with unstake AS (

SELECT

tx_hash,

event_resource,

(event_data:amapt) AS amapt_amount_unadj,

(event_data:amapt)/pow(10,8) AS amapt_amount,

(event_data:stapt) AS stapt_amount_unadj,

(event_data:stapt)/pow(10,8) AS stapt_amount

FROM aptos.core.fact_events

WHERE event_address = '0x111ae3e5bc816a5e63c2da97d0aa3886519e0cd5e4b046659fa35796bd11542a' -- Amnis contract address

AND event_type = '0x111ae3e5bc816a5e63c2da97d0aa3886519e0cd5e4b046659fa35796bd11542a::router::UnstakeEvent'

SELECT

block_number,

block_timestamp,

version,

t.tx_hash,

tx_type,

event_resource,

sender AS staker,

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

'Amnis' AS platform_name,

amapt_amount_unadj,

amapt_amount,

stapt_amount_unadj,

stapt_amount

FROM aptos.core.fact_transactions t

INNER JOIN unstake u ON t.tx_hash = u.tx_hash

WHERE payload_function = '0x111ae3e5bc816a5e63c2da97d0aa3886519e0cd5e4b046659fa35796bd11542a::router::unstake_entry' -- Amnis unstake payload function

LIMIT 100