PREVIEW / stock_5min / 2012-12-05
file: by_date/stock_5min/2012/2012-12-05.parquet size: 4.8 MB rows: 322,510 symbols: 3,475
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:00:00 | AAPL | Stock | 20.5 | 20.5 | 20.4321 | 20.4321 | 48860.0 |
| 2012-12-05 04:20:00 | AAPL | Stock | 20.4107 | 20.4214 | 20.4018 | 20.4214 | 22008.0 |
| 2012-12-05 04:30: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:45:00 | AAPL | Stock | 20.3279 | 20.3279 | 20.3214 | 20.3218 | 29064.0 |
| 2012-12-05 04:50:00 | AAPL | Stock | 20.3218 | 20.3218 | 20.3218 | 20.3218 | 2800.0 |
| 2012-12-05 05:00:00 | AAPL | Stock | 20.3018 | 20.3046 | 20.3018 | 20.3046 | 14000.0 |
| 2012-12-05 05:10:00 | AAPL | Stock | 20.2968 | 20.2968 | 20.2968 | 20.2968 | 2800.0 |
| 2012-12-05 05:25:00 | AAPL | Stock | 20.3393 | 20.3393 | 20.3393 | 20.3393 | 8400.0 |
| 2012-12-05 05:30:00 | AAPL | Stock | 20.3525 | 20.3571 | 20.3525 | 20.3571 | 11200.0 |
| 2012-12-05 05:40:00 | AAPL | Stock | 20.3214 | 20.3214 | 20.3214 | 20.3214 | 9884.0 |
| 2012-12-05 05:45:00 | AAPL | Stock | 20.3032 | 20.3032 | 20.3032 | 20.3032 | 2800.0 |
| 2012-12-05 05:50:00 | AAPL | Stock | 20.3214 | 20.3214 | 20.3214 | 20.3214 | 2800.0 |
| 2012-12-05 05:55: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.3504 | 20.3214 | 20.3504 | 11200.0 |
| 2012-12-05 06:15:00 | AAPL | Stock | 20.3271 | 20.3525 | 20.3271 | 20.3525 | 5600.0 |
| 2012-12-05 06:20:00 | AAPL | Stock | 20.3571 | 20.3571 | 20.3393 | 20.3393 | 12124.0 |
| 2012-12-05 06:25:00 | AAPL | Stock | 20.3293 | 20.3293 | 20.3293 | 20.3293 | 2800.0 |
| 2012-12-05 06:40:00 | AAPL | Stock | 20.3346 | 20.3346 | 20.3346 | 20.3346 | 2800.0 |
| 2012-12-05 06:45:00 | AAPL | Stock | 20.3393 | 20.3518 | 20.3293 | 20.3518 | 30716.0 |
| 2012-12-05 06:50:00 | AAPL | Stock | 20.3539 | 20.3539 | 20.3486 | 20.3486 | 14000.0 |
| 2012-12-05 06:55:00 | AAPL | Stock | 20.3518 | 20.3604 | 20.3518 | 20.3604 | 39256.0 |
| 2012-12-05 07:00:00 | AAPL | Stock | 20.3414 | 20.3804 | 20.3396 | 20.3657 | 52808.0 |
| 2012-12-05 07:05:00 | AAPL | Stock | 20.3571 | 20.3657 | 20.3464 | 20.3571 | 28000.0 |
| 2012-12-05 07:10:00 | AAPL | Stock | 20.3571 | 20.3571 | 20.3425 | 20.3425 | 79156.0 |
| 2012-12-05 07:15:00 | AAPL | Stock | 20.3429 | 20.35 | 20.3143 | 20.3254 | 81732.0 |
| 2012-12-05 07:20:00 | AAPL | Stock | 20.3289 | 20.3354 | 20.3214 | 20.3304 | 56000.0 |
| 2012-12-05 07:25:00 | AAPL | Stock | 20.3232 | 20.3571 | 20.3225 | 20.3571 | 114884.0 |
| 2012-12-05 07:30:00 | AAPL | Stock | 20.3464 | 20.3571 | 20.3357 | 20.3357 | 46564.0 |
| 2012-12-05 07:35:00 | AAPL | Stock | 20.3532 | 20.3679 | 20.3429 | 20.3679 | 29176.0 |
| 2012-12-05 07:40:00 | AAPL | Stock | 20.3593 | 20.3818 | 20.3593 | 20.375 | 175532.0 |
| 2012-12-05 07:45:00 | AAPL | Stock | 20.3739 | 20.3839 | 20.3682 | 20.3732 | 127820.0 |
| 2012-12-05 07:50:00 | AAPL | Stock | 20.3693 | 20.375 | 20.3668 | 20.3668 | 40040.0 |
| 2012-12-05 07:55:00 | AAPL | Stock | 20.3739 | 20.3818 | 20.3739 | 20.375 | 60200.0 |
| 2012-12-05 08:00:00 | AAPL | Stock | 20.3807 | 20.3857 | 20.3357 | 20.3386 | 328972.0 |
| 2012-12-05 08:05:00 | AAPL | Stock | 20.3343 | 20.3357 | 20.2679 | 20.275 | 689472.0 |
| 2012-12-05 08:10:00 | AAPL | Stock | 20.2679 | 20.275 | 20.2464 | 20.25 | 821408.0 |
| 2012-12-05 08:15:00 | AAPL | Stock | 20.2446 | 20.3161 | 20.2446 | 20.3161 | 632716.0 |
| 2012-12-05 08:20:00 | AAPL | Stock | 20.3068 | 20.3314 | 20.3021 | 20.3214 | 502880.0 |
| 2012-12-05 08:25:00 | AAPL | Stock | 20.3214 | 20.3489 | 20.3189 | 20.3489 | 136080.0 |
| 2012-12-05 08:30:00 | AAPL | Stock | 20.3393 | 20.3607 | 20.3293 | 20.3293 | 384972.0 |
| 2012-12-05 08:35:00 | AAPL | Stock | 20.3286 | 20.3636 | 20.3236 | 20.3614 | 335412.0 |
| 2012-12-05 08:40:00 | AAPL | Stock | 20.3571 | 20.3821 | 20.3571 | 20.3696 | 239260.0 |
| 2012-12-05 08:45:00 | AAPL | Stock | 20.3686 | 20.3718 | 20.3536 | 20.3536 | 105784.0 |
| 2012-12-05 08:50:00 | AAPL | Stock | 20.3536 | 20.3536 | 20.3393 | 20.3471 | 197960.0 |
| 2012-12-05 08:55:00 | AAPL | Stock | 20.3429 | 20.3657 | 20.3396 | 20.3571 | 233520.0 |
| 2012-12-05 09:00:00 | AAPL | Stock | 20.3625 | 20.4054 | 20.3571 | 20.3879 | 707448.0 |
| 2012-12-05 09:05:00 | AAPL | Stock | 20.3879 | 20.4204 | 20.3786 | 20.4086 | 513100.0 |
> showing 50 of 322,510 rows — these rows as CSV