Identity Demo Tables

Demo extracts of key identity tables. Use these to explore the schema and build queries before upgrading to full access. Row counts are capped well below the full dataset by design, so they’re built for validating structure and query logic, not for judging total coverage or how well a specific category is represented. Two sampling strategies are used, depending on the shape of the source table:

Row samples — 5,000 randomly sampled rows from the full dataset. Used for the address-level tables, where any subset is representative, and for cex_deposits_withdrawals_demo and entity_balances_daily_demo (so their dates are scattered across the full history).
Time windows — a rolling 90-day window ending 30 days ago. Used for the daily geo balance time series (geo_balances_daily_demo and geo_balances_exchanges_added_daily_demo), where a random row sample would leave gaps and make trends unreadable. These extracts are complete over the window they cover.

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 [email protected] 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	Display name of the primary entity (e.g., ‘Binance’), 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 alternative attributions in other_labels (the primary attribution isn’t counted).
has_multiple_attributions	Boolean flag indicating whether this address has conflicting attributions from multiple sources.
attribution_date	Date of the primary attribution.
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 EVM (ten networks, pooled per address), Solana, Tron, and Bitcoin.

Column Name	Description
address	The blockchain address (case-sensitive for Solana and Tron).
chain	Chain family: `evm`, `solana`, `tron`, or `bitcoin`. All EVM networks collapse to `evm`.
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 attribution strength, bounded between 0 and 1 (higher = stronger).
confidence	Categorical confidence level: `Very High Conviction`, `High Conviction`, `Moderate Conviction`, `Low Conviction`, or `Very Low Conviction`.
reasoning	Human-readable explanation of why this address was attributed to the given country.
chains_contributed	Networks whose evidence produced the score, sorted (e.g. `["bsc", "ethereum"]`). Solana, Tron, and Bitcoin rows list their own chain.

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 deposits.
_created_at	Row creation timestamp.
_updated_at	Row last update timestamp.

Entity Balances Daily

allium_identity.demo.entity_balances_daily_demo Daily token balances for entity wallets, summed per entity, chain and token.

Column Name	Description
date	The date of the balance snapshot.
entity	The entity holding the balance (e.g., ‘binance’).
category	The category of the entity (e.g., ‘exchange’).
chain	The blockchain network.
token_address	The token contract address.
token_symbol	The token symbol (e.g., ‘USDT’, ‘ETH’).
balance	Token balance amount.
usd_balance	USD value of the balance.
_created_at	Row creation timestamp.
_updated_at	Row last update timestamp.
_price_updated_at	When the price behind usd_balance last changed. NULL for unpriced tokens.

Geo Balances Daily

allium_identity.demo.geo_balances_daily_demo Daily token balances aggregated by attributed country. This demo covers a rolling 90-day window ending 30 days ago, rather than a row sample, so the time series is continuous over that period.

Column Name	Description
date	Calendar date (UTC) this record represents. Used in daily aggregate tables.
primary_country	Inferred primary country for a wallet or entity, derived from geographic attribution signals (exchange deposit/withdrawal patterns and timezone inference).
primary_region	World region corresponding to primary_country: ‘emea’, ‘apac’, or ‘americas’.
chain	Slug identifying the blockchain this record belongs to (e.g. `ethereum`, `base`, `avalanche`, `solana`). In per-chain tables this is always the same value; in cross-chain tables it identifies which chain the row came from.
token_address	Contract address of the token. For EVM chains, native currency (e.g. ETH, MATIC) is represented as the zero address (0x0000000000000000000000000000000000000000). For Solana, this is the mint address.
token_symbol	Ticker symbol of the token (e.g. “USDC”, “WETH”).
balance	Token balance normalized by the token’s decimal precision (raw_balance / 10^decimals). Human-readable value (e.g. 1.5 USDC rather than 1500000).
usd_balance	USD value of the token balance, computed using the exchange rate at the time of the balance snapshot.
_created_at	Timestamp (UTC) when this row was first written to the Allium platform. Set once on insert and never changed.
_updated_at	Timestamp (UTC) of the most recent update to this row in the Allium platform. Advances when the row is reprocessed or enriched (e.g. USD price hydration).

Geo Balances with Exchanges Added Daily

allium_identity.demo.geo_balances_exchanges_added_daily_demo Daily token balances aggregated by attributed country. This demo covers a rolling 90-day window ending 30 days ago, rather than a row sample, so the time series is continuous over that period.

Column Name	Description
date	Calendar date (UTC) this record represents. Used in daily aggregate tables.
primary_country	Inferred primary country for a wallet or entity, derived from geographic attribution signals (exchange deposit/withdrawal patterns and timezone inference).
chain	Slug identifying the blockchain this record belongs to (e.g. `ethereum`, `base`, `avalanche`, `solana`). In per-chain tables this is always the same value; in cross-chain tables it identifies which chain the row came from.
token_address	Contract address of the token. For EVM chains, native currency (e.g. ETH, MATIC) is represented as the zero address (0x0000000000000000000000000000000000000000). For Solana, this is the mint address.
token_symbol	Ticker symbol of the token (e.g. “USDC”, “WETH”).
balance	Token balance normalized by the token’s decimal precision (raw_balance / 10^decimals). Human-readable value (e.g. 1.5 USDC rather than 1500000).
usd_balance	USD value of the token balance, computed using the exchange rate at the time of the balance snapshot.
_created_at	Timestamp (UTC) when this row was first written to the Allium platform. Set once on insert and never changed.
_updated_at	Timestamp (UTC) of the most recent update to this row in the Allium platform. Advances when the row is reprocessed or enriched (e.g. USD price hydration).

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Skeleton group placeholder 4

Demo Tables

Identity Demo Tables

Address Labels

Addresses Geography

Addresses Timezones

CEX Deposits & Withdrawals

Entity Balances Daily

Geo Balances Daily

Geo Balances with Exchanges Added Daily

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Skeleton group placeholder 4

​Identity Demo Tables

​Address Labels

​Addresses Geography

​Addresses Timezones

​CEX Deposits & Withdrawals

​Entity Balances Daily

​Geo Balances Daily

​Geo Balances with Exchanges Added Daily

Identity Demo Tables

Address Labels

Addresses Geography

Addresses Timezones

CEX Deposits & Withdrawals

Entity Balances Daily

Geo Balances Daily

Geo Balances with Exchanges Added Daily