PREVIEW / stock_1min / 2011-02-25
file: by_date/stock_1min/2011/2011-02-25.parquet size: 13.6 MB rows: 1,032,517 symbols: 2,869
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 |
|---|---|---|---|---|---|---|---|
| 2011-02-25 04:24:00 | AAPL | Stock | 12.3196 | 12.3196 | 12.3196 | 12.3196 | 2800.0 |
| 2011-02-25 04:39:00 | AAPL | Stock | 12.3386 | 12.3386 | 12.3386 | 12.3386 | 2800.0 |
| 2011-02-25 04:47:00 | AAPL | Stock | 12.3393 | 12.3393 | 12.3393 | 12.3393 | 2800.0 |
| 2011-02-25 04:49:00 | AAPL | Stock | 12.3525 | 12.3525 | 12.3525 | 12.3525 | 2800.0 |
| 2011-02-25 05:07:00 | AAPL | Stock | 12.3429 | 12.3429 | 12.3429 | 12.3429 | 19516.0 |
| 2011-02-25 05:10:00 | AAPL | Stock | 12.3429 | 12.3429 | 12.3429 | 12.3429 | 2800.0 |
| 2011-02-25 05:21:00 | AAPL | Stock | 12.3536 | 12.3536 | 12.3536 | 12.3536 | 11200.0 |
| 2011-02-25 05:22:00 | AAPL | Stock | 12.3536 | 12.3536 | 12.3536 | 12.3536 | 8400.0 |
| 2011-02-25 05:44:00 | AAPL | Stock | 12.3393 | 12.3393 | 12.3393 | 12.3393 | 13440.0 |
| 2011-02-25 05:53:00 | AAPL | Stock | 12.3479 | 12.3479 | 12.3479 | 12.3479 | 2800.0 |
| 2011-02-25 06:00:00 | AAPL | Stock | 12.3564 | 12.3564 | 12.3564 | 12.3564 | 2800.0 |
| 2011-02-25 06:17:00 | AAPL | Stock | 12.3393 | 12.3393 | 12.3393 | 12.3393 | 16800.0 |
| 2011-02-25 06:23:00 | AAPL | Stock | 12.3393 | 12.3393 | 12.3393 | 12.3393 | 2800.0 |
| 2011-02-25 06:25:00 | AAPL | Stock | 12.3393 | 12.3393 | 12.3393 | 12.3393 | 5600.0 |
| 2011-02-25 06:33:00 | AAPL | Stock | 12.3393 | 12.3393 | 12.3393 | 12.3393 | 26796.0 |
| 2011-02-25 06:43:00 | AAPL | Stock | 12.3393 | 12.3393 | 12.3393 | 12.3393 | 7840.0 |
| 2011-02-25 06:45:00 | AAPL | Stock | 12.3529 | 12.3529 | 12.3529 | 12.3529 | 2800.0 |
| 2011-02-25 06:55:00 | AAPL | Stock | 12.3532 | 12.3536 | 12.3532 | 12.3536 | 16520.0 |
| 2011-02-25 06:58:00 | AAPL | Stock | 12.3561 | 12.3568 | 12.3561 | 12.3568 | 11200.0 |
| 2011-02-25 07:01:00 | AAPL | Stock | 12.35 | 12.3511 | 12.35 | 12.3511 | 8400.0 |
| 2011-02-25 07:03:00 | AAPL | Stock | 12.3518 | 12.3536 | 12.3393 | 12.3393 | 18844.0 |
| 2011-02-25 07:05:00 | AAPL | Stock | 12.3429 | 12.35 | 12.3429 | 12.35 | 11956.0 |
| 2011-02-25 07:06:00 | AAPL | Stock | 12.35 | 12.35 | 12.35 | 12.35 | 4200.0 |
| 2011-02-25 07:08:00 | AAPL | Stock | 12.35 | 12.35 | 12.3393 | 12.3393 | 12320.0 |
| 2011-02-25 07:11:00 | AAPL | Stock | 12.3482 | 12.3482 | 12.3482 | 12.3482 | 4200.0 |
| 2011-02-25 07:12:00 | AAPL | Stock | 12.3554 | 12.3554 | 12.3554 | 12.3554 | 2800.0 |
| 2011-02-25 07:15:00 | AAPL | Stock | 12.35 | 12.35 | 12.35 | 12.35 | 5600.0 |
| 2011-02-25 07:17:00 | AAPL | Stock | 12.3518 | 12.3518 | 12.3518 | 12.3518 | 2800.0 |
| 2011-02-25 07:21:00 | AAPL | Stock | 12.3396 | 12.3396 | 12.3396 | 12.3396 | 2800.0 |
| 2011-02-25 07:22:00 | AAPL | Stock | 12.3464 | 12.3464 | 12.3464 | 12.3464 | 14000.0 |
| 2011-02-25 07:23:00 | AAPL | Stock | 12.3446 | 12.3446 | 12.3446 | 12.3446 | 2800.0 |
| 2011-02-25 07:24:00 | AAPL | Stock | 12.3393 | 12.3393 | 12.3393 | 12.3393 | 19600.0 |
| 2011-02-25 07:26:00 | AAPL | Stock | 12.3393 | 12.3393 | 12.3393 | 12.3393 | 2800.0 |
| 2011-02-25 07:28:00 | AAPL | Stock | 12.3396 | 12.3464 | 12.3393 | 12.3393 | 73892.0 |
| 2011-02-25 07:30:00 | AAPL | Stock | 12.3354 | 12.3393 | 12.3354 | 12.3393 | 29400.0 |
| 2011-02-25 07:33:00 | AAPL | Stock | 12.3393 | 12.3393 | 12.3393 | 12.3393 | 5600.0 |
| 2011-02-25 07:35:00 | AAPL | Stock | 12.3375 | 12.3375 | 12.3375 | 12.3375 | 5600.0 |
| 2011-02-25 07:37:00 | AAPL | Stock | 12.3336 | 12.3336 | 12.3336 | 12.3336 | 2800.0 |
| 2011-02-25 07:38:00 | AAPL | Stock | 12.3257 | 12.3257 | 12.3257 | 12.3257 | 2800.0 |
| 2011-02-25 07:39:00 | AAPL | Stock | 12.3286 | 12.3286 | 12.3286 | 12.3286 | 2800.0 |
| 2011-02-25 07:40:00 | AAPL | Stock | 12.3264 | 12.3264 | 12.3261 | 12.3261 | 5600.0 |
| 2011-02-25 07:41:00 | AAPL | Stock | 12.325 | 12.325 | 12.3221 | 12.3221 | 37744.0 |
| 2011-02-25 07:42:00 | AAPL | Stock | 12.3257 | 12.3257 | 12.3204 | 12.3204 | 163800.0 |
| 2011-02-25 07:44:00 | AAPL | Stock | 12.3214 | 12.3214 | 12.3179 | 12.3179 | 11956.0 |
| 2011-02-25 07:45:00 | AAPL | Stock | 12.3179 | 12.3243 | 12.3175 | 12.3175 | 19600.0 |
| 2011-02-25 07:46:00 | AAPL | Stock | 12.3154 | 12.3211 | 12.3154 | 12.3211 | 33180.0 |
| 2011-02-25 07:48:00 | AAPL | Stock | 12.3139 | 12.3264 | 12.3136 | 12.3264 | 13860.0 |
| 2011-02-25 07:51:00 | AAPL | Stock | 12.3268 | 12.3268 | 12.3214 | 12.3239 | 8400.0 |
| 2011-02-25 07:53:00 | AAPL | Stock | 12.33 | 12.33 | 12.33 | 12.33 | 2800.0 |
| 2011-02-25 07:56:00 | AAPL | Stock | 12.33 | 12.33 | 12.33 | 12.33 | 14000.0 |
> showing 50 of 1,032,517 rows — these rows as CSV