headitmanagerstaking amounts
    Updated 2022-04-27
    SELECT SUM(ASSET_AMOUNT/POW(10,6)),t2.BLOCK_TIMESTAMP::DATE
    FROM algorand.transactions as T1
    INNER JOIN algorand.asset_transfer_transaction as T2
    ON T1.tx_group_id=T2.tx_group_id
    WHERE
    TRY_BASE64_DECODE_STRING(T1.tx_message:txn:apaa[0]::STRING) = 'S' AND T2.ASSET_ID=571576867
    GROUP BY 2
    Run a query to Download Data