Query editor
WITH xWAlletTransfers AS (SELECTtr."from" AS address,CAST(tr.value AS DOUBLE)/POWER(10,18) AS amount,contract_addressFROM erc20_ethereum.evt_transfer trWHERE "from" = 0x0000000000000000000000000000000000000000and contract_address = 0x47cd7e91c3cbaaf266369fe8518345fc4fc12935UNION ALLSELECTtr."to" AS address,-CAST(tr.value AS DOUBLE)/POWER(10,18) AS amount,contract_addressFROM erc20_ethereum.evt_transfer trWHERE "to" = 0x0000000000000000000000000000000000000000and contract_address = 0x47cd7e91c3cbaaf266369fe8518345fc4fc12935),Wallet AS (SELECTtr."from" AS address,-CAST(tr.value AS DOUBLE)/POWER(10,18) AS amount,contract_addressFROM erc20_ethereum.evt_transfer trWHERE "from" = 0x47cd7e91c3cbaaf266369fe8518345fc4fc12935and contract_address = 0x88800092ff476844f74dc2fc427974bbee2794aeUNION ALLSELECTtr."to" AS address,CAST(tr.value AS DOUBLE)/POWER(10,18) AS amount,contract_addressFROM erc20_ethereum.evt_transfer trWHERE to = 0x47cd7e91c3cbaaf266369fe8518345fc4fc12935and contract_address = 0x88800092ff476844f74dc2fc427974bbee2794ae),XWalletSupply AS ( select SUM(amount) as XWALLETSUM FROM xWAlletTransfers ),XWalletWAlletHoldings AS ( SELECT SUM(amount) as WALLETHOLDINGS FROM Wallet ),WalletPrice as (select price from prices.usd_latestwhere contract_address =0x88800092ff476844f74dc2fc427974bbee2794ae),AdxStakingTransfers AS (SELECTtr."from" AS address,CAST(tr.value AS DOUBLE)/POWER(10,18) AS amount,contract_addressFROM erc20_ethereum.evt_transfer trWHERE "from" = 0x0000000000000000000000000000000000000000and contract_address = 0xb6456b57f03352be48bf101b46c1752a0813491aUNION ALLSELECTtr."to" AS address,-CAST(tr.value AS DOUBLE)/POWER(10,18) AS amount,contract_addressFROM erc20_ethereum.evt_transfer trWHERE "to" = 0x0000000000000000000000000000000000000000and contract_address = 0xb6456b57f03352be48bf101b46c1752a0813491a),ADEX AS (SELECTtr."from" AS address,-CAST(tr.value AS DOUBLE)/POWER(10,18) AS amount,