🗃

Address & Their Relationships

These tables describe various relationships addresses have with other addresses, tokens, and entities. Together, we call these aggregates.

Dataset

Aggregate tables are located in the aggregates_$chain dataset. For Ethereum aggregates, the dataset is named aggregates_ethereum, for Avalanche, the dataset is named aggregates_avalanche
The aggregates dataset in Nansen Query

Token Usage Stats

Data on token transfer activity at the wallet label. Table name: token_transfer_stats_by_address_token
Field Name
Data Type
Description
_address_partition
INTEGER
Used for table partitioning, can ignore
token_address
STRING
Address of the ERC20 token
address
STRING
Address of the wallet / user
incoming_nof_token_transfers
INTEGER
Number of incoming token transfers (received)
incoming_total_cents
FLOAT
Total incoming token amount
incoming_first_transfer_at
TIMESTAMP
Timestamp of the first incoming token transfer
incoming_last_transfer_at
TIMESTAMP
Timestamp of the last incoming token transfer
outgoing_nof_token_transfers
INTEGER
Number of outgoing token transfers (sent)
outgoing_total_cents
FLOAT
Total outgoing token amount
outgoing_first_transfer_at
TIMESTAMP
Timestamp of the first outgoing token transfer
outgoing_last_transfer_at
TIMESTAMP
Timestamp of the last outgoing token transfer

Wallet Transaction Stats

Transaction statistics for every single wallet address on chain. Table name: transaction_stats_by_address
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