Every swap. Every pool. Every chain.

-- Protocol market share by chain, last 30 days
SELECT blockchain, platform, block_date,
  dex_volume_usd, dex_distinct_addresses,
  dex_volume_usd / SUM(dex_volume_usd)
    OVER (PARTITION BY blockchain, block_date)
    AS market_share
FROM crosschain.stats.ez_dex_protocol_metrics_daily
WHERE block_date >= CURRENT_DATE - 30
ORDER BY block_date DESC, dex_volume_usd DESC

-- Large swaps with entity labels, last 24 hours
SELECT s.trader, s.platform,
  s.symbol_in, s.symbol_out, s.amount_in_usd,
  l.label_type, l.project_name
FROM crosschain.defi.ez_dex_swaps s
LEFT JOIN crosschain.core.dim_labels l
  ON s.trader = l.address
  AND s.blockchain = l.blockchain
WHERE s.amount_in_usd >= 100000
  AND s.block_timestamp >= CURRENT_DATE - 1
ORDER BY s.amount_in_usd DESC

-- Pools with largest net outflows this week
SELECT p.platform, p.pool_address,
  SUM(CASE WHEN a.action = 'add'
    THEN a.amount_usd ELSE -a.amount_usd
  END) AS net_flow_usd
FROM crosschain.defi.ez_dex_liquidity_pool_actions a
JOIN crosschain.defi.dim_dex_liquidity_pools p
  ON a.pool_address = p.pool_address
  AND a.blockchain = p.blockchain
WHERE a.block_timestamp >= CURRENT_DATE - 7
GROUP BY 1, 2 ORDER BY net_flow_usd ASC