Data model
Contains information for block data, one record per block.
|
Column |
Data Type |
Description |
|
BLOCK_HASH |
VARCHAR |
Hashed value of the current block payload with previous block_hash, to guarantee immutability. |
|
BLOCK_NUMBER |
BIGINT |
Integer value of the block number. |
|
BASE_FEE_PER_GAS |
VARCHAR |
Fee calculated by a formula that compares the size of the previous block (the amount of gas used for all the transactions) with the target size. |
|
REWARD |
VARCHAR |
Refers to the cryptocurrency rewarded to a miner when they successfully validate a new block. |
|
GAS_LIMIT |
INTEGER |
The maximum amount of work you're estimating a validator will do on a particular transaction. |
|
PARENT_HASH |
VARCHAR |
Hashed value for parent node of the Merkle tree in the block. |
|
GAS_USED |
INTEGER |
Amount of gas used in the mining of the block. |
|
SIZE_ |
INTEGER |
Size of block data in bytes. |
|
MINER |
VARCHAR |
Address of the miner. |
|
TRANSACTION_COUNT |
INTEGER |
Number of transactions present in the block. |
|
TIME_STAMP |
TIMESTAMP |
Timestamp of the block creation. |
BLOCK_DETAIL
Contains additional information for the block data, one record per block. FK block_number to blocks table.
|
Column |
Data Type |
Description |
|
SHA3_UNCLES |
VARCHAR |
Hashed value of all the uncle blocks for a block. |
|
RECEIPTS_ROOT |
BIGINT |
Receipts root is the Keccak 256-bit hash of the root node of the transaction receipt trie. Trie is composed of all receipts. |
|
NONCE |
VARCHAR |
Nonce is a random 32-bit number that miners use as a base for their hash calculations. |
|
STATE_ROOT |
VARCHAR |
It is the Keccak 256-bit hash of the root node of the state trie after all the transactions are executed. |
|
BLOCK_NUMBER |
BIGINT |
Integer value of the block number. |
|
VERSION |
VARCHAR |
Internal purpose. |
|
UNCLES_COUNT |
INTEGER |
Number of uncles block generated with the block. |
|
TRANSACTIONS_ROOT |
VARCHAR |
Root hash of the transactions sequence in blocks. |
|
LOGS_BLOOM |
VARCHAR |
Data structure containing event logs. |
Contains information regarding the event “approvalforall” which is triggered when an owner gives or changes approval for all of their NFTs to an operator.
|
Column |
Data Type |
Description |
|
ACCOUNT |
VARCHAR |
Hashed value of all the uncle blocks for a block. |
|
CONTRACT_ADDRESS |
VARCHAR |
Address of the contract which emits this event. |
|
EVENT_INDEX |
SMALLINT |
“Log index” refers to the index of a log in transaction. |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
|
APPROVED |
BOOLEAN |
Contains information if changes in NFT are approved or not. |
|
OPERATOR |
VARCHAR |
The address of the operator who will receive full rights for the owner’s tokens. |
Contains information regarding the contracts involved in transactions in a block.
|
Column |
Data Type |
Description |
|
TIME_STAMP |
TIMESTAMP |
Timestamp of contract deployment/creation |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
|
BLOCK_NUMBER |
BIGINT |
Integer value of the block number. |
|
ADDRESS |
VARCHAR |
Deployment address of the contract, unique identifier for a contract. |
|
PROXY_CONTRACT_IMPL_ADDRESS |
VARCHAR |
Contains address of the proxy implementations of the contract. |
|
CONTRACT_CREATOR_ADDRESS |
VARCHAR |
Address of an owner/deployer of the contract. |
Contains information regarding the transfers of semi fungible tokens (SFT) in a block.
|
Column |
Data Type |
Description |
|
VALUE_ |
VARCHAR |
Value of ERC1155 token which is transferred. |
|
TO_ |
VARCHAR |
Destination “to” address of the wallet involved in transfer. |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
|
EVENT_INDEX |
SMALLINT |
“Log index” refers to the index of a log in transaction. |
|
TIME_STAMP |
TIMESTAMP |
Timestamp of the transfer. |
|
OPERATOR |
VARCHAR |
The address of the operator who will receive full rights for the owner’s tokens. |
|
FROM_ |
VARCHAR |
Source “from” address of the wallet involved in transfer. |
|
ID |
VARCHAR |
Token identifier (ID) similar to NFT. |
|
CONTRACT_ADDRESS |
VARCHAR |
Address of the ERC 1155 contract or SFT which is involved in transfers. |
|
BLOCK_NUMBER |
BIGINT |
Integer value of the block number. |
Contains information regarding the transfers of semi fungible tokens (SFT) in a block.
|
Column |
Data Type |
Description |
|
TO_ |
VARCHAR |
Destination “to” address of the wallet involved in transfer. |
|
TIME_STAMP |
TIMESTAMP |
Timestamp of the transfer. |
|
BLOCK_NUMBER |
BIGINT |
Integer value of the block number. |
|
FROM_ |
VARCHAR |
Source “from” address of the wallet involved in transfer. |
|
VALUES_ |
VARCHAR |
Total value of the ERC1155 in the batch. |
|
CONTRACT_ADDRESS |
VARCHAR |
Address of the ERC 1155 contract or SFT which is involved in transfers. |
|
OPERATOR |
VARCHAR |
The address of the operator who will receive full rights for the owner’s tokens. |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
|
EVENT_INDEX |
SMALLINT |
“Log index” refers to the index of a log in transaction. |
|
IDs |
VARCHAR |
Token ID entifiers (IDs) similar to NFT of the tokens involved in transfers in the batch. |
Contains information regarding the approval status for the transfers of ERC20 or fungible tokens (FT).
|
Column |
Data Type |
Description |
|
OWNER |
VARCHAR |
Address of the wallet of the owner of FT. |
|
SPENDER |
VARCHAR |
Address of the wallet of FT buyer (spender). |
|
EVENT_INDEX |
SMALLINT |
“Log index” refers to the index of a log in transaction. |
|
CONTRACT_ADDRESS |
VARCHAR |
Address of the ERC 20 contract or FT which is involved in transfers. |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
|
VALUE_ |
VARCHAR |
Total value of the ERC20 transfer that is approved. |
Contains information regarding the transfers of ERC20 fungible tokens (FT) in a block.
|
Column |
Data Type |
Description |
|
CONTRACT_ADDRESS |
VARCHAR |
Address of the ERC20 contract which is involved in transfers. |
|
TO_ |
VARCHAR |
Destination “to” address of the wallet involved in transfer. |
|
FROM_ |
VARCHAR |
Source “from” address of the wallet involved in transfer. |
|
VALUE_ |
VARCHAR |
Total value of the ERC20 transfer that is approved. |
|
BLOCK_NUMBER |
BIGINT |
Integer value of the block number. |
|
EVENT_INDEX |
SMALLINT |
“Log index” refers to the index of a log in transaction. |
|
TIME_STAMP |
TIMESTAMP |
Timestamp of the transfer. |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
Contains information regarding the approval involving transfers of ERC721 non fungible tokens (NFT) in a block.
|
Column |
Data Type |
Description |
|
TOKEN_ID |
VARCHAR |
Token ID of the NFT. |
|
OWNER |
VARCHAR |
Address of the owner's wallet for the NFT. |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
|
APPROVED |
VARCHAR |
If the NFT transfer is approved or not. |
|
CONTRACT_ADDRESS |
VARCHAR |
Address of the ERC 721 contract or NFT which is involved in transfer. |
|
EVENT_INDEX |
SMALLINT |
“Log index” refers to the index of a log in transaction. |
Contains information regarding the transfers of ERC721 non fungible tokens (NFT) in a block.
|
Column |
Data Type |
Description |
|
TOKEN_ID |
VARCHAR |
Token ID of the NFT. |
|
BLOCK_NUMBER |
BIGINT |
Integer value of the block number. |
|
EVENT_INDEX |
SMALLINT |
“Log index” refers to the index of a log in transaction. |
|
CONTRACT_ADDRESS |
VARCHAR |
Address of the ERC 721 contract or NFT which is involved in transfer. |
|
TO_ |
VARCHAR |
Destination “to” address of the wallet involved in transfer. |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
|
FROM_ |
VARCHAR |
Source “from” address of the wallet involved in transfer. |
|
TIME_STAMP |
TIMESTAMP |
Timestamp of the transfer. |
Contains information regarding the wallets which are involved in ERC721 non fungible tokens (NFT) transactions in a block.
|
Column |
Data Type |
Description |
|
WALLET_ADDRESS |
VARCHAR |
Address of the wallet. |
|
BALANCE |
VARCHAR |
Current NFT balance of the wallet. |
|
BLOCK_NUMBER |
BIGINT |
Integer value of the block number. |
|
TIME_STAMP |
TIMESTAMP |
Timestamp of the transfer. |
|
TOKEN_ADDRESS |
VARCHAR |
Address of the ERC721 token. |
Contains information regarding the transaction logs generated in transactions of a block.
|
Column |
Data Type |
Description |
|
DATA_ |
VARCHAR |
Data emitted by the transaction log. |
|
NAME |
VARCHAR |
Name of the event emitted. |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
|
TOPIC_1 |
VARCHAR |
Topic 1 (topic index 1) of the event. |
|
ANONYMOUS |
BOOLEAN |
Contains a check for anonymous events. |
|
ADDRESS |
VARCHAR |
Address of the log emitter. |
|
STATUS |
INTEGER |
This represents whether the log is decoded or not. Added the sets of
values the status column can have. 0 = decoded 1 = contract not verified 9 = ABI not found or the event does not exist in ABI. |
|
EVENT_INDEX |
SMALLINT |
“Log index” refers to the index of a log in transaction. |
|
TOPIC_2 |
VARCHAR |
Topic 2 (topic index 2) of the event. |
|
TOPIC_3 |
VARCHAR |
Topic 3 (topic index 3) of the event. |
|
TOPIC_0 |
VARCHAR |
Topic 0 (topic index 0) of the event. |
NATIVE_WALLET
Contains information regarding the native or Ethereum wallets that can store ethers.
|
Column |
Data Type |
Description |
|
BALANCE |
VARCHAR |
Ether balance of the native wallet. |
|
TIME_STAMP |
TIMESTAMP |
Timestamp of the transfer. |
|
WALLET_ADDRESS |
VARCHAR |
Address of the wallet. |
|
BLOCK_NUMBER |
BIGINT |
Integer value of the block number. |
Contains information regarding native token (Ether, BNB, etc.) transfers encountered in the blocks.
|
Column |
Data Type |
Description |
|
FROM_ |
VARCHAR |
Source “from” address of the wallet involved in transfer. |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
|
VALUE_ |
VARCHAR |
Value of amount of tokens involved in transfers. |
|
TIME_STAMP |
TIMESTAMP |
Timestamp of the transfer. |
|
BLOCK_NUMBER |
BIGINT |
Integer value of the block number. |
|
TO_ |
VARCHAR |
Destination “to” address of the wallet involved in transfer. |
Contains information regarding ERC 721 tokens/NFTs encountered in transactions.
|
Column |
Data Type |
Description |
|
CONTRACT_ADDRESS |
VARCHAR |
ERC 721 address or contract address for the token. |
|
TOKEN_URI |
VARCHAR |
URI of the NFT token. |
|
TOKEN_ID |
VARCHAR |
Token ID of the NFT. |
|
TIME_STAMP |
TIMESTAMP |
Timestamp of the NFT creation. |
Contains information regarding ERC 721 tokens/NFTs collections, NFT collections are set of NFTs designed/created by an common owner.
|
Column |
Data Type |
Description |
|
NAME |
VARCHAR |
Name of NFT collection |
|
TOKEN_STANDARD |
VARCHAR |
Standard protocol for a collection. |
|
ADDRESS |
VARCHAR |
Address of the NFT collection. |
|
SYMBOL |
VARCHAR |
Unique symbol for the collection. |
Contains information regarding an event “ownershiptransferred” which is triggered when tokens are transferred from one owner (account) to another.
|
Column |
Data Type |
Description |
|
CONTRACT_ADDRESS |
VARCHAR |
Contract address of the token involved in transfer. |
|
PREVIOUSOWNER |
VARCHAR |
Previous owner (wallet) address. |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
|
NEWOWNER |
VARCHAR |
New owner (wallet) address. |
|
EVENT_INDEX |
SMALLINT |
“Log index” refers to the index of a log in transaction. |
Contains information regarding tokens involved in transactions of the blocks.
|
Column |
Data Type |
Description |
|
DECIMALS |
VARCHAR |
Decimal place value for the token. |
|
SYMBOL |
VARCHAR |
Symbol of the token. |
|
NAME |
VARCHAR |
Name of the token. |
|
ADDRESS |
VARCHAR |
Contract address of the token. |
Contains detailed information of transactions in the blocks.
|
Column |
Data Type |
Description |
|
TYPE |
VARCHAR |
Type of the transaction. |
|
MAX_FEE_PER_GAS |
VARCHAR |
Max gas fee to be paid in transaction execution. |
|
GAS_PRICE |
VARCHAR |
Gas price on which transaction used gas. |
|
TRANSACTION_INDEX |
INTEGER |
Index of the transaction. |
|
MAX_PRIORITY_FEE_PER_GAS |
VARCHAR |
The absolute maximum you are willing to pay per unit of gas to get your transaction included in a block. |
|
RECEPIENT_CONTRACT_ADDRESS |
VARCHAR |
Contract address interacted with in the transaction. |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
|
METHOD_ID |
VARCHAR |
Method ID of the function involved in execution of transaction. |
|
RECEIPT_EFFECTIVE_GAS_PRICE |
VARCHAR |
Gas price in effect on the transaction. |
|
NONCE |
INTEGER |
Nonce is a random 32-bit number that miners use as a base for their hash calculations. |
|
CHAIN_ID |
VARCHAR |
Chain ID of the blockchain. |
|
FUNCTION_NAME |
VARCHAR |
Function involved in execution of transaction. |
|
LOGS_COUNT |
SMALLINT |
Number of logs in transaction. |
|
RECEIPT_GAS_USED |
INTEGER |
Amount of gas used for execution of transaction. |
Contains information about the transactions executed in the block.
|
Column |
Data Type |
Description |
|
BLOCK_NUMBER |
BIGINT |
Integer value of the block number. |
|
RECEIPT_STATUS |
INTEGER |
Receipt/Transaction status. |
|
TRANSACTION_FEE |
VARCHAR |
Fee required to execute transaction. |
|
TIME_STAMP |
TIMESTAMP |
Timestamp of the transaction creation. |
|
TO_ADDRESS |
VARCHAR |
Address of the receiver of the transaction value. |
|
RECEIPT_CUMULATIVE_GAS_USED |
INTEGER |
Total gas used in execution of transaction. |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
|
VALUE_ |
VARCHAR |
Value of the amount involved in transaction. |
|
FROM_ADDRESS |
VARCHAR |
Address of the source wallet from which value is deducted. |
|
GAS |
VARCHAR |
Gas used in transaction. |
Contains information for block data, one record per block.
|
Column |
Data Type |
Description |
|
BLOCK_HASH |
VARCHAR |
Hashed value of the current block payload with previous block_hash, to guarantee immutability. |
|
BLOCK_NUMBER |
BIGINT |
Integer value of the block number. |
|
BASE_FEE_PER_GAS |
VARCHAR |
Fee calculated by a formula that compares the size of the previous block (the amount of gas used for all the transactions) with the target size. |
|
REWARD |
VARCHAR |
Refers to the cryptocurrency rewarded to a miner when they successfully validate a new block. |
|
GAS_LIMIT |
INTEGER |
The maximum amount of work you're estimating a validator will do on a particular transaction. |
|
PARENT_HASH |
VARCHAR |
Hashed value for parent node of the Merkle tree in the block. |
|
GAS_USED |
INTEGER |
Amount of gas used in the mining of the block. |
|
SIZE_ |
INTEGER |
Size of block data in bytes. |
|
MINER |
VARCHAR |
Address of the miner. |
|
TRANSACTION_COUNT |
INTEGER |
Number of transactions present in the block. |
|
TIME_STAMP |
TIMESTAMP |
Timestamp of the block creation. |
Contains additional information for the block data, one record per block. FK block_number to blocks table.
|
Column |
Data Type |
Description |
|
SHA3_UNCLES |
VARCHAR |
Hashed value of all the uncle blocks for a block. |
|
RECEIPTS_ROOT |
BIGINT |
Receipts root is the Keccak 256-bit hash of the root node of the transaction receipt trie. Trie is composed of all receipts. |
|
NONCE |
VARCHAR |
Nonce is a random 32-bit number that miners use as a base for their hash calculations. |
|
STATE_ROOT |
VARCHAR |
It is the Keccak 256-bit hash of the root node of the state trie after all the transactions are executed. |
|
BLOCK_NUMBER |
BIGINT |
Integer value of the block number. |
|
VERSION |
VARCHAR |
Internal purpose. |
|
UNCLES_COUNT |
INTEGER |
Number of uncles block generated with the block. |
|
TRANSACTIONS_ROOT |
VARCHAR |
Root hash of the transactions sequence in blocks. |
|
LOGS_BLOOM |
VARCHAR |
Data structure containing event logs. |
Contains information regarding the event “approvalforall” which is triggered when an owner gives or changes approval for all of their NFTs to an operator.
|
Column |
Data Type |
Description |
|
ACCOUNT |
VARCHAR |
Hashed value of all the uncle blocks for a block. |
|
CONTRACT_ADDRESS |
VARCHAR |
Address of the contract which emits this event. |
|
EVENT_INDEX |
SMALLINT |
“Log index” refers to the index of a log in transaction. |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
|
APPROVED |
BOOLEAN |
Contains information if changes in NFT are approved or not. |
|
OPERATOR |
VARCHAR |
The address of the operator who will receive full rights for the owner’s tokens. |
Contains information regarding the contracts involved in transactions in a block.
|
Column |
Data Type |
Description |
|
TIME_STAMP |
TIMESTAMP |
Timestamp of contract deployment/creation |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
|
BLOCK_NUMBER |
BIGINT |
Integer value of the block number. |
|
ADDRESS |
VARCHAR |
Deployment address of the contract, unique identifier for a contract. |
|
PROXY_CONTRACT_IMPL_ADDRESS |
VARCHAR |
Contains address of the proxy implementations of the contract. |
|
CONTRACT_CREATOR_ADDRESS |
VARCHAR |
Address of an owner/deployer of the contract. |
Contains information regarding the transfers of semi fungible tokens (SFT) in a block.
|
Column |
Data Type |
Description |
|
VALUE_ |
VARCHAR |
Value of ERC1155 token which is transferred. |
|
TO_ |
VARCHAR |
Destination “to” address of the wallet involved in transfer. |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
|
EVENT_INDEX |
SMALLINT |
“Log index” refers to the index of a log in transaction. |
|
TIME_STAMP |
TIMESTAMP |
Timestamp of the transfer. |
|
OPERATOR |
VARCHAR |
The address of the operator who will receive full rights for the owner’s tokens. |
|
FROM_ |
VARCHAR |
Source “from” address of the wallet involved in transfer. |
|
ID |
VARCHAR |
Token identifier (ID) similar to NFT. |
|
CONTRACT_ADDRESS |
VARCHAR |
Address of the ERC 1155 contract or NFT which is involved in transfers. |
|
BLOCK_NUMBER |
BIGINT |
Integer value of the block number. |
Contains information regarding the transfers of semi fungible tokens (SFT) in a block.
|
Column |
Data Type |
Description |
|
TO_ |
VARCHAR |
Destination “to” address of the wallet involved in transfer. |
|
TIME_STAMP |
TIMESTAMP |
Timestamp of the transfer. |
|
BLOCK_NUMBER |
BIGINT |
Integer value of the block number. |
|
FROM_ |
VARCHAR |
Source “from” address of the wallet involved in transfer. |
|
VALUES_ |
VARCHAR |
Total value of the ERC1155 in the batch. |
|
CONTRACT_ADDRESS |
VARCHAR |
Address of the ERC 1155 contract or SFT which is involved in transfers. |
|
OPERATOR |
VARCHAR |
The address of the operator who will receive full rights for the owner’s tokens. |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
|
EVENT_INDEX |
SMALLINT |
“Log index” refers to the index of a log in transaction. |
|
IDs |
VARCHAR |
Token ID entifiers (IDs) similar to NFT of the tokens involved in transfers in the batch. |
Contains information regarding the approval status for the transfers of ERC20 or fungible tokens (FT).
|
Column |
Data Type |
Description |
|
OWNER |
VARCHAR |
Address of the wallet of the owner of FT. |
|
SPENDER |
VARCHAR |
Address of the wallet of FT buyer (spender). |
|
EVENT_INDEX |
SMALLINT |
“Log index” refers to the index of a log in transaction. |
|
CONTRACT_ADDRESS |
VARCHAR |
Address of the ERC 20 contract or FT which is involved in transfers. |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
|
VALUE_ |
VARCHAR |
Total value of the ERC20 transfer that is approved. |
Contains information regarding the transfers of ERC20 fungible tokens (FT) in a block.
|
Column |
Data Type |
Description |
|
CONTRACT_ADDRESS |
VARCHAR |
Address of the ERC20 contract which is involved in transfers. |
|
TO_ |
VARCHAR |
Destination “to” address of the wallet involved in transfer. |
|
FROM_ |
VARCHAR |
Source “from” address of the wallet involved in transfer. |
|
VALUE_ |
VARCHAR |
Total value of the ERC20 transfer that is approved. |
|
BLOCK_NUMBER |
BIGINT |
Integer value of the block number. |
|
EVENT_INDEX |
SMALLINT |
“Log index” refers to the index of a log in transaction. |
|
TIME_STAMP |
TIMESTAMP |
Timestamp of the transfer. |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
Contains information regarding the approval involving transfers of ERC721 non fungible tokens (NFT) in a block.
|
Column |
Data Type |
Description |
|
TOKEN_ID |
VARCHAR |
Token ID of the NFT. |
|
OWNER |
VARCHAR |
Address of the owner's wallet for the NFT. |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
|
APPROVED |
VARCHAR |
If the NFT transfer is approved or not. |
|
CONTRACT_ADDRESS |
VARCHAR |
Address of the ERC 721 contract or NFT which is involved in transfer. |
|
EVENT_INDEX |
SMALLINT |
“Log index” refers to the index of a log in transaction. |
Contains information regarding the transfers of ERC721 non fungible tokens (NFT) in a block.
|
Column |
Data Type |
Description |
|
TOKEN_ID |
VARCHAR |
Token ID of the NFT. |
|
BLOCK_NUMBER |
BIGINT |
Integer value of the block number. |
|
EVENT_INDEX |
SMALLINT |
“Log index” refers to the index of a log in transaction. |
|
CONTRACT_ADDRESS |
VARCHAR |
Address of the ERC 721 contract or NFT which is involved in transfer. |
|
TO_ |
VARCHAR |
Destination “to” address of the wallet involved in transfer. |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
|
FROM_ |
VARCHAR |
Source “from” address of the wallet involved in transfer. |
|
TIME_STAMP |
TIMESTAMP |
Timestamp of the transfer. |
Contains information regarding the wallets which are involved in ERC721 non fungible tokens (NFT) transactions in a block.
|
Column |
Data Type |
Description |
|
WALLET_ADDRESS |
VARCHAR |
Address of the wallet. |
|
BALANCE |
VARCHAR |
Current NFT balance of the wallet. |
|
BLOCK_NUMBER |
BIGINT |
Integer value of the block number. |
|
TIME_STAMP |
TIMESTAMP |
Timestamp of the transfer. |
|
TOKEN_ADDRESS |
VARCHAR |
Address of the ERC721 token. |
Contains information regarding the transaction logs generated in transactions of a block.
|
Column |
Data Type |
Description |
|
DATA_ |
VARCHAR |
Data emitted by the transaction log. |
|
NAME |
VARCHAR |
Name of the event emitted. |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
|
TOPIC_1 |
VARCHAR |
Topic 1 (topic index 1) of the event. |
|
ANONYMOUS |
BOOLEAN |
Contains a check for anonymous events. |
|
ADDRESS |
VARCHAR |
Address of the log emitter. |
|
STATUS |
INTEGER |
this represents whether the log is decoded or not. Added the sets of
values the status column can have. 0 = decoded 1 = contract not verified 9 = ABI not found or event does not exist in ABI. |
|
EVENT_INDEX |
SMALLINT |
“Log index” refers to the index of a log in transaction. |
|
TOPIC_2 |
VARCHAR |
Topic 2 (topic index 2) of the event. |
|
TOPIC_3 |
VARCHAR |
Topic 3 (topic index 3) of the event. |
|
TOPIC_0 |
VARCHAR |
Topic 0 (topic index 0) of the event. |
Contains information regarding the native or Ethereum wallets that can store ethers.
|
Column |
Data Type |
Description |
|
BALANCE |
VARCHAR |
Ether balance of the native wallet. |
|
TIME_STAMP |
TIMESTAMP |
Timestamp of the transfer. |
|
WALLET_ADDRESS |
VARCHAR |
Address of the wallet. |
|
BLOCK_NUMBER |
BIGINT |
Integer value of the block number. |
Contains information regarding native token (Ether, BNB, etc.) transfers encountered in the blocks.
|
Column |
Data Type |
Description |
|
FROM_ |
VARCHAR |
Source “from” address of the wallet involved in transfer. |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
|
VALUE_ |
VARCHAR |
Value of amount of tokens involved in transfers. |
|
TIME_STAMP |
TIMESTAMP |
Timestamp of the transfer |
|
BLOCK_NUMBER |
BIGINT |
Integer value of the block number. |
|
TO_ |
VARCHAR |
Destination “to” address of the wallet involved in transfer. |
Contains information regarding ERC 721 tokens/NFTs encountered in transactions.
|
Column |
Data Type |
Description |
|
CONTRACT_ADDRESS |
VARCHAR |
ERC 721 address or contract address for the token. |
|
TOKEN_URI |
VARCHAR |
URI of the NFT token. |
|
TOKEN_ID |
VARCHAR |
Token ID of the NFT. |
|
TIME_STAMP |
TIMESTAMP |
Timestamp of the NFT creation. |
Contains information regarding ERC 721 tokens/NFTs collections, NFT collections are set of NFTs designed/created by an common owner.
|
Column |
Data Type |
Description |
|
NAME |
VARCHAR |
Name of NFT collection |
|
TOKEN_STANDARD |
VARCHAR |
Standard protocol for the collection. |
|
ADDRESS |
VARCHAR |
Address of the NFT collection. |
|
SYMBOL |
VARCHAR |
Unique symbol for the collection. |
Contains information regarding an event “ownershiptransferred” which is triggered when tokens are transferred from one owner (account) to another.
|
Column |
Data Type |
Description |
|
CONTRACT_ADDRESS |
VARCHAR |
Contract address of the token involved in transfer. |
|
PREVIOUSOWNER |
VARCHAR |
Previous owner (wallet) address. |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
|
NEWOWNER |
VARCHAR |
New owner (wallet) address. |
|
EVENT_INDEX |
SMALLINT |
“Log index” refers to the index of a log in transaction. |
Contains information regarding tokens involved in transactions of the blocks.
|
Column |
Data Type |
Description |
|
DECIMALS |
VARCHAR |
Decimal place value for the token. |
|
SYMBOL |
VARCHAR |
Symbol of the token. |
|
NAME |
VARCHAR |
Name of the token. |
|
ADDRESS |
VARCHAR |
Contract address of the token. |
Contains detailed information of transactions in the blocks.
|
Column |
Data Type |
Description |
|
TYPE |
VARCHAR |
Type of the transaction. |
|
MAX_FEE_PER_GAS |
VARCHAR |
Max gas fee to be paid in transaction execution. |
|
GAS_PRICE |
VARCHAR |
Gas price on which transaction used gas. |
|
TRANSACTION_INDEX |
INTEGER |
Index of the transaction. |
|
MAX_PRIORITY_FEE_PER_GAS |
VARCHAR |
The absolute maximum you are willing to pay per unit of gas to get your transaction included in a block. |
|
RECEPIENT_CONTRACT_ADDRESS |
VARCHAR |
Contract address interacted with in the transaction. |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
|
METHOD_ID |
VARCHAR |
Method ID of the function involved in execution of transaction. |
|
RECEIPT_EFFECTIVE_GAS_PRICE |
VARCHAR |
Gas price in effect on the transaction. |
|
NONCE |
INTEGER |
Nonce is a random 32-bit number that miners use as a base for their hash calculations. |
|
CHAIN_ID |
VARCHAR |
Chain ID of the blockchain. |
|
FUNCTION_NAME |
VARCHAR |
Function involved in execution of transaction. |
|
LOGS_COUNT |
SMALLINT |
Number of logs in transaction. |
|
RECEIPT_GAS_USED |
INTEGER |
Amount of gas used for execution of transaction. |
TRANSACTIONS
Contains information about the transactions
executed in the block.
|
Column |
Data Type |
Description |
|
BLOCK_NUMBER |
BIGINT |
Integer value of the block number. |
|
RECEIPT_STATUS |
INTEGER |
Receipt/Transaction status. |
|
TRANSACTION_FEE |
VARCHAR |
Fee required to execute transaction. |
|
TIME_STAMP |
TIMESTAMP |
Timestamp of the transaction creation. |
|
TO_ADDRESS |
VARCHAR |
Address of the receiver of the transaction value. |
|
RECEIPT_CUMULATIVE_GAS_USED |
INTEGER |
Total gas used in execution of transaction. |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
|
VALUE_ |
VARCHAR |
Value of the amount involved in transaction. |
|
FROM_ADDRESS |
VARCHAR |
Address of the source wallet from which value is deducted. |
|
GAS |
VARCHAR |
Gas used in transaction. |
Contains information for block data, one record per block.
|
Column |
Data Type |
Description |
|
BLOCK_HASH |
VARCHAR |
Hashed value of the current block payload with previous block_hash, to guarantee immutability. |
|
BLOCK_NUMBER |
BIGINT |
Integer value of the block number. |
|
BASE_FEE_PER_GAS |
VARCHAR |
Fee calculated by a formula that compares the size of the previous block (the amount of gas used for all the transactions) with the target size. |
|
REWARD |
VARCHAR |
Refers to the cryptocurrency rewarded to a miner when they successfully validate a new block. |
|
GAS_LIMIT |
INTEGER |
The maximum amount of work you're estimating a validator will do on a particular transaction. |
|
PARENT_HASH |
VARCHAR |
Hashed value for parent node of the Merkle tree in the block. |
|
GAS_USED |
INTEGER |
Amount of gas used in the mining of the block. |
|
SIZE_ |
INTEGER |
Size of block data in bytes. |
|
MINER |
VARCHAR |
Address of the miner. |
|
TRANSACTION_COUNT |
INTEGER |
Number of transactions present in the block. |
|
TIME_STAMP |
TIMESTAMP |
Timestamp of the block creation. |
Contains additional information for the block data, one record per block. FK block_number to blocks table.
|
Column |
Data Type |
Description |
|
SHA3_UNCLES |
VARCHAR |
Hashed value of all the uncle blocks for a block. |
|
RECEIPTS_ROOT |
BIGINT |
Receipts root is the Keccak 256-bit hash of the root node of the transaction receipt trie. Trie is composed of all receipts. |
|
NONCE |
VARCHAR |
Nonce is a random 32-bit number that miners use as a base for their hash calculations. |
|
STATE_ROOT |
VARCHAR |
It is the Keccak 256-bit hash of the root node of the state trie after all the transactions are executed. |
|
BLOCK_NUMBER |
BIGINT |
Integer value of the block number. |
|
VERSION |
VARCHAR |
Internal purpose. |
|
UNCLES_COUNT |
INTEGER |
Number of uncles block generated with the block. |
|
TRANSACTIONS_ROOT |
VARCHAR |
Root hash of the transactions sequence in blocks. |
|
LOGS_BLOOM |
VARCHAR |
Data structure containing event logs. |
Contains information regarding the event “approvalforall” which is triggered when an owner gives or changes approval for all of their NFTs to an operator.
|
Column |
Data Type |
Description |
|
ACCOUNT |
VARCHAR |
Hashed value of all the uncle blocks for a block. |
|
CONTRACT_ADDRESS |
VARCHAR |
Address of the contract which emits this event. |
|
EVENT_INDEX |
SMALLINT |
“Log index” refers to the index of a log in transaction. |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
|
APPROVED |
BOOLEAN |
Contains information if changes in NFT are approved or not. |
|
OPERATOR |
VARCHAR |
The address of the operator who will receive full rights for the owner’s tokens. |
Contains information regarding the contracts involved in transactions in a block.
|
Column |
Data Type |
Description |
|
TIME_STAMP |
TIMESTAMP |
Timestamp of contract deployment/creation |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
|
BLOCK_NUMBER |
BIGINT |
Integer value of the block number. |
|
ADDRESS |
VARCHAR |
Deployment address of the contract, unique identifier for a contract. |
|
PROXY_CONTRACT_IMPL_ADDRESS |
VARCHAR |
Contains address of the proxy implementations of the contract. |
|
CONTRACT_CREATOR_ADDRESS |
VARCHAR |
Address of an owner/deployer of the contract. |
Contains information regarding the transfers of semi fungible tokens (SFT) in a block.
|
Column |
Data Type |
Description |
|
VALUE_ |
VARCHAR |
Value of ERC1155 token which is transferred. |
|
TO_ |
VARCHAR |
Destination “to” address of the wallet involved in transfer. |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
|
EVENT_INDEX |
SMALLINT |
“Log index” refers to the index of a log in transaction. |
|
TIME_STAMP |
TIMESTAMP |
Timestamp of the transfer. |
|
OPERATOR |
VARCHAR |
The address of the operator who will receive full rights for the owner’s tokens. |
|
FROM_ |
VARCHAR |
Source “from” address of the wallet involved in transfer. |
|
ID |
VARCHAR |
Token identifier (ID) similar to NFT. |
|
CONTRACT_ADDRESS |
VARCHAR |
Address of the ERC 1155 contract or SFT which is involved in transfers. |
|
BLOCK_NUMBER |
BIGINT |
Integer value of the block number. |
Contains information regarding the transfers of semi fungible tokens (SFT) in a block.
|
Column |
Data Type |
Description |
|
TO_ |
VARCHAR |
Destination “to” address of the wallet involved in transfer. |
|
TIME_STAMP |
TIMESTAMP |
Timestamp of the transfer. |
|
BLOCK_NUMBER |
BIGINT |
Integer value of the block number. |
|
FROM_ |
VARCHAR |
Source “from” address of the wallet involved in transfer. |
|
VALUES_ |
VARCHAR |
Total value of the ERC1155 in the batch. |
|
CONTRACT_ADDRESS |
VARCHAR |
Address of the ERC 1155 contract or NFT which is involved in transfers. |
|
OPERATOR |
VARCHAR |
Address of an owner/deployer of the contract. |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
|
EVENT_INDEX |
SMALLINT |
“Log index” refers to the index of a log in transaction. |
|
IDs |
VARCHAR |
Token ID entifiers (IDs) similar to NFT of the tokens involved in transfers in the batch. |
Contains information regarding the approval status for the transfers of ERC20 or fungible tokens (FT).
|
Column |
Data Type |
Description |
|
OWNER |
VARCHAR |
Address of the wallet of the owner of FT. |
|
SPENDER |
VARCHAR |
Address of the wallet of FT buyer (spender). |
|
EVENT_INDEX |
SMALLINT |
“Log index” refers to the index of a log in transaction. |
|
CONTRACT_ADDRESS |
VARCHAR |
Address of the ERC 20 contract or FT which is involved in transfers. |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
|
VALUE_ |
VARCHAR |
Total value of the ERC20 transfer that is approved. |
Contains information regarding the transfers of ERC20 fungible tokens (FT) in a block.
|
Column |
Data Type |
Description |
|
CONTRACT_ADDRESS |
VARCHAR |
Address of the ERC20 contract which is involved in transfers. |
|
TO_ |
VARCHAR |
Destination “to” address of the wallet involved in transfer. |
|
FROM_ |
VARCHAR |
Source “from” address of the wallet involved in transfer. |
|
VALUE_ |
VARCHAR |
Total value of the ERC20 transfer that is approved. |
|
BLOCK_NUMBER |
BIGINT |
Integer value of the block number. |
|
EVENT_INDEX |
SMALLINT |
“Log index” refers to the index of a log in transaction. |
|
TIME_STAMP |
TIMESTAMP |
Timestamp of the transfer. |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
Contains information regarding the approval involving transfers of ERC721 non fungible tokens (NFT) in a block.
|
Column |
Data Type |
Description |
|
TOKEN_ID |
VARCHAR |
Token ID of the NFT. |
|
OWNER |
VARCHAR |
Address of the owner's wallet for the NFT. |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
|
APPROVED |
VARCHAR |
If the NFT transfer is approved or not. |
|
CONTRACT_ADDRESS |
VARCHAR |
Address of the ERC 721 contract or NFT which is involved in transfer. |
|
EVENT_INDEX |
SMALLINT |
“Log index” refers to the index of a log in transaction. |
Contains information regarding the transfers of ERC721 non fungible tokens (NFT) in a block.
|
Column |
Data Type |
Description |
|
TOKEN_ID |
VARCHAR |
Token ID of the NFT. |
|
BLOCK_NUMBER |
BIGINT |
Integer value of the block number. |
|
EVENT_INDEX |
SMALLINT |
“Log index” refers to the index of a log in transaction. |
|
CONTRACT_ADDRESS |
VARCHAR |
Address of the ERC 721 contract or NFT which is involved in transfer. |
|
TO_ |
VARCHAR |
Destination “to” address of the wallet involved in transfer. |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
|
FROM_ |
VARCHAR |
Source “from” address of the wallet involved in transfer. |
|
TIME_STAMP |
TIMESTAMP |
Timestamp of the transfer. |
Contains information regarding the wallets which are involved in ERC721 non fungible tokens (NFT) transactions in a block.
|
Column |
Data Type |
Description |
|
WALLET_ADDRESS |
VARCHAR |
Address of the wallet. |
|
BALANCE |
VARCHAR |
Current NFT balance of the wallet. |
|
BLOCK_NUMBER |
BIGINT |
Integer value of the block number. |
|
TIME_STAMP |
TIMESTAMP |
Timestamp of the transfer. |
|
TOKEN_ADDRESS |
VARCHAR |
Address of the ERC721 token. |
Contains information regarding the transaction logs generated in transactions of a block.
|
Column |
Data Type |
Description |
|
DATA_ |
VARCHAR |
Data emitted by the transaction log. |
|
NAME |
VARCHAR |
Name of the event emitted. |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
|
TOPIC_1 |
VARCHAR |
Topic 1 (topic index 1) of the event. |
|
ANONYMOUS |
BOOLEAN |
Contains a check for anonymous events. |
|
ADDRESS |
VARCHAR |
Address of the log emitter. |
|
STATUS |
INTEGER |
this represents whether the log is decoded or not. Added the sets of
values the status column can have. 0 = decoded 1 = contract not verified 9 = ABI not found or event does not exist in ABI. |
|
EVENT_INDEX |
SMALLINT |
“Log index” refers to the index of a log in transaction. |
|
TOPIC_2 |
VARCHAR |
Topic 2 (topic index 2) of the event. |
|
TOPIC_3 |
VARCHAR |
Topic 3 (topic index 3) of the event. |
|
TOPIC_0 |
VARCHAR |
Topic 0 (topic index 0) of the event. |
Contains information regarding the native or Ethereum wallets that can store ethers.
|
Column |
Data Type |
Description |
|
BALANCE |
VARCHAR |
Ether balance of the native wallet. |
|
TIME_STAMP |
TIMESTAMP |
Timestamp of the transfer. |
|
WALLET_ADDRESS |
VARCHAR |
Address of the wallet. |
|
BLOCK_NUMBER |
BIGINT |
Integer value of the block number. |
Contains information regarding native token (Ether, BNB, etc.) transfers encountered in the blocks.
|
Column |
Data Type |
Description |
|
FROM_ |
VARCHAR |
Source “from” address of the wallet involved in transfer. |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
|
VALUE_ |
VARCHAR |
Value of amount of tokens involved in transfers. |
|
TIME_STAMP |
TIMESTAMP |
Timestamp of the transfer. |
|
BLOCK_NUMBER |
BIGINT |
Integer value of the block number. |
|
TO_ |
VARCHAR |
Destination “to” address of the wallet involved in transfer. |
Contains information regarding ERC 721 tokens/NFTs encountered in transactions.
|
Column |
Data Type |
Description |
|
CONTRACT_ADDRESS |
VARCHAR |
ERC 721 address or contract address for the token. |
|
TOKEN_URI |
VARCHAR |
URI of the NFT token. |
|
TOKEN_ID |
VARCHAR |
Token ID of the NFT. |
|
TIME_STAMP |
TIMESTAMP |
Timestamp of the NFT creation. |
Contains information regarding ERC 721 tokens/NFTs collections, NFT collections are set of NFTs designed/created by an common owner.
|
Column |
Data Type |
Description |
|
NAME |
VARCHAR |
Name of NFT collection |
|
TOKEN_STANDARD |
VARCHAR |
Standard protocol for the collection. |
|
ADDRESS |
VARCHAR |
Address of the NFT collection. |
|
SYMBOL |
VARCHAR |
Unique symbol for the collection. |
Contains information regarding an event “ownershiptransferred” which is triggered when tokens are transferred from one owner (account) to another.
|
Column |
Data Type |
Description |
|
CONTRACT_ADDRESS |
VARCHAR |
Contract address of the token involved in transfer. |
|
PREVIOUSOWNER |
VARCHAR |
Previous owner (wallet) address. |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
|
NEWOWNER |
VARCHAR |
New owner (wallet) address. |
|
EVENT_INDEX |
SMALLINT |
“Log index” refers to the index of a log in transaction. |
Contains information regarding tokens involved in transactions of the blocks
|
Column |
Data Type |
Description |
|
DECIMALS |
VARCHAR |
Decimal place value for the token. |
|
SYMBOL |
VARCHAR |
Symbol of the token. |
|
NAME |
VARCHAR |
Name of the token. |
|
ADDRESS |
VARCHAR |
Contract address of the token. |
Contains detailed information of transactions in the blocks.
|
Column |
Data Type |
Description |
|
TYPE |
VARCHAR |
Type of the transaction. |
|
MAX_FEE_PER_GAS |
VARCHAR |
Max gas fee to be paid in transaction execution. |
|
GAS_PRICE |
VARCHAR |
Gas price on which transaction used gas. |
|
TRANSACTION_INDEX |
INTEGER |
Index of the transaction. |
|
MAX_PRIORITY_FEE_PER_GAS |
VARCHAR |
The absolute maximum you are willing to pay per unit of gas to get your transaction included in a block. |
|
RECEPIENT_CONTRACT_ADDRESS |
VARCHAR |
Contract address interacted with in the transaction. |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
|
METHOD_ID |
VARCHAR |
Method ID of the function involved in execution of transaction. |
|
RECEIPT_EFFECTIVE_GAS_PRICE |
VARCHAR |
Gas price in effect on the transaction. |
|
NONCE |
INTEGER |
Nonce is a random 32-bit number that miners use as a base for their hash calculations. |
|
CHAIN_ID |
VARCHAR |
Chain ID of the blockchain. |
|
FUNCTION_NAME |
VARCHAR |
Function involved in execution of transaction. |
|
LOGS_COUNT |
SMALLINT |
Number of logs in transaction. |
|
RECEIPT_GAS_USED |
INTEGER |
Amount of gas used for execution of transaction. |
Contains information about the transactions executed in the block.
|
Column |
Data Type |
Description |
|
BLOCK_NUMBER |
BIGINT |
Integer value of the block number. |
|
RECEIPT_STATUS |
INTEGER |
Receipt/Transaction status. |
|
TRANSACTION_FEE |
VARCHAR |
Fee required to execute transaction. |
|
TIME_STAMP |
TIMESTAMP |
Timestamp of the transaction creation. |
|
TO_ADDRESS |
VARCHAR |
Address of the receiver of the transaction value. |
|
RECEIPT_CUMULATIVE_GAS_USED |
INTEGER |
Total gas used in execution of transaction. |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
|
VALUE_ |
VARCHAR |
Value of the amount involved in transaction. |
|
FROM_ADDRESS |
VARCHAR |
Address of the source wallet from which value is deducted. |
|
GAS |
VARCHAR |
Gas used in transaction. |
Contains information for block data, one record per block.
|
Column |
Data Type |
Description |
|
BLOCK_HASH |
VARCHAR |
Hashed value of the current block payload with previous block_hash, to guarantee immutability. |
|
BLOCK_NUMBER |
BIGINT |
Integer value of the block number. |
|
BASE_FEE_PER_GAS |
VARCHAR |
Fee calculated by a formula that compares the size of the previous block (the amount of gas used for all the transactions) with the target size. |
|
REWARD |
VARCHAR |
Refers to the cryptocurrency rewarded to a miner when they successfully validate a new block. |
|
GAS_LIMIT |
INTEGER |
The maximum amount of work you're estimating a validator will do on a particular transaction. |
|
PARENT_HASH |
VARCHAR |
Hashed value for parent node of the Merkle tree in the block. |
|
GAS_USED |
INTEGER |
Amount of gas used in the mining of the block. |
|
SIZE_ |
INTEGER |
Size of block data in bytes. |
|
MINER |
VARCHAR |
Address of the miner. |
|
TRANSACTION_COUNT |
INTEGER |
Number of transactions present in the block. |
|
TIME_STAMP |
TIMESTAMP |
Timestamp of the block creation. |
Contains additional information for the block data, one record per block. FK block_number to blocks table.
|
Column |
Data Type |
Description |
|
SHA3_UNCLES |
VARCHAR |
Hashed value of all the uncle blocks for a block. |
|
RECEIPTS_ROOT |
BIGINT |
Receipts root is the Keccak 256-bit hash of the root node of the transaction receipt trie. Trie is composed of all receipts. |
|
NONCE |
VARCHAR |
Nonce is a random 32-bit number that miners use as a base for their hash calculations. |
|
STATE_ROOT |
VARCHAR |
It is the Keccak 256-bit hash of the root node of the state trie after all the transactions are executed. |
|
BLOCK_NUMBER |
BIGINT |
Integer value of the block number. |
|
VERSION |
VARCHAR |
Internal purpose. |
|
UNCLES_COUNT |
INTEGER |
Number of uncles block generated with the block. |
|
TRANSACTIONS_ROOT |
VARCHAR |
Root hash of the transactions sequence in blocks. |
|
LOGS_BLOOM |
VARCHAR |
Data structure containing event logs. |
Contains information regarding the event “approvalforall” which is triggered when an owner gives or changes approval for all of their NFTs to an operator.
|
Column |
Data Type |
Description |
|
ACCOUNT |
VARCHAR |
Hashed value of all the uncle blocks for a block. |
|
CONTRACT_ADDRESS |
VARCHAR |
Address of the contract which emits this event. |
|
EVENT_INDEX |
SMALLINT |
“Log index” refers to the index of a log in transaction. |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
|
APPROVED |
BOOLEAN |
Contains information if changes in NFT are approved or not. |
|
OPERATOR |
VARCHAR |
The address of the operator who will receive full rights for the owner’s tokens. |
Contains information regarding the contracts involved in transactions in a block.
|
Column |
Data Type |
Description |
|
TIME_STAMP |
TIMESTAMP |
Timestamp of contract deployment/creation |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
|
BLOCK_NUMBER |
BIGINT |
Integer value of the block number. |
|
ADDRESS |
VARCHAR |
Deployment address of the contract, unique identifier for a contract. |
|
PROXY_CONTRACT_IMPL_ADDRESS |
VARCHAR |
Contains address of the proxy implementations of the contract. |
|
CONTRACT_CREATOR_ADDRESS |
VARCHAR |
Address of an owner/deployer of the contract. |
Contains information regarding the transfers of semi fungible tokens (SFT) in a block.
|
Column |
Data Type |
Description |
|
VALUE_ |
VARCHAR |
Value of ERC1155 token which is transferred. |
|
TO_ |
VARCHAR |
Destination “to” address of the wallet involved in transfer. |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
|
EVENT_INDEX |
SMALLINT |
“Log index” refers to the index of a log in transaction. |
|
TIME_STAMP |
TIMESTAMP |
Timestamp of the transfer. |
|
OPERATOR |
VARCHAR |
The address of the operator who will receive full rights for the owner’s tokens. |
|
FROM_ |
VARCHAR |
Source “from” address of the wallet involved in transfer. |
|
ID |
VARCHAR |
Token identifier (ID) similar to NFT. |
|
CONTRACT_ADDRESS |
VARCHAR |
Address of the ERC 1155 contract or NFT which is involved in transfers. |
|
BLOCK_NUMBER |
BIGINT |
Integer value of the block number. |
Contains information regarding the transfers of semi fungible tokens (SFT) in a block.
|
Column |
Data Type |
Description |
|
TO_ |
VARCHAR |
Destination “to” address of the wallet involved in transfer. |
|
TIME_STAMP |
TIMESTAMP |
Timestamp of the transfer. |
|
BLOCK_NUMBER |
BIGINT |
Integer value of the block number. |
|
FROM_ |
VARCHAR |
Source “from” address of the wallet involved in transfer. |
|
VALUES_ |
VARCHAR |
Total value of the ERC1155 in the batch. |
|
CONTRACT_ADDRESS |
VARCHAR |
Address of the ERC 1155 contract or NFT which is involved in transfers. |
|
OPERATOR |
VARCHAR |
The address of the operator who will receive full rights for the owner’s tokens. |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
|
EVENT_INDEX |
SMALLINT |
“Log index” refers to the index of a log in transaction. |
|
IDs |
VARCHAR |
Token ID entifiers (IDs) similar to NFT of the tokens involved in transfers in the batch. |
Contains information regarding the approval status for the transfers of ERC20 or Fungilble Tokens (FT)
|
Column |
Data Type |
Description |
|
OWNER |
VARCHAR |
Address of the wallet of the owner of FT. |
|
SPENDER |
VARCHAR |
Address of the wallet of FT buyer (spender). |
|
EVENT_INDEX |
SMALLINT |
“Log index” refers to the index of a log in transaction. |
|
CONTRACT_ADDRESS |
VARCHAR |
Address of the ERC 20 contract or FT which is involved in transfers. |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
|
VALUE_ |
VARCHAR |
Total value of the ERC20 transfer that is approved. |
Contains information regarding the transfers of ERC20 fungible tokens (FT) in a block.
|
Column |
Data Type |
Description |
|
CONTRACT_ADDRESS |
VARCHAR |
Address of the ERC20 contract which is involved in transfers. |
|
TO_ |
VARCHAR |
Destination “to” address of the wallet involved in transfer. |
|
FROM_ |
VARCHAR |
Source “from” address of the wallet involved in transfer. |
|
VALUE_ |
VARCHAR |
Total value of the ERC20 transfer that is approved. |
|
BLOCK_NUMBER |
BIGINT |
Integer value of the block number. |
|
EVENT_INDEX |
SMALLINT |
“Log index” refers to the index of a log in transaction. |
|
TIME_STAMP |
TIMESTAMP |
Timestamp of the transfer. |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
Contains information regarding the approval involving transfers of ERC721 non fungible tokens (NFT) in a block.
|
Column |
Data Type |
Description |
|
TOKEN_ID |
VARCHAR |
Token ID of the NFT. |
|
OWNER |
VARCHAR |
Address of the owner's wallet for the NFT. |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
|
APPROVED |
VARCHAR |
If the NFT transfer is approved or not. |
|
CONTRACT_ADDRESS |
VARCHAR |
Address of the ERC 721 contract or NFT which is involved in transfer. |
|
EVENT_INDEX |
SMALLINT |
“Log index” refers to the index of a log in transaction. |
Contains information regarding the transfers of ERC721 non fungible tokens (NFT) in a block.
|
Column |
Data Type |
Description |
|
TOKEN_ID |
VARCHAR |
Token ID of the NFT. |
|
BLOCK_NUMBER |
BIGINT |
Integer value of the block number. |
|
EVENT_INDEX |
SMALLINT |
“Log index” refers to the index of a log in transaction. |
|
CONTRACT_ADDRESS |
VARCHAR |
Address of the ERC 721 contract or NFT which is involved in transfer. |
|
TO_ |
VARCHAR |
Destination “to” address of the wallet involved in transfer. |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
|
FROM_ |
VARCHAR |
Source “from” address of the wallet involved in transfer. |
|
TIME_STAMP |
TIMESTAMP |
Timestamp of the transfer. |
Contains information regarding the wallets which are involved in ERC721 non fungible tokens (NFT) transactions in a block.
|
Column |
Data Type |
Description |
|
WALLET_ADDRESS |
VARCHAR |
Address of the wallet. |
|
BALANCE |
VARCHAR |
Current NFT balance of the wallet. |
|
BLOCK_NUMBER |
BIGINT |
Integer value of the block number. |
|
TIME_STAMP |
TIMESTAMP |
Timestamp of the transfer. |
|
TOKEN_ADDRESS |
VARCHAR |
Address of the ERC721 token. |
Contains information regarding the transaction logs generated in transactions of a block.
|
Column |
Data Type |
Description |
|
DATA_ |
VARCHAR |
Data emitted by the transaction log. |
|
NAME |
VARCHAR |
Name of the event emitted. |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
|
TOPIC_1 |
VARCHAR |
Topic 1 (topic index 1) of the event. |
|
ANONYMOUS |
BOOLEAN |
Contains a check for anonymous events. |
|
ADDRESS |
VARCHAR |
Address of the log emitter. |
|
STATUS |
INTEGER |
this represents whether the log is decoded or not. Added the sets of
values the status column can have. 0 = decoded 1 = contract not verified 9 = ABI not found or event does not exist in ABI. |
|
EVENT_INDEX |
SMALLINT |
“Log index” refers to the index of a log in transaction. |
|
TOPIC_2 |
VARCHAR |
Topic 2 (topic index 2) of the event. |
|
TOPIC_3 |
VARCHAR |
Topic 3 (topic index 3) of the event. |
|
TOPIC_0 |
VARCHAR |
Topic 0 (topic index 0) of the event. |
Contains information regarding the native or Ethereum wallets that can store ethers.
|
Column |
Data Type |
Description |
|
BALANCE |
VARCHAR |
Ether balance of the native wallet. |
|
TIME_STAMP |
TIMESTAMP |
Timestamp of the transfer. |
|
WALLET_ADDRESS |
VARCHAR |
Address of the wallet. |
|
BLOCK_NUMBER |
BIGINT |
Integer value of the block number. |
Contains information regarding native token (Ether, BNB, etc.) transfers encountered in the blocks.
|
Column |
Data Type |
Description |
|
FROM_ |
VARCHAR |
Source “from” address of the wallet involved in transfer. |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
|
VALUE_ |
VARCHAR |
Value of amount of tokens involved in transfers. |
|
TIME_STAMP |
TIMESTAMP |
Timestamp of the transfer. |
|
BLOCK_NUMBER |
BIGINT |
Integer value of the block number. |
|
TO_ |
VARCHAR |
Destination “to” address of the wallet involved in transfer. |
Contains information regarding ERC 721 tokens/NFTs encountered in transactions.
|
Column |
Data Type |
Description |
|
CONTRACT_ADDRESS |
VARCHAR |
ERC 721 address or contract address for the token. |
|
TOKEN_URI |
VARCHAR |
URI of the NFT token. |
|
TOKEN_ID |
VARCHAR |
Token ID of the NFT. |
|
TIME_STAMP |
TIMESTAMP |
Timestamp of the NFT creation. |
Contains information regarding ERC 721 tokens/NFTs collections, NFT collection is a set of NFTs designed/created by a common owner.
|
Column |
Data Type |
Description |
|
NAME |
VARCHAR |
Name of NFT collection |
|
TOKEN_STANDARD |
VARCHAR |
Standard protocol for the collection. |
|
ADDRESS |
VARCHAR |
Address of the NFT collection. |
|
SYMBOL |
VARCHAR |
Unique symbol for the collection. |
Contains information regarding an event “ownershiptransferred” which is triggered when tokens are transferred from one owner (account) to another.
|
Column |
Data Type |
Description |
|
CONTRACT_ADDRESS |
VARCHAR |
Contract address of the token involved in transfer. |
|
PREVIOUSOWNER |
VARCHAR |
Previous owner (wallet) address. |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
|
NEWOWNER |
VARCHAR |
New owner (wallet) address. |
|
EVENT_INDEX |
SMALLINT |
“Log index” refers to the index of a log in transaction. |
Contains information regarding tokens involved in transactions of the blocks.
|
Column |
Data Type |
Description |
|
DECIMALS |
VARCHAR |
Decimal place value for the token. |
|
SYMBOL |
VARCHAR |
Symbol of the token. |
|
NAME |
VARCHAR |
Name of the token. |
|
ADDRESS |
VARCHAR |
Contract address of the token. |
Contains detailed information of transactions in the blocks.
|
Column |
Data Type |
Description |
|
TYPE |
VARCHAR |
Type of the transaction. |
|
MAX_FEE_PER_GAS |
VARCHAR |
Max gas fee to be paid in transaction execution. |
|
GAS_PRICE |
VARCHAR |
Gas price on which transaction used gas. |
|
TRANSACTION_INDEX |
INTEGER |
Index of the transaction. |
|
MAX_PRIORITY_FEE_PER_GAS |
VARCHAR |
The absolute maximum you are willing to pay per unit of gas to get your transaction included in a block. |
|
RECEPIENT_CONTRACT_ADDRESS |
VARCHAR |
Contract address interacted with in the transaction. |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
|
METHOD_ID |
VARCHAR |
Method ID of the function involved in execution of transaction. |
|
RECEIPT_EFFECTIVE_GAS_PRICE |
VARCHAR |
Gas price in effect on the transaction. |
|
NONCE |
INTEGER |
Nonce is a random 32-bit number that miners use as a base for their hash calculations. |
|
CHAIN_ID |
VARCHAR |
Chain ID of the blockchain. |
|
FUNCTION_NAME |
VARCHAR |
Function involved in execution of transaction. |
|
LOGS_COUNT |
SMALLINT |
Number of logs in transaction. |
|
RECEIPT_GAS_USED |
INTEGER |
Amount of gas used for execution of transaction. |
Contains information about the transactions executed in the block.
|
Column |
Data Type |
Description |
|
BLOCK_NUMBER |
BIGINT |
Integer value of the block number. |
|
RECEIPT_STATUS |
INTEGER |
Receipt/Transaction status. |
|
TRANSACTION_FEE |
VARCHAR |
Fee required to execute transaction. |
|
TIME_STAMP |
TIMESTAMP |
Timestamp of the transaction creation. |
|
TO_ADDRESS |
VARCHAR |
Address of the receiver of the transaction value. |
|
RECEIPT_CUMULATIVE_GAS_USED |
INTEGER |
Total gas used in execution of transaction. |
|
TRANSACTION_HASH |
VARCHAR |
Hashed value transaction identifier. |
|
VALUE_ |
VARCHAR |
Value of the amount involved in transaction. |
|
FROM_ADDRESS |
VARCHAR |
Address of the source wallet from which value is deducted. |
|
GAS |
VARCHAR |
Gas used in transaction. |
Updated 13 days ago