PREVIEW / stock_1min / 2011-04-19
file: by_date/stock_1min/2011/2011-04-19.parquet size: 13.1 MB rows: 976,280 symbols: 2,854
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-04-19 04:09:00 | AAPL | Stock | 11.8639 | 11.8746 | 11.8639 | 11.8746 | 16800.0 |
| 2011-04-19 04:10:00 | AAPL | Stock | 11.8639 | 11.8746 | 11.8639 | 11.8746 | 5600.0 |
| 2011-04-19 04:19:00 | AAPL | Stock | 11.8868 | 11.8868 | 11.8868 | 11.8868 | 2800.0 |
| 2011-04-19 04:21:00 | AAPL | Stock | 11.8868 | 11.8868 | 11.8868 | 11.8868 | 2800.0 |
| 2011-04-19 04:26:00 | AAPL | Stock | 11.9086 | 11.9086 | 11.8989 | 11.8989 | 11200.0 |
| 2011-04-19 04:27:00 | AAPL | Stock | 11.9086 | 11.9086 | 11.9086 | 11.9086 | 14000.0 |
| 2011-04-19 04:29:00 | AAPL | Stock | 11.9107 | 11.9107 | 11.9107 | 11.9107 | 2800.0 |
| 2011-04-19 04:36:00 | AAPL | Stock | 11.9086 | 11.9086 | 11.9086 | 11.9086 | 2800.0 |
| 2011-04-19 04:42:00 | AAPL | Stock | 11.9157 | 11.9157 | 11.9157 | 11.9157 | 2800.0 |
| 2011-04-19 04:52:00 | AAPL | Stock | 11.9229 | 11.9239 | 11.9229 | 11.9239 | 8400.0 |
| 2011-04-19 04:53:00 | AAPL | Stock | 11.9239 | 11.9239 | 11.9239 | 11.9239 | 5600.0 |
| 2011-04-19 05:05:00 | AAPL | Stock | 11.9489 | 11.9489 | 11.9489 | 11.9489 | 11200.0 |
| 2011-04-19 05:11:00 | AAPL | Stock | 11.95 | 11.9579 | 11.95 | 11.9579 | 14000.0 |
| 2011-04-19 05:22:00 | AAPL | Stock | 11.9286 | 11.9286 | 11.9286 | 11.9286 | 2800.0 |
| 2011-04-19 05:48:00 | AAPL | Stock | 11.9286 | 11.9286 | 11.9286 | 11.9286 | 2800.0 |
| 2011-04-19 06:02:00 | AAPL | Stock | 11.9286 | 11.9286 | 11.9286 | 11.9286 | 13384.0 |
| 2011-04-19 06:05:00 | AAPL | Stock | 11.9375 | 11.9375 | 11.9375 | 11.9375 | 2800.0 |
| 2011-04-19 06:06:00 | AAPL | Stock | 11.9393 | 11.9393 | 11.9393 | 11.9393 | 5600.0 |
| 2011-04-19 06:12:00 | AAPL | Stock | 11.9286 | 11.9286 | 11.9286 | 11.9286 | 2800.0 |
| 2011-04-19 06:13:00 | AAPL | Stock | 11.9279 | 11.9279 | 11.9279 | 11.9279 | 2800.0 |
| 2011-04-19 06:23:00 | AAPL | Stock | 11.9279 | 11.9279 | 11.9279 | 11.9279 | 2800.0 |
| 2011-04-19 06:31:00 | AAPL | Stock | 11.9318 | 11.9318 | 11.9318 | 11.9318 | 2800.0 |
| 2011-04-19 06:38:00 | AAPL | Stock | 11.9425 | 11.9425 | 11.9425 | 11.9425 | 2800.0 |
| 2011-04-19 06:50:00 | AAPL | Stock | 11.9389 | 11.9389 | 11.9389 | 11.9389 | 2800.0 |
| 2011-04-19 06:52:00 | AAPL | Stock | 11.9286 | 11.9286 | 11.9286 | 11.9286 | 5600.0 |
| 2011-04-19 07:00:00 | AAPL | Stock | 11.9193 | 11.9193 | 11.9179 | 11.9179 | 8400.0 |
| 2011-04-19 07:01:00 | AAPL | Stock | 11.9243 | 11.9275 | 11.9243 | 11.9275 | 11200.0 |
| 2011-04-19 07:02:00 | AAPL | Stock | 11.9011 | 11.9011 | 11.9 | 11.9 | 14000.0 |
| 2011-04-19 07:03:00 | AAPL | Stock | 11.9246 | 11.9246 | 11.9246 | 11.9246 | 2800.0 |
| 2011-04-19 07:05:00 | AAPL | Stock | 11.9111 | 11.9111 | 11.9111 | 11.9111 | 2800.0 |
| 2011-04-19 07:06:00 | AAPL | Stock | 11.92 | 11.9246 | 11.92 | 11.9246 | 5600.0 |
| 2011-04-19 07:08:00 | AAPL | Stock | 11.9196 | 11.9196 | 11.9196 | 11.9196 | 2800.0 |
| 2011-04-19 07:10:00 | AAPL | Stock | 11.9125 | 11.9125 | 11.9125 | 11.9125 | 2800.0 |
| 2011-04-19 07:13:00 | AAPL | Stock | 11.9214 | 11.9214 | 11.9214 | 11.9214 | 33600.0 |
| 2011-04-19 07:14:00 | AAPL | Stock | 11.9111 | 11.9111 | 11.9111 | 11.9111 | 7000.0 |
| 2011-04-19 07:15:00 | AAPL | Stock | 11.9111 | 11.9111 | 11.9111 | 11.9111 | 2800.0 |
| 2011-04-19 07:18:00 | AAPL | Stock | 11.9221 | 11.9221 | 11.9221 | 11.9221 | 5600.0 |
| 2011-04-19 07:19:00 | AAPL | Stock | 11.9121 | 11.9121 | 11.9107 | 11.9107 | 21000.0 |
| 2011-04-19 07:20:00 | AAPL | Stock | 11.9071 | 11.9071 | 11.9071 | 11.9071 | 14000.0 |
| 2011-04-19 07:25:00 | AAPL | Stock | 11.9146 | 11.9146 | 11.9107 | 11.9107 | 16800.0 |
| 2011-04-19 07:26:00 | AAPL | Stock | 11.9107 | 11.9129 | 11.9107 | 11.9129 | 12040.0 |
| 2011-04-19 07:28:00 | AAPL | Stock | 11.905 | 11.905 | 11.905 | 11.905 | 12040.0 |
| 2011-04-19 07:29:00 | AAPL | Stock | 11.9161 | 11.9161 | 11.9161 | 11.9161 | 5600.0 |
| 2011-04-19 07:31:00 | AAPL | Stock | 11.9107 | 11.9107 | 11.9057 | 11.9057 | 38640.0 |
| 2011-04-19 07:34:00 | AAPL | Stock | 11.9061 | 11.9061 | 11.9061 | 11.9061 | 2800.0 |
| 2011-04-19 07:35:00 | AAPL | Stock | 11.9107 | 11.9107 | 11.9057 | 11.9057 | 8400.0 |
| 2011-04-19 07:37:00 | AAPL | Stock | 11.9125 | 11.9125 | 11.9125 | 11.9125 | 11620.0 |
| 2011-04-19 07:39:00 | AAPL | Stock | 11.9057 | 11.9057 | 11.9057 | 11.9057 | 2800.0 |
| 2011-04-19 07:40:00 | AAPL | Stock | 11.9107 | 11.9107 | 11.9057 | 11.9107 | 11200.0 |
| 2011-04-19 07:41:00 | AAPL | Stock | 11.9107 | 11.9107 | 11.9107 | 11.9107 | 5600.0 |
> showing 50 of 976,280 rows — these rows as CSV