Chains
| Chain | chain_id |
|---|---|
| Algorand | algorand |
| Cardano | cardano |
| Flow | flow |
| Hedera | hedera |
| NEAR | near |
| Ripple | ripple |
| Starknet | starknet |
| Stellar | stellar |
| TON | ton |
| Tron | tron |
Tables
Each chainβs tables are listed on its own page above, with every column and the month its history starts. Two habits hold across every chain here, whatever its tables are called. A table with one row per transaction or per event is split by day onblock_timestamp, and a table of blocks on timestamp. Filter on that column in every query: without a filter the query reads the whole table.
Identifiers reuse the familiar names wherever the chain has a matching idea: block_number, transaction_hash, and *_index for a position within something.
Exceptions
- Ripple and Stellar call their blocks ledgers; on both chains the ledgers land in
blocks. - Stellar splits a transaction into a list of operations, so
operationsholds what a transaction did andeffectsholds what each operation changed. - TONβs
block_headersandshardsare unpartitioned, so a query against either reads the whole table. Itstransactionsandmessagessplit by day onblock_timestamp, andblocksontimestamp, as usual. - Tron writes each address in two forms and both are here: the
*_hexcolumns hold the form that looks like an Ethereum address, and the plainaddress-style columns hold the base58 form that starts with a T. Pick whichever matches the addresses you are joining against.