PLATFORM,

DATE_TRUNC('day', block_timestamp) AS date,

SUM(amount_in_usd - amount_out_usd) OVER (PARTITION BY PLATFORM ORDER BY DATE_TRUNC('day', block_timestamp)) AS cumulative_fees

FROM optimism.core.ez_dex_swaps