}
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 hour
$data_hourly = array();
foreach ($symbols_array as $key => $val) {
$rates_array = array();
$starting_array = array();
foreach ($val as $kk => $vv) {
$rates_array[] = $vv['Rate'];
$starting_array[] = $vv['Datetime'];
}
// _print_r($rates_array,false);
// _print_r($starting_array,false);
$data_hourly[] = array('Symbol' => $val[0]['Symbol'], 'Open' => $rates_array[0], 'Heigh' => max($rates_array), 'Low' => min($rates_array), 'Closing' => $rates_array[count($rates_array) - 1], 'Datetime' => $starting_array[0]);
}
//_print_r($data_hourly,false);
//----------------------------------
//---------------------------------------------------
// insert into hour table
$db->insert_hour($config['db']['hour_table'], $data_hourly);
//---------------------------------------------------
//---------------------------------------------------
// delete data from the hour table according to the settings
$db->del($config['db']['hour_table'], $config['hour_table_range']);
//---------------------------------------------------
