nitsDaily Senders
    Updated 2022-04-09
    with top_10_assets as
    (SELECT asset_id as aid , count(DISTINCT sender) as unique_senders from algorand.asset_transfer_transaction
    where block_timestamp >= '2022-02-01'
    GROUP by 1
    ORDER by 2 desc
    limit 10 ),
    daily_senders as
    (SELECT date(block_timestamp) as day, asset_id as aid ,count(DISTINCT sender) as unique_senders from algorand.asset_transfer_transaction
    where asset_id in (SELECT aid from top_10_assets)
    and block_timestamp >= '2022-02-01'
    GROUP by 1,2 )
    SELECT day,asset_name, unique_senders from daily_senders
    inner join algorand.asset
    on aid = asset_id
    Run a query to Download Data