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.

core_payment_category

payment_categorization.core_payment_category — payment relationship (Real-World Payment transfers only).
For BCG-style real-world payment mix, sum B2B + B2C + C2B + C2C (folding I2B Payment, I2C Payment, B2I Payment, and Institutional Payment into their respective categories). Only Deposit to Institutional (C2I) is excluded as an investment/trade flow.

payment_purpose

payment_categorization.payment_purpose — granular purpose, driven by amount bands within each category.

classification_tier

payment_categorization.classification_tier — confidence that the amount sits in a calibrated band.

wallet_type & balance_tier

organic_activity_classification.from_wallet_type / to_wallet_type and the corresponding balance tiers.

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.

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