Query editor
with pricet as (selectdistinct contract_address as contract,pricefrom prices.latestwhere blockchain = 'plasma')/*WITH pricet AS (SELECT priceFROM prices.latestWHERE blockchain = 'ethereum'AND contract_address = 0x68749665ff8d2d112fa859aa293f07a622782f38),tokens AS (SELECT 0xB8CE59FC3717ada4C02eaDF9682A9e934F625ebb AS contract, 'USDT0' AS symbol, 6 AS decimals, 1.0 AS price UNION ALLSELECT 0x1B64B9025EEbb9A6239575dF9Ea4b9Ac46D4d193, 'XAUt0', 6, (SELECT price FROM pricet) UNION ALLSELECT 0x211Cc4DD073734dA055fbF44a2b4667d5E5fE5d2, 'sUSDe', 18, 1.0 UNION ALLSELECT 0x5d3a1Ff2b6BAb83b63cd9AD0787074081a52ef34, 'USDe', 18, 1.0 UNION ALLSELECT 0x0A1a1A107E45b7Ced86833863f482BC5f4ed82EF, 'USDai', 18, 1.0 UNION ALLSELECT 0x0B2b2B2076d95dda7817e785989fE353fe955ef9, 'sUSDai', 18, 1.0)*/SELECTcontract_address,symbol,price,SUM(bal) AS supply,SUM(bal)*price AS supply_usd,COUNT(DISTINCT user) AS usersFROM (SELECTuser,contract_address,symbol,SUM(amount) AS balFROM (selectdistinct contract_address,symbol,"from" as user,block_time,tx_hash,-1 * amount as amount,amount_usd as am_usdfrom tokens_plasma.transfers--WHERE contract_address = 0xB8CE59FC3717ada4C02eaDF9682A9e934F625ebbUNION ALLselectdistinct contract_address,symbol,"to" as user,block_time,tx_hash,amount as am,amount_usd as am_usdfrom tokens_plasma.transfers--WHERE contract_address = 0xB8CE59FC3717ada4C02eaDF9682A9e934F625ebb