Identity Demo Tables

Demo extracts of key identity tables. Use these to explore the schema and build queries before upgrading to full access. 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.
Time windows — a rolling 90-day window ending 30 days ago. Used for the daily balance time series, 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	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 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.

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 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.

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 (e.g., Europe, North America, Southeast Asia).
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

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

​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