Query editor
with daily_volume as (selectcoin,date_trunc('day', time) as day,avg(day_ntl_vlm) as daily_volumefrom hyperliquid.market_datawhere time >= now() - interval '90' daygroup by coin,date_trunc('day', time)),coin_avg_volume as (selectcoin,avg(daily_volume) as avg_daily_volumefrom daily_volumegroup by coin),classified as (selectcoin,avg_daily_volume,casewhen avg_daily_volume >= 1000000000then 'Mega'when avg_daily_volume >= 100000000then 'Very High'when avg_daily_volume >= 10000000then 'High'when avg_daily_volume >= 100000then 'Moderate'when avg_daily_volume > 0then 'Low'else'No Volume'end as activity_tierfrom coin_avg_volume)selectactivity_tier,count(*) as num_markets,round(avg(avg_daily_volume), 0) as avg_volume_in_tierfrom classifiedgroup by activity_tierorder by min(avg_daily_volume) desc