piperJUP Staking - v2 sw v2 copy
    Updated 2024-11-28

    SELECT DISTINCT
    di.signers
    FROM
    solana.core.fact_decoded_instructions di,
    LATERAL FLATTEN(input => di.signers) s
    WHERE
    di.program_id = 'voTpe3tHQ7AjQHMapgSue2HJFAh2cGsdokqN3XqmVSj'
    AND s.value::string = '2yxE6DfmdzRjv9NLCQFkUJGPLrYnvc2tkJKrcMoF4e5h'
    AND di.event_type IN (
    'mergePartialUnstaking',
    'openPartialUnstaking',
    'increaseLockedAmount',
    'toggleMaxLock',
    'newEscrow',
    'withdraw',
    'withdrawPartialUnstaking'
    )

    QueryRunArchived: QueryRun has been archived