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. |
<span lang="EN" style="font-size:14.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;color:#434343;mso-ansi-language:EN;mso-fareast-language:
EN-US;mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:14.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;color:#434343;mso-ansi-language:EN;mso-fareast-language:
EN-US;mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:14.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;color:#434343;mso-ansi-language:EN;mso-fareast-language:
EN-US;mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:14.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;color:#434343;mso-ansi-language:EN;mso-fareast-language:
EN-US;mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:14.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;color:#434343;mso-ansi-language:EN;mso-fareast-language:
EN-US;mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:14.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;color:#434343;mso-ansi-language:EN;mso-fareast-language:
EN-US;mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:14.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;color:#434343;mso-ansi-language:EN;mso-fareast-language:
EN-US;mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:14.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;color:#434343;mso-ansi-language:EN;mso-fareast-language:
EN-US;mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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. |
<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">
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 5 months ago