Token Usage Stats

These tables provide data on token transfer activity at a wallet level. You can use these tables to understand total incoming/outgoing tokens, timestamp of token transfers, number of tokens sent/received, timestamp of first and last incoming/outgoing transactions. These tables can also be partitioned using the _address_partition.

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

Table Preview:

Token Transfer Stats By Date Address Token

Field Name	Data Type	Description
address	STRING	Address of the wallet / user
block_date	TIMESTAMP	Timestamp of the token transfer
incoming_first_transfer_at	TIMESTAMP	Timestamp of the first incoming token transfer
incoming_last_transfer_at	TIMESTAMP	Timestamp of the last incoming token transfer
incoming_nof_token_transfers	INTEGER	Number of incoming token transfers (received)
incoming_total_cents	FLOAT	Total incoming 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
outgoing_nof_token_transfers	INTEGER	Number of outgoing token transfers (sent)
outgoing_total_cents	FLOAT	Total outgoing token amount
token_address	STRING	Address of the ERC20 token

Table Preview:

Nansen Query

Examples

As mentioned above, token usage table can be used to analyse token related activity associated with an address. Few example usecases include:

Example 1:

Content

Sample Query: