Name Description ethereum Database for decoded Ethereum transactions goerli Database for decoded Goerli (Ethereum testnet) transactions polygon Database for decoded Polygon transactions
SQL
select * from ethereum.block limit 1; -- or polygon.block or goerli.block
The block table stores information about .. yep, the indexed block .
Column Type Length Default Constraints Description id UUID gen_random_uuid() NOT NULL block_hash VARCHAR 66 NOT NULL UNIQUE block_number INTEGER NOT NULL Can change for block re-orgs chain VARCHAR 16 NOT NULL "ethereum", "polygon" or "goerli" context_id UUID NOT NULL Internal use. Will likely be removed in the future. num_transactions INT4 Number of transactions sort parsed in the block parent_block_hash VARCHAR 66 null if during a block re-org or partial transaction indextimestamp TIMESTAMP NOT NULL
Column Type Length Default Constraints Description id UUID gen_random_uuid() NOT NULL transaction_hash VARCHAR 66 NOT NULL UNIQUE block_id UUID NOT NULL FK constraint to block.id from VARCHAR 42 NOT NULL to VARCHAR 42 NOT NULL historical BOOL NOT NULL value NUMERIC NOT NULL In wei gas_limit NUMERIC gas_price NUMERIC gas_used NUMERIC max_fee_per_gas NUMERIC max_priority_fee_per_gas NUMERIC priority_fee_per_gas NUMERIC function VARCHAR NOT NULL ABI parsed function name params JSONB NOT NULL ABI parsed parameters for function nonce NUMERIC NOT NULL context_id UUID NOT NULL Internal use. Will likely be removed in the future. parse_successful BOOL NOT NULL Internal use. Will likely be removed in the future.
Column Type Length Default Constraints Description id UUID gen_random_uuid() NOT NULL transaction_id UUID NOT NULL FK constraint to transaction.id contract_address VARCHAR 42 NOT NUL index INT4 NOT NULL event VARCHAR NOT NULL ABI-parsed name of the event log params JSONB NOT NULL ABI-parsed event log parameters
Column Type Length Default Constraints Description id UUID gen_random_uuid() NOT NULL transaction_log_id UUID NOT NULL FK constraint to transaction_log.id event VARCHAR NOT NULL Signature of emitting event path VARCHAR NOT NULL Name of parameter in for this transaction_log_param entry bool_val BOOL Value from the transaction log for this parameter in BOOL format num_val NUMERIC Value from the transaction log for this parameter in NUMERIC format bin_val BYTEA Value from the transaction log for this parameter in BYTEA format str_val TEXT Value from the transaction log for this parameter in TEXT format
Column Type Length Default Constraints Description id UUID gen_random_uuid() NOT NULL transaction_id UUID NOT NULL FK constraint to transaction.id function VARCHAR NOT NULL path VARCHAR NOT NULL Name of parameter in for this transaction_param entry bool_val BOOL Value from the transaction log for this parameter in BOOL format num_val NUMERIC Value from the transaction log for this parameter in NUMERIC format bin_val BYTEA Value from the transaction log for this parameter in BYTEA format str_val TEXT Value from the transaction log for this parameter in TEXT format
Column Type Length Default Constraints Description id UUID gen_random_uuid() NOT NULL last_updated_transaction_id UUID NOT NULL Transaction ID this was last updated in. See also transaction.id contract_address VARCHAR 42 NOT NULL token_id INT8 NOT NULL ERC721 tokenId name VARCHAR 200 ERC721 Metadata JSON Schema name field description VARCHAR 1000 ERC721 Metadata JSON Schema description field image_uri VARCHAR 1000 ERC721 Metadata JSON Schema image field metadata_content JSONB NOT NULL Content of the ERC721 Metadata JSON call for tokenUri in JSON format last_updated TIMESTAMP NOT NULL Record last updated time token_uri VARCHAR 2000 NOT NULL tokenUri() in ERC721Metadata for this tokenId
See Timed Contract Function Calls
Column Type Length Default Constraints Description id UUID gen_random_uuid() NOT NULL contract_address VARCHAR 42 NOT NULL The contract on which the method was executed. method VARCHAR NOT NULL The name of the executed contract method. Based on ABI stored in ABI table. timestamp TIMESTAMP NOT NULL Time the method was executed (not the block timestamp). params JSONB JSON encoded parameters passed to the method, if any. result JSONB JSON-encoded result. See also the contract_method_execution_result table which provides these same results in a format which may be easier to work with in SQL. block_number INT4 NOT NULL Block number this was fired off in. See also block.block_number.
See Timed Contract Function Calls
Column Type Length Default Constraints Description id UUID gen_random_uuid() NOT NULL contract_method_execution_id UUID NOT NULL Foreign key constraint to contract_method_execution.id path VARCHAR NOT NULL The JSON path to the value represented by this row. bool_val BOOL Value located at path from the execution for this parameter in BOOL format num_val NUMERIC Value from the execution for this parameter in NUMERIC format bin_val BYTEA Value from the execution for this parameter in BYTEA format str_val TEXT Value from the execution for this parameter in TEXT format
Column Type Length Default Constraints Description id UUID gen_random_uuid() NOT NULL contract_address VARCHAR 42 NOT NULL interface JSONB NOT NULL decimals NUMERIC If this is an ERC-20 token, ERC-20's decimals field symbol VARCHAR 64 If this is an ERC-20 token, ERC-20's symbol field name VARCHAR 64 If this is an ERC-20 token, ERC-20's name field
Column Type Length Default Constraints Description id UUID gen_random_uuid() NOT NULL abi_id UUID NOT NULL FK constraint to abi event_sig_hash VARCHAR 66 NOT NULL The full event/function sig hash (not just 4 bytes) of the abi inputs JSONB NOT NULL Input surface (parameters) as JSON-encoded format. name VARCHAR 64 NOT NULL Name of function/variable/event type VARCHAR 32 NOT NULL Type of ABI item (error, constructor, function, fallback, receive, event) anonymous BOOL
