> ## 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 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 [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 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). |