1SELECT 
2    COUNT(DISTINCT l.name) as liquid_domains,
3    AVG(l.price_adj) as avg_ask,
4    AVG(o.price_adj) as avg_bid,
5    AVG(l.price_adj - o.price_adj) as avg_spread
6FROM "@blt.doma_testnet_core.listings" l
7INNER JOIN "@blt.doma_testnet_core.offers" o ON l.name = o.name
8WHERE l.expires_at > CURRENT_TIMESTAMP 
9    AND o.expires_at > CURRENT_TIMESTAMP
10    AND l.currency_symbol = o.currency_symbol