solana_utils.latest_balances

The solana_utils.latest_balances table provides the most recent balance snapshot for every address on Solana, covering both native SOL and SPL token holdings. Each row represents the latest known balance for a specific address and token combination. This table is derived from solana_utils.daily_balances and is incrementally updated.

When to Use This Table

Look up current token holdings for a wallet
Build portfolio dashboards showing real-time Solana balances
Identify top holders of a specific SPL token
Power wallet scoring and risk profiling systems

Query Performance

This table can be large. Always filter on address or token_mint_address for best performance.

-- ✅ Good: filter on specific address
SELECT *
FROM solana_utils.latest_balances
WHERE address = 'FG4Y3yX4AAchp1HvNZ7LfzFTewF2f6nDoMDCohTFrdpk'

-- ✅ Good: top holders of a specific token
SELECT address, token_balance
FROM solana_utils.latest_balances
WHERE token_mint_address = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' -- USDC
ORDER BY token_balance DESC
LIMIT 100

Table Schema

Column	Type	Description
`address`	`VARCHAR`	Solana wallet address
`block_time`	`TIMESTAMP`	Block time of the latest balance update
`block_slot`	`BIGINT`	Block slot of the latest balance update
`sol_balance`	`DOUBLE`	Native SOL balance
`token_balance`	`DECIMAL(38,18)`	SPL token balance in display units
`token_mint_address`	`VARCHAR`	Mint address of the SPL token
`token_balance_owner`	`VARCHAR`	Owner of the token balance
`updated_at`	`TIMESTAMP`	When this record was last updated

Table Sample

Example Queries

Get all token balances for a specific wallet:

SELECT
  token_mint_address,
  token_balance,
  sol_balance,
  updated_at
FROM solana_utils.latest_balances
WHERE address = 'FG4Y3yX4AAchp1HvNZ7LfzFTewF2f6nDoMDCohTFrdpk'
ORDER BY token_balance DESC

Top SOL holders:

SELECT
  address,
  sol_balance
FROM solana_utils.latest_balances
WHERE sol_balance > 0
ORDER BY sol_balance DESC
LIMIT 50

Curated Data

Solana

Hyperliquid

Non-EVM Networks

Protocols

EVM Networks

Partner Data

Dune Index

solana_utils.latest_balances

When to Use This Table

Query Performance

Table Schema

Table Sample

Example Queries

​When to Use This Table

​Query Performance

​Table Schema

​Table Sample

​Example Queries

When to Use This Table

Query Performance

Table Schema

Table Sample

Example Queries