PREVIEW / stock_5min / 2008-10-13
file: by_date/stock_5min/2008/2008-10-13.parquet size: 4.9 MB rows: 344,102 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 |
|---|---|---|---|---|---|---|---|
| 2008-10-13 05:10:00 | AAPL | Stock | 3.6786 | 3.6786 | 3.6786 | 3.6786 | 5600.0 |
| 2008-10-13 05:25:00 | AAPL | Stock | 3.6571 | 3.6607 | 3.6571 | 3.6607 | 29400.0 |
| 2008-10-13 05:55:00 | AAPL | Stock | 3.6786 | 3.6786 | 3.6786 | 3.6786 | 25480.0 |
| 2008-10-13 06:55:00 | AAPL | Stock | 3.6786 | 3.6786 | 3.6786 | 3.6786 | 10080.0 |
| 2008-10-13 07:00:00 | AAPL | Stock | 3.6607 | 3.6714 | 3.6429 | 3.6518 | 81648.0 |
| 2008-10-13 07:05:00 | AAPL | Stock | 3.6782 | 3.6782 | 3.6607 | 3.6607 | 61600.0 |
| 2008-10-13 07:10:00 | AAPL | Stock | 3.6607 | 3.6607 | 3.6518 | 3.6518 | 27076.0 |
| 2008-10-13 07:15:00 | AAPL | Stock | 3.6775 | 3.6775 | 3.6725 | 3.6725 | 102200.0 |
| 2008-10-13 07:20:00 | AAPL | Stock | 3.6779 | 3.6786 | 3.6521 | 3.6696 | 99848.0 |
| 2008-10-13 07:25:00 | AAPL | Stock | 3.6693 | 3.6696 | 3.6539 | 3.6696 | 100800.0 |
| 2008-10-13 07:35:00 | AAPL | Stock | 3.6607 | 3.6607 | 3.6589 | 3.6607 | 63280.0 |
| 2008-10-13 07:40:00 | AAPL | Stock | 3.6679 | 3.6786 | 3.6521 | 3.6786 | 296268.0 |
| 2008-10-13 07:45:00 | AAPL | Stock | 3.6518 | 3.6518 | 3.6429 | 3.6518 | 98000.0 |
| 2008-10-13 07:50:00 | AAPL | Stock | 3.6518 | 3.6518 | 3.6514 | 3.6518 | 28028.0 |
| 2008-10-13 07:55:00 | AAPL | Stock | 3.6607 | 3.6607 | 3.6379 | 3.6468 | 146328.0 |
| 2008-10-13 08:00:00 | AAPL | Stock | 3.6429 | 3.6464 | 3.6129 | 3.6354 | 1064504.0 |
| 2008-10-13 08:05:00 | AAPL | Stock | 3.6393 | 3.6468 | 3.6214 | 3.6429 | 441336.0 |
| 2008-10-13 08:10:00 | AAPL | Stock | 3.6429 | 3.6696 | 3.6429 | 3.6518 | 348236.0 |
| 2008-10-13 08:15:00 | AAPL | Stock | 3.6479 | 3.6618 | 3.6464 | 3.6554 | 476980.0 |
| 2008-10-13 08:20:00 | AAPL | Stock | 3.655 | 3.6632 | 3.65 | 3.6607 | 343896.0 |
| 2008-10-13 08:25:00 | AAPL | Stock | 3.6604 | 3.6914 | 3.6536 | 3.6821 | 741496.0 |
| 2008-10-13 08:30:00 | AAPL | Stock | 3.6864 | 3.6943 | 3.6786 | 3.6904 | 513156.0 |
| 2008-10-13 08:35:00 | AAPL | Stock | 3.6918 | 3.7143 | 3.6918 | 3.7107 | 1760416.0 |
| 2008-10-13 08:40:00 | AAPL | Stock | 3.7111 | 3.7282 | 3.7071 | 3.7264 | 980308.0 |
| 2008-10-13 08:45:00 | AAPL | Stock | 3.7257 | 3.7311 | 3.6971 | 3.7164 | 864948.0 |
| 2008-10-13 08:50:00 | AAPL | Stock | 3.7161 | 3.7179 | 3.6996 | 3.7043 | 564256.0 |
| 2008-10-13 08:55:00 | AAPL | Stock | 3.7054 | 3.7189 | 3.7036 | 3.7179 | 372204.0 |
| 2008-10-13 09:00:00 | AAPL | Stock | 3.7179 | 3.7268 | 3.7089 | 3.7107 | 653800.0 |
| 2008-10-13 09:05:00 | AAPL | Stock | 3.7114 | 3.7204 | 3.7089 | 3.7168 | 652596.0 |
| 2008-10-13 09:10:00 | AAPL | Stock | 3.7168 | 3.7318 | 3.7168 | 3.7271 | 648900.0 |
| 2008-10-13 09:15:00 | AAPL | Stock | 3.7271 | 3.7321 | 3.7125 | 3.7143 | 1233288.0 |
| 2008-10-13 09:20:00 | AAPL | Stock | 3.7129 | 3.7275 | 3.6861 | 3.7046 | 1598296.0 |
| 2008-10-13 09:25:00 | AAPL | Stock | 3.7046 | 3.7411 | 3.625 | 3.7343 | 4863684.0 |
| 2008-10-13 09:30:00 | AAPL | Stock | 3.7339 | 3.7857 | 3.7321 | 3.7354 | 75019280.0 |
| 2008-10-13 09:35:00 | AAPL | Stock | 3.7382 | 3.75 | 3.6882 | 3.7254 | 47134640.0 |
| 2008-10-13 09:40:00 | AAPL | Stock | 3.7257 | 3.7257 | 3.6768 | 3.6957 | 37240700.0 |
| 2008-10-13 09:45:00 | AAPL | Stock | 3.6957 | 3.7046 | 3.6504 | 3.6554 | 36215424.0 |
| 2008-10-13 09:50:00 | AAPL | Stock | 3.6543 | 3.6693 | 3.6196 | 3.6311 | 36978620.0 |
| 2008-10-13 09:55:00 | AAPL | Stock | 3.6325 | 3.6843 | 3.6286 | 3.6671 | 35515088.0 |
| 2008-10-13 10:00:00 | AAPL | Stock | 3.6668 | 3.6775 | 3.6446 | 3.6464 | 25122104.0 |
| 2008-10-13 10:05:00 | AAPL | Stock | 3.6461 | 3.65 | 3.6079 | 3.6493 | 22343188.0 |
| 2008-10-13 10:10:00 | AAPL | Stock | 3.65 | 3.6786 | 3.635 | 3.6775 | 17835328.0 |
| 2008-10-13 10:15:00 | AAPL | Stock | 3.6775 | 3.6964 | 3.6621 | 3.6871 | 19947928.0 |
| 2008-10-13 10:20:00 | AAPL | Stock | 3.6871 | 3.7121 | 3.6786 | 3.6814 | 19257812.0 |
| 2008-10-13 10:25:00 | AAPL | Stock | 3.6814 | 3.7143 | 3.6786 | 3.705 | 16244956.0 |
| 2008-10-13 10:30:00 | AAPL | Stock | 3.7064 | 3.7286 | 3.6982 | 3.6982 | 22856400.0 |
| 2008-10-13 10:35:00 | AAPL | Stock | 3.6986 | 3.7225 | 3.6825 | 3.7216 | 16974216.0 |
| 2008-10-13 10:40:00 | AAPL | Stock | 3.7204 | 3.7321 | 3.7089 | 3.7236 | 17708768.0 |
| 2008-10-13 10:45:00 | AAPL | Stock | 3.7236 | 3.7268 | 3.6929 | 3.6979 | 15599388.0 |
| 2008-10-13 10:50:00 | AAPL | Stock | 3.6979 | 3.7143 | 3.6889 | 3.7114 | 9427264.0 |
> showing 50 of 344,102 rows — these rows as CSV