Query editor
with tokent as (selectblockchain,contract_address,symbol,name,decimalsfrom tokens.erc20where contract_address in (0x4ca70811e831db42072cba1f0d03496ef126faad,0xcea2daf93617b97504e05affc5bcf9b3922d3034)),pricet as (selectpricefrom prices.latestwhere contract_address = 0x2260fac5e5542a773aa44fbcfedf7c193bc2c599and 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.transferswhere contract_address in (select contract_address from tokent)unionselectblockchain,block_time,tx_hash,"to" as user,contract_address,symbol,amount as amfrom tokens.transferswhere contract_address in (select contract_address from tokent))group by 1,2,3,4)