LTirrell1. Most Popular ASAs -- added asset transactions
Updated 2022-01-10
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
›
⌄
-- - What are the most popular ASAs on Algorand?
-- - How many wallets are holding each ASA?
-- - How many transactions happen with these ASAs?
-- - How have these stats changed over time?
WITH info AS (
SELECT
asset_name,
round(asset_added_at :: number, -4) as blocks,
count(address) as addresses
FROM
algorand.account_asset
WHERE
asset_name in (
'YouNow Pending Props',
'Camfrog Pending Props',
'Paltalk Pending Props',
'Tether USDt',
'USDC',
'Opulous',
'Buy Token',
'Listia Pending Props',
'Yieldly',
'PLANET'
)
GROUP BY
blocks,
asset_name
),
datetime_info AS (
SELECT
block_id,
block_timestamp
FROM
Run a query to Download Data