PREVIEW / stock_5min / 2008-10-02
file: by_date/stock_5min/2008/2008-10-02.parquet size: 4.4 MB rows: 314,713 symbols: 3,354
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-10-02 05:40:00 | AAPL | Stock | 3.9643 | 3.9643 | 3.9643 | 3.9643 | 2800.0 |
| 2008-10-02 06:05:00 | AAPL | Stock | 3.9643 | 3.9643 | 3.9643 | 3.9643 | 2800.0 |
| 2008-10-02 06:50:00 | AAPL | Stock | 3.9464 | 3.9464 | 3.9464 | 3.9464 | 2800.0 |
| 2008-10-02 07:00:00 | AAPL | Stock | 3.9357 | 3.9357 | 3.9321 | 3.9321 | 22400.0 |
| 2008-10-02 07:10:00 | AAPL | Stock | 3.9221 | 3.9221 | 3.9221 | 3.9221 | 88900.0 |
| 2008-10-02 07:15:00 | AAPL | Stock | 3.9071 | 3.9071 | 3.9071 | 3.9071 | 2800.0 |
| 2008-10-02 07:25:00 | AAPL | Stock | 3.9443 | 3.9443 | 3.9286 | 3.9286 | 11200.0 |
| 2008-10-02 07:30:00 | AAPL | Stock | 3.915 | 3.915 | 3.915 | 3.915 | 14000.0 |
| 2008-10-02 07:35:00 | AAPL | Stock | 3.915 | 3.915 | 3.9143 | 3.9143 | 16800.0 |
| 2008-10-02 07:40:00 | AAPL | Stock | 3.9111 | 3.9111 | 3.9071 | 3.9071 | 11200.0 |
| 2008-10-02 07:45:00 | AAPL | Stock | 3.8932 | 3.8932 | 3.8929 | 3.8929 | 37800.0 |
| 2008-10-02 07:50:00 | AAPL | Stock | 3.8754 | 3.8993 | 3.8754 | 3.8754 | 63000.0 |
| 2008-10-02 07:55:00 | AAPL | Stock | 3.8857 | 3.8857 | 3.8679 | 3.875 | 88228.0 |
| 2008-10-02 08:00:00 | AAPL | Stock | 3.8929 | 3.8929 | 3.8682 | 3.8714 | 150304.0 |
| 2008-10-02 08:05:00 | AAPL | Stock | 3.87 | 3.8911 | 3.8696 | 3.8907 | 44800.0 |
| 2008-10-02 08:10:00 | AAPL | Stock | 3.8907 | 3.8929 | 3.875 | 3.8814 | 133840.0 |
| 2008-10-02 08:15:00 | AAPL | Stock | 3.8764 | 3.8882 | 3.87 | 3.875 | 187600.0 |
| 2008-10-02 08:20:00 | AAPL | Stock | 3.8782 | 3.8839 | 3.8754 | 3.8754 | 61600.0 |
| 2008-10-02 08:25:00 | AAPL | Stock | 3.8754 | 3.8754 | 3.8614 | 3.8614 | 155288.0 |
| 2008-10-02 08:30:00 | AAPL | Stock | 3.8586 | 3.8586 | 3.8393 | 3.8468 | 350980.0 |
| 2008-10-02 08:35:00 | AAPL | Stock | 3.8514 | 3.8514 | 3.8307 | 3.8496 | 597856.0 |
| 2008-10-02 08:40:00 | AAPL | Stock | 3.8468 | 3.8504 | 3.8411 | 3.8411 | 125020.0 |
| 2008-10-02 08:45:00 | AAPL | Stock | 3.8411 | 3.8554 | 3.8382 | 3.855 | 147280.0 |
| 2008-10-02 08:50:00 | AAPL | Stock | 3.8543 | 3.8543 | 3.8511 | 3.8518 | 32620.0 |
| 2008-10-02 08:55:00 | AAPL | Stock | 3.8543 | 3.855 | 3.85 | 3.8504 | 46480.0 |
| 2008-10-02 09:00:00 | AAPL | Stock | 3.8443 | 3.8496 | 3.8414 | 3.8496 | 160188.0 |
| 2008-10-02 09:05:00 | AAPL | Stock | 3.8507 | 3.8568 | 3.8482 | 3.8482 | 140280.0 |
| 2008-10-02 09:10:00 | AAPL | Stock | 3.8468 | 3.8482 | 3.8382 | 3.8389 | 250488.0 |
| 2008-10-02 09:15:00 | AAPL | Stock | 3.8368 | 3.8368 | 3.8282 | 3.8346 | 367892.0 |
| 2008-10-02 09:20:00 | AAPL | Stock | 3.8357 | 3.84 | 3.8357 | 3.8375 | 187600.0 |
| 2008-10-02 09:25:00 | AAPL | Stock | 3.8375 | 3.875 | 3.8371 | 3.8579 | 1744596.0 |
| 2008-10-02 09:30:00 | AAPL | Stock | 3.8575 | 3.8786 | 3.8307 | 3.8446 | 28351624.0 |
| 2008-10-02 09:35:00 | AAPL | Stock | 3.8443 | 3.8571 | 3.825 | 3.8504 | 20033664.0 |
| 2008-10-02 09:40:00 | AAPL | Stock | 3.8514 | 3.8657 | 3.8393 | 3.85 | 15398404.0 |
| 2008-10-02 09:45:00 | AAPL | Stock | 3.8493 | 3.8854 | 3.8393 | 3.8689 | 22016876.0 |
| 2008-10-02 09:50:00 | AAPL | Stock | 3.8693 | 3.875 | 3.8421 | 3.8429 | 16710092.0 |
| 2008-10-02 09:55:00 | AAPL | Stock | 3.8429 | 3.8443 | 3.8036 | 3.8136 | 20285944.0 |
| 2008-10-02 10:00:00 | AAPL | Stock | 3.8125 | 3.8136 | 3.7911 | 3.7979 | 20276788.0 |
| 2008-10-02 10:05:00 | AAPL | Stock | 3.7986 | 3.8011 | 3.7286 | 3.7469 | 33182408.0 |
| 2008-10-02 10:10:00 | AAPL | Stock | 3.7461 | 3.75 | 3.6971 | 3.7396 | 29481844.0 |
| 2008-10-02 10:15:00 | AAPL | Stock | 3.7386 | 3.75 | 3.7143 | 3.7246 | 15915032.0 |
| 2008-10-02 10:20:00 | AAPL | Stock | 3.7254 | 3.7304 | 3.6471 | 3.6482 | 27589800.0 |
| 2008-10-02 10:25:00 | AAPL | Stock | 3.6482 | 3.7071 | 3.6436 | 3.6804 | 24422804.0 |
| 2008-10-02 10:30:00 | AAPL | Stock | 3.6807 | 3.6911 | 3.6429 | 3.6589 | 23204636.0 |
| 2008-10-02 10:35:00 | AAPL | Stock | 3.6582 | 3.6725 | 3.6071 | 3.6371 | 36405656.0 |
| 2008-10-02 10:40:00 | AAPL | Stock | 3.6379 | 3.65 | 3.6021 | 3.6432 | 37476236.0 |
| 2008-10-02 10:45:00 | AAPL | Stock | 3.6432 | 3.6546 | 3.6293 | 3.6361 | 17104696.0 |
| 2008-10-02 10:50:00 | AAPL | Stock | 3.6357 | 3.6668 | 3.635 | 3.6546 | 19311040.0 |
| 2008-10-02 10:55:00 | AAPL | Stock | 3.6543 | 3.6643 | 3.6429 | 3.6529 | 13258616.0 |
| 2008-10-02 11:00:00 | AAPL | Stock | 3.6534 | 3.6818 | 3.6511 | 3.6641 | 14357056.0 |
> showing 50 of 314,713 rows — these rows as CSV