Query editor
WITH weekly_transactions AS (SELECTDATE_TRUNC('week', block_time) AS week_start,AVG(amount_usd) AS avg_transaction_sizeFROM dex_solana.tradesWHERENOT amount_usd IS NULLGROUP BY1ORDER BYweek_start)SELECTweek_start,avg_transaction_sizeFROM weekly_transactions