Osmosis
This page presents the available tables for Osmosis.
Raw Tables
This table provides a comprehensive view of block events from the Cosmos ecosystem, offering insights into the blockchain's activity over time. It includes essential metadata to contextualize each event.
| Column Name | Type | Description |
|---|---|---|
| block_height | INTEGER | The height of the block within the blockchain at the time of the event. |
| block_timestamp | TIMESTAMP | The timestamp when the block was committed to the blockchain. |
| event_index | INTEGER | The index of the event within the block. |
| event_type | STRING | The type of event that occurred. |
| event_attributes | JSON | Additional attributes related to the event. |
| source | STRING | The source of the block event data. |
| schema_version | INTEGER | The version of the schema used to capture the event data. |
| ingestion_timestamp | TIMESTAMP | The timestamp when the event data was ingested into the system. |
Parsed Tables
This table contains information about arbitrage trades in the Cosmos ecosystem, providing insights into the execution of profit-driven trading strategies across different blockchain networks.
| Column Name | Type | Description |
|---|---|---|
| block_height | INTEGER | Height of the block in which the trade was executed, indicating the order of the transaction within the blockchain. |
| block_timestamp | TIMESTAMP | Timestamp of the block in which the trade was executed, displaying the exact time of the transaction. |
| tx_id | STRING | Unique identifier of the transaction in which the arbitrage trade was executed. |
| message_index | INTEGER | Index of the message within the transaction that triggered the arbitrage trade. |
| exec_msg_index | STRING | Index of the execution message within the transaction that executed the arbitrage trade. |
| arb_index | INTEGER | Unique identifier for the arbitrage trade, enabling tracking and analysis of individual trades. |
| trader | STRING | Address of the trader who executed the arbitrage trade, providing context about the trading entity. |
| amount_in | BIGNUMERIC | Amount of tokens or assets injected into the trade, including the original funds used by the trader. |
| amount_out | BIGNUMERIC | Amount of tokens or assets obtained from the trade, representing the profit generated by the arbitrage. |
| arbitraged_token | STRING | Token or asset being traded, highlighting the specific asset being arbitrated. |
| profit | BIGNUMERIC | Net profit generated by the arbitrage trade, indicating the economic benefit of the trade. |
| roi | FLOAT | Return on investment (ROI) of the arbitrage trade, displaying the percentage return on the initial investment. |
| pool_path | STRING | Path of the liquidity pools involved in the arbitrage trade, illustrating the flow of assets and funds. |
| n_hops | INTEGER | Number of intermediate steps or hops taken during the execution of the arbitrage trade. |
| n_pools | INTEGER | Number of liquidity pools involved in the arbitrage trade, representing the complexity of the trade. |
| ingestion_timestamp | TIMESTAMP | Timestamp when the trade data was ingested into the system, indicating the data freshness. |