select date_trunc('day',BLOCK_TIMESTAMP ) as DATE,

round(avg((replace(FEE, 'uosmo'))/(GAS_USED)),3) as gas_price

from osmosis.core.fact_transactions

where fee like '%uosmo%'

group by 1

),

maxdate as (

select max(date) from df

select gas_price from df

where date = (select * from maxdate)