PREVIEW / stock_5min / 2008-10-22
file: by_date/stock_5min/2008/2008-10-22.parquet size: 4.4 MB rows: 313,148 symbols: 3,319
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 |
|---|---|---|---|---|---|---|---|
| 2008-10-22 04:15:00 | AAPL | Stock | 3.5711 | 3.6071 | 3.5711 | 3.6071 | 8400.0 |
| 2008-10-22 04:25:00 | AAPL | Stock | 3.5929 | 3.5929 | 3.5929 | 3.5929 | 2800.0 |
| 2008-10-22 04:30:00 | AAPL | Stock | 3.5929 | 3.5929 | 3.5929 | 3.5929 | 2800.0 |
| 2008-10-22 04:45:00 | AAPL | Stock | 3.5921 | 3.5921 | 3.5921 | 3.5921 | 16800.0 |
| 2008-10-22 04:50:00 | AAPL | Stock | 3.5921 | 3.5921 | 3.5896 | 3.5896 | 16800.0 |
| 2008-10-22 04:55:00 | AAPL | Stock | 3.5896 | 3.5896 | 3.5893 | 3.5893 | 5600.0 |
| 2008-10-22 05:10:00 | AAPL | Stock | 3.5832 | 3.5832 | 3.5832 | 3.5832 | 2800.0 |
| 2008-10-22 05:15:00 | AAPL | Stock | 3.5832 | 3.5832 | 3.5786 | 3.5786 | 48440.0 |
| 2008-10-22 05:20:00 | AAPL | Stock | 3.5714 | 3.5714 | 3.5714 | 3.5714 | 2800.0 |
| 2008-10-22 05:35:00 | AAPL | Stock | 3.5779 | 3.5786 | 3.5779 | 3.5786 | 8400.0 |
| 2008-10-22 05:50:00 | AAPL | Stock | 3.56 | 3.56 | 3.56 | 3.56 | 2800.0 |
| 2008-10-22 05:55:00 | AAPL | Stock | 3.5768 | 3.5786 | 3.5768 | 3.5786 | 7280.0 |
| 2008-10-22 06:00:00 | AAPL | Stock | 3.5725 | 3.5979 | 3.5725 | 3.5979 | 27888.0 |
| 2008-10-22 06:05:00 | AAPL | Stock | 3.6025 | 3.6196 | 3.6025 | 3.6071 | 42952.0 |
| 2008-10-22 06:10:00 | AAPL | Stock | 3.6161 | 3.6214 | 3.6071 | 3.6071 | 16800.0 |
| 2008-10-22 06:15:00 | AAPL | Stock | 3.6071 | 3.6071 | 3.6071 | 3.6071 | 28000.0 |
| 2008-10-22 06:20:00 | AAPL | Stock | 3.6007 | 3.6011 | 3.5911 | 3.5911 | 81200.0 |
| 2008-10-22 06:25:00 | AAPL | Stock | 3.5993 | 3.6046 | 3.5993 | 3.6018 | 103600.0 |
| 2008-10-22 06:30:00 | AAPL | Stock | 3.6007 | 3.6007 | 3.5911 | 3.5911 | 65352.0 |
| 2008-10-22 06:35:00 | AAPL | Stock | 3.5879 | 3.5879 | 3.5821 | 3.5821 | 112252.0 |
| 2008-10-22 06:40:00 | AAPL | Stock | 3.5821 | 3.5979 | 3.5714 | 3.5714 | 119560.0 |
| 2008-10-22 06:45:00 | AAPL | Stock | 3.5732 | 3.5786 | 3.5607 | 3.5607 | 89600.0 |
| 2008-10-22 06:50:00 | AAPL | Stock | 3.58 | 3.5857 | 3.5714 | 3.5714 | 259084.0 |
| 2008-10-22 06:55:00 | AAPL | Stock | 3.5714 | 3.5804 | 3.5643 | 3.5714 | 538160.0 |
| 2008-10-22 07:00:00 | AAPL | Stock | 3.5714 | 3.5718 | 3.5536 | 3.5536 | 746620.0 |
| 2008-10-22 07:05:00 | AAPL | Stock | 3.5604 | 3.5714 | 3.5575 | 3.5607 | 232680.0 |
| 2008-10-22 07:10:00 | AAPL | Stock | 3.5657 | 3.575 | 3.5575 | 3.5575 | 465584.0 |
| 2008-10-22 07:15:00 | AAPL | Stock | 3.5571 | 3.5571 | 3.4893 | 3.4929 | 1179864.0 |
| 2008-10-22 07:20:00 | AAPL | Stock | 3.4946 | 3.5082 | 3.475 | 3.475 | 989296.0 |
| 2008-10-22 07:25:00 | AAPL | Stock | 3.4818 | 3.5179 | 3.4768 | 3.5179 | 523544.0 |
| 2008-10-22 07:30:00 | AAPL | Stock | 3.5125 | 3.5214 | 3.5018 | 3.5136 | 1251180.0 |
| 2008-10-22 07:35:00 | AAPL | Stock | 3.5139 | 3.5607 | 3.5114 | 3.5607 | 1406160.0 |
| 2008-10-22 07:40:00 | AAPL | Stock | 3.5461 | 3.5607 | 3.5461 | 3.55 | 939876.0 |
| 2008-10-22 07:45:00 | AAPL | Stock | 3.5504 | 3.5536 | 3.5429 | 3.5439 | 1316756.0 |
| 2008-10-22 07:50:00 | AAPL | Stock | 3.5446 | 3.5446 | 3.5232 | 3.5286 | 727524.0 |
| 2008-10-22 07:55:00 | AAPL | Stock | 3.5257 | 3.5318 | 3.5196 | 3.5296 | 2184840.0 |
| 2008-10-22 08:00:00 | AAPL | Stock | 3.5893 | 3.5893 | 3.4946 | 3.5704 | 5655300.0 |
| 2008-10-22 08:05:00 | AAPL | Stock | 3.5686 | 3.6243 | 3.5571 | 3.6086 | 4610928.0 |
| 2008-10-22 08:10:00 | AAPL | Stock | 3.6071 | 3.6286 | 3.5793 | 3.6161 | 3800160.0 |
| 2008-10-22 08:15:00 | AAPL | Stock | 3.6171 | 3.6179 | 3.5789 | 3.5893 | 4277840.0 |
| 2008-10-22 08:20:00 | AAPL | Stock | 3.5889 | 3.5964 | 3.5789 | 3.5929 | 2964976.0 |
| 2008-10-22 08:25:00 | AAPL | Stock | 3.5957 | 3.5964 | 3.5689 | 3.5832 | 4741996.0 |
| 2008-10-22 08:30:00 | AAPL | Stock | 3.5829 | 3.5896 | 3.5764 | 3.5771 | 1931608.0 |
| 2008-10-22 08:35:00 | AAPL | Stock | 3.5782 | 3.5879 | 3.5711 | 3.5871 | 2514176.0 |
| 2008-10-22 08:40:00 | AAPL | Stock | 3.5846 | 3.5954 | 3.5786 | 3.5836 | 1541596.0 |
| 2008-10-22 08:45:00 | AAPL | Stock | 3.5839 | 3.5907 | 3.5607 | 3.5611 | 4947908.0 |
| 2008-10-22 08:50:00 | AAPL | Stock | 3.5607 | 3.5696 | 3.5275 | 3.5375 | 6715688.0 |
| 2008-10-22 08:55:00 | AAPL | Stock | 3.5368 | 3.5446 | 3.5232 | 3.5236 | 3487988.0 |
| 2008-10-22 09:00:00 | AAPL | Stock | 3.5239 | 3.5407 | 3.5232 | 3.5371 | 3959732.0 |
| 2008-10-22 09:05:00 | AAPL | Stock | 3.5364 | 3.5386 | 3.52 | 3.5246 | 4139240.0 |
> showing 50 of 313,148 rows — these rows as CSV