-- forked from zackmendel / Solana Token Price @ https://flipsidecrypto.xyz/zackmendel/q/yaw-token-price-YuOF7s
SELECT
date_trunc(day, recorded_hour) AS timespan,
symbol,
avg (close) AS price
FROM solana.core.fact_token_prices_hourly
WHERE symbol IN ('SOL') --('FRKT', 'YAW')
AND recorded_hour::date > '2023-01-01'
GROUP BY 1,2
ORDER BY 1