shadilLet’s look into wallet activity with regards to Algorand NFTs - top NFTs by transactions number in May
    Updated 2022-06-01
    with nfts as (
    SELECT *
    from flipside_prod_db.algorand.asset
    where total_supply = 1
    )

    select
    lb.ASSET_NAME,
    count(distinct t.tx_group_id) as trx_count
    from algorand.transactions t
    join flipside_prod_db.algorand.asset lb on t.asset_id = lb.ASSET_ID
    where t.asset_id in (select asset_id from nfts)
    and date_trunc('month', t.block_timestamp) = '2022-05-01'
    and t.tx_group_id is not null
    GROUP BY lb.ASSET_NAME
    ORDER BY trx_count DESC
    limit 10
    Run a query to Download Data