_str
columns are numeric fields cast varchar
to retain precision when summing.
Unique Key: unique_id
Column | Description |
---|---|
project | The project (decentralized exchange) of the liquidity pool. |
protocol | DEX protocol (& version, if applicable) of the contract address. |
liquidity_pool_address | The address of the liquidity pool. |
transaction_module | The module name where the pool creation event occurred. |
package_id | The package ID containing the pool creation logic. |
package_event_address | The event address within the package. |
token0_address | The address of the first token in the pool. |
token0_name | The name of the first token in the pool. |
token0_symbol | The symbol of the first token in the pool. |
token0_decimals | The decimal places of the first token in the pool. |
token1_address | The address of the second token in the pool. |
token1_name | The name of the second token in the pool. |
token1_symbol | The symbol of the second token in the pool. |
token1_decimals | The decimal places of the second token in the pool. |
tokens_array | Array containing the tokens in the pool. |
tick_spacing | The tick spacing configuration for the pool. |
transaction_block_digest | Digest of the transaction block containing this pool creation. |
event_seq | Sequence number of the event within the transaction. |
checkpoint_timestamp | Timestamp of the checkpoint containing this pool creation. |
checkpoint_sequence | Sequence number of the checkpoint. |
checkpoint_digest | Digest of the checkpoint. |
_created_at | Timestamp when the record was created. |
_updated_at | Timestamp when the record was last updated. |
date_added | Timestamp when the record was added to the dataset. |