Query editor
1select2 date_trunc('week', time) as day,3 coin,4 sum(day_ntl_vlm) as volume5from hyperliquid.market_data 6where time = date_trunc('day', time)7group by 1,28order by 1 desc, 3 desc
select
date_trunc('week', time) as day,
coin,
sum(day_ntl_vlm) as volume
from hyperliquid.market_data
where time = date_trunc('day', time)
group by 1,2
order by 1 desc, 3 desc