xeejsgr478Untitled Query
Updated 2022-10-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
SELECT
date,
SUM(
CASE WHEN
balance_type = 'liquid'
THEN balance/POW(10, decimal)
ELSE 0
END
) AS liquid_volume,
coalesce(
SUM(
CASE WHEN
balance_type = 'staked'
THEN balance/POW(10, decimal)
ELSE 0
END
),1) AS staked_volume,
SUM(
CASE WHEN
balance_type = 'liquid'
THEN balance/POW(10,decimal)
ELSE 0
END
)/
SUM(
CASE WHEN
balance_type = 'staked'
THEN balance/POW(10,decimal)
ELSE 0
END
) AS liq_staked
FROM
osmosis.core.fact_daily_balances
WHERE
currency = 'uosmo'
AND
Run a query to Download Data