SELECT

origin_from_address,

date_trunc('day',block_timestamp) as date

FROM ethereum.core.ez_dex_swaps

WHERE platform IN ('uniswap-v2', 'uniswap-v3')

AND date > DATEADD('{{time}}', -{{last_n_period}}, current_date)

GROUP BY 1, 2

),

active_wallets as (

SELECT

date_trunc('month',date) as month,

origin_from_address,

count(date) as n_txn

FROM activities

GROUP BY 1 , 2

HAVING n_txn >=4

SELECT

date_trunc('{{interval}}', block_timestamp) as date,

count(DISTINCT b.origin_from_address) as n_engaged_wallets

FROM ethereum.core.ez_dex_swaps LEFT JOIN active_wallets b using(origin_from_address)

WHERE date > DATEADD('{{time}}', -{{last_n_period}}, current_date)

AND date < current_date

GROUP BY 1

ORDER BY 1 DESC