AzinOsmosis LP volume
Updated 2022-10-12
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select
sum(case when action='pool_joined' then AMOUNT/1e6 else null end) as pool_joined,
sum(case when action='pool_exited' then AMOUNT/1e6 else null end) as pool_exited,
pool_joined-pool_exited as LP_balance,
date_trunc('day',BLOCK_TIMESTAMP) as date
from
osmosis.core.fact_liquidity_provider_actions
where
CURRENCY='uosmo'
and BLOCK_TIMESTAMP>CURRENT_DATE-30
group by date
Run a query to Download Data