Query editor
-- xStocks vs Ondo Volume Comparison-- xStocks volume = CoinGecko trading volume + on-chain minting + on-chain burning-- CoinGecko market_chart calls are precomputed in bucketed Dune materialized views.WITH cg_bucketed AS (SELECT protocol, day, daily_volume_usdFROM dune.buccaneers.result_tokenized_stocks_ecosystem_cg_daily_b00_v01UNION ALLSELECT protocol, day, daily_volume_usdFROM dune.buccaneers.result_tokenized_stocks_ecosystem_cg_daily_b01_v01UNION ALLSELECT protocol, day, daily_volume_usdFROM dune.buccaneers.result_tokenized_stocks_ecosystem_cg_daily_b02_v01UNION ALLSELECT protocol, day, daily_volume_usdFROM dune.buccaneers.result_tokenized_stocks_ecosystem_cg_daily_b03_v01UNION ALLSELECT protocol, day, daily_volume_usdFROM dune.buccaneers.result_tokenized_stocks_ecosystem_cg_daily_b04_v01UNION ALLSELECT protocol, day, daily_volume_usdFROM dune.buccaneers.result_tokenized_stocks_ecosystem_cg_daily_b05_v01UNION ALLSELECT protocol, day, daily_volume_usdFROM dune.buccaneers.result_tokenized_stocks_ecosystem_cg_daily_b06_v01UNION ALLSELECT protocol, day, daily_volume_usdFROM dune.buccaneers.result_tokenized_stocks_ecosystem_cg_daily_b07_v01),daily_volumes AS (SELECTprotocol,day,SUM(daily_volume_usd) AS daily_volume_usdFROM cg_bucketedGROUP BY 1, 2),cg_pivoted AS (SELECTday,SUM(CASE WHEN protocol = 'Ondo' THEN daily_volume_usd ELSE 0 END) AS ondo_daily_volume,SUM(CASE WHEN protocol = 'xStocks' THEN daily_volume_usd ELSE 0 END) AS xstocks_cg_volumeFROM daily_volumesGROUP BY day),