glass_blossomsTop 10 assets by number of transfers
Updated 2022-04-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH top_asa as (
SELECT
block_id,
asset_id,
asset_receiver as holders,
tx_id as number_of_transactions
FROM algorand.asset_transfer_transaction
where asset_id is not null
),
time_line as (
SELECT
block_id,
date_trunc('day', block_timestamp) as day
FROM algorand.block
),
asset_names as (
SELECT
asset_id,
asset_name
FROM algorand.asset
)
SELECT
COUNT(DISTINCT top_asa.holders) as holder,
COUNT(top_asa.number_of_transactions) as tx_number,
time_line.day as day,
asset_names.asset_name as asa_name
FROM top_asa
INNER JOIN time_line
ON top_asa.block_id = time_line.block_id
INNER JOIN asset_names
ON top_asa.asset_id = asset_names.asset_id
where day>'2022-02-01'
Run a query to Download Data