PREVIEW / stock_5min / 2004-02-09
file: by_date/stock_5min/2004/2004-02-09.parquet size: 2.4 MB rows: 170,196 symbols: 1,715
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2004-02-09 08:40:00 | AAPL | Stock | 0.4027 | 0.4027 | 0.4027 | 0.4027 | 16800.0 |
| 2004-02-09 09:05:00 | AAPL | Stock | 0.4055 | 0.4055 | 0.4046 | 0.4046 | 3774400.0 |
| 2004-02-09 09:10:00 | AAPL | Stock | 0.4046 | 0.4046 | 0.4046 | 0.4046 | 56000.0 |
| 2004-02-09 09:20:00 | AAPL | Stock | 0.4048 | 0.4048 | 0.4038 | 0.4039 | 67200.0 |
| 2004-02-09 09:25:00 | AAPL | Stock | 0.4038 | 0.4063 | 0.4036 | 0.4039 | 672000.0 |
| 2004-02-09 09:30:00 | AAPL | Stock | 0.4039 | 0.407 | 0.4029 | 0.4032 | 5164320.0 |
| 2004-02-09 09:35:00 | AAPL | Stock | 0.4032 | 0.405 | 0.4025 | 0.4025 | 3799992.0 |
| 2004-02-09 09:40:00 | AAPL | Stock | 0.4025 | 0.4034 | 0.402 | 0.4029 | 1971816.0 |
| 2004-02-09 09:45:00 | AAPL | Stock | 0.4029 | 0.4036 | 0.4018 | 0.4027 | 1803256.0 |
| 2004-02-09 09:50:00 | AAPL | Stock | 0.4029 | 0.4029 | 0.402 | 0.4023 | 975632.0 |
| 2004-02-09 09:55:00 | AAPL | Stock | 0.4021 | 0.4036 | 0.4021 | 0.4031 | 1508920.0 |
| 2004-02-09 10:00:00 | AAPL | Stock | 0.4032 | 0.4041 | 0.4025 | 0.4036 | 1441608.0 |
| 2004-02-09 10:05:00 | AAPL | Stock | 0.4036 | 0.4039 | 0.4027 | 0.4034 | 1345792.0 |
| 2004-02-09 10:10:00 | AAPL | Stock | 0.4034 | 0.4043 | 0.4029 | 0.4043 | 890400.0 |
| 2004-02-09 10:15:00 | AAPL | Stock | 0.4039 | 0.4046 | 0.4034 | 0.4038 | 1930936.0 |
| 2004-02-09 10:20:00 | AAPL | Stock | 0.4038 | 0.4054 | 0.4037 | 0.4054 | 1189328.0 |
| 2004-02-09 10:25:00 | AAPL | Stock | 0.4052 | 0.4055 | 0.4043 | 0.4055 | 2117248.0 |
| 2004-02-09 10:30:00 | AAPL | Stock | 0.4055 | 0.4071 | 0.4055 | 0.407 | 3862992.0 |
| 2004-02-09 10:35:00 | AAPL | Stock | 0.407 | 0.4071 | 0.4066 | 0.4068 | 12425784.0 |
| 2004-02-09 10:40:00 | AAPL | Stock | 0.4069 | 0.4069 | 0.4064 | 0.4066 | 603008.0 |
| 2004-02-09 10:45:00 | AAPL | Stock | 0.4068 | 0.4082 | 0.4068 | 0.4079 | 2565304.0 |
| 2004-02-09 10:50:00 | AAPL | Stock | 0.4079 | 0.408 | 0.4075 | 0.4079 | 916832.0 |
| 2004-02-09 10:55:00 | AAPL | Stock | 0.4078 | 0.4079 | 0.4059 | 0.4059 | 1429176.0 |
| 2004-02-09 11:00:00 | AAPL | Stock | 0.4063 | 0.4063 | 0.4057 | 0.4059 | 1368416.0 |
| 2004-02-09 11:05:00 | AAPL | Stock | 0.4057 | 0.4059 | 0.405 | 0.4055 | 1618512.0 |
| 2004-02-09 11:10:00 | AAPL | Stock | 0.4054 | 0.4054 | 0.405 | 0.405 | 676480.0 |
| 2004-02-09 11:15:00 | AAPL | Stock | 0.4052 | 0.4052 | 0.4041 | 0.4043 | 3628744.0 |
| 2004-02-09 11:20:00 | AAPL | Stock | 0.4043 | 0.4051 | 0.4039 | 0.405 | 2418696.0 |
| 2004-02-09 11:25:00 | AAPL | Stock | 0.4048 | 0.4052 | 0.4048 | 0.405 | 5173280.0 |
| 2004-02-09 11:30:00 | AAPL | Stock | 0.4048 | 0.4052 | 0.4048 | 0.4052 | 1305584.0 |
| 2004-02-09 11:35:00 | AAPL | Stock | 0.405 | 0.4052 | 0.405 | 0.4052 | 1464624.0 |
| 2004-02-09 11:40:00 | AAPL | Stock | 0.4052 | 0.4052 | 0.405 | 0.4052 | 1523312.0 |
| 2004-02-09 11:45:00 | AAPL | Stock | 0.4052 | 0.4054 | 0.405 | 0.4054 | 366632.0 |
| 2004-02-09 11:50:00 | AAPL | Stock | 0.4052 | 0.4054 | 0.4045 | 0.4045 | 1988336.0 |
| 2004-02-09 11:55:00 | AAPL | Stock | 0.4043 | 0.4044 | 0.4034 | 0.4039 | 2883776.0 |
| 2004-02-09 12:00:00 | AAPL | Stock | 0.4038 | 0.4045 | 0.4036 | 0.4045 | 1572704.0 |
| 2004-02-09 12:05:00 | AAPL | Stock | 0.4045 | 0.4046 | 0.4038 | 0.4039 | 1822744.0 |
| 2004-02-09 12:10:00 | AAPL | Stock | 0.4039 | 0.4054 | 0.4039 | 0.4048 | 1277304.0 |
| 2004-02-09 12:15:00 | AAPL | Stock | 0.4046 | 0.4048 | 0.4041 | 0.4046 | 792624.0 |
| 2004-02-09 12:20:00 | AAPL | Stock | 0.4045 | 0.4046 | 0.4044 | 0.4045 | 255640.0 |
| 2004-02-09 12:25:00 | AAPL | Stock | 0.4045 | 0.4046 | 0.4039 | 0.4045 | 1169280.0 |
| 2004-02-09 12:30:00 | AAPL | Stock | 0.4045 | 0.4052 | 0.4045 | 0.4046 | 1717240.0 |
| 2004-02-09 12:35:00 | AAPL | Stock | 0.4045 | 0.4046 | 0.4043 | 0.4046 | 608496.0 |
| 2004-02-09 12:40:00 | AAPL | Stock | 0.4046 | 0.405 | 0.4046 | 0.4046 | 647640.0 |
| 2004-02-09 12:45:00 | AAPL | Stock | 0.4046 | 0.4048 | 0.4039 | 0.4041 | 923664.0 |
| 2004-02-09 12:50:00 | AAPL | Stock | 0.4038 | 0.4046 | 0.4038 | 0.4043 | 269136.0 |
| 2004-02-09 12:55:00 | AAPL | Stock | 0.4043 | 0.4046 | 0.4041 | 0.4045 | 782432.0 |
| 2004-02-09 13:00:00 | AAPL | Stock | 0.4046 | 0.405 | 0.4045 | 0.4048 | 314384.0 |
| 2004-02-09 13:05:00 | AAPL | Stock | 0.4046 | 0.4054 | 0.4046 | 0.4052 | 909272.0 |
| 2004-02-09 13:10:00 | AAPL | Stock | 0.4052 | 0.4059 | 0.4052 | 0.4057 | 1410416.0 |
> showing 50 of 170,196 rows — these rows as CSV