drift_users as (

select

block_timestamp ::date as date,

tx_id,

signers[0] as wallet_address

from solana.core.fact_events events

inner join solana.core.fact_transactions txs

using(tx_id,block_timestamp,succeeded)

where succeeded

and program_id = 'dRiftyHA39MWEi3m9aunc5MzRF1JYuBsbn6VPcn33UH'

and block_timestamp > '2022-11-04' ::date

-- and block_timestamp ::date > current_date() - interval '{{months}} months' - interval '1 month'

),

first_dates as (

select

wallet_address,

min(date) as date_first

from drift_users

group by 1

),

aggregated as (

select