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. Total number of incoming and outgoing transactions

2. Timing of first and last transactions

3. Total number of ETH sent or received

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: