flipside

    cosmic 1
    Hadisehcosmic 1
    Updated 2022-07-14
    select trunc(block_timestamp,'hour') as hour , sum(amount) as total_amount , count(DISTINCT tx_group_id) as total_sales
    from flipside_prod_db.algorand.transfers
    where asset_id in ( select asset_id from flipside_prod_db.algorand.asset
    where asset_name != 'SINGULARITY ERA COMMEMORATIVE' and asset_name != 'Cosmic Champs Whitelist TOKEN' and creator_address = 'CCNFTNFTSXVYGCGP5EU7AMUTQLUZI6TXRS4XMW2LP4XARZH3LB6RZPUOQM'
    )
    and block_timestamp >= '2022-07-06 18:00:00' and amount > 0
    group by hour
    Run a query to Download Data