This table is currently in beta and doesn’t cover all of the wallet addresses. Contact us if you want addresses that haven’t already been indexed.

At Allium, we have curated 100+ attributes for every wallet out there 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.

Blockchains Covered

BlockchainsLink
EthereumWallet 360
PolygonWallet 360
BaseWallet 360
Bitcoincoming soon

Sample Queries

Using Ethereum Wallet360, explore what your users are doing on-chain.

For addresses that were tagged as Rainbow Wallet, where were they first funded from?

select

    nvl(entities.project, 'Unknown') as funder,

    nvl(entities.category, 'Unknown') as funder_category,

    count(1) as wallet_count

from ethereum.wallet_features.wallet_360

left join common.identity.entities on first_funding_address = address and chain = 'ethereum'

where array_contains('rainbow_wallet'::variant, app_list)

group by all

order by 1 asc

Expanding to explore other wallet funding source:


Wallet 360 Sample Output

Wallet Address0xdd11dc9b6666b03bae04446f4d31d349115adc640xff5bb2d8623d34521cd2fa64131cc841f89674970x9515cb3caf793077b085c66c8609f50570769420
app_list[‘opensea_nft_marketplace’][‘opensea_nft_marketplace’][‘opensea_nft_marketplace’]
entity_list[‘opensea’][‘opensea’][‘opensea’]
interaction_list[‘opensea_nft_marketplace_trader’][‘opensea_nft_marketplace_trader’][‘opensea_nft_marketplace_trader’]
latest_ens_namedevdaoist.ethvibesandlogic.eth.eth
total_days_active7516
total_txn_count1118811
total_to_address6259
first_txn_date2021-11-06T19:49:232021-11-09T17:06:282021-12-02T00:47:15
first_txn_hash0x461eb306139645313be7800359b74e293ffefff84b8fbbae144af4750452d12e0xf961325d765f8fb5455950b160c4896c790bb48422bcb4348736bd3430e630f30xeb523d415557de8ea39a9fa43e5d8fbe02a2b8057bb8e7d841df7b396e70a40f
first_funding_date2021-11-06T19:45:482021-11-09T16:05:212021-12-01T00:18:49
first_funding_address0x378ff65cb9e9b83b86aa2534c9991e5b28f1ec920x6aed00e976f2e1f760025b52000d350c9080dbab0x025d6f999b9e396ad88486f5e3db266e1ecd3328
first_funding_txn_hash0xd4dac0342f128ea8f78540583ce0473bbb95e43ae79da1823ebeb03b3ee6c9d00xbfa5be643fb5e44a44a4b1e2a53999f575593d00b79f6ecebdd6a0ad8575006e0x114dfb02082fd906df4a56adca0a54c72cd1719996996ecbb0fd18948a4352b7
tokens_held_symbols[“ETH”, “MATIC”][“ETH”, “SolFi.Vision”][“ETH”]
tokens_held_addresses[“0x0000000000000000000000000000000000000000”, “0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0”][“0x0000000000000000000000000000000000000000”, “0xd88e87cd53d5b3c88c07bdb4715a39b75d6e7870”][“0x0000000000000000000000000000000000000000”]
total_usd_balance1190.3009458171205818.58492099277054.38545303545910
stablecoin_usd_balance0.00.00.0
native_token_usd_balance1113.96094581712005818.58492099277054.38545303545910
native_token_balance0.59221426032669903.5364457497585700.028912899471804500
total_dex_trade_volume_usd
avg_dex_trade_volume_usd
first_dex_trade_txn_hash
first_dex_trade_project
total_nft_trade_txn_count1.012.02.0
total_nft_trade_volume_usd1219.0718648.718235333330818.1918000000000
avg_nft_trade_volume_usd1219.071205.92186274603200409.09590000000000
list_nft_trade_marketplace_used[“opensea”][“opensea”][“opensea”]
list_nft_trade_aggregator_used[][“genie.xyz”][]
total_nft_trade_marketplace_count1.01.01.0
total_nft_trade_aggregator_count0.01.00.0
total_nft_trade_collection_count1.04.01.0
opensea_nft_trade_user1.01.01.0
opensea_nft_trade_first_txn_block_timestamp2021-12-27T00:08:382022-03-10T03:27:102021-12-15T05:13:19
opensea_nft_trade_last_txn_block_timestamp2021-12-27T00:08:382023-08-28T03:53:592021-12-18T15:29:12
opensea_nft_trade_total_txn_count1.012.02.0
opensea_nft_trade_total_volume_usd1219.0718648.718235333330818.1918000000000
opensea_nft_trade_avg_volume_usd1219.071205.92186274603200409.09590000000000
looksrare_nft_trade_user0.00.00.0
looksrare_nft_trade_first_txn_block_timestamp
looksrare_nft_trade_last_txn_block_timestamp
looksrare_nft_trade_total_txn_count0.00.00.0
looksrare_nft_trade_total_volume_usd0.00.00.0
looksrare_nft_trade_avg_volume_usd0.00.00.0
x2y2_nft_trade_user0.00.00.0
x2y2_nft_trade_first_txn_block_timestamp
x2y2_nft_trade_last_txn_block_timestamp
x2y2_nft_trade_total_txn_count0.00.00.0
x2y2_nft_trade_total_volume_usd0.00.00.0
x2y2_nft_trade_avg_volume_usd0.00.00.0
blur_nft_trade_user0.00.00.0
blur_nft_trade_first_txn_block_timestamp
blur_nft_trade_last_txn_block_timestamp
blur_nft_trade_total_txn_count0.00.00.0
blur_nft_trade_total_volume_usd0.00.00.0
blur_nft_trade_avg_volume_usd0.00.00.0
rarible_nft_trade_user0.00.00.0
rarible_nft_trade_first_txn_block_timestamp
rarible_nft_trade_last_txn_block_timestamp
rarible_nft_trade_total_txn_count0.00.00.0
rarible_nft_trade_total_volume_usd0.00.00.0
rarible_nft_trade_avg_volume_usd0.00.00.0