PREVIEW / stock_5min / 2010-01-28
file: by_date/stock_5min/2010/2010-01-28.parquet size: 4.8 MB rows: 324,031 symbols: 3,419
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 |
|---|---|---|---|---|---|---|---|
| 2010-01-28 04:35:00 | AAPL | Stock | 7.4464 | 7.4464 | 7.4464 | 7.4464 | 2800.0 |
| 2010-01-28 04:50:00 | AAPL | Stock | 7.4429 | 7.4429 | 7.4429 | 7.4429 | 2800.0 |
| 2010-01-28 04:55:00 | AAPL | Stock | 7.4432 | 7.4432 | 7.4432 | 7.4432 | 7000.0 |
| 2010-01-28 05:00:00 | AAPL | Stock | 7.4482 | 7.4482 | 7.4482 | 7.4482 | 2800.0 |
| 2010-01-28 05:05:00 | AAPL | Stock | 7.4282 | 7.4282 | 7.4204 | 7.4282 | 19600.0 |
| 2010-01-28 05:20:00 | AAPL | Stock | 7.4204 | 7.4204 | 7.4204 | 7.4204 | 10668.0 |
| 2010-01-28 05:25:00 | AAPL | Stock | 7.4107 | 7.4107 | 7.4107 | 7.4107 | 14252.0 |
| 2010-01-28 05:45:00 | AAPL | Stock | 7.4129 | 7.4129 | 7.4129 | 7.4129 | 14000.0 |
| 2010-01-28 06:05:00 | AAPL | Stock | 7.4054 | 7.4054 | 7.4054 | 7.4054 | 2800.0 |
| 2010-01-28 06:35:00 | AAPL | Stock | 7.4079 | 7.4079 | 7.4079 | 7.4079 | 14000.0 |
| 2010-01-28 06:40:00 | AAPL | Stock | 7.4043 | 7.4043 | 7.4036 | 7.4036 | 9800.0 |
| 2010-01-28 06:45:00 | AAPL | Stock | 7.4021 | 7.4021 | 7.3964 | 7.3964 | 23800.0 |
| 2010-01-28 06:50:00 | AAPL | Stock | 7.3964 | 7.3964 | 7.3964 | 7.3964 | 28000.0 |
| 2010-01-28 06:55:00 | AAPL | Stock | 7.3964 | 7.4014 | 7.3929 | 7.3929 | 37800.0 |
| 2010-01-28 07:00:00 | AAPL | Stock | 7.3929 | 7.3964 | 7.3929 | 7.3929 | 81200.0 |
| 2010-01-28 07:05:00 | AAPL | Stock | 7.3929 | 7.3929 | 7.3929 | 7.3929 | 34244.0 |
| 2010-01-28 07:10:00 | AAPL | Stock | 7.3957 | 7.4107 | 7.3932 | 7.4107 | 94668.0 |
| 2010-01-28 07:20:00 | AAPL | Stock | 7.4107 | 7.4107 | 7.3811 | 7.3811 | 50624.0 |
| 2010-01-28 07:25:00 | AAPL | Stock | 7.3811 | 7.3932 | 7.3793 | 7.3932 | 42000.0 |
| 2010-01-28 07:30:00 | AAPL | Stock | 7.3929 | 7.4018 | 7.3929 | 7.4018 | 28476.0 |
| 2010-01-28 07:35:00 | AAPL | Stock | 7.4018 | 7.4093 | 7.4018 | 7.4093 | 24724.0 |
| 2010-01-28 07:40:00 | AAPL | Stock | 7.4 | 7.4089 | 7.4 | 7.4018 | 36400.0 |
| 2010-01-28 07:45:00 | AAPL | Stock | 7.4018 | 7.4025 | 7.4018 | 7.4025 | 8400.0 |
| 2010-01-28 07:50:00 | AAPL | Stock | 7.4018 | 7.4071 | 7.3946 | 7.3946 | 56000.0 |
| 2010-01-28 07:55:00 | AAPL | Stock | 7.3946 | 7.4032 | 7.3929 | 7.4 | 139020.0 |
| 2010-01-28 08:00:00 | AAPL | Stock | 7.3996 | 7.4 | 7.3629 | 7.3679 | 728924.0 |
| 2010-01-28 08:05:00 | AAPL | Stock | 7.3679 | 7.3804 | 7.3679 | 7.3768 | 659204.0 |
| 2010-01-28 08:10:00 | AAPL | Stock | 7.38 | 7.4032 | 7.3786 | 7.3964 | 555408.0 |
| 2010-01-28 08:15:00 | AAPL | Stock | 7.3936 | 7.4071 | 7.3936 | 7.4071 | 441140.0 |
| 2010-01-28 08:20:00 | AAPL | Stock | 7.4068 | 7.41 | 7.4029 | 7.4093 | 570752.0 |
| 2010-01-28 08:25:00 | AAPL | Stock | 7.4071 | 7.4093 | 7.4011 | 7.4018 | 216580.0 |
| 2010-01-28 08:30:00 | AAPL | Stock | 7.4014 | 7.4014 | 7.3857 | 7.3911 | 779856.0 |
| 2010-01-28 08:35:00 | AAPL | Stock | 7.3879 | 7.4 | 7.3875 | 7.3893 | 842100.0 |
| 2010-01-28 08:40:00 | AAPL | Stock | 7.3893 | 7.3907 | 7.3782 | 7.3786 | 588924.0 |
| 2010-01-28 08:45:00 | AAPL | Stock | 7.3786 | 7.3786 | 7.3679 | 7.373 | 645260.0 |
| 2010-01-28 08:50:00 | AAPL | Stock | 7.3718 | 7.3718 | 7.3411 | 7.3411 | 1566600.0 |
| 2010-01-28 08:55:00 | AAPL | Stock | 7.3443 | 7.3571 | 7.34 | 7.34 | 914704.0 |
| 2010-01-28 09:00:00 | AAPL | Stock | 7.3418 | 7.3504 | 7.3354 | 7.3411 | 1352736.0 |
| 2010-01-28 09:05:00 | AAPL | Stock | 7.3421 | 7.3471 | 7.3321 | 7.3357 | 744212.0 |
| 2010-01-28 09:10:00 | AAPL | Stock | 7.3357 | 7.3454 | 7.3304 | 7.3361 | 2369444.0 |
| 2010-01-28 09:15:00 | AAPL | Stock | 7.3393 | 7.3393 | 7.3257 | 7.3339 | 441504.0 |
| 2010-01-28 09:20:00 | AAPL | Stock | 7.3332 | 7.3346 | 7.3196 | 7.3225 | 1276968.0 |
| 2010-01-28 09:25:00 | AAPL | Stock | 7.325 | 7.3332 | 7.3143 | 7.3179 | 3461360.0 |
| 2010-01-28 09:30:00 | AAPL | Stock | 7.3179 | 7.3393 | 7.2668 | 7.2707 | 37321480.0 |
| 2010-01-28 09:35:00 | AAPL | Stock | 7.2711 | 7.2821 | 7.2214 | 7.2264 | 36557136.0 |
| 2010-01-28 09:40:00 | AAPL | Stock | 7.2254 | 7.2286 | 7.1561 | 7.2096 | 49057456.0 |
| 2010-01-28 09:45:00 | AAPL | Stock | 7.2089 | 7.2429 | 7.2082 | 7.2161 | 26136068.0 |
| 2010-01-28 09:50:00 | AAPL | Stock | 7.2143 | 7.2346 | 7.2043 | 7.2089 | 18055772.0 |
| 2010-01-28 09:55:00 | AAPL | Stock | 7.2089 | 7.2229 | 7.1789 | 7.2229 | 23178680.0 |
| 2010-01-28 10:00:00 | AAPL | Stock | 7.2229 | 7.2411 | 7.1964 | 7.1982 | 19503036.0 |
> showing 50 of 324,031 rows — these rows as CSV