block_number,

block_timestamp,

version,

tx_hash,

event_data:account AS sender,

success,

tx_type,

payload_function,

split_part(payload_function,'::',1) AS platform_address,

'Thala' AS platform_name,

event_index,

event_type,

event_module,

event_resource,

event_data:sthAPT_burnt AS sthapt_amount_unadj,

event_data:sthAPT_burnt/pow(10,8) AS sthapt_amount,

event_data:thAPT_unstaked AS thapt_amount_unadj,

event_data:thAPT_unstaked/pow(10,8) AS thapt_amount,

event_data

FROM aptos.core.fact_events

WHERE event_resource = 'UnstakeThalaAPTEvent'

AND payload_function = '0xfaf4e633ae9eb31366c9ca24214231760926576c7b625313b3688b5e900731f6::scripts::unstake_thAPT' -- thala unstake payload function

LIMIT 100