Query editor
1SELECT2 DATE_TRUNC('day', evt_block_time) AS day,3 SUM(value) AS daily_transaction_volume4FROM bonk_base.Bonk_evt_Transfer5GROUP BY6 17ORDER BY8 daily_transaction_volume DESC9LIMIT 10
SELECT
DATE_TRUNC('day', evt_block_time) AS day,
SUM(value) AS daily_transaction_volume
FROM bonk_base.Bonk_evt_Transfer
GROUP BY
1
ORDER BY
daily_transaction_volume DESC
LIMIT 10