PapasotCosmic Champ NFT shuffle sales
Updated 2023-01-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
select
*
from algorand.asset_transfer_transaction
where sender = 'MS7TKJ3MXE6CQ5IZW2ZQC2KT3NWJFQPRSDAFTZPGYPFCZZ43PL7UPBTZXE'
and block_timestamp >= '2022-07-05'
and asset_amount > 0
and asset_id in ( select
asset_id
from flipside_prod_db.algorand.asset
where
CREATOR_ADDRESS='CCNFTNFTSXVYGCGP5EU7AMUTQLUZI6TXRS4XMW2LP4XARZH3LB6RZPUOQM'
and ASSET_DELETED='FALSE'
and ASSET_NAME not in ('SINGULARITY ERA COMMEMORATIVE','Cosmic Champs Whitelist TOKEN')
)
order by block_timestamp
Run a query to Download Data