Query editor
SELECTSUM(CASEWHEN "to" = 0x4200000000000000000000000000000000000010 THEN CAST(value AS DOUBLE) / 1e18WHEN "from" = 0x4200000000000000000000000000000000000010 THEN -CAST(value AS DOUBLE) / 1e18ELSE 0END) as total_net_ethFROM base.transactionsWHERE block_time > now() - interval '30' dayAND success = trueAND ("to" = 0x4200000000000000000000000000000000000010 OR "from" = 0x4200000000000000000000000000000000000010)