Query editor
-- WHYPE/USDT0 contract: 0xbd19e19e4b70eb7f248695a42208bc1edbbfb57d-- USDT0: 0xB8CE59FC3717ada4C02eaDF9682A9e934F625ebb-- WHYPE: 0x5555555555555555555555555555555555555555-- PRJX-V3-POS: 0xeaD19AE861c29bBb2101E834922B2FEee69B9091-- Pool add/remove transactionsWITH position_actions AS (SELECT block_time,block_number,tx_hash,contract_address,POW(1.0001,((BYTEARRAY_TO_INT256(topic2))/ 2)) AS lower_tick,POW(1.0001,((BYTEARRAY_TO_INT256(topic3))/ 2)) AS upper_tick,CASE WHEN topic0 = 0x7a53080ba414158be7ec69b987b5fb7d07dee101fe85488f0853ae16239d0bde -- MintTHEN VARBINARY_TO_UINT256(BYTEARRAY_SUBSTRING(data, 33, 32))WHEN topic0 = 0x0c396cd989a39f4459b5fa1aed6a9a8dcdbc45908acfd67e028cd568da98982c -- BurnTHEN -(VARBINARY_TO_UINT256(BYTEARRAY_SUBSTRING(data, 1, 32)))END AS liquidity_change,tx_from,tx_to,ROW_NUMBER() OVER (PARTITION BY tx_hash ORDER BY block_time DESC) AS rnFROM hyperevm.logsWHERE 1=1AND topic0 IN (0x7a53080ba414158be7ec69b987b5fb7d07dee101fe85488f0853ae16239d0bde, 0x0c396cd989a39f4459b5fa1aed6a9a8dcdbc45908acfd67e028cd568da98982c) -- Mint & BurnAND contract_address = 0xbd19e19e4b70eb7f248695a42208bc1edbbfb57d -- poolAND (CASE WHEN topic0 = 0x7a53080ba414158be7ec69b987b5fb7d07dee101fe85488f0853ae16239d0bde -- MintTHEN VARBINARY_TO_UINT256(BYTEARRAY_SUBSTRING(data, 33, 32))WHEN topic0 = 0x0c396cd989a39f4459b5fa1aed6a9a8dcdbc45908acfd67e028cd568da98982c -- BurnTHEN -(VARBINARY_TO_UINT256(BYTEARRAY_SUBSTRING(data, 1, 32)))END) != 0ORDER BY block_time DESC),-- Position NFT Mint/Burn/Transfer Transactionsposition_mints AS(SELECT block_time,contract_address,CASE WHEN VARBINARY_LTRIM(topic1) = 0xTHEN 'Mint'WHEN VARBINARY_LTRIM(topic2) = 0xTHEN 'Burn'ELSE 'Transfer'END AS tx_action,CASE WHEN VARBINARY_LTRIM(topic1) = 0xTHEN 0x0000000000000000000000000000000000000000ELSE VARBINARY_LTRIM(topic1) END AS sender,CASE WHEN VARBINARY_LTRIM(topic2) = 0xTHEN 0x0000000000000000000000000000000000000000ELSE VARBINARY_LTRIM(topic2) END AS receiver,VARBINARY_TO_UINT256(topic3) AS token_id,data,tx_hash,tx_from,tx_to,tx_indexFROM hyperevm.logsWHERE 1=1AND contract_address = 0xead19ae861c29bbb2101e834922b2feee69b9091 -- Position AddressAND topic0 = 0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef -- Position Mint/Burn transfersORDER BY token_id DESC),