Transaction Stats

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:
  1. 1.
    Total number of incoming and outgoing transactions
  2. 2.
    Timing of first and last transactions
  3. 3.
    Total number of ETH sent or received
  4. 4.
    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

Examples: