saber-jlcro price
Updated 2022-10-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with cor as (
SELECT
date_trunc('day',BLOCK_TIMESTAMP) as date,
avg(FROM_AMOUNT) as "avg cor amount"
FROM osmosis.core.fact_swaps
WHERE FROM_CURRENCY = 'ibc/E6931F78057F7CC5DA0FD6CEF82FF39373A6E0452BF1FD76910B93292CF356C1'
AND date >=current_date - 30
group by 1),
USDC AS (
SELECT
date_trunc('day',BLOCK_TIMESTAMP) as date,
avg(FROM_AMOUNT) as "avg usdc amount"
FROM osmosis.core.fact_swaps
WHERE FROM_CURRENCY = 'ibc/D189335C6E4A68B513C10AB227BF1C1D38C746766278BA3EEB4FB14124F1D858'
AND date >=current_date - 30
group by 1
)
SELECT
date,
avg("avg usdc amount"/"avg cor amount") as "cor price"
FROM cor join usdc using (date)
group by 1
Run a query to Download Data