Osmosis

Chain ID: osmosis

For Osmosis you'll find the following tables:

1. Raw Tables

2. Filtered Tables

   1. Staking

   2. IBC

   3. Liquidity Pools

   4. Governance

   5. Distribution

3. Additional Data Tables

Raw Tables

osmosis_blocks

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

osmosis_event_attributes

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

osmosis_message_event_attributes

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

osmosis_transactions

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

Filtered Event-Based Tables

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.)

Staking Tables

osmosis_delegate

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

osmosis_redelegate

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

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
osmo_amount	BIGNUMERIC
new_shares	STRING
ingestion_timestamp	TIMESTAMP

IBC Tables

osmosis_ibc_transfer

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_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

Liquidity Pools Tables

osmosis_join_pool

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

osmosis_exit_pool

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

osmosis_swaps

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

Governance Tables

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

Distribution Tables

osmosis_withdraw_rewards

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

osmosis_withdraw_commissions

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 Data Tables

Additional tables have data that is not event based but relevant when working with event based data.

asset_denoms

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

validators

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

message_types_transactions

Each record is a single message triggered within the chain. We include it's type, sender and the corresponding tx_id.