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