baseswap_users as (

SELECT origin_from_address as user,

min(block_timestamp) as first_interaction

FROM base.defi.ez_dex_swaps

WHERE platform = 'baseswap'

GROUP BY user

),

base_users as (

SELECT b.first_interaction,

min(block_timestamp) as first_transaction,

DATEDIFF(DAY, first_transaction, first_interaction) AS days_between

FROM base.core.fact_transactions t

JOIN baseswap_users b ON t.from_address = b.user

GROUP BY first_interaction

SELECT avg(days_between) as avg_days_between

FROM base_users