SELECT

SWAPPER

FROM

aptos.defi.ez_dex_swaps

WHERE

amount_in_usd IS NOT NULL

AND block_timestamp::date >= '2024-01-01'

AND PLATFORM = '{{DEX}}'

GROUP BY

SWAPPER

),

TIME AS (

SELECT

SWAPPER,

MIN(block_timestamp) AS min_block_timestamp

FROM aptos.core.fact_transactions t1

JOIN MAIN t2 ON t1.SENDER = t2.SWAPPER

GROUP BY SWAPPER)

SELECT

AVG(DATEDIFF(day, min_block_timestamp, CURRENT_DATE)) AS avg_days_diff

TIME;