niloCopy of Untitled Query
Updated 2022-09-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
select
sum(amount/1e6) as Volume,
count(distinct TX_ID) as TXN,
count(distinct LIQUIDITY_PROVIDER_ADDRESS) as LPrs,
case
when ACTION = 'pool_joined' then 'Deposit'
when ACTION = 'pool_exited' then 'Withdraw' end as Type,
avg(amount/1e6) as avgVolume, min(amount/1e6) as minVolume, max(amount/1e6) as maxVolume, median(amount/1e6) as medianVolume,
Volume/TXN as VolumePerTxn, Volume/LPrs as VolumePerUser
from osmosis.core.fact_liquidity_provider_actions
where POOL_ID = 812 and CURRENCY = 'ibc/903A61A498756EA560B85A85132D3AEE21B5DEDD41213725D22ABF276EA6945E'
and TX_STATUS = 'SUCCEEDED'
group by Type
Run a query to Download Data