Query editor
with tokent as (selectblockchain as chain,contract_address as contract--symbol,--name,--decimalsfrom tokens.erc20where contract_address in (0x7A56E1C57C7475CCf742a1832B028F0456652F97,0x4aae823a6a0b376De6A78e74eCC5b079d38cBCf7,0x3647c54c4c2C65bC7a2D63c0Da2809B399DBBDC0,0xbc78d84ba0c46dfe32cf2895a19939c86b81a777,0xa68d25fC2AF7278db4BcdcAabce31814252642a9,0x541FD749419CA806a8bc7da8ac23D346f2dF8B77,0x3B86Ad95859b6AB773f55f8d94B4b9d443EE931f,0xaE4EFbc7736f963982aACb17EFA37fCBAb924cB3)),pricet as (selectpricefrom prices.latestwhere contract_address = 0x7A56E1C57C7475CCf742a1832B028F0456652F97and blockchain = 'ethereum'),supplyt as (selectdistinct blockchain,contract_address,symbol,sum(balance) as supply,count(distinct user) as holdersfrom(selectuser,blockchain,contract_address,symbol,sum(am) as balancefrom(selectblockchain,block_time,tx_hash,"from" as user,contract_address,symbol,-1 * amount as amfrom tokens.transfersjoin tokent on contract_address = contract and blockchain = chainunionselectblockchain,block_time,tx_hash,"to" as user,contract_address,symbol,amount as amfrom tokens.transfersjoin tokent on contract_address = contract and blockchain = chain