🗃
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 👀
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 |
---|---|---|
transaction_stats_by_address | ✅ | ✅ |
token_transfer_stats_by_date_address_token | ✅ | ✅ |
token_transfer_stats_by_address_token | ✅ | ✅ |
entity_stats_view | ✅ | |
entity_stats_by_date_view | ✅ | |
entity_usd_flow_by_date_pair_token_view | ✅ | |
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 modified 1mo ago