adriaparcerisasWallet activity on Algorand NFTs
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
30
31
32
33
34
35
36
›
⌄
-- 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
trunc(block_timestamp,'month') as month,
count( distinct sender) as n_sellers,
count(distinct asset_receiver) as n_buyers,
sum(asset_amount) as total_nfts_sold
from algorand.asset_transfer_transaction where
block_timestamp>='2022-01-01' and asset_id in (
select
distinct asset_id from algorand.asset where total_supply=1 and decimals=0)
group by 1
order by 2 desc
),
nfts_transfers as (
SELECT
trunc(block_timestamp,'month') as month,
count( distinct asset_sender) as n_wallets_transfering,
sum(amount) as total_nfts_transferred
from algorand.transfers where
block_timestamp>='2022-01-01' and asset_id in (
select
distinct asset_id from algorand.asset where total_supply=1 and decimals=0)
group by 1
order by 2 desc
)
SELECT
x.month,
n_sellers,
n_buyers,
total_nfts_sold,
Run a query to Download Data