Query editor
WITH week_volume AS (SELECTdate_trunc('week', trade_time) AS week,trader,SUM(quote_volume * price) AS volumeFROM (SELECTt.taker AS trader,t.evt_block_time AS trade_time,(t.price / 1e18) * ABS(t.takeSize / 1e18) AS quote_volume,p.price AS priceFROMsynfutures_v2_polygon.Underlying_evt_Trade tLEFT JOIN synfutures_v2_polygon.Router_evt_NewUnderlying u ON t.contract_address = u.underlyingLEFT JOIN prices.usd p ON p.contract_address = u.quote AND DATE(t.evt_block_time) = p.minute AND p.blockchain = 'polygon') GROUP BY 1, 2),week_volume_rank AS (SELECT week, trader, volume, RANK() OVER(partition by week order by volume desc) as volume_rank from week_volume)SELECTweek,total_volume,top5_volume,top5_volume * 100 / total_volume as top5_ratioFROM (SELECTweek,sum(volume) as total_volume,sum(case when volume_rank <=5 then volume else 0 end) as top5_volumeFROM week_volume_rankgroup by 1having sum(volume) > 0) foo