Ethereum Core Data Model

BLOCKS

The blocks model follows the following structure

Name	Description	Type
block_number	The unique number assigned to the block.	bigint
block_hash	The hash of all the block's contents.	string
time_stamp	The block's timestamp (in ISO-8601 format).	timestamp
miner	The address miner who mines the block.	string
reward	The amount rewarded to the miner of the block.	decimal
size_	The size of a block in bytes.	integer
gas_used	Total gas used in the block.	integer
gas_limit	The maximum gas allowed in this block.	integer
base_fee_per_gas	The base fee to include a transaction in the block.	decimal
parent_hash	Hash of the parent block.	string
transaction_count	The number of transactions in the block.	integer

BLOCK_DETAILS

The block detail model follows the following structure:

Name	Description	Type
block_number	The unique number assigned to the block.	bigint
sha3_uncles	The hash of the block's uncle blocks.	string
state_root	The root of the final state trie of the block.	string
transactions_root	The root of the transaction trie of the block.	string
logs_bloom	The bloom filter for the logs of the block.	string
receipts_root	The root of the receipts trie of the block.	string
uncle_count	The number of uncle blocks included in the block.	integer
version	The block version number.	string
nonce	The block's nonce, is used in the proof of work algorithm.	string

TRANSACTIONS

The Transactions model follows the following structure:

Name	Description	Type
transaction_hash	The transaction's unique identifier.	string
block_number	Block number where this transaction was in.	biginteger
from_address	Address of the sender.	string
to_address	Address of the receiver.	string
value_	Value transferred in Wei.	decimal
gas	Gas provided by the sender.	decimal
transaction_fee	Amount paid to the Validator.	decimal
cumulative_gas_used	Amount of gas used when Tx was executed in a block.	biginteger
status	Status of transaction.	string
time_stamp	Transaction's timestamp (in ISO-8601 format).	date-time

TRANSACTION_DETAILS

The Transaction detail model follows the following structure:

Name	Description	Type
transaction_hash	The transaction's unique identifier.	string
chain_id	ChainID is an additional way to tell chains apart.	string
function_name	Method name which invoked.	string
receipt_effective_gas_price	The actual value per gas deducted from the sender's account.	decimal
receipt_contract_address	Address allocated when a smart contract is deployed.	string
receipt_gas_used	The amount of gas used in the transaction.	biginteger
max_fee_per_gas	The maximum fee used by the transaction(in wei).	decimal
max_priority_fee_per_gas	The maximum priority fee used by the transaction.	decimal
method_id	Method_id	string
gas_price	Gas price provided by the sender in Wei.	decimal
nonce	The number of transactions made by the sender before this one.	biginteger
type_	Transaction type. One of 0 (Legacy), 1 (Legacy), 2.	string
transaction_index	Integer of the transactions index position in the block.	biginteger
log_count	The number of logs produced in the transaction.	integer

CONTRACTS

The contract model follows the following structure:

Name	Description	Type
contract_address	Address from which this contract originated.	string
contract_creator_address	The address that deployed the contract.	string
time_stamp	The time at which the contract is created.	timestamp
proxy_contract_impl_address	If the contract is a proxy contract, proxy implementation address.	string
block_number	The block's number in which the contract is created.	bigint
transaction_hash	The hash of the transaction.	string

ERC20_EVT_APPROVAL

The ERC20 Approval model follows the following structure:

Name	Description	Type
transaction_hash	The transaction's unique identifier.	string
event_index	Integer of the log index position in the block.	integer
owner	The token owner who hold ERC20 tokens.	string
spender	The address which gets approval from the owner to spend that ERC20 tokens.	string
value_	Number of ERC20 token for approval.	decimal
time_stamp	ERC20 Token's approval timestamp (in ISO-8601 format).	timestamp
block_number	The block's number where this token is.	bigint
contract_address	Address allocated when a smart contract is deployed.	string

ERC20_EVT_TRANSFER

The ERC20 Transfer model follows the following structure:

Name	Description	Type
transaction_hash	The transaction's unique identifier.	string
event_index	Integer of the log index position in the block.	integer
from_	The ERC20 token sender address.	string
to_	The ERC20 token receiver address.	string
value_	Number of ERC20 token transfer.	decimal
time_stamp	ERC20 Token's transfer timestamp (in ISO-8601 format).	timestamp
block_number	The block's number where this token is.	bigint
contract_address	Address allocated when a smart contract is deployed.	string

ERC721_EVT_APPROVAL

The ERC721 Approval model follows the following structure:

Name	Description	Type
transaction_hash	The transaction's unique identifier.	string
event_index	Integer of the log index position in the block.	integer
token_id	A token ID is a number that identifies an approved token.	decimal
contract_address	Address allocated when a smart contract is deployed.	string
owner	The token owner who hold ERC721 tokens.	string
approved	The ERC721 token that the owner was approved.	boolean
block_number	The block's number where this token is.	bigint
time_stamp	ERC721 Token's approval timestamp (in ISO-8601 format).	timestamp

ERC721_EVT_TRANSFER

The ERC721 Transfer model follows the following structure:

Name	Description	Type
transaction_hash	The transaction's unique identifier.	string
event_index	Integer of the log index position in the block.	integer
token_id	A token ID is a number that identifies each token minted from a smart contract.	decimal
contract_address	Address allocated when a smart contract is deployed.	string
to_	The ERC721 token receiver address.	string
from_	The ERC721 token sender address.	string
block_number	The block's number where this token is.	bigint
time_stamp	ERC721 Token's transfer timestamp (in ISO-8601 format).	timestamp

ERC1155_EVT_APPROVAL

The ERC1155 Approval model follows the following structure:

