PREVIEW / stock_1min / 2011-07-15
file: by_date/stock_1min/2011/2011-07-15.parquet size: 12.6 MB rows: 951,414 symbols: 2,855
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 |
|---|---|---|---|---|---|---|---|
| 2011-07-15 04:03:00 | AAPL | Stock | 12.7989 | 12.7989 | 12.7989 | 12.7989 | 5600.0 |
| 2011-07-15 04:08:00 | AAPL | Stock | 12.8207 | 12.8221 | 12.8207 | 12.8221 | 5600.0 |
| 2011-07-15 04:12:00 | AAPL | Stock | 12.8171 | 12.8171 | 12.8171 | 12.8171 | 2800.0 |
| 2011-07-15 04:29:00 | AAPL | Stock | 12.825 | 12.825 | 12.825 | 12.825 | 3500.0 |
| 2011-07-15 04:40:00 | AAPL | Stock | 12.8214 | 12.8214 | 12.8214 | 12.8214 | 2800.0 |
| 2011-07-15 05:31:00 | AAPL | Stock | 12.8643 | 12.8643 | 12.8643 | 12.8643 | 2800.0 |
| 2011-07-15 05:36:00 | AAPL | Stock | 12.8636 | 12.8636 | 12.8636 | 12.8636 | 5600.0 |
| 2011-07-15 07:00:00 | AAPL | Stock | 12.8732 | 12.8732 | 12.8732 | 12.8732 | 2800.0 |
| 2011-07-15 07:02:00 | AAPL | Stock | 12.8746 | 12.8775 | 12.8746 | 12.8775 | 8400.0 |
| 2011-07-15 07:03:00 | AAPL | Stock | 12.8639 | 12.875 | 12.8639 | 12.875 | 5600.0 |
| 2011-07-15 07:05:00 | AAPL | Stock | 12.8796 | 12.8796 | 12.8786 | 12.8786 | 5600.0 |
| 2011-07-15 07:10:00 | AAPL | Stock | 12.8739 | 12.8739 | 12.8739 | 12.8739 | 2800.0 |
| 2011-07-15 07:12:00 | AAPL | Stock | 12.8718 | 12.8718 | 12.8718 | 12.8718 | 19600.0 |
| 2011-07-15 07:14:00 | AAPL | Stock | 12.8679 | 12.87 | 12.8679 | 12.87 | 22400.0 |
| 2011-07-15 07:16:00 | AAPL | Stock | 12.8704 | 12.8704 | 12.8679 | 12.8679 | 10976.0 |
| 2011-07-15 07:20:00 | AAPL | Stock | 12.8818 | 12.8818 | 12.8818 | 12.8818 | 5600.0 |
| 2011-07-15 07:21:00 | AAPL | Stock | 12.8804 | 12.8839 | 12.8804 | 12.8839 | 14000.0 |
| 2011-07-15 07:22:00 | AAPL | Stock | 12.8861 | 12.8861 | 12.8804 | 12.8804 | 5600.0 |
| 2011-07-15 07:24:00 | AAPL | Stock | 12.8893 | 12.9107 | 12.8804 | 12.9104 | 52360.0 |
| 2011-07-15 07:25:00 | AAPL | Stock | 12.9107 | 12.9189 | 12.9107 | 12.9121 | 25760.0 |
| 2011-07-15 07:26:00 | AAPL | Stock | 12.9182 | 12.9182 | 12.9121 | 12.9121 | 19600.0 |
| 2011-07-15 07:27:00 | AAPL | Stock | 12.9221 | 12.9225 | 12.9221 | 12.9225 | 5600.0 |
| 2011-07-15 07:28:00 | AAPL | Stock | 12.9279 | 12.9286 | 12.9271 | 12.9286 | 28000.0 |
| 2011-07-15 07:30:00 | AAPL | Stock | 12.9289 | 12.9289 | 12.9289 | 12.9289 | 11200.0 |
| 2011-07-15 07:31:00 | AAPL | Stock | 12.925 | 12.9257 | 12.9214 | 12.9214 | 11200.0 |
| 2011-07-15 07:32:00 | AAPL | Stock | 12.9107 | 12.9107 | 12.9107 | 12.9107 | 27132.0 |
| 2011-07-15 07:38:00 | AAPL | Stock | 12.91 | 12.9107 | 12.91 | 12.9107 | 5936.0 |
| 2011-07-15 07:39:00 | AAPL | Stock | 12.9111 | 12.9111 | 12.9111 | 12.9111 | 2800.0 |
| 2011-07-15 07:40:00 | AAPL | Stock | 12.9089 | 12.9111 | 12.9089 | 12.9111 | 11200.0 |
| 2011-07-15 07:44:00 | AAPL | Stock | 12.9036 | 12.9036 | 12.9036 | 12.9036 | 4200.0 |
| 2011-07-15 07:46:00 | AAPL | Stock | 12.9107 | 12.9107 | 12.9107 | 12.9107 | 6580.0 |
| 2011-07-15 07:48:00 | AAPL | Stock | 12.8989 | 12.9018 | 12.8989 | 12.9018 | 8400.0 |
| 2011-07-15 07:49:00 | AAPL | Stock | 12.9025 | 12.9025 | 12.9025 | 12.9025 | 2800.0 |
| 2011-07-15 07:50:00 | AAPL | Stock | 12.8971 | 12.8971 | 12.8654 | 12.8911 | 71680.0 |
| 2011-07-15 07:51:00 | AAPL | Stock | 12.8839 | 12.8839 | 12.8736 | 12.8736 | 31108.0 |
| 2011-07-15 07:52:00 | AAPL | Stock | 12.8693 | 12.8718 | 12.865 | 12.865 | 75236.0 |
| 2011-07-15 07:53:00 | AAPL | Stock | 12.8661 | 12.8746 | 12.8661 | 12.8746 | 39200.0 |
| 2011-07-15 07:54:00 | AAPL | Stock | 12.8746 | 12.8775 | 12.8746 | 12.8775 | 28000.0 |
| 2011-07-15 07:55:00 | AAPL | Stock | 12.8768 | 12.8875 | 12.8768 | 12.8875 | 39200.0 |
| 2011-07-15 07:57:00 | AAPL | Stock | 12.8807 | 12.8911 | 12.8796 | 12.8825 | 28000.0 |
| 2011-07-15 07:58:00 | AAPL | Stock | 12.8882 | 12.8882 | 12.8882 | 12.8882 | 2800.0 |
| 2011-07-15 08:00:00 | AAPL | Stock | 12.8889 | 12.9089 | 12.8889 | 12.9036 | 114072.0 |
| 2011-07-15 08:01:00 | AAPL | Stock | 12.9064 | 12.9107 | 12.9036 | 12.91 | 83944.0 |
| 2011-07-15 08:02:00 | AAPL | Stock | 12.9089 | 12.9089 | 12.9043 | 12.9043 | 54572.0 |
| 2011-07-15 08:03:00 | AAPL | Stock | 12.9107 | 12.9157 | 12.9089 | 12.9089 | 117320.0 |
| 2011-07-15 08:04:00 | AAPL | Stock | 12.9175 | 12.9179 | 12.9175 | 12.9179 | 8400.0 |
| 2011-07-15 08:05:00 | AAPL | Stock | 12.9143 | 12.9179 | 12.9143 | 12.9143 | 98364.0 |
| 2011-07-15 08:06:00 | AAPL | Stock | 12.9143 | 12.9214 | 12.9143 | 12.9164 | 123396.0 |
| 2011-07-15 08:08:00 | AAPL | Stock | 12.9179 | 12.9179 | 12.9143 | 12.9143 | 8400.0 |
| 2011-07-15 08:09:00 | AAPL | Stock | 12.9114 | 12.9114 | 12.91 | 12.91 | 25200.0 |
> showing 50 of 951,414 rows — these rows as CSV