amiroza shuffle sales over time
    Updated 2022-07-13
    with nfts as (select a.asset_id,total_supply
    from flipside_prod_db.algorand.asset a
    join flipside_prod_db.algorand.block b on a.CREATED_AT=b.BLOCK_ID
    where 1=1
    -- and asset_id in (786130476,786131555)
    and CREATOR_ADDRESS='CCNFTNFTSXVYGCGP5EU7AMUTQLUZI6TXRS4XMW2LP4XARZH3LB6RZPUOQM'
    and ASSET_NAME not in ('Cosmic Champs Whitelist TOKEN','SINGULARITY ERA COMMEMORATIVE')
    and ASSET_DELETED='FALSE'
    and b.BLOCK_TIMESTAMP::date >='2022-06-22')

    select BLOCK_TIMESTAMP::date date,sum(asset_amount) asset_count
    from flipside_prod_db.algorand.ASSET_TRANSFER_TRANSACTION a

    where 1=1
    --and asset_id in (select asset_id from nfts)
    and SENDER='CCNFTNFTSXVYGCGP5EU7AMUTQLUZI6TXRS4XMW2LP4XARZH3LB6RZPUOQM'
    and date>='2022-06-22'
    and asset_id in (select asset_id from nfts)
    group by 1
    Run a query to Download Data