Fact Sol Daily Balances

​

Description

​

Key Use Cases

• Daily balance analysis: Track SOL holdings over time for accounts, wallets, and protocols
• Portfolio tracking: Monitor SOL balance changes and trends for specific addresses
• Whale watching: Identify large SOL holders and track their balance movements
• Protocol analysis: Analyze SOL reserves and treasury balances for DeFi protocols
• Time series analytics: Perform historical balance analysis and trend identification
• Snapshot reporting: Generate point-in-time balance reports for any historical date

​

Important Relationships

• Sources data from core.fact_sol_balances which contains all SOL balance changes
• Uses crosschain.core.dim_dates for generating complete daily time series
• Complements core.fact_token_daily_balances which handles SPL token balances
• Related to core.ez_transfers for understanding SOL movement patterns

​

Commonly-used Fields

• balance_date: Essential for time-based analysis and filtering to specific dates
• account: Core field for account-specific balance tracking and wallet analysis
• amount: The SOL balance amount (in decimal SOL, not lamports) for value calculations
• last_balance_change: Critical for understanding when balances were last updated (only tracks dates when account had a positive balance)
• balance_changed_on_date: Key for filtering to only dates with actual balance activity

​

Sample Queries

​

Get current SOL balance for a specific account

SELECT
    account,
    amount as sol_balance,
    last_balance_change
FROM solana.core.fact_sol_daily_balances
WHERE account = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
    AND balance_date = CURRENT_DATE() - 1

​

Track SOL balance changes over time for an account

SELECT
    balance_date,
    amount as sol_balance,
    balance_changed_on_date
FROM solana.core.fact_sol_daily_balances
WHERE account = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
    AND balance_date >= CURRENT_DATE() - 30
ORDER BY balance_date DESC

​

Find accounts with largest SOL balances on a specific date

SELECT
    account,
    amount as sol_balance
FROM solana.core.fact_sol_daily_balances
WHERE balance_date = '2024-01-01'
    AND amount > 0
ORDER BY amount DESC
LIMIT 100

​

Analyze SOL balance distribution

SELECT
    CASE
        WHEN amount >= 10000 THEN '10K+ SOL'
        WHEN amount >= 1000 THEN '1K-10K SOL'
        WHEN amount >= 100 THEN '100-1K SOL'
        WHEN amount >= 10 THEN '10-100 SOL'
        ELSE '<10 SOL'
    END as balance_tier,
    COUNT(*) as account_count,
    SUM(amount) as total_sol
FROM solana.core.fact_sol_daily_balances
WHERE balance_date = CURRENT_DATE() - 1
GROUP BY 1
ORDER BY total_sol DESC

​

Columns

• Native SOL: 7GgkQ2... (wallet address)
• SPL Token: 9xQeWv... (token account address) | | AMOUNT | FLOAT | The account’s balance after the transaction, decimal-adjusted. For SOL, this is in units of SOL (not lamports); for tokens, this is in the token’s native units (adjusted for mint decimals).

• SOL: 0.23456789 (represents 0.23456789 SOL after a transfer)
• USDC: 50.00 (represents 50 USDC tokens after a transfer) | | LAST_BALANCE_CHANGE | DATE | The date when this account last had an actual balance change that resulted in a positive balance. This field tracks the most recent date when the balance was modified to a positive amount, which may be earlier than the balance_date due to forward-filling of balances on days with no activity. Note that accounts with zero balances are excluded from daily balance tables.