Skip to main content

​
Overview

common.tokens.profile_beta scores every token on Base 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. Scope: Base chain only in v0. Multichain support lands in the following release.

​
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'
  AND p.chain = 'base'

​
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
  AND p.chain = 'base'

​
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)
WHERE p.chain = 'base'

​
How grading works

Three stages:
  1. Signals — per-token metrics from DEX trades, pool liquidity, trader concentration, and the price source registry (7-day rolling window)
  2. 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)
  3. 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, diversification, and price stability.
GradeMeaning
grade_aDeep liquidity, active diversified market, stable pricing
grade_bSufficient liquidity or vendor price, plus active market
grade_cLimited 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

ColumnDescription
chainBlockchain (lowercase). v0 = base
addressToken contract address (lowercase)
symbolToken symbol
token_typestablecoin / lst / other (from curated registries; other = default)

​
Pool liquidity

ColumnDescription
total_pool_liquidity_usdSum of USD across all pools holding this token
num_dex_poolsCount of distinct pools
largest_pool_liquidity_usdUSD in the largest single pool
top_pool_weight_pctLargest pool’s share of total liquidity (0-1)

​
Trading activity (7d rolling)

ColumnDescription
avg_daily_volume_usdMean daily USD volume
avg_hourly_tradersMean unique traders per hour
avg_hourly_tradesMean trade count per hour
active_hours_7dCount of hours with activity (max 168)
activity_consistencyactive_hours_7d / 168
active_trading_days_7dCount of distinct UTC days with activity

​
Price quality

ColumnDescription
price_max_min_ratio_7dMax price / min price over 7d
price_coefficient_of_variationstddev(price) / avg(price)
median_safe_price_coverageFraction of hours with a non-null median safe price
price_sourcedex, provider_a, or static_price_mapping

​
Market structure

ColumnDescription
hhi_indexHerfindahl index of trader volume shares (0-1). Low = diversified
top5_trader_volume_pctVolume share of the top 5 traders (0-100)
unique_traders_7dCount of distinct trader addresses

​
Stablecoin-specific

ColumnDescription
peg_deviation_pctFor stablecoins: |price - 1.0|

​
Boolean flags

ColumnTrue when
has_vendor_priceprice_source = 'provider_a'
has_sufficient_liquidityPool liquidity passes the floor
has_active_marketTrader count, trade count, and volume all pass floors
has_stable_price7d price range is within bounds
has_diversified_tradingTrader concentration below threshold
has_multi_day_historyActive on at least one day in the window
is_realizableComposite: sufficient liquidity + active market + diversified

​
Composite grades

ColumnDescription
allium_classification_betagrade_a / grade_b / grade_c
quality_tier1-5 (numeric, monotonic)
quality_score0-100
confidence_score0-100, type-aware weighted

​
Limitations

  • Base-only in v0. Multichain expansion immediately follows.
  • Thresholds will be tuned during beta. 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.

​
Methodology

Current threshold values used by the boolean flags. These may be tuned during beta based on customer feedback.
FlagCondition
has_sufficient_liquiditytotal_pool_liquidity_usd >= 10,000
has_active_marketavg_hourly_traders >= 2 AND avg_hourly_trades >= 3 AND avg_daily_volume_usd >= 10,000
has_stable_priceprice_max_min_ratio_7d <= 10 OR price ratio is null
has_diversified_tradinghhi_index <= 0.15 (US DOJ antitrust standard for “competitive”)
has_multi_day_historyactive_trading_days_7d >= 1
Grade thresholds (stablecoin branch):
CheckThreshold
peg_deviation_pct for grade_a< 0.005 (0.5%)
num_dex_pools for grade_a>= 2
Grade thresholds (LST and other branches):
CheckThreshold
total_pool_liquidity_usd for grade_a>= 100,000
has_vendor_price alternativevendor presence substitutes for liquidity floor