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

FROM polygon.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_Polygon AS (

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

FROM polygon.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_Polygon.DAYS, "Number of swaps on Sushiswap", "Number of swaps on Uniswap"

FROM Sushiswap_Polygon JOIN Uniswap_Polygon USING(DAYS)