Tobi_12024-06-07 06:33 AM
    Updated 2024-06-07
    SELECT
    TOKEN_ADDRESS,
    SYMBOL,
    NAME,
    BLOCKCHAIN,
    AVG(PRICE) AS average_price
    FROM
    solana.price.ez_prices_hourly;
    WHERE
    BLOCKCHAIN = 'Solana'
    GROUP BY
    TOKEN_ADDRESS,
    SYMBOL,
    NAME,
    BLOCKCHAIN
    ORDER BY
    average_price DESC;

    QueryRunArchived: QueryRun has been archived