One table of the Orca Whirlpool dataset — sliced from the unified archive by ix_name = 'TwoHopSwapV2', coverage apr 2024 → jun 2026. Buying the dataset includes this table and all 66 others.
Payload columns · 33documented from the program IDL · schema v1.0
| Column | Type | Tags | Description |
|---|---|---|---|
| whirlpool_one | pubkey | accountwritable | payload account |
| whirlpool_two | pubkey | accountwritable | payload account |
| token_mint_input | pubkey | account | payload account |
| token_mint_intermediate | pubkey | account | payload account |
| token_mint_output | pubkey | account | payload account |
| token_program_input | pubkey | account | payload account |
| token_program_intermediate | pubkey | account | payload account |
| token_program_output | pubkey | account | payload account |
| token_owner_account_input | pubkey | accountwritable | payload account |
| token_vault_one_input | pubkey | accountwritable | payload account |
| token_vault_one_intermediate | pubkey | accountwritable | payload account |
| token_vault_two_intermediate | pubkey | accountwritable | payload account |
| token_vault_two_output | pubkey | accountwritable | payload account |
| token_owner_account_output | pubkey | accountwritable | payload account |
| token_authority | pubkey | accountsigner | payload account |
| tick_array_one0 | pubkey | accountwritable | payload account |
| tick_array_one1 | pubkey | accountwritable | payload account |
| tick_array_one2 | pubkey | accountwritable | payload account |
| tick_array_two0 | pubkey | accountwritable | payload account |
| tick_array_two1 | pubkey | accountwritable | payload account |
| tick_array_two2 | pubkey | accountwritable | payload account |
| oracle_one | pubkey | accountwritable | payload account |
| oracle_two | pubkey | accountwritable | payload account |
| memo_program | pubkey | account | payload account |
| whirlpool_program | pubkey | account | payload account |
| amount | u64 | arg | payload argument |
| other_amount_threshold | u64 | arg | payload argument |
| amount_specified_is_input | bool | arg | payload argument |
| a_to_b_one | bool | arg | payload argument |
| a_to_b_two | bool | arg | payload argument |
| sqrt_price_limit_one | u128 | arg | payload argument |
| sqrt_price_limit_two | u128 | arg | payload argument |
| remaining_accounts_info | Option<struct { slices: Vec<struct { accounts_type: enum(transferHookA, transferHookB, transferHookReward, transferHookInput, transferHookIntermediate, transferHookOutput, supplementalTickArrays, supplementalTickArraysOne, ...), length: u8 }> }> | arg | payload argument |
Physical schema · every delivered filefooter-verified
| Column | Type | Description |
|---|---|---|
| slot | u64 | Solana slot number |
| tx_index | u32 | transaction index in block |
| ix_index | u32 | top-level instruction index |
| inner_index | u32 | inner-instruction index |
| stack_height | u32 | CPI stack depth |
| is_inner | bool | true for inner (CPI) instructions |
| is_vote | bool | vote transaction flag |
| success | bool | transaction succeeded (failed txs included) |
payload above ships inside the json column · failed txs included & flagged