PREVIEW / stock_1min / 2013-09-24
file: by_date/stock_1min/2013/2013-09-24.parquet size: 13.9 MB rows: 1,011,398 symbols: 2,842
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 |
|---|---|---|---|---|---|---|---|
| 2013-09-24 04:00:00 | AAPL | Stock | 17.6421 | 17.6536 | 17.6421 | 17.6536 | 15400.0 |
| 2013-09-24 04:01:00 | AAPL | Stock | 17.6786 | 17.6786 | 17.6786 | 17.6786 | 2800.0 |
| 2013-09-24 04:06:00 | AAPL | Stock | 17.6429 | 17.6543 | 17.6429 | 17.6504 | 26320.0 |
| 2013-09-24 04:07:00 | AAPL | Stock | 17.6504 | 17.6504 | 17.6504 | 17.6504 | 8400.0 |
| 2013-09-24 04:08:00 | AAPL | Stock | 17.6396 | 17.6396 | 17.6396 | 17.6396 | 8400.0 |
| 2013-09-24 04:09:00 | AAPL | Stock | 17.6536 | 17.6536 | 17.6536 | 17.6536 | 13552.0 |
| 2013-09-24 04:11:00 | AAPL | Stock | 17.6482 | 17.6482 | 17.6482 | 17.6482 | 5096.0 |
| 2013-09-24 04:12:00 | AAPL | Stock | 17.6536 | 17.6536 | 17.6536 | 17.6536 | 2800.0 |
| 2013-09-24 04:16:00 | AAPL | Stock | 17.6464 | 17.6464 | 17.6396 | 17.6396 | 14000.0 |
| 2013-09-24 04:17:00 | AAPL | Stock | 17.6361 | 17.6361 | 17.6357 | 17.6357 | 16800.0 |
| 2013-09-24 04:23:00 | AAPL | Stock | 17.6429 | 17.6429 | 17.6429 | 17.6429 | 3668.0 |
| 2013-09-24 04:37:00 | AAPL | Stock | 17.6432 | 17.6432 | 17.6432 | 17.6432 | 3360.0 |
| 2013-09-24 04:44:00 | AAPL | Stock | 17.6132 | 17.6132 | 17.6071 | 17.6071 | 21000.0 |
| 2013-09-24 04:48:00 | AAPL | Stock | 17.6171 | 17.6171 | 17.6171 | 17.6171 | 5600.0 |
| 2013-09-24 04:53:00 | AAPL | Stock | 17.6171 | 17.64 | 17.6171 | 17.64 | 11200.0 |
| 2013-09-24 05:04:00 | AAPL | Stock | 17.6286 | 17.6286 | 17.6286 | 17.6286 | 14000.0 |
| 2013-09-24 05:10:00 | AAPL | Stock | 17.6079 | 17.6079 | 17.6079 | 17.6079 | 2800.0 |
| 2013-09-24 05:16:00 | AAPL | Stock | 17.61 | 17.61 | 17.61 | 17.61 | 5600.0 |
| 2013-09-24 05:17:00 | AAPL | Stock | 17.6082 | 17.6082 | 17.605 | 17.605 | 198800.0 |
| 2013-09-24 05:28:00 | AAPL | Stock | 17.6196 | 17.6196 | 17.6196 | 17.6196 | 2800.0 |
| 2013-09-24 05:30:00 | AAPL | Stock | 17.6068 | 17.6068 | 17.6068 | 17.6068 | 13860.0 |
| 2013-09-24 05:31:00 | AAPL | Stock | 17.5857 | 17.5857 | 17.5857 | 17.5857 | 11200.0 |
| 2013-09-24 05:37:00 | AAPL | Stock | 17.6068 | 17.6068 | 17.6068 | 17.6068 | 5544.0 |
| 2013-09-24 05:41:00 | AAPL | Stock | 17.6036 | 17.6036 | 17.6036 | 17.6036 | 2800.0 |
| 2013-09-24 05:44:00 | AAPL | Stock | 17.5879 | 17.5879 | 17.5879 | 17.5879 | 6916.0 |
| 2013-09-24 05:48:00 | AAPL | Stock | 17.5829 | 17.5829 | 17.5829 | 17.5829 | 5600.0 |
| 2013-09-24 05:50:00 | AAPL | Stock | 17.5879 | 17.5879 | 17.5879 | 17.5879 | 2800.0 |
| 2013-09-24 05:56:00 | AAPL | Stock | 17.5811 | 17.5811 | 17.5811 | 17.5811 | 6580.0 |
| 2013-09-24 05:57:00 | AAPL | Stock | 17.5811 | 17.5811 | 17.5811 | 17.5811 | 2800.0 |
| 2013-09-24 06:00:00 | AAPL | Stock | 17.5857 | 17.5857 | 17.5857 | 17.5857 | 2800.0 |
| 2013-09-24 06:01:00 | AAPL | Stock | 17.5857 | 17.6036 | 17.5536 | 17.5536 | 95200.0 |
| 2013-09-24 06:02:00 | AAPL | Stock | 17.5996 | 17.6071 | 17.5996 | 17.6071 | 8400.0 |
| 2013-09-24 06:04:00 | AAPL | Stock | 17.6286 | 17.6286 | 17.6286 | 17.6286 | 13720.0 |
| 2013-09-24 06:05:00 | AAPL | Stock | 17.6246 | 17.6246 | 17.6246 | 17.6246 | 4200.0 |
| 2013-09-24 06:07:00 | AAPL | Stock | 17.6246 | 17.625 | 17.6246 | 17.625 | 13972.0 |
| 2013-09-24 06:09:00 | AAPL | Stock | 17.625 | 17.625 | 17.625 | 17.625 | 17780.0 |
| 2013-09-24 06:10:00 | AAPL | Stock | 17.625 | 17.63 | 17.625 | 17.63 | 14000.0 |
| 2013-09-24 06:13:00 | AAPL | Stock | 17.6196 | 17.675 | 17.6196 | 17.6429 | 83552.0 |
| 2013-09-24 06:16:00 | AAPL | Stock | 17.6429 | 17.6429 | 17.6429 | 17.6429 | 8400.0 |
| 2013-09-24 06:17:00 | AAPL | Stock | 17.6429 | 17.6429 | 17.6429 | 17.6429 | 8568.0 |
| 2013-09-24 06:26:00 | AAPL | Stock | 17.6536 | 17.6536 | 17.65 | 17.65 | 14000.0 |
| 2013-09-24 06:28:00 | AAPL | Stock | 17.6429 | 17.6429 | 17.6429 | 17.6429 | 2800.0 |
| 2013-09-24 06:30:00 | AAPL | Stock | 17.6143 | 17.6336 | 17.6143 | 17.6336 | 8400.0 |
| 2013-09-24 06:32:00 | AAPL | Stock | 17.6493 | 17.6661 | 17.6493 | 17.6643 | 53200.0 |
| 2013-09-24 06:33:00 | AAPL | Stock | 17.6661 | 17.6661 | 17.6661 | 17.6661 | 43540.0 |
| 2013-09-24 06:36:00 | AAPL | Stock | 17.6618 | 17.6618 | 17.6618 | 17.6618 | 28000.0 |
| 2013-09-24 06:40:00 | AAPL | Stock | 17.6471 | 17.6471 | 17.6454 | 17.6454 | 25200.0 |
| 2013-09-24 06:43:00 | AAPL | Stock | 17.645 | 17.645 | 17.645 | 17.645 | 6748.0 |
| 2013-09-24 06:51:00 | AAPL | Stock | 17.6271 | 17.6271 | 17.6271 | 17.6271 | 2800.0 |
| 2013-09-24 06:54:00 | AAPL | Stock | 17.625 | 17.6321 | 17.625 | 17.6321 | 8400.0 |
> showing 50 of 1,011,398 rows — these rows as CSV