Query editor
SELECTdate_trunc('week',block_time) as week, COALESCE(amm_name, substring(amm,1,5)) as amm, sum(COALESCE(input_usd,output_usd)) as volume, count(distinct tx_signer) as tradersFROm jupiter_solana.aggregator_swaps spgroup by 1,2
Query editor
1SELECT2date_trunc('week',block_time) as week3, COALESCE(amm_name, substring(amm,1,5)) as amm4, sum(COALESCE(input_usd,output_usd)) as volume5, count(distinct tx_signer) as traders6FROm jupiter_solana.aggregator_swaps sp7group by 1,2