PREVIEW / stock_1min / 2012-06-05
file: by_date/stock_1min/2012/2012-06-05.parquet size: 12.9 MB rows: 973,527 symbols: 2,833
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-06-05 05:10:00 | AAPL | Stock | 20.0179 | 20.0179 | 20.0179 | 20.0179 | 3080.0 |
| 2012-06-05 05:23:00 | AAPL | Stock | 20.0536 | 20.0536 | 20.0536 | 20.0536 | 11200.0 |
| 2012-06-05 05:40:00 | AAPL | Stock | 20.0432 | 20.0432 | 20.0432 | 20.0432 | 28000.0 |
| 2012-06-05 05:51:00 | AAPL | Stock | 20.0286 | 20.0286 | 20.0286 | 20.0286 | 2800.0 |
| 2012-06-05 06:19:00 | AAPL | Stock | 20.07 | 20.07 | 20.07 | 20.07 | 2800.0 |
| 2012-06-05 06:53:00 | AAPL | Stock | 20.0632 | 20.0632 | 20.0632 | 20.0632 | 2800.0 |
| 2012-06-05 07:05:00 | AAPL | Stock | 20.0475 | 20.0475 | 20.0411 | 20.0411 | 28000.0 |
| 2012-06-05 07:06:00 | AAPL | Stock | 20.0411 | 20.0643 | 20.0411 | 20.0643 | 5600.0 |
| 2012-06-05 07:11:00 | AAPL | Stock | 20.0393 | 20.0393 | 20.0214 | 20.0214 | 22400.0 |
| 2012-06-05 07:12:00 | AAPL | Stock | 20.0357 | 20.0357 | 20.0357 | 20.0357 | 2800.0 |
| 2012-06-05 07:17:00 | AAPL | Stock | 20.0357 | 20.0357 | 20.0357 | 20.0357 | 2800.0 |
| 2012-06-05 07:18:00 | AAPL | Stock | 20.0357 | 20.0357 | 20.0357 | 20.0357 | 2800.0 |
| 2012-06-05 07:19:00 | AAPL | Stock | 20.0361 | 20.0361 | 20.0357 | 20.0357 | 25200.0 |
| 2012-06-05 07:20:00 | AAPL | Stock | 20.0243 | 20.0243 | 20.0243 | 20.0243 | 2800.0 |
| 2012-06-05 07:21:00 | AAPL | Stock | 20.02 | 20.02 | 20.02 | 20.02 | 10500.0 |
| 2012-06-05 07:22:00 | AAPL | Stock | 20.0268 | 20.0268 | 20.0268 | 20.0268 | 2800.0 |
| 2012-06-05 07:26:00 | AAPL | Stock | 20.0246 | 20.0246 | 20.0246 | 20.0246 | 5600.0 |
| 2012-06-05 07:27:00 | AAPL | Stock | 20.0211 | 20.0211 | 20.0211 | 20.0211 | 2800.0 |
| 2012-06-05 07:28:00 | AAPL | Stock | 20.0211 | 20.0357 | 20.0211 | 20.0357 | 42280.0 |
| 2012-06-05 07:29:00 | AAPL | Stock | 20.0357 | 20.0357 | 20.035 | 20.035 | 8400.0 |
| 2012-06-05 07:32:00 | AAPL | Stock | 20.0304 | 20.0304 | 20.0304 | 20.0304 | 5600.0 |
| 2012-06-05 07:34:00 | AAPL | Stock | 20.0361 | 20.0361 | 20.0361 | 20.0361 | 2800.0 |
| 2012-06-05 07:36:00 | AAPL | Stock | 20.0482 | 20.0482 | 20.0482 | 20.0482 | 2800.0 |
| 2012-06-05 07:40:00 | AAPL | Stock | 20.0364 | 20.0364 | 20.0357 | 20.0357 | 23240.0 |
| 2012-06-05 07:41:00 | AAPL | Stock | 20.0361 | 20.0361 | 20.0357 | 20.0361 | 16800.0 |
| 2012-06-05 07:43:00 | AAPL | Stock | 20.0286 | 20.0286 | 20.0268 | 20.0268 | 28000.0 |
| 2012-06-05 07:45:00 | AAPL | Stock | 20.0357 | 20.0357 | 20.0357 | 20.0357 | 10360.0 |
| 2012-06-05 07:47:00 | AAPL | Stock | 20.0368 | 20.0368 | 20.0368 | 20.0368 | 8400.0 |
| 2012-06-05 07:52:00 | AAPL | Stock | 20.0357 | 20.0357 | 20.0357 | 20.0357 | 2800.0 |
| 2012-06-05 07:53:00 | AAPL | Stock | 20.0539 | 20.0539 | 20.0539 | 20.0539 | 5600.0 |
| 2012-06-05 07:55:00 | AAPL | Stock | 20.0607 | 20.0607 | 20.0607 | 20.0607 | 2800.0 |
| 2012-06-05 07:56:00 | AAPL | Stock | 20.0571 | 20.0714 | 20.0571 | 20.0714 | 55160.0 |
| 2012-06-05 07:57:00 | AAPL | Stock | 20.0718 | 20.0846 | 20.0714 | 20.0846 | 31920.0 |
| 2012-06-05 07:58:00 | AAPL | Stock | 20.0893 | 20.0893 | 20.0879 | 20.0893 | 22120.0 |
| 2012-06-05 07:59:00 | AAPL | Stock | 20.0882 | 20.0961 | 20.0879 | 20.0961 | 18480.0 |
| 2012-06-05 08:00:00 | AAPL | Stock | 20.0929 | 20.1 | 20.0696 | 20.0804 | 119448.0 |
| 2012-06-05 08:01:00 | AAPL | Stock | 20.0879 | 20.0893 | 20.0857 | 20.0893 | 39200.0 |
| 2012-06-05 08:02:00 | AAPL | Stock | 20.08 | 20.0821 | 20.075 | 20.075 | 27440.0 |
| 2012-06-05 08:04:00 | AAPL | Stock | 20.0629 | 20.0629 | 20.0629 | 20.0629 | 16800.0 |
| 2012-06-05 08:05:00 | AAPL | Stock | 20.0636 | 20.0714 | 20.0636 | 20.0714 | 10360.0 |
| 2012-06-05 08:06:00 | AAPL | Stock | 20.0714 | 20.0714 | 20.0714 | 20.0714 | 2800.0 |
| 2012-06-05 08:09:00 | AAPL | Stock | 20.0804 | 20.0804 | 20.0754 | 20.0804 | 14000.0 |
| 2012-06-05 08:10:00 | AAPL | Stock | 20.0889 | 20.1029 | 20.0889 | 20.1029 | 65800.0 |
| 2012-06-05 08:11:00 | AAPL | Stock | 20.0964 | 20.0964 | 20.0964 | 20.0964 | 2800.0 |
| 2012-06-05 08:12:00 | AAPL | Stock | 20.1068 | 20.1068 | 20.1068 | 20.1068 | 24192.0 |
| 2012-06-05 08:13:00 | AAPL | Stock | 20.1161 | 20.1225 | 20.1161 | 20.1164 | 16940.0 |
| 2012-06-05 08:14:00 | AAPL | Stock | 20.1164 | 20.1214 | 20.1164 | 20.1164 | 38360.0 |
| 2012-06-05 08:15:00 | AAPL | Stock | 20.1193 | 20.1204 | 20.1071 | 20.1082 | 15400.0 |
| 2012-06-05 08:16:00 | AAPL | Stock | 20.1075 | 20.1179 | 20.1007 | 20.1143 | 75124.0 |
| 2012-06-05 08:17:00 | AAPL | Stock | 20.1179 | 20.1211 | 20.1125 | 20.1175 | 19600.0 |
> showing 50 of 973,527 rows — these rows as CSV