Query editor
-- profile of top uni takers missing/underweight on fluid: venue mix across ALL eth usdc-usdt venues, 2026-08-29..2026-09-27select tx_to, project, sum(amount_usd) as usd, count(*) as fills, approx_percentile(amount_usd, 0.5) as median_fill,count(distinct tx_from) as eoasfrom dex.tradeswhere blockchain='ethereum'and block_time >= timestamp '2026-08-29' and block_time < timestamp '2026-09-28'and token_bought_address in (0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48, 0xdac17f958d2ee523a2206206994597c13d831ec7)and token_sold_address in (0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48, 0xdac17f958d2ee523a2206206994597c13d831ec7)and token_bought_address <> token_sold_addressand tx_to in (0x000000000035b5e5ad9019092c665357240f594e, 0x4c82d1fbfe28c977cbb58d8c7ff8fcf9f70a2cca, 0x23617e59a5925b2a4bf75d73ff6711cd0b29de85,0x03f34be1bf910116595db1b11e9d1b2ca5d59659, 0x66a9893cc07d91d95644aedd05d03f95e1dba8af, 0xc623b0b546bf3031ba88a583a46d5180df8d67c2,0x68b3465833fb72a70ecdf485e0e4c7bd8665fc45, 0x9205a569b0ff45df1e4f5ae48e21bc7f0656f0bb, 0x07964f135f276412b3182a3b2407b8dd45000000)group by 1,2 order by 1, usd desc