PREVIEW / stock_1min / 2011-07-29
file: by_date/stock_1min/2011/2011-07-29.parquet size: 13.6 MB rows: 1,014,155 symbols: 2,871
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-29 04:00:00 | AAPL | Stock | 13.9286 | 13.9286 | 13.8968 | 13.8968 | 8400.0 |
| 2011-07-29 04:09:00 | AAPL | Stock | 13.8821 | 13.8821 | 13.8821 | 13.8821 | 2800.0 |
| 2011-07-29 04:10:00 | AAPL | Stock | 13.8889 | 13.8889 | 13.8821 | 13.8821 | 8400.0 |
| 2011-07-29 04:11:00 | AAPL | Stock | 13.8757 | 13.8757 | 13.8757 | 13.8757 | 2800.0 |
| 2011-07-29 04:12:00 | AAPL | Stock | 13.8786 | 13.8786 | 13.8786 | 13.8786 | 2800.0 |
| 2011-07-29 04:13:00 | AAPL | Stock | 13.8786 | 13.8786 | 13.8786 | 13.8786 | 2800.0 |
| 2011-07-29 04:17:00 | AAPL | Stock | 13.8889 | 13.8889 | 13.8889 | 13.8889 | 2800.0 |
| 2011-07-29 04:19:00 | AAPL | Stock | 13.8893 | 13.8893 | 13.8893 | 13.8893 | 2800.0 |
| 2011-07-29 04:21:00 | AAPL | Stock | 13.8918 | 13.8918 | 13.8918 | 13.8918 | 2800.0 |
| 2011-07-29 04:26:00 | AAPL | Stock | 13.8946 | 13.895 | 13.8946 | 13.895 | 5600.0 |
| 2011-07-29 04:32:00 | AAPL | Stock | 13.9189 | 13.9189 | 13.9189 | 13.9189 | 2800.0 |
| 2011-07-29 04:33:00 | AAPL | Stock | 13.9271 | 13.9271 | 13.9271 | 13.9271 | 5600.0 |
| 2011-07-29 04:35:00 | AAPL | Stock | 13.9268 | 13.9268 | 13.9268 | 13.9268 | 2800.0 |
| 2011-07-29 04:37:00 | AAPL | Stock | 13.9332 | 13.9332 | 13.9332 | 13.9332 | 2800.0 |
| 2011-07-29 04:45:00 | AAPL | Stock | 13.9161 | 13.9161 | 13.9161 | 13.9161 | 2800.0 |
| 2011-07-29 04:55:00 | AAPL | Stock | 13.9036 | 13.9036 | 13.9036 | 13.9036 | 2800.0 |
| 2011-07-29 05:27:00 | AAPL | Stock | 13.93 | 13.93 | 13.93 | 13.93 | 2800.0 |
| 2011-07-29 05:30:00 | AAPL | Stock | 13.9225 | 13.9225 | 13.9225 | 13.9225 | 2800.0 |
| 2011-07-29 05:50:00 | AAPL | Stock | 13.9161 | 13.9161 | 13.9161 | 13.9161 | 2800.0 |
| 2011-07-29 06:09:00 | AAPL | Stock | 13.9239 | 13.9239 | 13.9239 | 13.9239 | 2800.0 |
| 2011-07-29 06:39:00 | AAPL | Stock | 13.92 | 13.92 | 13.92 | 13.92 | 2800.0 |
| 2011-07-29 06:42:00 | AAPL | Stock | 13.9104 | 13.9104 | 13.9104 | 13.9104 | 3304.0 |
| 2011-07-29 06:45:00 | AAPL | Stock | 13.8982 | 13.8982 | 13.8871 | 13.8871 | 5600.0 |
| 2011-07-29 06:48:00 | AAPL | Stock | 13.8839 | 13.8839 | 13.875 | 13.875 | 5600.0 |
| 2011-07-29 06:49:00 | AAPL | Stock | 13.875 | 13.875 | 13.875 | 13.875 | 5600.0 |
| 2011-07-29 07:01:00 | AAPL | Stock | 13.8904 | 13.8929 | 13.89 | 13.89 | 16800.0 |
| 2011-07-29 07:02:00 | AAPL | Stock | 13.89 | 13.89 | 13.8893 | 13.8893 | 8400.0 |
| 2011-07-29 07:06:00 | AAPL | Stock | 13.8929 | 13.8929 | 13.8929 | 13.8929 | 14000.0 |
| 2011-07-29 07:09:00 | AAPL | Stock | 13.8936 | 13.8936 | 13.8929 | 13.8929 | 8400.0 |
| 2011-07-29 07:10:00 | AAPL | Stock | 13.8993 | 13.8993 | 13.8993 | 13.8993 | 2800.0 |
| 2011-07-29 07:12:00 | AAPL | Stock | 13.9064 | 13.9104 | 13.9064 | 13.9104 | 8400.0 |
| 2011-07-29 07:14:00 | AAPL | Stock | 13.8979 | 13.8979 | 13.8979 | 13.8979 | 2800.0 |
| 2011-07-29 07:16:00 | AAPL | Stock | 13.9007 | 13.9007 | 13.9007 | 13.9007 | 7000.0 |
| 2011-07-29 07:18:00 | AAPL | Stock | 13.9196 | 13.9196 | 13.9107 | 13.9107 | 28700.0 |
| 2011-07-29 07:19:00 | AAPL | Stock | 13.9075 | 13.9075 | 13.9075 | 13.9075 | 11200.0 |
| 2011-07-29 07:21:00 | AAPL | Stock | 13.9018 | 13.9018 | 13.8946 | 13.8946 | 5600.0 |
| 2011-07-29 07:22:00 | AAPL | Stock | 13.9071 | 13.9071 | 13.9071 | 13.9071 | 14000.0 |
| 2011-07-29 07:23:00 | AAPL | Stock | 13.8968 | 13.8968 | 13.8968 | 13.8968 | 5600.0 |
| 2011-07-29 07:30:00 | AAPL | Stock | 13.8964 | 13.8964 | 13.8929 | 13.8929 | 27412.0 |
| 2011-07-29 07:34:00 | AAPL | Stock | 13.8929 | 13.8929 | 13.8929 | 13.8929 | 4928.0 |
| 2011-07-29 07:38:00 | AAPL | Stock | 13.9036 | 13.9036 | 13.9036 | 13.9036 | 2800.0 |
| 2011-07-29 07:39:00 | AAPL | Stock | 13.8929 | 13.8929 | 13.8929 | 13.8929 | 26880.0 |
| 2011-07-29 07:40:00 | AAPL | Stock | 13.8921 | 13.8921 | 13.8911 | 13.8921 | 11200.0 |
| 2011-07-29 07:50:00 | AAPL | Stock | 13.8929 | 13.8929 | 13.8857 | 13.8893 | 74200.0 |
| 2011-07-29 07:53:00 | AAPL | Stock | 13.8925 | 13.8925 | 13.8925 | 13.8925 | 8400.0 |
| 2011-07-29 07:54:00 | AAPL | Stock | 13.8929 | 13.8929 | 13.8929 | 13.8929 | 2800.0 |
| 2011-07-29 07:56:00 | AAPL | Stock | 13.8979 | 13.9014 | 13.8979 | 13.9014 | 5600.0 |
| 2011-07-29 07:57:00 | AAPL | Stock | 13.9036 | 13.9093 | 13.8982 | 13.9093 | 42000.0 |
| 2011-07-29 08:00:00 | AAPL | Stock | 13.9079 | 13.9286 | 13.9014 | 13.9068 | 170940.0 |
| 2011-07-29 08:01:00 | AAPL | Stock | 13.9039 | 13.9179 | 13.9036 | 13.9039 | 114912.0 |
> showing 50 of 1,014,155 rows — these rows as CSV