mz0111osmo dash 2
Updated 2022-10-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
⌄
--credit to l4dyros4
select
DATE,
/*COUNT ( DISTINCT ADDRESS) AS USERS,
SUM (BALANCE/pow(10,DECIMAL)) AS VOLUME,
AVG (BALANCE/pow(10,DECIMAL)) AS AVG_VOLUME,*/
SUM (CASE WHEN BALANCE_TYPE = 'liquid' THEN BALANCE/pow(10,DECIMAL) END) AS LIQUID_VOLUME,
SUM (CASE WHEN BALANCE_TYPE = 'staked' THEN BALANCE/pow(10,DECIMAL) END) AS STAKED_VOLUME,
LIQUID_VOLUME / STAKED_VOLUME AS RATIO,
SUM (LIQUID_VOLUME) over (order by Date) as CUM_LIQUID,
SUM (STAKED_VOLUME) over (order by Date) as CUM_STAKED
FROM osmosis.core.fact_daily_balances
WHERE CURRENCY = 'uosmo'
AND BALANCE_TYPE IN ('liquid','staked')
AND DATE >= '2022-01-01'
GROUP BY 1
Run a query to Download Data