PREVIEW / stock_5min / 2008-02-14
file: by_date/stock_5min/2008/2008-02-14.parquet size: 4.4 MB rows: 319,367 symbols: 3,229
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 |
|---|---|---|---|---|---|---|---|
| 2008-02-14 04:20:00 | AAPL | Stock | 4.6621 | 4.6621 | 4.6621 | 4.6621 | 2800.0 |
| 2008-02-14 05:10:00 | AAPL | Stock | 4.6621 | 4.6621 | 4.6621 | 4.6621 | 2800.0 |
| 2008-02-14 05:35:00 | AAPL | Stock | 4.6607 | 4.6607 | 4.6607 | 4.6607 | 14000.0 |
| 2008-02-14 05:40:00 | AAPL | Stock | 4.6607 | 4.6607 | 4.6607 | 4.6607 | 2800.0 |
| 2008-02-14 05:50:00 | AAPL | Stock | 4.6607 | 4.6607 | 4.6543 | 4.6543 | 11200.0 |
| 2008-02-14 06:00:00 | AAPL | Stock | 4.6432 | 4.6432 | 4.6432 | 4.6432 | 8400.0 |
| 2008-02-14 06:05:00 | AAPL | Stock | 4.6593 | 4.6593 | 4.6593 | 4.6593 | 2800.0 |
| 2008-02-14 06:10:00 | AAPL | Stock | 4.6464 | 4.6464 | 4.6443 | 4.6443 | 14000.0 |
| 2008-02-14 06:15:00 | AAPL | Stock | 4.6475 | 4.6475 | 4.6464 | 4.6464 | 11200.0 |
| 2008-02-14 06:35:00 | AAPL | Stock | 4.6464 | 4.6464 | 4.645 | 4.645 | 11676.0 |
| 2008-02-14 06:50:00 | AAPL | Stock | 4.6429 | 4.6429 | 4.6429 | 4.6429 | 5124.0 |
| 2008-02-14 07:00:00 | AAPL | Stock | 4.6436 | 4.6436 | 4.6436 | 4.6436 | 2800.0 |
| 2008-02-14 07:25:00 | AAPL | Stock | 4.66 | 4.66 | 4.66 | 4.66 | 16800.0 |
| 2008-02-14 07:30:00 | AAPL | Stock | 4.6607 | 4.6607 | 4.6518 | 4.6536 | 63840.0 |
| 2008-02-14 07:35:00 | AAPL | Stock | 4.6489 | 4.6536 | 4.6489 | 4.6536 | 11200.0 |
| 2008-02-14 07:40:00 | AAPL | Stock | 4.6525 | 4.6525 | 4.65 | 4.65 | 19600.0 |
| 2008-02-14 07:45:00 | AAPL | Stock | 4.6525 | 4.6582 | 4.65 | 4.6582 | 22400.0 |
| 2008-02-14 07:50:00 | AAPL | Stock | 4.6464 | 4.6464 | 4.6454 | 4.6464 | 16800.0 |
| 2008-02-14 07:55:00 | AAPL | Stock | 4.6482 | 4.6482 | 4.6482 | 4.6482 | 28000.0 |
| 2008-02-14 08:00:00 | AAPL | Stock | 4.6464 | 4.6564 | 4.6389 | 4.6429 | 311304.0 |
| 2008-02-14 08:05:00 | AAPL | Stock | 4.6425 | 4.6496 | 4.6425 | 4.6461 | 137984.0 |
| 2008-02-14 08:10:00 | AAPL | Stock | 4.6461 | 4.6461 | 4.6325 | 4.6386 | 189672.0 |
| 2008-02-14 08:15:00 | AAPL | Stock | 4.6386 | 4.645 | 4.6386 | 4.6411 | 364224.0 |
| 2008-02-14 08:20:00 | AAPL | Stock | 4.6429 | 4.6479 | 4.6407 | 4.6429 | 262416.0 |
| 2008-02-14 08:25:00 | AAPL | Stock | 4.6429 | 4.6518 | 4.6425 | 4.6464 | 208124.0 |
| 2008-02-14 08:30:00 | AAPL | Stock | 4.6464 | 4.6518 | 4.6375 | 4.6375 | 311388.0 |
| 2008-02-14 08:35:00 | AAPL | Stock | 4.6375 | 4.6479 | 4.6375 | 4.6393 | 348068.0 |
| 2008-02-14 08:40:00 | AAPL | Stock | 4.6375 | 4.6425 | 4.6375 | 4.6421 | 130060.0 |
| 2008-02-14 08:45:00 | AAPL | Stock | 4.6425 | 4.6425 | 4.6393 | 4.6425 | 64568.0 |
| 2008-02-14 08:50:00 | AAPL | Stock | 4.6396 | 4.64 | 4.6375 | 4.6375 | 304136.0 |
| 2008-02-14 08:55:00 | AAPL | Stock | 4.6379 | 4.6393 | 4.6343 | 4.6361 | 173208.0 |
| 2008-02-14 09:00:00 | AAPL | Stock | 4.6389 | 4.6425 | 4.6382 | 4.6386 | 202496.0 |
| 2008-02-14 09:05:00 | AAPL | Stock | 4.6386 | 4.6386 | 4.6357 | 4.6361 | 332696.0 |
| 2008-02-14 09:10:00 | AAPL | Stock | 4.635 | 4.6379 | 4.6304 | 4.6304 | 285320.0 |
| 2008-02-14 09:15:00 | AAPL | Stock | 4.6304 | 4.6314 | 4.6161 | 4.6161 | 290080.0 |
| 2008-02-14 09:20:00 | AAPL | Stock | 4.6171 | 4.625 | 4.6143 | 4.625 | 267176.0 |
| 2008-02-14 09:25:00 | AAPL | Stock | 4.6239 | 4.6264 | 4.6143 | 4.62 | 626668.0 |
| 2008-02-14 09:30:00 | AAPL | Stock | 4.6211 | 4.6268 | 4.5714 | 4.5807 | 30857036.0 |
| 2008-02-14 09:35:00 | AAPL | Stock | 4.58 | 4.5889 | 4.5586 | 4.5657 | 22786428.0 |
| 2008-02-14 09:40:00 | AAPL | Stock | 4.5657 | 4.5813 | 4.5639 | 4.5668 | 13997648.0 |
| 2008-02-14 09:45:00 | AAPL | Stock | 4.5657 | 4.5904 | 4.5621 | 4.5829 | 23044504.0 |
| 2008-02-14 09:50:00 | AAPL | Stock | 4.5825 | 4.6 | 4.5768 | 4.5961 | 14523572.0 |
| 2008-02-14 09:55:00 | AAPL | Stock | 4.5961 | 4.62 | 4.5927 | 4.6014 | 25632964.0 |
| 2008-02-14 10:00:00 | AAPL | Stock | 4.6011 | 4.6104 | 4.5954 | 4.6039 | 15508668.0 |
| 2008-02-14 10:05:00 | AAPL | Stock | 4.6046 | 4.6136 | 4.5993 | 4.6079 | 13328616.0 |
| 2008-02-14 10:10:00 | AAPL | Stock | 4.6071 | 4.6489 | 4.6061 | 4.6486 | 29273524.0 |
| 2008-02-14 10:15:00 | AAPL | Stock | 4.6468 | 4.6539 | 4.6364 | 4.6529 | 24594948.0 |
| 2008-02-14 10:20:00 | AAPL | Stock | 4.6528 | 4.6714 | 4.6518 | 4.6536 | 23560908.0 |
| 2008-02-14 10:25:00 | AAPL | Stock | 4.6529 | 4.6657 | 4.6457 | 4.6496 | 17363696.0 |
| 2008-02-14 10:30:00 | AAPL | Stock | 4.65 | 4.6554 | 4.6304 | 4.6429 | 16673804.0 |
> showing 50 of 319,367 rows — these rows as CSV