Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 need mysql query converted in sql server query

Author  Topic 

farhanqureshi007
Starting Member

5 Posts
Posted - 2010-05-21 : 03:33:12
hi all i have a mysql query which was previously created ages ago in my office...
and now i have got instruction to convert our whole database in sql server every thing is going fine for now... conversion of database transferring data etc...
except only one query




here is complete mysql script

######################################################################

CREATE TABLE `z_livefeedlocal` (
`rowid` int(11) NOT NULL auto_increment,
`symbol_code` varchar(10) NOT NULL,
`market_code` varchar(10) NOT NULL,
`symbol_state` varchar(10) NOT NULL,
`symbol_flag` varchar(10) NOT NULL,
`bid_volume` bigint(20) NOT NULL,
`bid_price` double NOT NULL,
`ask_price` double NOT NULL,
`ask_volume` bigint(11) NOT NULL,
`last_trade_price` double(10,2) NOT NULL,
`last_trade_volume` bigint(11) NOT NULL,
`last_trade_time` time NOT NULL,
`last_day_close_price` double(10,2) NOT NULL,
`symbol_direction` varchar(1) NOT NULL,
`average_price` double NOT NULL,
`high_price` double NOT NULL,
`low_price` double NOT NULL,
`net_change` double NOT NULL,
`total_traded_volume` bigint(20) NOT NULL,
`total_trades` int(11) NOT NULL,
PRIMARY KEY (`rowid`),
KEY `rowid` (`rowid`),
KEY `symbol_code` (`symbol_code`),
KEY `last_trade_time` (`last_trade_time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1


insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(311, "MCB", "REG", "OPN", "", 4900, 202, 202.49, 250, 202, 100, "09:19:12", 202.89, "-", 201.79, 203, 201.05, -0.89, 4600, 10);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(419, "MCB", "REG", "OPN", "", 4900, 202, 202.48, 1000, 202, 100, "09:19:12", 202.89, "-", 201.79, 203, 201.05, -0.89, 4600, 10);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(427, "MCB", "REG", "OPN", "", 2000, 202.01, 202.48, 1000, 202, 100, "09:19:12", 202.89, "-", 201.79, 203, 201.05, -0.89, 4600, 10);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(437, "MCB", "REG", "OPN", "", 1607, 202.01, 202.48, 1000, 202.01, 393, "09:19:31", 202.89, "+", 201.81, 203, 201.05, -0.88, 4993, 11);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(502, "MCB", "REG", "OPN", "", 1607, 202.01, 202.25, 100, 202.01, 393, "09:19:31", 202.89, "+", 201.81, 203, 201.05, -0.88, 4993, 11);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(711, "MCB", "REG", "OPN", "", 4900, 202.1, 202.25, 100, 202.01, 393, "09:19:31", 202.89, "+", 201.81, 203, 201.05, -0.88, 4993, 11);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(738, "MCB", "REG", "OPN", "", 3900, 202.1, 202.25, 100, 202.1, 1000, "09:20:12", 202.89, "+", 201.86, 203, 201.05, -0.79, 5993, 12);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(744, "MCB", "REG", "OPN", "", 1100, 202.05, 202.1, 1100, 202.1, 3900, "09:20:13", 202.89, "+", 201.95, 203, 201.05, -0.79, 9893, 13);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(766, "MCB", "REG", "OPN", "", 600, 202.05, 202.1, 1100, 202.05, 500, "09:20:16", 202.89, "-", 201.96, 203, 201.05, -0.84, 10393, 14);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(772, "MCB", "REG", "OPN", "", 1107, 202.01, 202.25, 100, 202.01, 500, "09:20:17", 202.89, "-", 201.97, 203, 201.05, -0.88, 11493, 16);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(857, "MCB", "REG", "OPN", "", 1007, 202.01, 202.25, 100, 202.01, 100, "09:20:31", 202.89, "-", 201.97, 203, 201.05, -0.88, 11593, 17);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(872, "MCB", "REG", "OPN", "", 200, 201.56, 202, 3993, 202.01, 1007, "09:20:32", 202.89, "-", 201.97, 203, 201.05, -0.88, 12600, 18);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(980, "MCB", "REG", "OPN", "", 200, 201.3, 201.55, 200, 201.56, 200, "09:20:47", 202.89, "-", 201.96, 203, 201.05, -1.33, 12800, 19);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(1004, "MCB", "REG", "OPN", "", 200, 201.3, 202, 3993, 201.55, 200, "09:20:51", 202.89, "-", 201.96, 203, 201.05, -1.34, 13000, 20);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(1034, "MCB", "REG", "OPN", "", 500, 201.32, 201.99, 1000, 201.55, 200, "09:20:51", 202.89, "-", 201.96, 203, 201.05, -1.34, 13000, 20);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(1046, "MCB", "REG", "OPN", "", 500, 201.32, 201.98, 200, 201.55, 200, "09:20:51", 202.89, "-", 201.96, 203, 201.05, -1.34, 13000, 20);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(1084, "MCB", "REG", "OPN", "", 500, 201.32, 201.97, 1000, 201.55, 200, "09:20:51", 202.89, "-", 201.96, 203, 201.05, -1.34, 13000, 20);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(1152, "MCB", "REG", "OPN", "", 1500, 201.35, 201.97, 1000, 201.55, 200, "09:20:51", 202.89, "-", 201.96, 203, 201.05, -1.34, 13000, 20);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(1317, "MCB", "REG", "OPN", "", 200, 201.3, 201.97, 1000, 201.55, 200, "09:20:51", 202.89, "-", 201.96, 203, 201.05, -1.34, 13000, 20);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(1337, "MCB", "REG", "OPN", "", 200, 201.26, 201.97, 1000, 201.26, 300, "09:21:37", 202.89, "-", 201.93, 203, 201.05, -1.63, 13500, 22);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(1366, "MCB", "REG", "OPN", "", 200, 201.26, 201.96, 250, 201.26, 300, "09:21:37", 202.89, "-", 201.93, 203, 201.05, -1.63, 13500, 22);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(1373, "MCB", "REG", "OPN", "", 500, 201.5, 201.96, 250, 201.26, 300, "09:21:37", 202.89, "-", 201.93, 203, 201.05, -1.63, 13500, 22);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(1380, "MCB", "REG", "OPN", "", 500, 201.5, 201.96, 450, 201.26, 300, "09:21:37", 202.89, "-", 201.93, 203, 201.05, -1.63, 13500, 22);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(1402, "MCB", "REG", "OPN", "", 500, 201.5, 201.95, 1000, 201.26, 300, "09:21:37", 202.89, "-", 201.93, 203, 201.05, -1.63, 13500, 22);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(1413, "MCB", "REG", "OPN", "", 500, 201.5, 201.9, 200, 201.26, 300, "09:21:37", 202.89, "-", 201.93, 203, 201.05, -1.63, 13500, 22);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(1490, "MCB", "REG", "OPN", "", 500, 201.51, 201.9, 200, 201.26, 300, "09:21:37", 202.89, "-", 201.93, 203, 201.05, -1.63, 13500, 22);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(1520, "MCB", "REG", "OPN", "", 500, 201.51, 201.89, 1000, 201.26, 300, "09:21:37", 202.89, "-", 201.93, 203, 201.05, -1.63, 13500, 22);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(1564, "MCB", "REG", "OPN", "", 200, 201.26, 201.88, 200, 201.51, 500, "09:22:08", 202.89, "+", 201.92, 203, 201.05, -1.38, 14000, 23);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(1575, "MCB", "REG", "OPN", "", 100, 201.26, 201.88, 200, 201.26, 100, "09:22:09", 202.89, "-", 201.91, 203, 201.05, -1.63, 14100, 24);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(1595, "MCB", "REG", "OPN", "", 100, 201.26, 201.87, 1500, 201.26, 100, "09:22:09", 202.89, "-", 201.91, 203, 201.05, -1.63, 14100, 24);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(1631, "MCB", "REG", "OPN", "", 100, 201.26, 201.87, 1000, 201.26, 100, "09:22:09", 202.89, "-", 201.91, 203, 201.05, -1.63, 14100, 24);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(1646, "MCB", "REG", "OPN", "", 1000, 201.55, 201.87, 1000, 201.26, 100, "09:22:09", 202.89, "-", 201.91, 203, 201.05, -1.63, 14100, 24);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(1654, "MCB", "REG", "OPN", "", 1000, 201.55, 201.85, 200, 201.26, 100, "09:22:09", 202.89, "-", 201.91, 203, 201.05, -1.63, 14100, 24);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(1685, "MCB", "REG", "OPN", "", 800, 201.55, 201.96, 450, 201.55, 200, "09:22:24", 202.89, "+", 201.91, 203, 201.05, -1.34, 14300, 25);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(1857, "MCB", "REG", "OPN", "", 800, 201.55, 201.95, 500, 201.55, 200, "09:22:24", 202.89, "+", 201.91, 203, 201.05, -1.34, 14300, 25);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(1866, "MCB", "REG", "OPN", "", 500, 201.56, 201.95, 500, 201.55, 200, "09:22:24", 202.89, "+", 201.91, 203, 201.05, -1.34, 14300, 25);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(1918, "MCB", "REG", "OPN", "", 500, 201.56, 201.94, 250, 201.55, 200, "09:22:24", 202.89, "+", 201.91, 203, 201.05, -1.34, 14300, 25);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(1977, "MCB", "REG", "OPN", "", 400, 201.56, 201.94, 250, 201.56, 100, "09:23:08", 202.89, "+", 201.9, 203, 201.05, -1.33, 14400, 26);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(2091, "MCB", "REG", "OPN", "", 400, 201.56, 201.93, 200, 201.56, 100, "09:23:08", 202.89, "+", 201.9, 203, 201.05, -1.33, 14400, 26);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(2199, "MCB", "REG", "OPN", "", 2600, 201.5, 201.75, 100, 201.5, 1400, "09:28:13", 202.89, "-", 201.83, 203, 201.05, -1.39, 54301, 74);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(2209, "MCB", "REG", "OPN", "", 500, 201.51, 201.75, 100, 201.5, 1400, "09:28:13", 202.89, "-", 201.83, 203, 201.05, -1.39, 54301, 74);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(2288, "MCB", "REG", "OPN", "", 479, 201.51, 201.75, 100, 201.51, 21, "09:28:27", 202.89, "+", 201.83, 203, 201.05, -1.38, 54322, 75);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(2289, "MCB", "REG", "OPN", "", 180, 201.56, 201.93, 200, 201.56, 220, "09:23:40", 202.89, "+", 201.9, 203, 201.05, -1.33, 14620, 27);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(2364, "MCB", "REG", "OPN", "", 500, 201.55, 201.75, 100, 201.51, 21, "09:28:27", 202.89, "+", 201.83, 203, 201.05, -1.38, 54322, 75);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(2395, "MCB", "REG", "OPN", "", 900, 201.75, 201.9, 1899, 201.75, 100, "09:28:35", 202.89, "+", 201.83, 203, 201.05, -1.14, 54422, 76);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(2480, "MCB", "REG", "OPN", "", 800, 201.57, 201.93, 200, 201.56, 220, "09:23:40", 202.89, "+", 201.9, 203, 201.05, -1.33, 14620, 27);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(2565, "MCB", "REG", "OPN", "", 800, 201.75, 201.9, 1899, 201.75, 100, "09:28:46", 202.89, "+", 201.83, 203, 201.05, -1.14, 54522, 77);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(2625, "MCB", "REG", "OPN", "", 800, 201.75, 201.9, 1849, 201.9, 50, "09:28:50", 202.89, "+", 201.83, 203, 201.05, -0.99, 54572, 78);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(2683, "MCB", "REG", "OPN", "", 500, 201.58, 201.93, 200, 201.56, 220, "09:23:40", 202.89, "+", 201.9, 203, 201.05, -1.33, 14620, 27);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(2693, "MCB", "REG", "OPN", "", 800, 201.75, 201.9, 349, 201.9, 1500, "09:28:57", 202.89, "+", 201.83, 203, 201.05, -0.99, 56072, 79);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(2704, "MCB", "REG", "OPN", "", 651, 201.9, 202, 261, 201.9, 349, "09:28:58", 202.89, "+", 201.83, 203, 201.05, -0.99, 56421, 80);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(2750, "MCB", "REG", "OPN", "", 500, 201.58, 201.92, 200, 201.56, 220, "09:23:40", 202.89, "+", 201.9, 203, 201.05, -1.33, 14620, 27);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(2778, "MCB", "REG", "OPN", "", 651, 201.9, 202, 11, 202, 239, "09:29:02", 202.89, "+", 201.83, 203, 201.05, -0.89, 56671, 82);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(2885, "MCB", "REG", "OPN", "", 500, 201.58, 201.91, 250, 201.56, 220, "09:23:40", 202.89, "+", 201.9, 203, 201.05, -1.33, 14620, 27);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(2890, "MCB", "REG", "OPN", "", 100, 201.26, 201.5, 520, 201.56, 180, "09:24:20", 202.89, "-", 201.87, 203, 201.05, -1.33, 16100, 30);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(2960, "MCB", "REG", "OPN", "", 100, 201.26, 201.5, 1520, 201.56, 180, "09:24:20", 202.89, "-", 201.87, 203, 201.05, -1.33, 16100, 30);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(2968, "MCB", "REG", "OPN", "", 1100, 201.26, 201.5, 1520, 201.56, 180, "09:24:20", 202.89, "-", 201.87, 203, 201.05, -1.33, 16100, 30);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(3042, "MCB", "REG", "OPN", "", 500, 201.27, 201.5, 1520, 201.56, 180, "09:24:20", 202.89, "-", 201.87, 203, 201.05, -1.33, 16100, 30);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(3065, "MCB", "REG", "OPN", "", 980, 201.5, 201.9, 500, 201.5, 1000, "09:24:45", 202.89, "-", 201.84, 203, 201.05, -1.39, 17620, 32);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(3107, "MCB", "REG", "OPN", "", 500, 201.51, 201.9, 500, 201.5, 1000, "09:24:45", 202.89, "-", 201.84, 203, 201.05, -1.39, 17620, 32);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(3131, "MCB", "REG", "OPN", "", 500, 201.3, 201.5, 20, 201.5, 980, "09:24:53", 202.89, "-", 201.81, 203, 201.05, -1.39, 19100, 34);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(3178, "MCB", "REG", "OPN", "", 500, 201.3, 201.5, 1320, 201.5, 980, "09:24:53", 202.89, "-", 201.81, 203, 201.05, -1.39, 19100, 34);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(3188, "MCB", "REG", "OPN", "", 500, 201.31, 201.5, 1320, 201.5, 980, "09:24:53", 202.89, "-", 201.81, 203, 201.05, -1.39, 19100, 34);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(3302, "MCB", "REG", "OPN", "", 680, 201.6, 201.88, 500, 201.5, 1300, "09:25:20", 202.89, "-", 201.79, 203, 201.05, -1.39, 20420, 36);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(3317, "MCB", "REG", "OPN", "", 680, 201.6, 201.89, 250, 201.5, 1300, "09:25:20", 202.89, "-", 201.79, 203, 201.05, -1.39, 20420, 36);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(3367, "MCB", "REG", "OPN", "", 500, 201.31, 201.6, 1120, 201.6, 680, "09:25:32", 202.89, "+", 201.78, 203, 201.05, -1.29, 21100, 37);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(3399, "MCB", "REG", "OPN", "", 500, 201.31, 202, 1911, 202, 589, "09:25:38", 202.89, "+", 201.82, 203, 201.05, -0.89, 31100, 48);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(3431, "MCB", "REG", "OPN", "", 500, 201.35, 201.99, 500, 202, 589, "09:25:38", 202.89, "+", 201.82, 203, 201.05, -0.89, 31100, 48);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(3448, "MCB", "REG", "OPN", "", 2500, 201.5, 201.99, 500, 202, 589, "09:25:38", 202.89, "+", 201.82, 203, 201.05, -0.89, 31100, 48);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(3489, "MCB", "REG", "OPN", "", 500, 201.51, 201.99, 500, 202, 589, "09:25:38", 202.89, "+", 201.82, 203, 201.05, -0.89, 31100, 48);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(3511, "MCB", "REG", "OPN", "", 500, 201.51, 201.99, 2500, 202, 589, "09:25:38", 202.89, "+", 201.82, 203, 201.05, -0.89, 31100, 48);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(3516, "MCB", "REG", "OPN", "", 3000, 201.53, 201.99, 2500, 202, 589, "09:25:38", 202.89, "+", 201.82, 203, 201.05, -0.89, 31100, 48);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(3523, "MCB", "REG", "OPN", "", 3000, 201.53, 201.98, 500, 202, 2589, "09:25:55", 202.89, "+", 201.85, 203, 201.05, -0.89, 38100, 52);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(3577, "MCB", "REG", "OPN", "", 500, 201.54, 201.98, 500, 202, 2589, "09:25:55", 202.89, "+", 201.85, 203, 201.05, -0.89, 38100, 52);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(3605, "MCB", "REG", "OPN", "", 1500, 201.54, 201.98, 500, 202, 2589, "09:25:55", 202.89, "+", 201.85, 203, 201.05, -0.89, 38100, 52);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(3617, "MCB", "REG", "OPN", "", 1500, 201.54, 201.9, 1000, 202, 2589, "09:25:55", 202.89, "+", 201.85, 203, 201.05, -0.89, 38100, 52);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(3627, "MCB", "REG", "OPN", "", 3000, 201.57, 201.9, 1000, 202, 2589, "09:25:55", 202.89, "+", 201.85, 203, 201.05, -0.89, 38100, 52);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(3662, "MCB", "REG", "OPN", "", 1500, 201.65, 201.9, 1000, 201.65, 500, "09:26:13", 202.89, "-", 201.85, 203, 201.05, -1.24, 38600, 53);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(3762, "MCB", "REG", "OPN", "", 100, 201.65, 201.9, 1000, 201.65, 1400, "09:26:27", 202.89, "-", 201.84, 203, 201.05, -1.24, 40000, 54);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(3786, "MCB", "REG", "OPN", "", 2100, 201.65, 201.9, 1000, 201.65, 1400, "09:26:27", 202.89, "-", 201.84, 203, 201.05, -1.24, 40000, 54);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(3852, "MCB", "REG", "OPN", "", 3000, 201.66, 201.9, 1000, 201.65, 1400, "09:26:27", 202.89, "-", 201.84, 203, 201.05, -1.24, 40000, 54);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(3899, "MCB", "REG", "OPN", "", 2000, 201.75, 201.9, 1000, 201.65, 1400, "09:26:27", 202.89, "-", 201.84, 203, 201.05, -1.24, 40000, 54);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(3925, "MCB", "REG", "OPN", "", 2000, 201.75, 201.89, 500, 201.65, 1400, "09:26:27", 202.89, "-", 201.84, 203, 201.05, -1.24, 40000, 54);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(3971, "MCB", "REG", "OPN", "", 1900, 201.75, 201.89, 500, 201.75, 100, "09:26:59", 202.89, "+", 201.84, 203, 201.05, -1.14, 40100, 55);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(4026, "MCB", "REG", "OPN", "", 1900, 201.75, 201.89, 300, 201.89, 200, "09:27:07", 202.89, "+", 201.84, 203, 201.05, -1, 40300, 56);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(4056, "MCB", "REG", "OPN", "", 1900, 201.75, 201.9, 300, 201.9, 700, "09:27:11", 202.89, "+", 201.85, 203, 201.05, -0.99, 41300, 58);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(4066, "MCB", "REG", "OPN", "", 700, 201.9, 201.97, 250, 201.9, 300, "09:27:12", 202.89, "+", 201.85, 203, 201.05, -0.99, 41600, 59);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(4115, "MCB", "REG", "OPN", "", 800, 201.9, 201.97, 250, 201.9, 300, "09:27:12", 202.89, "+", 201.85, 203, 201.05, -0.99, 41600, 59);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(4124, "MCB", "REG", "OPN", "", 800, 201.9, 201.95, 100, 201.9, 300, "09:27:12", 202.89, "+", 201.85, 203, 201.05, -0.99, 41600, 59);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(4222, "MCB", "REG", "OPN", "", 650, 201.9, 201.95, 100, 201.9, 150, "09:27:32", 202.89, "+", 201.85, 203, 201.05, -0.99, 41750, 60);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(4247, "MCB", "REG", "OPN", "", 1, 201.92, 201.95, 100, 201.9, 150, "09:27:32", 202.89, "+", 201.85, 203, 201.05, -0.99, 41750, 60);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(4345, "MCB", "REG", "OPN", "", 1, 201.92, 202, 811, 202, 1939, "09:27:52", 202.89, "+", 201.86, 203, 201.05, -0.89, 46750, 66);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(4353, "MCB", "REG", "OPN", "", 1, 201.92, 202, 261, 202, 550, "09:27:53", 202.89, "+", 201.86, 203, 201.05, -0.89, 47300, 67);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(4376, "MCB", "REG", "OPN", "", 1900, 201.75, 201.9, 1899, 201.9, 100, "09:27:57", 202.89, "-", 201.86, 203, 201.05, -0.99, 47401, 69);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(4433, "MCB", "REG", "OPN", "", 100, 201.65, 201.75, 100, 201.75, 1900, "09:28:08", 202.89, "-", 201.86, 203, 201.05, -1.14, 49301, 70);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(4452, "MCB", "REG", "OPN", "", 500, 201.31, 201.5, 1400, 201.5, 2500, "09:28:11", 202.89, "-", 201.84, 203, 201.05, -1.39, 52901, 73);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(4465, "MCB", "REG", "OPN", "", 600, 201.5, 201.75, 100, 201.5, 1400, "09:28:13", 202.89, "-", 201.83, 203, 201.05, -1.39, 54301, 74);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(4538, "MCB", "REG", "OPN", "", 651, 201.9, 202, 2011, 202, 239, "09:29:02", 202.89, "+", 201.83, 203, 201.05, -0.89, 56671, 82);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(4611, "MCB", "REG", "OPN", "", 151, 201.9, 202, 2011, 202, 239, "09:29:02", 202.89, "+", 201.83, 203, 201.05, -0.89, 56671, 82);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(4692, "MCB", "REG", "OPN", "", 1800, 201.75, 201.9, 49, 201.9, 151, "09:29:35", 202.89, "-", 201.84, 203, 201.05, -0.99, 58822, 85);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(4735, "MCB", "REG", "OPN", "", 451, 201.9, 202, 11, 201.9, 49, "09:29:40", 202.89, "-", 201.84, 203, 201.05, -0.99, 58871, 86);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(4770, "MCB", "REG", "OPN", "", 451, 201.9, 202, 2811, 201.9, 49, "09:29:40", 202.89, "-", 201.84, 203, 201.05, -0.99, 58871, 86);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(4857, "MCB", "REG", "OPN", "", 451, 201.9, 201.99, 250, 201.9, 49, "09:29:40", 202.89, "-", 201.84, 203, 201.05, -0.99, 58871, 86);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(4895, "MCB", "REG", "OPN", "", 451, 201.9, 202, 1061, 202, 1739, "09:30:07", 202.89, "+", 201.84, 203, 201.05, -0.89, 60871, 89);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(4918, "MCB", "REG", "OPN", "", 451, 201.9, 201.99, 21, 202, 1739, "09:30:07", 202.89, "+", 201.84, 203, 201.05, -0.89, 60871, 89);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(4933, "MCB", "REG", "OPN", "", 500, 201.55, 201.75, 2749, 201.75, 1000, "09:30:15", 202.89, "-", 201.84, 203, 201.05, -1.14, 63122, 92);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(4945, "MCB", "REG", "OPN", "", 500, 201.55, 201.75, 2049, 201.75, 200, "09:30:16", 202.89, "-", 201.84, 203, 201.05, -1.14, 63822, 94);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(4982, "MCB", "REG", "OPN", "", 500, 201.55, 201.75, 49, 201.75, 2000, "09:30:22", 202.89, "-", 201.84, 203, 201.05, -1.14, 65822, 95);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(5003, "MCB", "REG", "OPN", "", 1000, 201.6, 201.75, 49, 201.75, 2000, "09:30:22", 202.89, "-", 201.84, 203, 201.05, -1.14, 65822, 95);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(5029, "MCB", "REG", "OPN", "", 951, 201.75, 201.99, 21, 201.75, 49, "09:30:28", 202.89, "-", 201.84, 203, 201.05, -1.14, 65871, 96);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(5039, "MCB", "REG", "OPN", "", 951, 201.75, 201.98, 250, 201.75, 49, "09:30:28", 202.89, "-", 201.84, 203, 201.05, -1.14, 65871, 96);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(5055, "MCB", "REG", "OPN", "", 1000, 201.6, 201.75, 4049, 201.75, 951, "09:30:32", 202.89, "-", 201.83, 203, 201.05, -1.14, 66822, 97);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(5117, "MCB", "REG", "OPN", "", 951, 201.75, 201.97, 100, 201.75, 4049, "09:30:41", 202.89, "-", 201.83, 203, 201.05, -1.14, 70871, 98);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(5136, "MCB", "REG", "OPN", "", 951, 201.75, 201.95, 250, 201.75, 4049, "09:30:41", 202.89, "-", 201.83, 203, 201.05, -1.14, 70871, 98);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(5188, "MCB", "REG", "OPN", "", 1051, 201.75, 201.95, 250, 201.75, 4049, "09:30:41", 202.89, "-", 201.83, 203, 201.05, -1.14, 70871, 98);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(5252, "MCB", "REG", "OPN", "", 100, 201.8, 201.95, 250, 201.75, 4049, "09:30:41", 202.89, "-", 201.83, 203, 201.05, -1.14, 70871, 98);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(5382, "MCB", "REG", "OPN", "", 100, 201.8, 201.99, 21, 201.75, 4049, "09:30:41", 202.89, "-", 201.83, 203, 201.05, -1.14, 70871, 98);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(5687, "MCB", "REG", "OPN", "", 179, 201.99, 202, 1061, 201.99, 21, "09:32:08", 202.89, "+", 201.83, 203, 201.05, -0.9, 70892, 99);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(5752, "MCB", "REG", "OPN", "", 100, 201.8, 202, 882, 202, 179, "09:32:18", 202.89, "+", 201.83, 203, 201.05, -0.89, 71071, 100);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(5782, "MCB", "REG", "OPN", "", 100, 201.8, 202, 782, 202, 100, "09:32:22", 202.89, "+", 201.83, 203, 201.05, -0.89, 71171, 101);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(5831, "MCB", "REG", "OPN", "", 100, 201.8, 202, 282, 202, 500, "09:32:31", 202.89, "+", 201.83, 203, 201.05, -0.89, 71671, 102);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(5843, "MCB", "REG", "OPN", "", 100, 201.85, 202, 282, 202, 500, "09:32:31", 202.89, "+", 201.83, 203, 201.05, -0.89, 71671, 102);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(5896, "MCB", "REG", "OPN", "", 1000, 201.6, 201.75, 3749, 201.75, 100, "09:32:41", 202.89, "-", 201.83, 203, 201.05, -1.14, 72922, 106);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(5925, "MCB", "REG", "OPN", "", 1251, 201.75, 202, 282, 201.75, 3749, "09:32:46", 202.89, "-", 201.83, 203, 201.05, -1.14, 76671, 107);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(5952, "MCB", "REG", "OPN", "", 100, 201.8, 202, 282, 201.75, 3749, "09:32:46", 202.89, "-", 201.83, 203, 201.05, -1.14, 76671, 107);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(5981, "MCB", "REG", "OPN", "", 1000, 201.6, 201.75, 3649, 201.75, 1251, "09:32:54", 202.89, "-", 201.83, 203, 201.05, -1.14, 78022, 109);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(6037, "MCB", "REG", "OPN", "", 100, 201.65, 201.75, 3649, 201.75, 1251, "09:32:54", 202.89, "-", 201.83, 203, 201.05, -1.14, 78022, 109);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(6127, "MCB", "REG", "OPN", "", 500, 201.66, 201.75, 3649, 201.75, 1251, "09:32:54", 202.89, "-", 201.83, 203, 201.05, -1.14, 78022, 109);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(6181, "MCB", "REG", "OPN", "", 500, 201.66, 201.75, 3149, 201.75, 500, "09:33:33", 202.89, "-", 201.82, 203, 201.05, -1.14, 78522, 110);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(6190, "MCB", "REG", "OPN", "", 100, 201.65, 201.75, 3149, 201.66, 500, "09:33:35", 202.89, "-", 201.82, 203, 201.05, -1.23, 79022, 111);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(6237, "MCB", "REG", "OPN", "", 1000, 201.6, 201.65, 400, 201.65, 100, "09:33:44", 202.89, "-", 201.82, 203, 201.05, -1.24, 79122, 112);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(6278, "MCB", "REG", "OPN", "", 600, 201.6, 201.75, 3149, 201.6, 400, "09:33:51", 202.89, "-", 201.82, 203, 201.05, -1.29, 79522, 113);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(6293, "MCB", "REG", "OPN", "", 600, 201.6, 201.75, 2949, 201.75, 200, "09:33:53", 202.89, "+", 201.82, 203, 201.05, -1.14, 79722, 114);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(6344, "MCB", "REG", "OPN", "", 600, 201.6, 201.74, 200, 201.75, 200, "09:33:53", 202.89, "+", 201.82, 203, 201.05, -1.14, 79722, 114);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(6527, "MCB", "REG", "OPN", "", 600, 201.6, 201.75, 2949, 201.75, 200, "09:33:53", 202.89, "+", 201.82, 203, 201.05, -1.14, 79722, 114);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(6575, "MCB", "REG", "OPN", "", 600, 201.6, 201.75, 2449, 201.75, 500, "09:34:44", 202.89, "+", 201.82, 203, 201.05, -1.14, 80222, 115);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(6583, "MCB", "REG", "OPN", "", 600, 201.6, 201.74, 500, 201.75, 500, "09:34:44", 202.89, "+", 201.82, 203, 201.05, -1.14, 80222, 115);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(6837, "MCB", "REG", "OPN", "", 1100, 201.6, 201.74, 500, 201.75, 500, "09:34:44", 202.89, "+", 201.82, 203, 201.05, -1.14, 80222, 115);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(6932, "MCB", "REG", "OPN", "", 1100, 201.6, 201.74, 496, 201.74, 4, "09:35:53", 202.89, "-", 201.82, 203, 201.05, -1.15, 80226, 116);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(7134, "MCB", "REG", "OPN", "", 1100, 201.6, 201.73, 250, 201.74, 4, "09:35:53", 202.89, "-", 201.82, 203, 201.05, -1.15, 80226, 116);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(7420, "MCB", "REG", "OPN", "", 900, 201.6, 201.73, 250, 201.6, 200, "09:37:25", 202.89, "-", 201.82, 203, 201.05, -1.29, 80426, 117);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(7458, "MCB", "REG", "OPN", "", 900, 201.6, 201.7, 250, 201.6, 200, "09:37:25", 202.89, "-", 201.82, 203, 201.05, -1.29, 80426, 117);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(7472, "MCB", "REG", "OPN", "", 500, 201.55, 201.6, 100, 201.6, 500, "09:37:31", 202.89, "-", 201.82, 203, 201.05, -1.29, 81326, 119);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(7533, "MCB", "REG", "OPN", "", 243, 201.51, 201.6, 100, 201.51, 246, "09:37:42", 202.89, "-", 201.82, 203, 201.05, -1.38, 82072, 122);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(7568, "MCB", "REG", "OPN", "", 143, 201.51, 201.6, 100, 201.51, 100, "09:37:47", 202.89, "-", 201.82, 203, 201.05, -1.38, 82172, 123);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(7576, "MCB", "REG", "OPN", "", 2500, 201.5, 201.51, 357, 201.5, 100, "09:37:48", 202.89, "-", 201.81, 203, 201.05, -1.39, 82415, 126);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(7588, "MCB", "REG", "OPN", "", 1500, 201.5, 201.51, 357, 201.5, 500, "09:37:49", 202.89, "-", 201.81, 203, 201.05, -1.39, 83415, 128);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(7595, "MCB", "REG", "OPN", "", 500, 201.5, 201.51, 357, 201.5, 500, "09:37:50", 202.89, "-", 201.81, 203, 201.05, -1.39, 84415, 130);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(7607, "MCB", "REG", "OPN", "", 500, 201.3, 201.5, 500, 201.5, 500, "09:37:52", 202.89, "-", 201.81, 203, 201.05, -1.39, 84915, 131);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(7651, "MCB", "REG", "OPN", "", 500, 201.3, 201.5, 700, 201.5, 500, "09:37:52", 202.89, "-", 201.81, 203, 201.05, -1.39, 84915, 131);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(7683, "MCB", "REG", "OPN", "", 300, 201.31, 201.5, 700, 201.5, 500, "09:37:52", 202.89, "-", 201.81, 203, 201.05, -1.39, 84915, 131);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(7705, "MCB", "REG", "OPN", "", 300, 201.31, 201.47, 500, 201.5, 500, "09:37:52", 202.89, "-", 201.81, 203, 201.05, -1.39, 84915, 131);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(7740, "MCB", "REG", "OPN", "", 300, 201.31, 201.47, 300, 201.47, 200, "09:38:12", 202.89, "-", 201.8, 203, 201.05, -1.42, 85115, 132);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(7794, "MCB", "REG", "OPN", "", 300, 201.31, 201.46, 357, 201.47, 200, "09:38:12", 202.89, "-", 201.8, 203, 201.05, -1.42, 85115, 132);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(7846, "MCB", "REG", "OPN", "", 300, 201.31, 201.45, 300, 201.47, 200, "09:38:12", 202.89, "-", 201.8, 203, 201.05, -1.42, 85115, 132);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(7868, "MCB", "REG", "OPN", "", 300, 201.31, 201.45, 280, 201.45, 20, "09:38:32", 202.89, "-", 201.8, 203, 201.05, -1.44, 85135, 133);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(7932, "MCB", "REG", "OPN", "", 500, 201.3, 201.31, 200, 201.31, 300, "09:38:42", 202.89, "-", 201.8, 203, 201.05, -1.58, 85435, 134);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(7942, "MCB", "REG", "OPN", "", 1200, 201.05, 201.31, 200, 201.05, 800, "09:38:43", 202.89, "-", 201.78, 203, 201.05, -1.84, 88435, 140);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(7966, "MCB", "REG", "OPN", "", 500, 200.75, 201, 80, 201, 100, "09:38:47", 202.89, "-", 201.76, 203, 201, -1.89, 91355, 146);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(8000, "MCB", "REG", "OPN", "", 500, 200.75, 200.9, 280, 201, 100, "09:38:47", 202.89, "-", 201.76, 203, 201, -1.89, 91355, 146);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(8025, "MCB", "REG", "OPN", "", 500, 200.8, 200.9, 280, 201, 100, "09:38:47", 202.89, "-", 201.76, 203, 201, -1.89, 91355, 146);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(8038, "MCB", "REG", "OPN", "", 401, 200.8, 200.9, 280, 200.8, 80, "09:38:58", 202.89, "-", 201.75, 203, 200.8, -2.09, 91454, 148);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(8056, "MCB", "REG", "OPN", "", 100, 200.81, 200.9, 280, 200.8, 80, "09:38:58", 202.89, "-", 201.75, 203, 200.8, -2.09, 91454, 148);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(8065, "MCB", "REG", "OPN", "", 100, 200.81, 200.9, 180, 200.9, 100, "09:39:02", 202.89, "+", 201.75, 203, 200.8, -1.99, 91554, 149);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(8075, "MCB", "REG", "OPN", "", 320, 200.9, 201.31, 200, 200.9, 180, "09:39:03", 202.89, "+", 201.75, 203, 200.8, -1.99, 91734, 150);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(8107, "MCB", "REG", "OPN", "", 320, 200.9, 201.3, 750, 200.9, 180, "09:39:03", 202.89, "+", 201.75, 203, 200.8, -1.99, 91734, 150);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(8141, "MCB", "REG", "OPN", "", 320, 200.9, 201.29, 357, 200.9, 180, "09:39:03", 202.89, "+", 201.75, 203, 200.8, -1.99, 91734, 150);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(8159, "MCB", "REG", "OPN", "", 320, 200.9, 201.1, 500, 200.9, 180, "09:39:03", 202.89, "+", 201.75, 203, 200.8, -1.99, 91734, 150);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(8187, "MCB", "REG", "OPN", "", 200, 201, 201.1, 500, 200.9, 180, "09:39:03", 202.89, "+", 201.75, 203, 200.8, -1.99, 91734, 150);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(8208, "MCB", "REG", "OPN", "", 320, 200.9, 201.1, 500, 201, 200, "09:39:31", 202.89, "+", 201.75, 203, 200.8, -1.89, 91934, 151);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(8274, "MCB", "REG", "OPN", "", 100, 200.81, 200.9, 180, 200.9, 320, "09:39:44", 202.89, "-", 201.75, 203, 200.8, -1.99, 92254, 152);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(8279, "MCB", "REG", "OPN", "", 100, 200.81, 200.9, 480, 200.9, 320, "09:39:44", 202.89, "-", 201.75, 203, 200.8, -1.99, 92254, 152);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(8339, "MCB", "REG", "OPN", "", 300, 200.75, 200.9, 180, 200.75, 200, "09:39:55", 202.89, "-", 201.74, 203, 200.75, -2.14, 92554, 154);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(8407, "MCB", "REG", "OPN", "", 300, 200.5, 200.9, 180, 200.5, 200, "09:40:08", 202.89, "-", 201.74, 203, 200.5, -2.39, 93054, 156);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(8656, "MCB", "REG", "OPN", "", 500, 200.51, 200.9, 180, 200.5, 200, "09:40:08", 202.89, "-", 201.74, 203, 200.5, -2.39, 93054, 156);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(8708, "MCB", "REG", "OPN", "", 600, 200.51, 200.9, 180, 200.5, 200, "09:40:08", 202.89, "-", 201.74, 203, 200.5, -2.39, 93054, 156);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(8735, "MCB", "REG", "OPN", "", 500, 200.6, 200.9, 180, 200.5, 200, "09:40:08", 202.89, "-", 201.74, 203, 200.5, -2.39, 93054, 156);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(8799, "MCB", "REG", "OPN", "", 500, 200.6, 200.8, 100, 200.5, 200, "09:40:08", 202.89, "-", 201.74, 203, 200.5, -2.39, 93054, 156);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(8848, "MCB", "REG", "OPN", "", 500, 200.6, 200.9, 180, 200.5, 200, "09:40:08", 202.89, "-", 201.74, 203, 200.5, -2.39, 93054, 156);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(8862, "MCB", "REG", "OPN", "", 2000, 200.7, 200.9, 180, 200.5, 200, "09:40:08", 202.89, "-", 201.74, 203, 200.5, -2.39, 93054, 156);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(8914, "MCB", "REG", "OPN", "", 2901, 200.71, 200.9, 180, 200.5, 200, "09:40:08", 202.89, "-", 201.74, 203, 200.5, -2.39, 93054, 156);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(8932, "MCB", "REG", "OPN", "", 401, 200.72, 200.9, 180, 200.5, 200, "09:40:08", 202.89, "-", 201.74, 203, 200.5, -2.39, 93054, 156);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(8946, "MCB", "REG", "OPN", "", 2000, 200.75, 200.9, 180, 200.5, 200, "09:40:08", 202.89, "-", 201.74, 203, 200.5, -2.39, 93054, 156);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(8965, "MCB", "REG", "OPN", "", 401, 200.76, 200.9, 180, 200.5, 200, "09:40:08", 202.89, "-", 201.74, 203, 200.5, -2.39, 93054, 156);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(8991, "MCB", "REG", "OPN", "", 500, 200.77, 200.9, 180, 200.5, 200, "09:40:08", 202.89, "-", 201.74, 203, 200.5, -2.39, 93054, 156);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(9023, "MCB", "REG", "OPN", "", 500, 200.77, 200.9, 130, 200.9, 50, "09:42:23", 202.89, "+", 201.74, 203, 200.5, -1.99, 93104, 157);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(9035, "MCB", "REG", "OPN", "", 401, 200.76, 200.9, 130, 200.77, 500, "09:42:25", 202.89, "-", 201.73, 203, 200.5, -2.12, 93604, 158);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(9059, "MCB", "REG", "OPN", "", 2, 200.75, 200.9, 130, 200.77, 500, "09:42:25", 202.89, "-", 201.73, 203, 200.5, -2.12, 93604, 158);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(9084, "MCB", "REG", "OPN", "", 2002, 200.75, 200.9, 130, 200.77, 500, "09:42:25", 202.89, "-", 201.73, 203, 200.5, -2.12, 93604, 158);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(9096, "MCB", "REG", "OPN", "", 401, 200.76, 200.9, 130, 200.77, 500, "09:42:25", 202.89, "-", 201.73, 203, 200.5, -2.12, 93604, 158);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(9104, "MCB", "REG", "OPN", "", 271, 200.9, 201.24, 357, 200.9, 130, "09:42:41", 202.89, "+", 201.73, 203, 200.5, -1.99, 93734, 159);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(9129, "MCB", "REG", "OPN", "", 1000, 201, 201.24, 357, 200.9, 130, "09:42:41", 202.89, "+", 201.73, 203, 200.5, -1.99, 93734, 159);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(9167, "MCB", "REG", "OPN", "", 1000, 201, 201.2, 250, 200.9, 130, "09:42:41", 202.89, "+", 201.73, 203, 200.5, -1.99, 93734, 159);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(9234, "MCB", "REG", "OPN", "", 271, 200.9, 201.2, 250, 200.9, 130, "09:42:41", 202.89, "+", 201.73, 203, 200.5, -1.99, 93734, 159);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(9265, "MCB", "REG", "OPN", "", 271, 200.9, 201, 1000, 200.9, 130, "09:42:41", 202.89, "+", 201.73, 203, 200.5, -1.99, 93734, 159);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(9366, "MCB", "REG", "OPN", "", 171, 200.9, 201, 1000, 200.9, 100, "09:43:53", 202.89, "+", 201.73, 203, 200.5, -1.99, 93834, 160);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(9377, "MCB", "REG", "OPN", "", 171, 200.9, 201, 500, 201, 500, "09:43:56", 202.89, "+", 201.73, 203, 200.5, -1.89, 94334, 161);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(9388, "MCB", "REG", "OPN", "", 1000, 200.77, 200.9, 69, 200.9, 171, "09:43:59", 202.89, "-", 201.73, 203, 200.5, -1.99, 94505, 162);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(9470, "MCB", "REG", "OPN", "", 500, 200.77, 200.9, 69, 200.77, 500, "09:44:20", 202.89, "-", 201.72, 203, 200.5, -2.12, 95005, 163);

insert into z_livefeedlocal
(rowid, symbol_code, market_code, symbol_state, symbol_flag, bid_volume, bid_price, ask_price, ask_volume, last_trade_price, last_trade_volume, last_trade_time, last_day_close_price, symbol_direction, average_price, high_price, low_price, net_change, total_traded_volume, total_trades)
VALUES
(9480, "MCB", "REG", "OPN", "", 500, 200.77, 200.89, 357, 200.77, 500, "09:44:20", 202.89, "-", 201.72, 203, 200.5, -2.12, 95005, 163);


#####################################################################
select z.open, if(z.open='NoValue','NoValue',z.high) high, if(z.open='NoValue','NoValue',z.low) low, if (z.open='NoValue','NoValue',s.last_trade_price) close, z.last_trade_volume turnover, z.varhour `Hour`,z.varmin `Min` from z_livefeedlocal s, ( select z_livefeedlocal.rowid, '2010-03-02' date, max(z_livefeedlocal.rowid) max_live_rowid, z_livefeedlocal.last_trade_price open, min(z_livefeedlocal.last_trade_price) low, max(z_livefeedlocal.last_trade_price) high, time_format(z_livefeedlocal.last_trade_time,'%H') as varhour, truncate(time_format(z_livefeedlocal.last_trade_time,'%i')/3,0)*3 as varmin, sum(z_livefeedlocal.last_trade_volume) last_trade_volume from z_livefeedlocal where z_livefeedlocal.last_trade_volume <> 0 and z_livefeedlocal.symbol_code= "MCB" and z_livefeedlocal.market_code = 'REG' group by varhour, varmin order by date, varhour, varmin ) z where (s.rowid = z.max_live_rowid) group by date, varhour, varmin;







Problem i m having over here

truncate(time_format(z_livefeedlocal.last_trade_time,'%i')/5,0)*5 as varmin,

webfred
Master Smack Fu Yak Hacker

8781 Posts
Posted - 2010-05-21 : 04:15:26
quote:
Problem i m having over here

truncate(time_format(z_livefeedlocal.last_trade_time,'%i')/5,0)*5 as varmin,

Can you give an example what's going in and what's coming out?

No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

farhanqureshi007
Starting Member

5 Posts
Posted - 2010-05-21 : 04:26:21
i have posted the mysql table structure and Sample data..
basically what mysql query do is format the time and break it in groups

like wise from 09:15 to 09:30 as 09 as hour and 15 as min
take open high low close form fields and then again
09:30 to 09:45 and take open high low and close etc.......
its better that u create a mysql table and insert data which i have provided u in previous post and run the query
i will be thanks full for you to take ur precious time for me
Go to Top of Page

webfred
Master Smack Fu Yak Hacker

8781 Posts
Posted - 2010-05-21 : 04:42:01
Now we are one step ahead because we know input and desired output.

select
truncate(time_format('09:44:20','%i')/5,0)*5 as a,
truncate(time_format('09:46:20','%i')/5,0)*5 as b

results in

a  b  
40 45


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

webfred
Master Smack Fu Yak Hacker

8781 Posts
Posted - 2010-05-21 : 04:44:48
Next we need to know, how the information like 09:44:20 is stored in SQL Server.
Version = 2005?
Data type of that column?

No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

farhanqureshi007
Starting Member

5 Posts
Posted - 2010-05-21 : 05:57:29
i got the following error

Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'truncate'.


and column can be varchar datetime what ever u will suggest to me but i will ask u once again take some of ur precious time and run this mysql query at your end u will be clear might i m not able to tell u my problem :)
Go to Top of Page

webfred
Master Smack Fu Yak Hacker

8781 Posts
Posted - 2010-05-21 : 07:18:20
Your table in MS SQL Server database should have the column last_trade_time of datatype varchar(10).
Instead of this truncate(time_format(z_livefeedlocal.last_trade_time,'%i')/5,0)*5 as varmin
you can do this in SQL Server 2005:
(convert(int,parsename(replace(@test,':','.'),2))/5)*5 as varmin

For a test please run this in SQL Server:
declare @test varchar(10)
set @test='09:44:22'

select @test,(convert(int,parsename(replace(@test,':','.'),2))/5)*5

set @test='09:46:22'

select @test,(convert(int,parsename(replace(@test,':','.'),2))/5)*5


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

farhanqureshi007
Starting Member

5 Posts
Posted - 2010-05-22 : 03:19:19
man u r champ
:)

Thanks a lot GOD bless you
Go to Top of Page

webfred
Master Smack Fu Yak Hacker

8781 Posts
Posted - 2010-05-22 : 06:25:14
welcome

No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site