Query editor
-- 1번 쿼리: 3일 이동평균 포함 버전WITH daily_data AS (SELECTDATE_TRUNC('day', block_time) as day,COUNT(*) as total_transactions,COUNT(DISTINCT "from") as unique_borrowers,COUNT(DISTINCT "to") as unique_lenders,SUM(value / 1e18) as daily_volume_eth,AVG(value / 1e18) as avg_tx_size_eth,MAX(value / 1e18) as max_tx_size_ethFROM ethereum.transactionsWHERE block_time >= now() - interval '7' dayAND value / 1e18 >= 1AND success = trueGROUP BY DATE_TRUNC('day', block_time))SELECTday,total_transactions,unique_borrowers,unique_lenders,ROUND(daily_volume_eth, 2) as daily_volume_eth,ROUND(avg_tx_size_eth, 2) as avg_tx_size_eth,ROUND(max_tx_size_eth, 2) as max_tx_size_eth,ROUND(AVG(daily_volume_eth) OVER (ORDER BY day ROWS BETWEEN 2 PRECEDING AND CURRENT ROW), 2) as volume_3d_avgFROM daily_dataORDER BY day DESC;