Token Profile (beta)

Overview

common.tokens.profile_beta scores every token across liquidity depth, trading activity, trader concentration, and token legitimacy. Customers join to common.prices.hourly and filter by whatever threshold fits their use case, or use Allium’s built-in grades. Shipped as beta: the table name and classification column carry a _beta suffix. Thresholds and schema may change before GA. Coverage: ethereum, base, bsc, polygon, arbitrum, optimism, avalanche, robinhood, solana.

Update - 4 September 2026: trader concentration no longer affects the grade.has_diversified_trading (hhi_index <= 0.15) previously gated grade_a and is_realizable. It no longer does. Both columns are still published and hhi_index still feeds quality_score and confidence_score.If you filter on allium_classification_beta = 'grade_a' or is_realizable, your result set grows - roughly 280 more tokens, including WETH, USDC and USDT on their main chains, which the old gate excluded. Nothing loses its grade.To keep the previous behaviour, add AND q.has_diversified_trading to your filter. See Trader concentration for why this changed.

Sample queries

Strict (institutional filter)

SELECT p.*
FROM common.prices.hourly p
JOIN common.tokens.profile_beta q USING (chain, address)
WHERE q.allium_classification_beta = 'grade_a'

Custom thresholds

-- Multi-day trading history + non-trivial liquidity
SELECT p.*, q.allium_classification_beta, q.is_realizable
FROM common.prices.hourly p
JOIN common.tokens.profile_beta q USING (chain, address)
WHERE q.active_trading_days_7d >= 2
  AND q.total_pool_liquidity_usd >= 10000

Scope to a chain (or set of chains)

SELECT p.*, q.allium_classification_beta
FROM common.prices.hourly p
JOIN common.tokens.profile_beta q USING (chain, address)
WHERE q.allium_classification_beta IN ('grade_a', 'grade_b')
  AND p.chain IN ('ethereum', 'base', 'solana')

Research (everything with context)

SELECT p.*, q.allium_classification_beta, q.confidence_score,
       q.total_pool_liquidity_usd, q.num_dex_pools, q.hhi_index
FROM common.prices.hourly p
LEFT JOIN common.tokens.profile_beta q USING (chain, address)

How grading works

Three stages:

Signals — per-token metrics from DEX trades, pool liquidity, trader concentration, and the price source registry (7-day rolling window)
Flags — signals combined into boolean gates (has_sufficient_liquidity, has_active_market, has_diversified_trading, has_stable_price, has_multi_day_history, has_vendor_price)
Grade — type-aware cascading CASE assigns grade_a, grade_b, or grade_c. Stablecoins are graded against their peg. LSTs against liquidity depth and activity. Other tokens against market depth, activity, and price stability.

has_diversified_trading is computed and published but does not affect the grade. See Trader concentration for why, and for how to apply it yourself if you want the stricter filter.

Grade	Meaning
`grade_a`	Deep liquidity, active market, stable pricing
`grade_b`	Sufficient liquidity or vendor price, plus active market
`grade_c`	Limited signals — use with independent validation

A composite quality_tier (1-5) and quality_score (0-100) are also exposed for customers who prefer numeric filters.

Schema

Unique key: (chain, address). One row per token per chain.

Identity

Column	Description
`chain`	Blockchain (lowercase): `ethereum`, `base`, `bsc`, `polygon`, `arbitrum`, `optimism`, `avalanche`, `robinhood`, `solana`
`address`	Token contract address (lowercase)
`symbol`	Token symbol
`token_type`	`stablecoin` / `lst` / `other` (from curated registries; `other` = default)

Pool liquidity

Column	Description
`total_pool_liquidity_usd`	Sum of USD across all pools holding this token
`num_dex_pools`	Count of distinct pools
`largest_pool_liquidity_usd`	USD in the largest single pool
`top_pool_weight_pct`	Largest pool’s share of total liquidity (0-1)

Trading activity (7d rolling)

Column	Description
`avg_daily_volume_usd`	Mean daily USD volume
`avg_hourly_traders`	Mean unique traders per hour
`avg_hourly_trades`	Mean trade count per hour
`active_hours_7d`	Count of hours with activity (max 168)
`activity_consistency`	`active_hours_7d / 168`
`active_trading_days_7d`	Count of distinct UTC days with activity

Price quality

Column	Description
`price_max_min_ratio_7d`	Max price / min price over 7d
`price_coefficient_of_variation`	stddev(price) / avg(price)
`median_safe_price_coverage`	Fraction of hours with a non-null median safe price
`price_source`	`dex`, `provider_a`, or `static_price_mapping`

