Wallet 360

Get a comprehensive understanding of users, projects, and the competitive landscape to feed the growth engine.

The ethereum.wallet_features.wallet_360 schema is designed to provide insights into user behavior, customer segments, user acquisition journeys, market share, and potential business partnerships for a protocol/dApp. 
Wallet 360 is built on Allium's raw and enriched data verticals. 
Transaction Activity: transaction counts, days online, funding address, and transaction for a  wallet address.
Assets Held: Wallet USD balance, assets held, stablecoin balances, native currency balances.
DEX Interactions: DEX projects interacted by the wallet, USD volume traded.
NFT Marketplace Interactions: NFT marketplace used, total and average USD traded, NFT transactions, and collections traded per marketplace. 
NFT Acquired and Bluechips: First NFT minted, acquired, and traded, bluechip collections held.
This document outlines the use cases of Wallet 360 schema and the variables included in the table. 
Use Cases 
User Activity: How has user behavior changed on-chain week on week?
Customer Segments: What are the user segments based on behavior, origin, net worth, and interests that are gaining traction?
User Acquisition: What did users do before their first interaction with our protocol/dApp?
Market Share: Are we gaining market share compared to competitors?
Business Partnerships: Are there significant overlaps with another project's user base where we can explore potential partnerships?
User Recommendations: Are there asset classes our users love, and can we sell them similar tokens or NFTs?
Table Columns
Wallet Transactions
Core information about the transaction activity of a wallet. 
Column Name
Description
app_list
The app_list is an array of applications that the wallets have interacted with. The apps tag for each wallet is associated to the on-chain interaction in the interaction list. 

The current list of apps includes: 
robinhood_cex
moonpay_ramp
​
rainbow_wallet
krystal_wallet
coinbase_wallet
metamask_wallet
bitkeep_wallet
​
rarible_nft_marketplace
opensea_nft_marketplace
magiceden_nft_marketplace
looksrare_nft_marketplace
larvalabs_nft_marketplace
blurio_nft_marketplace
x2y2_nft_marketplace
The app list for the wallets will be updated to improve coverage over time.
entity_list
An array of entities that the wallet address has interacted with previously, based on the app_list. 
​
 e.g. coinbase, metamask, robinhood, moonpay, krystal
interaction_list
The array of on-chain interactions that flags a particular wallet address to be associated with the usage of a specific application. 
​
e.g. metamask_wallet_swap, moonpay_ramp_funded,ranbow_wallet_swap
wallet_address
Wallet address.
latest_ens_name
Latest ENS name registered by the user.
total_days_active
Total number of days where the wallet was active. Defined as the distinct number of days where the user initiates a transaction.
total_txn_count
Total distinct number of transactions performed by the wallet at the time of analysis.
total_to_address
Total distinct number of addresses that the wallet has interacted with from raw transactions.
first_txn_date
Block timestamp of the wallet's first transaction.
first_txn_hash
Transaction hash of the wallet's first transaction.
first_funding_address
Address that funded the wallet's first gas token.
first_funding_txn_hash
Transaction that funded the wallet's first gas token.
Assets Held 
Balances held by the wallet at the time of analysis. 
Column Name
Description
tokens_held_symbols
Array of ERC20 token symbols held by the wallet at the time of update.
tokens_held_addresses
Array of ERC20 token addresses held by the wallet at the time of update.
total_usd_balance
Total USD balance held by the wallet at the time of update.
stablecoin_usd_balance
Total stablecoin USD balance held by the wallet at the time of update. Currently includes USDC, USDT, BUSD, TUSD and USDP.
native_token_usd_balance
Total ETH USD balance held by the wallet at the time of update.
native_token_balance
Total ETH balance held by the wallet at the time of update.
DEX Interactions
DEXs interacted that the user has interacted with at the time of analysis. 
Column Name
Description
list_dex_trade_project_used
List of DEX projects the wallet has traded on.
total_dex_trade_volume_usd
Total USD volume traded by the wallet.
avg_dex_trade_volume_usd
Average USD volume per trade performed.
first_dex_trade_block_timestamp
Block timestamp of the first DEX trade performed.
first_dex_trade_txn_hash
Transaction hash of the first DEX trade performed.
first_dex_trade_project
First DEX project interacted by the wallet.
NFT Marketplace Interactions  
Aggregated metrics on NFT transactions performed by the wallet address. Currently supports NFT marketplaces indexed by Allium. 
Column Name
Description
total_nft_trade_txn_count
Total number of NFT trades performed.
total_nft_trade_volume_usd
Total USD volume of NFT trades performed.
avg_nft_trade_volume_usd
Average USD volume of NFT per trade.
list_nft_trade_marketplace_used
List of NFT marketplaces that the wallet has bought NFT from.
list_nft_trade_aggregator_used
List of NFT aggregators that the wallet has bought NFT from.
total_nft_trade_marketplace_count
Total number of NFT marketplaces that the wallet has bought NFT from.
total_nft_trade_aggregator_count
Total number of NFT aggregators that the wallet has bought NFT from.
total_nft_trade_collection_count
Total number of NFT collections that the wallet has traded (distinct collection address).
<marketplace>_nft_trade_user

