Nige7777test
Updated 2021-05-24
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
›
⌄
select
t.gas_used
,t.fee_usd
,a.*
from uniswapv3.lp_actions a
left join ethereum.transactions t on t.tx_id = a.tx_id
where liquidity_provider = '0x26c462ecb097105fbbbe5d9203c940d75f72bc87'
order by block_timestamp
-----select * from uniswapv3.pool_stats
--where block_timestamp >= '2021-05-17T00:00:00Z' and block_timestamp <= '2021-05-17T01:00:00Z'
--and pool_name like 'UNI_WETH%'
-- select last_value (p.liquidity_adjusted) over (partition by p.pool_address, p.nf_token_id, p.liquidity_provider order by p.liquidity_provider ) as lv_liquidity
-- from uniswapv3.positions p
-- --inner join uniswapv3.position_collected_fees f on f.tx_id = p.tx_id
-- --left join ethereum.token_prices_hourly e on e.hour = date_trunc('hour', p.block_timestamp) and e.symbol = 'ETH'
-- where
-- p.pool_name like 'UNI_WETH%' --'USDC_WETH%'
-- and price_upper_0_1_USD > 37000
-- and p.block_timestamp >= '2021-05-11T15:00:00Z'
Run a query to Download Data