Baselight
Sign In 
1SELECT 
2    SPLIT_PART(name, '.', -1) as tld,
3    DATE_TRUNC('day', created_at) as listing_date,
4    COUNT(*) as new_listings
5FROM "@blt.doma_testnet_core.listings"
6WHERE created_at >= CURRENT_TIMESTAMP - INTERVAL '7 days'
7GROUP BY tld, listing_date
8ORDER BY listing_date DESC, new_listings DESC
tldlisting_datenew_listings
ai2025-10-13 00:00:00+0057
io2025-10-13 00:00:00+0034
com2025-10-13 00:00:00+0033
football2025-10-13 00:00:00+0020
ape2025-10-13 00:00:00+003
name2025-10-13 00:00:00+001
ai2025-10-12 00:00:00+0067
com2025-10-12 00:00:00+0036
io2025-10-12 00:00:00+0031
football2025-10-12 00:00:00+0024
ai2025-10-11 00:00:00+0039
io2025-10-11 00:00:00+0031
com2025-10-11 00:00:00+0028
football2025-10-11 00:00:00+0017
ai2025-10-10 00:00:00+0071
com2025-10-10 00:00:00+0040
io2025-10-10 00:00:00+0030
football2025-10-10 00:00:00+0030
ai2025-10-09 00:00:00+0081
com2025-10-09 00:00:00+0051
io2025-10-09 00:00:00+0043
football2025-10-09 00:00:00+0014
ape2025-10-09 00:00:00+003
ai2025-10-08 00:00:00+00553
io2025-10-08 00:00:00+0056
com2025-10-08 00:00:00+0050
football2025-10-08 00:00:00+0037
shib2025-10-08 00:00:00+0034
ape2025-10-08 00:00:00+0030
ai2025-10-07 00:00:00+001174
io2025-10-07 00:00:00+00178
com2025-10-07 00:00:00+00162
football2025-10-07 00:00:00+0046
ape2025-10-07 00:00:00+0011
shib2025-10-07 00:00:00+007
name2025-10-07 00:00:00+002
xyz2025-10-07 00:00:00+001
ai2025-10-06 00:00:00+00288
com2025-10-06 00:00:00+0021
io2025-10-06 00:00:00+005
football2025-10-06 00:00:00+001

Share link

Anyone who has the link will be able to view this.