Query editor
WITH jupiter_volume AS (SELECTDATE_TRUNC('week', block_time) AS week,SUM(input_usd) AS jupiter_volumeFROM jupiter_solana.aggregator_swapsWHEREamm_name = 'Raydium amm'AND block_time >= CURRENT_TIMESTAMP - INTERVAL '6' MONTHGROUP BYDATE_TRUNC('week', block_time)),raydium_total_volume AS (WITH combined_trades AS (SELECTamount_usd,block_timeFROM raydium_v4.tradesWHEREblock_time >= DATE_TRUNC('day', CURRENT_DATE - INTERVAL '6' MONTH)UNION ALLSELECTamount_usd,block_timeFROM raydium_v3.tradesWHEREblock_time >= DATE_TRUNC('day', CURRENT_DATE - INTERVAL '6' MONTH))SELECTDATE_TRUNC('week', block_time) AS week,SUM(amount_usd) AS raydium_total_volumeFROM combined_tradesGROUP BYDATE_TRUNC('week', block_time))SELECTrtv.week,COALESCE(jv.jupiter_volume, 0) AS jupiter_volume,COALESCE(rtv.raydium_total_volume, 0) - COALESCE(jv.jupiter_volume, 0) AS raydium_native_volumeFROMraydium_total_volume rtvLEFT JOINjupiter_volume jvONrtv.week = jv.weekORDER BYrtv.week DESC;