Query editor
WITHv2_all_trades_on_polygon AS (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.quoteAND DATE(t.evt_block_time) = p.minuteAND p.blockchain = 'polygon'),v2_weekly_volume AS (SELECTdate_trunc('week', trade_time) AS week,trader,SUM(quote_volume * price) AS volumeFROMv2_all_trades_on_polygonGROUP BY1,2),v2_weekly_volume_rank_by_trader AS (SELECTweek,trader,volume,RANK() OVER (PARTITION BYweekORDER BYvolume DESC) AS volume_rankFROMv2_weekly_volume),v2_weekly_volume_of_top5_traders AS (SELECTweek,sum(volume) as total_volume,sum(casewhen volume_rank <= 5 then volumeelse 0end) as top5_volumeFROMv2_weekly_volume_rank_by_traderGROUP BY1HAVINGsum(volume) > 0)SELECTweek,total_volume,top5_volume,