Query editor
-- OP-Stack DEX Landscape · Ink USD share daily (WIDE-PIVOTED)-- Caveat: excludes Nado Spot, Otomate, SakuraSwap (46.2% of chain DEX volume per DefiLlama)WITH ink_trades AS (SELECT DATE_TRUNC('day', block_time) AS day, project, version, amount_usd, tx_hashFROM dex.tradesWHERE blockchain = 'ink'AND block_time >= TIMESTAMP '2024-12-20 00:00:00'AND block_month >= DATE '2024-12-01'AND project NOT IN ('synthetix', 'bridgers')AND amount_usd IS NOT NULL AND amount_usd > 0),labeled AS (SELECT day, amount_usd, tx_hash,CASEWHEN project = 'velodrome' THEN 'Velodrome'WHEN project = 'uniswap' THEN 'Uniswap'WHEN (project, version) = ('inkyswap', '1') THEN 'Inkyswap'WHEN (project, version) = ('reservoir_swap', '1') THEN 'Reservoir'WHEN (project, version) = ('inkswap', '1') THEN 'Inkswap'ELSE INITCAP(project)END AS display_nameFROM ink_trades),daily_legend AS (SELECT day,CASE display_nameWHEN 'Velodrome' THEN 'Velodrome'WHEN 'Inkyswap' THEN 'Inkyswap'WHEN 'Uniswap' THEN 'Uniswap'WHEN 'Reservoir' THEN 'Reservoir'ELSE 'Other'END AS legend_name,amount_usdFROM labeled),daily_usd AS (SELECT day, legend_name, SUM(amount_usd) AS usd_volume FROM daily_legend GROUP BY day, legend_name),daily_total AS (SELECT day AS total_day, SUM(usd_volume) AS day_total FROM daily_usd GROUP BY day),shares AS (SELECT d.day AS day, d.legend_name AS display_name,100.0 * d.usd_volume / NULLIF(t.day_total, 0) AS share_pctFROM daily_usd d JOIN daily_total t ON d.day = t.total_day)SELECT day,COALESCE(MAX(CASE WHEN display_name = 'Velodrome' THEN share_pct END), 0) AS velodrome,COALESCE(MAX(CASE WHEN display_name = 'Inkyswap' THEN share_pct END), 0) AS inkyswap,COALESCE(MAX(CASE WHEN display_name = 'Uniswap' THEN share_pct END), 0) AS uniswap,COALESCE(MAX(CASE WHEN display_name = 'Reservoir' THEN share_pct END), 0) AS reservoir,COALESCE(MAX(CASE WHEN display_name = 'Other' THEN share_pct END), 0) AS otherFROM shares GROUP BY day ORDER BY day