Market structure

Column	Description
`hhi_index`	Herfindahl index of trader volume shares (0-1). Low = diversified
`top5_trader_volume_pct`	Volume share of the top 5 traders (0-100)
`unique_traders_7d`	Count of distinct trader addresses

Stablecoin-specific

Column	Description
`peg_deviation_pct`	For stablecoins: `\|price - 1.0\|`

Boolean flags

Column	True when
`has_vendor_price`	`price_source = 'provider_a'`
`has_sufficient_liquidity`	Pool liquidity passes the floor
`has_active_market`	Trader count, trade count, and volume all pass floors
`has_stable_price`	7d price range is within bounds
`has_diversified_trading`	Trader concentration below threshold. Informational — does not affect the grade
`has_multi_day_history`	Active on at least one day in the window
`is_realizable`	Composite: sufficient liquidity + active market

Composite grades

Column	Description
`allium_classification_beta`	`grade_a` / `grade_b` / `grade_c`
`quality_tier`	1-5 (numeric, monotonic)
`quality_score`	0-100
`confidence_score`	0-100, type-aware weighted

Trader concentration

hhi_index and has_diversified_trading are published on every row but do not affect allium_classification_beta or is_realizable. HHI measures the shape of the trader distribution and is blind to its size. Deep markets concentrate flow in solvers and market makers, so the metric penalises depth and rewards thin ones. On a representative week, USDT on BSC failed it with 978,518 traders and

18.8B of volume, while a token with 110 traders and

3M of volume passed. Market size is gated by has_sufficient_liquidity and has_active_market instead. If you want the stricter filter, apply it yourself:

SELECT p.*
FROM common.prices.hourly p
JOIN common.tokens.profile_beta q USING (chain, address)
WHERE q.allium_classification_beta = 'grade_a'
  AND q.has_diversified_trading

hhi_index also continues to feed quality_score and confidence_score.

Limitations

Beta thresholds will be tuned. Schema values you filter on (allium_classification_beta, quality_tier, the raw signals) remain stable; the grade boundaries themselves may shift as we collect customer feedback.
Solana grading is sparser. Solana’s long tail of low-activity tokens is reflected in the grade distribution (the vast majority land in grade_c). Filter on is_realizable or allium_classification_beta IN ('grade_a','grade_b') for production use cases.

Methodology

Current threshold values used by the boolean flags. These may be tuned during beta based on customer feedback.

Flag	Condition
`has_sufficient_liquidity`	`total_pool_liquidity_usd >= 10,000`
`has_active_market`	`avg_hourly_traders >= 2` AND `avg_hourly_trades >= 3` AND `avg_daily_volume_usd >= 10,000`
`has_stable_price`	`price_max_min_ratio_7d <= 10` OR price ratio is null
`has_diversified_trading`	`hhi_index <= 0.15`. Informational only
`has_multi_day_history`	`active_trading_days_7d >= 1`

Grade thresholds (stablecoin branch):

Check	Threshold
`peg_deviation_pct` for `grade_a`	`< 0.005` (0.5%)
`num_dex_pools` for `grade_a`	`>= 2`

Grade thresholds (LST and other branches):

Check	Threshold
`total_pool_liquidity_usd` for `grade_a`	`>= 100,000`
`has_vendor_price` alternative	vendor presence substitutes for liquidity floor

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Overview

Sample queries

Strict (institutional filter)

Custom thresholds

Scope to a chain (or set of chains)

Research (everything with context)

How grading works

Schema

Identity

Pool liquidity

Trading activity (7d rolling)

Price quality

Market structure

Stablecoin-specific

Boolean flags

Composite grades

Trader concentration

Limitations

Methodology

​Overview

​Sample queries

​Strict (institutional filter)

​Custom thresholds

​Scope to a chain (or set of chains)

​Research (everything with context)

​How grading works

​Schema

​Identity

​Pool liquidity

​Trading activity (7d rolling)

​Price quality

​Market structure

​Stablecoin-specific

​Boolean flags

​Composite grades

​Trader concentration

​Limitations

​Methodology

Overview

Sample queries

Strict (institutional filter)

Custom thresholds

Scope to a chain (or set of chains)

Research (everything with context)

How grading works

Schema

Identity

Pool liquidity

Trading activity (7d rolling)

Price quality

Market structure

Stablecoin-specific

Boolean flags

Composite grades

Trader concentration

Limitations

Methodology