solana_wallets AS (

SELECT

signers[0] as wallets,

min(date(block_timestamp)) as solana_first_tx

FROM

solana.core.fact_events

GROUP BY

1

),

solana_new_wallets AS (

SELECT

solana_first_tx,

count(distinct wallets) as new_wallets

FROM

solana_wallets

WHERE

solana_first_tx between CURRENT_DATE() -60 and current_date() -1

GROUP BY

1

)

*

solana_new_wallets

order by

solana_first_tx desc