Insert values from other tables

foreigninsert.sql

#table declaration
CREATE TABLE `prices_by_seconds` (
  `ask_price` double,
  `ask_size` int(11),
  `bid_price` double,
  `bid_size` int(11),
  `last_trade_price` double,
  `symbol` varchar(8),
  `updated_at` datetime
)

CREATE TABLE `sets` (
  `id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `start` datetime,
  `end` datetime,
  `scale` int(11),
  `table` varchar(32),
  PRIMARY KEY (`id`)
)

INSERT INTO `sets` (`symbol`, `start`, `end`, `scale`, `table`) 
SELECT `symbol` , min(`updated_at`), max(`updated_at`), 100000, 'moment' 
FROM `prices_by_seconds` 
WHERE DATE(`updated_at`) = DATE(NOW()) GROUP BY `symbol`;