Osmosis
This page presents the available tables for Osmosis.
Raw Tables
This table provides information about the events occurring on the blockchain within the Cosmos ecosystem, offering insights into the block height, timestamp, and event occurrences. The data is sourced from the blockchain to provide a comprehensive view of the network's activity.
| Column Name | Type | Description |
|---|---|---|
| block_height | INTEGER | The height of the block within the blockchain, representing the number of blocks mined up to this point. |
| block_timestamp | TIMESTAMP | The timestamp when the block was mined, indicating the time at which the events occurred. |
| event_index | INTEGER | The index of the event within the block, identifying its position in the list of events. |
| event_type | STRING | The type of event that occurred, categorizing the type of action or transaction. |
| event_attributes | JSON | Additional attributes associated with the event, providing more detailed information about the occurrence. |
| source | STRING | The source of the data, indicating the blockchain or network from which the information was obtained. |
| schema_version | INTEGER | The version of the schema used to describe the structure of the data, ensuring consistency and compatibility. |
| ingestion_timestamp | TIMESTAMP | The timestamp when the data was ingested into the system, indicating the time at which the data was received. |
Parsed Tables
Arbitrage trades data from the Cosmos ecosystem, showcasing opportunities where traders took advantage of price discrepancies across different blockchain networks.
| Column Name | Type | Description |
|---|---|---|
| block_height | INTEGER | The height of the block in which the trade transaction occurred. |
| block_timestamp | TIMESTAMP | Timestamp of the block in which the trade transaction occurred, indicating the time of the trade. |
| tx_id | STRING | Unique identifier of the transaction in which the arbitrage trade occurred. |
| message_index | INTEGER | Index of the message within the transaction where the arbitrage trade was executed. |
| exec_msg_index | STRING | Index of the execute message within the transaction where the arbitrage trade was executed. |
| arb_index | INTEGER | Index of the arbitrage trade within the transaction. |
| trader | STRING | Identifier of the trader who executed the arbitrage trade. |
| amount_in | BIGNUMERIC | Quantity of the token being traded into the pool. |
| amount_out | BIGNUMERIC | Quantity of the token being traded out of the pool. |
| arbitraged_token | STRING | Token being arbitrated, involved in the price discrepancy. |
| profit | BIGNUMERIC | Profit made by the trader from the arbitrage trade. |
| roi | FLOAT | Return on Investment (ROI) for the arbitrage trade. |
| pool_path | STRING | Path of the liquidity pool used for the arbitrage trade. |
| n_hops | INTEGER | Number of hops taken to execute the arbitrage trade. |
| n_pools | INTEGER | Number of pools used to execute the arbitrage trade. |
| ingestion_timestamp | TIMESTAMP | Timestamp when the data was ingested into the system. |