PREVIEW / stock_1min / 2008-10-29
file: by_date/stock_1min/2008/2008-10-29.parquet size: 13.0 MB rows: 1,038,387 symbols: 2,702
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-29 04:15:00 | AAPL | Stock | 3.5689 | 3.5689 | 3.5689 | 3.5689 | 2800.0 |
| 2008-10-29 06:05:00 | AAPL | Stock | 3.5575 | 3.5575 | 3.5418 | 3.5418 | 8400.0 |
| 2008-10-29 06:06:00 | AAPL | Stock | 3.5521 | 3.5543 | 3.5521 | 3.5543 | 5600.0 |
| 2008-10-29 06:08:00 | AAPL | Stock | 3.5543 | 3.5543 | 3.5543 | 3.5543 | 2800.0 |
| 2008-10-29 06:09:00 | AAPL | Stock | 3.5543 | 3.5543 | 3.5543 | 3.5543 | 11200.0 |
| 2008-10-29 06:11:00 | AAPL | Stock | 3.5571 | 3.5571 | 3.5571 | 3.5571 | 5600.0 |
| 2008-10-29 06:12:00 | AAPL | Stock | 3.5596 | 3.5596 | 3.5596 | 3.5596 | 2800.0 |
| 2008-10-29 06:13:00 | AAPL | Stock | 3.5629 | 3.5629 | 3.5629 | 3.5629 | 8400.0 |
| 2008-10-29 06:35:00 | AAPL | Stock | 3.5454 | 3.5454 | 3.5454 | 3.5454 | 5600.0 |
| 2008-10-29 06:57:00 | AAPL | Stock | 3.6179 | 3.6179 | 3.6179 | 3.6179 | 2800.0 |
| 2008-10-29 07:03:00 | AAPL | Stock | 3.6071 | 3.6071 | 3.6071 | 3.6071 | 2800.0 |
| 2008-10-29 07:11:00 | AAPL | Stock | 3.5818 | 3.5893 | 3.5818 | 3.5893 | 49000.0 |
| 2008-10-29 07:12:00 | AAPL | Stock | 3.5893 | 3.5893 | 3.5893 | 3.5893 | 30800.0 |
| 2008-10-29 07:29:00 | AAPL | Stock | 3.5982 | 3.5982 | 3.5982 | 3.5982 | 10752.0 |
| 2008-10-29 07:31:00 | AAPL | Stock | 3.5921 | 3.5921 | 3.5911 | 3.5914 | 28000.0 |
| 2008-10-29 07:32:00 | AAPL | Stock | 3.6071 | 3.6071 | 3.6071 | 3.6071 | 12600.0 |
| 2008-10-29 07:34:00 | AAPL | Stock | 3.5932 | 3.5932 | 3.5914 | 3.5914 | 52528.0 |
| 2008-10-29 07:35:00 | AAPL | Stock | 3.5964 | 3.5964 | 3.5964 | 3.5964 | 14000.0 |
| 2008-10-29 07:36:00 | AAPL | Stock | 3.5911 | 3.5911 | 3.5911 | 3.5911 | 5600.0 |
| 2008-10-29 07:38:00 | AAPL | Stock | 3.5957 | 3.5964 | 3.5957 | 3.5964 | 47600.0 |
| 2008-10-29 07:39:00 | AAPL | Stock | 3.6054 | 3.6071 | 3.6054 | 3.6071 | 18200.0 |
| 2008-10-29 07:40:00 | AAPL | Stock | 3.6071 | 3.6071 | 3.6071 | 3.6071 | 16800.0 |
| 2008-10-29 07:41:00 | AAPL | Stock | 3.6161 | 3.6161 | 3.6161 | 3.6161 | 2800.0 |
| 2008-10-29 07:42:00 | AAPL | Stock | 3.6161 | 3.6161 | 3.6161 | 3.6161 | 2800.0 |
| 2008-10-29 07:46:00 | AAPL | Stock | 3.6071 | 3.6071 | 3.6071 | 3.6071 | 2800.0 |
| 2008-10-29 07:47:00 | AAPL | Stock | 3.6161 | 3.6179 | 3.6161 | 3.6179 | 11200.0 |
| 2008-10-29 07:48:00 | AAPL | Stock | 3.6214 | 3.6429 | 3.6214 | 3.6429 | 77504.0 |
| 2008-10-29 07:50:00 | AAPL | Stock | 3.6232 | 3.6232 | 3.6232 | 3.6232 | 2800.0 |
| 2008-10-29 07:51:00 | AAPL | Stock | 3.6071 | 3.6071 | 3.6071 | 3.6071 | 11200.0 |
| 2008-10-29 07:53:00 | AAPL | Stock | 3.6229 | 3.6229 | 3.6229 | 3.6229 | 5600.0 |
| 2008-10-29 07:54:00 | AAPL | Stock | 3.6357 | 3.6357 | 3.6357 | 3.6357 | 8400.0 |
| 2008-10-29 07:55:00 | AAPL | Stock | 3.6357 | 3.6357 | 3.6357 | 3.6357 | 5600.0 |
| 2008-10-29 07:56:00 | AAPL | Stock | 3.6357 | 3.6357 | 3.6357 | 3.6357 | 6440.0 |
| 2008-10-29 07:57:00 | AAPL | Stock | 3.6339 | 3.6339 | 3.6339 | 3.6339 | 14000.0 |
| 2008-10-29 07:58:00 | AAPL | Stock | 3.6268 | 3.6268 | 3.6268 | 3.6268 | 8400.0 |
| 2008-10-29 07:59:00 | AAPL | Stock | 3.625 | 3.625 | 3.625 | 3.625 | 7000.0 |
| 2008-10-29 08:00:00 | AAPL | Stock | 3.6232 | 3.625 | 3.5979 | 3.6071 | 270004.0 |
| 2008-10-29 08:01:00 | AAPL | Stock | 3.6075 | 3.6161 | 3.6075 | 3.6154 | 54992.0 |
| 2008-10-29 08:02:00 | AAPL | Stock | 3.6093 | 3.6139 | 3.6079 | 3.6079 | 14840.0 |
| 2008-10-29 08:03:00 | AAPL | Stock | 3.6079 | 3.6111 | 3.6071 | 3.6071 | 70672.0 |
| 2008-10-29 08:04:00 | AAPL | Stock | 3.6021 | 3.6096 | 3.6021 | 3.6096 | 73780.0 |
| 2008-10-29 08:05:00 | AAPL | Stock | 3.6096 | 3.6107 | 3.6004 | 3.6068 | 93352.0 |
| 2008-10-29 08:06:00 | AAPL | Stock | 3.6 | 3.6143 | 3.5982 | 3.6118 | 109312.0 |
| 2008-10-29 08:07:00 | AAPL | Stock | 3.6096 | 3.6257 | 3.6096 | 3.6114 | 226660.0 |
| 2008-10-29 08:08:00 | AAPL | Stock | 3.6164 | 3.625 | 3.6161 | 3.625 | 86800.0 |
| 2008-10-29 08:09:00 | AAPL | Stock | 3.6261 | 3.6271 | 3.6214 | 3.6221 | 80136.0 |
| 2008-10-29 08:10:00 | AAPL | Stock | 3.6268 | 3.6314 | 3.6268 | 3.6314 | 19600.0 |
| 2008-10-29 08:11:00 | AAPL | Stock | 3.6268 | 3.6332 | 3.6268 | 3.6304 | 77420.0 |
| 2008-10-29 08:12:00 | AAPL | Stock | 3.6286 | 3.6321 | 3.6271 | 3.6289 | 69328.0 |
| 2008-10-29 08:13:00 | AAPL | Stock | 3.6307 | 3.6307 | 3.6286 | 3.6307 | 30184.0 |
> showing 50 of 1,038,387 rows — these rows as CSV