SELECT

COUNT(DISTINCT tx_hash) AS uniswap_tx_count,

-- DATE_TRUNC('month', block_timestamp) AS month,

blockchain

FROM crosschain.defi.ez_dex_swaps

WHERE lower(platform) LIKE 'uniswap%'

AND block_timestamp >= '2020-01-01'

GROUP BY blockchain

),

blast_uniswap_addresses AS (

SELECT DISTINCT address FROM blast.core.dim_contracts WHERE lower(name) LIKE '%uniswap%'

),

uniswap_blast AS (

SELECT

COUNT(DISTINCT tx_hash) AS uniswap_tx_count,

-- DATE_TRUNC('month', block_timestamp) AS month

FROM blast.core.fact_transactions

WHERE (to_address IN (SELECT address FROM blast_uniswap_addresses) OR from_address IN (SELECT address FROM blast_uniswap_addresses))

AND status = 'SUCCESS'

AND block_timestamp >= '2020-01-01'

-- GROUP BY month

),

blast_dex_addresses AS (

SELECT DISTINCT address FROM blast.core.dim_labels WHERE label_type = 'dex'

),

dex_blast AS (

SELECT

COUNT(DISTINCT tx_hash) AS dex_tx_count,

-- DATE_TRUNC('month', block_timestamp) AS month

FROM blast.core.fact_transactions

WHERE (to_address IN (SELECT address FROM blast_dex_addresses) OR from_address IN (SELECT address FROM blast_dex_addresses))