Search
K

Wallet 360

The polygon.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 on Polygon Blockchain.
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: metamask_wallet, coinbase_wallet, bitkeep_wallet, robinhood_cex, rainbow_wallet, moonpay_ramp, krystal_wallet 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
Blocktime stamp 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.