nitsUntitled Query
    Updated 2022-05-27
    with ids as
    (SELECT asset_id, asset_name
    FROM algorand.asset
    WHERE asset_name LIKE 'Al Goanna%'),
    usage_ as
    (SELECT asset_id as id, max(block_timestamp) as last_holder_time from algorand.transactions
    where asset_id in (SELECT asset_id from ids)
    GROUP by 1 )

    SELECT * from algorand.payment_transaction
    where asset_id in (SELECT asset_id from ids )
    limit 1000
    Run a query to Download Data