Query editor
-- uniswap v4 usdc-usdt pool ids by volume (+ the 0x35b5e5 bot share), 2026-08-29..2026-09-27select s.id as pool_id, p.fee, p.hooks,sum(abs(s.amount0))/1e6 as usdc_leg_usd, count(*) as swaps,sum(case when tx."to" = 0x000000000035b5e5ad9019092c665357240f594e then abs(s.amount0) else 0 end)/1e6 as bot_usdfrom uniswap_v4_ethereum.poolmanager_evt_swap sjoin uniswap_v4_ethereum.poolmanager_evt_initialize p on p.id = s.idjoin ethereum.transactions tx on tx.hash = s.evt_tx_hash and tx.block_number = s.evt_block_numberwhere s.evt_block_time >= timestamp '2026-08-29' and s.evt_block_time < timestamp '2026-09-28'and tx.block_time >= timestamp '2026-08-29' and tx.block_time < timestamp '2026-09-28'and p.currency0 = 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 and p.currency1 = 0xdac17f958d2ee523a2206206994597c13d831ec7group by 1,2,3 order by usdc_leg_usd desc limit 10