Query editor
WITHlst_to_mlrt_map AS (SELECT * FROM (VALUES(0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84, 0x49446a0874197839d15395b908328a74ccc96bc0),(0xf951E335afb289353dc249e82926178EaC7DEd78, 0x32bd822d615a3658a68b6fdd30c2fcb2c996d678),(0xa2E3356610840701BDf5611a53974510Ae27E2e1, 0xe46a5e19b19711332e33f33c2db3ea143e86bc10),(0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2, 0x18f313Fc6Afc9b5FD6f0908c1b3D476E3feA1DD9)) AS t(lst_token, mlrt_token)),token_metadata AS (SELECT * FROM (VALUES(0x49446a0874197839d15395b908328a74ccc96bc0, 'mLRT'),(0x32bd822d615a3658a68b6fdd30c2fcb2c996d678, 'mwBETH'),(0xe46a5e19b19711332e33f33c2db3ea143e86bc10, 'mwbETH'),(0x18f313Fc6Afc9b5FD6f0908c1b3D476E3feA1DD9, 'mWETH')) AS t(token, symbol)),latest_prices AS (SELECTm.lst_token,m.mlrt_token,p.priceFROM lst_to_mlrt_map mJOIN (SELECTcontract_address,price,ROW_NUMBER() OVER (PARTITION BY contract_address ORDER BY timestamp DESC) AS rnFROM prices.day) p ON p.contract_address = m.lst_tokenWHERE p.rn = 1),all_chains AS (SELECTevt_block_time,depositor AS "user",amount AS amount,tokenFROM zircuit_staking_ethereum.ZtakingPool_evt_DepositUNION ALLSELECTevt_block_time,withdrawer AS "user",-amount AS amount,tokenFROM zircuit_staking_ethereum.ZtakingPool_evt_withdraw),cumulative_balances AS (SELECTuser,token,evt_block_time,SUM(amount) OVER (PARTITION BY user, token ORDER BY evt_block_time) AS balanceFROM all_chains