0xHaM-dSolana Price
    Updated 2022-11-28
    SELECT
    RECORDED_HOUR::date as date,
    CASE
    WHEN RECORDED_HOUR >= '2022-11-07' THEN 'Post FTX Demise' ELSE 'Pre FTX Demise'
    END as period,
    avg(CLOSE) as "Token Price",
    avg("Token Price") over (order by date rows between 7 PRECEDING and current row) as "MA 7-day Token",
    avg("Token Price") over (order by date rows between 100 PRECEDING and current row) as "MA 100-day Token",
    avg("Token Price") over (order by date rows between 200 PRECEDING and current row) as "MA 200-day Token"
    from solana.core.fact_token_prices_hourly
    where SYMBOL = 'SOL'
    and IMPUTED = FALSE
    AND RECORDED_HOUR >= '2022-10-01'
    AND RECORDED_HOUR <= CURRENT_DATE - 1
    GROUP by 1,2
    ORDER by 1
    Run a query to Download Data