PREVIEW / stock_1min / 2014-05-08
file: by_date/stock_1min/2014/2014-05-08.parquet size: 15.0 MB rows: 1,091,336 symbols: 2,864
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 |
|---|---|---|---|---|---|---|---|
| 2014-05-08 04:08:00 | AAPL | Stock | 21.0714 | 21.0714 | 21.0714 | 21.0714 | 2800.0 |
| 2014-05-08 04:12:00 | AAPL | Stock | 21.1089 | 21.1089 | 21.1089 | 21.1089 | 2800.0 |
| 2014-05-08 04:38:00 | AAPL | Stock | 21.1071 | 21.1071 | 21.1071 | 21.1071 | 2800.0 |
| 2014-05-08 04:39:00 | AAPL | Stock | 21.1071 | 21.1071 | 21.1071 | 21.1071 | 2800.0 |
| 2014-05-08 04:45:00 | AAPL | Stock | 21.1071 | 21.1071 | 21.1071 | 21.1071 | 2800.0 |
| 2014-05-08 04:54:00 | AAPL | Stock | 21.1107 | 21.1107 | 21.1107 | 21.1107 | 2800.0 |
| 2014-05-08 04:56:00 | AAPL | Stock | 21.1107 | 21.1107 | 21.1107 | 21.1107 | 2800.0 |
| 2014-05-08 05:17:00 | AAPL | Stock | 21.0893 | 21.0893 | 21.0893 | 21.0893 | 8400.0 |
| 2014-05-08 05:30:00 | AAPL | Stock | 21.0721 | 21.0721 | 21.0721 | 21.0721 | 2800.0 |
| 2014-05-08 05:31:00 | AAPL | Stock | 21.0718 | 21.0718 | 21.0718 | 21.0718 | 2800.0 |
| 2014-05-08 06:11:00 | AAPL | Stock | 21.0714 | 21.0714 | 21.0714 | 21.0714 | 2800.0 |
| 2014-05-08 06:12:00 | AAPL | Stock | 21.0643 | 21.0643 | 21.0643 | 21.0643 | 11200.0 |
| 2014-05-08 06:51:00 | AAPL | Stock | 21.0643 | 21.0643 | 21.0643 | 21.0643 | 7308.0 |
| 2014-05-08 06:53:00 | AAPL | Stock | 21.0643 | 21.0643 | 21.0643 | 21.0643 | 3892.0 |
| 2014-05-08 06:54:00 | AAPL | Stock | 21.0643 | 21.0643 | 21.0643 | 21.0643 | 4228.0 |
| 2014-05-08 06:58:00 | AAPL | Stock | 21.045 | 21.045 | 21.0432 | 21.0432 | 28000.0 |
| 2014-05-08 06:59:00 | AAPL | Stock | 21.0432 | 21.0432 | 21.0429 | 21.0429 | 25200.0 |
| 2014-05-08 07:18:00 | AAPL | Stock | 21.0711 | 21.0879 | 21.0711 | 21.0821 | 16800.0 |
| 2014-05-08 07:29:00 | AAPL | Stock | 21.0818 | 21.0818 | 21.0818 | 21.0818 | 2800.0 |
| 2014-05-08 07:31:00 | AAPL | Stock | 21.0714 | 21.0714 | 21.0714 | 21.0714 | 2800.0 |
| 2014-05-08 07:32:00 | AAPL | Stock | 21.0625 | 21.0625 | 21.0625 | 21.0625 | 14000.0 |
| 2014-05-08 07:35:00 | AAPL | Stock | 21.055 | 21.055 | 21.055 | 21.055 | 2800.0 |
| 2014-05-08 07:37:00 | AAPL | Stock | 21.0557 | 21.0557 | 21.0557 | 21.0557 | 14000.0 |
| 2014-05-08 07:41:00 | AAPL | Stock | 21.0446 | 21.0446 | 21.0429 | 21.0429 | 11200.0 |
| 2014-05-08 07:42:00 | AAPL | Stock | 21.0482 | 21.0557 | 21.0479 | 21.05 | 101332.0 |
| 2014-05-08 07:43:00 | AAPL | Stock | 21.0393 | 21.0446 | 21.0236 | 21.0446 | 23772.0 |
| 2014-05-08 07:44:00 | AAPL | Stock | 21.0357 | 21.0357 | 21.0357 | 21.0357 | 10500.0 |
| 2014-05-08 07:45:00 | AAPL | Stock | 21.0357 | 21.0446 | 21.0357 | 21.0446 | 64400.0 |
| 2014-05-08 07:46:00 | AAPL | Stock | 21.0429 | 21.0446 | 21.0193 | 21.0221 | 78400.0 |
| 2014-05-08 07:47:00 | AAPL | Stock | 21.0325 | 21.0357 | 21.0325 | 21.0357 | 17500.0 |
| 2014-05-08 07:49:00 | AAPL | Stock | 21.0343 | 21.0343 | 21.0339 | 21.0339 | 8400.0 |
| 2014-05-08 07:50:00 | AAPL | Stock | 21.0332 | 21.0443 | 21.0304 | 21.0357 | 36400.0 |
| 2014-05-08 07:51:00 | AAPL | Stock | 21.0357 | 21.0357 | 21.0354 | 21.0357 | 35700.0 |
| 2014-05-08 07:54:00 | AAPL | Stock | 21.0329 | 21.0329 | 21.0307 | 21.0307 | 8400.0 |
| 2014-05-08 07:56:00 | AAPL | Stock | 21.0446 | 21.0482 | 21.0446 | 21.0482 | 11200.0 |
| 2014-05-08 07:58:00 | AAPL | Stock | 21.0457 | 21.0457 | 21.0457 | 21.0457 | 8400.0 |
| 2014-05-08 07:59:00 | AAPL | Stock | 21.0464 | 21.0464 | 21.0446 | 21.0446 | 8820.0 |
| 2014-05-08 08:00:00 | AAPL | Stock | 21.0536 | 21.0557 | 21.0536 | 21.0536 | 30800.0 |
| 2014-05-08 08:01:00 | AAPL | Stock | 21.0468 | 21.0468 | 21.0429 | 21.0429 | 29204.0 |
| 2014-05-08 08:02:00 | AAPL | Stock | 21.0368 | 21.0432 | 21.0368 | 21.0432 | 8400.0 |
| 2014-05-08 08:04:00 | AAPL | Stock | 21.0418 | 21.0418 | 21.0418 | 21.0418 | 2800.0 |
| 2014-05-08 08:05:00 | AAPL | Stock | 21.0464 | 21.0464 | 21.0464 | 21.0464 | 2800.0 |
| 2014-05-08 08:06:00 | AAPL | Stock | 21.0393 | 21.0393 | 21.0357 | 21.0357 | 47432.0 |
| 2014-05-08 08:07:00 | AAPL | Stock | 21.0332 | 21.0332 | 21.0332 | 21.0332 | 11200.0 |
| 2014-05-08 08:08:00 | AAPL | Stock | 21.025 | 21.0332 | 21.0214 | 21.0332 | 33376.0 |
| 2014-05-08 08:09:00 | AAPL | Stock | 21.0214 | 21.0214 | 21.0179 | 21.0179 | 14000.0 |
| 2014-05-08 08:10:00 | AAPL | Stock | 21.0189 | 21.0189 | 21.0189 | 21.0189 | 3920.0 |
| 2014-05-08 08:11:00 | AAPL | Stock | 21.0193 | 21.0193 | 21.0193 | 21.0193 | 2800.0 |
| 2014-05-08 08:12:00 | AAPL | Stock | 21.0193 | 21.0193 | 21.0193 | 21.0193 | 2800.0 |
| 2014-05-08 08:13:00 | AAPL | Stock | 21.0214 | 21.0214 | 21.0179 | 21.0179 | 5600.0 |
> showing 50 of 1,091,336 rows — these rows as CSV