DevJacobihow-many-transactions-happen-with-these-asas
Updated 2022-09-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with popular_asas as (
select TOP 10 asset.asset_id, count(asset.asset_id) as transactions_total from algorand.asset_transfer_transaction att
join algorand.asset asset on att.asset_id = asset.asset_id
where asset.asset_deleted = false
group by asset.asset_id
order by count(asset.asset_id) desc
),
total_transactions as (
select popular_asas.asset_id, date(transactions.block_timestamp) as date, count(popular_asas.asset_id, date(transactions.block_timestamp)) as total_transactions
from popular_asas join flipside_prod_db.algorand.transactions transactions on popular_asas.asset_id = transactions.asset_id
group by popular_asas.asset_id, date(transactions.block_timestamp)
),
assets as (select * from flipside_prod_db.algorand.asset a)
select asset_name, date, total_transactions from total_transactions t join assets a on t.asset_id = a.asset_id
Run a query to Download Data