Query editor
1SELECT2 DATE_TRUNC('week', evt_block_time) AS week,3 AVG(TRY_CAST(value AS DOUBLE)) AS avg_transaction_size4FROM bonk_base.Bonk_evt_Transfer5GROUP BY6 17ORDER BY8 week910
SELECT
DATE_TRUNC('week', evt_block_time) AS week,
AVG(TRY_CAST(value AS DOUBLE)) AS avg_transaction_size
FROM bonk_base.Bonk_evt_Transfer
GROUP BY
1
ORDER BY
week