Query editor
WITH ethDYDX_holders AS (SELECTaccount,SUM(amount) AS ethDYDX_balanceFROM (SELECT"from" AS account,-SUM(value / TRY_CAST(1e18 AS DOUBLE)) AS amountFROM erc20_ethereum.evt_TransferWHEREcontract_address = 0x92d6c1e31e14520e676a687f0a93788b716beff5GROUP BY1UNION ALLSELECT"to" AS account,SUM(value / TRY_CAST(1e18 AS DOUBLE)) AS amountFROM erc20_ethereum.evt_TransferWHEREcontract_address = 0x92d6c1e31e14520e676a687f0a93788b716beff5GROUP BY1) AS to_fromWHEREaccount <> 0x0000000000000000000000000000000000000000GROUP BY1),wethDYDX_holders AS (SELECTaccount,SUM(amount) AS wethDYDX_balanceFROM (SELECT"from" AS account,-SUM(value / TRY_CAST(1e18 AS DOUBLE)) AS amountFROM erc20_ethereum.evt_TransferWHEREcontract_address = 0x46b2DeAe6eFf3011008EA27EA36b7c27255ddFA9GROUP BY1UNION ALLSELECT"to" AS account,SUM(value / TRY_CAST(1e18 AS DOUBLE)) AS amountFROM erc20_ethereum.evt_TransferWHEREcontract_address = 0x46b2DeAe6eFf3011008EA27EA36b7c27255ddFA9GROUP BY1) AS to_fromWHEREaccount <> 0x0000000000000000000000000000000000000000GROUP BY1),stkDYDX_holders AS (SELECTaccount,SUM(amount) AS stkDYDX_balance