0-MID2023-06-13 05:56 AM
Updated 2023-07-14
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select date_trunc('month',BLOCK_TIMESTAMP) as month
,sum(AMOUNT/pow(10,DECIMAL)) as volume
,count(distinct LIQUIDITY_PROVIDER_ADDRESS) as lpers
,count(distinct TX_ID) as lpes
,sum(volume)over(order by month) as "Lp volume growth"
,sum(lpers)over(order by month) as "Lper growth"
,sum(lpes)over(order by month) as "Lp growth"
from osmosis.core.fact_liquidity_provider_actions
where CURRENCY='uosmo'
group by 1
Run a query to Download Data