Query editor
1SELECT2 DATE_TRUNC('week', block_time) AS week,3 AVG(amount_usd) AS average_transaction_size4FROM dex_solana.trades5WHERE6 token_bought_symbol = 'BONK' OR token_sold_symbol = 'BONK'7GROUP BY8 19ORDER BY10 week
SELECT
DATE_TRUNC('week', block_time) AS week,
AVG(amount_usd) AS average_transaction_size
FROM dex_solana.trades
WHERE
token_bought_symbol = 'BONK' OR token_sold_symbol = 'BONK'
GROUP BY
1
ORDER BY
week