Query editor
{{unnamed_parameter}}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 (selectvarbinary_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 (selecttoken_addressfrom pons_tokens))or (varbinary_substring (l.topic2, 13, 20) = 0x0bd7d308f8e1639fab988df18a8011f41eacad73and varbinary_substring (l.topic1, 13, 20) in (selecttoken_addressfrom pons_tokens)))), swaps as (selectl.block_time, casewhen p.token0 = 0x0bd7d308f8e1639fab988df18a8011f41eacad73then CAST(varbinary_to_int256 (varbinary_substring (l.data, 1, 32)) as double)elseCAST(varbinary_to_int256 (varbinary_substring (l.data, 33, 32)) as double)end / 1e18 as weth_deltafrom robinhood.logs linner join pons_pools p on p.pool = l.contract_addresswhere l.topic0 = 0xc42079f94a6350d7e6235f29174924f928cc2ac818eb64fed8004e115fbcca67and l.block_date = CURRENT_DATE), fee_accrual as (selectDATE_TRUNC('hour', s.block_time) as hour, SUM(case