Query editor
WITH-- V2 trade value on polygonv2_trade_value_on_polygon AS (SELECTu.quote AS quote,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 AS tLEFT JOIN synfutures_v2_polygon.Router_evt_NewUnderlying AS u ON t.contract_address = u.underlyingLEFT JOIN prices.usd AS p ON p.contract_address = u.quoteAND Date(t.evt_block_time) = p.minuteAND p.blockchain = 'polygon')SELECTdate_trunc('day', trade_time) AS time,SUM(quote_volume * price) AS volumeFROMv2_trade_value_on_polygonGROUP BY1