Query editor
WITH nm AS (SELECTsymbolFROM prices.tokensWHEREblockchain = 'ethereum'), eth AS (SELECTpriceFROM prices.usdWHEREsymbol = 'WETH'ORDER BYminuteLIMIT 1),l11 AS (SELECTSUM(CASEWHEN token_sold_symbol IN ('WETH')THEN COALESCE(amount_usd,TRY_CAST(token_sold_amount_raw AS DOUBLE) / 1e18 * (SELECTpriceFROM eth))ELSE COALESCE(-amount_usd,-TRY_CAST(token_bought_amount_raw AS DOUBLE) / 1e18 * (SELECTpriceFROM eth))END) AS delta,SUM(CASEWHEN token_sold_symbol IN ('WETH')THEN COALESCE(amount_usd,TRY_CAST(token_sold_amount_raw AS DOUBLE) / 1e18 * (SELECTpriceFROM eth))ELSE COALESCE(amount_usd,TRY_CAST(token_bought_amount_raw AS DOUBLE) / 1e18 * (SELECTpriceFROM eth))END) AS vol,