/* Navicat Premium Data Transfer Source Server : localhost Source Server Type : MySQL Source Server Version : 80022 Source Host : localhost:3306 Source Schema : nstocks Target Server Type : MySQL Target Server Version : 80022 File Encoding : 65001 Date: 29/12/2021 23:44:26 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for stocks_limit_up -- ---------------------------- DROP TABLE IF EXISTS `stocks_limit_up`; CREATE TABLE `stocks_limit_up` ( `id` double NOT NULL AUTO_INCREMENT, `code` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `trade_day` date NULL DEFAULT NULL COMMENT '交易日期', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 161 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '每日涨停板' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of stocks_limit_up -- ---------------------------- INSERT INTO `stocks_limit_up` VALUES (1, '600184.SH', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (2, '605555.SH', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (3, '000722.SZ', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (4, '002141.SZ', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (5, '003019.SZ', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (6, '600773.SH', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (7, '000838.SZ', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (8, '600684.SH', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (9, '600215.SH', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (10, '000955.SZ', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (11, '600318.SH', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (12, '600291.SH', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (13, '603518.SH', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (14, '002269.SZ', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (15, '002212.SZ', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (16, '600695.SH', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (17, '000525.SZ', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (18, '600589.SH', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (19, '603928.SH', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (20, '600091.SH', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (21, '600078.SH', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (22, '603213.SH', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (23, '002068.SZ', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (24, '605020.SH', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (25, '000153.SZ', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (26, '603387.SH', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (27, '603351.SH', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (28, '605116.SH', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (29, '002581.SZ', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (30, '603960.SH', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (31, '300337.SZ', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (32, '002063.SZ', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (33, '003032.SZ', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (34, '000969.SZ', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (35, '000795.SZ', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (36, '002264.SZ', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (37, '600301.SH', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (38, '000972.SZ', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (39, '600506.SH', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (40, '600191.SH', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (41, '603219.SH', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (42, '603037.SH', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (43, '002813.SZ', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (44, '600856.SH', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (45, '300204.SZ', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (46, '002038.SZ', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (47, '600406.SH', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (48, '600973.SH', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (49, '000400.SZ', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (50, '603861.SH', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (51, '603530.SH', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (52, '600517.SH', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (53, '300933.SZ', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (54, '002350.SZ', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (55, '002606.SZ', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (56, '002358.SZ', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (57, '002162.SZ', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (58, '600260.SH', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (59, '603011.SH', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (60, '603398.SH', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (61, '600587.SH', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (62, '300869.SZ', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (63, '002432.SZ', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (64, '000812.SZ', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (65, '002825.SZ', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (66, '600351.SH', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (67, '600479.SH', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (68, '002317.SZ', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (69, '002873.SZ', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (70, '000587.SZ', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (71, '603611.SH', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (72, '002683.SZ', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (73, '002667.SZ', '2021-11-25'); INSERT INTO `stocks_limit_up` VALUES (74, '002047.SZ', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (75, '603895.SH', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (76, '300902.SZ', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (77, '002645.SZ', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (78, '002529.SZ', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (79, '300945.SZ', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (80, '002317.SZ', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (81, '000812.SZ', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (82, '600587.SH', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (83, '002432.SZ', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (84, '605186.SH', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (85, '603355.SH', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (86, '300866.SZ', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (87, '600281.SH', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (88, '002210.SZ', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (89, '603398.SH', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (90, '300907.SZ', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (91, '002338.SZ', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (92, '002943.SZ', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (93, '600775.SH', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (94, '300134.SZ', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (95, '603220.SH', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (96, '600260.SH', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (97, '002858.SZ', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (98, '603333.SH', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (99, '002300.SZ', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (100, '600856.SH', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (101, '603166.SH', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (102, '603358.SH', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (103, '603040.SH', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (104, '603286.SH', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (105, '603949.SH', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (106, '605333.SH', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (107, '000572.SZ', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (108, '688071.SH', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (109, '603048.SH', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (110, '600735.SH', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (111, '605009.SH', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (112, '603529.SH', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (113, '603219.SH', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (114, '600506.SH', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (115, '601101.SH', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (116, '002102.SZ', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (117, '300975.SZ', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (118, '600306.SH', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (119, '002988.SZ', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (120, '300224.SZ', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (121, '000795.SZ', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (122, '003037.SZ', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (123, '300264.SZ', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (124, '300659.SZ', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (125, '002766.SZ', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (126, '600595.SH', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (127, '000967.SZ', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (128, '002907.SZ', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (129, '002895.SZ', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (130, '603213.SH', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (131, '600691.SH', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (132, '002734.SZ', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (133, '000525.SZ', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (134, '600423.SH', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (135, '300987.SZ', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (136, '002076.SZ', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (137, '002323.SZ', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (138, '300591.SZ', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (139, '603196.SH', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (140, '603518.SH', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (141, '002269.SZ', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (142, '002687.SZ', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (143, '603511.SH', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (144, '605138.SH', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (145, '605055.SH', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (146, '605080.SH', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (147, '000838.SZ', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (148, '603920.SH', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (149, '003019.SZ', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (150, '300220.SZ', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (151, '605258.SH', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (152, '300076.SZ', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (153, '002885.SZ', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (154, '002902.SZ', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (155, '002730.SZ', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (156, '000791.SZ', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (157, '600098.SH', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (158, '600863.SH', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (159, '603728.SH', '2021-11-24'); INSERT INTO `stocks_limit_up` VALUES (160, '688662.SH', '2021-11-24'); SET FOREIGN_KEY_CHECKS = 1;