Daily Wallet Address Stats

The Daily Wallet Address Stats table provides daily statistics for each wallet address. This table is updated on a daily basis and includes information about the number and value of transactions (incoming, outgoing, and self), internal transactions, and token transfers (ERC20, ERC721, and ERC1155) associated with each address.

Column Name	Data Type	Note
address	str	length 42
block_date	date
txn_in_cnt	int
txn_out_cnt	int
txn_self_cnt	int
txn_in_error_cnt	int
txn_out_error_cnt	int
txn_self_error_cnt	int
txn_in_value	int
txn_out_value	int
internal_txn_in_cnt	int
internal_txn_out_cnt	int
internal_txn_in_value	int
internal_txn_out_value	int
erc20_transfer_in_cnt	int
erc721_transfer_in_cnt	int
erc1155_transfer_in_cnt	int
erc20_transfer_out_cnt	int
erc721_transfer_out_cnt	int
erc1155_transfer_out_cnt	int
internal_txn_cnt	int
erc20_transfer_cnt	int
erc721_transfer_cnt	int
erc1155_transfer_cnt	int
txn_cnt	int

Examples

{
  "address": "0x2821023289920dd815ca1f5adb0a33328afb3bfe",
  "block_date": "2023-10-25",
  "txn_in_cnt": 4,
  "txn_out_cnt": 44,
  "txn_self_cnt": 0,
  "txn_in_error_cnt": 0,
  "txn_out_error_cnt": 1,
  "txn_self_error_cnt": 0,
  "txn_in_value": 45655000000001070,
  "txn_out_value": 49278943858313640,
  "internal_txn_in_cnt": 0,
  "internal_txn_out_cnt": 0,
  "internal_txn_in_value": null,
  "internal_txn_out_value": null,
  "erc20_transfer_in_cnt": 13,
  "erc721_transfer_in_cnt": 13,
  "erc1155_transfer_in_cnt": 3,
  "erc20_transfer_out_cnt": 9,
  "erc721_transfer_out_cnt": 1,
  "erc1155_transfer_out_cnt": 1,
  "internal_txn_cnt": 0,
  "erc20_transfer_cnt": 22,
  "erc721_transfer_cnt": 14,
  "erc1155_transfer_cnt": 4,
  "txn_cnt": 48
}

0x2821023289920dd815ca1f5adb0a33328afb3bfe,2023-10-25,4,44,0,0,1,0,45655000000001070,49278943858313640,0,0,,,13,13,3,9,1,1,0,22,14,4,48

Model in the Database

Column Name	Data Type	Note
address	bytea
block_date	date
txn_in_cnt	integer
txn_out_cnt	integer
txn_self_cnt	integer
txn_in_error_cnt	integer
txn_out_error_cnt	integer
txn_self_error_cnt	integer
txn_in_value	numeric(78)
txn_out_value	numeric(78)
internal_txn_in_cnt	integer
internal_txn_out_cnt	integer
internal_txn_in_value	numeric(78)
internal_txn_out_value	numeric(78)
erc20_transfer_in_cnt	integer
erc721_transfer_in_cnt	integer
erc1155_transfer_in_cnt	integer
erc20_transfer_out_cnt	integer
erc721_transfer_out_cnt	integer
erc1155_transfer_out_cnt	integer
internal_txn_cnt	integer
erc20_transfer_cnt	integer
erc721_transfer_cnt	integer
erc1155_transfer_cnt	integer
txn_cnt	integer

{
  "address": "\\x2821023289920dd815ca1f5adb0a33328afb3bfe",
  "block_date": "2023-10-25",
  "txn_in_cnt": 4,
  "txn_out_cnt": 44,
  "txn_self_cnt": 0,
  "txn_in_error_cnt": 0,
  "txn_out_error_cnt": 1,
  "txn_self_error_cnt": 0,
  "txn_in_value": 45655000000001070,
  "txn_out_value": 49278943858313640,
  "internal_txn_in_cnt": 0,
  "internal_txn_out_cnt": 0,
  "internal_txn_in_value": null,
  "internal_txn_out_value": null,
  "erc20_transfer_in_cnt": 13,
  "erc721_transfer_in_cnt": 13,
  "erc1155_transfer_in_cnt": 3,
  "erc20_transfer_out_cnt": 9,
  "erc721_transfer_out_cnt": 1,
  "erc1155_transfer_out_cnt": 1,
  "internal_txn_cnt": 0,
  "erc20_transfer_cnt": 22,
  "erc721_transfer_cnt": 14,
  "erc1155_transfer_cnt": 4,
  "txn_cnt": 48
}

\\x2821023289920dd815ca1f5adb0a33328afb3bfe,2023-10-25,4,44,0,0,1,0,45655000000001070,49278943858313640,0,0,,,13,13,3,9,1,1,0,22,14,4,48