Query editor
-- 시간별 활동량SELECTDATE_TRUNC('hour', block_time) as hour,COUNT(*) as tx_countFROM zksync.transactionsWHERE block_time >= CURRENT_DATE - INTERVAL '30' DAYGROUP BY DATE_TRUNC('hour', block_time)ORDER BY hour;
Query editor
1-- 시간별 활동량2SELECT3DATE_TRUNC('hour', block_time) as hour,4COUNT(*) as tx_count5FROM zksync.transactions6WHERE block_time >= CURRENT_DATE - INTERVAL '30' DAY7GROUP BY DATE_TRUNC('hour', block_time)8ORDER BY hour;