theericstonePosition Changes by Day
Updated 2023-03-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
SELECT
date_trunc('day',lpa.block_timestamp) as date,
--pool_address,
--pool_name,
--count(distinct liquidity_provider) as providers,
sum(fee_usd) as fees_paid,
count(distinct lpa.tx_id) as n_changes -- position changes
FROM uniswapv3.lp_actions lpa
join ethereum.transactions etx
on etx.tx_id = lpa.tx_id
WHERE lpa.block_timestamp >= getdate() - interval '14 days'
and etx.block_timestamp >= getdate() - interval '14 days'
GROUP BY 1
--pool_address, pool_name
--HAVING providers > 9
ORDER BY 1 desc;
Run a query to Download Data