flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Let’s look into wallet activity with regards to Algorand NFTs - top NFTs by transactions number in May
shadil
Let’s look into wallet activity with regards to Algorand NFTs - top NFTs by transactions number in May
Updated 2022-06-01
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with
nfts
as
(
SELECT
*
from
flipside_prod_db
.
algorand
.
asset
where
total_supply
=
1
)
select
lb
.
ASSET_NAME
,
count
(
distinct
t
.
tx_group_id
)
as
trx_count
from
algorand
.
transactions
t
join
flipside_prod_db
.
algorand
.
asset
lb
on
t
.
asset_id
=
lb
.
ASSET_ID
where
t
.
asset_id
in
(
select
asset_id
from
nfts
)
and
date_trunc
(
'month'
,
t
.
block_timestamp
)
=
'2022-05-01'
and
t
.
tx_group_id
is
not
null
GROUP
BY
lb
.
ASSET_NAME
ORDER
BY
trx_count
DESC
limit
10
Results
Run a query to Download Data