signers[0] as user,

min(block_timestamp) as first_tx

from solana.core.fact_events

where succeeded

and program_id = 'ATLocKpzDbTokxgvnLew3d7drZkEzLzDpzwgrgWKDbmc'

group by user),

daily_new_star_atlas as (select

date_trunc('day', first_tx) as date,

count(*) as new_users,

sum(new_users) over (order by date asc rows between unbounded preceding and current row) as cum_users,

'star atlas' as label

from star_atlas_users

group by date),

aurory_users as (select

signers[0] as user,

min(block_timestamp) as first_tx

from solana.core.fact_events

where succeeded

and program_id = 'STkwf3sbMapjy7KV3hgrJtcVvY4SvRxWQ8pj4Enw1i5'

group by user

),

daily_new_aurory_users as (select

date_trunc('day', first_tx) as date,

count(*) as new_users,

sum(new_users) over (order by date asc rows between unbounded preceding and current row) as cum_users,

'aurory' as label

from aurory_users

group by date),

genopets_users as (select

signers[0] as user,

min(block_timestamp) as first_tx