One table of the PancakeSwap dataset — sliced from the unified archive by ix_name = 'OpenPositionV2', coverage ≈ jun 2025 → jun 2026. Buying the dataset includes this table and all 27 others.
Payload columns · 31documented from the program IDL · schema v1.0
| Column | Type | Tags | Description |
|---|---|---|---|
| payer | pubkey | accountsignerwritable | payload account |
| position_nft_owner | pubkey | account | payload account |
| position_nft_mint | pubkey | accountsignerwritable | payload account |
| position_nft_account | pubkey | accountwritable | payload account |
| metadata_account | pubkey | accountwritable | payload account |
| pool_state | pubkey | accountwritable | payload account |
| protocol_position | pubkey | accountwritable | payload account |
| tick_array_lower | pubkey | accountwritable | payload account |
| tick_array_upper | pubkey | accountwritable | payload account |
| personal_position | pubkey | accountwritable | payload account |
| token_account0 | pubkey | accountwritable | payload account |
| token_account1 | pubkey | accountwritable | payload account |
| token_vault0 | pubkey | accountwritable | payload account |
| token_vault1 | pubkey | accountwritable | payload account |
| rent | pubkey | account | payload account |
| system_program | pubkey | account | payload account |
| token_program | pubkey | account | payload account |
| associated_token_program | pubkey | account | payload account |
| metadata_program | pubkey | account | payload account |
| token_program2022 | pubkey | account | payload account |
| vault0_mint | pubkey | account | payload account |
| vault1_mint | pubkey | account | payload account |
| tick_lower_index | i32 | arg | payload argument |
| tick_upper_index | i32 | arg | payload argument |
| tick_array_lower_start_index | i32 | arg | payload argument |
| tick_array_upper_start_index | i32 | arg | payload argument |
| liquidity | u128 | arg | payload argument |
| amount0_max | u64 | arg | payload argument |
| amount1_max | u64 | arg | payload argument |
| with_metadata | bool | arg | payload argument |
| base_flag | Option<bool> | 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