Query editor
WITHv2_trade_event_on_polygon AS (SELECTt.taker AS trader,t.evt_block_time AS trade_time,(t.price / 1e18) * ABS(t.takeSize / 1e18) AS 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_trade_frequency_on_polygon AS (SELECTdate_trunc('week', trade_time) AS week,trader,sum(volume * price) AS volume,count(*) AS frequencyFROMv2_trade_event_on_polygonGROUP BY1,2)SELECTweek,CASEWHEN frequency < 10 THEN 'Low(< 10)'WHEN frequency >= 10AND frequency < 100 THEN 'Medium(10-100)'ELSE 'High(>=100)'END AS frequency,SUM(volume) AS volumeFROMv2_trade_frequency_on_polygonGROUP BY1,2