select recorded_hour::date as date
, close as price
from solana.price.fact_token_prices_hourly
where recorded_hour >= '2024-01-29'
and symbol = 'JUP'
and id = '29210'
qualify(
row_number() over (partition by recorded_hour::date order by recorded_hour desc) = 1
)