Query editor
with tokent as (selectblockchain,contract_address,symbol--decimalsfrom tokens.erc20where contract_address in (0x4ca70811e831db42072cba1f0d03496ef126faad,0xcea2daf93617b97504e05affc5bcf9b3922d3034)unionselect'Solana' as blockchain,token_mint_address,symbolfrom tokens_solana.transferswhere token_mint_address = 'soLvpPEDkN8D1Wgjezrb1oj4WjGtj17vynGm6t3jah6'),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,