Cosmos ecosystem

These chains are all built with the same toolkit, the Cosmos SDK. On them a transaction does not do one thing: it carries a list of messages, each one a typed request such as “send these coins” or “vote on this proposal”. Running those messages makes the chain write events, its own notes on what happened, and the chain writes more of them at the start and end of each block, with no transaction behind them. So each chain gets five tables, blocks, transactions, transaction_messages, message_events and block_events, in one dataset per chain. The Tables section below says what each table holds and lists the columns once for the whole family.

Chains

Chain	`chain_id`	blocks	transactions	transaction_messages	message_events	block_events
Celestia	`celestia`	✓	✓	✓	✓	✓
Cosmos Hub	`cosmoshub`	✓	✓	✓	✓	✓
dYdX	`dydx`	✓	✓	✓	✓	✓
Injective	`injective`	✓	✓	✓	✓	✓

Tables

Cosmos chains are built from the same toolkit, so they all carry the same five tables with the same columns. The schemas below are read from cosmoshub, and apply to every chain listed on the Cosmos overview. One thing to know before the tables. On these chains a transaction does not do one thing: it carries a list of messages, each one a typed request such as “send these coins” or “vote on this proposal”. Running those messages emits events, which are the chain’s own notes about what happened, so the sequence is transaction, then messages, then events. Every table except blocks is split by day on block_timestamp, and blocks on timestamp. Filter on that column in every query: with a filter the query reads only the days you asked for, without one it reads the whole table.

blocks
transactions
transaction_messages
message_events
block_events

A block is a batch of transactions added to the chain, and the validator that put it forward is its proposer. blocks contains one row per block.

Column	Type	Description
`timestamp`	`TIMESTAMP`	The time the block was produced. Partition column.
`block_height`	`INT64`	The block height.
`transaction_count`	`INT64`	The number of transactions in the block.
`validators_hash`	`STRING`	The hash of the validator set.
`proposer_address`	`STRING`	The address of the block proposer.

Daily blocks and transactions

Count blocks and total transactions per day over one week.

select
    timestamp_trunc(timestamp, day) as day,
    count(*) as blocks,
    sum(transaction_count) as transactions
from `cosmoshub.blocks`
where timestamp >= timestamp('2026-08-16')
  and timestamp < timestamp('2026-08-23')
group by day
order by day

A transaction is one signed submission to the chain, carrying the messages that say what to do. transactions contains one row per transaction, with the fee it paid and whether it worked.

Column	Type	Description
`block_height`	`INT64`	The height of the containing block.
`block_timestamp`	`TIMESTAMP`	The time of the containing block. Partition column.
`transaction_hash`	`STRING`	The hash of the transaction.
`transaction_index`	`INT64`	The position of the transaction within the block.
`transaction_info`	`STRING`	The transaction info string returned by the node.
`transaction_log`	`STRING`	The execution log.
`transaction_code`	`INT64`	The result code. Zero marks success.
`transaction_fee`	`INT64`	The fee paid.
`gas_wanted`	`STRING`	The gas requested.
`gas_used`	`STRING`	The gas consumed.

Daily success rate and fees

Count daily transactions, their success rate and average fee over one week.

select
    timestamp_trunc(block_timestamp, day) as day,
    count(*) as transactions,
    countif(transaction_code = 0) as successful,
    avg(transaction_fee) as avg_fee
from `cosmoshub.transactions`
where block_timestamp >= timestamp('2026-08-16')
  and block_timestamp < timestamp('2026-08-23')
group by day
order by day

A message is one typed request inside a transaction: send coins, delegate a stake, vote. Its type is the best single column for asking what users were doing on the chain. transaction_messages contains one row per message.

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	The time of the containing block. Partition column.
`block_height`	`INT64`	The height of the containing block.
`transaction_hash`	`STRING`	The hash of the containing transaction.
`transaction_index`	`INT64`	The position of the transaction within the block.
`message_index`	`INT64`	The position of the message within the transaction.
`message_type`	`STRING`	What kind of request this is, written as a full type path such as `/cosmos.bank.v1beta1.MsgSend`.
`message`	`STRING`	The message payload.

Message types

Rank message types by count over one week.

select
    message_type,
    count(*) as messages
from `cosmoshub.transaction_messages`
where block_timestamp >= timestamp('2026-08-16')
  and block_timestamp < timestamp('2026-08-23')
group by message_type
order by messages desc
limit 20

An event is a note the chain writes while it carries out a message: coins moved, a stake changed. message_events contains one row per event a transaction produced.

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	The time of the containing block. Partition column.
`block_height`	`INT64`	The height of the containing block.
`transaction_hash`	`STRING`	The hash of the emitting transaction.
`event_type`	`STRING`	The event type.
`transaction_index`	`INT64`	The position of the transaction within the block.
`event_index`	`INT64`	The position of the event within the transaction.
`event_attributes`	`JSON`	The event attributes, as key-value pairs.

Event types

Rank event types by count over one week.

select
    event_type,
    count(*) as events
from `cosmoshub.message_events`
where block_timestamp >= timestamp('2026-08-16')
  and block_timestamp < timestamp('2026-08-23')
group by event_type
order by events desc
limit 20

Some things happen because the chain itself does them at the start or end of a block, with no transaction behind them: paying out staking rewards, for instance. block_events contains one row per event of that kind, and source says whether it came at the beginning of the block or the end.

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	The time of the block. Partition column.
`block_height`	`INT64`	The block height.
`event_type`	`STRING`	The event type.
`event_index`	`INT64`	The position of the event within its source.
`event_attributes`	`JSON`	The event attributes, as key-value pairs.
`source`	`STRING`	The emission point, begin block or end block.

Block event types by source

Rank block-level event types by source, begin block or end block, over one week.

select
    source,
    event_type,
    count(*) as events
from `cosmoshub.block_events`
where block_timestamp >= timestamp('2026-08-16')
  and block_timestamp < timestamp('2026-08-23')
group by source, event_type
order by events desc
limit 20

Overview

Core entities

Core datasets

Market verticals

Chain verticals

Chains

Tables

​Chains

​Tables

Chains

Tables