Query editor
-- Ekubo ve(3,3) "STONX" on Robinhood Chain-- Ve33 extension: 0xd18685a514e59b06d59824e16db07e73345d9953-- Ekubo Core: 0x00000000000014aa86c5d3c41765bb24e11bd701-- Core emits topic-less packed logs; swap log = 116 bytes:-- extension(20) | poolId(32) | delta0(int128) | delta1(int128) | sqrtRatio(12) | tick(int32) | liquidity(uint128)WITH tok AS (SELECT contract_address, symbol, decimalsFROM tokens.erc20WHERE blockchain = 'robinhood'),keys AS (SELECT DISTINCTfrom_hex(substr(json_extract_scalar(poolKey, '$.token0'), 3)) AS token0,from_hex(substr(json_extract_scalar(poolKey, '$.token1'), 3)) AS token1,from_hex(substr(json_extract_scalar(poolKey, '$.config'), 3)) AS configFROM stonx_robinhood.ve33_call_beforeinitializepool),pools AS (SELECTkeccak(concat(0x000000000000000000000000, token0, 0x000000000000000000000000, token1, config)) AS pool_id,token0, token1,coalesce(t0.decimals, 18) AS dec0,coalesce(t1.decimals, 18) AS dec1FROM keys kLEFT JOIN tok t0 ON t0.contract_address = k.token0LEFT JOIN tok t1 ON t1.contract_address = k.token1),swaps AS (SELECTl.block_time,l.block_date,substr(l.data, 21, 32) AS pool_id,cast(from_big_endian_64(substr(l.data, 53, 8)) AS double) * 18446744073709551616.0+ (CASE WHEN from_big_endian_64(substr(l.data, 61, 8)) >= 0THEN cast(from_big_endian_64(substr(l.data, 61, 8)) AS double)ELSE cast(from_big_endian_64(substr(l.data, 61, 8)) AS double) + 18446744073709551616.0 END) AS delta0,cast(from_big_endian_64(substr(l.data, 69, 8)) AS double) * 18446744073709551616.0+ (CASE WHEN from_big_endian_64(substr(l.data, 77, 8)) >= 0THEN cast(from_big_endian_64(substr(l.data, 77, 8)) AS double)ELSE cast(from_big_endian_64(substr(l.data, 77, 8)) AS double) + 18446744073709551616.0 END) AS delta1FROM robinhood.logs lWHERE l.contract_address = 0x00000000000014aa86c5d3c41765bb24e11bd701AND length(l.data) = 116AND l.block_date >= DATE '2026-07-30'),px AS (SELECT contract_address, date_trunc('hour', timestamp) AS h, avg(price) AS priceFROM prices.hourWHERE blockchain = 'robinhood' AND timestamp >= TIMESTAMP '2026-07-30'GROUP BY 1, 2),eth_px AS ( -- native ETH (0x0) priced off WETH on the same chainSELECT date_trunc('hour', timestamp) AS h, avg(price) AS priceFROM prices.hourWHERE blockchain = 'robinhood'AND contract_address = 0x0bd7d308f8e1639fab988df18a8011f41eacad73AND timestamp >= TIMESTAMP '2026-07-30'GROUP BY 1),priced AS (