Query editor
WITH daily_migration AS (SELECTDATE(block_time) as date,COUNT(*) as daily_migration_txs,COUNT(DISTINCT "from") as unique_migrators,AVG(CAST(value AS DECIMAL(38,0)) / 1e18) as avg_transaction_size,AVG(gas_price) as avg_gas_priceFROM zksync.transactionsWHERE block_time >= CURRENT_DATE - INTERVAL '14' DAYAND CAST(value AS DECIMAL(38,0)) / 1e18 > 100AND gas_used > 50000GROUP BY DATE(block_time))SELECTdate,daily_migration_txs,unique_migrators,avg_transaction_size,avg_gas_price,LAG(daily_migration_txs) OVER (ORDER BY date) as prev_day_txs,LAG(unique_migrators) OVER (ORDER BY date) as prev_day_unique,(daily_migration_txs - LAG(daily_migration_txs) OVER (ORDER BY date)) as migration_increase,(unique_migrators - LAG(unique_migrators) OVER (ORDER BY date)) as unique_increase,CASEWHEN (daily_migration_txs - LAG(daily_migration_txs) OVER (ORDER BY date)) > 50 THEN 'ACCELERATING'WHEN (daily_migration_txs - LAG(daily_migration_txs) OVER (ORDER BY date)) > 20 THEN 'GROWING'WHEN (daily_migration_txs - LAG(daily_migration_txs) OVER (ORDER BY date)) > 0 THEN 'STABLE'ELSE 'DECLINING'END as acceleration_signalFROM daily_migrationORDER BY migration_increase DESC;