Celestia
This page presents the available tables for Celestia.
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. |
ingestion_timestamp | TIMESTAMP | The timestamp when the event data was ingested into the system. |
schema_version | INTEGER | The version of the schema used to capture the event data. |
Parsed Tables
This table provides a comprehensive overview of the accounting balances for accounts in the Cosmos ecosystem. It includes both native and USDC-denominated balances.
Column Name | Type | Description |
---|---|---|
block_height | INTEGER | The height of the block at which the account's balances were last updated. |
block_timestamp | TIMESTAMP | The timestamp of the block at which the account's balances were last updated. |
address | STRING | The public address of the account for which the balances are being tracked. |
liquid_balance | FLOAT | The liquid balance of the account, which represents the funds available for spending. |
staking_balance | FLOAT | The staking balance of the account, which represents the funds committed to staking validators. |
unclaimed_rewards | FLOAT | The unclaimed rewards of the account, which represents the rewards earned but not yet claimed. |
claimed_rewards | FLOAT | The claimed rewards of the account, which represents the rewards earned and already claimed. |
liquid_balance_usdc | FLOAT | The liquid balance of the account in USDC, which represents the funds available for spending in USDC. |
staking_balance_usdc | FLOAT | The staking balance of the account in USDC, which represents the funds committed to staking validators in USDC. |
unclaimed_rewards_usdc | FLOAT | The unclaimed rewards of the account in USDC, which represents the rewards earned but not yet claimed in USDC. |
claimed_rewards_usdc | FLOAT | The claimed rewards of the account in USDC, which represents the rewards earned and already claimed in USDC. |