Query editor
WITH eth_transfers AS (SELECT"from" as address,SUM(CAST(value AS int256) * -1) as amountFROM erc20_ethereum.evt_TransferWHERE contract_address = 0x8d0d000ee44948fc98c9b98a4fa4921476f08b0dGROUP BY "from"UNION ALLSELECT"to" as address,SUM(CAST(value AS int256)) as amountFROM erc20_ethereum.evt_TransferWHERE contract_address = 0x8d0d000ee44948fc98c9b98a4fa4921476f08b0dGROUP BY "to"),eth_balances AS (SELECTaddress,SUM(amount) / POWER(10, 18) as balanceFROM eth_transfersWHERE address <> 0x0000000000000000000000000000000000000000GROUP BY addressHAVING SUM(amount) > 0),eth_total_supply AS (SELECT SUM(balance) as total FROM eth_balances),eth_ranked AS (SELECTaddress,balance,ROW_NUMBER() OVER (ORDER BY balance DESC) as rankFROM eth_balances),eth_concentration AS (SELECT'ethereum' as blockchain,SUM(CASE WHEN rank = 1 THEN balance ELSE 0 END) / (SELECT total FROM eth_total_supply) * 100 as top_1_pct,SUM(CASE WHEN rank <= 5 THEN balance ELSE 0 END) / (SELECT total FROM eth_total_supply) * 100 as top_5_pct,SUM(CASE WHEN rank <= 10 THEN balance ELSE 0 END) / (SELECT total FROM eth_total_supply) * 100 as top_10_pct,SUM(CASE WHEN rank <= 50 THEN balance ELSE 0 END) / (SELECT total FROM eth_total_supply) * 100 as top_50_pctFROM eth_ranked),bnb_transfers AS (SELECT"from" as address,SUM(CAST(value AS int256) * -1) as amountFROM erc20_bnb.evt_TransferWHERE contract_address = 0x8d0d000ee44948fc98c9b98a4fa4921476f08b0dGROUP BY "from"UNION ALLSELECT"to" as address,SUM(CAST(value AS int256)) as amountFROM erc20_bnb.evt_TransferWHERE contract_address = 0x8d0d000ee44948fc98c9b98a4fa4921476f08b0dGROUP BY "to"),bnb_balances AS (SELECT