first_txs as (

SELECT

distinct signers[0] as news,

min(block_timestamp) as first_tx

from solana.core.fact_transactions

group by 1

),

transactions as (

select

fns.block_timestamp,

fns.purchaser,

fns.tx_id,

dnm.contract_name

from solana.fact_nft_sales fns

join solana.dim_nft_metadata dnm on fns.mint = dnm.mint

),

matches as (

select

first_tx,

contract_name as nft_collection,

from first_txs ft

join transactions t on t.purchaser=ft.news and trunc(t.block_timestamp,'day') between trunc(ft.first_tx,'day') and trunc(ft.first_tx,'day')+INTERVAL '7 DAYS'

)

nft_collection,

count(distinct purchaser) as wallets

from matches

group by 1

order by 2 desc