Query editor
-- Plume 스타일: 부동산 토큰화 관련 거래SELECTDATE(block_time) as date,COUNT(*) as plume_style_txs,AVG(CAST(value AS DECIMAL(38,0)) / 1e18) as avg_value,COUNT(DISTINCT to) as unique_propertiesFROM ethereum.transactionsWHERE block_time >= CURRENT_DATE - INTERVAL '30' DAYAND CAST(value AS DECIMAL(38,0)) / 1e18 BETWEEN 5000 AND 50000 -- 부동산 규모AND gas_used > 150000 -- 부동산 토큰화 복잡도AND EXTRACT(HOUR FROM block_time) BETWEEN 8 AND 20 -- 긴 업무시간AND (-- 월말/분기말 패턴 (부동산 거래 특징)EXTRACT(DAY FROM block_time) BETWEEN 25 AND 31OR EXTRACT(DAY FROM block_time) BETWEEN 1 AND 5)GROUP BY DATE(block_time)ORDER BY date DESC;