KaskoazulSTBL staking - missing unstaking data
    Updated 2022-03-11
    SELECT
    try_base64_decode_string(act.tx_message:txn:note::string),
    act.block_timestamp::date as fecha,
    act.tx_group_id,
    act.sender,
    att.asset_amount/pow(10,6) as amount,
    att.asset_id,
    'UNSTAKE' AS Operation
    FROM
    algorand.application_call_transaction act
    INNER JOIN algorand.asset_transfer_transaction att
    ON act.tx_group_id = att.tx_group_id
    WHERE
    act.app_id = 482608867
    Run a query to Download Data