SELECT BLOCK_TIMESTAMP,TX_HASH,'Uniswap' AS PLATFORM,TX_FEE

FROM ethereum.core.fact_transactions

WHERE TX_HASH IN (SELECT DISTINCT TX_HASH FROM ethereum.defi.ez_dex_swaps

WHERE BLOCK_TIMESTAMP>=CURRENT_DATE-INTERVAL '6 MONTHS'

AND PLATFORM LIKE '%uniswap%')

AND BLOCK_TIMESTAMP>=CURRENT_DATE-INTERVAL '6 MONTHS'

UNION ALL

SELECT BLOCK_TIMESTAMP,TX_HASH,'Curve' AS PLATFORM,TX_FEE

FROM ethereum.core.fact_transactions

WHERE TX_HASH IN (SELECT DISTINCT TX_HASH FROM ethereum.defi.ez_dex_swaps

WHERE BLOCK_TIMESTAMP>=CURRENT_DATE-INTERVAL '6 MONTHS'

AND PLATFORM LIKE '%curve%')

AND BLOCK_TIMESTAMP>=CURRENT_DATE-INTERVAL '6 MONTHS'

UNION ALL

SELECT BLOCK_TIMESTAMP,TX_HASH,'Kyberswap' AS PLATFORM,TX_FEE

FROM ethereum.core.fact_transactions

WHERE TX_HASH IN (SELECT DISTINCT TX_HASH FROM ethereum.defi.ez_dex_swaps

WHERE BLOCK_TIMESTAMP>=CURRENT_DATE-INTERVAL '6 MONTHS'

AND PLATFORM LIKE '%kyberswap%')

AND BLOCK_TIMESTAMP>=CURRENT_DATE-INTERVAL '6 MONTHS'

UNION ALL

SELECT BLOCK_TIMESTAMP,TX_HASH,'Sushiswap' AS PLATFORM,TX_FEE

FROM ethereum.core.fact_transactions

WHERE TX_HASH IN (SELECT DISTINCT TX_HASH FROM ethereum.defi.ez_dex_swaps

WHERE BLOCK_TIMESTAMP>=CURRENT_DATE-INTERVAL '6 MONTHS'

AND PLATFORM LIKE '%sushiswap%')

AND BLOCK_TIMESTAMP>=CURRENT_DATE-INTERVAL '6 MONTHS'

UNION ALL