PREVIEW / stock_5min / 2009-11-27
file: by_date/stock_5min/2009/2009-11-27.parquet size: 2.7 MB rows: 178,397 symbols: 3,333
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 |
|---|---|---|---|---|---|---|---|
| 2009-11-27 04:15:00 | AAPL | Stock | 7.0707 | 7.1161 | 7.0707 | 7.0718 | 42000.0 |
| 2009-11-27 04:55:00 | AAPL | Stock | 7.1025 | 7.1025 | 7.1025 | 7.1025 | 11200.0 |
| 2009-11-27 05:05:00 | AAPL | Stock | 7.0596 | 7.0596 | 7.0532 | 7.0532 | 8400.0 |
| 2009-11-27 05:10:00 | AAPL | Stock | 7.0364 | 7.0364 | 7.0361 | 7.0361 | 11200.0 |
| 2009-11-27 05:15:00 | AAPL | Stock | 7.0361 | 7.0361 | 7.0361 | 7.0361 | 18200.0 |
| 2009-11-27 05:20:00 | AAPL | Stock | 7.0361 | 7.0361 | 7.0361 | 7.0361 | 64400.0 |
| 2009-11-27 05:40:00 | AAPL | Stock | 7.0336 | 7.0336 | 7.0336 | 7.0336 | 2800.0 |
| 2009-11-27 06:30:00 | AAPL | Stock | 7.0514 | 7.0514 | 7.0514 | 7.0514 | 2800.0 |
| 2009-11-27 06:35:00 | AAPL | Stock | 7.0571 | 7.0714 | 7.0571 | 7.0714 | 42000.0 |
| 2009-11-27 06:40:00 | AAPL | Stock | 7.0768 | 7.0768 | 7.0714 | 7.0714 | 5600.0 |
| 2009-11-27 06:55:00 | AAPL | Stock | 7.0775 | 7.0775 | 7.0721 | 7.0732 | 87892.0 |
| 2009-11-27 07:00:00 | AAPL | Stock | 7.0736 | 7.0914 | 7.0736 | 7.0754 | 82012.0 |
| 2009-11-27 07:05:00 | AAPL | Stock | 7.0896 | 7.09 | 7.0771 | 7.09 | 19600.0 |
| 2009-11-27 07:10:00 | AAPL | Stock | 7.0771 | 7.0929 | 7.0771 | 7.0807 | 229600.0 |
| 2009-11-27 07:15:00 | AAPL | Stock | 7.0832 | 7.1071 | 7.0832 | 7.1071 | 57092.0 |
| 2009-11-27 07:20:00 | AAPL | Stock | 7.1111 | 7.1111 | 7.0839 | 7.0882 | 137228.0 |
| 2009-11-27 07:25:00 | AAPL | Stock | 7.0964 | 7.0964 | 7.0846 | 7.0893 | 128128.0 |
| 2009-11-27 07:30:00 | AAPL | Stock | 7.0893 | 7.0982 | 7.0893 | 7.0893 | 42000.0 |
| 2009-11-27 07:35:00 | AAPL | Stock | 7.0896 | 7.09 | 7.0757 | 7.0807 | 260792.0 |
| 2009-11-27 07:40:00 | AAPL | Stock | 7.0893 | 7.1071 | 7.0893 | 7.1071 | 45080.0 |
| 2009-11-27 07:45:00 | AAPL | Stock | 7.1064 | 7.1071 | 7.1014 | 7.1071 | 60368.0 |
| 2009-11-27 07:50:00 | AAPL | Stock | 7.1071 | 7.1125 | 7.1068 | 7.1086 | 189980.0 |
| 2009-11-27 07:55:00 | AAPL | Stock | 7.115 | 7.1154 | 7.1146 | 7.115 | 19600.0 |
| 2009-11-27 08:00:00 | AAPL | Stock | 7.115 | 7.1393 | 7.1089 | 7.1204 | 943292.0 |
| 2009-11-27 08:05:00 | AAPL | Stock | 7.1161 | 7.1318 | 7.1143 | 7.125 | 346836.0 |
| 2009-11-27 08:10:00 | AAPL | Stock | 7.1232 | 7.125 | 7.1211 | 7.1239 | 131572.0 |
| 2009-11-27 08:15:00 | AAPL | Stock | 7.1232 | 7.1411 | 7.1221 | 7.1407 | 320264.0 |
| 2009-11-27 08:20:00 | AAPL | Stock | 7.1389 | 7.1421 | 7.1339 | 7.1339 | 350672.0 |
| 2009-11-27 08:25:00 | AAPL | Stock | 7.1286 | 7.1393 | 7.1168 | 7.1321 | 466284.0 |
| 2009-11-27 08:30:00 | AAPL | Stock | 7.1286 | 7.1339 | 7.125 | 7.1339 | 154644.0 |
| 2009-11-27 08:35:00 | AAPL | Stock | 7.1279 | 7.1321 | 7.1261 | 7.1314 | 174384.0 |
| 2009-11-27 08:40:00 | AAPL | Stock | 7.1271 | 7.1318 | 7.1175 | 7.1175 | 451808.0 |
| 2009-11-27 08:45:00 | AAPL | Stock | 7.1175 | 7.125 | 7.1143 | 7.1186 | 210308.0 |
| 2009-11-27 08:50:00 | AAPL | Stock | 7.1193 | 7.125 | 7.1107 | 7.1118 | 145292.0 |
| 2009-11-27 08:55:00 | AAPL | Stock | 7.1134 | 7.1229 | 7.1036 | 7.1071 | 580328.0 |
| 2009-11-27 09:00:00 | AAPL | Stock | 7.1071 | 7.1093 | 7.1 | 7.1071 | 297416.0 |
| 2009-11-27 09:05:00 | AAPL | Stock | 7.1071 | 7.1107 | 7.1054 | 7.1089 | 156744.0 |
| 2009-11-27 09:10:00 | AAPL | Stock | 7.1089 | 7.1125 | 7.1036 | 7.1125 | 483532.0 |
| 2009-11-27 09:15:00 | AAPL | Stock | 7.1107 | 7.1132 | 7.1043 | 7.1071 | 427672.0 |
| 2009-11-27 09:20:00 | AAPL | Stock | 7.1068 | 7.1243 | 7.0982 | 7.12 | 362404.0 |
| 2009-11-27 09:25:00 | AAPL | Stock | 7.1236 | 7.1275 | 7.1118 | 7.1132 | 840112.0 |
| 2009-11-27 09:30:00 | AAPL | Stock | 7.115 | 7.1532 | 7.0846 | 7.1461 | 31577700.0 |
| 2009-11-27 09:35:00 | AAPL | Stock | 7.1457 | 7.1571 | 7.1339 | 7.1386 | 18011084.0 |
| 2009-11-27 09:40:00 | AAPL | Stock | 7.1361 | 7.1668 | 7.1325 | 7.1496 | 12648720.0 |
| 2009-11-27 09:45:00 | AAPL | Stock | 7.1482 | 7.1518 | 7.1354 | 7.1463 | 8803928.0 |
| 2009-11-27 09:50:00 | AAPL | Stock | 7.1464 | 7.155 | 7.1432 | 7.1496 | 6857312.0 |
| 2009-11-27 09:55:00 | AAPL | Stock | 7.1496 | 7.1696 | 7.1468 | 7.1582 | 8152536.0 |
| 2009-11-27 10:00:00 | AAPL | Stock | 7.1586 | 7.1782 | 7.1564 | 7.1739 | 9618812.0 |
| 2009-11-27 10:05:00 | AAPL | Stock | 7.1732 | 7.18 | 7.1625 | 7.1659 | 7799820.0 |
| 2009-11-27 10:10:00 | AAPL | Stock | 7.1661 | 7.1904 | 7.1661 | 7.1836 | 9409568.0 |
> showing 50 of 178,397 rows — these rows as CSV