Query editor
SELECT date_trunc('day', evt_block_time) as time,CASEWHEN SUM(realizedPnl * 1e-18) > 0 THEN 'PROFIT'ELSE 'LOSS'END as outcome,SUM(realizedPnl * 1e-18) AS daily_pnl,SUM(realizedPnl * 1e-18) - SUM(fee * 1e-18) AS daily_pnl_incl_fee,-- Technique used from @Momir https://dune.xyz/queries/290040/547786SUM(SUM(fee) * 1e-18) OVER (ORDER BY date_trunc('day', evt_block_time)) as cumulative_fees,SUM(SUM(realizedPnl) * 1e-18) OVER (ORDER BY date_trunc('day', evt_block_time)) as cumulative_pnlFROM perp_v2_optimism.ClearingHouse_evt_PositionChangedWHERE CAST(trader AS VARCHAR) = '{{wallet address}}' and(CASEWHEN '{{time period}}' = 'Day' THEN date_trunc('day', evt_block_time) >= NOW() - interval '1' dayWHEN '{{time period}}' = 'Week' THEN date_trunc('day', evt_block_time) >= NOW() - interval '7' dayWHEN '{{time period}}' = 'Month' THEN date_trunc('day', evt_block_time) >= NOW() - interval '1' monthWHEN '{{time period}}' = 'Year' THEN date_trunc('day', evt_block_time) >= NOW() - interval '1' yearWHEN '{{time period}}' = 'All-Time' THEN 1=1END)GROUP BY 1ORDER BY 1 DESC