Table Columns
Table Columns
Wallet Transactions
Core information about the transaction activity of a wallet.
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:
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, rainbow_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.
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.
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.
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.
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.
Last updated