select RECORDED_AT as date, PRICE

from osmosis.core.dim_prices

where symbol = 'OSMO' ),

maxdate as (select max(date) from df)

select round(price,2) as price from(

select PRICE from df

where date = (select * from maxdate))