foreach ($data as $key => $val) { $cur_symbol = $val['Symbol']; array_push($symbols_array[$cur_symbol], $val); } _print_r($symbols_array, false); //------------------------------------- //------------------------------------- // find the open, heigh, low, & closing of the day $data_day = array(); foreach ($symbols_array as $key => $val) { $heigh_array = array(); $low_array = array(); foreach ($val as $kk => $vv) { $heigh_array[] = $vv['Heigh']; $low_array[] = $vv['Low']; } // _print_r($heigh_array,false); // _print_r($low_array,false); $date = explode(' ', $val[0]['Datetime']); $data_day[] = array('Symbol' => $val[0]['Symbol'], 'Open' => $val[0]['Open'], 'Heigh' => max($heigh_array), 'Low' => min($low_array), 'Closing' => $val[count($val) - 1]['Closing'], 'Datetime' => $val[0]['Datetime'], 'Range_start' => $date[0] . ' ' . $config['range_start'], 'Range_end' => $date[0] . ' ' . $config['range_end']); } _print_r($data_day, false); //---------------------------------- //--------------------------------------------------- // insert into day table $db->insert_day($config['db']['day_table'], $data_day); //--------------------------------------------------- //--------------------------------------------------- // delete data from the day table according to the settings $db->del($config['db']['day_table'], $config['day_table_range']); //---------------------------------------------------