'Ethereum' AS blockchain,

TO_CHAR(DATE_TRUNC('month', block_timestamp), 'Mon YYYY') AS month,

COUNT(DISTINCT tx_hash) AS tx_count,

DATE_TRUNC('month', block_timestamp) AS month_date -- Used for ordering

FROM

ethereum.defi.ez_dex_swaps

WHERE

platform LIKE 'kyber%'

AND block_timestamp >= '2024-01-01'

AND block_timestamp < '2025-01-01'

GROUP BY

month, month_date

UNION ALL

SELECT

'Avalanche' AS blockchain,

TO_CHAR(DATE_TRUNC('month', block_timestamp), 'Mon YYYY') AS month,

COUNT(DISTINCT tx_hash) AS tx_count,

DATE_TRUNC('month', block_timestamp) AS month_date -- Used for ordering

FROM

avalanche.defi.ez_dex_swaps

WHERE

platform LIKE 'kyber%'

AND block_timestamp >= '2024-01-01'

AND block_timestamp < '2025-01-01'

GROUP BY

month, month_date

UNION ALL

SELECT

'Arbitrum' AS blockchain,

TO_CHAR(DATE_TRUNC('month', block_timestamp), 'Mon YYYY') AS month,

COUNT(DISTINCT tx_hash) AS tx_count,