DrsimonFrax and Osmosis - deposit and withdraw d1
Updated 2023-02-26
999
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
›
⌄
with Frax as
(
select
* ,
DECIMAL as ddd
from osmosis.core.dim_tokens
where
LABEL = 'Frax'
or PROJECT_NAME = 'FRAX'
or ADDRESS = 'ibc/0E43EDE2E2A3AFA36D0CD38BDDC0B49FECA64FA426A82E102F304E430ECF46EE'
) ,
price1 as (
SELECT
date_trunc('week', RECORDED_AT) as day1,
avg(price) as price
FROM osmosis.core.dim_prices
LEFT outer JOIN osmosis.core.dim_labels
ON PROJECT_NAME LIKE symbol
WHERE symbol LIKE 'OSMO'
GROUP BY 1
),
TAB1 AS (
SELECT
DATE_TRUNC('week', BLOCK_TIMESTAMP) AS DAY,
CASE WHEN not TO_CURRENCY LIKE 'uosmo' THEN TO_CURRENCY ELSE FROM_CURRENCY END AS token_address,
MEDIAN(CASE WHEN not TO_CURRENCY LIKE 'uosmo' THEN ((FROM_AMOUNT/POWER(10, FROM_DECIMAL)) * PRICE)/(TO_AMOUNT/POWER(10, TO_DECIMAL))
ELSE ((TO_AMOUNT/POWER(10, TO_DECIMAL)) * PRICE)/(FROM_AMOUNT/POWER(10, FROM_DECIMAL)) END) AS MEDIAN_PRICE,
AVG(CASE WHEN not TO_CURRENCY LIKE 'uosmo' THEN ((FROM_AMOUNT/POWER(10, FROM_DECIMAL)) * PRICE)/(TO_AMOUNT/POWER(10, TO_DECIMAL))
ELSE ((TO_AMOUNT/POWER(10, TO_DECIMAL)) * PRICE)/(FROM_AMOUNT/POWER(10, FROM_DECIMAL)) END) AS AVG_PRICE
FROM osmosis.core.fact_swaps
LEFT outer JOIN osmosis.core.dim_labels
Run a query to Download Data