The test data can be used as the following examples：
”
create table stock_ticker
(
closing_date dateTime,
stock_symbol string,
closing_price decimal(10, 0)
) duplicate key(closing_date)
distributed by hash(closing_date) buckets 1
properties
(
"replication_num"="1"
);

insert into stock_ticker values
('2014-10-02 00:00:00','JDR',12.86),
('2014-10-03 00:00:00','JDR',12.89),
('2014-10-04 00:00:00','JDR',12.94),
('2014-10-05 00:00:00','JDR',12.55),
('2014-10-06 00:00:00','JDR',14.03),
('2014-10-07 00:00:00','JDR',14.75),
('2014-10-08 00:00:00','JDR',13.98),
('2014-10-08 00:00:00','TTD',16.98),
('2014-10-06 00:00:00','TTD',13.98),
('2014-10-07 00:00:00','TTD',12.98);

select * from stock_ticker;
“

Thank you for the contribution, will review it then merge it ASAP