🗃️Aggregates

Aggregates tables can be used to:

1. Describe various relationships addresses have with other entities, tokens: You can use this table to understand token transfer stats, transaction stats and dex trades stats related to an address.

2. Describe characteristics about the address itself: Tables like address stats is a compilation of all active addresses on a chain, with useful wallet features such as nft platforms used, bridge used, token balance, eth_balance, most recent transactions at and all the information related to an address. We’re soon going to expand this to labels as well 👀

Accessing Aggregates Datasets

This dataset can be accessed by searching for aggregates in Query. For each chain, the dataset is named as aggregates_[chain_name] (aggregates_ethereum, aggregates_solana).

Following is the list of all the tables that are available for Ethereum and other EVM chains that Nansen supports.

Table	Ethereum	EVM Chains
address_stats	✅	✅
entity_stats_view	✅	✅
entity_stats_by_date_view	✅	✅
entity_usd_flow_by_date_pair_token_view	✅	✅
balances_by_date_address	✅	✅
balances_by_date_entity	✅	✅
transaction_stats_by_address	✅	✅
token_transfer_stats_by_date_address_token	✅	✅
token_transfer_stats_by_address_token	✅	✅
dex_trader_stats_by_hour_token	✅
dex_trader_stats_30d_by_hour_token	✅
dex_trader_stats_by_hour_token	✅
dex_trader_stats_30d_by_hour_token	✅
address_timezone_classifier	✅
liquidity_provider_uniswapv2_profit_stats	✅
bridge_flows_by_date_address_token	✅