ioanUntitled Query
    Updated 2023-02-27
    SELECT TO_VARCHAR(date_trunc('day', HOUR), 'YYYY-MM-DD"T"HH24:MI:SS.FF3TZH') AS day
    , TOKEN_ADDRESS AS token
    , avg(PRICE) AS price
    FROM ethereum.core.fact_hourly_token_prices
    WHERE TOKEN_ADDRESS = lower('0x1a4b46696b2bb4794eb3d4c26f1c55f9170fa4c5')
    GROUP BY 1, 2
    Run a query to Download Data