Query editor
WITHinflow as (SELECTto as address,contract_address,sum(value) / 1e18 as valueFROMerc20_ethereum.evt_TransferWHEREcontract_address IN (0x92d6c1e31e14520e676a687f0a93788b716beff5, --ethDYDX token0x46b2deae6eff3011008ea27ea36b7c27255ddfa9) -- wethDYDX tokenGROUP BY1,2),outflow as (SELECT"from" as address,contract_address,sum(value) / 1e18 as valueFROMerc20_ethereum.evt_TransferWHEREcontract_address IN (0x92d6c1e31e14520e676a687f0a93788b716beff5, --ethDYDX token0x46b2deae6eff3011008ea27ea36b7c27255ddfa9) -- wethDYDX tokenGROUP BY1,2),bridge_evt AS (SELECTb."from" AS address,accAddress AS dydx_chain_address_hex,evt_block_time,TRY_CAST(amount AS DOUBLE) / 1E18 AS amountFROMdydx_ethereum.WrappedEthereumDydxToken_evt_Bridge AS bORDER BYevt_block_time DESC),ethdydx_balances as (SELECTaddress,(i.value - COALESCE(o.value, 0)) as ethdydx_balanceFROMinflow iLEFT JOIN outflow o USING (address, contract_address)WHEREcontract_address = 0x92d6c1e31e14520e676a687f0a93788b716beff5),wethdydx_balances as (SELECTaddress,(i.value - COALESCE(o.value, 0)) as wethdydx_balanceFROM