Skip to main content
Schema: solana.defi Table: dim_stablecoins Type: Base Table

​
What

This table provides a dimensional view of verified stablecoins across Solana. It consolidates stablecoin metadata from various sources to create a unified reference table for identifying and analyzing stablecoin tokens.

​
Key Use Cases

  • Identifying stablecoin tokens in transaction and event data
  • Filtering DeFi activities to stablecoin-only transactions
  • Analyzing stablecoin adoption and distribution
  • Tracking verified stablecoin contracts across chains
  • Building stablecoin-specific metrics and dashboards

​
Important Relationships

  • Join with defi.ez_stablecoins_supply: Use token_address for supply metrics

​
Commonly-used Fields

  • token_address: Unique stablecoin token contract address
  • symbol: Token symbol (e.g., USDC, USDT, DAI)
  • name: Full token name
  • label: Combined symbol and name, as a stablecoin unique identifier
  • decimals: Number of decimal places for the token
  • is_verified: Verification status

​
Sample queries

-- Get unique stablecoins
SELECT 
    label AS stablecoin,
    COUNT(*) AS token_count
FROM solana..defi.dim_stablecoins
GROUP BY 1
ORDER BY 2 DESC;

-- Get all USDC variants
SELECT 
    token_address,
    symbol,
    name,
    decimals
FROM solana.defi.dim_stablecoins
WHERE symbol LIKE '%USDC%'
ORDER BY symbol;

-- Check if specific address is a stablecoin
SELECT 
    token_address,
    label,
    decimals
FROM solana.defi.dim_stablecoins
WHERE token_address = LOWER('EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v');

​
Columns

Column NameData TypeDescription
TOKEN_ADDRESSTEXTThe unique token address of the stablecoin token. Example: ‘EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v’
SYMBOLTEXTThe symbol identifier for the stablecoin token. Example: ‘USDC’
NAMETEXTThe full name of the stablecoin token. Example: ‘USD Coin’
LABELTEXTA combined display label containing both symbol and name. Example: ‘USDC: USD Coin’
DECIMALSNUMBERThe number of decimal places used by the token address. Example: 6
IS_VERIFIEDBOOLEANIndicates whether the stablecoin is verified by the Flipside team. Example: true
IS_VERIFIED_MODIFIED_TIMESTAMPTIMESTAMP_NTZIndicates when the stablecoin was verified by the Flipside team. Example: true
INSERTED_TIMESTAMPTIMESTAMP_NTZThe timestamp when this transaction record was first inserted into the analytics database. Used for data freshness tracking and incremental model logic. Format: YYYY-MM-DD HH:MI:SS. Not derived from the blockchain, but from the ETL process.
MODIFIED_TIMESTAMPTIMESTAMP_NTZThe timestamp when this transaction record was last updated in the analytics database. Used for tracking updates and supporting incremental model logic. Format: YYYY-MM-DD HH:MI:SS. Not derived from the blockchain, but from the ETL process.
DIM_STABLECOINS_IDTEXTA unique, stable identifier for each record in this table. The primary key (PK) ensures that every row is uniquely identifiable and supports efficient joins, lookups, and data integrity across models. The PK may be a natural key (such as a blockchain transaction hash) or a surrogate key generated from one or more fields, depending on the table’s structure and requirements.