flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
The top ten assets by the number of transfers since Feb 2022
princefarzam
The top ten assets by the number of transfers since Feb 2022
Updated 2022-04-07
Copy Reference
Fork
9
1
2
3
4
5
6
7
8
›
⌄
SELECT
b
.
ASSET_NAME
,
COUNT
(
DISTINCT
a
.
TX_ID
)
AS
number_of_transfers
FROM
algorand
.
asset_transfer_transaction
a
INNER
JOIN
algorand
.
asset
b
ON
a
.
ASSET_ID
=
b
.
ASSET_ID
WHERE
a
.
BLOCK_TIMESTAMP
>=
'2022-02-01'
GROUP
BY
1
ORDER
BY
2
DESC
LIMIT
10
Results
Run a query to Download Data