| LIQUIDITY_POOL_ID | TEXT | Unique identifier for a liquidity pool. There cannot be duplicate pools for the same asset pair. Once a pool has been created for the asset pair, another cannot be created. |
| CLOSED_AT | TIMESTAMP_NTZ | Timestamp when the ledger was closed and committed to the network. Ledgers are expected to close ~every 5 seconds. |
| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | |
| TYPE | TEXT | The mechanism that calculates pricing and division of shares for the pool. With the initial AMM rollout, the only type of liquidity pool allowed to be created is a constant product pool. |
| FEE | NUMBER | The number of basis points charged as a percentage of the trade in order to complete the transaction. The fees earned on all trades are divided amongst pool shareholders and distributed as an incentive to keep money in the pools. |
| TRUSTLINE_COUNT | NUMBER | Total number of accounts with trustlines authorized to the pool. To create a trustline, an account must trust both base assets before trusting a pool with the asset pair. |
| POOL_SHARE_COUNT | FLOAT | Participation in a liquidity pool is represented by a pool share. |
| ASSET_A_TYPE | TEXT | The identifier for type of asset code, can be an alphanumeric with 4 characters, 12 characters or the native asset to the network, XLM. |
| ASSET_A_CODE | TEXT | The 4 or 12 character code representation of the asset on the network. |
| ASSET_A_ISSUER | TEXT | The account address of the original asset issuer that created the asset. |
| ASSET_A_ID | NUMBER | The Farm Hash encoding of Asset Code + Asset Issuer + Asset Type. This field is optimized for cross table joins since integer joins are less expensive than the original asset id components. |
| ASSET_A_AMOUNT | FLOAT | The raw number of tokens locked in the pool for one of the two asset pairs in the liquidity pool. |
| ASSET_B_TYPE | TEXT | The identifier for type of asset code, can be an alphanumeric with 4 characters, 12 characters or the native asset to the network, XLM. |
| ASSET_B_CODE | TEXT | The 4 or 12 character code representation of the asset on the network. |
| ASSET_B_ISSUER | TEXT | The account address of the original asset issuer that created the asset. |
| ASSET_B_ID | NUMBER | The Farm Hash encoding of Asset Code + Asset Issuer + Asset Type. This field is optimized for cross table joins since integer joins are less expensive than the original asset id components. |
| ASSET_B_AMOUNT | FLOAT | The raw number of tokens locked in the pool for one of the two asset pairs in the liquidity pool. |
| LAST_MODIFIED_LEDGER | NUMBER | The ledger sequence number when the ledger entry was last modified. Deletions do not count as a modification and will report the prior modification sequence number. |
| LEDGER_ENTRY_CHANGE | NUMBER | Code that describes the ledger entry change type that was applied to the ledger entry. |
| DELETED | BOOLEAN | Indicates whether the ledger entry (account, claimable balance, trust line, offer, liquidity pool) has been deleted or not. Once an entry is deleted, it cannot be recovered. |
| BATCH_ID | TEXT | String representation of the run id for a given DAG in Airflow. Takes the form of “scheduled__<batch_end_date>-<dag_alias>”. Batch ids are unique to the batch and help with monitoring and rerun capabilities. |
| BATCH_RUN_DATE | TIMESTAMP_NTZ | The start date for the batch interval. When taken with the date in the batch_id, the date represents the interval of ledgers processed. The batch run date can be seen as a proxy of closed_at for a ledger. |
| BATCH_INSERT_TS | TIMESTAMP_NTZ | The timestamp in UTC when a batch of records was inserted into the database. This field can help identify if a batch executed in real time or as part of a backfill. The timestamp should not be used during ad hoc analysis and is useful for data engineering purposes. |
| LEDGER_SEQUENCE | NUMBER | The sequence number of the ledger. |
| FACT_LIQUIDITY_POOLS_ID | TEXT | Unique primary key for the dimension table, used as the main identifier for each record. |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | Timestamp when this record was inserted. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | Timestamp when this record was last modified. |
