Query editor
-- factory address: 0xFf7B3e8C00e57ea31477c32A5B52a58Eea47b072-- PoolCreated: 0x783cca1c0412dd0d695e784568c96da2e9c22ff989357a2e8b1d9b2b4e6b7118WITH pool_created AS (SELECT contract_address,topic0,CASE WHEN VARBINARY_LTRIM(topic1) = 0x780555bd0bca3791f89f9542c2d6 THEN 0x000000000000780555bD0BCA3791f89f9542c2d6ELSE VARBINARY_LTRIM(topic1) END AS token0,CASE WHEN VARBINARY_LTRIM(topic2) = 0x780555bd0bca3791f89f9542c2d6 THEN 0x000000000000780555bD0BCA3791f89f9542c2d6ELSE VARBINARY_LTRIM(topic2) END AS token1,VARBINARY_TO_UINT256(topic3) AS pool_fee,VARBINARY_LTRIM(BYTEARRAY_SUBSTRING(data, 33, 32)) AS pool_address,get_href('https://hyperevmscan.io/tx/' || CAST(tx_hash AS VARCHAR), CAST(tx_hash AS VARCHAR)) AS tx_hash,tx_from,tx_toFROM hyperevm.logsWHERE 1=1AND contract_address = 0xFf7B3e8C00e57ea31477c32A5B52a58Eea47b072AND topic0 = 0x783cca1c0412dd0d695e784568c96da2e9c22ff989357a2e8b1d9b2b4e6b7118),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,