mohamadreza221166daily average price
    Updated 2022-09-09
    WITH prices AS(
    SELECT HOUR::DATE AS days, SYMBOL, DECIMALS, avg(PRICE) AS avg_price
    FROM ethereum.core.fact_hourly_token_prices
    WHERE SYMBOL IN('rETH', 'aETH', 'stETH')
    -- AND IS_IMPUTED = TRUE
    GROUP BY 1,2,3
    )

    SELECT *
    FROM prices
    ORDER BY days
    Run a query to Download Data