Query editor
with Agg as (SELECTdate_trunc('week',block_time) as date, 'Jupiter' as Trade_Source, sum(COALESCE(input_usd,output_usd)) as VolumeFROM jupiter_solana.aggregator_swapswhere block_time >= date'2025-05-05'and block_time < CURRENT_DATEgroup by 1, 2union allselectdate_trunc('week', block_time) as date, casewhen trade_source = '6m2CDdhRgxpH4WjvdzxAYbGxwdGUz5MziiL5jek2kBma' then 'OKX'when trade_source = 'T1TANpTeScyeqVzzgNViGDNrkQ6qHz9KrSBS4aNXvGT' then 'Titan'end as Trade_Source, sum(amount_usd) as Volumefrom dex_solana.tradeswhere trade_source in ('6m2CDdhRgxpH4WjvdzxAYbGxwdGUz5MziiL5jek2kBma', 'T1TANpTeScyeqVzzgNViGDNrkQ6qHz9KrSBS4aNXvGT')and block_time >= date'2025-05-05'and block_time < CURRENT_DATEgroup by 1, 2union ALLselectdate_trunc('week', evt_block_date) as date, 'DFlow' as trade_source, sum(coalesce(input_amount * p1.price / pow(10,p1.decimals), output_amount * p2.price / pow(10,p2.decimals))) as Volumefrom dflow_solana.swap_orchestrator_evt_swapevent a join dex_solana.price_hour p1 on a.input_mint = p1.contract_addressand date_trunc('hour',a.evt_block_time) = p1.hour and p1.price < pow(10,5)join dex_solana.price_hour p2 on a.output_mint = p2.contract_addressand date_trunc('hour',a.evt_block_time) = p2.hour and p2.price < pow(10,5)where evt_block_date >= date'2025-05-05'and evt_block_time < CURRENT_DATEgroup by 1, 2)selectdate, trade_source, sum(Volume) as trading_Volfrom Agggroup by 1, 2