SELECT BLOCK_TIMESTAMP::DATE AS DAYS, COUNT(DISTINCT(ORIGIN_FROM_ADDRESS)) "Number of users on Sushiswap"

FROM arbitrum.sushi.ez_swaps

WHERE BLOCK_TIMESTAMP::DATE < '2022-10-15' ---BLOCK_TIMESTAMP::DATE BETWEEN '2022-05-12' AND '2022-10-12'

GROUP BY DAYS),

Uniswap_Arbitrum AS (

SELECT BLOCK_TIMESTAMP::DATE AS DAYS, COUNT(DISTINCT(ORIGIN_FROM_ADDRESS)) "Number of users on Uniswap"

FROM arbitrum.core.fact_event_logs

WHERE BLOCK_TIMESTAMP::DATE < '2022-10-15' AND TX_STATUS = 'SUCCESS' ---BLOCK_TIMESTAMP::DATE BETWEEN '2022-05-12' AND '2022-10-12'

AND ORIGIN_TO_ADDRESS IN ('0xe592427a0aece92de3edee1f18e0157c05861564','0x68b3465833fb72a70ecdf485e0e4c7bd8665fc45') AND EVENT_NAME = 'Swap'

GROUP BY DAYS)

SELECT Sushiswap_Arbitrum.DAYS, "Number of users on Sushiswap", "Number of users on Uniswap"

FROM Sushiswap_Arbitrum JOIN Uniswap_Arbitrum USING(DAYS)