AlishASA Asset Transfers
Updated 2022-04-17
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
SELECT
to_date(block_timestamp) as date,
asset.asset_name,
count(asset_transferred) as total_assets,
row_number () over (partition by date ORDER BY total_assets desc ) as rank
from algorand.asset_transfer_transaction asset_transfer JOIN algorand.asset asset on asset_transfer.asset_transferred = asset.asset_id
where date >= '2022-02-01' and date < CURRENT_DATE - 1
group by date, asset_transfer.asset_transferred, asset.asset_name qualify rank <= 10;
-- select * from algorand.asset_transfer_transaction limit 10;
-- SELECT to_date(block_timestamp) AS DATE, asset_transferred, COUNT(asset_id) AS total_assets FROM algorand.asset_transfer_transaction
-- WHERE date >= '2022-02-01' AND date <= CURRENT_DATE - 1 GROUP BY date, asset_transferred order by total_assets desc LIMIT 10;
Run a query to Download Data