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_volume as (selectcoin,sum(daily_volume) as total_volumefrom daily_volumegroup by coin),ranked as (selectcoin,total_volume,row_number() over (order by total_volume desc) as volume_rankfrom coin_volume)selectcoin,total_volume,volume_rank,round(total_volume / sum(total_volume) over () * 100, 2) as percent_of_total,round(sum(total_volume) over (order by total_volume desc)/ sum(total_volume) over () * 100, 2) as cumulative_percentfrom rankedorder by total_volume desclimit 15