Identity Demo Tables

Demo samples of key identity tables, each containing 5,000 randomly sampled rows from the full dataset. Use these to explore the schema and build queries before upgrading to full access.

Demo tables are available in the allium_identity.demo schema (e.g., allium_identity.demo.address_labels_demo).

Want full access? These demo tables are limited samples. For complete, production-grade identity data, contact our team at hello@allium.so to discuss access and pricing.

Address Labels

allium_identity.demo.address_labels_demo Blockchain addresses mapped to their primary entity, category, and risk indicators. Covers all chains.

Column Name	Description
chain	The blockchain network (e.g., ‘ethereum’, ‘solana’, ‘bitcoin’, ‘tron’).
address	The blockchain address.
primary_label	The primary attribution label for this address (e.g., ‘binance hot wallet’, ‘coinbase deposit wallet’).
primary_entity	The entity this address is attributed to (e.g., ‘binance’, ‘coinbase’, ‘uniswap’).
primary_category	The category of the entity (e.g., ‘exchange’, ‘defi’, ‘bridge’, ‘mev’).
subcategory	More specific classification within the category.
primary_category_id	Numeric ID for the primary category, for joining to taxonomy tables.
primary_entity_id	Numeric ID for the primary entity, for joining to taxonomy tables.
is_illicit	Boolean flag indicating the address belongs to an illicit category (e.g., exploit, scam).
is_high_risk	Boolean flag indicating the address belongs to a high-risk category.
other_labels	Array of alternative attribution labels when multiple sources disagree.
other_entities	Array of alternative entity attributions.
total_attribution_count	Number of distinct attribution sources for this address.
has_multiple_attributions	Boolean flag indicating whether this address has conflicting attributions from multiple sources.
attribution_date	Date when this address was first attributed.
chain_group	Grouping of chains (e.g., ‘evm’ for EVM-compatible chains).
confidence	Confidence level of the attribution.
source_type	Type of data source for the attribution.
source_system	The system that produced this attribution.
category_ranking	Priority ranking of the category in collision resolution.
entity_ranking	Priority ranking of the entity in collision resolution.
source_priority	Priority score of the attribution source.
composite_ranking_score	Combined ranking score used to resolve competing attributions.
category_tier	Tier classification of the category.
entity_tier	Tier classification of the entity.
_attribution_processed_at	Timestamp when the attribution was processed.
_attribution_updated_at	Timestamp when the attribution was last updated.
_created_at	Row creation timestamp.
_updated_at	Row last update timestamp.

Addresses Geography

allium_identity.demo.addresses_geography_demo Address-level geographic mapping with inferred country and region. Covers Ethereum, Polygon, and Base.

Column Name	Description
address	The blockchain address (EVM only — Ethereum, Polygon, Base).
primary_country	The most likely country associated with this address (e.g., ‘United States’, ‘South Korea’, ‘Turkey’). NULL if only region-level data is available.
primary_region	The geographic region. One of ‘emea’, ‘apac’, or ‘americas’.
score	Composite confidence score between 0 and 10.
confidence	Categorical confidence level: `Very High`, `High`, `Medium`, `Low`, or `Very Low`.
reasoning	Human-readable explanation of why this address was attributed to the given country.

Addresses Timezones

allium_identity.demo.addresses_timezones_demo Address-level timezone inference for individual user addresses. Covers EVM, Solana, and Tron.

Column Name	Description
address	The blockchain address.
chain	The blockchain network (‘evm’, ‘solana’, ‘tron’).
likely_timezone	The predicted timezone region. One of ‘emea’, ‘apac’, or ‘americas’.
separation_score	Score between 0 and 1 measuring how clearly the top timezone separates from the second-best.
absolute_confidence	Score between 0 and 1 measuring how closely the activity pattern matches the predicted timezone.
sample_confidence	Score between 0 and 1 reflecting whether the address has enough transactions for a reliable prediction.
confidence_score	Final confidence score between 0 and 1.
conviction_level	Categorical label: `Very High Conviction`, `High Conviction`, `Moderate Conviction`, `Low Conviction`, or `Very Low Conviction`.
_updated_at	Timestamp of when this row was last computed.

CEX Deposits & Withdrawals

allium_identity.demo.cex_deposits_withdrawals_demo Daily deposit and withdrawal volumes aggregated by entity, chain, and token.

Column Name	Description
date	The date of the aggregated transfers.
entity	The exchange entity (e.g., ‘binance’, ‘coinbase’, ‘kraken’).
chain	The blockchain network.
token_address	The token contract address.
token_symbol	The token symbol (e.g., ‘USDT’, ‘ETH’).
token_name	The full token name.
amount_in	Total token amount deposited to the exchange on this date.
amount_out	Total token amount withdrawn from the exchange on this date.
usd_amount_in	Total USD value of deposits on this date.
usd_amount_out	Total USD value of withdrawals on this date.
net_usd_amount	Net USD flow (usd_amount_in - usd_amount_out). Positive means net inflow.
_created_at	Row creation timestamp.
_updated_at	Row last update timestamp.

Entity Balances Daily

allium_identity.demo.entity_balances_daily_demo Daily stablecoin and native token balances for entity wallets.

Column Name	Description
activity_date	The date of the balance snapshot.
chain	The blockchain network.
wallet_id	Anonymized wallet identifier (immutable, based on first transaction chronological order).
anonymized_label	Human-readable label combining entity name and wallet ID (e.g., ‘Binance 42’).
primary_entity	The entity this wallet belongs to.
primary_category	The category of the entity (e.g., ‘exchange’).
token_type	Either ‘stablecoin’ or ‘native’.
token_address	The token contract address (NULL for native tokens).
token_symbol	The token symbol (e.g., ‘USDT’, ‘ETH’).
stablecoin_id	Standardized stablecoin identifier (e.g., ‘usdt’, ‘usdc’). NULL for native tokens.
balance	Token balance amount.
usd_balance	USD value of the balance.
current_balance_rank	Rank of this wallet within the entity for the same token on the same date, by USD balance desc.
last_activity_block_timestamp	Timestamp of the last on-chain activity for this balance.
_created_at	Row creation timestamp.
_updated_at	Row last update timestamp.

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Demo Tables

Identity Demo Tables

Address Labels

Addresses Geography

Addresses Timezones

CEX Deposits & Withdrawals

Entity Balances Daily

​Identity Demo Tables

​Address Labels

​Addresses Geography

​Addresses Timezones

​CEX Deposits & Withdrawals

​Entity Balances Daily

Identity Demo Tables

Address Labels

Addresses Geography

Addresses Timezones

CEX Deposits & Withdrawals

Entity Balances Daily