Query editor
WITH pons_tokens AS (SELECT DISTINCTaddress AS token_addressFROM robinhood.creation_tracesWHERE "from" IN (0xa5aab3f0c6eeadf30ef1d3eb997108e976351feb,0x0c37a24f5d23a486fa692d1500881d698b1f77a4)AND block_time >= TIMESTAMP '2026-07-01'),pons_pools AS (SELECT DISTINCTvarbinary_substring(l.data, 45, 20) AS pool,varbinary_substring(l.topic1, 13, 20) AS token0FROM robinhood.logs lWHERE l.topic0 =0x783cca1c0412dd0d695e784568c96da2e9c22ff989357a2e8b1d9b2b4e6b7118AND l.block_date >= DATE '2026-07-01'AND ((varbinary_substring(l.topic1, 13, 20) =0x0bd7d308f8e1639fab988df18a8011f41eacad73AND varbinary_substring(l.topic2, 13, 20) IN (SELECT token_addressFROM pons_tokens))OR(varbinary_substring(l.topic2, 13, 20) =0x0bd7d308f8e1639fab988df18a8011f41eacad73AND varbinary_substring(l.topic1, 13, 20) IN (SELECT token_addressFROM pons_tokens)))),swaps AS (SELECTl.block_date,l.block_time,CASEWHEN p.token0 =0x0bd7d308f8e1639fab988df18a8011f41eacad73THEN CAST(varbinary_to_int256(varbinary_substring(l.data, 1, 32)) AS double)ELSE CAST(varbinary_to_int256(varbinary_substring(l.data, 33, 32)) AS double)END / 1e18 AS weth_deltaFROM robinhood.logs lJOIN pons_pools p