feyikemi$GHST Price
    Updated 2024-09-20
    SELECT
    DATE_TRUNC('day', HOUR) AS Date,
    AVG(price) AS price
    FROM
    polygon.price.ez_prices_hourly
    WHERE
    1 = 1
    AND token_address = '0x385eeac5cb85a38a9a07a70c73e0a3271cfb54a7' -- $GHST Contract Address
    AND date >= '2024-01-01'
    GROUP BY
    Date
    ORDER BY
    Date DESC;
    QueryRunArchived: QueryRun has been archived