Query editor
SELECT hooks AS hook,COUNT(DISTINCT id) AS pool_count,0 AS swaps_90d,MAX(evt_block_time) AS first_seenFROM uniswap_v4_unichain.PoolManager_evt_InitializeWHERE hooks <> 0x0000000000000000000000000000000000000000AND evt_block_time > now() - interval '90' dayGROUP BY 1ORDER BY first_seen DESCLIMIT 80