granadohoTop 10 Assets by Number of Transfer by day
    Updated 2022-04-06
    with toplist as (
    select
    a.asset_id,
    count(distinct a.tx_group_id) as total_transfer
    from algorand.asset_transfer_transaction a
    where date(a.block_timestamp) >= '2022-02-01'
    group by 1
    order by 2 DESC
    limit 10
    )

    select
    date(a.block_timestamp) as date,
    b.asset_name,
    count(distinct a.tx_group_id) as total_transfer
    from algorand.asset_transfer_transaction a
    inner join algorand.asset b
    on a.asset_transferred = b.asset_id
    where date(a.block_timestamp) >= '2022-02-01'
    and a.asset_id in (select asset_id from toplist)
    group by 1, 2
    order by 1



    Run a query to Download Data