drethereumUni v3 Position Fees Bug
Updated 2022-11-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
--withdrawal = 0x7fcf532c15f0a6db0bd6d0e038bea71d30d808c7d98cb3bf7268a95bf5081b65
--collect = 0x40d0efd1a53d60ecbf40971b9daf7dc90178c3aadc7aab1765632738fa8b8f01
--transfer = 0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef
--decrease liquidity = 0x26f6a048ee9138f2c0ce266f322cb99228e8d619ae2bff30c67f8dcf9d2377b4
--increase liquidity = 0x3067048beee31b25b2f1681f88dac838c8bba36af25bfb2b7cf7473a5847e35f
--burn = 0x0c396cd989a39f4459b5fa1aed6a9a8dcdbc45908acfd67e028cd568da98982c
--approval = 0x8c5be1e5ebec7d5bd14f71427d1e84f3dd0314c0f7b2291e5b200ac8c7c3b925
-- SELECT tx_hash, COUNT(*)
-- FROM ethereum.uniswapv3.ez_lp_actions
-- --WHERE TX_HASH = '0x035ad277b055ae0fcf697d50329b53255860b7a4d2478b10f4c34f68dcc68eb8'
-- WHERE block_timestamp::date >= '2022-11-27'
-- GROUP BY 1
-- HAVING COUNT(*) > 1
--ORDER BY BLOCK_NUMBER DESC
--LIMIT 5
-- SELECT *
-- FROM ethereum.uniswapv3.ez_position_collected_fees
-- WHERE TX_HASH = '0x035ad277b055ae0fcf697d50329b53255860b7a4d2478b10f4c34f68dcc68eb8'
-- WHERE block_timestamp::DATE = '2022-11-28'
-- ORDER BY block_timestamp DESC
-- LIMIT 25
-- SELECT * FROM ethereum.uniswapv3.ez_lp_actions
-- WHERE TX_HASH IN ('0x035ad277b055ae0fcf697d50329b53255860b7a4d2478b10f4c34f68dcc68eb8','0xb18c9ed64ed7784be689220e0cf891874470b5f9934af8b3e2c8d59b42da128e')
-- ORDER BY BLOCK_NUMBER DESC
-- SELECT *
-- FROM ethereum.uniswapv3.ez_position_collected_fees
-- WHERE TX_HASH IN ('0x035ad277b055ae0fcf697d50329b53255860b7a4d2478b10f4c34f68dcc68eb8','0xb18c9ed64ed7784be689220e0cf891874470b5f9934af8b3e2c8d59b42da128e'
SELECT
f.tx_hash,
f.amount0_adjusted - a.amount0_adjusted AS amt0,
Run a query to Download Data