PREVIEW / stock_5min / 2009-01-23
file: by_date/stock_5min/2009/2009-01-23.parquet size: 4.4 MB rows: 306,797 symbols: 3,312
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-01-23 04:20:00 | AAPL | Stock | 3.1161 | 3.1161 | 3.1161 | 3.1161 | 11480.0 |
| 2009-01-23 04:30:00 | AAPL | Stock | 3.1071 | 3.1071 | 3.1071 | 3.1071 | 5600.0 |
| 2009-01-23 06:55:00 | AAPL | Stock | 3.1018 | 3.1018 | 3.1018 | 3.1018 | 5600.0 |
| 2009-01-23 07:00:00 | AAPL | Stock | 3.1071 | 3.1071 | 3.1071 | 3.1071 | 9772.0 |
| 2009-01-23 07:45:00 | AAPL | Stock | 3.1079 | 3.1143 | 3.1071 | 3.1143 | 96600.0 |
| 2009-01-23 07:50:00 | AAPL | Stock | 3.1143 | 3.1214 | 3.1143 | 3.1214 | 18368.0 |
| 2009-01-23 07:55:00 | AAPL | Stock | 3.1075 | 3.1075 | 3.1075 | 3.1075 | 5600.0 |
| 2009-01-23 08:00:00 | AAPL | Stock | 3.1079 | 3.1264 | 3.1079 | 3.1164 | 121940.0 |
| 2009-01-23 08:05:00 | AAPL | Stock | 3.1161 | 3.1168 | 3.1125 | 3.1168 | 73360.0 |
| 2009-01-23 08:10:00 | AAPL | Stock | 3.1168 | 3.1179 | 3.1161 | 3.1179 | 20720.0 |
| 2009-01-23 08:15:00 | AAPL | Stock | 3.1182 | 3.1193 | 3.1175 | 3.1175 | 48300.0 |
| 2009-01-23 08:20:00 | AAPL | Stock | 3.1175 | 3.1175 | 3.1161 | 3.1161 | 64232.0 |
| 2009-01-23 08:25:00 | AAPL | Stock | 3.1161 | 3.1161 | 3.1125 | 3.1125 | 121380.0 |
| 2009-01-23 08:30:00 | AAPL | Stock | 3.1132 | 3.1132 | 3.1036 | 3.1036 | 305592.0 |
| 2009-01-23 08:35:00 | AAPL | Stock | 3.1018 | 3.1018 | 3.0893 | 3.0936 | 415016.0 |
| 2009-01-23 08:40:00 | AAPL | Stock | 3.0964 | 3.0979 | 3.0896 | 3.0979 | 275996.0 |
| 2009-01-23 08:45:00 | AAPL | Stock | 3.1036 | 3.1179 | 3.1029 | 3.1054 | 572712.0 |
| 2009-01-23 08:50:00 | AAPL | Stock | 3.1071 | 3.1139 | 3.1071 | 3.1071 | 80388.0 |
| 2009-01-23 08:55:00 | AAPL | Stock | 3.1068 | 3.1068 | 3.0932 | 3.0932 | 180600.0 |
| 2009-01-23 09:00:00 | AAPL | Stock | 3.0932 | 3.0989 | 3.0932 | 3.0982 | 236600.0 |
| 2009-01-23 09:05:00 | AAPL | Stock | 3.0982 | 3.0982 | 3.0907 | 3.0907 | 188048.0 |
| 2009-01-23 09:10:00 | AAPL | Stock | 3.0907 | 3.0982 | 3.0907 | 3.0946 | 208656.0 |
| 2009-01-23 09:15:00 | AAPL | Stock | 3.0946 | 3.1054 | 3.0946 | 3.1018 | 230160.0 |
| 2009-01-23 09:20:00 | AAPL | Stock | 3.1018 | 3.1039 | 3.1014 | 3.1014 | 142800.0 |
| 2009-01-23 09:25:00 | AAPL | Stock | 3.1007 | 3.1054 | 3.0986 | 3.1014 | 409584.0 |
| 2009-01-23 09:30:00 | AAPL | Stock | 3.1007 | 3.1332 | 3.0982 | 3.1214 | 24693004.0 |
| 2009-01-23 09:35:00 | AAPL | Stock | 3.1211 | 3.1382 | 3.1071 | 3.115 | 25539080.0 |
| 2009-01-23 09:40:00 | AAPL | Stock | 3.1157 | 3.1311 | 3.0964 | 3.1047 | 21848736.0 |
| 2009-01-23 09:45:00 | AAPL | Stock | 3.1057 | 3.1136 | 3.09 | 3.1064 | 14337484.0 |
| 2009-01-23 09:50:00 | AAPL | Stock | 3.1064 | 3.125 | 3.0993 | 3.1186 | 16510032.0 |
| 2009-01-23 09:55:00 | AAPL | Stock | 3.1182 | 3.1193 | 3.0893 | 3.0896 | 15791468.0 |
| 2009-01-23 10:00:00 | AAPL | Stock | 3.0911 | 3.1214 | 3.0896 | 3.1104 | 15480640.0 |
| 2009-01-23 10:05:00 | AAPL | Stock | 3.1104 | 3.1173 | 3.0986 | 3.1132 | 10687376.0 |
| 2009-01-23 10:10:00 | AAPL | Stock | 3.1129 | 3.1282 | 3.1036 | 3.1236 | 10492972.0 |
| 2009-01-23 10:15:00 | AAPL | Stock | 3.1243 | 3.1371 | 3.1236 | 3.1318 | 10982972.0 |
| 2009-01-23 10:20:00 | AAPL | Stock | 3.1318 | 3.1375 | 3.1214 | 3.1368 | 8869868.0 |
| 2009-01-23 10:25:00 | AAPL | Stock | 3.1371 | 3.1429 | 3.135 | 3.1396 | 12854296.0 |
| 2009-01-23 10:30:00 | AAPL | Stock | 3.1396 | 3.1429 | 3.1304 | 3.1361 | 11522756.0 |
| 2009-01-23 10:35:00 | AAPL | Stock | 3.1368 | 3.1429 | 3.1343 | 3.135 | 8138088.0 |
| 2009-01-23 10:40:00 | AAPL | Stock | 3.135 | 3.1357 | 3.1268 | 3.1279 | 6956320.0 |
| 2009-01-23 10:45:00 | AAPL | Stock | 3.1275 | 3.1311 | 3.1179 | 3.1243 | 7254352.0 |
| 2009-01-23 10:50:00 | AAPL | Stock | 3.1246 | 3.1339 | 3.1236 | 3.13 | 4931780.0 |
| 2009-01-23 10:55:00 | AAPL | Stock | 3.1304 | 3.1339 | 3.1179 | 3.1189 | 4784080.0 |
| 2009-01-23 11:00:00 | AAPL | Stock | 3.1189 | 3.1429 | 3.1189 | 3.1418 | 9342928.0 |
| 2009-01-23 11:05:00 | AAPL | Stock | 3.1418 | 3.1554 | 3.1371 | 3.1554 | 16397276.0 |
| 2009-01-23 11:10:00 | AAPL | Stock | 3.1554 | 3.1554 | 3.1375 | 3.1446 | 14940520.0 |
| 2009-01-23 11:15:00 | AAPL | Stock | 3.1443 | 3.15 | 3.1396 | 3.1441 | 10330068.0 |
| 2009-01-23 11:20:00 | AAPL | Stock | 3.1443 | 3.1561 | 3.1443 | 3.1511 | 12218304.0 |
| 2009-01-23 11:25:00 | AAPL | Stock | 3.1511 | 3.155 | 3.1446 | 3.1539 | 7179452.0 |
| 2009-01-23 11:30:00 | AAPL | Stock | 3.1532 | 3.1664 | 3.1446 | 3.1507 | 14002268.0 |
> showing 50 of 306,797 rows — these rows as CSV