with lst_first_tx as (
select
min(BLOCK_TIMESTAMP) as first_date
,SIGNERS[0] as wallet
from solana.core.fact_transactions
where SUCCEEDED=true
-- block_timestamp::date>='2022-01-11'
group by 2
order by 1
)
select top 10
mint as nft
,count(MINT) as count_nft
,sum(SALES_AMOUNT) as amount
from solana.core.fact_nft_sales s
join lst_first_tx t on t.wallet = s.PURCHASER
where SUCCEEDED=true
and s.BLOCK_TIMESTAMP>t.first_date and s.BLOCK_TIMESTAMP<=(t.first_date::date)+2
group by 1
order by 2 DESC