Query editor
WITH components AS (SELECTsymbol,name,day,nominal_balance,aum_usdFROM query_5664941UNION ALLSELECTsymbol,name,day,float_supply_units AS nominal_balance,aum_usdFROM query_6084787UNION ALLSELECTsymbol,name,day,nominal_balance,aum_usdFROM query_7437753UNION ALLSELECTsymbol,name,day,float_supply_units AS nominal_balance,aum_usdFROM query_7437769),combined AS (SELECTsymbol,MAX_BY(name, CASE WHEN name IS NULL OR name = '' THEN 0 ELSE 1 END) AS name,day,SUM(COALESCE(nominal_balance, 0)) AS total_nominal_balance,SUM(COALESCE(aum_usd, 0)) AS total_aum_usdFROM componentsGROUP BY 1, 3)SELECTsymbol,name,day,total_nominal_balance,total_aum_usdFROM combinedORDER BY day, total_aum_usd DESC