marketplace supported includes: 
opensea, x2y2, looksrare, blur, rarible
Flag on whether the wallet is a user of the NFT marketplace. Where 1 = User and 0 = not user.
<marketplace>_nft_trade_first_txn_block_timestamp
Block timestamp of first NFT trade on the marketplace.
<marketplace>_nft_trade_last_txn_block_timestamp
Block timestamp of last NFT trade on the marketplace.
<marketplace>_nft_trade_total_txn_count
Total NFT trade transactions performed on the marketplace.
<marketplace>_nft_trade_total_volume_usd
Total USD volume traded on the marketplace.
<marketplace>_nft_trade_avg_volume_usd
Average USD volume per trade on the marketplace.
NFT Acquired and Bluechip Held
NFT first acquired by wallet, first NFT bought and minted as well as bluechip NFTs held by the wallet currently. 
Column Name
Description
first_nft_trade_token_address
Token address of first NFT traded.
first_nft_trade_token_id
Token ID of first NFT traded.
first_nft_trade_token_name
Token name of first NFT traded.
first_nft_trade_block_timestamp
Block timestamp of first NFT traded.
first_nft_trade_txn_hash
Transaction hash of first NFT traded.
total_collections_minted
Total number of unique NFT collections minted.
total_nft_mint_txn
Total number of NFT minting transactions.
total_mint_volume_usd
Total USD volume spent on minting NFTs.
avg_mint_price_usd
Average USD spent per mint.
first_nft_mint_token_address
Token address of first NFT minted.
first_nft_mint_token_name
Token ID of first NFT minted.
first_nft_mint_token_id
Token name of first NFT minted.
first_nft_mint_block_timestamp
Block timestamp of first NFT minted.
first_nft_mint_txn_hash
Transaction hash of first NFT minted.
first_nft_token_address
Token address of the first NFT acquired (which can be a mint or NFT bought).
first_nft_token_name
Token ID of first NFT acquired.
first_nft_token_id
Token name of first NFT acquired.
first_nft_block_timestamp
Block timestamp of first NFT acquired.
first_nft_txn_hash
Transaction hash of first NFT acquired.
blue_chip_collections_held
List of Bluechip NFT held by the wallet at the time of analysis. 
​
Bluechips NFT collections include: CryptoPunks, BoredApeYachtClub, MutantApeYachtClub, Fidenza | Art Blocks, Otherdeed, Azuki, CloneX, Moonbirds, Sandbox's LANDs, Chromie Squiggle | Art Blocks,
blue_chip_collections_count
Number of Bluechip NFT collections held by the wallet at the time of analysis.
blue_chip_nfts_count
Number of Bluechip NFTs held by the wallet at the time of analysis.
blue_chip_collection_address_list
List of Bluechip NFT addresses held by the wallet at the time of analysis.
blue_chip_collection_name_list
List of Bluechip NFT names held by the wallet at the time of analysis.
_updated_at
Timestamp when the entry was updated. 
​

Column Name	Description
app_list	The app_list is an array of applications that the wallets have interacted with. The apps tag for each wallet is associated to the on-chain interaction in the interaction list. The current list of apps includes: robinhood_cex moonpay_ramp rainbow_wallet krystal_wallet coinbase_wallet metamask_wallet bitkeep_wallet rarible_nft_marketplace opensea_nft_marketplace magiceden_nft_marketplace looksrare_nft_marketplace larvalabs_nft_marketplace blurio_nft_marketplace x2y2_nft_marketplace The app list for the wallets will be updated to improve coverage over time.
entity_list	An array of entities that the wallet address has interacted with previously, based on the app_list. e.g. `coinbase, metamask, robinhood, moonpay, krystal`
interaction_list	The array of on-chain interactions that flags a particular wallet address to be associated with the usage of a specific application. e.g. `metamask_wallet_swap, moonpay_ramp_funded,ranbow_wallet_swap`
wallet_address	Wallet address.
latest_ens_name	Latest ENS name registered by the user.
total_days_active	Total number of days where the wallet was active. Defined as the distinct number of days where the user initiates a transaction.
total_txn_count	Total distinct number of transactions performed by the wallet at the time of analysis.
total_to_address	Total distinct number of addresses that the wallet has interacted with from raw transactions.
first_txn_date	Block timestamp of the wallet's first transaction.
first_txn_hash	Transaction hash of the wallet's first transaction.
first_funding_address	Address that funded the wallet's first gas token.
first_funding_txn_hash	Transaction that funded the wallet's first gas token.

