select RECORDED_AT as block_timestamp, TOTAL_SUPPLY

from osmosis.core.dim_prices

where symbol = 'OSMO' )

select date_trunc('day', block_timestamp) as date, round(avg(TOTAL_SUPPLY),2) as circsuppl

from df group by 1