Query editor
-- factory address: 0xfb8Ed3485EfA29a0e4bed93351dD51B59fC4b0f0-- PoolCreated: 0x91ccaa7a278130b65168c3a0c8d3bcae84cf5e43704342bd3ec0b59e59c036dbWITH pool_created AS (SELECT contract_address,topic0,CASE WHEN VARBINARY_LTRIM(topic1) = 0xc5dc95539589fbd24be07c6c14eca4 THEN 0x0000000000c5dc95539589fbd24be07c6c14eca4ELSE VARBINARY_LTRIM(topic1) END AS token0,VARBINARY_LTRIM(topic2) AS token1,VARBINARY_LTRIM(BYTEARRAY_SUBSTRING(data, 1, 32)) AS pool_address,get_href('https://etherscan.io/tx/' || CAST(tx_hash AS VARCHAR), CAST(tx_hash AS VARCHAR)) AS tx_hash,tx_from,tx_toFROM ethereum.logsWHERE 1=1AND contract_address = 0xfb8Ed3485EfA29a0e4bed93351dD51B59fC4b0f0AND topic0 = 0x91ccaa7a278130b65168c3a0c8d3bcae84cf5e43704342bd3ec0b59e59c036db),token_transafers AS ((SELECT p.pool_address,t.contract_address,t.evt_tx_hash AS tx_hash,t.evt_block_time,CASE WHEN t.contract_address = p.token0 THEN p.token0 END AS token0,CASE WHEN t.contract_address = p.token1 THEN p.token1 END AS token1,t."from",t."to",t."value"FROM erc20_hyperevm.evt_transfer tLEFT JOIN (SELECT pool_address,token0,token1FROM pool_created) p ON 1=1WHERE 1=1AND t."to" = p.pool_addressORDER BY t.evt_block_time DESC)UNION ALL(SELECT p.pool_address,t.contract_address,t.evt_tx_hash AS tx_hash,t.evt_block_time,CASE WHEN t.contract_address = p.token0 THEN p.token0 END AS token0,CASE WHEN t.contract_address = p.token1 THEN p.token1 END AS token1,t."from",t."to",-"value"FROM erc20_hyperevm.evt_transfer tLEFT JOIN (SELECT pool_address,token0,token1FROM pool_created) p ON 1=1WHERE 1=1AND t."from" = p.pool_addressORDER BY t.evt_block_time DESC)),pool_balances AS (SELECT pool_address,MAX(token0) AS token0,MAX(token1) AS token1,