FlorentGUniV3 Burn
Updated 2023-08-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
SELECT
CONTRACT_ADDRESS as univ3_pool,
TOPICS[2] as tickLower,
TOPICS[3] as tickUpper,
data
FROM arbitrum.core.fact_event_logs
WHERE TOPICS[0] = '0x0c396cd989a39f4459b5fa1aed6a9a8dcdbc45908acfd67e028cd568da98982c' --burn liquidity
AND CONTRACT_ADDRESS = '0x7e7fb3cceca5f2ac952edf221fd2a9f62e411980' --MAGIC/wETH pool
AND TX_STATUS = 'SUCCESS'
-- LIMIT 10
SELECT *
FROM arbitrum.core.fact_transactions
WHERE Tx_HASH = '0xa2b0027acb909ddee2519c785c19b9ebbba2a24b4a925a3e16405903cc06f0af'
Run a query to Download Data