One table of the PancakeSwap dataset — sliced from the unified archive by ix_name = 'CreatePool', coverage ≈ jun 2025 → jun 2026. Buying the dataset includes this table and all 27 others.
Payload columns · 15documented from the program IDL · schema v1.0
| Column | Type | Tags | Description |
|---|---|---|---|
| pool_creator | pubkey | accountsignerwritable | payload account |
| amm_config | pubkey | account | payload account |
| pool_state | pubkey | accountwritable | payload account |
| token_mint0 | pubkey | account | payload account |
| token_mint1 | pubkey | account | payload account |
| token_vault0 | pubkey | accountwritable | payload account |
| token_vault1 | pubkey | accountwritable | payload account |
| observation_state | pubkey | accountwritable | payload account |
| tick_array_bitmap | pubkey | accountwritable | payload account |
| token_program0 | pubkey | account | payload account |
| token_program1 | pubkey | account | payload account |
| system_program | pubkey | account | payload account |
| rent | pubkey | account | payload account |
| sqrt_price_x64 | u128 | arg | payload argument |
| open_time | u64 | 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