Query editor
with pricet as (selectdistinct contract_address as pcontract,pricefrom prices.latestwhere blockchain = 'plasma')/*with pricet as (selectdistinct t.contract_address as pcontract,t.symbol as psymbol,t.block_time,t.price_usdfrom tokens_plasma.transfers tjoin( select contract_address, max(block_time) as max_date from tokens_plasma.transfers where price_usd is not null group by contract_address ) lateston t.contract_address = latest.contract_address and t.block_time = latest.max_date ) *//*select sum(supply) as tot_supply from(*/selectdistinct contract_address,symbol,price,sum(bal) as supply,sum(bal)*price as supply_usd,count(distinct user) as holdersfrom(selectdistinct user,contract_address,symbol,sum(am) as balfrom(selectdistinct contract_address,symbol, "from" as user,block_time,tx_hash,-1 * amount as am,amount_usd as am_usdfrom tokens_plasma.transfersunionselectdistinct contract_address,symbol,"to" as user,block_time,tx_hash,amount as am,amount_usd as am_usdfrom tokens_plasma.transfers )group by 1,2,3 )join pricet on pcontract = contract_addresswhere bal > 0 and (lower(symbol) like '%usd%' or symbol = 'XAUt0')group by 1,2,price --)order by supply_usd desc