PREVIEW / stock_5min / 2005-08-22
file: by_date/stock_5min/2005/2005-08-22.parquet size: 2.7 MB rows: 198,787 symbols: 2,076
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 |
|---|---|---|---|---|---|---|---|
| 2005-08-22 08:00:00 | AAPL | Stock | 1.6582 | 1.6582 | 1.6439 | 1.6439 | 47600.0 |
| 2005-08-22 08:05:00 | AAPL | Stock | 1.6479 | 1.6518 | 1.6479 | 1.6518 | 142800.0 |
| 2005-08-22 08:10:00 | AAPL | Stock | 1.6464 | 1.65 | 1.6464 | 1.65 | 19600.0 |
| 2005-08-22 08:25:00 | AAPL | Stock | 1.6482 | 1.65 | 1.6482 | 1.65 | 50400.0 |
| 2005-08-22 08:35:00 | AAPL | Stock | 1.6493 | 1.6496 | 1.6493 | 1.6496 | 39200.0 |
| 2005-08-22 08:40:00 | AAPL | Stock | 1.6482 | 1.6482 | 1.6482 | 1.6482 | 25200.0 |
| 2005-08-22 08:45:00 | AAPL | Stock | 1.6464 | 1.6464 | 1.6464 | 1.6464 | 11200.0 |
| 2005-08-22 08:50:00 | AAPL | Stock | 1.6457 | 1.6496 | 1.6446 | 1.6446 | 24024.0 |
| 2005-08-22 08:55:00 | AAPL | Stock | 1.6446 | 1.6464 | 1.6446 | 1.6464 | 15680.0 |
| 2005-08-22 09:00:00 | AAPL | Stock | 1.6464 | 1.6464 | 1.6461 | 1.6461 | 96880.0 |
| 2005-08-22 09:05:00 | AAPL | Stock | 1.6454 | 1.6464 | 1.6429 | 1.6429 | 97440.0 |
| 2005-08-22 09:10:00 | AAPL | Stock | 1.6436 | 1.6443 | 1.6436 | 1.6436 | 14000.0 |
| 2005-08-22 09:15:00 | AAPL | Stock | 1.6436 | 1.6436 | 1.6436 | 1.6436 | 11200.0 |
| 2005-08-22 09:20:00 | AAPL | Stock | 1.6436 | 1.6464 | 1.6436 | 1.6436 | 92400.0 |
| 2005-08-22 09:25:00 | AAPL | Stock | 1.6446 | 1.6496 | 1.6429 | 1.6482 | 188832.0 |
| 2005-08-22 09:30:00 | AAPL | Stock | 1.6482 | 1.6511 | 1.6464 | 1.6511 | 13363336.0 |
| 2005-08-22 09:35:00 | AAPL | Stock | 1.6511 | 1.6607 | 1.6489 | 1.6589 | 14676452.0 |
| 2005-08-22 09:40:00 | AAPL | Stock | 1.6593 | 1.6596 | 1.6539 | 1.6568 | 5696460.0 |
| 2005-08-22 09:45:00 | AAPL | Stock | 1.6561 | 1.6629 | 1.6561 | 1.6607 | 9861040.0 |
| 2005-08-22 09:50:00 | AAPL | Stock | 1.6607 | 1.6636 | 1.6586 | 1.6636 | 8461852.0 |
| 2005-08-22 09:55:00 | AAPL | Stock | 1.6632 | 1.6654 | 1.6607 | 1.6614 | 8333892.0 |
| 2005-08-22 10:00:00 | AAPL | Stock | 1.6618 | 1.6661 | 1.6604 | 1.6654 | 6694660.0 |
| 2005-08-22 10:05:00 | AAPL | Stock | 1.6657 | 1.6693 | 1.665 | 1.6689 | 7120568.0 |
| 2005-08-22 10:10:00 | AAPL | Stock | 1.6689 | 1.6696 | 1.6643 | 1.6675 | 7473004.0 |
| 2005-08-22 10:15:00 | AAPL | Stock | 1.6679 | 1.6682 | 1.6643 | 1.6679 | 7380828.0 |
| 2005-08-22 10:20:00 | AAPL | Stock | 1.6679 | 1.6679 | 1.6625 | 1.665 | 3987984.0 |
| 2005-08-22 10:25:00 | AAPL | Stock | 1.6654 | 1.6661 | 1.6639 | 1.665 | 4322052.0 |
| 2005-08-22 10:30:00 | AAPL | Stock | 1.665 | 1.6661 | 1.6643 | 1.6643 | 3472336.0 |
| 2005-08-22 10:35:00 | AAPL | Stock | 1.6643 | 1.6682 | 1.6621 | 1.6679 | 5723144.0 |
| 2005-08-22 10:40:00 | AAPL | Stock | 1.6679 | 1.6686 | 1.6625 | 1.6629 | 4169060.0 |
| 2005-08-22 10:45:00 | AAPL | Stock | 1.6636 | 1.6639 | 1.6596 | 1.6629 | 5285868.0 |
| 2005-08-22 10:50:00 | AAPL | Stock | 1.6629 | 1.6643 | 1.6621 | 1.6629 | 2353428.0 |
| 2005-08-22 10:55:00 | AAPL | Stock | 1.6625 | 1.6643 | 1.6621 | 1.6629 | 1442280.0 |
| 2005-08-22 11:00:00 | AAPL | Stock | 1.6623 | 1.6636 | 1.6586 | 1.6593 | 4446148.0 |
| 2005-08-22 11:05:00 | AAPL | Stock | 1.6593 | 1.6607 | 1.6579 | 1.6582 | 3388700.0 |
| 2005-08-22 11:10:00 | AAPL | Stock | 1.6579 | 1.6586 | 1.6554 | 1.6557 | 5867512.0 |
| 2005-08-22 11:15:00 | AAPL | Stock | 1.6561 | 1.6589 | 1.6504 | 1.6525 | 7160888.0 |
| 2005-08-22 11:20:00 | AAPL | Stock | 1.6525 | 1.6539 | 1.6518 | 1.6536 | 4703664.0 |
| 2005-08-22 11:25:00 | AAPL | Stock | 1.6536 | 1.6539 | 1.6525 | 1.6536 | 1681568.0 |
| 2005-08-22 11:30:00 | AAPL | Stock | 1.6536 | 1.6539 | 1.6514 | 1.6536 | 2729104.0 |
| 2005-08-22 11:35:00 | AAPL | Stock | 1.6536 | 1.6568 | 1.6532 | 1.6561 | 2757020.0 |
| 2005-08-22 11:40:00 | AAPL | Stock | 1.6564 | 1.6564 | 1.6557 | 1.6561 | 547484.0 |
| 2005-08-22 11:45:00 | AAPL | Stock | 1.6561 | 1.6564 | 1.6546 | 1.6546 | 1370964.0 |
| 2005-08-22 11:50:00 | AAPL | Stock | 1.6546 | 1.655 | 1.6464 | 1.6475 | 5491640.0 |
| 2005-08-22 11:55:00 | AAPL | Stock | 1.6475 | 1.6496 | 1.6446 | 1.6461 | 5531316.0 |
| 2005-08-22 12:00:00 | AAPL | Stock | 1.6457 | 1.6461 | 1.6421 | 1.6421 | 6033524.0 |
| 2005-08-22 12:05:00 | AAPL | Stock | 1.6421 | 1.645 | 1.6404 | 1.645 | 5635560.0 |
| 2005-08-22 12:10:00 | AAPL | Stock | 1.645 | 1.6454 | 1.6425 | 1.6429 | 2558360.0 |
| 2005-08-22 12:15:00 | AAPL | Stock | 1.6425 | 1.6486 | 1.6421 | 1.6468 | 3873352.0 |
| 2005-08-22 12:20:00 | AAPL | Stock | 1.6464 | 1.6482 | 1.6464 | 1.6464 | 2566228.0 |
> showing 50 of 198,787 rows — these rows as CSV