Query editor
1SELECT2 DATE_TRUNC('week', block_time) AS week,3 'overall' AS volume_type,4 SUM(COALESCE(input_usd, output_usd)) AS volume5FROM jupiter_solana.aggregator_swaps6GROUP BY7 1,8 29ORDER BY10 1 DESC
SELECT
DATE_TRUNC('week', block_time) AS week,
'overall' AS volume_type,
SUM(COALESCE(input_usd, output_usd)) AS volume
FROM jupiter_solana.aggregator_swaps
GROUP BY
1,
2
ORDER BY
1 DESC