with price as (select date_trunc('day',RECORDED_HOUR) as date
, avg(CLOSE) as Price
from solana.price.fact_token_prices_hourly
where SYMBOL = 'WIF'
and date >= '2024-01-01'
group by 1)
select date
, Price as Price
, (Price*998906176.90) as Market_cap
from price