princefarzamMINE volatility
Updated 2022-02-10
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
›
⌄
With MAX_MINE_PRICE AS (
SELECT
date_trunc('day', block_timestamp) AS day,
max(price_usd) AS MAX_PRICE_OF_MINE
from terra.oracle_prices
where symbol= 'MINE'
and day::DATE >= CURRENT_DATE -INTERVAL'90 days'
GROUP BY 1
ORDER BY 1
),MIN_MINE_PRICE AS (
SELECT
date_trunc('day', block_timestamp) AS day,
min(price_usd) AS MIN_PRICE_OF_MINE
from terra.oracle_prices
where symbol= 'MINE'
and day::DATE >= CURRENT_DATE -INTERVAL'90 days'
GROUP BY 1
ORDER BY 1
)
SELECT
MX.day,
MX.MAX_PRICE_OF_MINE,
MN.MIN_PRICE_OF_MINE,
MX.MAX_PRICE_OF_MINE - MN.MIN_PRICE_OF_MINE AS volatility
FROM MAX_MINE_PRICE MX INNER JOIN MIN_MINE_PRICE MN ON MX.day=MN.day
Run a query to Download Data