Query editor
WITHsettings AS (SELECTTIMESTAMP '2026-07-19 00:00:00' AS start_time,0x0bd7d308f8e1639fab988df18a8011f41eacad73 AS weth,0xa5aab3f0c6eeadf30ef1d3eb997108e976351feb AS active_factory,0x0c37a24f5d23a486fa692d1500881d698b1f77a4 AS legacy_factory,0x1f7d7550b1b028f7571e69a784071f0205fd2efa AS uniswap_v3_factory,0xda4bcee76b29efec9697fcf663601c2042043968 AS fee_collector),pons_tokens AS (SELECT DISTINCTct.address AS token_address,ct."from" AS factory_addressFROM robinhood.creation_traces ctCROSS JOIN settings sWHERE ct."from" IN (s.active_factory, s.legacy_factory)AND ct.block_time >= s.start_time),pool_created_events AS (SELECTvarbinary_substring(l.topic1, 13, 20) AS token0,varbinary_substring(l.topic2, 13, 20) AS token1,varbinary_substring(l.data, 45, 20) AS poolFROM robinhood.logs lCROSS JOIN settings sWHERE l.contract_address = s.uniswap_v3_factoryAND l.topic0 =0x783cca1c0412dd0d695e784568c96da2e9c22ff989357a2e8b1d9b2b4e6b7118AND l.block_time >= s.start_time),pons_pools AS (SELECT DISTINCTpe.pool,pe.token0,pe.token1,pt.token_address,pt.factory_addressFROM pool_created_events peCROSS JOIN settings sJOIN pons_tokens ptON pt.token_address =CASEWHEN pe.token0 = s.weth THEN pe.token1WHEN pe.token1 = s.weth THEN pe.token0ENDWHERE pe.token0 = s.wethOR pe.token1 = s.weth),swaps AS (SELECTl.block_time,p.token_address,p.factory_address,CASE