with price as (select date_trunc('day',HOUR) as date
, avg(PRICE) as Price
from bsc.price.fact_hourly_token_prices
where TOKEN_ADDRESS = '0xba2ae424d960c26247dd6c32edc70b295c744c43'
and date >= '2024-01-01'
group by 1)
select date
, Price
, (Price*143914556384) as Market_cap
from price