nickpayiatis_Untitled Query
Updated 2022-07-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
with nfts as (
select asset_id
from flipside_prod_db.algorand.asset
where asset_name like 'Warrior Croc%' and (creator_address = 'A62XRVE7ZWSXLAA4YDDI7GUMCHML2TT3JXFT3OWTVQAKOZSBGNT7FX5YQU' or creator_address = 'SRRIUGPVPPGST3KPH32XQXTE567G6LHCEX2IMHDRW2IWH3427UVWXRXHCQ')
), asset_tx as (
select block_timestamp::date as date1, asset_amount, asset_transferred, asset_receiver
from flipside_prod_db.algorand.asset_transfer_transaction att join nfts n on att.asset_transferred = n.asset_id
)
select distinct blk.block_timestamp::date as date1, acc.address
from flipside_prod_db.algorand.account acc join asset_tx atx on acc.address = atx.asset_receiver join flipside_prod_db.algorand.block blk on acc.created_at = blk.block_id
--group by 1
order by 1 asc
Run a query to Download Data