lagandispensernumber of NFT atomic transfers
    Updated 2022-06-16
    WITH
    standard69 as (
    SELECT
    asset_id, created_at as block_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 distinct asset_id, created_at as block_id from algorand.asset where asset_url like '%#arc3%' and closed_at is null
    ),
    datetimes as (
    SELECT
    block_timestamp,
    block_id
    from algorand.block
    ),
    s69_final as (
    SELECT
    asset_id,
    block_timestamp,
    'ARC69' as standard
    from standard69 x, datetimes y where x.block_id=y.block_id
    ),
    s3_final as (
    SELECT
    asset_id,
    block_timestamp,
    'ARC3' as standard
    from standard3 x, datetimes y where x.block_id=y.block_id
    ),
    final_data as (
    select * from s69_final
    union ALL
    select * from s3_final
    )
    select
    trunc(block_timestamp,'day') as date,
    Run a query to Download Data