PREVIEW / stock_1min / 2012-12-05
file: by_date/stock_1min/2012/2012-12-05.parquet size: 12.8 MB rows: 948,277 symbols: 2,809
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-12-05 04:02:00 | AAPL | Stock | 20.5 | 20.5 | 20.5 | 20.5 | 14000.0 |
| 2012-12-05 04:03:00 | AAPL | Stock | 20.4946 | 20.5 | 20.4946 | 20.5 | 23660.0 |
| 2012-12-05 04:04:00 | AAPL | Stock | 20.4682 | 20.4682 | 20.4321 | 20.4321 | 11200.0 |
| 2012-12-05 04:22:00 | AAPL | Stock | 20.4107 | 20.4107 | 20.4107 | 20.4107 | 5600.0 |
| 2012-12-05 04:23:00 | AAPL | Stock | 20.4107 | 20.4107 | 20.4018 | 20.4018 | 13608.0 |
| 2012-12-05 04:24:00 | AAPL | Stock | 20.4214 | 20.4214 | 20.4214 | 20.4214 | 2800.0 |
| 2012-12-05 04:34:00 | AAPL | Stock | 20.3611 | 20.3611 | 20.3571 | 20.3571 | 26180.0 |
| 2012-12-05 04:35:00 | AAPL | Stock | 20.3929 | 20.3929 | 20.3929 | 20.3929 | 2800.0 |
| 2012-12-05 04:40:00 | AAPL | Stock | 20.3679 | 20.3679 | 20.3679 | 20.3679 | 5600.0 |
| 2012-12-05 04:46:00 | AAPL | Stock | 20.3279 | 20.3279 | 20.3279 | 20.3279 | 2800.0 |
| 2012-12-05 04:48:00 | AAPL | Stock | 20.3218 | 20.3218 | 20.3218 | 20.3218 | 17920.0 |
| 2012-12-05 04:49:00 | AAPL | Stock | 20.3214 | 20.3218 | 20.3214 | 20.3218 | 8344.0 |
| 2012-12-05 04:51:00 | AAPL | Stock | 20.3218 | 20.3218 | 20.3218 | 20.3218 | 2800.0 |
| 2012-12-05 05:01:00 | AAPL | Stock | 20.3018 | 20.3018 | 20.3018 | 20.3018 | 2800.0 |
| 2012-12-05 05:02:00 | AAPL | Stock | 20.3046 | 20.3046 | 20.3046 | 20.3046 | 5600.0 |
| 2012-12-05 05:03:00 | AAPL | Stock | 20.3046 | 20.3046 | 20.3046 | 20.3046 | 5600.0 |
| 2012-12-05 05:11:00 | AAPL | Stock | 20.2968 | 20.2968 | 20.2968 | 20.2968 | 2800.0 |
| 2012-12-05 05:26:00 | AAPL | Stock | 20.3393 | 20.3393 | 20.3393 | 20.3393 | 8400.0 |
| 2012-12-05 05:33:00 | AAPL | Stock | 20.3525 | 20.3561 | 20.3525 | 20.3561 | 5600.0 |
| 2012-12-05 05:34:00 | AAPL | Stock | 20.3571 | 20.3571 | 20.3571 | 20.3571 | 5600.0 |
| 2012-12-05 05:43:00 | AAPL | Stock | 20.3214 | 20.3214 | 20.3214 | 20.3214 | 9884.0 |
| 2012-12-05 05:47:00 | AAPL | Stock | 20.3032 | 20.3032 | 20.3032 | 20.3032 | 2800.0 |
| 2012-12-05 05:54:00 | AAPL | Stock | 20.3214 | 20.3214 | 20.3214 | 20.3214 | 2800.0 |
| 2012-12-05 05:56:00 | AAPL | Stock | 20.3214 | 20.3214 | 20.3214 | 20.3214 | 2800.0 |
| 2012-12-05 06:00:00 | AAPL | Stock | 20.3214 | 20.3214 | 20.3214 | 20.3214 | 2800.0 |
| 2012-12-05 06:10:00 | AAPL | Stock | 20.3214 | 20.3214 | 20.3214 | 20.3214 | 2800.0 |
| 2012-12-05 06:12:00 | AAPL | Stock | 20.335 | 20.335 | 20.335 | 20.335 | 2800.0 |
| 2012-12-05 06:13:00 | AAPL | Stock | 20.3354 | 20.3504 | 20.3354 | 20.3504 | 5600.0 |
| 2012-12-05 06:16:00 | AAPL | Stock | 20.3271 | 20.3271 | 20.3271 | 20.3271 | 2800.0 |
| 2012-12-05 06:18:00 | AAPL | Stock | 20.3525 | 20.3525 | 20.3525 | 20.3525 | 2800.0 |
| 2012-12-05 06:20:00 | AAPL | Stock | 20.3571 | 20.3571 | 20.3571 | 20.3571 | 2800.0 |
| 2012-12-05 06:24:00 | AAPL | Stock | 20.3393 | 20.3393 | 20.3393 | 20.3393 | 9324.0 |
| 2012-12-05 06:25:00 | AAPL | Stock | 20.3293 | 20.3293 | 20.3293 | 20.3293 | 2800.0 |
| 2012-12-05 06:43:00 | AAPL | Stock | 20.3346 | 20.3346 | 20.3346 | 20.3346 | 2800.0 |
| 2012-12-05 06:45:00 | AAPL | Stock | 20.3393 | 20.3393 | 20.3393 | 20.3393 | 2800.0 |
| 2012-12-05 06:46:00 | AAPL | Stock | 20.3293 | 20.3293 | 20.3293 | 20.3293 | 2800.0 |
| 2012-12-05 06:47:00 | AAPL | Stock | 20.3293 | 20.3489 | 20.3293 | 20.3296 | 13916.0 |
| 2012-12-05 06:48:00 | AAPL | Stock | 20.3479 | 20.3482 | 20.3479 | 20.3482 | 5600.0 |
| 2012-12-05 06:49:00 | AAPL | Stock | 20.35 | 20.3518 | 20.35 | 20.3518 | 5600.0 |
| 2012-12-05 06:51:00 | AAPL | Stock | 20.3539 | 20.3539 | 20.3486 | 20.3486 | 14000.0 |
| 2012-12-05 06:59:00 | AAPL | Stock | 20.3518 | 20.3604 | 20.3518 | 20.3604 | 39256.0 |
| 2012-12-05 07:00:00 | AAPL | Stock | 20.3414 | 20.3414 | 20.3396 | 20.3396 | 9940.0 |
| 2012-12-05 07:01:00 | AAPL | Stock | 20.3686 | 20.3686 | 20.3686 | 20.3686 | 7812.0 |
| 2012-12-05 07:02:00 | AAPL | Stock | 20.3714 | 20.3804 | 20.3636 | 20.3804 | 32256.0 |
| 2012-12-05 07:04:00 | AAPL | Stock | 20.3657 | 20.3657 | 20.3657 | 20.3657 | 2800.0 |
| 2012-12-05 07:05:00 | AAPL | Stock | 20.3571 | 20.3571 | 20.3571 | 20.3571 | 14000.0 |
| 2012-12-05 07:07:00 | AAPL | Stock | 20.3571 | 20.3571 | 20.3571 | 20.3571 | 2800.0 |
| 2012-12-05 07:08:00 | AAPL | Stock | 20.3657 | 20.3657 | 20.3464 | 20.3464 | 8400.0 |
| 2012-12-05 07:09:00 | AAPL | Stock | 20.3571 | 20.3571 | 20.3571 | 20.3571 | 2800.0 |
| 2012-12-05 07:10:00 | AAPL | Stock | 20.3571 | 20.3571 | 20.35 | 20.35 | 11200.0 |
> showing 50 of 948,277 rows — these rows as CSV