PREVIEW / stock_1min / 2012-02-03
file: by_date/stock_1min/2012/2012-02-03.parquet size: 14.2 MB rows: 1,052,228 symbols: 2,877
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-02-03 04:33:00 | AAPL | Stock | 16.2661 | 16.2661 | 16.2661 | 16.2661 | 2800.0 |
| 2012-02-03 06:03:00 | AAPL | Stock | 16.2714 | 16.2714 | 16.2714 | 16.2714 | 7140.0 |
| 2012-02-03 06:44:00 | AAPL | Stock | 16.2714 | 16.2714 | 16.2714 | 16.2714 | 11200.0 |
| 2012-02-03 06:57:00 | AAPL | Stock | 16.2714 | 16.2714 | 16.2714 | 16.2714 | 2800.0 |
| 2012-02-03 07:04:00 | AAPL | Stock | 16.275 | 16.275 | 16.2714 | 16.2714 | 28700.0 |
| 2012-02-03 07:14:00 | AAPL | Stock | 16.2736 | 16.2736 | 16.2714 | 16.2714 | 15260.0 |
| 2012-02-03 07:27:00 | AAPL | Stock | 16.2714 | 16.2714 | 16.2714 | 16.2714 | 2800.0 |
| 2012-02-03 07:33:00 | AAPL | Stock | 16.2607 | 16.2607 | 16.2607 | 16.2607 | 2800.0 |
| 2012-02-03 07:44:00 | AAPL | Stock | 16.2696 | 16.2696 | 16.2696 | 16.2696 | 13496.0 |
| 2012-02-03 07:49:00 | AAPL | Stock | 16.2679 | 16.2679 | 16.2679 | 16.2679 | 2800.0 |
| 2012-02-03 07:53:00 | AAPL | Stock | 16.2607 | 16.2679 | 16.2589 | 16.2589 | 58800.0 |
| 2012-02-03 08:00:00 | AAPL | Stock | 16.2639 | 16.2639 | 16.2579 | 16.2579 | 32284.0 |
| 2012-02-03 08:02:00 | AAPL | Stock | 16.2579 | 16.2579 | 16.2511 | 16.2511 | 69048.0 |
| 2012-02-03 08:03:00 | AAPL | Stock | 16.25 | 16.25 | 16.25 | 16.25 | 5600.0 |
| 2012-02-03 08:04:00 | AAPL | Stock | 16.25 | 16.25 | 16.25 | 16.25 | 11200.0 |
| 2012-02-03 08:05:00 | AAPL | Stock | 16.2429 | 16.2429 | 16.2429 | 16.2429 | 12180.0 |
| 2012-02-03 08:06:00 | AAPL | Stock | 16.25 | 16.25 | 16.25 | 16.25 | 24360.0 |
| 2012-02-03 08:09:00 | AAPL | Stock | 16.2414 | 16.2414 | 16.2414 | 16.2414 | 2800.0 |
| 2012-02-03 08:12:00 | AAPL | Stock | 16.2393 | 16.2393 | 16.2321 | 16.2321 | 64372.0 |
| 2012-02-03 08:13:00 | AAPL | Stock | 16.2371 | 16.2375 | 16.2136 | 16.2207 | 135716.0 |
| 2012-02-03 08:14:00 | AAPL | Stock | 16.2321 | 16.2375 | 16.2286 | 16.2371 | 36260.0 |
| 2012-02-03 08:15:00 | AAPL | Stock | 16.2371 | 16.2375 | 16.2371 | 16.2375 | 24080.0 |
| 2012-02-03 08:16:00 | AAPL | Stock | 16.2421 | 16.2421 | 16.2421 | 16.2421 | 4620.0 |
| 2012-02-03 08:22:00 | AAPL | Stock | 16.2339 | 16.2339 | 16.2339 | 16.2339 | 3556.0 |
| 2012-02-03 08:24:00 | AAPL | Stock | 16.2357 | 16.2361 | 16.2357 | 16.2361 | 11200.0 |
| 2012-02-03 08:25:00 | AAPL | Stock | 16.2339 | 16.2468 | 16.2339 | 16.2468 | 11200.0 |
| 2012-02-03 08:27:00 | AAPL | Stock | 16.2507 | 16.2507 | 16.2357 | 16.2357 | 29400.0 |
| 2012-02-03 08:28:00 | AAPL | Stock | 16.2357 | 16.2496 | 16.2357 | 16.2493 | 17052.0 |
| 2012-02-03 08:29:00 | AAPL | Stock | 16.2489 | 16.2489 | 16.2489 | 16.2489 | 2800.0 |
| 2012-02-03 08:30:00 | AAPL | Stock | 16.25 | 16.3211 | 16.2364 | 16.3096 | 574700.0 |
| 2012-02-03 08:31:00 | AAPL | Stock | 16.3036 | 16.3279 | 16.3036 | 16.3211 | 493528.0 |
| 2012-02-03 08:32:00 | AAPL | Stock | 16.3193 | 16.3196 | 16.3036 | 16.3175 | 169400.0 |
| 2012-02-03 08:33:00 | AAPL | Stock | 16.3168 | 16.3196 | 16.3136 | 16.3196 | 274848.0 |
| 2012-02-03 08:34:00 | AAPL | Stock | 16.3189 | 16.325 | 16.3171 | 16.325 | 389200.0 |
| 2012-02-03 08:35:00 | AAPL | Stock | 16.325 | 16.3446 | 16.3221 | 16.3446 | 201684.0 |
| 2012-02-03 08:36:00 | AAPL | Stock | 16.3461 | 16.3564 | 16.3461 | 16.3468 | 222180.0 |
| 2012-02-03 08:37:00 | AAPL | Stock | 16.3493 | 16.3571 | 16.3486 | 16.3554 | 337204.0 |
| 2012-02-03 08:38:00 | AAPL | Stock | 16.3568 | 16.3571 | 16.3421 | 16.3486 | 185388.0 |
| 2012-02-03 08:39:00 | AAPL | Stock | 16.2543 | 16.3482 | 16.2543 | 16.3393 | 279216.0 |
| 2012-02-03 08:40:00 | AAPL | Stock | 16.3418 | 16.3418 | 16.3321 | 16.3371 | 61600.0 |
| 2012-02-03 08:41:00 | AAPL | Stock | 16.3261 | 16.3271 | 16.325 | 16.3261 | 25200.0 |
| 2012-02-03 08:42:00 | AAPL | Stock | 16.3357 | 16.3371 | 16.3307 | 16.3346 | 19460.0 |
| 2012-02-03 08:43:00 | AAPL | Stock | 16.3321 | 16.3357 | 16.3304 | 16.3304 | 60732.0 |
| 2012-02-03 08:44:00 | AAPL | Stock | 16.3354 | 16.3464 | 16.3304 | 16.3464 | 295736.0 |
| 2012-02-03 08:45:00 | AAPL | Stock | 16.3418 | 16.3475 | 16.3411 | 16.3461 | 41580.0 |
| 2012-02-03 08:46:00 | AAPL | Stock | 16.3429 | 16.3429 | 16.3393 | 16.3393 | 163240.0 |
| 2012-02-03 08:47:00 | AAPL | Stock | 16.3393 | 16.3446 | 16.3304 | 16.3389 | 49700.0 |
| 2012-02-03 08:48:00 | AAPL | Stock | 16.3307 | 16.3382 | 16.3264 | 16.3264 | 81452.0 |
| 2012-02-03 08:49:00 | AAPL | Stock | 16.3271 | 16.3271 | 16.3261 | 16.3264 | 34972.0 |
| 2012-02-03 08:50:00 | AAPL | Stock | 16.3268 | 16.3304 | 16.3268 | 16.3304 | 39200.0 |
> showing 50 of 1,052,228 rows — these rows as CSV