🗃️Aggregates
Aggregates tables can be used to:
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.
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.
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
✅
Last updated