with hereW as (

select

BLOCK_TIMESTAMP,

TX_ID as TX_HASH,

SWAPPER as user,

from solana.marinade.ez_swaps

,

qmain as (

SELECT DISTINCT

block_timestamp,

tx_hash,

user as FROM_ADDRESS

FROM hereW

, base_table as ( -- this is data prep

select

FROM_ADDRESS as address

, date_trunc('week', block_timestamp) as date

, min(date_trunc('week', block_timestamp)) over(partition by address) as earliest_date

, datediff(

'week'

, min(date_trunc('week', block_timestamp)) over(partition by address) -- earliest_date

, date_trunc('week', block_timestamp) -- current date in month

) as difference

from qmain

where block_timestamp >= current_timestamp() - interval '13 WEEK'

HAVING date_trunc('week', block_timestamp) < date_trunc('week', current_date())