MLDZMNFBBA1
    Updated 2023-04-28
    select
    HOUR::date date,
    avg(PRICE) avg_price,
    max(PRICE) max_price,
    min(PRICE) min_price,
    avg(avg_price)over(order by date rows between 7 preceding and current row) as "7 days mov avg"
    from ethereum.core.fact_hourly_token_prices
    where TOKEN_ADDRESS ilike '0x5283D291DBCF85356A21bA090E6db59121208b44'
    and HOUR::date > CURRENT_DATE - 45
    group by 1
    Run a query to Download Data