maytsu2023-11-08 prices across oracles & LPs
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
›
⌄
avalanche.defi.ez_dex_swaps
WITH UST_PEG AS (
SELECT
DATE_TRUNC('hour', block_timestamp) as date,
avg(price_usd) as UST_TERRA
-- ABS(1.0 - UST_TERRA) AS UST_PEG_DEVIATION
FROM terra.classic.dim_oracle_prices
WHERE symbol = 'UST'
--AND block_timestamp > {{date}}
--AND CURRENT_DATE - block_date < 90
GROUP BY 1
ORDER BY 1 DESC
),
Luna_terra AS (
SELECT
DATE_TRUNC('hour', block_timestamp) as Ldate,
avg(price_usd) as Luna_terra
-- ABS(1.0 - UST_TERRA) AS UST_PEG_DEVIATION
FROM terra.classic.dim_oracle_prices
WHERE symbol = 'LUNA'
--AND block_timestamp > {{date}}
--AND CURRENT_DATE - block_date < 90
GROUP BY 1
ORDER BY 1 DESC
),
THORCHAIN_LUNA AS (
select
date_trunc('hour', block_timestamp) as time,
avg(ASSET_USD) as Luna_thorchain
from thorchain.price.fact_prices
where
Run a query to Download Data