PapasotAlgo NFT minters and sellers
Updated 2023-01-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
›
⌄
with NFTs as(
SELECT
asset_id,asset_name,creator_address
from algorand.asset
where total_supply = 1
and decimals = 0
and asset_deleted = 'False'
)
select
date_trunc('month',block_timestamp) as month,
count(DISTINCT(sender)) as NFT_sellers,
sum(NFT_sellers) over(order by month) as cum_sellers,
count(DISTINCT(asset_receiver)) as NFT_buyers,
count(tx_id) as NFT_transfers
from algorand.asset_transfer_transaction a
left join NFTs b on b.asset_id = asset_transferred
where month >= '2022-01-01'
and asset_amount = 1
and a.asset_id = b.asset_id
and sender = creator_address
group by month
order by month
Run a query to Download Data