Smart Contract Function Results | Ethereum & EVM Chains Data

**Dataset Overview**

BlockDB Discovered Smart Contract Function Results stores on-chain view function outputs versioned by block height, enabling time-travel queries over any contract's state directly in Snowflake. Each record captures the raw ABI-encoded return value of a deterministic function call (eth_call) at a specific block, keyed on a composite of contract incarnation, block number, and call data. Using the same 26-byte CONTRACT_ID as the contracts dataset, it correctly handles metamorphic contracts across redeployments. Coverage includes token metadata reads, price oracle snapshots, governance parameters, pool configuration values, and any other view function captured during BlockDB's ingestion pipeline.

<p><br/></p>

**Sample Notice**

This dataset contains **a small sample** of the full BlockDB Smart Contract Function Results dataset. It is provided **for evaluation, research, and interoperability testing only**. If you need full historical coverage, real-time streaming, or end-of-day (EOD) exports please contact us via contact form on Snowflake Marketplace.

<p><br/></p>

**Chains and 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.

<p><br/></p>

**Join Keys**

CONTRACT_ID → BLOCKDB0121_CONTRACTS_V1 for contract deployment metadata. SIGNATURE_HASH identifies the 4-byte function selector for ABI decoding in downstream Snowflake pipelines.

<p><br/></p>

**Lineage**

Each function result record includes a deterministic _TRACING_ID, linking it to the block and contract incarnation where the call was executed. This ensures verifiable traceability and reproducibility for every downstream record derived from contract state data.

<p><br/></p>

**Quality**

- Verifiable lineage: deterministic cryptographic hashes per row
- Reorg-aware ingestion: continuity and consistency across forks
- Complete historical coverage: from chain genesis to present