SELECT

TX_HASH,

DATE_TRUNC('month', BLOCK_TIMESTAMP) AS month

FROM ethereum.core.ez_dex_swaps

),

crosschain_swaps AS (

SELECT

TX_HASH,

DATE_TRUNC('month', BLOCK_TIMESTAMP) AS month

FROM crosschain.defi.ez_swaps

WHERE BLOCKCHAIN = 'Ethereum'

),

eth_only AS (

SELECT

month,

COUNT(*) AS eth_only_count,

COUNT(DISTINCT TX_HASH) AS eth_only_count_unique

FROM eth_swaps

WHERE TX_HASH NOT IN (SELECT TX_HASH FROM crosschain_swaps)

GROUP BY month

),

crosschain_only AS (

SELECT

month,

COUNT(*) AS crosschain_only_count,

COUNT(DISTINCT TX_HASH) AS crosschain_only_count_unique

FROM crosschain_swaps

WHERE TX_HASH NOT IN (SELECT TX_HASH FROM eth_swaps)

GROUP BY month

),

both_tables AS (