Column Name	Description
tokens_held_symbols	Array of ERC20 token symbols held by the wallet at the time of update.
tokens_held_addresses	Array of ERC20 token addresses held by the wallet at the time of update.
total_usd_balance	Total USD balance held by the wallet at the time of update.
stablecoin_usd_balance	Total stablecoin USD balance held by the wallet at the time of update. Currently includes USDC, USDT, BUSD, TUSD and USDP.
native_token_usd_balance	Total ETH USD balance held by the wallet at the time of update.
native_token_balance	Total ETH balance held by the wallet at the time of update.

Column Name	Description
list_dex_trade_project_used	List of DEX projects the wallet has traded on.
total_dex_trade_volume_usd	Total USD volume traded by the wallet.
avg_dex_trade_volume_usd	Average USD volume per trade performed.
first_dex_trade_block_timestamp	Block timestamp of the first DEX trade performed.
first_dex_trade_txn_hash	Transaction hash of the first DEX trade performed.
first_dex_trade_project	First DEX project interacted by the wallet.

Column Name	Description
total_nft_trade_txn_count	Total number of NFT trades performed.
total_nft_trade_volume_usd	Total USD volume of NFT trades performed.
avg_nft_trade_volume_usd	Average USD volume of NFT per trade.
list_nft_trade_marketplace_used	List of NFT marketplaces that the wallet has bought NFT from.
list_nft_trade_aggregator_used	List of NFT aggregators that the wallet has bought NFT from.
total_nft_trade_marketplace_count	Total number of NFT marketplaces that the wallet has bought NFT from.
total_nft_trade_aggregator_count	Total number of NFT aggregators that the wallet has bought NFT from.
total_nft_trade_collection_count	Total number of NFT collections that the wallet has traded (distinct collection address).
<marketplace>_nft_trade_user marketplace supported includes: `opensea, x2y2, looksrare, blur, rarible`	Flag on whether the wallet is a user of the NFT marketplace. Where 1 = User and 0 = not user.
<marketplace>_nft_trade_first_txn_block_timestamp	Block timestamp of first NFT trade on the marketplace.
<marketplace>_nft_trade_last_txn_block_timestamp	Block timestamp of last NFT trade on the marketplace.
<marketplace>_nft_trade_total_txn_count	Total NFT trade transactions performed on the marketplace.
<marketplace>_nft_trade_total_volume_usd	Total USD volume traded on the marketplace.
<marketplace>_nft_trade_avg_volume_usd	Average USD volume per trade on the marketplace.

Column Name	Description
first_nft_trade_token_address	Token address of first NFT traded.
first_nft_trade_token_id	Token ID of first NFT traded.
first_nft_trade_token_name	Token name of first NFT traded.
first_nft_trade_block_timestamp	Block timestamp of first NFT traded.
first_nft_trade_txn_hash	Transaction hash of first NFT traded.
total_collections_minted	Total number of unique NFT collections minted.
total_nft_mint_txn	Total number of NFT minting transactions.
total_mint_volume_usd	Total USD volume spent on minting NFTs.
avg_mint_price_usd	Average USD spent per mint.
first_nft_mint_token_address	Token address of first NFT minted.
first_nft_mint_token_name	Token ID of first NFT minted.
first_nft_mint_token_id	Token name of first NFT minted.
first_nft_mint_block_timestamp	Block timestamp of first NFT minted.
first_nft_mint_txn_hash	Transaction hash of first NFT minted.
first_nft_token_address	Token address of the first NFT acquired (which can be a mint or NFT bought).
first_nft_token_name	Token ID of first NFT acquired.
first_nft_token_id	Token name of first NFT acquired.
first_nft_block_timestamp	Block timestamp of first NFT acquired.
first_nft_txn_hash	Transaction hash of first NFT acquired.
blue_chip_collections_held	List of Bluechip NFT held by the wallet at the time of analysis. Bluechips NFT collections include: CryptoPunks, BoredApeYachtClub, MutantApeYachtClub, Fidenza \| Art Blocks, Otherdeed, Azuki, CloneX, Moonbirds, Sandbox's LANDs, Chromie Squiggle \| Art Blocks,
blue_chip_collections_count	Number of Bluechip NFT collections held by the wallet at the time of analysis.
blue_chip_nfts_count	Number of Bluechip NFTs held by the wallet at the time of analysis.
blue_chip_collection_address_list	List of Bluechip NFT addresses held by the wallet at the time of analysis.
blue_chip_collection_name_list	List of Bluechip NFT names held by the wallet at the time of analysis.
_updated_at	Timestamp when the entry was updated.

Balances Calculation

NFTs

Last modified 2mo ago