Query editor
-- 5번 쿼리: 시간별 거래 패턴 분석SELECTEXTRACT(hour FROM block_time) as hour_of_day,EXTRACT(dow FROM block_time) as day_of_week,COUNT(*) as tx_count,COUNT(DISTINCT "from") as unique_borrowers,ROUND(SUM(value / 1e18), 2) as total_volume_eth,ROUND(AVG(value / 1e18), 2) as avg_tx_size_ethFROM ethereum.transactionsWHERE block_time >= now() - interval '7' dayAND value / 1e18 >= 1AND success = trueGROUP BYEXTRACT(hour FROM block_time),EXTRACT(dow FROM block_time)ORDER BY day_of_week, hour_of_day;