PREVIEW / stock_1min / 2013-04-29
file: by_date/stock_1min/2013/2013-04-29.parquet size: 13.0 MB rows: 954,424 symbols: 2,840
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-04-29 04:00:00 | AAPL | Stock | 14.9464 | 15.3286 | 14.9464 | 15.0 | 39564.0 |
| 2013-04-29 04:42:00 | AAPL | Stock | 14.9607 | 14.9607 | 14.9607 | 14.9607 | 2800.0 |
| 2013-04-29 06:09:00 | AAPL | Stock | 14.9786 | 14.9786 | 14.9786 | 14.9786 | 2800.0 |
| 2013-04-29 06:10:00 | AAPL | Stock | 14.9786 | 14.9786 | 14.9754 | 14.9754 | 5600.0 |
| 2013-04-29 06:15:00 | AAPL | Stock | 14.9754 | 14.9786 | 14.9643 | 14.9786 | 15428.0 |
| 2013-04-29 06:42:00 | AAPL | Stock | 14.9818 | 14.9818 | 14.9818 | 14.9818 | 2800.0 |
| 2013-04-29 06:53:00 | AAPL | Stock | 14.9829 | 14.9829 | 14.9811 | 14.9811 | 7056.0 |
| 2013-04-29 06:56:00 | AAPL | Stock | 14.9754 | 14.9754 | 14.9754 | 14.9754 | 4844.0 |
| 2013-04-29 07:02:00 | AAPL | Stock | 14.9732 | 14.9732 | 14.9732 | 14.9732 | 4900.0 |
| 2013-04-29 07:03:00 | AAPL | Stock | 14.9679 | 14.9679 | 14.9643 | 14.9643 | 12264.0 |
| 2013-04-29 07:04:00 | AAPL | Stock | 14.9546 | 14.9643 | 14.9546 | 14.9643 | 14252.0 |
| 2013-04-29 07:05:00 | AAPL | Stock | 14.9636 | 14.9636 | 14.9636 | 14.9636 | 2800.0 |
| 2013-04-29 07:07:00 | AAPL | Stock | 14.9554 | 14.9554 | 14.9554 | 14.9554 | 2800.0 |
| 2013-04-29 07:18:00 | AAPL | Stock | 14.9639 | 14.9804 | 14.9639 | 14.9804 | 27048.0 |
| 2013-04-29 07:19:00 | AAPL | Stock | 14.9646 | 14.9646 | 14.9646 | 14.9646 | 5600.0 |
| 2013-04-29 07:20:00 | AAPL | Stock | 14.9643 | 14.9643 | 14.9643 | 14.9643 | 11200.0 |
| 2013-04-29 07:26:00 | AAPL | Stock | 14.9704 | 14.9704 | 14.9704 | 14.9704 | 2800.0 |
| 2013-04-29 07:28:00 | AAPL | Stock | 14.9711 | 14.9711 | 14.9711 | 14.9711 | 2800.0 |
| 2013-04-29 07:29:00 | AAPL | Stock | 14.9714 | 14.9782 | 14.9714 | 14.9782 | 8400.0 |
| 2013-04-29 07:31:00 | AAPL | Stock | 14.9771 | 14.9779 | 14.9771 | 14.9779 | 14000.0 |
| 2013-04-29 07:33:00 | AAPL | Stock | 14.9775 | 14.9893 | 14.9775 | 14.9893 | 138264.0 |
| 2013-04-29 07:34:00 | AAPL | Stock | 14.9946 | 14.9946 | 14.9921 | 14.9921 | 5600.0 |
| 2013-04-29 07:35:00 | AAPL | Stock | 14.9964 | 15.0079 | 14.9964 | 15.0079 | 99036.0 |
| 2013-04-29 07:36:00 | AAPL | Stock | 15.0007 | 15.0007 | 15.0007 | 15.0007 | 2800.0 |
| 2013-04-29 07:37:00 | AAPL | Stock | 15.0071 | 15.0161 | 15.0071 | 15.0161 | 36400.0 |
| 2013-04-29 07:38:00 | AAPL | Stock | 15.0075 | 15.0118 | 15.0075 | 15.0118 | 8400.0 |
| 2013-04-29 07:39:00 | AAPL | Stock | 15.0139 | 15.0179 | 15.0114 | 15.0179 | 47572.0 |
| 2013-04-29 07:40:00 | AAPL | Stock | 15.0232 | 15.0232 | 15.0214 | 15.0214 | 8400.0 |
| 2013-04-29 07:41:00 | AAPL | Stock | 15.0182 | 15.0182 | 15.0143 | 15.0143 | 14000.0 |
| 2013-04-29 07:42:00 | AAPL | Stock | 15.0071 | 15.0071 | 15.0068 | 15.0068 | 5600.0 |
| 2013-04-29 07:43:00 | AAPL | Stock | 15.0136 | 15.0136 | 15.0025 | 15.0025 | 11200.0 |
| 2013-04-29 07:44:00 | AAPL | Stock | 15.0011 | 15.0011 | 15.0 | 15.0004 | 16800.0 |
| 2013-04-29 07:47:00 | AAPL | Stock | 14.9821 | 14.9857 | 14.9821 | 14.9857 | 11200.0 |
| 2013-04-29 07:48:00 | AAPL | Stock | 14.9814 | 14.9814 | 14.9721 | 14.9793 | 22400.0 |
| 2013-04-29 07:49:00 | AAPL | Stock | 14.9779 | 14.9907 | 14.9779 | 14.9907 | 22400.0 |
| 2013-04-29 07:50:00 | AAPL | Stock | 14.9754 | 14.9754 | 14.9754 | 14.9754 | 5600.0 |
| 2013-04-29 07:51:00 | AAPL | Stock | 14.9911 | 14.9911 | 14.9911 | 14.9911 | 2800.0 |
| 2013-04-29 07:52:00 | AAPL | Stock | 14.9771 | 14.9771 | 14.9771 | 14.9771 | 5600.0 |
| 2013-04-29 07:53:00 | AAPL | Stock | 14.9732 | 14.9732 | 14.9732 | 14.9732 | 2800.0 |
| 2013-04-29 07:54:00 | AAPL | Stock | 14.9736 | 14.9736 | 14.97 | 14.97 | 14000.0 |
| 2013-04-29 07:56:00 | AAPL | Stock | 14.9771 | 14.9771 | 14.9771 | 14.9771 | 2800.0 |
| 2013-04-29 07:58:00 | AAPL | Stock | 14.9754 | 14.9818 | 14.975 | 14.9818 | 11200.0 |
| 2013-04-29 08:00:00 | AAPL | Stock | 14.9729 | 15.0243 | 14.9643 | 14.9893 | 183036.0 |
| 2013-04-29 08:01:00 | AAPL | Stock | 14.9857 | 14.9857 | 14.9854 | 14.9857 | 12348.0 |
| 2013-04-29 08:02:00 | AAPL | Stock | 14.9857 | 14.9929 | 14.9857 | 14.9929 | 54320.0 |
| 2013-04-29 08:03:00 | AAPL | Stock | 14.9964 | 15.0071 | 14.9964 | 15.0036 | 63896.0 |
| 2013-04-29 08:04:00 | AAPL | Stock | 15.0036 | 15.0107 | 15.0036 | 15.0089 | 81480.0 |
| 2013-04-29 08:05:00 | AAPL | Stock | 15.0086 | 15.0104 | 15.0036 | 15.0086 | 45248.0 |
| 2013-04-29 08:06:00 | AAPL | Stock | 15.0018 | 15.0046 | 14.995 | 14.995 | 74284.0 |
| 2013-04-29 08:07:00 | AAPL | Stock | 15.0 | 15.0 | 15.0 | 15.0 | 2800.0 |
> showing 50 of 954,424 rows — these rows as CSV