Transactions
The ethereum.transactions table provides indexed views of all transactions that succeeded, or were partially successful (had at least 1 successful internal transaction).
Columns
| Name | Type | Description |
|---|---|---|
| base_fee_per_gas | numeric |
The base fee to include a transaction in the block (in Wei per gas unit). |
| block_number | integer |
The block number the transaction was included in. |
| contract_address | text |
The address of the contract created by the transaction, if any. |
| fees_burned | numeric |
The amount of transaction fees burned by the transaction (see EIP-1559) (in Wei). |
| fees_rewarded | numeric |
The amount of transaction fees rewarded to the miner of the transaction (in Wei). |
| fees_saved | numeric |
The amount of transaction fees saved by the transaction (in Wei). |
| from_address | text |
The address of the transaction's sender. |
| gas_limit | numeric |
The maximum amount of gas that can be used in the transaction (in gas units). |
| gas_price | numeric |
The actual price of gas used in the transaction (in Wei per gas unit). |
| gas_used | numeric |
The amount of gas used in the transaction (in gas units). |
| input | text |
The input data for the transaction. |
| internal_failed_transaction_count | integer |
The number of internal transactions that failed in the transaction. |
| internal_transaction_count | integer |
The number of successful internal transactions produced in the transaction. |
| log_count | integer |
The number of logs produced in the transaction. |
| max_fee_per_gas | numeric |
The maximum fee used by the transaction (in Wei per gas unit). |
| max_priority_fee_per_gas | numeric |
The maximum priority fee used by the transaction (in Wei per gas unit). |
| nonce | integer |
The transaction sender's nonce. |
| output | text |
The output data for the transaction. |
| position | integer |
The position of the transaction in the block. |
| timestamp | timestamp |
The transaction's timestamp (in ISO-8601 format). |
| to_address | text |
The address of the transaction's recipient, if any. |
| transaction_fee | numeric |
The gas fee paid by the transaction (in Wei). |
| transaction_hash | text |
The transaction's hash. |
| type | integer |
The type of the transaction (see EIP-1559, EIP-2718). |
| value | numeric |
The amount sent by the transaction (in Wei). |
| __confirmed | boolean |
Flag indicating whether the transaction has been confirmed. |
Indexes
| Index |
|---|
| transaction_hash |
| to_address, left(input, 10), block_number, position |
| left(input, 10), block_number, position |
| to_address, block_number, position |
| from_address, block_number, position |
| timestamp, position |
| block_number, position |
| __confirmed WHERE __confirmed = false |
Got questions? Join our Discord
Discord is the primary home of the Transpose developer community. Join us to ask questions, share your work, and get help.