🗃️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

Last updated