> ## Documentation Index > Fetch the complete documentation index at: https://docs.allium.so/llms.txt > Use this file to discover all available pages before exploring further. # Schemas > Available prediction market schemas and table columns for Polymarket, Kalshi, and Solana projects. ## Available Tables ### Polymarket (Polygon) | **Polygon Prediction Market Tables** | **Schema** | | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | --------------------- | | • [trades](/historical-data/supported-blockchains/evm/polygon/predictions/trades)
• [trades\_enriched](/historical-data/supported-blockchains/evm/polygon/predictions/trades-enriched)
• [markets](/historical-data/supported-blockchains/evm/polygon/predictions/markets)
• [token\_prices\_daily](/historical-data/supported-blockchains/evm/polygon/predictions/token-prices-daily)
• [user\_actions](/historical-data/supported-blockchains/evm/polygon/predictions/user-actions)
• [wallets](/historical-data/supported-blockchains/evm/polygon/predictions/wallets)
• [user\_positions\_daily](/historical-data/supported-blockchains/evm/polygon/predictions/user-positions-daily)
• [open\_interest\_daily](/historical-data/supported-blockchains/evm/polygon/predictions/open-interest-daily)
• [market\_orderbook](/historical-data/supported-blockchains/evm/polygon/predictions/market-orderbook)
• [builder\_code](/historical-data/supported-blockchains/evm/polygon/predictions/builder-code) | `polygon.predictions` | ### Solana (Jupiter, DFlow, World) | **Solana Prediction Market Tables** | **Schema** | | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | -------------------- | | • [trades](/historical-data/supported-blockchains/solana/solana/predictions/trades)
• [trades\_enriched](/historical-data/supported-blockchains/solana/solana/predictions/trades-enriched)
• [kalshi\_markets](/historical-data/supported-blockchains/solana/solana/predictions/kalshi-markets) | `solana.predictions` | ### Kalshi (Centralized) | **Kalshi Prediction Market Tables** | **Schema** | | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | -------------------- | | • [trades](/historical-data/predictions/kalshi/trades)
• [trades\_enriched](/historical-data/predictions/kalshi/trades-enriched)
• [markets](/historical-data/predictions/kalshi/markets)
• [events](/historical-data/predictions/kalshi/events)
• [series](/historical-data/predictions/kalshi/series)
• [series\_fee\_changes](/historical-data/predictions/kalshi/series-fee-changes)
• [candlesticks\_hourly](/historical-data/predictions/kalshi/candlesticks-hourly)
• [open\_interest\_daily](/historical-data/predictions/kalshi/open-interest-daily)
• [market\_orderbook](/historical-data/predictions/kalshi/market-orderbook) | `common.predictions` | ### Crosschain | **Crosschain Prediction Market Tables** | **Schema** | | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------ | | • [markets](/historical-data/predictions/crosschain/markets)
• [trades](/historical-data/predictions/crosschain/trades)
• [open\_interest\_daily](/historical-data/predictions/crosschain/open-interest-daily)
• [metrics\_daily](/historical-data/predictions/crosschain/metrics-daily) | `crosschain.predictions` | ## Table Columns ### Polymarket Columns | Column Name | Description | | --------------------------- | ---------------------------------------------------------------- | | event\_name | Type of prediction market event (OrderFilled, FPMMBuy, FPMMSell) | | project | Name of the project (e.g., Polymarket) | | protocol | Protocol name (e.g., polymarket) | | exchange\_type | Exchange type (CTFExchange, NegRiskCTFExchange, FPMM) | | condition\_id | Unique identifier for the event condition | | market\_address | Address of the prediction market contract | | order\_hash | Unique hash of the order (null for FPMM trades) | | maker | Address of the maker (order creator) in the trade | | taker | Address of the taker (order fulfiller) in the trade | | asset\_id | Asset/token ID of the outcome token being traded | | collateral\_amount\_raw | Raw unnormalized collateral amount | | token\_amount\_raw | Raw unnormalized outcome token amount | | price\_str | Share price as a precise string representation | | price | Share price as a float | | trade\_price | Share price as float | | maker\_amount\_raw | Raw unnormalized amount from maker side | | taker\_amount\_raw | Raw unnormalized amount from taker side | | fee\_raw | Raw unnormalized fee amount | | collateral\_amount | Collateral amount | | fee\_amount | Fee amount | | collateral\_token\_address | Address of the collateral token | | collateral\_token\_name | Name of the collateral token | | collateral\_token\_symbol | Symbol of the collateral token (USDC, USDC.e) | | collateral\_token\_decimals | Number of decimals for the collateral token | | usd\_exchange\_rate | USD exchange rate for the collateral token | | usd\_collateral\_amount | USD value of the collateral amount | | usd\_fee\_amount | USD value of the fee paid in the trade | | transaction\_hash | Hash of the transaction containing the trade | | transaction\_index | Index of the transaction in the block | | log\_index | Index of the log within the transaction | | block\_timestamp | Timestamp of the block containing the trade | | block\_number | Block number containing the trade | | block\_hash | Hash of the block containing the trade | | unique\_id | Unique identifier for each trade | | Column Name | Description | | ---------------------------- | ---------------------------------------------- | | market\_unique\_id | Unique key for grouping related markets | | market\_id | Market identifier from onchain data | | market\_request\_id | NegRisk market request ID | | market\_name | Market name from onchain data | | market\_description\_onchain | Market description from onchain events | | question\_id | Unique question identifier | | question | Market question text | | description | Market description from API | | token\_id | Token ID for this outcome | | token\_outcome | Token outcome name (Yes/No) | | token\_outcome\_name | Combined outcome and question name | | token\_name | Combined outcome and question name | | token\_price | Current token price | | is\_winner | Whether this outcome won | | is\_winning\_outcome | Whether this outcome won the market | | active | Whether market is active | | archived | Whether market is archived | | closed | Whether market is closed | | accepting\_orders | Whether accepting new orders | | enable\_order\_book | Whether order book is enabled | | neg\_risk | Whether this is a NegRisk market | | resolved\_by | Entity responsible for resolution | | category | Main category (politics, sports, crypto, etc.) | | sub\_category | Specific subcategory | | tags | Original category tokens from API | | api\_category | Original category from API | | api\_type | Data source type | | start\_date | Market start time | | end\_date | Market end time | | game\_start\_time | Event start time | | seconds\_delay | Resolution delay in seconds | | fpmm | FPMM contract address | | maker\_fee | Maker fee | | taker\_fee | Taker fee | | oracle | Oracle contract address | | fee\_bips | Fee in basis points | | prepared\_at | Market preparation timestamp | | outcome | Resolution outcome | | resolved\_at | Resolution timestamp | | created\_at | API record creation time | | updated\_at | API record update time | | Column Name | Description | | ------------------------- | ------------------------------------------------------- | | address | User wallet address holding the position | | wallet\_address | Address of the created wallet | | factory\_address | Address of the factory contract that created the wallet | | creation\_type | Type of wallet creation (MagicLink or GnosisSafe) | | wallet\_type | Wallet type description | | action | Type of action (deposit, withdrawal, transfer, convert) | | from\_wallet\_type | Wallet creation type of sender | | to\_wallet\_type | Wallet creation type of receiver | | from\_wallet\_description | Human-readable description of sender wallet type | | to\_wallet\_description | Human-readable description of receiver wallet type | | from\_address | Address sending the tokens | | to\_address | Address receiving the tokens | | token\_address | Address of the token being transferred | | token\_name | Name of the token being transferred | | token\_symbol | Symbol of the token being transferred (USDC or USDC.e) | | raw\_amount\_str | Raw token amount as string | | raw\_amount | Raw token amount as float | | amount\_str | Normalized token amount as string | | amount | Normalized token amount as float | | usd\_amount | USD value of the token amount | | token\_balance | Number of outcome tokens held | | open\_interest | Number of outcome tokens held (position size) | | open\_interest\_usd | USD value of the open interest position | | day | Date of the snapshot | | unique\_id | Unique identifier for the position | | market\_active | Whether market is currently active | | market\_closed | Whether market is closed | | market\_accepting\_orders | Whether market is accepting new orders | | Column Name | Description | | ------------------ | ---------------------------------------- | | project | Project identifier, always 'polymarket' | | protocol | Protocol identifier, always 'polymarket' | | order\_date | Date of the orderbook snapshot | | market\_unique\_id | Unique key for grouping related markets | | condition\_id | Unique condition identifier | | market\_question | Market question text | | token\_id | Token ID for this outcome | | token\_name | Combined outcome and question name | | token\_outcome | Token outcome name | | side | Orderbook side (bid or ask) | | price | Price level in dollars | | quantity | Quantity at this price level | | tick\_size | Minimum price increment (tick size) | | neg\_risk | Whether this is a NegRisk market | | min\_order\_size | Minimum order size in dollars | | orderbook\_hash | Hash of the orderbook state | | order\_timestamp | Timestamp of the orderbook snapshot | | ingested\_at | Data ingestion timestamp | | unique\_key | Unique record key | | Column Name | Description | | ------------- | -------------------------------------------------- | | project | Project name (polymarket) | | protocol | Protocol name (polymarket) | | date | Date of the volume data | | builder\_name | Name of the builder | | builder\_logo | URL to the builder's logo | | is\_verified | Whether the builder is verified | | volume\_usd | Trading volume in USD for the day | | active\_users | Number of active users for the builder on this day | | daily\_rank | Builder rank for the day | | \_created\_at | Record creation timestamp | | \_updated\_at | Record update timestamp | *** ### Solana Columns | Column Name | Description | | ------------------------ | -------------------------------------------------------------------------------------------------------- | | project | Project identifier (jupiter, dflow, or world) | | protocol | Protocol identifier (kalshi, polymarket, or world) | | trade\_date | Date of the trade execution | | timestamp | Timestamp when the trade executed on-chain | | trade\_id | Unique identifier for the trade (venue order ID) | | ticker | Market ticker identifier (e.g., KXFEDDECISION-25DEC-C25). On-chain market address for World rows | | num\_contracts | Number of contracts filled in this trade | | user\_address | Solana wallet address of the user who placed the order | | action | Trade action (buy or sell) | | taker\_side | Side taken by the taker (yes or no) | | maker\_side | Side taken by the maker (opposite of taker\_side) | | yes\_price | YES outcome price at execution, on a 0-1 scale. yes\_price + no\_price = 1 | | no\_price | NO outcome price at execution, on a 0-1 scale. yes\_price + no\_price = 1 | | taker\_price | Execution price paid by the taker for their side, on a 0-1 scale | | settlement\_token\_price | Settlement token USD price at trade time (USDC, JupUSD, or CASH depending on project) | | venue\_fee\_usd | Venue fee paid in USD | | order\_created\_time | Timestamp when the order was created on-chain. Null for World, which has no separate order-creation step | | order\_txn\_id | Transaction signature of the order-creation transaction. Null for World | | fill\_txn\_id | Transaction signature of the fill transaction | | extras | Platform-specific metadata for the trade | | \_created\_at | Record creation timestamp | | \_updated\_at | Record update timestamp | | Column Name | Description | | ---------------------------------- | -------------------------------------------------------------------------------------------------------- | | project | Project identifier (jupiter, dflow, or world) | | protocol | Protocol identifier (kalshi, polymarket, or world) | | trade\_date | Date of the trade execution | | timestamp | Timestamp when the trade executed on-chain | | trade\_id | Unique identifier for the trade (venue order ID) | | ticker | Market ticker identifier. On-chain market address for World rows | | num\_contracts | Number of contracts filled | | user\_address | Solana wallet address of the trader | | action | Trade action (buy or sell) | | taker\_side | Side taken by the taker (yes or no) | | maker\_side | Side taken by the maker | | yes\_price | YES outcome price at execution, on a 0-1 scale. yes\_price + no\_price = 1 | | no\_price | NO outcome price at execution, on a 0-1 scale. yes\_price + no\_price = 1 | | taker\_price | Execution price paid by the taker for their side, on a 0-1 scale | | settlement\_token\_price | Settlement token USD price at trade time (USDC, JupUSD, or CASH depending on project) | | venue\_fee\_usd | Venue fee paid in USD | | market\_event\_id | Event identifier for the market | | market\_name | Market name | | market\_question | Market question text | | market\_description | Market description | | is\_mve | True for multi-variable event markets | | market\_category | Market category classification | | market\_sub\_category | Polymarket sub-category. Populated for Polymarket markets; null for Kalshi, DFlow, and World | | market\_status | Current status of the market. World markets report active or settled | | market\_start\_date | Market opening timestamp | | market\_end\_date | Market closing timestamp | | market\_expected\_expiration\_time | Expected expiration timestamp | | market\_expiration\_time | Actual expiration timestamp | | market\_outcome | Market outcome resolution | | market\_resolved\_at | Market resolution timestamp | | order\_created\_time | Timestamp when the order was created on-chain. Null for World, which has no separate order-creation step | | order\_txn\_id | Transaction signature of the order-creation transaction. Null for World | | fill\_txn\_id | Transaction signature of the fill transaction | | extras | Platform-specific metadata for the trade | | \_created\_at | Record creation timestamp | | \_updated\_at | Record update timestamp | | Column Name | Description | | --------------------------- | ----------------------------------------------------------------- | | project | Project identifier, always 'jupiter' | | protocol | Protocol identifier, always 'kalshi' | | market\_unique\_id | Unique identifier for the Kalshi market ticker | | market\_event\_id | Event identifier that groups related markets | | market\_series\_id | Series ticker identifier for the event | | market\_mve\_id | Multi-variable event (MVE) collection ticker | | is\_mve | True for multi-variable event markets | | market\_name | Market title describing the prediction question | | question\_id | Question identifier | | question | Question text from the event | | description | Market description | | last\_token\_price | Last traded price as a float (0-1 scale) | | market\_status | Current status (active, open, closed, finalized, settled) | | active | Boolean flag indicating if the market is active or open | | closed | Boolean flag indicating if closed, finalized, or settled | | accepting\_orders | Boolean flag indicating if currently accepting orders | | category | Category classification of the market | | start\_date | Timestamp when the market opened for trading | | end\_date | Timestamp when the market closes for trading | | expected\_expiration\_time | Expected timestamp for market expiration | | expiration\_time | Actual expiration timestamp of the market | | latest\_expiration\_time | Latest possible expiration timestamp | | seconds\_delay | Settlement timer in seconds | | can\_close\_early | Boolean flag indicating if the market can close before expiration | | expiration\_value | Value used to determine market settlement | | strike\_type | Type of strike price (if applicable) | | floor\_strike | Floor strike price for ranged markets | | cap\_strike | Cap strike price for ranged markets | | rules\_primary | Primary rules governing the market settlement | | rules\_secondary | Secondary rules for market settlement | | early\_close\_condition | Conditions under which the market can close early | | mve\_collection\_ticker | Multi-variable event collection ticker | | mve\_selected\_legs | Selected legs for multi-variable events | | market\_outcome\_resolution | Market outcome resolution (or 'unresolved' if still open) | | resolved\_at | Timestamp when the market was resolved | *** ### Kalshi Columns | Column Name | Description | | -------------- | ------------------------------------------------- | | project | Project identifier (kalshi) | | protocol | Protocol identifier (kalshi) | | trade\_date | Date of the trade (used for partitioning) | | created\_time | Timestamp when the trade was created | | trade\_id | Unique identifier for the trade | | ticker | Market ticker identifier for this trade | | num\_contracts | Number of contracts traded (1 contract = \$1) | | taker\_side | Side taken by the taker (yes or no) | | maker\_side | Side taken by the maker (opposite of taker\_side) | | yes\_price | Price for "yes" outcome as a float (0-1 scale) | | no\_price | Price for "no" outcome as a float (0-1 scale) | | taker\_price | Price paid by the taker based on taker\_side | | Column Name | Description | | --------------------------- | -------------------------------------------------------------------------------------------------------------- | | series\_title | Series title | | series\_category | Series category | | series\_tags | Series topic tags | | fee\_type | Fee formula in force on trade\_date | | taker\_fee\_multiplier | Taker multiplier in force on trade\_date | | maker\_fee\_multiplier | Maker multiplier in force on trade\_date. 1 when the series charges maker fees, otherwise 0 | | is\_fee\_schedule\_inferred | True when the day's multipliers use Kalshi's standard schedule because no recorded fee change covers that date | | taker\_fee\_usd | Taker trade fee in USD, rounded up to the next \$0.0001 | | maker\_fee\_usd | Maker trade fee in USD, rounded up to the next \$0.0001 | | fee\_usd | Venue trade fee in USD: taker\_fee\_usd + maker\_fee\_usd | | Column Name | Description | | --------------------------- | ----------------------------------------------------------------- | | project | Project identifier (kalshi) | | protocol | Protocol identifier (kalshi) | | market\_unique\_id | Unique identifier for the market ticker | | market\_event\_id | Event identifier that groups related markets | | market\_series\_id | Series ticker identifier for the event | | market\_mve\_id | Multi-variable event (MVE) collection ticker | | market\_name | Market title describing the prediction question | | question\_id | Question identifier | | question | Question text from the event | | description | Market description | | last\_token\_price | Last traded price as a float (0-1 scale) | | market\_status | Current status (active, open, closed, finalized, settled) | | active | Boolean flag indicating if the market is active or open | | closed | Boolean flag indicating if the market is closed/finalized/settled | | accepting\_orders | Boolean flag indicating if accepting orders | | category | Category classification of the market | | start\_date | Timestamp when the market opened for trading | | end\_date | Timestamp when the market closes for trading | | expected\_expiration\_time | Expected timestamp for market expiration | | expiration\_time | Actual expiration timestamp of the market | | latest\_expiration\_time | Latest possible expiration timestamp | | seconds\_delay | Settlement timer in seconds | | can\_close\_early | Boolean flag indicating if the market can close early | | expiration\_value | Value used to determine market settlement | | strike\_type | Type of strike price (if applicable) | | floor\_strike | Floor strike price for ranged markets | | cap\_strike | Cap strike price for ranged markets | | rules\_primary | Primary rules governing market settlement | | rules\_secondary | Secondary rules for market settlement | | early\_close\_condition | Conditions for early market closure | | mve\_collection\_ticker | Multi-variable event collection ticker | | mve\_selected\_legs | Selected legs for multi-variable events | | market\_outcome\_resolution | Market outcome resolution (or 'unresolved') | | resolved\_at | Timestamp when the market was resolved | | Column Name | Description | | ------------------------ | ------------------------------------------------------------------------- | | event\_ticker | Unique event identifier | | series\_ticker | Series ticker identifier | | category | Category classification | | title | Event title | | sub\_title | Event subtitle (MVE indicator) | | mutually\_exclusive | Boolean flag for mutually exclusive outcomes | | strike\_period | Strike period for the event | | strike\_date | Strike date for the event | | available\_on\_brokers | Boolean flag for broker availability | | collateral\_return\_type | Type of collateral return | | is\_settled | Boolean flag indicating if settled | | market\_ticker | Market ticker identifier (for candlesticks) | | period\_date | Date of the candlestick period | | start\_period\_datetime | Start timestamp of the hourly period | | end\_period\_datetime | End timestamp of the hourly period | | price\_open | Opening price for the hour | | price\_high | Highest price for the hour | | price\_low | Lowest price for the hour | | price\_close | Closing price for the hour | | volume | Trading volume for the hour | | open\_interest | Open interest at end of hour (for candlesticks) or end of day (for daily) | | day | Date of the open interest snapshot (for daily OI) | | unique\_id | Unique identifier for the record | | Column Name | Description | | ---------------- | -------------------------------------------------- | | project | Project identifier (kalshi) | | protocol | Protocol identifier (kalshi) | | order\_date | Date of the orderbook snapshot | | market\_ticker | Market ticker identifier | | side | Orderbook side (bid or ask) | | price | Price level in dollars | | quantity | Quantity (number of contracts) at this price level | | order\_timestamp | Timestamp of the orderbook snapshot | | ingested\_at | Data ingestion timestamp | | unique\_key | Unique record key |