Osmosis
This page presents the available tables for Osmosis.
Raw Tables
This table provides a comprehensive overview of every action and occurrence within the Cosmos blockchain ecosystem. It includes detailed information about each block's transactions, enabling the analysis of the blockchain's behavior and evolution over time.
| Column Name | Type | Description |
|---|---|---|
| block_height | INTEGER | Height of the block in the blockchain, incrementing with each new block |
| block_timestamp | TIMESTAMP | Timestamp when the block was sealed and considered final |
| event_index | INTEGER | Index of events within a block, used for ordering and reference |
| event_type | STRING | Type of event occurring within a transaction or block |
| event_attributes | JSON | Associated attributes and details for the event type |
| source | STRING | Originating blockchain or network, identifies data source |
| schema_version | INTEGER | Version of the schema used to define the table structure |
| ingestion_timestamp | TIMESTAMP | Time when the data was ingested into the analytical system |
Parsed Tables
This table contains arbitrage trades executed in various pools within the Cosmos ecosystem. It tracks profitable trades executed by traders to take advantage of price discrepancies.
| Column Name | Type | Description |
|---|---|---|
| block_height | INTEGER | Block numbers indicating the progression of each block in the blockchain |
| block_timestamp | TIMESTAMP | Timestamps of all blocks listed in chronological order |
| tx_id | STRING | Unique transaction identifiers on the blockchain network |
| message_index | INTEGER | Indices of messages contained in a particular transaction |
| exec_msg_index | STRING | Indices of executed messages within a transaction |
| arb_index | INTEGER | Indices of arbitrage trades executed on the network |
| trader | STRING | Address or identifier of the account performing arbitrage trades |
| amount_in | BIGNUMERIC | Quantities of assets input to arbitrage trades |
| amount_out | BIGNUMERIC | Quantities of assets output from arbitrage trades |
| arbitraged_token | STRING | Token symbols of assets being arbitraged |
| profit | BIGNUMERIC | Net profit earned from successful arbitrage trades |
| roi | FLOAT | Return on investment (ROI) for each arbitrage trade |
| pool_path | STRING | Hypsersurface paths involved in cross-chain pool trades |
| n_hops | INTEGER | Number of hops taken to execute cross-chain pool trades |
| n_pools | INTEGER | Number of pools involved in cross-chain pool trades |
| ingestion_timestamp | TIMESTAMP | Timestamps when data is ingested into the dataset |