PREVIEW / stock_1min / 2014-03-14
file: by_date/stock_1min/2014/2014-03-14.parquet size: 14.6 MB rows: 1,070,404 symbols: 2,865
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 |
|---|---|---|---|---|---|---|---|
| 2014-03-14 04:01:00 | AAPL | Stock | 18.8925 | 18.8925 | 18.8925 | 18.8925 | 2800.0 |
| 2014-03-14 04:03:00 | AAPL | Stock | 18.9268 | 18.9286 | 18.9268 | 18.9286 | 8400.0 |
| 2014-03-14 04:09:00 | AAPL | Stock | 18.8929 | 18.8929 | 18.8929 | 18.8929 | 5600.0 |
| 2014-03-14 06:37:00 | AAPL | Stock | 18.9071 | 18.9071 | 18.9071 | 18.9071 | 2800.0 |
| 2014-03-14 06:46:00 | AAPL | Stock | 18.9018 | 18.9018 | 18.9018 | 18.9018 | 2800.0 |
| 2014-03-14 07:02:00 | AAPL | Stock | 18.9071 | 18.9071 | 18.9071 | 18.9071 | 2800.0 |
| 2014-03-14 07:03:00 | AAPL | Stock | 18.9071 | 18.9196 | 18.9071 | 18.9196 | 8400.0 |
| 2014-03-14 07:04:00 | AAPL | Stock | 18.925 | 18.925 | 18.925 | 18.925 | 8400.0 |
| 2014-03-14 07:06:00 | AAPL | Stock | 18.9246 | 18.9246 | 18.9246 | 18.9246 | 2800.0 |
| 2014-03-14 07:12:00 | AAPL | Stock | 18.9089 | 18.9089 | 18.9036 | 18.9036 | 11200.0 |
| 2014-03-14 07:16:00 | AAPL | Stock | 18.9229 | 18.9321 | 18.9229 | 18.9286 | 26656.0 |
| 2014-03-14 07:17:00 | AAPL | Stock | 18.9371 | 18.9371 | 18.9371 | 18.9371 | 2800.0 |
| 2014-03-14 07:19:00 | AAPL | Stock | 18.9304 | 18.9304 | 18.9286 | 18.9286 | 13440.0 |
| 2014-03-14 07:21:00 | AAPL | Stock | 18.9286 | 18.9286 | 18.9286 | 18.9286 | 16800.0 |
| 2014-03-14 07:24:00 | AAPL | Stock | 18.9286 | 18.9286 | 18.9286 | 18.9286 | 2800.0 |
| 2014-03-14 07:30:00 | AAPL | Stock | 18.9143 | 18.9143 | 18.9143 | 18.9143 | 5600.0 |
| 2014-03-14 07:37:00 | AAPL | Stock | 18.9107 | 18.9107 | 18.9107 | 18.9107 | 14000.0 |
| 2014-03-14 07:43:00 | AAPL | Stock | 18.8968 | 18.8968 | 18.8968 | 18.8968 | 5600.0 |
| 2014-03-14 07:45:00 | AAPL | Stock | 18.9104 | 18.9104 | 18.9104 | 18.9104 | 4228.0 |
| 2014-03-14 07:47:00 | AAPL | Stock | 18.9118 | 18.9129 | 18.9118 | 18.9129 | 8400.0 |
| 2014-03-14 07:49:00 | AAPL | Stock | 18.9125 | 18.9125 | 18.9107 | 18.9107 | 6384.0 |
| 2014-03-14 07:59:00 | AAPL | Stock | 18.9114 | 18.9114 | 18.9114 | 18.9114 | 2800.0 |
| 2014-03-14 08:00:00 | AAPL | Stock | 18.9196 | 18.9286 | 18.9007 | 18.9007 | 25872.0 |
| 2014-03-14 08:01:00 | AAPL | Stock | 18.9107 | 18.9107 | 18.9107 | 18.9107 | 7000.0 |
| 2014-03-14 08:03:00 | AAPL | Stock | 18.9021 | 18.9068 | 18.9 | 18.9068 | 8400.0 |
| 2014-03-14 08:04:00 | AAPL | Stock | 18.9089 | 18.9218 | 18.9089 | 18.9218 | 38584.0 |
| 2014-03-14 08:07:00 | AAPL | Stock | 18.9139 | 18.9143 | 18.9139 | 18.9143 | 8400.0 |
| 2014-03-14 08:08:00 | AAPL | Stock | 18.9225 | 18.9232 | 18.9196 | 18.9196 | 22400.0 |
| 2014-03-14 08:09:00 | AAPL | Stock | 18.9182 | 18.9243 | 18.9182 | 18.9243 | 8400.0 |
| 2014-03-14 08:13:00 | AAPL | Stock | 18.9175 | 18.9182 | 18.9161 | 18.9161 | 37688.0 |
| 2014-03-14 08:27:00 | AAPL | Stock | 18.9057 | 18.9057 | 18.9029 | 18.9029 | 11200.0 |
| 2014-03-14 08:31:00 | AAPL | Stock | 18.8996 | 18.8996 | 18.8996 | 18.8996 | 27384.0 |
| 2014-03-14 08:34:00 | AAPL | Stock | 18.8982 | 18.8982 | 18.8904 | 18.8904 | 22400.0 |
| 2014-03-14 08:35:00 | AAPL | Stock | 18.895 | 18.9007 | 18.8896 | 18.8896 | 8400.0 |
| 2014-03-14 08:36:00 | AAPL | Stock | 18.8982 | 18.8982 | 18.8911 | 18.8929 | 31920.0 |
| 2014-03-14 08:37:00 | AAPL | Stock | 18.8886 | 18.8886 | 18.8886 | 18.8886 | 2800.0 |
| 2014-03-14 08:38:00 | AAPL | Stock | 18.885 | 18.89 | 18.885 | 18.89 | 8400.0 |
| 2014-03-14 08:40:00 | AAPL | Stock | 18.8839 | 18.8839 | 18.8839 | 18.8839 | 18060.0 |
| 2014-03-14 08:41:00 | AAPL | Stock | 18.8811 | 18.8811 | 18.8811 | 18.8811 | 2800.0 |
| 2014-03-14 08:42:00 | AAPL | Stock | 18.8789 | 18.8789 | 18.8786 | 18.8786 | 5600.0 |
| 2014-03-14 08:43:00 | AAPL | Stock | 18.8786 | 18.8786 | 18.8786 | 18.8786 | 3108.0 |
| 2014-03-14 08:45:00 | AAPL | Stock | 18.8861 | 18.8861 | 18.8821 | 18.8821 | 8400.0 |
| 2014-03-14 08:46:00 | AAPL | Stock | 18.8861 | 18.8861 | 18.8861 | 18.8861 | 14000.0 |
| 2014-03-14 08:48:00 | AAPL | Stock | 18.8857 | 18.8857 | 18.8839 | 18.8839 | 5600.0 |
| 2014-03-14 08:51:00 | AAPL | Stock | 18.8854 | 18.8854 | 18.8854 | 18.8854 | 2800.0 |
| 2014-03-14 08:52:00 | AAPL | Stock | 18.8857 | 18.8857 | 18.8857 | 18.8857 | 4480.0 |
| 2014-03-14 08:57:00 | AAPL | Stock | 18.885 | 18.885 | 18.885 | 18.885 | 2800.0 |
| 2014-03-14 09:04:00 | AAPL | Stock | 18.8929 | 18.8929 | 18.8929 | 18.8929 | 5600.0 |
| 2014-03-14 09:05:00 | AAPL | Stock | 18.9018 | 18.9018 | 18.9018 | 18.9018 | 2800.0 |
| 2014-03-14 09:07:00 | AAPL | Stock | 18.9161 | 18.9161 | 18.9161 | 18.9161 | 2800.0 |
> showing 50 of 1,070,404 rows — these rows as CSV