with max_hour as (
select
max(hour) as hour
from arbitrum.vertex.ez_market_stats
)
select
symbol as pairs,
open_interest_usd
from arbitrum.vertex.ez_market_stats as stats
inner join max_hour on stats.hour = max_hour.hour
order by open_interest_usd desc