MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();


version()


8.0.27


CREATE TABLE Trades (
    trade_time datetime(3)  NOT NULL PRIMARY KEY,
    price      NUMERIC(7,2) NOT NULL
);
INSERT INTO Trades(trade_time,price) VALUES
 ('2020-01-01 00:00:01.481',7189.42)
,('2020-01-01 00:00:01.708',7189.42)
,('2020-01-01 00:00:06.290',7189.5)
,('2020-01-01 00:00:06.291',7190.52)
,('2020-01-01 00:00:07.161',7188.97)
,('2020-01-01 00:00:08.274',7189.93)
,('2020-01-01 00:00:09.277',7190.47)
,('2020-01-01 00:00:09.384',7190.47)
,('2020-01-01 00:00:09.630',7190.11)
,('2020-01-01 00:00:09.848',7189.74)
SELECT * FROM Trades


trade_time
price


2020-01-01 00:00:01.481
7189.42

2020-01-01 00:00:01.708
7189.42

2020-01-01 00:00:06.290
7189.50

2020-01-01 00:00:06.291
7190.52

2020-01-01 00:00:07.161
7188.97

2020-01-01 00:00:08.274
7189.93

2020-01-01 00:00:09.277
7190.47

2020-01-01 00:00:09.384
7190.47

2020-01-01 00:00:09.630
7190.11

2020-01-01 00:00:09.848
7189.74

trade_time	price
2020-01-01 00:00:01.481	7189.42
2020-01-01 00:00:01.708	7189.42
2020-01-01 00:00:06.290	7189.50
2020-01-01 00:00:06.291	7190.52
2020-01-01 00:00:07.161	7188.97
2020-01-01 00:00:08.274	7189.93
2020-01-01 00:00:09.277	7190.47
2020-01-01 00:00:09.384	7190.47
2020-01-01 00:00:09.630	7190.11
2020-01-01 00:00:09.848	7189.74