Skip to main content

Overview

This schema contains 15 tables and views for Ethereum data.

Tables and Views

Dim Contract Abis

This table contains Application Binary Interfaces (ABIs) for smart contracts deployed on EVM blockchains.

Dim Contracts

This table provides comprehensive metadata for all smart contracts deployed on EVM blockchains.

Dim Labels

The labels table is a critical dimension for blockchain analysis, providing one-to-one address identifiers that transform opaque addresses into rec…

Ez Balance Deltas

This table contains the block level balance changes for both tokens (including ERC721s) and the native asset on this EVM blockchain for all wallets…

Ez Current Balances

This table contains the current, non-zero balances for wallets on this EVM blockchain.

Ez Decoded Event Logs

This table provides human-readable decoded event data for smart contracts where ABIs are available.

Ez Decoded Traces

This model contains decoded data for traces on this EVM blockchain.

Ez Native Transfers

This convenience table tracks all native asset transfers (ETH, AVAX, MATIC, etc.) extracted from transaction traces.

Ez Token Transfers

This convenience table provides a comprehensive view of all ERC-20 token transfers with enriched metadata including decimal adjustments, USD values…

Fact Blocks

This table contains block-level data for EVM blockchains, providing a complete record of all blocks produced on the chain.

Fact Eth Balances

This table contains the unadjusted Ether (ETH) balances for users on the Ethereum blockchain.

Fact Event Logs

This table contains raw event logs emitted by smart contracts during transaction execution.

Fact Token Balances

This table contains the unadjusted token balances for users on the Ethereum blockchain.

Fact Traces

This table contains detailed execution traces of all internal transactions within the EVM.

Fact Transactions

This table contains comprehensive transaction-level data for EVM blockchains.