Query editor
with coin_funding as (selectcoin,avg(funding) as avg_funding,count(distinct date_trunc('day', time)) as num_distinct_daysfrom hyperliquid.market_datawhere time >= (select max(time) from hyperliquid.market_data) - interval '90' daygroup by coin),established_coins as (selectcoin,avg_funding,num_distinct_daysfrom coin_fundingwhere num_distinct_days >= 60)selectcoin,num_distinct_days,round(avg_funding * 100, 4) as avg_funding_pct,round(avg_funding * 24 * 365 * 100, 2) as annualized_funding_pct,row_number() over (order by avg_funding desc) as long_crowding_rank,row_number() over (order by avg_funding asc) as short_crowding_rankfrom established_coinsorder by avg_funding desc