misaghlbAlgorand Competitive advantages Algorand NFTs Atomic Transfer Sales
    Updated 2022-06-15
    WITH
    standard69 as (
    SELECT
    asset_id from algorand.asset where asset_id in (
    select distinct asset_id from algorand.asset_configuration_transaction where try_base64_decode_string(tx_message:txn:note::string) like '%{"standard":"arc69"%') and closed_at is null
    ),
    standard3 as (
    select asset_id from algorand.asset where asset_url like '%#arc3%' and closed_at is null
    ),
    tx_ids69 as (
    SELECT tx_group_id
    from flipside_prod_db.algorand.transactions
    WHERE asset_id in (SELECT asset_id from standard69) -- 418142231
    and tx_group_id = 'SPtV0lbAJEPGKjaa0vYRXvvm9BFMfi1vCZBB0eL1pRY='
    and TX_ID not in (SELECT TX_ID from flipside_prod_db.algorand.application_call_transaction where date(BLOCK_TIMESTAMP) >= '2022-01-01')
    and date(BLOCK_TIMESTAMP) >= '2022-01-01'
    group by tx_group_id
    ),
    tx_692_2 as (
    SELECT tx_group_id, count(*) as tx_count,
    COUNT(DISTINCT SENDER) as wallet_count
    from flipside_prod_db.algorand.transactions
    -- asset_id in (SELECT asset_id from standard69) -- 418142231
    WHERE tx_group_id in (SELECT tx_group_id from tx_ids69)
    -- and TX_ID not in (SELECT TX_ID from flipside_prod_db.algorand.application_call_transaction where date(BLOCK_TIMESTAMP) >= '2022-01-01')
    and date(BLOCK_TIMESTAMP) >= '2022-01-01'
    group by tx_group_id HAVING tx_count = 3
    ),
    tx_ids3 as (
    SELECT tx_group_id
    from flipside_prod_db.algorand.transactions
    WHERE asset_id in (SELECT asset_id from standard3) -- 418142231
    -- and tx_group_id = 'SPtV0lbAJEPGKjaa0vYRXvvm9BFMfi1vCZBB0eL1pRY='
    and TX_ID not in (SELECT TX_ID from flipside_prod_db.algorand.application_call_transaction where date(BLOCK_TIMESTAMP) >= '2022-01-01')
    and date(BLOCK_TIMESTAMP) >= '2022-01-01'
    group by tx_group_id
    Run a query to Download Data