adriaparcerisasSolana Free Square
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
›
⌄
-- Is there a relationship between minters and buyers on Solana? How the crossover looks like?
WITH
nft_mints as (
select
trunc(block_timestamp,'week') as week,
count(distinct purchaser) as wallets,
count(distinct tx_id) as transactions
from solana.core.fact_nft_mints
group by 1
),
nft_buys as (
select
trunc(block_timestamp,'week') as week,
count(distinct purchaser) as wallets,
count(distinct tx_id) as transactions
from solana.core.fact_nft_sales
group by 1
)
select 'Mints' as actions, * from nft_mints
UNION
select 'Buys' as actions, * from nft_buys
Run a query to Download Data