PREVIEW / stock_1min / 2012-07-10
file: by_date/stock_1min/2012/2012-07-10.parquet size: 12.4 MB rows: 912,663 symbols: 2,837
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-07-10 04:03:00 | AAPL | Stock | 21.8775 | 21.8775 | 21.8775 | 21.8775 | 11200.0 |
| 2012-07-10 04:05:00 | AAPL | Stock | 21.8782 | 21.8789 | 21.8782 | 21.8789 | 5600.0 |
| 2012-07-10 04:23:00 | AAPL | Stock | 21.8775 | 21.8775 | 21.8775 | 21.8775 | 2800.0 |
| 2012-07-10 05:19:00 | AAPL | Stock | 21.9657 | 21.9657 | 21.9654 | 21.9654 | 14000.0 |
| 2012-07-10 05:21:00 | AAPL | Stock | 21.9657 | 21.9657 | 21.9654 | 21.9654 | 5600.0 |
| 2012-07-10 05:22:00 | AAPL | Stock | 21.9654 | 21.9654 | 21.9654 | 21.9654 | 2800.0 |
| 2012-07-10 05:25:00 | AAPL | Stock | 21.9654 | 21.975 | 21.965 | 21.975 | 11200.0 |
| 2012-07-10 05:30:00 | AAPL | Stock | 21.975 | 21.975 | 21.975 | 21.975 | 2800.0 |
| 2012-07-10 05:32:00 | AAPL | Stock | 21.9964 | 21.9964 | 21.9964 | 21.9964 | 5600.0 |
| 2012-07-10 05:33:00 | AAPL | Stock | 21.9964 | 21.9964 | 21.9964 | 21.9964 | 8372.0 |
| 2012-07-10 05:55:00 | AAPL | Stock | 22.0321 | 22.0321 | 22.0321 | 22.0321 | 2800.0 |
| 2012-07-10 06:11:00 | AAPL | Stock | 21.9893 | 21.9893 | 21.9893 | 21.9893 | 25200.0 |
| 2012-07-10 06:12:00 | AAPL | Stock | 21.9893 | 21.9893 | 21.9839 | 21.9839 | 16800.0 |
| 2012-07-10 06:13:00 | AAPL | Stock | 21.9889 | 21.9889 | 21.9889 | 21.9889 | 4480.0 |
| 2012-07-10 06:14:00 | AAPL | Stock | 21.9889 | 21.9893 | 21.9889 | 21.9893 | 11200.0 |
| 2012-07-10 06:19:00 | AAPL | Stock | 21.9893 | 21.9893 | 21.9893 | 21.9893 | 2800.0 |
| 2012-07-10 06:21:00 | AAPL | Stock | 21.9893 | 21.9893 | 21.9893 | 21.9893 | 39256.0 |
| 2012-07-10 06:22:00 | AAPL | Stock | 21.9857 | 21.9893 | 21.9821 | 21.9893 | 12040.0 |
| 2012-07-10 06:26:00 | AAPL | Stock | 21.9893 | 21.9893 | 21.9893 | 21.9893 | 9100.0 |
| 2012-07-10 07:00:00 | AAPL | Stock | 22.0139 | 22.0143 | 22.0139 | 22.0143 | 11200.0 |
| 2012-07-10 07:01:00 | AAPL | Stock | 22.0071 | 22.0104 | 21.9946 | 22.0104 | 26040.0 |
| 2012-07-10 07:03:00 | AAPL | Stock | 22.0232 | 22.0243 | 22.0232 | 22.0243 | 5600.0 |
| 2012-07-10 07:04:00 | AAPL | Stock | 22.0239 | 22.0243 | 22.0018 | 22.0179 | 56196.0 |
| 2012-07-10 07:05:00 | AAPL | Stock | 22.0179 | 22.0179 | 22.0179 | 22.0179 | 8400.0 |
| 2012-07-10 07:06:00 | AAPL | Stock | 22.0175 | 22.0321 | 22.0175 | 22.0321 | 124880.0 |
| 2012-07-10 07:07:00 | AAPL | Stock | 22.0393 | 22.0393 | 22.0214 | 22.0332 | 44800.0 |
| 2012-07-10 07:08:00 | AAPL | Stock | 22.0232 | 22.035 | 22.0179 | 22.0268 | 207396.0 |
| 2012-07-10 07:09:00 | AAPL | Stock | 22.0268 | 22.0268 | 22.0107 | 22.0179 | 56560.0 |
| 2012-07-10 07:11:00 | AAPL | Stock | 22.0107 | 22.0129 | 22.0107 | 22.0129 | 23856.0 |
| 2012-07-10 07:13:00 | AAPL | Stock | 22.0107 | 22.0107 | 21.9904 | 21.9929 | 62412.0 |
| 2012-07-10 07:14:00 | AAPL | Stock | 21.9921 | 21.9921 | 21.9804 | 21.9804 | 78400.0 |
| 2012-07-10 07:15:00 | AAPL | Stock | 21.9861 | 21.9861 | 21.9861 | 21.9861 | 11200.0 |
| 2012-07-10 07:16:00 | AAPL | Stock | 21.9893 | 21.9893 | 21.9643 | 21.9643 | 97972.0 |
| 2012-07-10 07:17:00 | AAPL | Stock | 21.9729 | 21.9732 | 21.9729 | 21.9732 | 5600.0 |
| 2012-07-10 07:18:00 | AAPL | Stock | 21.9732 | 21.9732 | 21.9625 | 21.9625 | 97160.0 |
| 2012-07-10 07:20:00 | AAPL | Stock | 21.9714 | 21.9714 | 21.9714 | 21.9714 | 2800.0 |
| 2012-07-10 07:22:00 | AAPL | Stock | 21.9889 | 21.9929 | 21.9889 | 21.9929 | 25200.0 |
| 2012-07-10 07:24:00 | AAPL | Stock | 21.9879 | 21.9907 | 21.9879 | 21.9907 | 11200.0 |
| 2012-07-10 07:25:00 | AAPL | Stock | 21.9893 | 21.9893 | 21.9893 | 21.9893 | 2800.0 |
| 2012-07-10 07:26:00 | AAPL | Stock | 21.9907 | 21.9925 | 21.9907 | 21.9911 | 60928.0 |
| 2012-07-10 07:27:00 | AAPL | Stock | 21.9886 | 21.9886 | 21.9886 | 21.9886 | 2800.0 |
| 2012-07-10 07:29:00 | AAPL | Stock | 21.9829 | 21.9829 | 21.9821 | 21.9829 | 11200.0 |
| 2012-07-10 07:30:00 | AAPL | Stock | 21.9821 | 21.9821 | 21.9725 | 21.9725 | 5600.0 |
| 2012-07-10 07:31:00 | AAPL | Stock | 21.9804 | 21.9818 | 21.98 | 21.9818 | 8400.0 |
| 2012-07-10 07:32:00 | AAPL | Stock | 21.9829 | 21.9829 | 21.9821 | 21.9821 | 32200.0 |
| 2012-07-10 07:34:00 | AAPL | Stock | 21.9857 | 21.9925 | 21.9857 | 21.9925 | 22400.0 |
| 2012-07-10 07:35:00 | AAPL | Stock | 21.9918 | 21.9918 | 21.9918 | 21.9918 | 2800.0 |
| 2012-07-10 07:36:00 | AAPL | Stock | 21.9925 | 21.9925 | 21.9918 | 21.9918 | 5880.0 |
| 2012-07-10 07:38:00 | AAPL | Stock | 21.9911 | 21.9925 | 21.9911 | 21.9925 | 12068.0 |
| 2012-07-10 07:39:00 | AAPL | Stock | 21.9925 | 21.9929 | 21.9893 | 21.9893 | 76748.0 |
> showing 50 of 912,663 rows — these rows as CSV