Query editor
WITH params AS (SELECT '{{Chains:}}' AS chain_sel),wallet_flow AS (SELECTwallet,SUM(gmx_s_delta) AS gmx_s_amount,SUM(gmxmp_s_delta) AS gmxmp_s_amount,SUM(gmxmp_u_delta) AS gmxmp_u_amount,SUM(mp_c_delta) AS mp_c_amount,SUM(mp_b_delta) AS mp_b_amount,CAST(0 AS DOUBLE) AS mp_i_amount, -- kept for schema compatibility (original query had no MP_i source)SUM(mp_t_delta) AS mp_t_amountFROM (-- Arbitrum: TO-side contributionsSELECTCAST("to" AS VARCHAR) AS wallet,CASE WHEN contract_address = 0x908c4d94d34924765f1edc22a1dd098397c59dd4AND "from" = 0x0000000000000000000000000000000000000000THEN value / 1e18 ELSE 0 END AS gmx_s_delta,CASE WHEN contract_address = 0xd2d1162512f927a7e282ef43a362659e4f2a728fAND "from" = 0x0000000000000000000000000000000000000000THEN value / 1e18 ELSE 0 END AS gmxmp_s_delta,CAST(0 AS DOUBLE) AS gmxmp_u_delta,CASE WHEN contract_address = 0x35247165119b69a40edd5304969560d0ef486921AND "from" = 0x4d268a7d4c16ceb5a606c173bd974984343fea13THEN value / 1e18 ELSE 0 END AS mp_c_delta,CAST(0 AS DOUBLE) AS mp_b_delta,CASE WHEN contract_address = 0x35247165119b69a40edd5304969560d0ef486921THEN value / 1e18 ELSE 0 END AS mp_t_deltaFROM erc20_arbitrum.evt_TransferWHERE (SELECT chain_sel FROM params) IN ('All', 'Arbitrum')AND contract_address IN (0x908c4d94d34924765f1edc22a1dd098397c59dd4, -- sGMX0xd2d1162512f927a7e282ef43a362659e4f2a728f, -- sbfGMX0x35247165119b69a40edd5304969560d0ef486921 -- bnGMX)UNION ALL-- Arbitrum: FROM-side contributionsSELECTCAST("from" AS VARCHAR) AS wallet,CASE WHEN contract_address = 0x908c4d94d34924765f1edc22a1dd098397c59dd4AND "to" = 0x0000000000000000000000000000000000000000THEN -value / 1e18 ELSE 0 END AS gmx_s_delta,CAST(0 AS DOUBLE) AS gmxmp_s_delta,CASE WHEN contract_address = 0xd2d1162512f927a7e282ef43a362659e4f2a728fAND "to" = 0x0000000000000000000000000000000000000000THEN -value / 1e18 ELSE 0 END AS gmxmp_u_delta,CAST(0 AS DOUBLE) AS mp_c_delta,CASE WHEN contract_address = 0x35247165119b69a40edd5304969560d0ef486921AND "to" = 0x0000000000000000000000000000000000000000THEN value / 1e18 ELSE 0 END AS mp_b_delta,CASE WHEN contract_address = 0x35247165119b69a40edd5304969560d0ef486921THEN -value / 1e18 ELSE 0 END AS mp_t_deltaFROM erc20_arbitrum.evt_TransferWHERE (SELECT chain_sel FROM params) IN ('All', 'Arbitrum')AND contract_address IN (