PapasotRapid Chess NFTs transfers
    Updated 2022-09-12
    select
    *
    FROM
    algorand.transfers
    WHERE
    amount = 1 and
    asset_id in (
    select
    asset_id
    from algorand.asset
    where ASSET_NAME like '%Rapid chess game%'
    and ASSET_DELETED= false
    and total_supply = 1
    and creator_address= 'PAPA23PAWOROGLHBAL3DNHEFI76JNIET4N32OOJLJGQRKR4PMD4EE5M7PQ'
    order by asset_name
    )
    order by block_timestamp







    Run a query to Download Data