Query editor
WITH excluded(addr) AS (VALUES(0x0000000000000000000000000000000000000000),(0xd5f7838f5c461feff7fe49ea5ebaf7728bb0adfa),(0xe3cbd06d7dadb3f4e6557bab7edd924cd1489e8f),(0x38fdf7b489316e03ed8754ad339cb5c4483fdcf9)),elig AS (SELECT addr AS walletFROM (SELECTaddr,sum(delta) / CAST(1e18 AS DECIMAL(38,0)) AS balance_methFROM (SELECT evt_block_time, "to" AS addr, CAST(value AS DECIMAL(38,0)) AS deltaFROM mantle_ethereum.meth_evt_transferUNION ALLSELECT evt_block_time, "from" AS addr, -CAST(value AS DECIMAL(38,0)) AS deltaFROM mantle_ethereum.meth_evt_transfer) flowsWHERE addr NOT IN (SELECT addr FROM excluded)AND evt_block_time < TIMESTAMP '2026-01-01 00:00:00'GROUP BY 1) bWHERE balance_meth >= 1),activity AS (SELECTwallet,count(*) FILTER (WHERE evt_block_time >= TIMESTAMP '2025-12-02' AND evt_block_time < TIMESTAMP '2026-01-01') AS tx_pre_30d,count(*) FILTER (WHERE evt_block_time >= TIMESTAMP '2026-01-01' AND evt_block_time < TIMESTAMP '2026-01-31') AS tx_post_30dFROM (SELECT evt_block_time, "from" AS wallet FROM mantle_ethereum.meth_evt_transferUNION ALLSELECT evt_block_time, "to" AS wallet FROM mantle_ethereum.meth_evt_transfer) xWHERE wallet IN (SELECT wallet FROM elig)GROUP BY 1)SELECTcount(*) AS eligible_wallets,avg(tx_pre_30d) AS avg_tx_pre_30d,avg(tx_post_30d) AS avg_tx_post_30d,avg(tx_post_30d - tx_pre_30d) AS avg_lift_tx_30d,count(*) FILTER (WHERE tx_post_30d > tx_pre_30d) * 1.0 / count(*) AS pct_increased_activityFROM activity;