nitsCurrent Pool Stats
Updated 2022-12-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with enter as
(SELECT currency, sum(amount/pow(10,decimal)) as amt_joined from osmosis.core.fact_liquidity_provider_actions a
where pool_id [0] = '773'
and tx_status = 'SUCCEEDED' and action = 'pool_joined'
GROUP by 1 ),
exit_ as
(SELECT currency as c , sum(amount/pow(10,decimal)) as amt_exit from osmosis.core.fact_liquidity_provider_actions a
where pool_id [0] = '773'
and tx_status = 'SUCCEEDED' and action = 'pool_exited'
GROUP by 1 )
SELECT *, amt_joined - amt_exit as net_amount , case when c = 'uosmo' then net_amount*1.5 else net_amount*5.3 end as net_val,
case when c = 'uosmo' then 'Osmo' else 'DOT' end as name,
case when c = 'uosmo' then amt_joined*1.5 else amt_joined*5.3 end as net_val_joined,
case when c = 'uosmo' then amt_exit*1.5 else amt_exit*5.3 end as net_val_exit
from
(SELECT * from enter join exit_
on c = currency)
LIMIT 199
Run a query to Download Data