Nige7777best positions for fees
Updated 2021-11-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with cte_pools as (
select
sum(token1_balance_usd + token0_balance_usd) as pool_balance
, pool_name
,pool_address
from uniswapv3.pool_stats
where token1_balance_usd + token0_balance_usd > 0
group by pool_name,pool_address
order by pool_balance desc
limit 5
)
select
action
, date_trunc('day',block_timestamp) as date
, count(*),
pool_name
from
uniswapv3.lp_actions
where pool_address in (select pool_address from cte_pools)
and pool_name like 'USDC_WETH%'
group by pool_name , action , date
Run a query to Download Data