WITH uniswap_volume AS (

SELECT

SUM(amount_in_usd) as volume,

-- 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

SUM(AMOUNT_USD) as volume,

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

FROM blast.core.ez_token_transfers

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

SUM(AMOUNT_USD) as volume,

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

FROM blast.core.ez_token_transfers