Query editor
WITH all_chains AS (SELECT-value / 1e18 AS amount,"from" AS user,'mpendle-eth-wallet' AS token,evt_block_timeFROM erc20_ethereum.evt_transferWHERE contract_address = 0x83e817E1574e2201a005EC0f7e700ED5606F555EUNION ALLSELECTvalue / 1e18 AS amount,"to" AS user,'mpendle-eth-wallet' AS token,evt_block_timeFROM erc20_ethereum.evt_transferWHERE contract_address = 0x83e817E1574e2201a005EC0f7e700ED5606F555E),balances AS (SELECTuser,token,-- balance strictly up to Jan 1SUM(CASEWHEN evt_block_time <= TIMESTAMP '2026-01-01 00:00:00 UTC'THEN amountELSE 0END) AS balance_jan1,-- balance strictly up to Feb 1SUM(CASEWHEN evt_block_time <= TIMESTAMP '2026-02-01 00:00:00 UTC'THEN amountELSE 0END) AS balance_feb1FROM all_chainsGROUP BY user, token)SELECTuser,token,balance_jan1,balance_feb1,-- absolute balance changebalance_feb1 - balance_jan1 AS balance_change,-- increase / decrease labelCASEWHEN balance_feb1 > balance_jan1 THEN 'Increase'WHEN balance_feb1 < balance_jan1 THEN 'Decrease'