Query editor
WITH all_rows AS (SELECT symbol, CAST(NULL AS VARCHAR) AS name, day, float_supply_units as nominal_balance, aum_usd FROM query_7433850UNION ALLSELECT symbol, CAST(NULL AS VARCHAR) AS name, day, float_supply_units as nominal_balance, aum_usd FROM query_7433828)SELECTsymbol,MAX(name) AS name,day,SUM(nominal_balance) AS nominal_balance,SUM(aum_usd) AS total_aum_usdFROM all_rowsGROUP BY symbol, nominal_balance, dayORDER BY day, total_aum_usd DESC;