Quickstart Guide

SELECT
  blockchain,
  COUNT(*) as transaction_count
FROM ethereum.transactions
WHERE block_time >= NOW() - INTERVAL '7' day
GROUP BY blockchain

// Automatically applied colors:
{
  "ethereum": "#88AAF1",  // Matches alias "ethereum"
  "base": "#0052FF",       // Matches alias "base"
  "optimism": "#FF0420",   // Matches alias "optimism"
  "arbitrum": "#12AAFF"   // Matches alias "arbitrum"
}

SELECT
  project as protocol,
  SUM(amount_usd) as volume_24h
FROM dex.trades
WHERE block_time >= NOW() - INTERVAL '1' day
GROUP BY project
ORDER BY volume_24h DESC
LIMIT 10

// Automatically applied when project names match aliases:
{
  "uniswap": "#F50DB4",     // Uniswap
  "1inch": "#0077FF",       // 1inch
  "Pancakeswap": "#F3BA2F", // Matches BNB alias "bsc"
  "sushiswap": "#...",      // If defined in palette
  "curve": "#..."           // If defined in palette
}

SELECT
  nft_project_name as marketplace,
  SUM(amount_usd) as volume_usd
FROM nft.trades
WHERE block_time >= NOW() - INTERVAL '30' day
GROUP BY marketplace
ORDER BY volume_usd DESC

{
  "opensea": "#2884E4",
  "blur": "#FF8404",
  "magiceden": "#BF79F5",
  "looksrare": "#10E464",
  "x2y2": "#14DBFC"
}

SELECT
  symbol as stablecoin,
  SUM(amount) as total_supply
FROM tokens.transfers
WHERE contract_address IN (
  -- USDC, USDT, DAI contract addresses
  '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48',
  '0xdac17f958d2ee523a2206206994597c13d831ec7',
  '0x6b175474e89094c44da98b954eedeac495271d0f'
)
GROUP BY symbol

{
  "usdc": "#2775CA",   // USDC
  "usdt": "#26A17B",   // USDT/Tether
  "dai": "#F2B705"     // DAI
}

SELECT
  blockchain,
  DATE_TRUNC('day', block_time) as date,
  COUNT(DISTINCT "from") as active_users
FROM transactions
WHERE block_time >= NOW() - INTERVAL '90' day
GROUP BY blockchain, date

{
  "ethereum": "#88AAF1",
  "base": "#0052FF",
  "optimism": "#FF0420",
  "arbitrum": "#12AAFF",
  "polygon": "#8A46FF",
  "zksync": "#1E69FF",
  "linea": "#61DFFF",
  "scroll": "#EBC28E"
}