cnallenzhaoTest data with Dune
Updated 2022-11-14
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
›
⌄
-- WITH as (SELECT * FROM ethereum.uniswapv3.ez_lp_actions
-- WHERE ACTION = 'DECREASE_LIQUIDITY' AND (NF_POSITION_MANAGER_ADDRESS IS NULL OR NF_TOKEN_ID IS NULL)
-- AND POOL_ADDRESS IN (
-- '0x88e6a0c2ddd26feeb64f039a2c41296fcb3f5640',
-- '0x8ad599c3a0ff1de082011efddc58f1908eb6e6d8'
-- )
-- AND tx_hash = '0xcd7dae143a4c0223349c16237ce4cd7696b1638d116a72755231ede872ab70fc'
-- )
WITH lp as (SELECT * FROM ethereum.uniswapv3.ez_lp_actions
WHERE --ACTION = 'DECREASE_LIQUIDITY' AND (NF_POSITION_MANAGER_ADDRESS IS NULL OR NF_TOKEN_ID IS NULL) AND
POOL_ADDRESS IN ( '0x88e6a0c2ddd26feeb64f039a2c41296fcb3f5640')
AND LIQUIDITY_PROVIDER = '0xf5f30eaf55fd9ffc70651b13b791410aad663846')
SELECT lp.*, t.tx_fee, t.from_address, t.to_address
FROM lp
LEFT JOIN ethereum.core.fact_transactions t
ON lp.tx_hash = t.tx_hash
-- SELECT DISTINCT(a.liquidity_provider) FROM ethereum.uniswapv3.ez_lp_actions a
-- where a.liquidity_provider != '0xc36442b4a4522e871399cd717abdd847ab11fe88'
-- AND a.block_timestamp <= '2022-11-01'
-- AND a.POOL_ADDRESS IN ('0x8ad599c3a0ff1de082011efddc58f1908eb6e6d8')
-- This LP has some issues!
-- SELECT COUNT(*) FROM ethereum.uniswapv3.ez_lp_actions
-- WHERE LIQUIDITY_PROVIDER = '0xf5f30eaf55fd9ffc70651b13b791410aad663846' AND pool_address = '0x88e6a0c2ddd26feeb64f039a2c41296fcb3f5640'
Run a query to Download Data