PREVIEW / stock_5min / 2009-05-08
file: by_date/stock_5min/2009/2009-05-08.parquet size: 4.8 MB rows: 324,741 symbols: 3,370
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-05-08 05:10:00 | AAPL | Stock | 4.6536 | 4.6536 | 4.6536 | 4.6536 | 5600.0 |
| 2009-05-08 06:20:00 | AAPL | Stock | 4.6607 | 4.6607 | 4.6607 | 4.6607 | 14000.0 |
| 2009-05-08 06:45:00 | AAPL | Stock | 4.6554 | 4.6554 | 4.6554 | 4.6554 | 14000.0 |
| 2009-05-08 07:15:00 | AAPL | Stock | 4.6607 | 4.6696 | 4.6607 | 4.6696 | 12600.0 |
| 2009-05-08 07:25:00 | AAPL | Stock | 4.6607 | 4.6607 | 4.6607 | 4.6607 | 2800.0 |
| 2009-05-08 07:30:00 | AAPL | Stock | 4.6607 | 4.6607 | 4.6607 | 4.6607 | 9352.0 |
| 2009-05-08 07:40:00 | AAPL | Stock | 4.6661 | 4.6661 | 4.6661 | 4.6661 | 13300.0 |
| 2009-05-08 07:45:00 | AAPL | Stock | 4.6661 | 4.6661 | 4.6536 | 4.6571 | 39312.0 |
| 2009-05-08 07:50:00 | AAPL | Stock | 4.6489 | 4.6536 | 4.6429 | 4.6429 | 15400.0 |
| 2009-05-08 07:55:00 | AAPL | Stock | 4.6429 | 4.6429 | 4.6386 | 4.6393 | 61600.0 |
| 2009-05-08 08:00:00 | AAPL | Stock | 4.6382 | 4.6429 | 4.6379 | 4.6389 | 31080.0 |
| 2009-05-08 08:05:00 | AAPL | Stock | 4.6393 | 4.6432 | 4.6393 | 4.6432 | 86604.0 |
| 2009-05-08 08:10:00 | AAPL | Stock | 4.6432 | 4.6461 | 4.6429 | 4.6461 | 42000.0 |
| 2009-05-08 08:15:00 | AAPL | Stock | 4.6479 | 4.66 | 4.6446 | 4.6514 | 115780.0 |
| 2009-05-08 08:20:00 | AAPL | Stock | 4.6429 | 4.6482 | 4.6429 | 4.6482 | 15400.0 |
| 2009-05-08 08:25:00 | AAPL | Stock | 4.6446 | 4.6496 | 4.6429 | 4.6429 | 159404.0 |
| 2009-05-08 08:30:00 | AAPL | Stock | 4.6464 | 4.6604 | 4.6286 | 4.6429 | 399084.0 |
| 2009-05-08 08:35:00 | AAPL | Stock | 4.6429 | 4.6429 | 4.6243 | 4.6243 | 93212.0 |
| 2009-05-08 08:40:00 | AAPL | Stock | 4.6164 | 4.6346 | 4.6161 | 4.6346 | 191660.0 |
| 2009-05-08 08:45:00 | AAPL | Stock | 4.6339 | 4.6407 | 4.6261 | 4.6407 | 65772.0 |
| 2009-05-08 08:50:00 | AAPL | Stock | 4.6389 | 4.6389 | 4.6371 | 4.6371 | 16800.0 |
| 2009-05-08 08:55:00 | AAPL | Stock | 4.635 | 4.6357 | 4.6311 | 4.6343 | 128996.0 |
| 2009-05-08 09:00:00 | AAPL | Stock | 4.635 | 4.6357 | 4.635 | 4.6357 | 39200.0 |
| 2009-05-08 09:05:00 | AAPL | Stock | 4.6357 | 4.6357 | 4.6339 | 4.6339 | 136192.0 |
| 2009-05-08 09:10:00 | AAPL | Stock | 4.6339 | 4.6339 | 4.6311 | 4.6311 | 138264.0 |
| 2009-05-08 09:15:00 | AAPL | Stock | 4.6311 | 4.6321 | 4.6196 | 4.6214 | 80612.0 |
| 2009-05-08 09:20:00 | AAPL | Stock | 4.6196 | 4.6196 | 4.6125 | 4.6154 | 72352.0 |
| 2009-05-08 09:25:00 | AAPL | Stock | 4.6121 | 4.6175 | 4.6071 | 4.6071 | 299572.0 |
| 2009-05-08 09:30:00 | AAPL | Stock | 4.6086 | 4.6246 | 4.5689 | 4.6204 | 14746788.0 |
| 2009-05-08 09:35:00 | AAPL | Stock | 4.6211 | 4.6375 | 4.5907 | 4.6107 | 14221228.0 |
| 2009-05-08 09:40:00 | AAPL | Stock | 4.6102 | 4.6643 | 4.6 | 4.6632 | 15216936.0 |
| 2009-05-08 09:45:00 | AAPL | Stock | 4.6629 | 4.6869 | 4.6539 | 4.6689 | 13826204.0 |
| 2009-05-08 09:50:00 | AAPL | Stock | 4.6682 | 4.6768 | 4.6589 | 4.6625 | 9542540.0 |
| 2009-05-08 09:55:00 | AAPL | Stock | 4.6625 | 4.6679 | 4.6446 | 4.6495 | 8747592.0 |
| 2009-05-08 10:00:00 | AAPL | Stock | 4.6475 | 4.6489 | 4.6111 | 4.625 | 11261824.0 |
| 2009-05-08 10:05:00 | AAPL | Stock | 4.6229 | 4.6251 | 4.6082 | 4.6146 | 6768356.0 |
| 2009-05-08 10:10:00 | AAPL | Stock | 4.6146 | 4.6179 | 4.5921 | 4.5981 | 9657956.0 |
| 2009-05-08 10:15:00 | AAPL | Stock | 4.5961 | 4.5981 | 4.5421 | 4.5636 | 18044628.0 |
| 2009-05-08 10:20:00 | AAPL | Stock | 4.5654 | 4.5764 | 4.5507 | 4.5532 | 8328012.0 |
| 2009-05-08 10:25:00 | AAPL | Stock | 4.5529 | 4.5543 | 4.5096 | 4.53 | 17712464.0 |
| 2009-05-08 10:30:00 | AAPL | Stock | 4.5285 | 4.5357 | 4.5186 | 4.535 | 9874648.0 |
| 2009-05-08 10:35:00 | AAPL | Stock | 4.5354 | 4.5393 | 4.5093 | 4.5164 | 8900668.0 |
| 2009-05-08 10:40:00 | AAPL | Stock | 4.5164 | 4.5282 | 4.5093 | 4.528 | 7300636.0 |
| 2009-05-08 10:45:00 | AAPL | Stock | 4.5264 | 4.5357 | 4.5232 | 4.5271 | 4855984.0 |
| 2009-05-08 10:50:00 | AAPL | Stock | 4.5271 | 4.5346 | 4.5179 | 4.5343 | 4249140.0 |
| 2009-05-08 10:55:00 | AAPL | Stock | 4.5343 | 4.5504 | 4.5339 | 4.5396 | 6338640.0 |
| 2009-05-08 11:00:00 | AAPL | Stock | 4.5396 | 4.5679 | 4.5396 | 4.5614 | 7995204.0 |
| 2009-05-08 11:05:00 | AAPL | Stock | 4.5607 | 4.5718 | 4.5604 | 4.5696 | 4659032.0 |
| 2009-05-08 11:10:00 | AAPL | Stock | 4.5693 | 4.5729 | 4.5589 | 4.5651 | 3921736.0 |
| 2009-05-08 11:15:00 | AAPL | Stock | 4.5661 | 4.5839 | 4.5639 | 4.5792 | 4353720.0 |
> showing 50 of 324,741 rows — these rows as CSV