Delamir-601401-price012-1
    Updated 2023-02-02
    select
    date_trunc(week,HOUR) as date,
    case when date >= CURRENT_DATE-60 then 'Last 2 months' else 'Other days' end as timespan,
    avg(price) as Price_MATIC,
    avg(Price_MATIC) over (order by date rows between 8 preceding and current row) as MA_9,
    avg(Price_MATIC) over (order by date rows between 25 preceding and current row) as MA_26
    from ethereum.core.fact_hourly_token_prices
    where symbol = 'MATIC'
    group by 1

    Run a query to Download Data