with mint_stake AS (

SELECT

tx_hash,

(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::StakeEvent'

),

apt AS (

block_number,

block_timestamp,

version,

tx_hash,

tx_type,

event_resource,

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

'Amnis' AS platform_name,

event_data:amount_added AS apt_amount_unadj,

event_data:amount_added /POW(10,8) AS apt_amount,

event_data:pool_address AS pool_address

FROM aptos.core.fact_events

WHERE payload_function = '0x111ae3e5bc816a5e63c2da97d0aa3886519e0cd5e4b046659fa35796bd11542a::router::deposit_and_stake_entry' -- Amnis mint and stake payload function

AND event_resource = 'AddStakeEvent'

AND event_module = 'stake'

),

txs AS (

SELECT tx_hash, sender AS staker

FROM aptos.core.fact_transactions