Query editor
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),totalt as (SELECTdistinct user as holder,count(distinct contract_address) as tokens,sum(bal_usd) as balanceFROM (SELECTuser,contract_address,symbol,COALESCE(SUM(amount)/pow(10,decimals),SUM(amount)) AS bal,COALESCE(SUM(amount)*price/pow(10,decimals),SUM(amount)) AS bal_usdFROM (SELECTcontract_address,evt_tx_hash,evt_block_time,"from" AS user,cast(0 - cast(value as double) as double) AS amountFROM erc20_plasma.evt_transfer--WHERE contract_address = 0xB8CE59FC3717ada4C02eaDF9682A9e934F625ebbUNION ALLSELECTcontract_address,evt_tx_hash,evt_block_time,"to" AS user,cast(value as double) AS amountFROM erc20_plasma.evt_transfer--WHERE contract_address = 0xB8CE59FC3717ada4C02eaDF9682A9e934F625ebb)join tokens on contract = contract_addressGROUP BY user, contract_address,symbol,decimals,price)WHERE bal > 0group by 1)selectcasewhen balance <= 10 then '1. Lees than $10'