freemartianTortuga Unstake Instantly
    Updated 2024-07-10
    SELECT
    block_number,
    block_timestamp,
    version,
    tx_hash,
    success,
    event_data:sender_addr AS staker,
    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:out_au AS apt_amount_unadj,
    event_data:out_au/pow(10,8) AS apt_amount,
    event_data:in_au AS tapt_amount_unadj,
    event_data:in_au/pow(10,8) AS tapt_amount

    FROM aptos.core.fact_events
    WHERE event_type = '0xbd35135844473187163ca197ca93b2ab014370587bb0ed3befff9e902d6bb541::amm::SwapEvent'
    AND event_data:in_coin_type = '0x84d7aeef42d38a5ffc3ccef853e1b82e4958659d16a7de736a29c55fbbeb0114::staked_aptos_coin::StakedAptosCoin'

    ORDER BY 2 DESC
    LIMIT 100










    QueryRunArchived: QueryRun has been archived