--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;