PapasotCopy of Cosmic Champ NFT shuffle sales
    Updated 2023-01-03
    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