Cosmos Hub

cosmoshub holds the standardized Cosmos Hub tables, following the schema documented in the family overview exactly, with no differences.

Tables

Table	Since	Description
`blocks`	2019-12	One row per block, with its transaction count and proposer.
`transactions`	2021-02	One row per transaction, with its fee and result code.
`transaction_messages`	2021-02	One row per message inside a transaction.
`message_events`	2021-02	One row per event emitted during transaction execution.
`block_events`	2021-02	One row per event emitted outside a transaction.

Sample queries

Daily success rate
Tokens tracked

Count daily transactions and their success rate over one week.

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

List the Cosmos Hub tokens we track, with the name the chain knows each one by. Cosmos chains identify a token by a string called its denom, and that is what token_address holds: an ibc/ hash for a voucher, or a factory/ path for one the token factory minted.

select
    token_id,
    symbol,
    name,
    decimals,
    token_address
from `dimensions.tokens`
where chain_id = 'cosmoshub'
  and symbol is not null
order by created_at
limit 20

Notes

The transaction tables begin on 2021-02-18, at the Cosmos Hub 4 upgrade, while blocks also covers the hub version before it. The rest of the catalog holds one slice of Cosmos Hub: its tokens. Some arrived from another chain over IBC, the Cosmos transfer protocol, and are held as vouchers; the others were minted on Cosmos Hub itself by its token factory. No app, pool or tokenized asset table covers Cosmos Hub, so its activity comes from the raw tables above. Tokens covers the token list and the daily price table built beside it. Chains covers the list of chains we track.

Overview

Core entities

Core datasets

Market verticals

Chain verticals

Tables

Sample queries

Notes

​Tables

​Sample queries

​Notes

Tables

Sample queries

Notes