with proposals as(
select last_day(block_timestamp,'week') as week, count(proposal_id) as number
from terra.gov_submit_proposal
group by last_day(block_timestamp,'week')
),
luna_prices as(
select *
from terra.oracle_prices
where currency = 'uluna'
),
luna_daily as(
select date(block_timestamp) as date, avg(price_usd) as price
from luna_prices
group by date(block_timestamp)
),
luna_daily_std_dev as(
select date, stddev(price) over (
order by date
rows between 7 preceding and current row
) as stddev_7
from luna_daily
)
select * from luna_daily_std_dev l
left join proposals p on l.date = p.week
where l.date > date_from_parts(2020,09,30)
-- select * from terra.oracle_prices
-- limit 100