Skip to main content
A consolidated reference for the categorical fields in the stablecoins.intelligence tables. For full column lists see the Table Reference.

​
transaction_type

organic_activity_classification.transaction_type — the high-level economic intent of an organic transfer.
ValueMeaning
Real-World PaymentConsumer/business payment-sized flow below the large-ticket trade threshold
Investment/TradeLarge B2B/institutional transfers, outlier ticket sizes, short-term round-trip patterns, exchange-style flows
Store as ValueReceiver accumulates an inflow large relative to balance and typical ticket, with low subsequent outflow
UnclassifiedNo rule matched with sufficient confidence

​
core_payment_category

payment_categorization.core_payment_category — payment relationship (Real-World Payment transfers only).
ValueMeaningCounts as real-world payment?
C2C PaymentConsumer → Consumer✅
C2B PaymentConsumer → Business✅
B2C PaymentBusiness → Consumer✅
B2B PaymentBusiness → Business✅
I2B PaymentInstitutional → Business✅ (rolled into B2B)
I2C PaymentInstitutional → Consumer⚠️ treated as Investment/Trade
Institutional PaymentInstitutional → Institutional (I2I)✅ (rolled into B2B)
Deposit to InstitutionalC2I / B2I inflow to an institutional wallet❌ excluded (Investment/Trade)
For BCG-style real-world payment mix, sum B2B + B2C + C2B + C2C (folding I2B Payment and Institutional Payment into B2B). Deposit to Institutional and I2C Payment are excluded as investment/trade flows.

​
payment_purpose

payment_categorization.payment_purpose — granular purpose, driven by amount bands within each category.
FlowPurposes (small → large)
C2CP2P Micro Payment · P2P Remittance · P2P Large Transfer
C2BRetail Purchase · Service Payment · Large Purchase
B2CMicro Payout · Gig/Creator Payout · Salary/Payroll · Large Disbursement
B2BService Fee · Supplier Payment · Large B2B Settlement
InstitutionalInstitutional Settlement and related

​
classification_tier

payment_categorization.classification_tier — confidence that the amount sits in a calibrated band.
ValueMeaning
CoreAmount within primary calibrated thresholds (highest confidence)
ExtendedLarger secondary bands
FallbackOutside Core/Extended but still a real-world payment upstream

​
wallet_type & balance_tier

organic_activity_classification.from_wallet_type / to_wallet_type and the corresponding balance tiers.
wallet_typeProfile
ConsumerRetail-sized balances and tickets
BusinessCommercial throughput backed by a real working balance
InstitutionalTreasury / protocol / market-maker scale
balance_tierMax stablecoin balance (USD)
whale≥ $1M
large100K–100K – 1M
medium10K–10K – 100K
small1K–1K – 10K
micro25–25 – 1K
dust< $25

​
wallet_type_combination

Sender × receiver pairing: C2C, C2B, B2C, B2B, I2C, I2B, I2I, C2I, B2I (C = Consumer, B = Business, I = Institutional).

​
classification (activity taxonomy)

enriched_transfers.classification — the top-level activity bucket for every transfer (not just organic). Most non-payment buckets are excluded from is_adjusted_volume.
ValueMeaning
dustBelow de-minimis USD threshold
mint_burnSupply increase/decrease (genesis/mint/burn)
infra_automationBridges, bots, MEV, inorganic, infrastructure
cex_flowAt least one centralized-exchange address
defiDEX/lending/DeFi-labeled counterparty
short_term_pairRapid round-trip routing leg
gamblingGambling-sector counterparty
paymentsReal-world payment flow
store_of_valueAccumulation vs typical spend
investment_tradeTrading / large B2B / short-term pair behavior
organic_activityPasses adjusted-volume filters, no finer bucket matched
unclassifiedNo rule matched or failed adjusted-volume gate

​
Directional flow categories

enriched_transfers.{cex,defi,payment_services,infrastructure}_flow_category — directional tags relative to each labeled sector, e.g. CEX TO CEX, OTHERS DEPOSITS TO CEX, OTHERS WITHDRAWALS FROM CEX, DEFI TO DEFI, PAYMENT SERVICES TO PAYMENT SERVICES, UNCATEGORIZED.

​
stablecoin_type

enriched_transfers.stablecoin_type — registry taxonomy: native, bridged, yield_bearing, lending_receipt, vault_share, unclassified.

​
Next Steps

Table Reference

Full column-level schema

Example Queries

Recipes using these fields