1SELECT 
2    orderbook,
3    COUNT(*) as listing_count,
4    AVG(price_adj) as avg_price,
5    MIN(price_adj) as floor_price,
6    COUNT(DISTINCT name) as unique_domains
7FROM "@blt.doma_testnet_core.listings"
8WHERE expires_at > CURRENT_TIMESTAMP
9GROUP BY orderbook
10ORDER BY listing_count DESC