Query editor
-- Wormhole — Comparable Stats (summary table)-- Table: dune.serotonin_data.result_wormhole_dataset-- Optional params:-- start_ts (DateTime) | default: 1970-01-01-- end_ts (DateTime) | default: current_timestampWITH params AS (SELECTCOALESCE(TRY(CAST('{{start_ts}}' AS TIMESTAMP)), TIMESTAMP '1970-01-01') AS start_ts,COALESCE(TRY(CAST('{{end_ts}}' AS TIMESTAMP)), current_timestamp) AS end_ts),base AS (SELECT"from" AS user_address,recipient_chain,token_symbol,CAST(amount_usd AS DOUBLE) AS amount_usd,block_timeFROM dune.serotonin_data.result_wormhole_dataset, params pWHERE block_time >= p.start_tsAND block_time < p.end_tsAND amount_usd > 0),-- Overall KPIssummary AS (SELECTCOUNT(*) AS transfers,COUNT(DISTINCT user_address) AS users,SUM(amount_usd) AS volume_usd,AVG(amount_usd) AS avg_tx_usd,approx_percentile(amount_usd, 0.50) AS p50_tx_usd,approx_percentile(amount_usd, 0.90) AS p90_tx_usd,approx_percentile(amount_usd, 0.99) AS p99_tx_usd,COUNT(DISTINCT recipient_chain) AS chains_used,COUNT(DISTINCT token_symbol) AS tokens_usedFROM base),-- Per-user totals for segmentation & flagsuser_totals AS (SELECTuser_address,SUM(amount_usd) AS user_volume_usd,COUNT(*) AS user_transfers,COUNT(DISTINCT recipient_chain) AS user_chains,COUNT(DISTINCT token_symbol) AS user_tokensFROM baseGROUP BY user_address),-- Named thresholds (Everyday/Core/Power/Whale/Mega)seg_named AS (SELECTCASEWHEN user_volume_usd < 1_000 THEN 'Everyday (<$1k)'WHEN user_volume_usd < 10_000 THEN 'Core ($1k–$10k)'WHEN user_volume_usd < 100_000 THEN 'Power ($10k–$100k)'WHEN user_volume_usd < 1_000_000 THEN 'Whale ($100k–$1M)'