PREVIEW / stock_1min / 2010-06-29
file: by_date/stock_1min/2010/2010-06-29.parquet size: 13.8 MB rows: 1,054,731 symbols: 2,806
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.5361 | 9.5361 | 5600.0 |
| 2010-06-29 04:19:00 | AAPL | Stock | 9.5039 | 9.5039 | 9.5039 | 9.5039 | 2800.0 |
| 2010-06-29 05:37:00 | AAPL | Stock | 9.5 | 9.5 | 9.5 | 9.5 | 2800.0 |
| 2010-06-29 05:38:00 | AAPL | Stock | 9.5 | 9.5 | 9.5 | 9.5 | 2800.0 |
| 2010-06-29 05:59:00 | AAPL | Stock | 9.5032 | 9.5032 | 9.5032 | 9.5032 | 5600.0 |
| 2010-06-29 06:13:00 | AAPL | Stock | 9.5171 | 9.5171 | 9.5171 | 9.5171 | 2800.0 |
| 2010-06-29 06:26:00 | AAPL | Stock | 9.5175 | 9.5175 | 9.5175 | 9.5175 | 2800.0 |
| 2010-06-29 06:27:00 | AAPL | Stock | 9.5182 | 9.5182 | 9.5182 | 9.5182 | 2800.0 |
| 2010-06-29 06:49: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.505 | 11200.0 |
| 2010-06-29 07:01:00 | AAPL | Stock | 9.505 | 9.5143 | 9.505 | 9.5143 | 8400.0 |
| 2010-06-29 07:02:00 | AAPL | Stock | 9.5071 | 9.5143 | 9.5071 | 9.5118 | 8400.0 |
| 2010-06-29 07:03:00 | AAPL | Stock | 9.5071 | 9.5139 | 9.5068 | 9.5111 | 14000.0 |
| 2010-06-29 07:04:00 | AAPL | Stock | 9.5107 | 9.5107 | 9.5107 | 9.5107 | 5600.0 |
| 2010-06-29 07:05:00 | AAPL | Stock | 9.5107 | 9.5107 | 9.5107 | 9.5107 | 11200.0 |
| 2010-06-29 07:06:00 | AAPL | Stock | 9.5107 | 9.5107 | 9.5107 | 9.5107 | 11200.0 |
| 2010-06-29 07:09:00 | AAPL | Stock | 9.5068 | 9.5068 | 9.5068 | 9.5068 | 2800.0 |
| 2010-06-29 07:10:00 | AAPL | Stock | 9.5068 | 9.5068 | 9.5068 | 9.5068 | 2800.0 |
| 2010-06-29 07:13:00 | AAPL | Stock | 9.5057 | 9.5064 | 9.5046 | 9.5046 | 47600.0 |
| 2010-06-29 07:14:00 | AAPL | Stock | 9.5004 | 9.5004 | 9.5004 | 9.5004 | 11200.0 |
| 2010-06-29 07:21:00 | AAPL | Stock | 9.4996 | 9.4996 | 9.4996 | 9.4996 | 2800.0 |
| 2010-06-29 07:24:00 | AAPL | Stock | 9.4961 | 9.5032 | 9.4904 | 9.4904 | 30800.0 |
| 2010-06-29 07:25:00 | AAPL | Stock | 9.4889 | 9.4889 | 9.4889 | 9.4889 | 2800.0 |
| 2010-06-29 07:26:00 | AAPL | Stock | 9.4839 | 9.4839 | 9.4839 | 9.4839 | 2800.0 |
| 2010-06-29 07:30:00 | AAPL | Stock | 9.4839 | 9.4839 | 9.4839 | 9.4839 | 2800.0 |
| 2010-06-29 07:37:00 | AAPL | Stock | 9.475 | 9.475 | 9.475 | 9.475 | 51408.0 |
| 2010-06-29 07:38:00 | AAPL | Stock | 9.4736 | 9.4736 | 9.4736 | 9.4736 | 8400.0 |
| 2010-06-29 07:39:00 | AAPL | Stock | 9.4686 | 9.4736 | 9.4686 | 9.4736 | 5600.0 |
| 2010-06-29 07:40:00 | AAPL | Stock | 9.4736 | 9.4736 | 9.4736 | 9.4736 | 13440.0 |
| 2010-06-29 07:42:00 | AAPL | Stock | 9.4739 | 9.4821 | 9.4739 | 9.4821 | 15400.0 |
| 2010-06-29 07:43:00 | AAPL | Stock | 9.4757 | 9.4757 | 9.4757 | 9.4757 | 7924.0 |
| 2010-06-29 07:45:00 | AAPL | Stock | 9.4718 | 9.4718 | 9.4718 | 9.4718 | 2800.0 |
| 2010-06-29 07:49:00 | AAPL | Stock | 9.4807 | 9.4807 | 9.4807 | 9.4807 | 5600.0 |
| 2010-06-29 07:50:00 | AAPL | Stock | 9.4811 | 9.4811 | 9.4811 | 9.4811 | 3640.0 |
| 2010-06-29 07:51:00 | AAPL | Stock | 9.4814 | 9.4907 | 9.4814 | 9.49 | 82040.0 |
| 2010-06-29 07:52:00 | AAPL | Stock | 9.4904 | 9.4904 | 9.4904 | 9.4904 | 2800.0 |
| 2010-06-29 07:53:00 | AAPL | Stock | 9.4907 | 9.4932 | 9.4907 | 9.4911 | 16800.0 |
| 2010-06-29 07:55:00 | AAPL | Stock | 9.4893 | 9.4893 | 9.4893 | 9.4893 | 9436.0 |
| 2010-06-29 07:56:00 | AAPL | Stock | 9.4957 | 9.4957 | 9.4957 | 9.4957 | 2800.0 |
| 2010-06-29 07:57:00 | AAPL | Stock | 9.49 | 9.49 | 9.4825 | 9.4825 | 68964.0 |
| 2010-06-29 07:58:00 | AAPL | Stock | 9.4821 | 9.4821 | 9.4821 | 9.4821 | 16800.0 |
| 2010-06-29 07:59:00 | AAPL | Stock | 9.4854 | 9.4854 | 9.4854 | 9.4854 | 2800.0 |
| 2010-06-29 08:00:00 | AAPL | Stock | 9.485 | 9.4964 | 9.4807 | 9.4929 | 122696.0 |
| 2010-06-29 08:01:00 | AAPL | Stock | 9.4829 | 9.4829 | 9.4814 | 9.4814 | 26600.0 |
| 2010-06-29 08:02:00 | AAPL | Stock | 9.4807 | 9.4807 | 9.4689 | 9.4732 | 270284.0 |
| 2010-06-29 08:03:00 | AAPL | Stock | 9.4768 | 9.4768 | 9.4682 | 9.4686 | 92288.0 |
| 2010-06-29 08:04:00 | AAPL | Stock | 9.4682 | 9.4714 | 9.4468 | 9.4482 | 245308.0 |
| 2010-06-29 08:05:00 | AAPL | Stock | 9.4525 | 9.4589 | 9.4464 | 9.4536 | 126280.0 |
| 2010-06-29 08:06:00 | AAPL | Stock | 9.4536 | 9.4582 | 9.4536 | 9.4554 | 81200.0 |
> showing 50 of 1,054,731 rows — these rows as CSV