sum(AMOUNT_IN_USD) as "Total Amount in USD",

COUNT(DISTINCT ORIGIN_FROM_ADDRESS) as "Users",

DATE_TRUNC('Month', block_timestamp) as "Month"

-- CASE WHEN platform IN ('uniswap-v1', 'uniswap-v2', 'uniswap-v3') THEN 'Uniswap' WHEN platform IN ('sushiswap') THEN 'Sushiswap' END dex

FROM ethereum.core.ez_dex_swaps

WHERE platform LIKE 'uniswap-%'

AND block_timestamp::DATE > '2022-01-01'

GROUP BY "Month"

ORDER BY "Month"),

sushiswap_data AS (SELECT 'sushiswap' as DEX, COUNT(DISTINCT tx_hash) as "Number of Transactions",

sum(AMOUNT_IN_USD) as "Total Amount in USD",

COUNT(DISTINCT ORIGIN_FROM_ADDRESS) as "Users",

DATE_TRUNC('Month', block_timestamp) as "Month"

FROM ethereum.core.ez_dex_swaps

WHERE platform = 'sushiswap'

AND block_timestamp::DATE > '2022-01-01'

GROUP BY "Month"

ORDER BY "Month")

select * from uniswap_data

union

select * from sushiswap_data