Query editor
-- 개선된 RWA 프로토콜 ZKP 마이그레이션 조기 신호WITH ethereum_rwa AS (SELECTDATE(block_time) as date,COUNT(*) as rwa_ethereum_txs,SUM(CAST(value AS DECIMAL(38,0)) / 1e18) as total_volume_ethFROM ethereum.transactionsWHERE block_time >= CURRENT_DATE - INTERVAL '30' DAYAND CAST(value AS DECIMAL(38,0)) / 1e18 > 1000 -- RWA 패턴AND gas_used > 100000 -- 복잡한 RWA 트랜잭션GROUP BY DATE(block_time)),zksync_rwa AS (SELECTDATE(block_time) as date,COUNT(*) as rwa_zksync_txs,SUM(CAST(value AS DECIMAL(38,0)) / 1e18) as total_volume_zksyncFROM zksync.transactionsWHERE block_time >= CURRENT_DATE - INTERVAL '30' DAYAND CAST(value AS DECIMAL(38,0)) / 1e18 > 100 -- RWA 패턴AND gas_used > 50000 -- ZKP 최적화된 트랜잭션GROUP BY DATE(block_time))SELECTCOALESCE(e.date, z.date) as date,COALESCE(e.rwa_ethereum_txs, 0) as rwa_ethereum_txs,COALESCE(z.rwa_zksync_txs, 0) as rwa_zksync_txs,COALESCE(e.total_volume_eth, 0) as total_volume_eth,COALESCE(z.total_volume_zksync, 0) as total_volume_zksync,CASEWHEN COALESCE(e.rwa_ethereum_txs, 0) = 0 THEN 100.0ELSE (COALESCE(z.rwa_zksync_txs, 0) / NULLIF(e.rwa_ethereum_txs, 0)) * 100END as migration_ratio,CASEWHEN (COALESCE(z.rwa_zksync_txs, 0) / NULLIF(e.rwa_ethereum_txs, 0)) > 0.3 THEN 'HIGH_MIGRATION'WHEN (COALESCE(z.rwa_zksync_txs, 0) / NULLIF(e.rwa_ethereum_txs, 0)) > 0.1 THEN 'MEDIUM_MIGRATION'ELSE 'LOW_MIGRATION'END as migration_signalFROM ethereum_rwa eFULL OUTER JOIN zksync_rwa z ON e.date = z.dateORDER BY migration_ratio DESC;