DevJacobihow-many-transactions-happen-with-these-asas
    Updated 2022-09-20
    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