Data Raw Access
Introduction
Upon request, we can provide access to the raw data stored in the Orbit Codes network of indexers.
This data is stored in PostgreSQL and ClickHouse databases and can be accessed using a read-only user on a replication instance.
When to use PG or CH
- PostgreSQL (PG): Use PostgreSQL for querying data that is not time-series related, such as account balances, blocks, transactions, and more.
- ClickHouse (CH): Use ClickHouse for querying time-series data, such as historical prices, trading volumes, and more.
Default Tables
The following tables are available for querying by default:
| Table Name | PostgreSQL | ClickHouse |
|---|---|---|
| accounts | ||
| blocks | ||
| evm_contracts | ||
| ibc_channels | ||
| ibc_clients | ||
| ibc_connections | ||
| ibc_operations | ||
| params | ||
| proposals | ||
| proposal_deposits | ||
| proposal_votes | ||
| transactions | ||
| transaction_messages | ||
| validators | ||
| validator_delegations | ||
| validator_redelegations | ||
| validator_undelegations |