PREVIEW / stock_1min / 2010-06-24
file: by_date/stock_1min/2010/2010-06-24.parquet size: 13.3 MB rows: 1,031,814 symbols: 2,791
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 |
|---|---|---|---|---|---|---|---|
| 2010-06-24 05:55:00 | AAPL | Stock | 9.6429 | 9.6429 | 9.6429 | 9.6429 | 28000.0 |
| 2010-06-24 07:00:00 | AAPL | Stock | 9.6489 | 9.6518 | 9.6411 | 9.6411 | 15400.0 |
| 2010-06-24 07:07:00 | AAPL | Stock | 9.6432 | 9.6432 | 9.6432 | 9.6432 | 2800.0 |
| 2010-06-24 07:12:00 | AAPL | Stock | 9.6286 | 9.6286 | 9.6286 | 9.6286 | 12460.0 |
| 2010-06-24 07:16:00 | AAPL | Stock | 9.6321 | 9.6321 | 9.6321 | 9.6321 | 2800.0 |
| 2010-06-24 07:19:00 | AAPL | Stock | 9.6354 | 9.6354 | 9.6354 | 9.6354 | 8400.0 |
| 2010-06-24 07:22:00 | AAPL | Stock | 9.6304 | 9.6304 | 9.6304 | 9.6304 | 2800.0 |
| 2010-06-24 07:29:00 | AAPL | Stock | 9.6436 | 9.6436 | 9.6436 | 9.6436 | 2800.0 |
| 2010-06-24 07:31:00 | AAPL | Stock | 9.6321 | 9.6321 | 9.6189 | 9.6189 | 44800.0 |
| 2010-06-24 07:32:00 | AAPL | Stock | 9.6264 | 9.6264 | 9.6264 | 9.6264 | 11200.0 |
| 2010-06-24 07:33:00 | AAPL | Stock | 9.6307 | 9.6307 | 9.6307 | 9.6307 | 2800.0 |
| 2010-06-24 07:34:00 | AAPL | Stock | 9.6304 | 9.6389 | 9.6304 | 9.6389 | 19600.0 |
| 2010-06-24 07:35:00 | AAPL | Stock | 9.6268 | 9.6268 | 9.6182 | 9.6182 | 16800.0 |
| 2010-06-24 07:36:00 | AAPL | Stock | 9.6161 | 9.6161 | 9.6125 | 9.6125 | 53200.0 |
| 2010-06-24 07:37:00 | AAPL | Stock | 9.6164 | 9.6164 | 9.6164 | 9.6164 | 8400.0 |
| 2010-06-24 07:38:00 | AAPL | Stock | 9.6243 | 9.6321 | 9.6243 | 9.6321 | 61936.0 |
| 2010-06-24 07:39:00 | AAPL | Stock | 9.6321 | 9.6321 | 9.6286 | 9.6286 | 14000.0 |
| 2010-06-24 07:40:00 | AAPL | Stock | 9.625 | 9.6311 | 9.625 | 9.6311 | 20468.0 |
| 2010-06-24 07:48:00 | AAPL | Stock | 9.6229 | 9.6232 | 9.6229 | 9.6232 | 20860.0 |
| 2010-06-24 07:49:00 | AAPL | Stock | 9.62 | 9.6229 | 9.6189 | 9.6189 | 19600.0 |
| 2010-06-24 07:50:00 | AAPL | Stock | 9.6214 | 9.625 | 9.6214 | 9.6246 | 40516.0 |
| 2010-06-24 07:54:00 | AAPL | Stock | 9.6232 | 9.6232 | 9.6189 | 9.6189 | 16800.0 |
| 2010-06-24 07:55:00 | AAPL | Stock | 9.6246 | 9.6246 | 9.6161 | 9.6161 | 32200.0 |
| 2010-06-24 07:56:00 | AAPL | Stock | 9.6143 | 9.6143 | 9.6021 | 9.6025 | 48384.0 |
| 2010-06-24 07:57:00 | AAPL | Stock | 9.6071 | 9.6071 | 9.6071 | 9.6071 | 5600.0 |
| 2010-06-24 07:58:00 | AAPL | Stock | 9.6121 | 9.6143 | 9.6121 | 9.6143 | 7000.0 |
| 2010-06-24 07:59:00 | AAPL | Stock | 9.6136 | 9.6136 | 9.6136 | 9.6136 | 2800.0 |
| 2010-06-24 08:00:00 | AAPL | Stock | 9.6121 | 9.6189 | 9.6054 | 9.6071 | 154280.0 |
| 2010-06-24 08:01:00 | AAPL | Stock | 9.6075 | 9.61 | 9.6071 | 9.6071 | 25760.0 |
| 2010-06-24 08:02:00 | AAPL | Stock | 9.6079 | 9.6089 | 9.5993 | 9.5993 | 97132.0 |
| 2010-06-24 08:03:00 | AAPL | Stock | 9.5993 | 9.6 | 9.5993 | 9.6 | 8400.0 |
| 2010-06-24 08:04:00 | AAPL | Stock | 9.6 | 9.6036 | 9.5989 | 9.5989 | 45220.0 |
| 2010-06-24 08:05:00 | AAPL | Stock | 9.5989 | 9.6036 | 9.5989 | 9.6036 | 36400.0 |
| 2010-06-24 08:06:00 | AAPL | Stock | 9.6061 | 9.6071 | 9.6039 | 9.6039 | 42700.0 |
| 2010-06-24 08:07:00 | AAPL | Stock | 9.6071 | 9.6071 | 9.6071 | 9.6071 | 10780.0 |
| 2010-06-24 08:08:00 | AAPL | Stock | 9.6129 | 9.6143 | 9.6071 | 9.6071 | 38360.0 |
| 2010-06-24 08:09:00 | AAPL | Stock | 9.6125 | 9.6157 | 9.6111 | 9.6157 | 19600.0 |
| 2010-06-24 08:10:00 | AAPL | Stock | 9.615 | 9.6161 | 9.6114 | 9.615 | 59500.0 |
| 2010-06-24 08:11:00 | AAPL | Stock | 9.6157 | 9.6161 | 9.6143 | 9.6143 | 81088.0 |
| 2010-06-24 08:12:00 | AAPL | Stock | 9.6154 | 9.6171 | 9.6154 | 9.6164 | 11200.0 |
| 2010-06-24 08:13:00 | AAPL | Stock | 9.6179 | 9.6196 | 9.6179 | 9.6196 | 8400.0 |
| 2010-06-24 08:14:00 | AAPL | Stock | 9.6196 | 9.6236 | 9.6182 | 9.6214 | 85680.0 |
| 2010-06-24 08:15:00 | AAPL | Stock | 9.6236 | 9.6321 | 9.6214 | 9.6321 | 179200.0 |
| 2010-06-24 08:16:00 | AAPL | Stock | 9.6329 | 9.6364 | 9.6321 | 9.6337 | 146160.0 |
| 2010-06-24 08:17:00 | AAPL | Stock | 9.635 | 9.6429 | 9.635 | 9.6393 | 163576.0 |
| 2010-06-24 08:18:00 | AAPL | Stock | 9.6393 | 9.6421 | 9.6321 | 9.6321 | 318416.0 |
| 2010-06-24 08:19:00 | AAPL | Stock | 9.6343 | 9.6429 | 9.63 | 9.63 | 379008.0 |
| 2010-06-24 08:20:00 | AAPL | Stock | 9.6357 | 9.6371 | 9.6271 | 9.63 | 36400.0 |
| 2010-06-24 08:21:00 | AAPL | Stock | 9.6354 | 9.6357 | 9.6354 | 9.6357 | 35840.0 |
| 2010-06-24 08:22:00 | AAPL | Stock | 9.6336 | 9.6339 | 9.6307 | 9.6307 | 31892.0 |
> showing 50 of 1,031,814 rows — these rows as CSV