PREVIEW / stock_5min / 2013-03-27
file: by_date/stock_5min/2013/2013-03-27.parquet size: 4.8 MB rows: 325,092 symbols: 3,468
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-03-27 05:30:00 | AAPL | Stock | 16.4821 | 16.4821 | 16.4821 | 16.4821 | 2800.0 |
| 2013-03-27 05:40:00 | AAPL | Stock | 16.4332 | 16.4332 | 16.4332 | 16.4332 | 26460.0 |
| 2013-03-27 06:30:00 | AAPL | Stock | 16.445 | 16.445 | 16.445 | 16.445 | 2800.0 |
| 2013-03-27 06:35:00 | AAPL | Stock | 16.445 | 16.445 | 16.445 | 16.445 | 9072.0 |
| 2013-03-27 06:40:00 | AAPL | Stock | 16.4293 | 16.4293 | 16.4286 | 16.4286 | 18060.0 |
| 2013-03-27 06:55:00 | AAPL | Stock | 16.4271 | 16.4271 | 16.4271 | 16.4271 | 11200.0 |
| 2013-03-27 07:00:00 | AAPL | Stock | 16.4179 | 16.4179 | 16.4179 | 16.4179 | 2800.0 |
| 2013-03-27 07:05:00 | AAPL | Stock | 16.4279 | 16.4286 | 16.4279 | 16.4286 | 30800.0 |
| 2013-03-27 07:10:00 | AAPL | Stock | 16.4125 | 16.4125 | 16.4125 | 16.4125 | 2800.0 |
| 2013-03-27 07:15:00 | AAPL | Stock | 16.4143 | 16.4143 | 16.4018 | 16.4018 | 11200.0 |
| 2013-03-27 07:20:00 | AAPL | Stock | 16.3975 | 16.3986 | 16.3929 | 16.3929 | 47320.0 |
| 2013-03-27 07:25:00 | AAPL | Stock | 16.3814 | 16.3814 | 16.3571 | 16.3571 | 93408.0 |
| 2013-03-27 07:30:00 | AAPL | Stock | 16.3346 | 16.3482 | 16.3293 | 16.3293 | 93296.0 |
| 2013-03-27 07:35:00 | AAPL | Stock | 16.3336 | 16.3357 | 16.3075 | 16.3336 | 136556.0 |
| 2013-03-27 07:40:00 | AAPL | Stock | 16.3396 | 16.3636 | 16.3214 | 16.3521 | 50680.0 |
| 2013-03-27 07:45:00 | AAPL | Stock | 16.3582 | 16.3582 | 16.3232 | 16.3232 | 93660.0 |
| 2013-03-27 07:50:00 | AAPL | Stock | 16.3357 | 16.3571 | 16.3357 | 16.35 | 18200.0 |
| 2013-03-27 07:55:00 | AAPL | Stock | 16.3586 | 16.375 | 16.3582 | 16.375 | 80696.0 |
| 2013-03-27 08:00:00 | AAPL | Stock | 16.3696 | 16.4464 | 16.3304 | 16.34 | 249620.0 |
| 2013-03-27 08:05:00 | AAPL | Stock | 16.3393 | 16.3561 | 16.33 | 16.33 | 151760.0 |
| 2013-03-27 08:10:00 | AAPL | Stock | 16.3282 | 16.3314 | 16.3136 | 16.3207 | 317884.0 |
| 2013-03-27 08:15:00 | AAPL | Stock | 16.3207 | 16.3364 | 16.3207 | 16.3364 | 143472.0 |
| 2013-03-27 08:20:00 | AAPL | Stock | 16.3393 | 16.3536 | 16.3321 | 16.3325 | 103404.0 |
| 2013-03-27 08:25:00 | AAPL | Stock | 16.3386 | 16.3421 | 16.3343 | 16.3393 | 53200.0 |
| 2013-03-27 08:30:00 | AAPL | Stock | 16.3346 | 16.3536 | 16.3343 | 16.3482 | 79716.0 |
| 2013-03-27 08:35:00 | AAPL | Stock | 16.3536 | 16.3546 | 16.3429 | 16.3514 | 69468.0 |
| 2013-03-27 08:40:00 | AAPL | Stock | 16.3514 | 16.3571 | 16.3461 | 16.3539 | 167888.0 |
| 2013-03-27 08:45:00 | AAPL | Stock | 16.3596 | 16.3646 | 16.3504 | 16.3504 | 108920.0 |
| 2013-03-27 08:50:00 | AAPL | Stock | 16.3514 | 16.3536 | 16.3514 | 16.3536 | 25396.0 |
| 2013-03-27 08:55:00 | AAPL | Stock | 16.3629 | 16.3629 | 16.3511 | 16.3511 | 36400.0 |
| 2013-03-27 09:00:00 | AAPL | Stock | 16.3507 | 16.3571 | 16.3396 | 16.3536 | 132720.0 |
| 2013-03-27 09:05:00 | AAPL | Stock | 16.3414 | 16.355 | 16.3404 | 16.3464 | 145180.0 |
| 2013-03-27 09:10:00 | AAPL | Stock | 16.3407 | 16.3446 | 16.3314 | 16.3314 | 142912.0 |
| 2013-03-27 09:15:00 | AAPL | Stock | 16.3307 | 16.3343 | 16.3214 | 16.3321 | 356216.0 |
| 2013-03-27 09:20:00 | AAPL | Stock | 16.3257 | 16.3364 | 16.325 | 16.325 | 243880.0 |
| 2013-03-27 09:25:00 | AAPL | Stock | 16.3264 | 16.3264 | 16.2975 | 16.3104 | 827008.0 |
| 2013-03-27 09:30:00 | AAPL | Stock | 16.3021 | 16.3143 | 16.1946 | 16.2543 | 26481392.0 |
| 2013-03-27 09:35:00 | AAPL | Stock | 16.2546 | 16.3057 | 16.2507 | 16.2793 | 10106180.0 |
| 2013-03-27 09:40:00 | AAPL | Stock | 16.28 | 16.2893 | 16.2582 | 16.2696 | 7200508.0 |
| 2013-03-27 09:45:00 | AAPL | Stock | 16.2693 | 16.2961 | 16.2393 | 16.2459 | 6754636.0 |
| 2013-03-27 09:50:00 | AAPL | Stock | 16.2432 | 16.2643 | 16.225 | 16.2618 | 5784576.0 |
| 2013-03-27 09:55:00 | AAPL | Stock | 16.2614 | 16.275 | 16.2325 | 16.2379 | 5682628.0 |
| 2013-03-27 10:00:00 | AAPL | Stock | 16.2421 | 16.2493 | 16.2168 | 16.2217 | 7818356.0 |
| 2013-03-27 10:05:00 | AAPL | Stock | 16.2232 | 16.2289 | 16.1793 | 16.1886 | 10321416.0 |
| 2013-03-27 10:10:00 | AAPL | Stock | 16.1861 | 16.1975 | 16.156 | 16.1589 | 7972048.0 |
| 2013-03-27 10:15:00 | AAPL | Stock | 16.1591 | 16.1821 | 16.1554 | 16.1625 | 5232052.0 |
| 2013-03-27 10:20:00 | AAPL | Stock | 16.1614 | 16.1946 | 16.1543 | 16.187 | 4866064.0 |
| 2013-03-27 10:25:00 | AAPL | Stock | 16.1868 | 16.2043 | 16.1829 | 16.195 | 3761240.0 |
| 2013-03-27 10:30:00 | AAPL | Stock | 16.1954 | 16.215 | 16.1893 | 16.2097 | 5267332.0 |
| 2013-03-27 10:35:00 | AAPL | Stock | 16.2086 | 16.2261 | 16.1943 | 16.215 | 3696840.0 |
> showing 50 of 325,092 rows — these rows as CSV