Query editor
WITH weekly_transactions AS (SELECTDATE_TRUNC('week', block_date) AS week,amount_usdFROMwoofi.tradesWHEREamount_usd > 0AND token_bought_symbol = 'WOO')SELECTweek,AVG(amount_usd) AS avg_transaction_sizeFROMweekly_transactionsGROUP BYweekORDER BYweek ASC;