Query editor
WITH daily_swaps AS (SELECTDATE_TRUNC('day', block_time) AS day, /* Truncate the block_time to the day level */SUM(CASE WHEN log_index = 1 THEN 1 ELSE 0 END) AS swaps /* Sum the number of swaps per day */FROM jupiter_solana.aggregator_swapsWHEREblock_time BETWEEN TRY_CAST('2024-01-01' AS TIMESTAMP) AND TRY_CAST('2024-06-30' AS TIMESTAMP) /* Filter data for Q1 and Q2 of 2024 */GROUP BYDATE_TRUNC('day', block_time))SELECTCASEWHEN day BETWEEN TRY_CAST('2024-01-01' AS TIMESTAMP) AND TRY_CAST('2024-03-31' AS TIMESTAMP)THEN 'Q1' /* Define Q1 */WHEN day BETWEEN TRY_CAST('2024-04-01' AS TIMESTAMP) AND TRY_CAST('2024-06-30' AS TIMESTAMP)THEN 'Q2' /* Define Q2 */END AS quarter,AVG(swaps) AS average_daily_swaps /* Calculate the average daily swaps for each quarter */FROM daily_swapsGROUP BY1ORDER BYquarter