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