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