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']);
//---------------------------------------------------
