gigiokobaAverage Price for July 22, 2024
    Updated 2024-08-04
    SELECT
    DATE_TRUNC('day', hour) AS recorded_day,
    AVG(price) AS avg_Boden_Price
    FROM solana.price.ez_prices_hourly
    WHERE TOKEN_ADDRESS = '3psH1Mj1f7yUfaD5gh6Zj7epE8hhrMkMETgv5TshQA4o'
    AND DATE(hour) = '2024-07-22'
    GROUP BY recorded_day;

    QueryRunArchived: QueryRun has been archived