HeminHow many active wallets are buying/selling/transferring NFTs monthly?
Updated 2022-06-02
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
›
⌄
⌄
/*
How many active wallets are buying/selling/transferring NFTs monthly?
What percent of Algo wallets hold an NFT?
What’s the number of total wallets that have minted NFTs and put them up for sale, month over month and cumulatively?
What projects are the most popular, generating the most transaction volume this month?
*/
with nfts as (select
ASSET_ID
from flipside_prod_db.algorand.asset
where TOTAL_SUPPLY = 1 and DECIMALS = 0
)
, active as (
select
ADDRESS
from flipside_prod_db.algorand.account
where ACCOUNT_CLOSED = FALSE
)
select
date_trunc(MONTH , BLOCK_TIMESTAMP) as month ,
count(DISTINCT (SENDER) ) as nft_users
-- (select count(DISTINCT ADDRESS) from active ) as totoal_active_users ,
-- nft_users/ totoal_active_users*100 as percent
from flipside_prod_db.algorand.transactions
where
asset_id in (select * from nfts )
and SENDER in (select * from active )
GROUP by month
Run a query to Download Data