Query editor
WITH weekly_average_transaction AS (SELECTDATE_TRUNC('week', block_time) AS week,AVG(amount_usd) AS average_transaction_sizeFROMdex_solana.tradesGROUP BYDATE_TRUNC('week', block_time)ORDER BYweek)SELECT * FROM weekly_average_transaction;