PapasotCopy of Cosmic Champ NFT shuffle sales
Updated 2023-01-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
select
date_trunc('hour',block_timestamp) as block_hour,
sum(asset_amount) as NFT_sales
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')
)
group by block_hour
order by block_hour
Run a query to Download Data