PapasotAlgo NFT minters and sellers
    Updated 2023-01-03
    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