Transaction Stats
Last updated
Last updated
To analyse transaction stats for every single wallet on chain, you can use the transaction_stats_by_address table. This table would provide you data like:
Total number of incoming and outgoing transactions
Timing of first and last transactions
Total number of ETH sent or received
Total number of gas paid
| Field Name | Data Type | Description |
|---|---|---|
_address_partition
INTEGER
Used for table partitioning, can ignore
address
STRING
Address of the wallet
incoming_nof_transactions
INTEGER
Number of incoming transactions (receiver)
incoming_nof_wei_transactions
INTEGER
Number of incoming transactions with non-zero wei value (receiver)
incoming_total_wei
NUMERIC
Total amount of incoming wei (received)
incoming_first_transaction_at
TIMESTAMP
Time stamp of the first incoming (receiving) transaction
incoming_last_transaction_at
TIMESTAMP
Time stamp of the last incoming (receiving) transaction
outgoing_nof_transactions
INTEGER
Number of incoming transactions (sender)
outgoing_nof_wei_transactions
INTEGER
Number of incoming transactions with non-zero wei value (sender)
outgoing_total_wei
NUMERIC
Total amount of incoming wei (sent)
outgoing_first_transaction_at
TIMESTAMP
Time stamp of the first outgoing (sending) transaction
outgoing_last_transaction_at
TIMESTAMP
Time stamp of the last outgoing (sending) transaction
outgoing_total_gas_wei
NUMERIC
Total amount of outgoing wei (sent) on gas
block_date_max
DATE
Date of most recent transaction block