PREVIEW / stock_5min / 2011-09-12
file: by_date/stock_5min/2011/2011-09-12.parquet size: 4.9 MB rows: 333,532 symbols: 3,517
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-09-12 04:00:00 | AAPL | Stock | 13.3929 | 13.3929 | 13.3929 | 13.3929 | 5600.0 |
| 2011-09-12 04:30:00 | AAPL | Stock | 13.3393 | 13.3393 | 13.3393 | 13.3393 | 2800.0 |
| 2011-09-12 05:35:00 | AAPL | Stock | 13.3214 | 13.3214 | 13.3214 | 13.3214 | 5600.0 |
| 2011-09-12 05:40:00 | AAPL | Stock | 13.3214 | 13.3214 | 13.3214 | 13.3214 | 2800.0 |
| 2011-09-12 05:50:00 | AAPL | Stock | 13.3393 | 13.3393 | 13.3393 | 13.3393 | 2800.0 |
| 2011-09-12 06:15:00 | AAPL | Stock | 13.3214 | 13.3214 | 13.3214 | 13.3214 | 16800.0 |
| 2011-09-12 06:25:00 | AAPL | Stock | 13.3125 | 13.3214 | 13.3125 | 13.3214 | 5600.0 |
| 2011-09-12 06:55:00 | AAPL | Stock | 13.3036 | 13.3036 | 13.3036 | 13.3036 | 7700.0 |
| 2011-09-12 07:00:00 | AAPL | Stock | 13.3179 | 13.3196 | 13.2946 | 13.3071 | 187600.0 |
| 2011-09-12 07:05:00 | AAPL | Stock | 13.3107 | 13.3207 | 13.3057 | 13.3207 | 22400.0 |
| 2011-09-12 07:10:00 | AAPL | Stock | 13.3214 | 13.3446 | 13.3214 | 13.3218 | 40992.0 |
| 2011-09-12 07:15:00 | AAPL | Stock | 13.3311 | 13.3321 | 13.3236 | 13.3321 | 20944.0 |
| 2011-09-12 07:20:00 | AAPL | Stock | 13.3329 | 13.3482 | 13.3329 | 13.3482 | 34104.0 |
| 2011-09-12 07:25:00 | AAPL | Stock | 13.3643 | 13.3643 | 13.3357 | 13.3357 | 25760.0 |
| 2011-09-12 07:30:00 | AAPL | Stock | 13.3461 | 13.3571 | 13.3336 | 13.3454 | 99680.0 |
| 2011-09-12 07:35:00 | AAPL | Stock | 13.3479 | 13.3564 | 13.3325 | 13.3325 | 78400.0 |
| 2011-09-12 07:40:00 | AAPL | Stock | 13.3411 | 13.3411 | 13.3411 | 13.3411 | 8400.0 |
| 2011-09-12 07:45:00 | AAPL | Stock | 13.3489 | 13.3532 | 13.3454 | 13.3532 | 56700.0 |
| 2011-09-12 07:50:00 | AAPL | Stock | 13.3289 | 13.3318 | 13.3214 | 13.3214 | 51100.0 |
| 2011-09-12 07:55:00 | AAPL | Stock | 13.3286 | 13.3371 | 13.3036 | 13.3196 | 120512.0 |
| 2011-09-12 08:00:00 | AAPL | Stock | 13.3204 | 13.3254 | 13.2804 | 13.2871 | 350560.0 |
| 2011-09-12 08:05:00 | AAPL | Stock | 13.2882 | 13.2882 | 13.2357 | 13.25 | 612556.0 |
| 2011-09-12 08:10:00 | AAPL | Stock | 13.25 | 13.3036 | 13.2429 | 13.2811 | 546252.0 |
| 2011-09-12 08:15:00 | AAPL | Stock | 13.2714 | 13.285 | 13.2675 | 13.2682 | 137228.0 |
| 2011-09-12 08:20:00 | AAPL | Stock | 13.2714 | 13.2857 | 13.2714 | 13.2821 | 138740.0 |
| 2011-09-12 08:25:00 | AAPL | Stock | 13.2821 | 13.3164 | 13.275 | 13.2929 | 449400.0 |
| 2011-09-12 08:30:00 | AAPL | Stock | 13.2864 | 13.3143 | 13.2864 | 13.3104 | 248528.0 |
| 2011-09-12 08:35:00 | AAPL | Stock | 13.3111 | 13.3271 | 13.3096 | 13.3096 | 375340.0 |
| 2011-09-12 08:40:00 | AAPL | Stock | 13.3107 | 13.3207 | 13.2957 | 13.3086 | 328104.0 |
| 2011-09-12 08:45:00 | AAPL | Stock | 13.3079 | 13.3143 | 13.3036 | 13.3089 | 109060.0 |
| 2011-09-12 08:50:00 | AAPL | Stock | 13.3093 | 13.3321 | 13.2993 | 13.3261 | 312368.0 |
| 2011-09-12 08:55:00 | AAPL | Stock | 13.3243 | 13.3375 | 13.3182 | 13.3357 | 157136.0 |
| 2011-09-12 09:00:00 | AAPL | Stock | 13.3293 | 13.3632 | 13.3293 | 13.3496 | 359604.0 |
| 2011-09-12 09:05:00 | AAPL | Stock | 13.35 | 13.3714 | 13.34 | 13.3714 | 413308.0 |
| 2011-09-12 09:10:00 | AAPL | Stock | 13.3707 | 13.3711 | 13.3571 | 13.3643 | 214620.0 |
| 2011-09-12 09:15:00 | AAPL | Stock | 13.3704 | 13.3704 | 13.3571 | 13.3571 | 122584.0 |
| 2011-09-12 09:20:00 | AAPL | Stock | 13.3575 | 13.3668 | 13.3425 | 13.3489 | 140000.0 |
| 2011-09-12 09:25:00 | AAPL | Stock | 13.3546 | 13.3639 | 13.3218 | 13.3239 | 606816.0 |
| 2011-09-12 09:30:00 | AAPL | Stock | 13.3239 | 13.4446 | 13.3214 | 13.3986 | 14481992.0 |
| 2011-09-12 09:35:00 | AAPL | Stock | 13.4004 | 13.4275 | 13.3764 | 13.4064 | 10057404.0 |
| 2011-09-12 09:40:00 | AAPL | Stock | 13.4054 | 13.4704 | 13.4036 | 13.4511 | 11066860.0 |
| 2011-09-12 09:45:00 | AAPL | Stock | 13.4564 | 13.4968 | 13.4464 | 13.4546 | 10235736.0 |
| 2011-09-12 09:50:00 | AAPL | Stock | 13.4543 | 13.5311 | 13.4482 | 13.5114 | 11583628.0 |
| 2011-09-12 09:55:00 | AAPL | Stock | 13.5082 | 13.5625 | 13.5082 | 13.555 | 11021920.0 |
| 2011-09-12 10:00:00 | AAPL | Stock | 13.5539 | 13.5632 | 13.5314 | 13.5557 | 9390192.0 |
| 2011-09-12 10:05:00 | AAPL | Stock | 13.5589 | 13.6029 | 13.5536 | 13.575 | 9821196.0 |
| 2011-09-12 10:10:00 | AAPL | Stock | 13.575 | 13.5946 | 13.5396 | 13.5517 | 9063376.0 |
| 2011-09-12 10:15:00 | AAPL | Stock | 13.55 | 13.5586 | 13.5221 | 13.5384 | 7173964.0 |
| 2011-09-12 10:20:00 | AAPL | Stock | 13.5389 | 13.5604 | 13.5193 | 13.525 | 4955412.0 |
| 2011-09-12 10:25:00 | AAPL | Stock | 13.5218 | 13.5357 | 13.5098 | 13.5161 | 5878152.0 |
> showing 50 of 333,532 rows — these rows as CSV