Welcome to Dune

-- Stablecoin transfers in the last 24h
SELECT
  date_trunc('day', block_time) AS day,
  blockchain,
  symbol,
  SUM(amount) AS total_volume,
  COUNT(*) AS transfer_count
FROM tokens.transfers
WHERE block_time > NOW() - INTERVAL '24' HOUR
  AND symbol IN ('USDT', 'USDC', 'DAI')
GROUP BY 1, 2, 3
ORDER BY total_volume DESC

-- DEX volume by protocol
SELECT
  date_trunc('week', block_time) AS week,
  project,
  version,
  SUM(amount_usd) AS volume,
  COUNT(DISTINCT taker) AS traders
FROM dex.trades
WHERE block_time > NOW() - INTERVAL '90' DAY
GROUP BY 1, 2, 3
ORDER BY 1 DESC, volume DESC

-- Ethereum gas tracker
SELECT
  date_trunc('hour', block_time) AS hour,
  AVG(gas_price / 1e9) AS avg_gwei,
  PERCENTILE_CONT(0.5) WITHIN GROUP
    (ORDER BY gas_price / 1e9) AS median_gwei
FROM ethereum.transactions
WHERE block_time > NOW() - INTERVAL '7' DAY
GROUP BY 1
ORDER BY 1 DESC

-- NFT marketplace volume
SELECT
  date_trunc('day', block_time) AS day,
  platform,
  SUM(amount_usd) AS volume,
  COUNT(*) AS sales,
  COUNT(DISTINCT buyer) AS unique_buyers
FROM nft.trades
WHERE block_time > NOW() - INTERVAL '30' DAY
GROUP BY 1, 2
ORDER BY 1 DESC, volume DESC

Every chain. Every contract. All decoded.

Real-time onchain data ready to query, fork, and build on.

Trusted by 1,000+ leading data teams