freemartianTortuga Stake
    Updated 2024-07-10
    SELECT
    block_number,
    block_timestamp,
    version,
    tx_hash,
    event_data:delegator AS staker,
    success,
    tx_type,
    payload_function,
    split_part(payload_function,'::',1) AS platform_address,
    'Tortuga' AS platform_name,
    event_type,
    event_address,
    event_module,
    event_resource,
    event_data,
    event_data:amount AS apt_amount_unadj,
    event_data:amount/pow(10,8) AS apt_amount,
    event_data:t_apt_coins AS tapt_amount_unadj,
    event_data:t_apt_coins/pow(10,8) AS tapt_amount,
    FROM aptos.core.fact_events
    WHERE event_type = '0x8f396e4246b2ba87b51c0739ef5ea4f26515a98375308c31ac2ec1e42142a57f::stake_router::StakeEvent'
    ORDER BY 2 DESC
    LIMIT 100