Name	Description	Type
transaction_hash	The transaction's unique identifier.	string
event_index	Integer of the log index position in the block.	bigint
operator	The address which gets approval from the account to spend that ERC1155 tokens.	string
account	The account who hold ERC1155 tokens.	string
approved	The ERC1155 token that account was approved.	boolean
time_stamp	ERC1155 Token's approval timestamp (in ISO-8601 format).	string
block_number	The block's number where this token is.	integer
contract_address	Address allocated when a smart contract is deployed.	string

ERC1155_EVT_TRANSFER

The ERC1155 Transfer model follows the following structure:

Name	Description	Type
transaction_hash	The transaction's unique identifier.	string
event_index	Integer of the log index position in the block.	integer
from_	The ERC1155 token sender address.	string
to_	The ERC1155 token receiver address.	string
value_	Number of ERC1155 token.	decimal
time_stamp	ERC1155 Token's transfer timestamp (in ISO-8601 format).	timestamp
block_number	The block's number where this token is.	bigint
contract_address	Address allocated when a smart contract is deployed.	string
operator	The address which gets approval from the account to transfer that ERC1155 tokens.	string
id	The ID of the ERC1155 token that was transferred.	decimal

ERC1155_EVT_TRANSFERBATCH

The ERC1155 Transfer Batch model follows the following structure:

Name	Description	Type
transaction_hash	The transaction's unique identifier.	string
event_index	Integer of the log index position in the block.	integer
from_	The ERC1155 token sender address.	string
to_	The ERC1155 token receiver address.	string
value_	Number of ERC1155 token transfer in batch.	integer
time_stamp	ERC1155 Token's transfer timestamp (in ISO-8601 format).	timestamp
block_number	The block's number where this token is.	bigint
operator	The address which gets approval from the account to transfer	string
ids	A token ID is a number that identifies each token minted from a smart contract.	string

FUNGIBLETOKEN_WALLETS

The Fungible Token Wallet model follows the following structure:

Name	Description	Type
wallet_address	The unique identity that's used to send and receive cryptocurrency.	string
token_address	The unique identity of the deployed token smart contract.	string
block_number	The block's Number.	bigint
balance	The amount of crypto your fungible token wallet account held.	decimal
time_stamp	Transaction's timestamp (in ISO-8601 format).	timestamp

LOGS

The Logs model follows the following structure:

Name	Description	Type
transaction_hash	The transaction's unique identifier.	string
event_index	Integer of the log index position in the block.	integer
address	Address from which this log originated.	string
data	Contains one or more 32 Bytes non-indexed arguments of the log.	string
status	Status of the event log.	integer
block_number	The block number the parent transaction was included in.	bigint
time_stamp	The log's timestamp (in ISO-8601 format).	timestamp
topic_0	The topic_0 of the log.	string
topic_1	The topic_1 of the log.	string
topic_2	The topic_2 of the log.	string
anonymous	The event is anonymous.	boolean

NATIVE_WALLETS

The Native Wallet model follows the following structure:

Name	Description	Type
wallet_address	The unique identity that's used to send and receive cryptocurrency.	string
block_number	The block's Number.	bigint
balance	The amount of crypto your fungible token wallet account held.	integer
time_stamp	Transaction's timestamp (in ISO-8601 format).	timestamp

NATIVETOKEN_TRANSFERS

The Native Token Transfer model follows the following structure:

Name	Description	Type
transaction_hash	The transaction's unique identifier.	string
block_number	The block's number where this token is.	bigint
from_	The token sender address.	string
to_	The token receiver address.	string
value_	Number of native token transfers.	decimal
time_stamp	NativeToken's transfer timestamp (in ISO-8601 format).	string

NFT_COLLECTIONS

The NFT Collection model follows the following structure:

Name	Description	Type
address	Address from which this NFT Collection contract originated.	string
name	The name of the Non-Fungible Token Collection.	string
symbol	The symbol of a Non-Fungible Token.	string
token_standard	ERC standard used to create the NFT (ERC721, ERC1155).	string

NFTS

The NFT model follows the following structure:

Name	Description	Type
contract_address	Address from which this Non-Fungible Token contract originated.	string
token_id	A token ID is a number that identifies a Non-Fungible token.	decimal
name	The name of Non-Fungible Token.	string
image	The Unique image of a Non-fungible asset.	string
description	Describe the Non-fungible Token Attributes.	string
token_uri	The token URI on an NFT is a unique identifier of what the token "looks" like.	string
time_stamp	The time at which the Non-Fungible Token contract is created.	timestamp

TOKENS

The Token model follows the following structure:

Name	Description	Type
contract_address	Address on which this Fungible Token contract is deployed.	string
name	The name of the Fungible Token contract.	string
decimals	Decimals refer to how divisible a token can be, from 0 to 18.	decimal
symbol	The symbol of the Fungible Token contract.	string

CONTRACT_EVT_APPROVALFORALL

The Approvalforall model follows the following structure:

Name	Description	Type
event_index	The position of the event log in the Ethereum block.	integer
block_number	The block number	bigint
transaction_hash	The unique identifier of the Ethereum transaction that triggered the event.	string
operator	The address that is called the setApprovalForAll function.	string
account	The address that owns the assets that were approved.	string
approved	A boolean indicating whether the approval is granted or revoked.	boolean
contract_address	The address of the smart contract that manages the approved assets.	string
time_stamp	The time_stamp	timestamp

CONTRACT_EVT_OWNERSHIPTRANSFERRED

Ownershiptransferred model follows the following structure:

Name	Description	Type
block_number	The block number	bigint
time_stamp	The time_stamp	timestamp
transaction_hash	The transaction's unique identifier.	string
event_index	Integer of the log index position in the block.	integer
previousowner	The address of the previous owner of the token.	string
newowner	The address of the new owner of the token.	string
contract_address	Token address.	string