SELECT DISTINCT

origin_from_address

FROM

kaia.defi.ez_dex_swaps

WHERE

block_timestamp > CURRENT_TIMESTAMP - INTERVAL '30 days'

AND origin_from_address NOT IN (

SELECT DISTINCT origin_from_address

FROM kaia.defi.ez_dex_swaps

WHERE block_timestamp <= CURRENT_TIMESTAMP - INTERVAL '30 days'

)

),

new_user_swaps AS (

SELECT

CONCAT(s.symbol_in, ' -> ', s.symbol_out) AS swap_pair,

COUNT(DISTINCT s.tx_hash) AS swap_count

FROM

kaia.defi.ez_dex_swaps s

JOIN

new_users nu ON s.origin_from_address = nu.origin_from_address

WHERE

s.block_timestamp > CURRENT_TIMESTAMP - INTERVAL '30 days'

GROUP BY

swap_pair

swap_pair,

swap_count

new_user_swaps

ORDER BY

swap_count DESC

LIMIT 10;