mrwildcatmeme: prices pepe
    Updated 2023-05-16
    --ethereum.core.fact_hourly_token_prices
    SELECT DATE_TRUNC('day', hour) AS day,
    avg(price) as price, --* 420690000000000,
    avg(price) * 420690000000000 as mkt_cap
    --*
    FROM ethereum.core.fact_hourly_token_prices
    WHERE token_address = '0x6982508145454ce325ddbe47a25d4ec3d2311933'
    GROUP BY day
    ORDER BY DAY DESC;
    Run a query to Download Data