permarybsc & avax unique wallets which interacted with nfts
Updated 2024-11-03
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
›
⌄
-- Unique wallets interacting with NFTs on BNB Chain
SELECT
'BNB Chain' AS chain,
COUNT(DISTINCT wallet_address) AS total_unique_wallets
FROM (
SELECT NFT_FROM_ADDRESS AS wallet_address
FROM bsc.nft.ez_nft_transfers -- Adjust the table name according to your schema
WHERE block_timestamp BETWEEN '2024-01-01' AND '2024-12-31'
UNION
SELECT NFT_TO_ADDRESS AS wallet_address
FROM bsc.nft.ez_nft_transfers -- Adjust the table name according to your schema
WHERE block_timestamp BETWEEN '2024-01-01' AND '2024-12-31'
) AS bnb_unique_wallets
UNION ALL
-- Unique wallets interacting with NFTs on Avalanche
SELECT
'Avalanche' AS chain,
COUNT(DISTINCT wallet_address) AS total_unique_wallets
FROM (
SELECT NFT_FROM_ADDRESS AS wallet_address
FROM avalanche.nft.ez_nft_transfers -- Adjust the table name according to your schema
WHERE block_timestamp BETWEEN '2024-01-01' AND '2024-12-31'
UNION
SELECT NFT_TO_ADDRESS AS wallet_address
FROM avalanche.nft.ez_nft_transfers -- Adjust the table name according to your schema
WHERE block_timestamp BETWEEN '2024-01-01' AND '2024-12-31'
) AS avax_unique_wallets;
QueryRunArchived: QueryRun has been archived