Transactions
Transactions are cryptographically signed instructions from accounts.
An account will initiate a transaction to update the state of the Ethereum network. Transactions always originate from an externally owned account (a smart contract can not initiate a transaction). Transactions, which change the state of the EVM, need to be broadcast to the whole network. Any node can broadcast a request for a transaction to be executed on the EVM; after this happens, a validator will execute the transaction and propagate the resulting state change to the rest of the network.
Action labels
When using the API, transactions are enriched with action labels that convey the primary intention of the transaction from the perspective of the wallet that created the transaction. Action labeling coverage is not guaranteed to be exhaustive, but will be improved over time.
Supported labels
| Category | Name | Status | Name | Description |
|---|---|---|---|---|
| DEX | dex_swap | ✅ | dex_swap | |
| DEX | dex_add_liquidity | ✅ | dex_add_liquidity | |
| DEX | dex_remove_liquidty | ✅ | dex_remove_liquidity | |
| DEX | dex_deploy_liquidity_pool | ✅ | dex_deploy_liquidity_pool | |
| NFT | nft_buy | ✅ | nft_buy | |
| NFT | nft_sell | ✅ | nft_ | |
| NFT | nft_mint | ✅ |
Sample Query
Query transaction data by from/to address, block number or hash.
PSQLAPI (cURL)
Table Columns
| Column Name | Type | Description | Example |
|---|---|---|---|
| hash | varchar(66) | Unique identifier of a transaction. | 0xfff47a31c6d41cc755654d612ed2d8115d408fb5839b697be4f0d16ac368a49b |
| nonce | bigint | The transaction nonce, unique to the wallet | 3 |
| transaction_index | bigint | The position of this transaction in the block that it belongs to. The first transaction has index 0. | 3 |
| from_address | varchar(44) | The address of the sending party of this transaction. | 0xb5a0bb236466fdb3282d0dff3eb7e4fb33b53f13 |
| to_address | varchar(44) | The address of the receiving party of this transaction (could be a contract address). | 0x9d9c0c4e764117fccd2bc3548f0e95c806e6f996 |
| value | numeric(38) | The amount of ether sent in this transaction, in wei. | 1000000000000000 |
| gas | bigint | The maximum amount of gas allocated for this transaction in wei. | 196966 |
| 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. | 100000056 |
| input | text | The data send along with the transaction. | <truncated> 0x84bb1e42000000000000000000000000b5a0bb236466fdb3282d0dff3eb7e4fb33b53f130000000000000000000000000000000000000000000000000000000000000001000000000000000000000000eeeeeeeeeeeeeeeeeeee |
| receipt_cumulative_gas_used | bigint | The total amount of gas used when this transaction was executed in the block. | 379027 |
| receipt_gas_used | bigint | Gas consumed by the transaction in wei. | 155563 |
| receipt_contract_address | varchar(42) | The contract address created, if the transaction was a contract creation, otherwise null. | |
| receipt_root | varchar(66) | Transaction stateroot (pre Byzantium) | |
| receipt_status | bigint | Success status of the transaction. Either 1 (success) or 0 (failure). | 1 |
| block_timestamp | timestamp | The time when the block that contains this transaction was included on the blockchain. | 2023-08-17T18:40:55 |
| block_number | bigint | The length of the chain, in blocks. | 2754154 |
| block_hash | varchar(66) | Unique identifier of the block that includes this transaction. | 0x3629854087e318ca97647cec62ebbc15ad2550aa73c4db66140e0052f358a0bc |
| max_fee_per_gas | bigint | The sum of the base fee and tip paid per unit of gas. | 100000062 |
| max_priority_fee_per_gas | bigint | The maximum fee per gas the transaction sender is willing to give to validators (Proof of Stake) or miners (Proof of Work) to incentivize them to include their transaction (introduced in EIP1559) | 100000000 |
| transaction_type | bigint | Integer of the transaction type, 0x0 for legacy transactions, 0x1 for access list types, 0x2 for dynamic fees. | 2 |
| log_count | bigint | Number of logs in the transactions | 2 |
| receipt_effective_gas_price | bigint | The integer of the transaction type, 0x0 for legacy transactions, 0x1 for access list types, 0x2 for dynamic fees. | 100000056 |
| function_signature* | varchar | ||
| action* | varchar | A label indicating the primary intention of the transaction, from the perspective of the wallet that created the transaction. See #supported-labelsfor the possible labels. | dex_swap |
*field is only available via the API, and are not in the underlying table.
Indexes
| Index | Type |
|---|---|
| block_number | |
| block_timestamp DESC | btree |
| from_address, block_timestamp DESC | btree |
| to_address, block_timestamp DESC | btree |