Celestia
This page presents the available tables for Celestia.
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 | Unique identifier of a block in the blockchain, incremented with each new block |
| block_timestamp | TIMESTAMP | Timestamp when a block was added to the blockchain, in UTC time |
| event_index | INTEGER | Sequential order of events within a block, used for data correlation and linkage |
| event_type | STRING | Type of event being reported, defining the nature of the blockchain occurrence |
| event_attributes | JSON | Collection of relevant data associated with a particular event, including key-value pairs |
| source | STRING | Identifier of the blockchain network or application origin of the event data |
| ingestion_timestamp | TIMESTAMP | Timestamp when the event data was imported into the dataset, in UTC time |
| schema_version | INTEGER | Current or previous schema version of the data, documented for version control |
Parsed Tables
This table provides a snapshot of user balances across different networks within the Cosmos ecosystem. It includes both stable and unstaked coin balances, separate and in USDC, as well as unclaimed and claimed rewards.
| Column Name | Type | Description |
|---|---|---|
| block_height | INTEGER | Sequential number assigned to each block within a blockchain |
| block_timestamp | TIMESTAMP | Timestamp representing when a block was successfully mined or confirmed |
| address | STRING | Unique identifier for an on-chain wallet or onion address |
| liquid_balance | FLOAT | Available balance of a user's native cryptocurrency |
| staking_balance | FLOAT | Locked balance of a user's native cryptocurrency for staking |
| unclaimed_rewards | FLOAT | Accrued but unclaimed rewards from staking activities |
| claimed_rewards | FLOAT | Rewards already claimed by a user from staking activities |
| liquid_balance_usdc | FLOAT | Available balance of USD stablecoin USDC |
| staking_balance_usdc | FLOAT | Locked balance of USD stablecoin USDC for staking |
| unclaimed_rewards_usdc | FLOAT | Accrued but unclaimed rewards of USD stablecoin USDC |
| claimed_rewards_usdc | FLOAT | Rewards already claimed of USD stablecoin USDC |