signers[0] as new_users

from solana.core.fact_transactions

where succeeded = 'TRUE'

group by 2

having initial_transaction >= '2022-11-01'),

table_1 as (select date_trunc('day', initial_transaction) as day,

count(distinct(new_users)) as wallet_count,

sum(wallet_count) over (order by day) as cumu_wallet_count

from new_user

group by 1),

table_2 as (select date_trunc('day', block_timestamp) as day,

count(distinct(tx_id)) as tx_count,

sum(tx_count) over (order by day) as cumu_tx_count

from solana.core.fact_transactions

where signers[0] in (select new_users from new_user)

group by 1),

table_3 as (select date_trunc('day', block_timestamp) as day,

count(distinct(purchaser)) as nft_wallet_count,

count(distinct(tx_id)) as nft_tx_count,

sum(nft_tx_count) over (order by day) as cumu_nft_tx_count

from solana.core.fact_nft_sales

where succeeded = 'TRUE'

and purchaser in (select new_users from new_user)

group by 1),

final1 as (select a.day,

wallet_count,

cumu_wallet_count,

tx_count,

cumu_tx_count,

nft_wallet_count,

nft_tx_count,