Address Stats
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
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: nansen-query.aggregates_ethereum.address_stats
This table is updated daily.
address
STRING
The address of the account
incoming_nof_transactions
INTEGER
Number of transactions where address is to_address
incoming_nof_wei_transactions
INTEGER
Number of transactions with ETH value where address is to_address
outgoing_nof_transactions
INTEGER
Number of transactions where address is from_address
outgoing_nof_wei_transactions
INTEGER
Number of transactions with ETH value where address is from_address
incoming_total_wei
NUMERIC
Total wei incoming to address (excluding gas)
outgoing_total_wei
NUMERIC
Total wei outgoing from address (excluding gas)
incoming_total_gas_wei
NUMERIC
Total wei earned from gas (for miners only)
outgoing_total_gas_wei
NUMERIC
Total wei spent on gas
incoming_first_transaction_at
DATE
Timestamp for first incoming transaction
incoming_last_transaction_at
DATE
Timestamp for last incoming transaction
outgoing_first_transaction_at
DATE
Timestamp for first outgoing transaction
outgoing_last_transaction_at
DATE
Timestamp for last outgoing transaction
wei_balance
NUMERIC
Wei balance of address (transform to ETH by dividing with POW(10, CAST(18 AS NUMERIC) )
wei_balance_usd
FLOAT
Wei balance in USD of address, using current Coingecko prices
token_balance
RECORD
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.
nft_balance_per_project
RECORD
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.
nft_platforms_used
STRING
List of NFT platforms used by address either for sales or purchases
nft_aggregator_platforms_used
STRING
List of NFT aggregator platforms used by address either for sales or purchases
nof_peers
INTEGER
An estimate number of peers for the address. Calculated using HyperLogLog++ functions.
first_activity_at
DATE
Timestamp for when activity was first seen for this account (transactions, traces or token transfers)
last_activity_at
DATE
Timestamp for when activity was last seen for this account (transactions, traces or token transfers)
bridges_used
STRING
Array of bridges ever used by address
ens_names
STRING
List of ENS names owned by this address
is_contract
BOOLEAN
True if the address belongs to a smart contract
is_tornado_cash_user
BOOLEAN
A flag for whether the address has ever used tornado cash, as a withdrawer, relayer or depositor
is_liquidity_provider
BOOLEAN
True if the address has ever provided liqudity to pools on Uniswap (V2 or V3) or Sushiswap
is_nft_washtrader
BOOLEAN
True if the address is flagged by Nansen as an NFT washtrader
is_contract_deployer
BOOLEAN
True if the address has ever deployed a contract (EOA deployer, not factory contract)
is_mev_bot
BOOLEAN
True if the address is labelled by Nansen as a MEV bot
is_dex_trader
BOOLEAN
True if the address has ever performed a DEX trade
found_on_chains
STRING
List of chains other than Ethereum where this address has activity (transaction, traces or token transfers)
Last updated