PREVIEW / stock_5min / 2012-06-12
file: by_date/stock_5min/2012/2012-06-12.parquet size: 4.8 MB rows: 327,825 symbols: 3,512
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 |
|---|---|---|---|---|---|---|---|
| 2012-06-12 04:40:00 | AAPL | Stock | 20.4311 | 20.4311 | 20.4311 | 20.4311 | 2800.0 |
| 2012-06-12 04:55:00 | AAPL | Stock | 20.4582 | 20.4582 | 20.4582 | 20.4582 | 2800.0 |
| 2012-06-12 05:35:00 | AAPL | Stock | 20.4586 | 20.4586 | 20.4586 | 20.4586 | 2800.0 |
| 2012-06-12 05:45:00 | AAPL | Stock | 20.4586 | 20.4586 | 20.4586 | 20.4586 | 2800.0 |
| 2012-06-12 05:50:00 | AAPL | Stock | 20.4854 | 20.4854 | 20.4854 | 20.4854 | 2800.0 |
| 2012-06-12 06:05:00 | AAPL | Stock | 20.5139 | 20.5264 | 20.5139 | 20.5264 | 28000.0 |
| 2012-06-12 06:40:00 | AAPL | Stock | 20.4914 | 20.4914 | 20.4914 | 20.4914 | 2800.0 |
| 2012-06-12 06:50:00 | AAPL | Stock | 20.4904 | 20.4904 | 20.4904 | 20.4904 | 2800.0 |
| 2012-06-12 07:00:00 | AAPL | Stock | 20.4582 | 20.4893 | 20.4536 | 20.4643 | 44352.0 |
| 2012-06-12 07:05:00 | AAPL | Stock | 20.4543 | 20.465 | 20.4375 | 20.465 | 58800.0 |
| 2012-06-12 07:10:00 | AAPL | Stock | 20.4714 | 20.4821 | 20.4714 | 20.4821 | 15680.0 |
| 2012-06-12 07:15:00 | AAPL | Stock | 20.4818 | 20.4925 | 20.4818 | 20.4925 | 63168.0 |
| 2012-06-12 07:20:00 | AAPL | Stock | 20.4839 | 20.4839 | 20.4839 | 20.4839 | 2800.0 |
| 2012-06-12 07:25:00 | AAPL | Stock | 20.4786 | 20.4893 | 20.4643 | 20.4761 | 99008.0 |
| 2012-06-12 07:30:00 | AAPL | Stock | 20.4643 | 20.4786 | 20.4611 | 20.4689 | 50148.0 |
| 2012-06-12 07:35:00 | AAPL | Stock | 20.4643 | 20.4786 | 20.4643 | 20.4786 | 16800.0 |
| 2012-06-12 07:40:00 | AAPL | Stock | 20.4857 | 20.5125 | 20.4857 | 20.5125 | 69328.0 |
| 2012-06-12 07:45:00 | AAPL | Stock | 20.5125 | 20.5325 | 20.5125 | 20.5196 | 217420.0 |
| 2012-06-12 07:50:00 | AAPL | Stock | 20.5129 | 20.5246 | 20.5007 | 20.5025 | 108248.0 |
| 2012-06-12 07:55:00 | AAPL | Stock | 20.495 | 20.5 | 20.4896 | 20.4896 | 38416.0 |
| 2012-06-12 08:00:00 | AAPL | Stock | 20.5 | 20.5229 | 20.4568 | 20.4571 | 339444.0 |
| 2012-06-12 08:05:00 | AAPL | Stock | 20.4561 | 20.4643 | 20.4518 | 20.4636 | 142492.0 |
| 2012-06-12 08:10:00 | AAPL | Stock | 20.4629 | 20.4818 | 20.46 | 20.4743 | 181188.0 |
| 2012-06-12 08:15:00 | AAPL | Stock | 20.4732 | 20.4732 | 20.4639 | 20.4639 | 122612.0 |
| 2012-06-12 08:20:00 | AAPL | Stock | 20.4589 | 20.4732 | 20.4582 | 20.4732 | 127400.0 |
| 2012-06-12 08:25:00 | AAPL | Stock | 20.4754 | 20.4925 | 20.4743 | 20.4846 | 235592.0 |
| 2012-06-12 08:30:00 | AAPL | Stock | 20.4839 | 20.5036 | 20.4786 | 20.4971 | 157584.0 |
| 2012-06-12 08:35:00 | AAPL | Stock | 20.4932 | 20.505 | 20.4686 | 20.4786 | 237384.0 |
| 2012-06-12 08:40:00 | AAPL | Stock | 20.4786 | 20.5 | 20.4786 | 20.4975 | 142492.0 |
| 2012-06-12 08:45:00 | AAPL | Stock | 20.4821 | 20.4889 | 20.4643 | 20.4714 | 174524.0 |
| 2012-06-12 08:50:00 | AAPL | Stock | 20.465 | 20.4729 | 20.4643 | 20.4729 | 75040.0 |
| 2012-06-12 08:55:00 | AAPL | Stock | 20.4729 | 20.4729 | 20.4643 | 20.4646 | 159012.0 |
| 2012-06-12 09:00:00 | AAPL | Stock | 20.4725 | 20.5 | 20.4654 | 20.5 | 289856.0 |
| 2012-06-12 09:05:00 | AAPL | Stock | 20.5 | 20.5071 | 20.4964 | 20.5054 | 217980.0 |
| 2012-06-12 09:10:00 | AAPL | Stock | 20.5071 | 20.5536 | 20.5071 | 20.5482 | 645876.0 |
| 2012-06-12 09:15:00 | AAPL | Stock | 20.5496 | 20.5532 | 20.5218 | 20.5314 | 268912.0 |
| 2012-06-12 09:20:00 | AAPL | Stock | 20.5275 | 20.5425 | 20.5218 | 20.5425 | 355544.0 |
| 2012-06-12 09:25:00 | AAPL | Stock | 20.5436 | 20.5454 | 20.515 | 20.5179 | 794836.0 |
| 2012-06-12 09:30:00 | AAPL | Stock | 20.5179 | 20.5311 | 20.4361 | 20.495 | 16847768.0 |
| 2012-06-12 09:35:00 | AAPL | Stock | 20.4947 | 20.5082 | 20.4232 | 20.4775 | 8937432.0 |
| 2012-06-12 09:40:00 | AAPL | Stock | 20.4814 | 20.5268 | 20.4139 | 20.4993 | 13280820.0 |
| 2012-06-12 09:45:00 | AAPL | Stock | 20.4989 | 20.4989 | 20.3986 | 20.4424 | 10565072.0 |
| 2012-06-12 09:50:00 | AAPL | Stock | 20.445 | 20.485 | 20.4214 | 20.4432 | 7576632.0 |
| 2012-06-12 09:55:00 | AAPL | Stock | 20.4388 | 20.4796 | 20.4018 | 20.4252 | 7970340.0 |
| 2012-06-12 10:00:00 | AAPL | Stock | 20.4214 | 20.4375 | 20.3661 | 20.3661 | 12372584.0 |
| 2012-06-12 10:05:00 | AAPL | Stock | 20.3668 | 20.3911 | 20.2786 | 20.3032 | 17594276.0 |
| 2012-06-12 10:10:00 | AAPL | Stock | 20.3071 | 20.35 | 20.2821 | 20.2986 | 10937892.0 |
| 2012-06-12 10:15:00 | AAPL | Stock | 20.2957 | 20.3446 | 20.2679 | 20.2818 | 8602720.0 |
| 2012-06-12 10:20:00 | AAPL | Stock | 20.2921 | 20.2982 | 20.2393 | 20.2789 | 9344104.0 |
| 2012-06-12 10:25:00 | AAPL | Stock | 20.2835 | 20.3293 | 20.2786 | 20.3118 | 5391568.0 |
> showing 50 of 327,825 rows — these rows as CSV