SELECT

recipient AS wallet_addresses,

date_trunc('month', min(block_timestamp) :: date) AS start_month,

LISTAGG(

DISTINCT date_trunc('month', block_timestamp) :: date,

','

) AS active_months_list

FROM

ethereum.uniswapv3.ez_swaps

WHERE

block_timestamp >= '2024-06-01'

AND block_timestamp < '2024-10-01'

GROUP BY

wallet_addresses

),

splitActiveMonths AS (

SELECT

wallet_addresses,

value :: date AS active_month

FROM

userActiveMonths,

TABLE(SPLIT_TO_TABLE(active_months_list, ','))

),

monthlyRetention AS (

SELECT

to_char(start_month, 'Mon') AS month,

COUNT(start_month) AS new_users,

COUNT(

CASE

WHEN EXISTS (

SELECT

1

FROM

splitActiveMonths

WHERE