One table of the OpenBook V2 dataset — sliced from the unified archive by ix_name = 'PlaceOrders', coverage apr 2024 → jun 2026. Buying the dataset includes this table and all 30 others.
Payload columns · 18documented from the program IDL · schema v1.0
| Column | Type | Tags | Description |
|---|---|---|---|
| signer | pubkey | accountsigner | payload account |
| open_orders_account | pubkey | accountwritable | payload account |
| open_orders_admin | pubkey | accountsigneroptional | payload account |
| user_quote_account | pubkey | accountwritable | payload account |
| user_base_account | pubkey | accountwritable | payload account |
| market | pubkey | accountwritable | payload account |
| bids | pubkey | accountwritable | payload account |
| asks | pubkey | accountwritable | payload account |
| event_heap | pubkey | accountwritable | payload account |
| market_quote_vault | pubkey | accountwritable | payload account |
| market_base_vault | pubkey | accountwritable | payload account |
| oracle_a | pubkey | accountoptional | payload account |
| oracle_b | pubkey | accountoptional | payload account |
| token_program | pubkey | account | payload account |
| orders_type | enum(limit, immediateOrCancel, postOnly, market, postOnlySlide) | arg | payload argument |
| bids | Vec<struct { price_lots: i64, max_quote_lots_including_fees: i64, expiry_timestamp: u64 }> | arg | payload argument |
| asks | Vec<struct { price_lots: i64, max_quote_lots_including_fees: i64, expiry_timestamp: u64 }> | arg | payload argument |
| limit | 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