amiroza shuffle sales over time
Updated 2022-07-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
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