nitsDaily Senders
Updated 2022-04-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
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