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.
0x9068357001dc45c59a0c0383860f25fd64daeef205f723c5cbd980f280baca38
transaction_index
bigint
The position of this transaction in the block that it belongs to. The first transaction has index 0.
62
from_address
varchar(44)
The address of the sending party of this transaction.
0x7e63870ac9cb1491928e3c8922c19b2595331ac9
to_address
varchar(44)
The address of the receiving party of this transaction (could be a contract address).
0x68b3465833fb72a70ecdf485e0e4c7bd8665fc45
value
numeric(38)
The amount of ether sent in this transaction, in wei.
3.42E+17
gas
bigint
The maximum amount of gas allocated for this transaction in wei.
209,392
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.
6,545,492,045
input
text
The data send along with the transaction.
<truncated> 0x5ae401dc00000000000000000000000000000000000000000000000000000000632409bf0
receipt_cumulative_gas_used
bigint
The total amount of gas used when this transaction was executed in the block.
6,091,409
receipt_gas_used
bigint
Gas consumed by the transaction in wei.
150,272
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.
2022-09-16 04:59:59
block_number
bigint
The length of the chain, in blocks.
15,543,975
block_hash
varchar(66)
Unique identifier of the block that includes this transaction.
0xe3eb6f24b34ab179646608ca100a3cd1d2fd1144f83544d029c0352429371b6d
max_fee_per_gas
bigint
The sum of the base fee and tip paid per unit of gas.
10,293,849,223
max_priority_fee_per_gas
bigint
2,000,000,000
transaction_type
bigint
Integer of the transaction type, 0x0 for legacy transactions, 0x1 for access list types, 0x2 for dynamic fees.
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.
6,545,492,045
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
block_number
block_timestamp DESC
btree
from_address, block_timestamp DESC
btree
to_address, block_timestamp DESC
btree
Last updated