One table of the Orca Whirlpool dataset — sliced from the unified archive by ix_name = 'TwoHopSwap', coverage apr 2024 → jun 2026. Buying the dataset includes this table and all 66 others.
Payload columns · 28documented from the program IDL · schema v1.0
| Column | Type | Tags | Description |
|---|---|---|---|
| token_program | pubkey | account | payload account |
| token_authority | pubkey | accountsigner | payload account |
| whirlpool_one | pubkey | accountwritable | payload account |
| whirlpool_two | pubkey | accountwritable | payload account |
| token_owner_account_one_a | pubkey | accountwritable | payload account |
| token_vault_one_a | pubkey | accountwritable | payload account |
| token_owner_account_one_b | pubkey | accountwritable | payload account |
| token_vault_one_b | pubkey | accountwritable | payload account |
| token_owner_account_two_a | pubkey | accountwritable | payload account |
| token_vault_two_a | pubkey | accountwritable | payload account |
| token_owner_account_two_b | pubkey | accountwritable | payload account |
| token_vault_two_b | pubkey | accountwritable | 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 | account | payload account |
| oracle_two | 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 |
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