Query editor
SELECT *,SUM(volume_) OVER (PARTITION BY symbol) AS total_volumeFROM (SELECT date_trunc('{{3 Time Granularity}}', evt_block_time) AS day,COALESCE(symbol,"baseToken"::text) AS symbol,sum(ABS("exchangedPositionNotional") / 10^18) AS volume_,--sum(sum(ABS("exchangedPositionNotional") / 10^18)) over (order by date_trunc('{{3 Time Granularity}}', evt_block_time)) as cumulative_volume,COUNT(*) AS num_swapsfrom perp_v2."ClearingHouse_evt_PositionChanged" pLEFT JOIN erc20."tokens" tON "baseToken" = t."contract_address"WHERE1 = (CASE WHEN '{{2 Show Current Period}}' = 'Yes' THEN 1WHEN '{{2 Show Current Period}}' = 'No' AND date_trunc('{{3 Time Granularity}}', evt_block_time) != date_trunc('{{3 Time Granularity}}', NOW()) THEN 1ELSE 0END)AND date_trunc('{{3 Time Granularity}}', evt_block_time) > date_trunc('{{3 Time Granularity}}',NOW()) - interval '{{1 Trailing Num Days}} days'group by 1,2) aORDER BY total_volume DESC