boomer77luna stddev
Updated 2021-08-03
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
with luna as
(SELECT
date_trunc('day',block_timestamp) as days, avg(event_amount) as amt, avg(event_amount_usd) as usd, usd/amt as LUNA_price
from terra.transfers
where event_currency = 'LUNA'
group by 1)
select
days, stddev(luna_price)
from luna
group by 1
Run a query to Download Data