adriaparcerisasSolana Onboarding NFTs 3
Updated 2022-06-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with
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
),
new_nft as (
select
trunc(block_timestamp,'month') as months,
count(distinct purchaser) as new_NFT_wallets
from first_txs ft
join transactions t on t.purchaser=ft.news and trunc(t.block_timestamp,'month')=trunc(ft.first_tx,'month')
group by 1
order by 1 asc
),
news as (
select
trunc(first_tx,'month') as months,
count(distinct news) as new_wallets
from first_txs
group by 1
order by 1 asc
)
SELECT
x.months,
Run a query to Download Data