Unique Key: hash
Column Name | Data Type | Description |
---|---|---|
hash | VARCHAR | Unique identifier of a transaction. |
nonce | BIGINT | The transaction nonce, unique to the wallet |
transaction_index | BIGINT | The position of this transaction in the block that it belongs to. The first transaction has index 0. |
from_address | VARCHAR | The address of the sending party of this transaction. |
to_address | VARCHAR | The address of the receiving party of this transaction (could be a contract address). |
value | VARCHAR | The amount of ether sent in this transaction, in wei. |
gas | BIGINT | The maximum amount of gas allocated for this transaction in wei. |
gas_price | BIGINT | Cost per unit of gas specified by the transaction in wei. The higher the gas price, the higher chance of getting included in a block. |
input | VARCHAR | The data sent along with the transaction. |
receipt_cumulative_gas_used | BIGINT | The total amount of gas used when this transaction was executed in the block. |
receipt_gas_used | BIGINT | The total amount of gas consumed by a transaction as recorded in its receipt |
receipt_contract_address | VARCHAR | The contract address created, if the transaction was a contract creation, otherwise null. |
receipt_root | VARCHAR | Transaction stateroot (pre Byzantium). |
receipt_status | BIGINT | Success status of the transaction. Either 1 (success) or 0 (failure). |
block_timestamp | TIMESTAMP_NTZ(9) | The time when the block that contains this transaction was included on the blockchain. |
block_number | BIGINT | The length of the chain, in blocks. |
block_hash | VARCHAR | Unique identifier of the block that includes this transaction. |
transaction_type | BIGINT | The integer of the transaction type, 0x0 for legacy transactions, 0x1 for access list types, 0x2 for dynamic fees. |
receipt_effective_gas_price | BIGINT | The sum of the base fee and tip paid per unit of gas. |
log_count | BIGINT | Number of event logs emitted in the transaction. |
_created_at | TIMESTAMP_NTZ(9) | Timestamp of the entry creation. |
_updated_at | TIMESTAMP_NTZ(9) | Timestamp of the entry update. |
Unique Key: hash
Column Name | Data Type | Description |
---|---|---|
hash | VARCHAR | Unique identifier of a transaction. |
nonce | BIGINT | The transaction nonce, unique to the wallet |
transaction_index | BIGINT | The position of this transaction in the block that it belongs to. The first transaction has index 0. |
from_address | VARCHAR | The address of the sending party of this transaction. |
to_address | VARCHAR | The address of the receiving party of this transaction (could be a contract address). |
value | VARCHAR | The amount of ether sent in this transaction, in wei. |
gas | BIGINT | The maximum amount of gas allocated for this transaction in wei. |
gas_price | BIGINT | Cost per unit of gas specified by the transaction in wei. The higher the gas price, the higher chance of getting included in a block. |
input | VARCHAR | The data sent along with the transaction. |
receipt_cumulative_gas_used | BIGINT | The total amount of gas used when this transaction was executed in the block. |
receipt_gas_used | BIGINT | The total amount of gas consumed by a transaction as recorded in its receipt |
receipt_contract_address | VARCHAR | The contract address created, if the transaction was a contract creation, otherwise null. |
receipt_root | VARCHAR | Transaction stateroot (pre Byzantium). |
receipt_status | BIGINT | Success status of the transaction. Either 1 (success) or 0 (failure). |
block_timestamp | TIMESTAMP_NTZ(9) | The time when the block that contains this transaction was included on the blockchain. |
block_number | BIGINT | The length of the chain, in blocks. |
block_hash | VARCHAR | Unique identifier of the block that includes this transaction. |
transaction_type | BIGINT | The integer of the transaction type, 0x0 for legacy transactions, 0x1 for access list types, 0x2 for dynamic fees. |
receipt_effective_gas_price | BIGINT | The sum of the base fee and tip paid per unit of gas. |
log_count | BIGINT | Number of event logs emitted in the transaction. |
_created_at | TIMESTAMP_NTZ(9) | Timestamp of the entry creation. |
_updated_at | TIMESTAMP_NTZ(9) | Timestamp of the entry update. |