binhachonNew Wallets from NFTs - #6
    Updated 2022-06-07
    with wallet_list as (
    select
    address,
    created_at,
    balance,
    block_timestamp
    from flipside_prod_db.algorand.account
    inner join flipside_prod_db.algorand.block on (block_id = created_at)
    where account_closed = 'FALSE'
    and balance > 1
    ),
    NFT_list as (
    select
    asset_id
    from flipside_prod_db.algorand.asset
    where total_supply = 1
    and decimals = 0
    ),
    arc69_NFT_list as (
    select
    asset_id
    from flipside_prod_db.algorand.asset_configuration_transaction
    where asset_id in (select asset_id from NFT_list)
    and try_parse_json(try_base64_decode_string(tx_message:txn:note::string)):standard::string = 'arc69'
    ),
    address_with_NFT as (
    select
    asset_receiver as NFT_address,
    count(distinct asset_id) as number_of_NFTs
    from flipside_prod_db.algorand.asset_transfer_transaction
    where NFT_address in (select address from wallet_list)
    and asset_id in (select asset_id from arc69_NFT_list)
    and block_timestamp::date >= '2022-05-01'
    group by 1
    ),
    address_with_NFT_1 as (
    Run a query to Download Data