> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.
# Demo Tables
# 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](mailto: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. |