Useful stats for user segmentation and lookalike modeling.
Address stats is a new feature from Nansen Query. It's a compilation of all active addresses on a chain, with useful wallet features such as if the address as ever participated in liquidity pool provisioning.
Address stats is a list of all active users, what tokens are being held by the address, and actions this wallet has performed. It's listed under the Aggregates dataset. Table name:
This table is updated daily.
The address of the account
Number of transactions where address is to_address
Number of transactions with ETH value where address is to_address
Number of transactions where address is from_address
Number of transactions with ETH value where address is from_address
Total wei incoming to address (excluding gas)
Total wei outgoing from address (excluding gas)
Total wei earned from gas (for miners only)
Total wei spent on gas
Timestamp for first incoming transaction
Timestamp for last incoming transaction
Timestamp for first outgoing transaction
Timestamp for last outgoing transaction
Wei balance of address (transform to ETH by dividing with POW(10, CAST(18 AS NUMERIC) )
Wei balance in USD of address, using current Coingecko prices
Array of structs with balance per token that the address has ever held (in smallest unit for token). Balance can be zero and can also be negative since the data type is FLOAT64 which is not 100% accurate. Balance can also be negative for tokens that have custom events that are not included in the calculation or for rebase tokens. Balance in USD uses current Coingecko prices. Some tokens are missing price info.
Array of structs with number of NFTs per project_id currently held by address. There are cases where this number is not accurate, f.ex negative balances, due to not being able to capture the incoming transfer event or overflow issues. The median price is based on data from the past 24 hours (at run time of underlying table) or past 7 days. For some special collections, the median price for the past 90 days is used. The liquidity classification (Low, Medium, High) is based on number of sales the past 7 days. Also includes name of collection, flag for whether it is a blue chip collection and category, which can be either Art, Game, Metaverse or Social.
List of NFT platforms used by address either for sales or purchases
List of NFT aggregator platforms used by address either for sales or purchases
An estimate number of peers for the address. Calculated using HyperLogLog++ functions.
Timestamp for when activity was first seen for this account (transactions, traces or token transfers)
Timestamp for when activity was last seen for this account (transactions, traces or token transfers)
Array of bridges ever used by address
List of ENS names owned by this address
True if the address belongs to a smart contract
A flag for whether the address has ever used tornado cash, as a withdrawer, relayer or depositor
True if the address has ever provided liqudity to pools on Uniswap (V2 or V3) or Sushiswap
True if the address is flagged by Nansen as an NFT washtrader
True if the address has ever deployed a contract (EOA deployer, not factory contract)
True if the address is labelled by Nansen as a MEV bot
True if the address has ever performed a DEX trade
List of chains other than Ethereum where this address has activity (transaction, traces or token transfers)