glass_blossomsMine 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
›
⌄
WITH prices AS
(select date_trunc('day',block_timestamp) as Date,
symbol,
round(avg(price_usd),2) AS avg,
round(min(price_usd),2) AS low,
round(max(price_usd),2) AS high,
round(stddev(price_usd),2) AS stdDev
from terra.oracle_prices
where symbol = 'MINE'
and block_timestamp > getdate() - interval'90 days'
group by 1,2)
select *,
round((avg+stdDev),2) AS highStdDev,
round((avg-stdDev),2) AS lowStdDev,
round((avg-low),2) AS lowDiff,
round((high-avg),2) AS highDiff
from prices
order by 1
Run a query to Download Data