AlishASA Asset Transfers
    Updated 2022-04-17
    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