with
t as (
select
block_hour,
avg(total_liquidity_usd) as liquidity_usd,
avg(reserve_price) as reserve_price,
row_number() over (order by block_hour desc) as rate
from ethereum.aave.ez_market_stats
where reserve_name = 'SNX'
group by 1
qualify rate = 1
)
select liquidity_usd, reserve_price from t