Sbhn_NPOSMO TOATL STATS
Updated 2022-09-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
--credit : betoo
with osmo as(select
count(distinct tx_id) as transactions,
count(distinct LIQUIDITY_PROVIDER_ADDRESS) as users,
sum(amount) as volume
from osmosis.core.fact_liquidity_provider_actions
where action like 'pool_joined'
and pool_id like '812'
and TX_STATUS = 'SUCCEEDED'
and currency like 'uosmo'),
axl as (select
count(distinct tx_id) as transactions,
count(distinct LIQUIDITY_PROVIDER_ADDRESS) as users,
sum(amount) as volume
from osmosis.core.fact_liquidity_provider_actions
where action like 'pool_joined'
and pool_id like '812'
and TX_STATUS = 'SUCCEEDED'
and currency like 'ibc/903A61A498756EA560B85A85132D3AEE21B5DEDD41213725D22ABF276EA6945E')
select * from osmo
Run a query to Download Data