price_usd as current_price

from near.core.fact_prices

where token = 'Wrapped NEAR fungible token'

and timestamp = (select max(timestamp) from near.core.fact_prices where token = 'Wrapped NEAR fungible token')),

ath as (select

max(price_usd)as all_time_high

from near.core.fact_prices

where token = 'Wrapped NEAR fungible token'),

one_day_high as (select

max(price_usd) as one_day_high_price

from near.core.fact_prices

where token = 'Wrapped NEAR fungible token'

and timestamp >= DATEADD(HOUR, -1, current_date())),

one_day_low as (select

min(price_usd) as one_day_min_price

from near.core.fact_prices

where token = 'Wrapped NEAR fungible token'

and timestamp >= DATEADD(HOUR, -1, current_date()))

select * from one_day_low

limit 1