Query editor
WITHv2_24h_volume_on_polygon AS (SELECTu.quote AS quote,t.evt_block_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'WHEREt.evt_block_time >= current_timestamp - interval '24' hour)SELECT-- v1 has phased out, last 24h volume is always 0SUM(quote_volume * price) as volumeFROMv2_24h_volume_on_polygon