PREVIEW / stock_5min / 2013-06-25
file: by_date/stock_5min/2013/2013-06-25.parquet size: 5.2 MB rows: 349,098 symbols: 3,521
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-06-25 04:10:00 | AAPL | Stock | 14.3789 | 14.3789 | 14.3789 | 14.3789 | 5600.0 |
| 2013-06-25 05:50:00 | AAPL | Stock | 14.4411 | 14.4411 | 14.4182 | 14.4339 | 26936.0 |
| 2013-06-25 05:55:00 | AAPL | Stock | 14.4464 | 14.4464 | 14.4464 | 14.4464 | 5600.0 |
| 2013-06-25 06:00:00 | AAPL | Stock | 14.4643 | 14.4643 | 14.4643 | 14.4643 | 14000.0 |
| 2013-06-25 06:15:00 | AAPL | Stock | 14.4464 | 14.4464 | 14.4464 | 14.4464 | 6636.0 |
| 2013-06-25 06:30:00 | AAPL | Stock | 14.4464 | 14.4625 | 14.4464 | 14.4618 | 11200.0 |
| 2013-06-25 06:45:00 | AAPL | Stock | 14.4643 | 14.4643 | 14.4296 | 14.4296 | 22988.0 |
| 2013-06-25 07:00:00 | AAPL | Stock | 14.4489 | 14.4518 | 14.4489 | 14.4518 | 5600.0 |
| 2013-06-25 07:05:00 | AAPL | Stock | 14.4661 | 14.4686 | 14.4661 | 14.4679 | 28000.0 |
| 2013-06-25 07:10:00 | AAPL | Stock | 14.4686 | 14.4814 | 14.4686 | 14.4814 | 61600.0 |
| 2013-06-25 07:15:00 | AAPL | Stock | 14.4768 | 14.5 | 14.4768 | 14.495 | 100408.0 |
| 2013-06-25 07:20:00 | AAPL | Stock | 14.4932 | 14.4932 | 14.4768 | 14.4768 | 30800.0 |
| 2013-06-25 07:25:00 | AAPL | Stock | 14.4643 | 14.4643 | 14.4611 | 14.4611 | 5600.0 |
| 2013-06-25 07:30:00 | AAPL | Stock | 14.4732 | 14.4768 | 14.47 | 14.47 | 16800.0 |
| 2013-06-25 07:35:00 | AAPL | Stock | 14.4854 | 14.5 | 14.4854 | 14.5 | 72184.0 |
| 2013-06-25 07:40:00 | AAPL | Stock | 14.5071 | 14.5157 | 14.5029 | 14.5086 | 76832.0 |
| 2013-06-25 07:45:00 | AAPL | Stock | 14.5068 | 14.5071 | 14.5068 | 14.5071 | 5600.0 |
| 2013-06-25 07:50:00 | AAPL | Stock | 14.5139 | 14.5139 | 14.5071 | 14.5071 | 25200.0 |
| 2013-06-25 08:00:00 | AAPL | Stock | 14.4929 | 14.5071 | 14.3571 | 14.475 | 162596.0 |
| 2013-06-25 08:05:00 | AAPL | Stock | 14.4679 | 14.4679 | 14.4482 | 14.4571 | 177212.0 |
| 2013-06-25 08:10:00 | AAPL | Stock | 14.4479 | 14.4732 | 14.4479 | 14.4732 | 86800.0 |
| 2013-06-25 08:15:00 | AAPL | Stock | 14.4725 | 14.4789 | 14.4621 | 14.4789 | 47600.0 |
| 2013-06-25 08:20:00 | AAPL | Stock | 14.4768 | 14.4786 | 14.4464 | 14.4464 | 117040.0 |
| 2013-06-25 08:25:00 | AAPL | Stock | 14.4471 | 14.4554 | 14.4429 | 14.4536 | 94696.0 |
| 2013-06-25 08:30:00 | AAPL | Stock | 14.4536 | 14.4643 | 14.4536 | 14.4643 | 22232.0 |
| 2013-06-25 08:35:00 | AAPL | Stock | 14.4589 | 14.4646 | 14.4589 | 14.4643 | 19796.0 |
| 2013-06-25 08:40:00 | AAPL | Stock | 14.4646 | 14.4775 | 14.4643 | 14.4775 | 74452.0 |
| 2013-06-25 08:45:00 | AAPL | Stock | 14.4782 | 14.4836 | 14.4711 | 14.4732 | 89376.0 |
| 2013-06-25 08:50:00 | AAPL | Stock | 14.4757 | 14.4786 | 14.465 | 14.465 | 115388.0 |
| 2013-06-25 08:55:00 | AAPL | Stock | 14.47 | 14.4736 | 14.4639 | 14.4736 | 53200.0 |
| 2013-06-25 09:00:00 | AAPL | Stock | 14.4714 | 14.4754 | 14.4707 | 14.4714 | 61600.0 |
| 2013-06-25 09:05:00 | AAPL | Stock | 14.4686 | 14.4839 | 14.4686 | 14.4821 | 116340.0 |
| 2013-06-25 09:10:00 | AAPL | Stock | 14.4846 | 14.4929 | 14.4839 | 14.4893 | 357448.0 |
| 2013-06-25 09:15:00 | AAPL | Stock | 14.4893 | 14.4911 | 14.4789 | 14.4796 | 256284.0 |
| 2013-06-25 09:20:00 | AAPL | Stock | 14.4857 | 14.5004 | 14.4839 | 14.4975 | 194404.0 |
| 2013-06-25 09:25:00 | AAPL | Stock | 14.4929 | 14.5036 | 14.4839 | 14.4839 | 113344.0 |
| 2013-06-25 09:30:00 | AAPL | Stock | 14.48 | 14.5639 | 14.4561 | 14.5236 | 16314172.0 |
| 2013-06-25 09:35:00 | AAPL | Stock | 14.5236 | 14.53 | 14.4761 | 14.5014 | 5823440.0 |
| 2013-06-25 09:40:00 | AAPL | Stock | 14.5032 | 14.5089 | 14.415 | 14.4332 | 8222872.0 |
| 2013-06-25 09:45:00 | AAPL | Stock | 14.4357 | 14.4411 | 14.3943 | 14.4164 | 8790628.0 |
| 2013-06-25 09:50:00 | AAPL | Stock | 14.4118 | 14.4264 | 14.3332 | 14.335 | 8657236.0 |
| 2013-06-25 09:55:00 | AAPL | Stock | 14.3354 | 14.3682 | 14.3321 | 14.365 | 5130244.0 |
| 2013-06-25 10:00:00 | AAPL | Stock | 14.3634 | 14.3929 | 14.35 | 14.375 | 6624576.0 |
| 2013-06-25 10:05:00 | AAPL | Stock | 14.3746 | 14.3804 | 14.3346 | 14.3418 | 6349952.0 |
| 2013-06-25 10:10:00 | AAPL | Stock | 14.3393 | 14.3546 | 14.2982 | 14.3011 | 7354788.0 |
| 2013-06-25 10:15:00 | AAPL | Stock | 14.3053 | 14.3193 | 14.2982 | 14.3114 | 5103308.0 |
| 2013-06-25 10:20:00 | AAPL | Stock | 14.3066 | 14.3114 | 14.2739 | 14.293 | 8005088.0 |
| 2013-06-25 10:25:00 | AAPL | Stock | 14.2904 | 14.3104 | 14.2439 | 14.2482 | 7823228.0 |
| 2013-06-25 10:30:00 | AAPL | Stock | 14.2496 | 14.2782 | 14.245 | 14.27 | 5553464.0 |
| 2013-06-25 10:35:00 | AAPL | Stock | 14.2704 | 14.3211 | 14.2564 | 14.3107 | 6984348.0 |
> showing 50 of 349,098 rows — these rows as CSV