SELECT DATE_TRUNC('DAY', block_timestamp) AS date

, 'Uniswap' AS platform

, COUNT(*) AS swaps

FROM arbitrum.core.fact_transactions

WHERE (to_address ilike '0xE592427A0AEce92De3Edee1F18E0157C05861564'

OR to_address ilike '0x68b3465833fb72A70ecDF485E0e4C7bD8665Fc45')

AND DATEDIFF('DAY', block_timestamp, CURRENT_DATE) <= 90

AND status = 'SUCCESS'

GROUP BY 1, 2

UNION ALL

SELECT DATE_TRUNC('DAY', block_timestamp) AS date

, 'Sushiswap' AS platform

, COUNT(*) AS swaps

FROM arbitrum.sushi.ez_swaps

WHERE DATEDIFF('DAY', block_timestamp, CURRENT_DATE) <= 90

GROUP BY 1, 2

SELECT *

, SUM(swaps) OVER (PARTITION BY platform ORDER BY date) AS cumulative

FROM swaps