​
Table Columns

​
Wallet Transactions

Core information about the transaction activity of a wallet.

Column NameDescription
app_listAn array of applications that the wallets have interacted with. Each app tag is linked to an on-chain interaction in the interaction list.

Current apps include:
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 will be updated over time.
entity_listAn array of entities that the wallet has interacted with, derived from the app_list.
e.g. coinbase, metamask, robinhood, moonpay, krystal
interaction_listThe array of on-chain interactions that associate a wallet address with the use of a specific application.
e.g. metamask_wallet_swap, moonpay_ramp_funded, rainbow_wallet_swap
wallet_addressWallet address.
latest_ens_nameLatest ENS name registered by the user.
total_days_activeTotal number of distinct days where the wallet was active (i.e., initiated a transaction).
total_txn_countTotal number of distinct transactions made by the wallet at the time of analysis.
total_to_addressTotal number of distinct addresses the wallet has interacted with through transactions.
first_txn_dateBlock timestamp of the wallet’s first transaction.
first_txn_hashTransaction hash of the wallet’s first transaction.
first_funding_addressThe address that funded the wallet’s first gas token.
first_funding_txn_hashTransaction hash that funded the wallet’s first gas token.

​
Assets Held

Balances held by the wallet at the time of analysis.

Column NameDescription
tokens_held_symbolsArray of ERC20 token symbols held by the wallet at the time of update.
tokens_held_addressesArray of ERC20 token addresses held by the wallet at the time of update.
total_usd_balanceTotal USD balance held by the wallet at the time of update.
stablecoin_usd_balanceTotal stablecoin USD balance held by the wallet at the time of update.
Currently includes USDC, USDT, BUSD, TUSD, and USDP.
native_token_usd_balanceTotal ETH USD balance held by the wallet at the time of update.
native_token_balanceTotal 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 NameDescription
list_dex_trade_project_usedList of DEX projects the wallet has traded on.
total_dex_trade_volume_usdTotal USD volume traded by the wallet.
avg_dex_trade_volume_usdAverage USD volume per trade performed.
first_dex_trade_block_timestampBlock timestamp of the first DEX trade performed.
first_dex_trade_txn_hashTransaction hash of the first DEX trade performed.
first_dex_trade_projectFirst 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 NameDescription
total_nft_trade_txn_countTotal number of NFT trades performed.
total_nft_trade_volume_usdTotal USD volume of NFT trades performed.
avg_nft_trade_volume_usdAverage USD volume of NFT per trade.
list_nft_trade_marketplace_usedList of NFT marketplaces that the wallet has bought NFT from.
list_nft_trade_aggregator_usedList of NFT aggregators that the wallet has bought NFT from.
total_nft_trade_marketplace_countTotal number of NFT marketplaces that the wallet has bought NFT from.
total_nft_trade_aggregator_countTotal number of NFT aggregators that the wallet has bought NFT from.
total_nft_trade_collection_countTotal number of NFT collections that the wallet has traded (distinct collection address).
<marketplace>_nft_trade_userFlag on whether the wallet is a user of the NFT marketplace. 1 = User, 0 = Not a user.
<marketplace>_nft_trade_first_txn_block_timestampBlock timestamp of first NFT trade on the marketplace.
<marketplace>_nft_trade_last_txn_block_timestampBlock timestamp of last NFT trade on the marketplace.
<marketplace>_nft_trade_total_txn_countTotal NFT trade transactions performed on the marketplace.
<marketplace>_nft_trade_total_volume_usdTotal USD volume traded on the marketplace.
<marketplace>_nft_trade_avg_volume_usdAverage 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 NameDescription
first_nft_trade_token_addressToken address of first NFT traded.
first_nft_trade_token_idToken ID of first NFT traded.
first_nft_trade_token_nameToken name of first NFT traded.
first_nft_trade_block_timestampBlock timestamp of first NFT traded.
first_nft_trade_txn_hashTransaction hash of first NFT traded.
total_collections_mintedTotal number of unique NFT collections minted.
total_nft_mint_txnTotal number of NFT minting transactions.
total_mint_volume_usdTotal USD volume spent on minting NFTs.
avg_mint_price_usdAverage USD spent per mint.
first_nft_mint_token_addressToken address of first NFT minted.
first_nft_mint_token_nameToken name of first NFT minted.
first_nft_mint_token_idToken ID of first NFT minted.
first_nft_mint_block_timestampBlock timestamp of first NFT minted.
first_nft_mint_txn_hashTransaction hash of first NFT minted.
first_nft_token_addressToken address of the first NFT acquired (mint or purchase).
first_nft_token_nameToken name of the first NFT acquired.
first_nft_token_idToken ID of the first NFT acquired.
first_nft_block_timestampBlock timestamp of first NFT acquired.
first_nft_txn_hashTransaction hash of first NFT acquired.
blue_chip_collections_heldList of Bluechip NFTs held by the wallet at the time of analysis.
blue_chip_collections_countNumber of Bluechip NFT collections held.
blue_chip_nfts_countNumber of Bluechip NFTs held by the wallet.
blue_chip_collection_address_listList of Bluechip NFT contract addresses held.
blue_chip_collection_name_listList of Bluechip NFT collection names held.
_updated_atTimestamp when the entry was updated.