PREVIEW / stock_1min / 2012-09-26
file: by_date/stock_1min/2012/2012-09-26.parquet size: 12.8 MB rows: 950,521 symbols: 2,796
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 |
|---|---|---|---|---|---|---|---|
| 2012-09-26 04:00:00 | AAPL | Stock | 24.1025 | 24.1025 | 24.1025 | 24.1025 | 5600.0 |
| 2012-09-26 04:01:00 | AAPL | Stock | 24.0982 | 24.1025 | 24.0893 | 24.0893 | 14000.0 |
| 2012-09-26 04:02:00 | AAPL | Stock | 24.0893 | 24.0893 | 24.0786 | 24.0786 | 5600.0 |
| 2012-09-26 04:03:00 | AAPL | Stock | 24.0786 | 24.0786 | 24.0786 | 24.0786 | 5600.0 |
| 2012-09-26 04:04:00 | AAPL | Stock | 24.075 | 24.075 | 24.0714 | 24.0714 | 8400.0 |
| 2012-09-26 04:11:00 | AAPL | Stock | 24.0714 | 24.0714 | 24.0714 | 24.0714 | 5600.0 |
| 2012-09-26 04:15:00 | AAPL | Stock | 24.0625 | 24.0625 | 24.0625 | 24.0625 | 14000.0 |
| 2012-09-26 04:25:00 | AAPL | Stock | 24.0536 | 24.0536 | 24.0536 | 24.0536 | 5600.0 |
| 2012-09-26 04:26:00 | AAPL | Stock | 24.0446 | 24.0446 | 24.0446 | 24.0446 | 5320.0 |
| 2012-09-26 04:30:00 | AAPL | Stock | 24.0075 | 24.0075 | 24.0075 | 24.0075 | 2800.0 |
| 2012-09-26 04:38:00 | AAPL | Stock | 24.0182 | 24.0182 | 24.0182 | 24.0182 | 2800.0 |
| 2012-09-26 04:53:00 | AAPL | Stock | 24.0625 | 24.0625 | 24.0625 | 24.0625 | 11900.0 |
| 2012-09-26 04:58:00 | AAPL | Stock | 24.0714 | 24.0714 | 24.0714 | 24.0714 | 5600.0 |
| 2012-09-26 05:09:00 | AAPL | Stock | 24.0857 | 24.0857 | 24.0857 | 24.0857 | 5600.0 |
| 2012-09-26 05:10:00 | AAPL | Stock | 24.0893 | 24.0893 | 24.0893 | 24.0893 | 2800.0 |
| 2012-09-26 05:11:00 | AAPL | Stock | 24.0893 | 24.0893 | 24.0893 | 24.0893 | 2800.0 |
| 2012-09-26 05:12:00 | AAPL | Stock | 24.0893 | 24.0893 | 24.0893 | 24.0893 | 5600.0 |
| 2012-09-26 05:27:00 | AAPL | Stock | 24.0893 | 24.0893 | 24.0893 | 24.0893 | 2800.0 |
| 2012-09-26 05:30:00 | AAPL | Stock | 24.0893 | 24.0893 | 24.0893 | 24.0893 | 5600.0 |
| 2012-09-26 06:31:00 | AAPL | Stock | 24.0643 | 24.0643 | 24.0643 | 24.0643 | 2800.0 |
| 2012-09-26 06:45:00 | AAPL | Stock | 24.0479 | 24.0482 | 24.0479 | 24.0482 | 14000.0 |
| 2012-09-26 06:53:00 | AAPL | Stock | 24.0211 | 24.0254 | 24.0211 | 24.0254 | 15260.0 |
| 2012-09-26 06:54:00 | AAPL | Stock | 24.0232 | 24.0232 | 24.0232 | 24.0232 | 2800.0 |
| 2012-09-26 06:56:00 | AAPL | Stock | 24.0268 | 24.0268 | 24.0268 | 24.0268 | 2800.0 |
| 2012-09-26 06:57:00 | AAPL | Stock | 24.0211 | 24.0211 | 24.0211 | 24.0211 | 2800.0 |
| 2012-09-26 07:00:00 | AAPL | Stock | 24.0357 | 24.0429 | 24.0357 | 24.0429 | 11200.0 |
| 2012-09-26 07:02:00 | AAPL | Stock | 24.0446 | 24.0504 | 24.0446 | 24.0504 | 22400.0 |
| 2012-09-26 07:04:00 | AAPL | Stock | 24.0493 | 24.0511 | 24.0482 | 24.0482 | 19600.0 |
| 2012-09-26 07:14:00 | AAPL | Stock | 24.0357 | 24.0357 | 24.0357 | 24.0357 | 2800.0 |
| 2012-09-26 07:16:00 | AAPL | Stock | 24.0357 | 24.0357 | 24.0357 | 24.0357 | 2800.0 |
| 2012-09-26 07:17:00 | AAPL | Stock | 24.0393 | 24.0439 | 24.0357 | 24.0357 | 16800.0 |
| 2012-09-26 07:19:00 | AAPL | Stock | 24.0421 | 24.0421 | 24.0421 | 24.0421 | 2800.0 |
| 2012-09-26 07:20:00 | AAPL | Stock | 24.0357 | 24.0357 | 24.0321 | 24.0321 | 29960.0 |
| 2012-09-26 07:22:00 | AAPL | Stock | 24.0268 | 24.0268 | 24.0268 | 24.0268 | 2800.0 |
| 2012-09-26 07:23:00 | AAPL | Stock | 24.0246 | 24.0246 | 24.0 | 24.0 | 28476.0 |
| 2012-09-26 07:24:00 | AAPL | Stock | 24.0004 | 24.0004 | 24.0004 | 24.0004 | 11200.0 |
| 2012-09-26 07:32:00 | AAPL | Stock | 24.0014 | 24.0014 | 24.0014 | 24.0014 | 2800.0 |
| 2012-09-26 07:33:00 | AAPL | Stock | 23.9971 | 23.9971 | 23.985 | 23.985 | 34720.0 |
| 2012-09-26 07:34:00 | AAPL | Stock | 23.9654 | 23.9707 | 23.9575 | 23.9707 | 30800.0 |
| 2012-09-26 07:36:00 | AAPL | Stock | 23.9664 | 23.9664 | 23.9664 | 23.9664 | 4480.0 |
| 2012-09-26 07:38:00 | AAPL | Stock | 23.9607 | 23.9607 | 23.9607 | 23.9607 | 24976.0 |
| 2012-09-26 07:39:00 | AAPL | Stock | 23.95 | 23.9518 | 23.9464 | 23.9464 | 30716.0 |
| 2012-09-26 07:40:00 | AAPL | Stock | 23.9396 | 23.9464 | 23.9396 | 23.9464 | 16800.0 |
| 2012-09-26 07:41:00 | AAPL | Stock | 23.9411 | 23.9464 | 23.9286 | 23.9336 | 43680.0 |
| 2012-09-26 07:42:00 | AAPL | Stock | 23.9329 | 23.9329 | 23.9321 | 23.9321 | 30800.0 |
| 2012-09-26 07:43:00 | AAPL | Stock | 23.9254 | 23.9282 | 23.9214 | 23.925 | 15484.0 |
| 2012-09-26 07:44:00 | AAPL | Stock | 23.9143 | 23.9243 | 23.8982 | 23.9143 | 29680.0 |
| 2012-09-26 07:45:00 | AAPL | Stock | 23.9246 | 23.9246 | 23.9243 | 23.9243 | 8400.0 |
| 2012-09-26 07:46:00 | AAPL | Stock | 23.9143 | 23.9239 | 23.9143 | 23.9239 | 8400.0 |
| 2012-09-26 07:47:00 | AAPL | Stock | 23.925 | 23.925 | 23.925 | 23.925 | 8400.0 |
> showing 50 of 950,521 rows — these rows as CSV