Updated 2023-05-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select
date_trunc('Day', BLOCK_TIMESTAMP)::DATE AS Day,
case
when ACTION = 'DECREASE_LIQUIDITY' then 'Decrease'
else 'Increase'
end AS Action,
count(DISTINCT LIQUIDITY_PROVIDER) AS "Liquidity providers Number",
count(*) AS "Events Number",
sum(AMOUNT0_USD + AMOUNT1_USD) AS "Amount (USD)"
from ethereum.uniswapv3.ez_lp_actions
where
BLOCK_TIMESTAMP >= dateadd('Day', - {{Last_N_days}}, current_date)
and POOL_ADDRESS = '0x3416cf6c708da44db2624d63ea0aaef7113527c6'
group by 1,2
Run a query to Download Data