Query editor
/* Calculate the average 24-hour trading volume for each quarter *//* Calculate the daily trading volume */WITH daily_volume AS (SELECTDATE_TRUNC('day', block_time) AS day, /* Truncate the block_time to the day level */SUM(COALESCE(input_usd, output_usd)) AS volume /* Sum the input and output USD to get the daily volume */FROM jupiter_solana.aggregator_swapsWHEREblock_time BETWEEN CAST('2024-01-01' AS TIMESTAMP) AND CAST('2024-06-30' /* Filter data for Q1 and Q2 of 2024 */ AS TIMESTAMP)GROUP BY1)SELECTCASEWHEN day BETWEEN CAST('2024-01-01' AS TIMESTAMP) AND CAST('2024-03-31' AS TIMESTAMP)THEN 'Q1' /* Define Q1 */WHEN day BETWEEN CAST('2024-04-01' AS TIMESTAMP) AND CAST('2024-06-30' AS TIMESTAMP)THEN 'Q2' /* Define Q2 */END AS quarter,AVG(volume) AS average_24h_volume /* Calculate the average daily volume for each quarter */FROM daily_volumeGROUP BY1ORDER BYquarter