itsxenuxNumber of active wallets that are selling NFTs monthly
    Updated 2022-06-02
    select count(distinct flipside_prod_db.algorand.transactions.sender) as total_sellers,
    date_trunc('month', flipside_prod_db.algorand.transactions.block_timestamp) as date_time
    from flipside_prod_db.algorand.application_call_transaction join flipside_prod_db.algorand.transactions
    on flipside_prod_db.algorand.transactions.tx_group_id = flipside_prod_db.algorand.application_call_transaction.tx_group_id
    and flipside_prod_db.algorand.transactions.tx_message:ca is null
    where flipside_prod_db.algorand.transactions.asset_id in (select distinct asset_id
    from flipside_prod_db.algorand.asset_configuration_transaction
    where try_base64_decode_string(tx_message:txn:note::string) like '%arc69%' OR try_base64_decode_string(tx_message:txn:note::string) like '%arc3%')
    group by date_time
    Run a query to Download Data