One table of the Orca Whirlpool dataset — sliced from the unified archive by ix_name = 'SwapV2', coverage apr 2024 → jun 2026. Buying the dataset includes this table and all 66 others.
Payload columns · 22documented from the program IDL · schema v1.0
| Column | Type | Tags | Description |
|---|---|---|---|
| token_program_a | pubkey | account | payload account |
| token_program_b | pubkey | account | payload account |
| memo_program | pubkey | account | payload account |
| token_authority | pubkey | accountsigner | payload account |
| whirlpool | pubkey | accountwritable | payload account |
| token_mint_a | pubkey | account | payload account |
| token_mint_b | pubkey | account | payload account |
| token_owner_account_a | pubkey | accountwritable | payload account |
| token_vault_a | pubkey | accountwritable | payload account |
| token_owner_account_b | pubkey | accountwritable | payload account |
| token_vault_b | pubkey | accountwritable | payload account |
| tick_array0 | pubkey | accountwritable | payload account |
| tick_array1 | pubkey | accountwritable | payload account |
| tick_array2 | pubkey | accountwritable | payload account |
| oracle | pubkey | accountwritable | payload account |
| whirlpool_program | pubkey | account | payload account |
| amount | u64 | arg | payload argument |
| other_amount_threshold | u64 | arg | payload argument |
| sqrt_price_limit | u128 | arg | payload argument |
| amount_specified_is_input | bool | arg | payload argument |
| a_to_b | bool | 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