PREVIEW / stock_5min / 2007-11-05
file: by_date/stock_5min/2007/2007-11-05.parquet size: 4.5 MB rows: 330,172 symbols: 3,193
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-11-05 04:15:00 | AAPL | Stock | 6.6804 | 6.6804 | 6.6804 | 6.6804 | 2800.0 |
| 2007-11-05 05:55:00 | AAPL | Stock | 6.6539 | 6.6539 | 6.6518 | 6.6518 | 53200.0 |
| 2007-11-05 06:10:00 | AAPL | Stock | 6.645 | 6.645 | 6.6432 | 6.6432 | 28000.0 |
| 2007-11-05 06:30:00 | AAPL | Stock | 6.6607 | 6.6607 | 6.6607 | 6.6607 | 5600.0 |
| 2007-11-05 06:35:00 | AAPL | Stock | 6.6607 | 6.6607 | 6.66 | 6.66 | 8400.0 |
| 2007-11-05 06:40:00 | AAPL | Stock | 6.6607 | 6.6607 | 6.6607 | 6.6607 | 14000.0 |
| 2007-11-05 06:50:00 | AAPL | Stock | 6.6464 | 6.6464 | 6.6429 | 6.6429 | 11200.0 |
| 2007-11-05 06:55:00 | AAPL | Stock | 6.6429 | 6.6429 | 6.6429 | 6.6429 | 14000.0 |
| 2007-11-05 07:00:00 | AAPL | Stock | 6.6429 | 6.6429 | 6.6429 | 6.6429 | 46900.0 |
| 2007-11-05 07:05:00 | AAPL | Stock | 6.6536 | 6.6571 | 6.6536 | 6.6571 | 47600.0 |
| 2007-11-05 07:10:00 | AAPL | Stock | 6.6604 | 6.6604 | 6.6604 | 6.6604 | 8400.0 |
| 2007-11-05 07:15:00 | AAPL | Stock | 6.6607 | 6.6607 | 6.6607 | 6.6607 | 30800.0 |
| 2007-11-05 07:20:00 | AAPL | Stock | 6.6607 | 6.6732 | 6.6607 | 6.6732 | 137200.0 |
| 2007-11-05 07:25:00 | AAPL | Stock | 6.6732 | 6.6732 | 6.6679 | 6.6729 | 14000.0 |
| 2007-11-05 07:30:00 | AAPL | Stock | 6.6696 | 6.6696 | 6.6643 | 6.6643 | 58800.0 |
| 2007-11-05 07:35:00 | AAPL | Stock | 6.6643 | 6.6643 | 6.6643 | 6.6643 | 28000.0 |
| 2007-11-05 07:45:00 | AAPL | Stock | 6.6554 | 6.6554 | 6.6554 | 6.6554 | 5600.0 |
| 2007-11-05 07:50:00 | AAPL | Stock | 6.6571 | 6.6679 | 6.6571 | 6.6679 | 5600.0 |
| 2007-11-05 07:55:00 | AAPL | Stock | 6.6589 | 6.6589 | 6.6525 | 6.6525 | 44800.0 |
| 2007-11-05 08:00:00 | AAPL | Stock | 6.6554 | 6.7096 | 6.6321 | 6.6429 | 1694448.0 |
| 2007-11-05 08:05:00 | AAPL | Stock | 6.6464 | 6.6518 | 6.6396 | 6.6396 | 293412.0 |
| 2007-11-05 08:10:00 | AAPL | Stock | 6.64 | 6.6429 | 6.6321 | 6.6321 | 533540.0 |
| 2007-11-05 08:15:00 | AAPL | Stock | 6.6329 | 6.64 | 6.6325 | 6.6361 | 152348.0 |
| 2007-11-05 08:20:00 | AAPL | Stock | 6.6339 | 6.6357 | 6.6325 | 6.6332 | 335524.0 |
| 2007-11-05 08:25:00 | AAPL | Stock | 6.6325 | 6.6393 | 6.6325 | 6.6339 | 239036.0 |
| 2007-11-05 08:30:00 | AAPL | Stock | 6.6343 | 6.635 | 6.6282 | 6.6282 | 200228.0 |
| 2007-11-05 08:35:00 | AAPL | Stock | 6.6282 | 6.6286 | 6.6196 | 6.6196 | 231364.0 |
| 2007-11-05 08:40:00 | AAPL | Stock | 6.6239 | 6.625 | 6.6182 | 6.6214 | 89348.0 |
| 2007-11-05 08:45:00 | AAPL | Stock | 6.6232 | 6.6268 | 6.6218 | 6.6254 | 189896.0 |
| 2007-11-05 08:50:00 | AAPL | Stock | 6.6279 | 6.6325 | 6.6279 | 6.6321 | 160636.0 |
| 2007-11-05 08:55:00 | AAPL | Stock | 6.6325 | 6.6411 | 6.6321 | 6.6393 | 236600.0 |
| 2007-11-05 09:00:00 | AAPL | Stock | 6.64 | 6.7096 | 6.6361 | 6.6361 | 475720.0 |
| 2007-11-05 09:05:00 | AAPL | Stock | 6.6375 | 6.6379 | 6.6268 | 6.6318 | 299236.0 |
| 2007-11-05 09:10:00 | AAPL | Stock | 6.6318 | 6.6346 | 6.6307 | 6.6343 | 202104.0 |
| 2007-11-05 09:15:00 | AAPL | Stock | 6.6354 | 6.6357 | 6.6329 | 6.6357 | 194740.0 |
| 2007-11-05 09:20:00 | AAPL | Stock | 6.6332 | 6.6332 | 6.6286 | 6.6286 | 109200.0 |
| 2007-11-05 09:25:00 | AAPL | Stock | 6.6268 | 6.6286 | 6.6107 | 6.6175 | 392028.0 |
| 2007-11-05 09:30:00 | AAPL | Stock | 6.6179 | 6.6275 | 6.58 | 6.6229 | 26629680.0 |
| 2007-11-05 09:35:00 | AAPL | Stock | 6.6193 | 6.6478 | 6.6125 | 6.6475 | 13558916.0 |
| 2007-11-05 09:40:00 | AAPL | Stock | 6.6479 | 6.6629 | 6.625 | 6.6425 | 17662064.0 |
| 2007-11-05 09:45:00 | AAPL | Stock | 6.6425 | 6.6471 | 6.6075 | 6.6207 | 10986080.0 |
| 2007-11-05 09:50:00 | AAPL | Stock | 6.6189 | 6.6218 | 6.5986 | 6.6175 | 14199052.0 |
| 2007-11-05 09:55:00 | AAPL | Stock | 6.6179 | 6.6393 | 6.6154 | 6.6254 | 13543684.0 |
| 2007-11-05 10:00:00 | AAPL | Stock | 6.6268 | 6.6504 | 6.6268 | 6.6457 | 15779120.0 |
| 2007-11-05 10:05:00 | AAPL | Stock | 6.6457 | 6.65 | 6.6157 | 6.6264 | 11849656.0 |
| 2007-11-05 10:10:00 | AAPL | Stock | 6.6264 | 6.6471 | 6.6236 | 6.6446 | 7402528.0 |
| 2007-11-05 10:15:00 | AAPL | Stock | 6.6446 | 6.6446 | 6.625 | 6.6318 | 8211588.0 |
| 2007-11-05 10:20:00 | AAPL | Stock | 6.6321 | 6.65 | 6.6311 | 6.6493 | 9094288.0 |
| 2007-11-05 10:25:00 | AAPL | Stock | 6.648 | 6.6518 | 6.6382 | 6.6407 | 8462804.0 |
| 2007-11-05 10:30:00 | AAPL | Stock | 6.6411 | 6.6496 | 6.6375 | 6.6407 | 5548704.0 |
> showing 50 of 330,172 rows — these rows as CSV