SELECT

DATE(block_timestamp) AS swap_date,

swapper AS swapper_id

FROM

solana.defi.ez_dex_swaps

WHERE

block_timestamp BETWEEN '2024-10-01'

AND '2024-10-31'

),

EthereumSwappers AS (

SELECT

DATE(block_timestamp) AS swap_date,

origin_from_address AS swapper_id

FROM

ethereum.defi.ez_dex_swaps

WHERE

block_timestamp BETWEEN '2024-10-01'

AND '2024-10-31'

),

SolanaSwapperClassification AS (

SELECT

swap_date,

swapper_id,

CASE

WHEN MIN(swap_date) OVER (

PARTITION BY swapper_id

ORDER BY

swap_date

) = swap_date THEN 'SolanaNewSwapper'

ELSE 'SolanaReturningSwapper'

END AS SwapperType

FROM

SolanaSwappers

),

EthereumSwapperClassification AS (