select

block_timestamp,

signers [0] as user_address

from

solana.core.fact_events

where

succeeded

and fact_events.program_id = 'SHARKobtfF1bHhxD2eqftjHBdVSCbKo9JtgK71FhELP'

),

first_txs as (

select

user_address,

min(block_timestamp) as first_timestamp

from

solana.core.fact_events

inner join (

select

distinct user_address

from

all_txs

) users on fact_events.signers [0] = users.user_address

where

succeeded

and fact_events.program_id = 'SHARKobtfF1bHhxD2eqftjHBdVSCbKo9JtgK71FhELP'

group by

1

),

aggregated as (

select

date_trunc('day', block_timestamp) as date,

iff(

first_timestamp :: date = block_timestamp :: date,

'New',

'Old'

) as category,