Moebeefy prc copy
    Updated 2023-09-02
    select
    HOUR::date date,
    avg(PRICE) as token_price,
    avg(token_price)over( order by date rows between 6 preceding and current row) as Mov_avg7,
    avg(token_price)over( order by date rows between 29 preceding and current row) as Mov_avg30
    from
    avalanche.core.fact_hourly_token_prices
    where
    TOKEN_ADDRESS ilike '0xb279f8dd152b99ec1d84a489d32c35bc0c7f5674'
    and
    hour between '2023-01-01' and current_date
    group by 1



    Run a query to Download Data