Query editor
WITH weekly_data AS (SELECTDATE_TRUNC('week', block_time) AS "Date",blockchain AS "Chain",SUM(CAST(amount_usd AS DOUBLE)) AS "USD Volume",COUNT(DISTINCT tx_from) AS DAU,COUNT(DISTINCT tx_hash) AS tx,SUM(CAST(amount_usd AS DOUBLE)) / COUNT(DISTINCT tx_from) AS "Avg Volume per User",SUM(CAST(amount_usd AS DOUBLE)) / COUNT(DISTINCT tx_hash) AS "Avg Volume per Trade"FROM dex.tradesWHERE block_time > DATE_TRUNC('day', NOW()) - INTERVAL '365' dayAND CASE WHEN '{{Filter_out_low_value_tx}}' = 'Y' THEN amount_usd > 0.1 ELSE amount_usd < 0.1 ENDGROUP BY 1, 2UNION ALLSELECTDATE_TRUNC('week', block_time) AS "Date",'Solana' AS "Chain",SUM(CAST(amount_usd AS DOUBLE)) AS "USD Volume",COUNT(DISTINCT trader_id) AS DAU,COUNT(*) AS tx,SUM(CAST(amount_usd AS DOUBLE)) / COUNT(DISTINCT trader_id) AS "Avg Volume per User",SUM(CAST(amount_usd AS DOUBLE)) / COUNT(*) AS "Avg Volume per Trade"FROM dex_solana.tradesWHERE block_time > DATE_TRUNC('day', NOW()) - INTERVAL '90' dayAND trader_id NOT IN ('2HDozvLZ8JPC8tuj5gKicAX3UX92AaKqXKkNGTyQgxC5')AND CASE WHEN '{{Filter_out_low_value_tx}}' = 'Y' THEN amount_usd > 0.1 ELSE amount_usd < 0.1 ENDGROUP BY 1, 2),filtered_weekly_data AS (SELECT *FROM weekly_dataWHERE "Date" BETWEEN DATE '2025-01-01' AND DATE '2025-03-05'),top_chains AS (SELECT "Chain"FROM filtered_weekly_dataGROUP BY "Chain"ORDER BY SUM("USD Volume") DESCLIMIT 7)SELECTfwd."Date",fwd."Chain",fwd."USD Volume",fwd.DAU,fwd."Avg Volume per User",AVG(fwd."Avg Volume per User") OVER (PARTITION BY fwd."Chain"ORDER BY fwd."Date"ROWS BETWEEN 3 PRECEDING AND CURRENT ROW) AS "4-Week Moving Avg Volume per User",fwd."Avg Volume per Trade",AVG(fwd."Avg Volume per Trade") OVER (PARTITION BY fwd."Chain"ORDER BY fwd."Date"ROWS BETWEEN 3 PRECEDING AND CURRENT ROW) AS "4-Week Moving Avg Volume per Trade"FROM filtered_weekly_data fwd