PREVIEW / stock_5min / 2013-09-26
file: by_date/stock_5min/2013/2013-09-26.parquet size: 5.1 MB rows: 338,514 symbols: 3,529
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 |
|---|---|---|---|---|---|---|---|
| 2013-09-26 05:30:00 | AAPL | Stock | 17.2343 | 17.2343 | 17.2343 | 17.2343 | 3976.0 |
| 2013-09-26 06:50:00 | AAPL | Stock | 17.2686 | 17.2804 | 17.2686 | 17.2804 | 30800.0 |
| 2013-09-26 06:55:00 | AAPL | Stock | 17.2896 | 17.2946 | 17.2857 | 17.2857 | 14000.0 |
| 2013-09-26 07:00:00 | AAPL | Stock | 17.3125 | 17.3393 | 17.3036 | 17.3393 | 77392.0 |
| 2013-09-26 07:05:00 | AAPL | Stock | 17.3389 | 17.3389 | 17.3071 | 17.3071 | 143080.0 |
| 2013-09-26 07:10:00 | AAPL | Stock | 17.2882 | 17.2882 | 17.2771 | 17.2771 | 19600.0 |
| 2013-09-26 07:15:00 | AAPL | Stock | 17.2736 | 17.2736 | 17.2736 | 17.2736 | 5600.0 |
| 2013-09-26 07:20:00 | AAPL | Stock | 17.2607 | 17.3111 | 17.2607 | 17.3111 | 138600.0 |
| 2013-09-26 07:25:00 | AAPL | Stock | 17.3207 | 17.3339 | 17.2957 | 17.3071 | 256732.0 |
| 2013-09-26 07:30:00 | AAPL | Stock | 17.3079 | 17.3079 | 17.3021 | 17.3021 | 22400.0 |
| 2013-09-26 07:35:00 | AAPL | Stock | 17.3054 | 17.3379 | 17.3036 | 17.335 | 146188.0 |
| 2013-09-26 07:40:00 | AAPL | Stock | 17.3257 | 17.3329 | 17.3107 | 17.3214 | 43260.0 |
| 2013-09-26 07:45:00 | AAPL | Stock | 17.3214 | 17.3554 | 17.3111 | 17.3539 | 267260.0 |
| 2013-09-26 07:50:00 | AAPL | Stock | 17.3539 | 17.3571 | 17.33 | 17.3382 | 146972.0 |
| 2013-09-26 07:55:00 | AAPL | Stock | 17.3304 | 17.3568 | 17.3246 | 17.3529 | 120120.0 |
| 2013-09-26 08:00:00 | AAPL | Stock | 17.3446 | 17.3536 | 17.2964 | 17.3411 | 540932.0 |
| 2013-09-26 08:05:00 | AAPL | Stock | 17.3393 | 17.3536 | 17.3214 | 17.3214 | 400904.0 |
| 2013-09-26 08:10:00 | AAPL | Stock | 17.3214 | 17.3268 | 17.2875 | 17.3086 | 323596.0 |
| 2013-09-26 08:15:00 | AAPL | Stock | 17.2954 | 17.3268 | 17.2932 | 17.3268 | 321328.0 |
| 2013-09-26 08:20:00 | AAPL | Stock | 17.3257 | 17.3268 | 17.3043 | 17.3268 | 144172.0 |
| 2013-09-26 08:25:00 | AAPL | Stock | 17.3268 | 17.3357 | 17.3143 | 17.325 | 147560.0 |
| 2013-09-26 08:30:00 | AAPL | Stock | 17.3261 | 17.3514 | 17.3211 | 17.3375 | 378560.0 |
| 2013-09-26 08:35:00 | AAPL | Stock | 17.3461 | 17.35 | 17.3346 | 17.3393 | 103740.0 |
| 2013-09-26 08:40:00 | AAPL | Stock | 17.3461 | 17.3461 | 17.3214 | 17.3214 | 270620.0 |
| 2013-09-26 08:45:00 | AAPL | Stock | 17.3232 | 17.3232 | 17.3136 | 17.3211 | 152992.0 |
| 2013-09-26 08:50:00 | AAPL | Stock | 17.3157 | 17.3518 | 17.3157 | 17.35 | 174216.0 |
| 2013-09-26 08:55:00 | AAPL | Stock | 17.3475 | 17.3475 | 17.3375 | 17.3389 | 25620.0 |
| 2013-09-26 09:00:00 | AAPL | Stock | 17.3221 | 17.3296 | 17.3214 | 17.3254 | 75572.0 |
| 2013-09-26 09:05:00 | AAPL | Stock | 17.3254 | 17.3254 | 17.3125 | 17.315 | 157836.0 |
| 2013-09-26 09:10:00 | AAPL | Stock | 17.3171 | 17.3246 | 17.3143 | 17.3246 | 97888.0 |
| 2013-09-26 09:15:00 | AAPL | Stock | 17.3214 | 17.3546 | 17.3171 | 17.3521 | 876372.0 |
| 2013-09-26 09:20:00 | AAPL | Stock | 17.3521 | 17.4018 | 17.3471 | 17.4014 | 1309028.0 |
| 2013-09-26 09:25:00 | AAPL | Stock | 17.4014 | 17.4107 | 17.3571 | 17.3611 | 979468.0 |
| 2013-09-26 09:30:00 | AAPL | Stock | 17.3593 | 17.4 | 17.3357 | 17.3743 | 17576496.0 |
| 2013-09-26 09:35:00 | AAPL | Stock | 17.3739 | 17.3843 | 17.3125 | 17.3211 | 7976360.0 |
| 2013-09-26 09:40:00 | AAPL | Stock | 17.3229 | 17.3479 | 17.3036 | 17.3218 | 6217988.0 |
| 2013-09-26 09:45:00 | AAPL | Stock | 17.3282 | 17.3736 | 17.3125 | 17.3675 | 6345136.0 |
| 2013-09-26 09:50:00 | AAPL | Stock | 17.3661 | 17.3687 | 17.3436 | 17.3525 | 5207384.0 |
| 2013-09-26 09:55:00 | AAPL | Stock | 17.3525 | 17.375 | 17.3411 | 17.3636 | 3601920.0 |
| 2013-09-26 10:00:00 | AAPL | Stock | 17.3643 | 17.4375 | 17.3621 | 17.4329 | 12749352.0 |
| 2013-09-26 10:05:00 | AAPL | Stock | 17.4304 | 17.4364 | 17.4111 | 17.4348 | 6643980.0 |
| 2013-09-26 10:10:00 | AAPL | Stock | 17.4336 | 17.4486 | 17.4146 | 17.4175 | 7166684.0 |
| 2013-09-26 10:15:00 | AAPL | Stock | 17.417 | 17.4285 | 17.3939 | 17.4236 | 4246816.0 |
| 2013-09-26 10:20:00 | AAPL | Stock | 17.4256 | 17.4382 | 17.4147 | 17.4321 | 3709944.0 |
| 2013-09-26 10:25:00 | AAPL | Stock | 17.4321 | 17.4411 | 17.4125 | 17.42 | 1882776.0 |
| 2013-09-26 10:30:00 | AAPL | Stock | 17.4207 | 17.4243 | 17.3839 | 17.3971 | 4133612.0 |
| 2013-09-26 10:35:00 | AAPL | Stock | 17.4007 | 17.4064 | 17.3843 | 17.3989 | 2683436.0 |
| 2013-09-26 10:40:00 | AAPL | Stock | 17.3989 | 17.4018 | 17.3646 | 17.375 | 2039548.0 |
| 2013-09-26 10:45:00 | AAPL | Stock | 17.3775 | 17.3843 | 17.3371 | 17.3521 | 4621316.0 |
| 2013-09-26 10:50:00 | AAPL | Stock | 17.3482 | 17.3743 | 17.3371 | 17.3554 | 3058244.0 |
> showing 50 of 338,514 rows — these rows as CSV