maybeyonasGovernance - Price Volatility - Proposals Correlation
    Updated 2021-08-25
    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
    Run a query to Download Data