PREVIEW / stock_5min / 2010-06-29
file: by_date/stock_5min/2010/2010-06-29.parquet size: 4.9 MB rows: 340,528 symbols: 3,460
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-06-29 04:15:00 | AAPL | Stock | 9.5396 | 9.5396 | 9.5039 | 9.5039 | 8400.0 |
| 2010-06-29 05:35:00 | AAPL | Stock | 9.5 | 9.5 | 9.5 | 9.5 | 5600.0 |
| 2010-06-29 05:55:00 | AAPL | Stock | 9.5032 | 9.5032 | 9.5032 | 9.5032 | 5600.0 |
| 2010-06-29 06:10:00 | AAPL | Stock | 9.5171 | 9.5171 | 9.5171 | 9.5171 | 2800.0 |
| 2010-06-29 06:25:00 | AAPL | Stock | 9.5175 | 9.5182 | 9.5175 | 9.5182 | 5600.0 |
| 2010-06-29 06:45:00 | AAPL | Stock | 9.5143 | 9.5143 | 9.5143 | 9.5143 | 8400.0 |
| 2010-06-29 06:50:00 | AAPL | Stock | 9.5143 | 9.5143 | 9.5143 | 9.5143 | 2800.0 |
| 2010-06-29 07:00:00 | AAPL | Stock | 9.5143 | 9.5143 | 9.505 | 9.5107 | 47600.0 |
| 2010-06-29 07:05:00 | AAPL | Stock | 9.5107 | 9.5107 | 9.5068 | 9.5068 | 25200.0 |
| 2010-06-29 07:10:00 | AAPL | Stock | 9.5068 | 9.5068 | 9.5004 | 9.5004 | 61600.0 |
| 2010-06-29 07:20:00 | AAPL | Stock | 9.4996 | 9.5032 | 9.4904 | 9.4904 | 33600.0 |
| 2010-06-29 07:25:00 | AAPL | Stock | 9.4889 | 9.4889 | 9.4839 | 9.4839 | 5600.0 |
| 2010-06-29 07:30:00 | AAPL | Stock | 9.4839 | 9.4839 | 9.4839 | 9.4839 | 2800.0 |
| 2010-06-29 07:35:00 | AAPL | Stock | 9.475 | 9.475 | 9.4686 | 9.4736 | 65408.0 |
| 2010-06-29 07:40:00 | AAPL | Stock | 9.4736 | 9.4821 | 9.4736 | 9.4757 | 36764.0 |
| 2010-06-29 07:45:00 | AAPL | Stock | 9.4718 | 9.4807 | 9.4718 | 9.4807 | 8400.0 |
| 2010-06-29 07:50:00 | AAPL | Stock | 9.4811 | 9.4932 | 9.4811 | 9.4911 | 105280.0 |
| 2010-06-29 07:55:00 | AAPL | Stock | 9.4893 | 9.4957 | 9.4821 | 9.4854 | 100800.0 |
| 2010-06-29 08:00:00 | AAPL | Stock | 9.485 | 9.4964 | 9.4468 | 9.4482 | 757176.0 |
| 2010-06-29 08:05:00 | AAPL | Stock | 9.4525 | 9.4786 | 9.4464 | 9.47 | 571900.0 |
| 2010-06-29 08:10:00 | AAPL | Stock | 9.4729 | 9.4732 | 9.4557 | 9.4607 | 428344.0 |
| 2010-06-29 08:15:00 | AAPL | Stock | 9.4632 | 9.4636 | 9.4511 | 9.4604 | 307328.0 |
| 2010-06-29 08:20:00 | AAPL | Stock | 9.4607 | 9.4661 | 9.4564 | 9.4604 | 403060.0 |
| 2010-06-29 08:25:00 | AAPL | Stock | 9.46 | 9.4639 | 9.4514 | 9.4529 | 423220.0 |
| 2010-06-29 08:30:00 | AAPL | Stock | 9.4536 | 9.4618 | 9.45 | 9.4536 | 361116.0 |
| 2010-06-29 08:35:00 | AAPL | Stock | 9.4512 | 9.4559 | 9.425 | 9.4346 | 763420.0 |
| 2010-06-29 08:40:00 | AAPL | Stock | 9.4357 | 9.4407 | 9.4275 | 9.4307 | 596736.0 |
| 2010-06-29 08:45:00 | AAPL | Stock | 9.4275 | 9.4495 | 9.4275 | 9.4432 | 281456.0 |
| 2010-06-29 08:50:00 | AAPL | Stock | 9.4464 | 9.4536 | 9.4464 | 9.4475 | 249200.0 |
| 2010-06-29 08:55:00 | AAPL | Stock | 9.4489 | 9.4525 | 9.4464 | 9.4511 | 223384.0 |
| 2010-06-29 09:00:00 | AAPL | Stock | 9.4518 | 9.4671 | 9.4518 | 9.4529 | 606480.0 |
| 2010-06-29 09:05:00 | AAPL | Stock | 9.45 | 9.4618 | 9.4393 | 9.4393 | 475524.0 |
| 2010-06-29 09:10:00 | AAPL | Stock | 9.4429 | 9.4536 | 9.4393 | 9.4536 | 163128.0 |
| 2010-06-29 09:15:00 | AAPL | Stock | 9.4486 | 9.4596 | 9.4482 | 9.4543 | 205100.0 |
| 2010-06-29 09:20:00 | AAPL | Stock | 9.4546 | 9.4582 | 9.4518 | 9.4582 | 157864.0 |
| 2010-06-29 09:25:00 | AAPL | Stock | 9.4539 | 9.4596 | 9.4329 | 9.4364 | 318808.0 |
| 2010-06-29 09:30:00 | AAPL | Stock | 9.4364 | 9.4425 | 9.4046 | 9.4314 | 28426692.0 |
| 2010-06-29 09:35:00 | AAPL | Stock | 9.43 | 9.4346 | 9.3739 | 9.3779 | 19488364.0 |
| 2010-06-29 09:40:00 | AAPL | Stock | 9.3789 | 9.3804 | 9.3082 | 9.3372 | 34620628.0 |
| 2010-06-29 09:45:00 | AAPL | Stock | 9.3364 | 9.3486 | 9.2525 | 9.2629 | 41907712.0 |
| 2010-06-29 09:50:00 | AAPL | Stock | 9.2636 | 9.2675 | 9.2146 | 9.2536 | 43201340.0 |
| 2010-06-29 09:55:00 | AAPL | Stock | 9.2529 | 9.272 | 9.2257 | 9.2618 | 26069316.0 |
| 2010-06-29 10:00:00 | AAPL | Stock | 9.2611 | 9.2662 | 9.1889 | 9.1952 | 43978900.0 |
| 2010-06-29 10:05:00 | AAPL | Stock | 9.1954 | 9.228 | 9.1807 | 9.2179 | 24273620.0 |
| 2010-06-29 10:10:00 | AAPL | Stock | 9.2161 | 9.2304 | 9.2071 | 9.2225 | 17663744.0 |
| 2010-06-29 10:15:00 | AAPL | Stock | 9.2229 | 9.2246 | 9.1911 | 9.2125 | 16164624.0 |
| 2010-06-29 10:20:00 | AAPL | Stock | 9.2123 | 9.2232 | 9.189 | 9.2138 | 16185176.0 |
| 2010-06-29 10:25:00 | AAPL | Stock | 9.2107 | 9.2111 | 9.1268 | 9.1271 | 34186740.0 |
| 2010-06-29 10:30:00 | AAPL | Stock | 9.1315 | 9.165 | 9.1157 | 9.1502 | 21603876.0 |
| 2010-06-29 10:35:00 | AAPL | Stock | 9.151 | 9.1696 | 9.1429 | 9.1586 | 13833260.0 |
> showing 50 of 340,528 rows — these rows as CSV