Comment on page
Osmosis
Chain ID: osmosis
For Osmosis you'll find the following tables:
- 1.
- 2.
- 1.
- 2.
- 3.
- 4.
- 5.
osmosis_blocks
osmosis_event_attributes
osmosis_message_event_attributes
osmosis_transactions
Contains each validated block in the chain.
block_timestamp is only available in this table, so you need to do an inner join on block_height to get block_timestamp to the other tables.Field | Type |
|---|---|
block_height | STRING |
block_timestamp | TIMESTAMP |
chain_id | STRING |
proposer_address | STRING |
validators_hash | STRING |
Contains all events and their corresponding attributes partitioned by
tx_id. Events and their corresponding event_index are relative to the parent transaction , not the message. Events are identified by the event_type column and attributes by the attribute_key. Events are linked to transactions via column tx_id.Field | Type |
|---|---|
block_height | INTEGER |
chain_id | STRING |
tx_id | STRING |
event_index | INTEGER |
event_type | STRING |
attribute_key | STRING |
attribute_value | STRING |
attribute_index | INTEGER |
ingestion_timestamp | TIMESTAMP |
Contains all events and their corresponding attributes partitioned by
message_index. Events and their corresponding event_index are relative to the parent message_index which is relative to the tx_id. Events are identified by the event_type column and attributes by the attribute_key. Events are linked to transactions via column tx_id.Field | Type |
|---|---|
block_height | STRING |
chain_id | STRING |
tx_id | STRING |
message_index | INTEGER |
event_index | INTEGER |
event_type | STRING |
attribute_key | STRING |
attribute_value | STRING |
attribute_index | INTEGER |
ingestion_timestamp | TIMESTAMP |
Contains relevant data associated with a transaction.
Field | Type |
|---|---|
block_height | STRING |
chain_id | STRING |
tx_id | STRING |
tx_status | STRING |
fee | STRING |
tx_code | INTEGER |
tx_index | INTEGER |
gas_used | INTEGER |
gas_wanted | INTEGER |
ingestion_timestamp | TIMESTAMP |
Beyond the raw tables, we have sub-tables for different relevant types of events, such as delegations, redelegations, swaps & voting. You can find them in their respective area (delegations in staking, swaps in liquidity pools, etc.)
osmosis_delegate
osmosis_redelegate
osmosis_undelegate
Field | Type |
|---|---|
block_height | INTEGER |
block_timestamp | TIMESTAMP |
tx_id | STRING |
message_index | INTEGER |
nth_action | INTEGER |
validator | STRING |
moniker | STRING |
delegator | STRING |
parsed_OSMO_amount | FLOAT64 |
new_shares | STRING |
ingestion_timestamp | TIMESTAMP |
Field | Type |
|---|---|
block_height | INTEGER |
block_timestamp | TIMESTAMP |
tx_id | STRING |
message_index | INTEGER |
nth_action | INTEGER |
source_validator | STRING |
source_moniker | STRING |
destination_validator | STRING |
destination_moniker | STRING |
delegator | STRING |
osmo_amount | BIGNUMERIC |
new_shares | STRING |
ingestion_timestamp | TIMESTAMP |
Field | Type |
|---|---|
block_height | INTEGER |
block_timestamp | TIMESTAMP |
tx_id | STRING |
message_index | INTEGER |
nth_action | INTEGER |
validator | STRING |
moniker | STRING |
delegator | STRING |
osmo_amount | BIGNUMERIC |
new_shares | STRING |
ingestion_timestamp | TIMESTAMP |
osmosis_ibc_transfer
osmosis_ibc_receive
Field | Type |
|---|---|
block_height | INTEGER |
block_timestamp | TIMESTAMP |
tx_id | STRING |
message_index | INTEGER |
nth_action | INTEGER |
packet_src_channel | STRING |
packet_dts_channel | STRING |
packet_connection | STRING |
sender | STRING |
receiver | STRING |
amount | FLOAT64 |
token_path | STRING |
token_alias | STRING |
token_denom | STRING |
ingestion_timestamp | TIMESTAMP |
Field | Type |
|---|---|
block_height | INTEGER |
block_timestamp | TIMESTAMP |
tx_id | STRING |
message_index | INTEGER |
nth_action | INTEGER |
packet_src_channel | STRING |
packet_dts_channel | STRING |
packet_connection | STRING |
sender | STRING |
receiver | STRING |
amount | FLOAT64 |
token_path | STRING |
token_alias | STRING |
token_denom | STRING |
ingestion_timestamp | TIMESTAMP |
osmosis_join_pool
osmosis_exit_pool
osmosis_swaps
Field | Type |
|---|---|
block_height | INTEGER |
block_timestamp | TIMESTAMP |
tx_id | STRING |
message_index | INTEGER |
nth_action | INTEGER |
sender | STRING |
pool_id | STRING |
tokens_in | STRING |
ingestion_timestamp | TIMESTAMP |
Field | Type |
|---|---|
block_height | INTEGER |
block_timestamp | TIMESTAMP |
tx_id | STRING |
message_index | INTEGER |
nth_action | INTEGER |
sender | STRING |
pool_id | STRING |
tokens_out | STRING |
ingestion_timestamp | TIMESTAMP |
Field | Type |
|---|---|
block_height | INTEGER |
block_timestamp | TIMESTAMP |
tx_id | STRING |
event_index | INTEGER |
sender | STRING |
pool_id | STRING |
amount_in | BIGNUMERIC |
parsed_amount_in | FLOAT64 |
denom_in | STRING |
native_denom_in | STRING |
amount_out | BIGNUMERIC |
parsed_amount_out | FLOAT64 |
denom_out | STRING |
native_denom_out | STRING |
ingestion_timestamp | TIMESTAMP |
osmosis_voting
Field | Type |
|---|---|
block_height | INTEGER |
block_timestamp | TIMESTAMP |
tx_id | STRING |
message_index | INTEGER |
nth_action | INTEGER |
voter | STRING |
proposal_id | STRING |
proposal_option | STRING |
ingestion_timestamp | TIMESTAMP |
osmosis_withdraw_rewards
osmosis_withdraw_commissions
Field | Type |
|---|---|
block_height | INTEGER |
block_timestamp | TIMESTAMP |
tx_id | STRING |
message_index | INTEGER |
nth_action | INTEGER |
validator | STRING |
moniker | STRING |
receiver | STRING |
token_amount | FLOAT64 |
token_amount_in_usdc | FLOAT64 |
token_denom | STRING |
ingestion_timestamp | TIMESTAMP |
Field | Type |
|---|---|
block_height | INTEGER |
block_timestamp | TIMESTAMP |
tx_id | STRING |
message_index | INTEGER |
nth_action | INTEGER |
validator | STRING |
moniker | STRING |
token_amount | FLOAT64 |
token_amount_in_usdc | FLOAT64 |
token_denom | STRING |
ingestion_timestamp | TIMESTAMP |
Additional tables have data that is not event based but relevant when working with event based data.
asset_denoms
validators
message_types_transactions
Purpose: This table decodes token address to denom & stores exponents to parse tokens.
Field | Type |
|---|---|
id | INTEGER |
name | STRING |
base | STRING |
symbol | STRING |
coingecko_id | STRING |
exponent | INTEGER |
Purpose: This table maps validator addresses to moniker & other metadata.
Field | Type |
|---|---|
account_address | STRING |
operator_address | STRING |
consensus_pubkey | STRING |
status | FLOAT |
moniker | STRING |
identity | STRING |
rate | STRING |
max_rate | FLOAT |
min_self_delegation | FLOAT |
Network | STRING |
Snapshot_date | TIMESTAMP |
Each record is a single message triggered within the chain. We include it's type, sender and the corresponding
tx_id.
Last modified 3mo ago