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:
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 |
Examples:
Last updated