Query editor
1SELECT date_trunc('day', et.block_time) AS time2, et.`type` AS tx_type3, COUNT(et.block_time) AS tx_count4FROM ethereum.transactions et5WHERE et.block_time >= date_trunc('day', NOW() - interval '1 year')6GROUP BY time, tx_type
SELECT date_trunc('day', et.block_time) AS time
, et.`type` AS tx_type
, COUNT(et.block_time) AS tx_count
FROM ethereum.transactions et
WHERE et.block_time >= date_trunc('day', NOW() - interval '1 year')
GROUP BY time, tx_type