PREVIEW / stock_5min / 2007-03-06
file: by_date/stock_5min/2007/2007-03-06.parquet size: 3.7 MB rows: 261,802 symbols: 2,527
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 |
|---|---|---|---|---|---|---|---|
| 2007-03-06 06:10:00 | AAPL | Stock | 3.1136 | 3.1136 | 3.1136 | 3.1136 | 5600.0 |
| 2007-03-06 06:50:00 | AAPL | Stock | 3.1271 | 3.1275 | 3.1271 | 3.1275 | 27720.0 |
| 2007-03-06 06:55:00 | AAPL | Stock | 3.1289 | 3.1289 | 3.1289 | 3.1289 | 28000.0 |
| 2007-03-06 07:00:00 | AAPL | Stock | 3.12 | 3.1282 | 3.1179 | 3.1282 | 182000.0 |
| 2007-03-06 07:05:00 | AAPL | Stock | 3.1282 | 3.1282 | 3.1232 | 3.1232 | 33600.0 |
| 2007-03-06 07:15:00 | AAPL | Stock | 3.1189 | 3.1189 | 3.1179 | 3.1179 | 14000.0 |
| 2007-03-06 07:20:00 | AAPL | Stock | 3.1264 | 3.1268 | 3.1264 | 3.1268 | 8400.0 |
| 2007-03-06 07:25:00 | AAPL | Stock | 3.125 | 3.1321 | 3.125 | 3.1321 | 347200.0 |
| 2007-03-06 07:30:00 | AAPL | Stock | 3.13 | 3.1346 | 3.13 | 3.1346 | 11200.0 |
| 2007-03-06 07:35:00 | AAPL | Stock | 3.13 | 3.1354 | 3.13 | 3.1354 | 65240.0 |
| 2007-03-06 07:40:00 | AAPL | Stock | 3.1346 | 3.1364 | 3.1321 | 3.1346 | 170800.0 |
| 2007-03-06 07:45:00 | AAPL | Stock | 3.1364 | 3.1364 | 3.13 | 3.13 | 76188.0 |
| 2007-03-06 07:50:00 | AAPL | Stock | 3.1325 | 3.1325 | 3.1268 | 3.1268 | 324800.0 |
| 2007-03-06 07:55:00 | AAPL | Stock | 3.1268 | 3.1268 | 3.1204 | 3.1204 | 75600.0 |
| 2007-03-06 08:00:00 | AAPL | Stock | 3.1282 | 3.1304 | 3.1196 | 3.1286 | 1127084.0 |
| 2007-03-06 08:05:00 | AAPL | Stock | 3.1286 | 3.1314 | 3.1279 | 3.1286 | 262640.0 |
| 2007-03-06 08:10:00 | AAPL | Stock | 3.1268 | 3.1311 | 3.125 | 3.1304 | 154756.0 |
| 2007-03-06 08:15:00 | AAPL | Stock | 3.13 | 3.1321 | 3.1268 | 3.1279 | 224700.0 |
| 2007-03-06 08:20:00 | AAPL | Stock | 3.1286 | 3.1293 | 3.1268 | 3.1286 | 284564.0 |
| 2007-03-06 08:25:00 | AAPL | Stock | 3.1293 | 3.1314 | 3.1293 | 3.13 | 102200.0 |
| 2007-03-06 08:30:00 | AAPL | Stock | 3.1286 | 3.1304 | 3.1268 | 3.1271 | 144060.0 |
| 2007-03-06 08:35:00 | AAPL | Stock | 3.1286 | 3.1286 | 3.1275 | 3.1275 | 128324.0 |
| 2007-03-06 08:40:00 | AAPL | Stock | 3.1275 | 3.1293 | 3.1254 | 3.1254 | 119812.0 |
| 2007-03-06 08:45:00 | AAPL | Stock | 3.1254 | 3.1286 | 3.1254 | 3.1271 | 150696.0 |
| 2007-03-06 08:50:00 | AAPL | Stock | 3.1275 | 3.1304 | 3.1275 | 3.1304 | 212716.0 |
| 2007-03-06 08:55:00 | AAPL | Stock | 3.13 | 3.1314 | 3.13 | 3.1304 | 296044.0 |
| 2007-03-06 09:00:00 | AAPL | Stock | 3.13 | 3.1336 | 3.13 | 3.1321 | 595644.0 |
| 2007-03-06 09:05:00 | AAPL | Stock | 3.1321 | 3.1357 | 3.1321 | 3.1329 | 478044.0 |
| 2007-03-06 09:10:00 | AAPL | Stock | 3.1321 | 3.1339 | 3.1304 | 3.1307 | 185360.0 |
| 2007-03-06 09:15:00 | AAPL | Stock | 3.1307 | 3.1321 | 3.13 | 3.1304 | 618660.0 |
| 2007-03-06 09:20:00 | AAPL | Stock | 3.1304 | 3.1325 | 3.13 | 3.1304 | 146300.0 |
| 2007-03-06 09:25:00 | AAPL | Stock | 3.1304 | 3.1357 | 3.1286 | 3.1339 | 904064.0 |
| 2007-03-06 09:30:00 | AAPL | Stock | 3.1357 | 3.1539 | 3.1339 | 3.1475 | 43925700.0 |
| 2007-03-06 09:35:00 | AAPL | Stock | 3.1489 | 3.15 | 3.1393 | 3.1396 | 18375784.0 |
| 2007-03-06 09:40:00 | AAPL | Stock | 3.1404 | 3.1454 | 3.1325 | 3.1332 | 19823832.0 |
| 2007-03-06 09:45:00 | AAPL | Stock | 3.1329 | 3.1443 | 3.1325 | 3.14 | 18908792.0 |
| 2007-03-06 09:50:00 | AAPL | Stock | 3.14 | 3.1414 | 3.1293 | 3.1375 | 18128908.0 |
| 2007-03-06 09:55:00 | AAPL | Stock | 3.1375 | 3.1421 | 3.1357 | 3.1389 | 11627084.0 |
| 2007-03-06 10:00:00 | AAPL | Stock | 3.1386 | 3.1414 | 3.1329 | 3.1382 | 13668928.0 |
| 2007-03-06 10:05:00 | AAPL | Stock | 3.1379 | 3.1411 | 3.1354 | 3.1368 | 13859104.0 |
| 2007-03-06 10:10:00 | AAPL | Stock | 3.1368 | 3.1382 | 3.1289 | 3.1343 | 17304336.0 |
| 2007-03-06 10:15:00 | AAPL | Stock | 3.1343 | 3.1375 | 3.1289 | 3.1354 | 20420568.0 |
| 2007-03-06 10:20:00 | AAPL | Stock | 3.1354 | 3.1364 | 3.1214 | 3.1268 | 16701692.0 |
| 2007-03-06 10:25:00 | AAPL | Stock | 3.1275 | 3.1339 | 3.1243 | 3.1307 | 14393512.0 |
| 2007-03-06 10:30:00 | AAPL | Stock | 3.1304 | 3.1346 | 3.1268 | 3.1282 | 10688972.0 |
| 2007-03-06 10:35:00 | AAPL | Stock | 3.1279 | 3.1321 | 3.1261 | 3.1307 | 7236460.0 |
| 2007-03-06 10:40:00 | AAPL | Stock | 3.13 | 3.1329 | 3.1254 | 3.1307 | 8815576.0 |
| 2007-03-06 10:45:00 | AAPL | Stock | 3.1304 | 3.1307 | 3.1225 | 3.1268 | 9250724.0 |
| 2007-03-06 10:50:00 | AAPL | Stock | 3.1268 | 3.1304 | 3.1243 | 3.13 | 8154160.0 |
| 2007-03-06 10:55:00 | AAPL | Stock | 3.13 | 3.13 | 3.1239 | 3.1257 | 8997380.0 |
> showing 50 of 261,802 rows — these rows as CSV