PREVIEW / stock_5min / 2008-03-20
file: by_date/stock_5min/2008/2008-03-20.parquet size: 4.6 MB rows: 328,053 symbols: 3,269
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-03-20 04:15:00 | AAPL | Stock | 4.6107 | 4.6107 | 4.6107 | 4.6107 | 2800.0 |
| 2008-03-20 05:50:00 | AAPL | Stock | 4.6346 | 4.6346 | 4.6346 | 4.6346 | 28000.0 |
| 2008-03-20 06:30:00 | AAPL | Stock | 4.6314 | 4.6314 | 4.6314 | 4.6314 | 14000.0 |
| 2008-03-20 07:00:00 | AAPL | Stock | 4.6339 | 4.6357 | 4.6339 | 4.6357 | 7000.0 |
| 2008-03-20 07:05:00 | AAPL | Stock | 4.6357 | 4.6357 | 4.6357 | 4.6357 | 2800.0 |
| 2008-03-20 07:10:00 | AAPL | Stock | 4.6339 | 4.6339 | 4.6339 | 4.6339 | 5600.0 |
| 2008-03-20 07:30:00 | AAPL | Stock | 4.6482 | 4.6482 | 4.6482 | 4.6482 | 5600.0 |
| 2008-03-20 07:55:00 | AAPL | Stock | 4.6564 | 4.6564 | 4.65 | 4.65 | 37912.0 |
| 2008-03-20 08:00:00 | AAPL | Stock | 4.65 | 4.6571 | 4.6446 | 4.6564 | 247436.0 |
| 2008-03-20 08:05:00 | AAPL | Stock | 4.6536 | 4.6571 | 4.6518 | 4.6518 | 93380.0 |
| 2008-03-20 08:10:00 | AAPL | Stock | 4.6518 | 4.6518 | 4.6464 | 4.6464 | 40600.0 |
| 2008-03-20 08:15:00 | AAPL | Stock | 4.65 | 4.65 | 4.6429 | 4.6439 | 145740.0 |
| 2008-03-20 08:20:00 | AAPL | Stock | 4.6475 | 4.6507 | 4.6471 | 4.6507 | 47600.0 |
| 2008-03-20 08:25:00 | AAPL | Stock | 4.6493 | 4.6554 | 4.6493 | 4.6507 | 56000.0 |
| 2008-03-20 08:30:00 | AAPL | Stock | 4.6436 | 4.6464 | 4.6375 | 4.6429 | 157864.0 |
| 2008-03-20 08:35:00 | AAPL | Stock | 4.6443 | 4.6443 | 4.625 | 4.625 | 685552.0 |
| 2008-03-20 08:40:00 | AAPL | Stock | 4.625 | 4.6318 | 4.6214 | 4.6214 | 168952.0 |
| 2008-03-20 08:45:00 | AAPL | Stock | 4.6189 | 4.6307 | 4.615 | 4.6282 | 260540.0 |
| 2008-03-20 08:50:00 | AAPL | Stock | 4.63 | 4.6304 | 4.625 | 4.625 | 177800.0 |
| 2008-03-20 08:55:00 | AAPL | Stock | 4.6232 | 4.6232 | 4.6179 | 4.6186 | 50400.0 |
| 2008-03-20 09:00:00 | AAPL | Stock | 4.6211 | 4.6268 | 4.6179 | 4.6268 | 60200.0 |
| 2008-03-20 09:05:00 | AAPL | Stock | 4.6268 | 4.6411 | 4.6261 | 4.6396 | 139972.0 |
| 2008-03-20 09:10:00 | AAPL | Stock | 4.6375 | 4.6454 | 4.6311 | 4.6421 | 294672.0 |
| 2008-03-20 09:15:00 | AAPL | Stock | 4.6429 | 4.6461 | 4.6361 | 4.6432 | 197120.0 |
| 2008-03-20 09:20:00 | AAPL | Stock | 4.6496 | 4.6675 | 4.6486 | 4.665 | 892052.0 |
| 2008-03-20 09:25:00 | AAPL | Stock | 4.665 | 4.6804 | 4.6393 | 4.6804 | 5551728.0 |
| 2008-03-20 09:30:00 | AAPL | Stock | 4.6746 | 4.6843 | 4.6536 | 4.6571 | 90088656.0 |
| 2008-03-20 09:35:00 | AAPL | Stock | 4.6571 | 4.6729 | 4.6375 | 4.6668 | 18111576.0 |
| 2008-03-20 09:40:00 | AAPL | Stock | 4.6671 | 4.69 | 4.665 | 4.6779 | 19663028.0 |
| 2008-03-20 09:45:00 | AAPL | Stock | 4.6782 | 4.6839 | 4.6625 | 4.6671 | 13983956.0 |
| 2008-03-20 09:50:00 | AAPL | Stock | 4.6671 | 4.6732 | 4.6629 | 4.6664 | 10667244.0 |
| 2008-03-20 09:55:00 | AAPL | Stock | 4.6664 | 4.6689 | 4.6507 | 4.6654 | 13358632.0 |
| 2008-03-20 10:00:00 | AAPL | Stock | 4.665 | 4.6814 | 4.6614 | 4.6711 | 16323832.0 |
| 2008-03-20 10:05:00 | AAPL | Stock | 4.6714 | 4.6786 | 4.6511 | 4.6532 | 15026116.0 |
| 2008-03-20 10:10:00 | AAPL | Stock | 4.6525 | 4.6568 | 4.6439 | 4.6482 | 13614300.0 |
| 2008-03-20 10:15:00 | AAPL | Stock | 4.6489 | 4.6696 | 4.6479 | 4.6621 | 11219488.0 |
| 2008-03-20 10:20:00 | AAPL | Stock | 4.662 | 4.6868 | 4.6586 | 4.6739 | 13386492.0 |
| 2008-03-20 10:25:00 | AAPL | Stock | 4.6739 | 4.6786 | 4.6661 | 4.6693 | 7817460.0 |
| 2008-03-20 10:30:00 | AAPL | Stock | 4.6689 | 4.6714 | 4.6589 | 4.6664 | 8068312.0 |
| 2008-03-20 10:35:00 | AAPL | Stock | 4.6657 | 4.6661 | 4.6521 | 4.66 | 10840396.0 |
| 2008-03-20 10:40:00 | AAPL | Stock | 4.6589 | 4.6646 | 4.6507 | 4.6625 | 10237220.0 |
| 2008-03-20 10:45:00 | AAPL | Stock | 4.6629 | 4.6667 | 4.6554 | 4.6596 | 6137180.0 |
| 2008-03-20 10:50:00 | AAPL | Stock | 4.6593 | 4.6732 | 4.6543 | 4.6704 | 10610488.0 |
| 2008-03-20 10:55:00 | AAPL | Stock | 4.67 | 4.6732 | 4.6657 | 4.6721 | 5727960.0 |
| 2008-03-20 11:00:00 | AAPL | Stock | 4.6718 | 4.6725 | 4.6596 | 4.6645 | 5773600.0 |
| 2008-03-20 11:05:00 | AAPL | Stock | 4.6646 | 4.6654 | 4.6525 | 4.6583 | 7292292.0 |
| 2008-03-20 11:10:00 | AAPL | Stock | 4.6582 | 4.6618 | 4.6475 | 4.6532 | 8986908.0 |
| 2008-03-20 11:15:00 | AAPL | Stock | 4.6532 | 4.6554 | 4.6464 | 4.6482 | 7870632.0 |
| 2008-03-20 11:20:00 | AAPL | Stock | 4.6482 | 4.6607 | 4.645 | 4.66 | 10358124.0 |
| 2008-03-20 11:25:00 | AAPL | Stock | 4.66 | 4.6629 | 4.65 | 4.6625 | 5646816.0 |
> showing 50 of 328,053 rows — these rows as CSV