PREVIEW / stock_5min / 2010-09-03
file: by_date/stock_5min/2010/2010-09-03.parquet size: 4.6 MB rows: 317,475 symbols: 3,473
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 |
|---|---|---|---|---|---|---|---|
| 2010-09-03 05:00:00 | AAPL | Stock | 9.0079 | 9.0079 | 9.0079 | 9.0079 | 2800.0 |
| 2010-09-03 07:10:00 | AAPL | Stock | 8.9754 | 8.9754 | 8.9643 | 8.9643 | 26880.0 |
| 2010-09-03 07:15:00 | AAPL | Stock | 8.9696 | 8.9718 | 8.9554 | 8.9718 | 30100.0 |
| 2010-09-03 07:20:00 | AAPL | Stock | 8.9911 | 8.9911 | 8.9911 | 8.9911 | 2800.0 |
| 2010-09-03 07:30:00 | AAPL | Stock | 8.9811 | 9.0 | 8.9811 | 8.9811 | 11200.0 |
| 2010-09-03 07:35:00 | AAPL | Stock | 8.9761 | 8.9811 | 8.9761 | 8.9811 | 16800.0 |
| 2010-09-03 07:40:00 | AAPL | Stock | 8.9971 | 8.9971 | 8.9857 | 8.9957 | 36400.0 |
| 2010-09-03 07:45:00 | AAPL | Stock | 8.9879 | 8.9879 | 8.9857 | 8.9864 | 64400.0 |
| 2010-09-03 07:50:00 | AAPL | Stock | 8.995 | 8.995 | 8.995 | 8.995 | 2800.0 |
| 2010-09-03 08:00:00 | AAPL | Stock | 8.9929 | 8.9954 | 8.9857 | 8.9857 | 65128.0 |
| 2010-09-03 08:05:00 | AAPL | Stock | 8.9857 | 8.9893 | 8.9857 | 8.9893 | 41160.0 |
| 2010-09-03 08:10:00 | AAPL | Stock | 8.9911 | 8.9943 | 8.9893 | 8.9904 | 38360.0 |
| 2010-09-03 08:15:00 | AAPL | Stock | 8.9943 | 9.0007 | 8.9939 | 8.9964 | 190876.0 |
| 2010-09-03 08:20:00 | AAPL | Stock | 8.9989 | 9.0 | 8.9954 | 8.9986 | 170716.0 |
| 2010-09-03 08:25:00 | AAPL | Stock | 8.9979 | 9.005 | 8.9829 | 8.9829 | 260428.0 |
| 2010-09-03 08:30:00 | AAPL | Stock | 8.9829 | 9.1032 | 8.9829 | 9.0893 | 2988720.0 |
| 2010-09-03 08:35:00 | AAPL | Stock | 9.0925 | 9.0925 | 9.0786 | 9.0871 | 1213044.0 |
| 2010-09-03 08:40:00 | AAPL | Stock | 9.0911 | 9.1182 | 9.0896 | 9.1182 | 1958068.0 |
| 2010-09-03 08:45:00 | AAPL | Stock | 9.1179 | 9.1239 | 9.1118 | 9.1221 | 1175524.0 |
| 2010-09-03 08:50:00 | AAPL | Stock | 9.1225 | 9.1304 | 9.1168 | 9.1261 | 1491168.0 |
| 2010-09-03 08:55:00 | AAPL | Stock | 9.1264 | 9.1268 | 9.1189 | 9.125 | 848932.0 |
| 2010-09-03 09:00:00 | AAPL | Stock | 9.125 | 9.1268 | 9.1171 | 9.1232 | 728588.0 |
| 2010-09-03 09:05:00 | AAPL | Stock | 9.1239 | 9.1261 | 9.1218 | 9.1221 | 482524.0 |
| 2010-09-03 09:10:00 | AAPL | Stock | 9.1232 | 9.1232 | 9.1161 | 9.1164 | 550676.0 |
| 2010-09-03 09:15:00 | AAPL | Stock | 9.1161 | 9.1261 | 9.1161 | 9.1214 | 469168.0 |
| 2010-09-03 09:20:00 | AAPL | Stock | 9.12 | 9.1214 | 9.1175 | 9.1175 | 132160.0 |
| 2010-09-03 09:25:00 | AAPL | Stock | 9.1179 | 9.1193 | 9.1071 | 9.1129 | 1086120.0 |
| 2010-09-03 09:30:00 | AAPL | Stock | 9.11 | 9.1154 | 9.0893 | 9.0992 | 26794628.0 |
| 2010-09-03 09:35:00 | AAPL | Stock | 9.0993 | 9.125 | 9.0989 | 9.1225 | 15402156.0 |
| 2010-09-03 09:40:00 | AAPL | Stock | 9.1236 | 9.1411 | 9.1196 | 9.1407 | 18015816.0 |
| 2010-09-03 09:45:00 | AAPL | Stock | 9.1407 | 9.1421 | 9.1272 | 9.1364 | 10613176.0 |
| 2010-09-03 09:50:00 | AAPL | Stock | 9.1371 | 9.1689 | 9.1354 | 9.1682 | 15057420.0 |
| 2010-09-03 09:55:00 | AAPL | Stock | 9.1686 | 9.1929 | 9.1671 | 9.1811 | 18656036.0 |
| 2010-09-03 10:00:00 | AAPL | Stock | 9.1777 | 9.1857 | 9.15 | 9.1775 | 14796936.0 |
| 2010-09-03 10:05:00 | AAPL | Stock | 9.1768 | 9.1768 | 9.1461 | 9.1568 | 10250716.0 |
| 2010-09-03 10:10:00 | AAPL | Stock | 9.1568 | 9.1643 | 9.1389 | 9.1407 | 9472568.0 |
| 2010-09-03 10:15:00 | AAPL | Stock | 9.1396 | 9.1554 | 9.1304 | 9.1461 | 9126796.0 |
| 2010-09-03 10:20:00 | AAPL | Stock | 9.1479 | 9.1561 | 9.1364 | 9.1373 | 6156276.0 |
| 2010-09-03 10:25:00 | AAPL | Stock | 9.1367 | 9.1414 | 9.1071 | 9.1118 | 10086440.0 |
| 2010-09-03 10:30:00 | AAPL | Stock | 9.1139 | 9.1139 | 9.0954 | 9.1036 | 8553748.0 |
| 2010-09-03 10:35:00 | AAPL | Stock | 9.1039 | 9.1161 | 9.099 | 9.1118 | 7214312.0 |
| 2010-09-03 10:40:00 | AAPL | Stock | 9.1125 | 9.1221 | 9.1096 | 9.1168 | 5763940.0 |
| 2010-09-03 10:45:00 | AAPL | Stock | 9.1179 | 9.1214 | 9.1099 | 9.1139 | 3903928.0 |
| 2010-09-03 10:50:00 | AAPL | Stock | 9.1136 | 9.1139 | 9.0975 | 9.1018 | 4770024.0 |
| 2010-09-03 10:55:00 | AAPL | Stock | 9.1016 | 9.1143 | 9.0964 | 9.1138 | 5515748.0 |
| 2010-09-03 11:00:00 | AAPL | Stock | 9.1129 | 9.1132 | 9.1004 | 9.1121 | 3551520.0 |
| 2010-09-03 11:05:00 | AAPL | Stock | 9.1111 | 9.1189 | 9.1086 | 9.1125 | 4345768.0 |
| 2010-09-03 11:10:00 | AAPL | Stock | 9.1125 | 9.1214 | 9.1018 | 9.1213 | 3450720.0 |
| 2010-09-03 11:15:00 | AAPL | Stock | 9.1193 | 9.1271 | 9.1157 | 9.1239 | 4158980.0 |
| 2010-09-03 11:20:00 | AAPL | Stock | 9.125 | 9.1304 | 9.1171 | 9.1289 | 3300164.0 |
> showing 50 of 317,475 rows — these rows as CSV