mariya Total number of unique wallets
Updated 2022-04-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
WITH diagram1 AS (
SELECT
count(distinct(posttokenbalances[0]:owner)) as me_total_wallets
FROM solana.nfts
WHERE (program_id = 'MEisE1HzehtrDpAAT8PnLHjpSSkRYakotTuJRPjTpo8' OR program_id = 'M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K')
AND array_size(inner_instruction:instructions) > 2
AND block_timestamp >= '2022-04-06'
),
diagram2 AS (
SELECT
count(distinct(instruction:accounts[0])) as os_total_wallets
FROM solana.fact_events
WHERE index = 7
AND program_id = 'hausS13jsjafwWwGqZTUQRmWyvyxn9EQpqMwV1PBBmk'
AND block_timestamp >= '2022-04-06'
)
SELECT
'Total unique wallets bought a SOL NFT on OpenSea vs. Magic Eden', os_total_wallets, me_total_wallets
FROM diagram2 , diagram1
Run a query to Download Data