drethereumUni v3 LP Bug
Updated 2022-12-01
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
›
⌄
-- SELECT
-- a.tx_hash,
-- f.liquidity_provider AS lp1,
-- a.liquidity_provider AS lp2
-- FROM ethereum.uniswapv3.ez_position_collected_fees f
-- INNER JOIN ethereum.uniswapv3.ez_lp_actions a ON f.tx_hash = a.tx_hash
-- WHERE a.tx_hash = '0x846dc363d7f43d388da1283c9d5e8a001ad6dea0018da6e334ded4ad0fa10779'
-- LIMIT 10
SELECT
tx_hash,
liquidity_provider,{{param_1}}
NF_POSITION_MANAGER_ADDRESS,
nf_token_id,
ORIGIN_FROM_ADDRESS,
contract_address
FROM ethereum.uniswapv3.ez_lp_actions a
INNER JOIN ethereum.core.fact_event_logs b USING(tx_hash)
WHERE tx_hash = '0x6cdaa3c05a92bbaf9499bb32de2d8534aed1256b7a510b65219e668833f0a26b'
--LIMIT 100
-- SELECT *
-- FROM ethereum.core.fact_event_logs
-- WHERE tx_hash = '0xe2e2917fcdf48cb2a170ca9b1ebaf7688ba1518efc968eb4f1df07f7c6b026b4'
-- WITH lp AS (
-- SELECT
-- tx_hash,
-- liquidity_provider
-- FROM ethereum.uniswapv3.ez_lp_actions
-- --WHERE tx_hash = '0x846dc363d7f43d388da1283c9d5e8a001ad6dea0018da6e334ded4ad0fa10779'
-- ),
-- fees AS (
Run a query to Download Data