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
DEX
dex_swap
DEX
dex_add_liquidity
DEX
dex_remove_liquidty
DEX
dex_deploy_liquidity_pool
NFT
nft_buy
NFT
nft_sell
NFT
nft_mint
Sample Query
Query transaction data by from/to address, block number or hash.
Table Columns
hash
varchar(66)
Unique identifier of a transaction.
0xfff47a31c6d41cc755654d612ed2d8115d408fb5839b697be4f0d16ac368a49b
nonce
bigint
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
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
dex_swap
*field is only available via the API, and are not in the underlying table.
Indexes
block_number
block_timestamp DESC
btree
from_address, block_timestamp DESC
btree
to_address, block_timestamp DESC
btree
Last updated