Query editor
WITH pricet AS (SELECTdistinct contract_address as token_address,psymbol,pricefrom(SELECTdistinct contract_address,symbol as psymbol,priceFROM prices.latestWHERE blockchain = 'bob'AND price is not nullUNIONSELECTdistinct b.contract_address,b.symbol as psymbol,u.priceFROM prices.latest bleft join prices.usd_latest u on b.symbol = u.symbolwhere u.blockchain = 'ethereum'and b.contract_address != 0x0000000000000000000000000000000000000000and u.price > 0)where contract_address in (0x0000000000000000000000000000000000000000, --eth0x2260fac5e5542a773aa44fbcfedf7c193bc2c599, --wbtc0xdac17f958d2ee523a2206206994597c13d831ec7, --usdt0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48, --usdc0x7122985656e38bdc0302db86685bb972b145bd3c, --stone0x6b175474e89094c44da98b954eedeac495271d0f --DAI)),baset AS (SELECT"from" AS user,tx_hash,contract_address,symbol,-1 * amount AS amFROM tokens_bob.transfersWHERE amount IS NOT NULLUNION ALLSELECT"to" AS user,tx_hash,contract_address,symbol,amount AS amFROM tokens_bob.transfersWHERE amount IS NOT NULL),user_balances AS (SELECTuser,contract_address,symbol,