BlockDB Coins Tokens Details | Ethereum & EVM Chains | Historical, EOD, Real-Time | Crypto Token ...

🟦 What this is
Canonical on-chain token reference for fungible and non-fungible assets, providing unified structure and lineage for every recognized contract.
Each row represents a unique token or collection, traceable to its genesis event and ABI-decoded metadata.

Key traits
• Schema-stable, versioned, and audit-ready
• Historical and real-time ingestion from chain genesis
• Deterministic lineage and proof-of-derivation per token

🌐 Chains / Coverage
ETH, BSC, Base, Arbitrum, Unichain, Avalanche, Polygon, Celo, Linea, Optimism (others on request).
Full history from chain genesis; reorg-aware real-time ingestion and updates.
Includes both native coins (ETH, BNB, AVAX, etc.) and token contracts (ERC-20, ERC-721, ERC-1155, ERC-4626, custom standards).

📑 Schema
List the columns exactly as delivered. Keep names/types consistent with files.
• contract_address BYTEA - PK; 20-byte ERC-20 contract address
• tracing_id BYTEA - deterministic row-level hash (proof-of-derivation)
• parent_tracing_ids BYTEA - salted hash(es) of immediate parent rows in the derivation graph
• genesis_tracing_ids BYTEA - salted hash(es) of original sources (genesis of the derivation path)
• genesis_block_number BIGINT - first block where the token was recognized
• genesis_tx_index INTEGER - tx index for that event
• genesis_log_index INTEGER - log index for that event
• name TEXT - asset name (from ABI or native coin registry)
• symbol TEXT - token symbol or ticker
• decimals SMALLINT - number of decimal places for fungible tokens (NULL for NFTs)
• metadata_uri TEXT - optional field for NFT metadata base URI (if applicable)

Notes
• Use encode(contract_address,'hex') for hex presentation.
• Metadata for each token type is retrieved deterministically via ABI decoding or registry sources.
• If the ABI read was unsuccessful, the token is not present in this table.

🔑 Keys & Joins
• Primary key: contract_address
• Lineage triple for joins to raw events: (genesis_block_number, genesis_tx_index, genesis_log_index)

🧬 Lineage & Reproducibility
Every row has a verifiable path back to the originating raw events via the lineage triple and tracing graph:
• tracing_id - this row’s identity
• parent_tracing_ids - immediate sources
• genesis_tracing_ids - original on-chain sources
This supports audits and exact reprocessing to source transactions/logs/function calls.

📈 Common uses
• Canonical token registry for normalization across DeFi datasets
• Symbol, name, decimals lookups for accurate unit scaling in analytics
• Cross-chain asset identity resolution
• Foundation for NFT, LP token, and vault datasets
• Integration layer for pricing engines, wallets, and indexers

🚚 Delivery
By default
• WebSocket (API/WSS) reorg-aware live emissions when a new update is available; <140 ms median latency on ETH streams (7-day).
• SFTP server for archives and daily End-of-Day (EOD) snapshots.
• Model Context Protocol (MCP) for AI workflows (pull slices, schemas, lineage).
Optional
• Integrations to Amazon S3, Azure Blob Storage, Snowflake, and other enterprise platforms on request.

🗂️ Files (time-partitioned in UTC, compressed)
• Parquet
• CSV
• XLS
• JSON

💡 Quality and operations
• Reorg-aware ingestion.
• 99.95% uptime target SLA.
• Backfills to chain genesis.
• Versioned, schema-stable datasets; changes are additive and announced.

🔄 Change policy
Schema is stable. Any breaking change ships as a new version (e.g., tokens_v2) with migration notes. Content updates are additive (new rows/fields filled); types aren’t changed in place.