PREVIEW / stock_5min / 2009-08-28
file: by_date/stock_5min/2009/2009-08-28.parquet size: 4.5 MB rows: 308,185 symbols: 3,392
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-08-28 04:45:00 | AAPL | Stock | 6.1014 | 6.1014 | 6.1014 | 6.1014 | 14000.0 |
| 2009-08-28 05:15:00 | AAPL | Stock | 6.1018 | 6.1018 | 6.1018 | 6.1018 | 5600.0 |
| 2009-08-28 05:20:00 | AAPL | Stock | 6.1029 | 6.1029 | 6.1029 | 6.1029 | 14000.0 |
| 2009-08-28 05:50:00 | AAPL | Stock | 6.1071 | 6.1071 | 6.1071 | 6.1071 | 5600.0 |
| 2009-08-28 05:55:00 | AAPL | Stock | 6.1143 | 6.1143 | 6.1143 | 6.1143 | 5600.0 |
| 2009-08-28 06:15:00 | AAPL | Stock | 6.1075 | 6.1075 | 6.1075 | 6.1075 | 2800.0 |
| 2009-08-28 06:35:00 | AAPL | Stock | 6.1111 | 6.1111 | 6.1071 | 6.1071 | 14000.0 |
| 2009-08-28 07:00:00 | AAPL | Stock | 6.1246 | 6.1246 | 6.1179 | 6.1179 | 11536.0 |
| 2009-08-28 07:05:00 | AAPL | Stock | 6.1161 | 6.1214 | 6.1161 | 6.1214 | 10864.0 |
| 2009-08-28 07:10:00 | AAPL | Stock | 6.1179 | 6.1214 | 6.1161 | 6.1161 | 27440.0 |
| 2009-08-28 07:15:00 | AAPL | Stock | 6.1143 | 6.1143 | 6.1143 | 6.1143 | 14000.0 |
| 2009-08-28 07:20:00 | AAPL | Stock | 6.1211 | 6.1211 | 6.1193 | 6.1193 | 8400.0 |
| 2009-08-28 07:25:00 | AAPL | Stock | 6.1179 | 6.1179 | 6.1179 | 6.1179 | 2800.0 |
| 2009-08-28 07:30:00 | AAPL | Stock | 6.1196 | 6.1196 | 6.1164 | 6.1164 | 47600.0 |
| 2009-08-28 07:35:00 | AAPL | Stock | 6.1164 | 6.1168 | 6.1164 | 6.1164 | 39200.0 |
| 2009-08-28 07:40:00 | AAPL | Stock | 6.1107 | 6.1107 | 6.1107 | 6.1107 | 28000.0 |
| 2009-08-28 07:45:00 | AAPL | Stock | 6.1107 | 6.1107 | 6.1107 | 6.1107 | 14560.0 |
| 2009-08-28 07:50:00 | AAPL | Stock | 6.1107 | 6.1214 | 6.1107 | 6.1214 | 114380.0 |
| 2009-08-28 07:55:00 | AAPL | Stock | 6.1179 | 6.1232 | 6.1179 | 6.1207 | 239400.0 |
| 2009-08-28 08:00:00 | AAPL | Stock | 6.1179 | 6.1239 | 6.1179 | 6.1232 | 635264.0 |
| 2009-08-28 08:05:00 | AAPL | Stock | 6.1232 | 6.1268 | 6.1232 | 6.125 | 285516.0 |
| 2009-08-28 08:10:00 | AAPL | Stock | 6.1254 | 6.1282 | 6.125 | 6.1282 | 446208.0 |
| 2009-08-28 08:15:00 | AAPL | Stock | 6.1282 | 6.1318 | 6.1282 | 6.1311 | 370860.0 |
| 2009-08-28 08:20:00 | AAPL | Stock | 6.1296 | 6.1339 | 6.1286 | 6.1339 | 241024.0 |
| 2009-08-28 08:25:00 | AAPL | Stock | 6.1346 | 6.1389 | 6.1346 | 6.1364 | 167580.0 |
| 2009-08-28 08:30:00 | AAPL | Stock | 6.1364 | 6.1393 | 6.1339 | 6.1343 | 435960.0 |
| 2009-08-28 08:35:00 | AAPL | Stock | 6.1354 | 6.1393 | 6.1343 | 6.1382 | 540484.0 |
| 2009-08-28 08:40:00 | AAPL | Stock | 6.1375 | 6.1379 | 6.1339 | 6.1343 | 611604.0 |
| 2009-08-28 08:45:00 | AAPL | Stock | 6.1361 | 6.1364 | 6.1332 | 6.135 | 457100.0 |
| 2009-08-28 08:50:00 | AAPL | Stock | 6.1329 | 6.1382 | 6.1307 | 6.1357 | 430220.0 |
| 2009-08-28 08:55:00 | AAPL | Stock | 6.1346 | 6.1393 | 6.1314 | 6.1329 | 568288.0 |
| 2009-08-28 09:00:00 | AAPL | Stock | 6.1325 | 6.16 | 6.13 | 6.1557 | 1331568.0 |
| 2009-08-28 09:05:00 | AAPL | Stock | 6.155 | 6.1564 | 6.15 | 6.1521 | 533120.0 |
| 2009-08-28 09:10:00 | AAPL | Stock | 6.1525 | 6.1571 | 6.1518 | 6.1571 | 536228.0 |
| 2009-08-28 09:15:00 | AAPL | Stock | 6.1568 | 6.1696 | 6.1568 | 6.1646 | 1086148.0 |
| 2009-08-28 09:20:00 | AAPL | Stock | 6.1661 | 6.1686 | 6.1629 | 6.1675 | 455336.0 |
| 2009-08-28 09:25:00 | AAPL | Stock | 6.1646 | 6.1675 | 6.1446 | 6.1493 | 1952636.0 |
| 2009-08-28 09:30:00 | AAPL | Stock | 6.1525 | 6.1604 | 6.1321 | 6.1439 | 28052808.0 |
| 2009-08-28 09:35:00 | AAPL | Stock | 6.1442 | 6.15 | 6.1193 | 6.1211 | 18428816.0 |
| 2009-08-28 09:40:00 | AAPL | Stock | 6.1196 | 6.1214 | 6.0629 | 6.0805 | 30856448.0 |
| 2009-08-28 09:45:00 | AAPL | Stock | 6.0804 | 6.09 | 6.0682 | 6.0862 | 13054440.0 |
| 2009-08-28 09:50:00 | AAPL | Stock | 6.0868 | 6.1136 | 6.0864 | 6.095 | 16299220.0 |
| 2009-08-28 09:55:00 | AAPL | Stock | 6.0946 | 6.1071 | 6.0743 | 6.0782 | 11826444.0 |
| 2009-08-28 10:00:00 | AAPL | Stock | 6.0786 | 6.0886 | 6.0682 | 6.0856 | 11059720.0 |
| 2009-08-28 10:05:00 | AAPL | Stock | 6.0854 | 6.0911 | 6.0682 | 6.0868 | 8300600.0 |
| 2009-08-28 10:10:00 | AAPL | Stock | 6.085 | 6.0993 | 6.0761 | 6.0811 | 5856088.0 |
| 2009-08-28 10:15:00 | AAPL | Stock | 6.0811 | 6.0939 | 6.0793 | 6.0871 | 3860472.0 |
| 2009-08-28 10:20:00 | AAPL | Stock | 6.0886 | 6.0886 | 6.0714 | 6.0732 | 6746544.0 |
| 2009-08-28 10:25:00 | AAPL | Stock | 6.0732 | 6.0839 | 6.0586 | 6.0634 | 7183848.0 |
| 2009-08-28 10:30:00 | AAPL | Stock | 6.0646 | 6.07 | 6.0539 | 6.0679 | 6558888.0 |
> showing 50 of 308,185 rows — these rows as CSV