Query editor
SELECTevt_block_time AS tx_time,evt_tx_hash AS tx_hash,'Deposit' AS action,(CAST(amount0 AS DOUBLE)/1e18) AS ipor_liq,(CAST(amount1 AS DOUBLE)/1e18) AS eth_liq,tickUpper AS tick_upper,tickLower AS tick_lower,owner AS ownerFROM uniswap_v3_ethereum.Pair_evt_MintWHERE evt_block_time >= CAST('2023-01-01' AS TIMESTAMP)AND contract_address = 0xea7d10e9b963e28a2a59429f44cd7922482000b7AND (CAST(amount1 AS DOUBLE)/1e18) = 0AND evt_tx_hash in (0xf8a11cef9bafa856342f9bf08735ed22338bdffc6ee57626166cf8022b0d82d0, 0x2c3c19b33c31fc8699c2a1edfb17dda3b66195b3035ebb6418cbf8b3795be4d9)UNIONSELECTevt_block_time AS tx_time,evt_tx_hash AS tx_hash,'Withdraw' AS action,(CAST(amount0 AS DOUBLE)/1e18) AS ipor_liq,(CAST(amount1 AS DOUBLE)/1e18) AS eth_liq,tickUpper AS tick_upper,tickLower AS tick_lower,owner AS ownerFROM uniswap_v3_ethereum.Pair_evt_BurnWHERE evt_block_time >= CAST('2023-01-01' AS TIMESTAMP)AND contract_address = 0xea7d10e9b963e28a2a59429f44cd7922482000b7AND evt_tx_hash in (0x0ae856ba443f5408c376635006fba2768284f08f04ff81c54152a100a7adc02f, 0xcdb6278d3456979612c694119e5d23a43abcc7126e09254226936773075c6911)ORDER BY tx_time DESC