Dune Queries
WalletWall uses Dune Analytics scheduled queries as a source-backed data layer for holder analytics, whale activity, and Quantum Intelligence signals. All Dune data is scheduled and cached — it is never live streaming.
Public docs use source aliases instead of deployment environment variable names. Runtime secret and query-ID configuration belongs in the private deployment environment, not Mintlify docs.
Holder Wall queries
48h Active Wallets
Public source alias: Active wallet feed
Powers the Active Wallets tab in the Holder Wall treemap. Returns wallets that have been active within the last 48 hours, with balance and activity tier information.
Used by: api/holder-wall.js
Whale Trades
Public source alias: Whale trade feed
Powers the Whale Wallets tab in the Holder Wall treemap. Returns large-balance wallets with trade activity data.
Used by: api/holder-wall.js
Whale Watcher queries
12-Week Active Wallets
Public source alias: 12-week activity feed
Provides per-day activity data for the 12-week heatmap in the Whale Watcher workspace.
Required row fields:
| Field | Description |
|---|
address | Wallet address |
label | Entity label or category |
category | Activity category |
tx_count_48h | Transaction count in the last 48h |
unique_receivers_48h | Unique receiver count in the last 48h |
usd_volume_48h | USD volume in the last 48h |
last_seen | Last observed activity timestamp |
activity_tier | Overall activity tier |
activity_day | Date of the activity row |
week_number | Week number in the 12-week window |
day_of_week | Day of week (0–6) |
tx_count_day | Transaction count for this day |
unique_receivers_day | Unique receivers for this day |
usd_volume_day | USD volume for this day |
intensity_score | Computed intensity for heatmap coloring |
day_activity_tier | Activity tier for this specific day |
Wallet Portfolio
Public source alias: Wallet portfolio feed
Provides per-wallet token holdings or trading exposure for the WalletHoldingsStrip component.
Two query shapes are supported. The API detects the shape from the columns present:
wallet_address, token_symbol, token_address, balance, balance_usd
wallet_address, token_symbol, token_address, total_traded_usd, trade_count, last_trade_at
inDataset: false).
Quantum Intelligence queries
These queries provide source-backed facts for the Quantum Exposure Score and its components. All four queries run on scheduled cadences and their results are cached.
walletwall_dormant_quantum_exposure_v1
Public source alias: Dormancy exposure feed
Suggested cadence: Weekly
Emits one row per wallet that is both dormant (no observed outgoing activity beyond a configurable threshold) and has implied ECDSA/secp256k1 signature exposure. Provides the primary data for dormant-holder quantum-exposure signals in the Holder Wall treemap and the QuantumExposureCard.
Key output fields:
| Field | Description |
|---|
wallet_address | EVM wallet address (checksummed) |
signature_exposure_status | signature_exposure_observed, no_outgoing_signature_observed, contract_wallet, or unknown |
dormancy_bucket | warm_dormant_30_180d, cold_dormant_180_730d, or ancient_dormant_730d_plus |
days_dormant | Days since last observed outgoing transaction |
balance_usd | USD-denominated balance at query execution time |
entity_label | Community/source-backed category label |
is_contract | True if the address is a contract wallet |
migration_readiness_hint | e.g., safe_wallet_detected, account_abstraction_detected |
walletwall_wallet_signature_exposure_v1
Public source alias: Signature exposure feed
Suggested cadence: Daily or on-demand per wallet
Emits per-wallet source facts for quantum-signature exposure heuristics. Used for single-wallet lookups in Whale Watcher and Coinstellation detail panels.
Key output fields:
| Field | Description |
|---|
is_contract | True if address has deployed contract code |
first_outgoing_tx_at | Timestamp of first outgoing transaction; null if none observed |
signed_tx_count | Count of outgoing transactions |
days_dormant | Days since last activity; null if no activity observed |
signature_scheme | ecdsa_secp256k1 for EVM EOAs; unknown for contracts |
exposure_status | Same four-value enum as above |
walletwall_quantum_value_at_risk_v1
Public source alias: Value-at-risk feed
Suggested cadence: Daily
Provides source-backed balance and supply-share facts for the valueAtRiskScore component of the Quantum Exposure Score.
Key output fields:
| Field | Description |
|---|
native_balance_usd | Native asset (ETH) balance in USD |
token_balance_usd | ERC-20 token balance in USD |
total_balance_usd | Sum of native + token balances |
top_token_symbol | Symbol of the largest single token position |
holder_rank | Holder rank for this token at query time |
supply_share | Fraction of token supply held (0.0–1.0) |
walletwall_wallet_migration_readiness_v1
Public source alias: Migration readiness feed
Suggested cadence: Weekly
Emits migration-readiness signals and wallet structure facts. Feeds the migrationReadinessScore component and the migrationReadinessHints section of QuantumExposureCard.
Key output fields:
| Field | Description |
|---|
is_contract_wallet | True if the address is any contract-based wallet |
contract_wallet_type | safe, gnosis_multisig, erc4337_aa, other_contract, or null |
is_safe_wallet | True if wallet is a Gnosis Safe instance |
is_account_abstraction_wallet | True if ERC-4337 AA is detected |
recent_migration_signal | True if a token migration or key-rotation event was observed |
risky_approval_count | Count of active ERC-20 approvals with unlimited or large allowances |
Stable Seer queries (drafts)
The docs/dune/queries/stable-seer/ directory contains draft SQL for:
stable_peg_metrics.sql — peg stability and deviation across major stablecoinsstable_liquidity_flows.sql — stablecoin inflows and outflows across major DeFi protocols
These are drafts for Ethereum and EVM-compatible chains. Solana holder analytics are excluded.
Freshness and staleness summary
| Query | Cadence | Staleness threshold | Stale behaviour |
|---|
walletwall_dormant_quantum_exposure_v1 | Weekly | 30 hours | Show stale badge; do not hide signal |
walletwall_wallet_signature_exposure_v1 | Daily / on-demand | 30 hours | Show stale badge; keep last known value |
walletwall_quantum_value_at_risk_v1 | Daily | 30 hours | Show stale badge; USD values are estimates |
walletwall_wallet_migration_readiness_v1 | Weekly | 7 days | Show stale badge; facts change slowly |
queryRunAt and the freshnessStatus / staleMessage mechanism in api/_dune.js.
Integration pattern
Queries are consumed through the readOrCache() pattern in api/_dune.js. Each query requires:
- A Dune saved query with a numeric query ID
- A private deployment configuration entry that maps the relevant public source alias to that saved query ID
- The configuration entry set in the deployment provider and local development environment
Missing query-ID configuration causes a "query ID not configured" warning to be appended to the API response’s metadata.warnings array, which is then promoted to a caveat on the Quantum Exposure Score via appendDuneSourceCaveats().
Guardrails
- Dune data is scheduled/cached, never live. All outputs must be labeled as scheduled/cached in the UI.
- No exploitability claims. Dormancy and signature exposure are migration-readiness heuristics, not statements that any wallet is currently quantum-exploitable.
- No deanonymization. Entity labels are community/source-backed category labels only.
- No investment advice. These signals are informational risk indicators.
- Missing data returns
Unknown / insufficient data, not fake precision.
