PREVIEW / stock_1min / 2010-05-27
file: by_date/stock_1min/2010/2010-05-27.parquet size: 13.4 MB rows: 1,023,415 symbols: 2,817
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 |
|---|---|---|---|---|---|---|---|
| 2010-05-27 04:15:00 | AAPL | Stock | 8.8818 | 8.8818 | 8.825 | 8.8618 | 19600.0 |
| 2010-05-27 04:52:00 | AAPL | Stock | 8.9071 | 8.9071 | 8.9071 | 8.9071 | 14000.0 |
| 2010-05-27 05:04:00 | AAPL | Stock | 8.9071 | 8.9082 | 8.9071 | 8.9082 | 5600.0 |
| 2010-05-27 05:06:00 | AAPL | Stock | 8.9111 | 8.9111 | 8.9111 | 8.9111 | 2800.0 |
| 2010-05-27 06:06:00 | AAPL | Stock | 8.9143 | 8.9143 | 8.9143 | 8.9143 | 2800.0 |
| 2010-05-27 06:17:00 | AAPL | Stock | 8.9439 | 8.9439 | 8.9439 | 8.9439 | 2800.0 |
| 2010-05-27 06:20:00 | AAPL | Stock | 8.9439 | 8.9439 | 8.9439 | 8.9439 | 2800.0 |
| 2010-05-27 06:28:00 | AAPL | Stock | 8.9571 | 8.9571 | 8.9571 | 8.9571 | 2800.0 |
| 2010-05-27 06:33:00 | AAPL | Stock | 8.9571 | 8.9571 | 8.9571 | 8.9571 | 2800.0 |
| 2010-05-27 06:34:00 | AAPL | Stock | 8.9571 | 8.9571 | 8.9571 | 8.9571 | 2800.0 |
| 2010-05-27 06:38:00 | AAPL | Stock | 8.9571 | 8.9571 | 8.9571 | 8.9571 | 2800.0 |
| 2010-05-27 06:42:00 | AAPL | Stock | 8.9571 | 8.9571 | 8.9571 | 8.9571 | 5600.0 |
| 2010-05-27 06:48:00 | AAPL | Stock | 8.9571 | 8.9571 | 8.9571 | 8.9571 | 2800.0 |
| 2010-05-27 06:49:00 | AAPL | Stock | 8.9571 | 8.9571 | 8.9571 | 8.9571 | 8400.0 |
| 2010-05-27 07:00:00 | AAPL | Stock | 8.9439 | 8.9629 | 8.9432 | 8.9571 | 140000.0 |
| 2010-05-27 07:01:00 | AAPL | Stock | 8.9571 | 8.9571 | 8.9568 | 8.9568 | 12488.0 |
| 2010-05-27 07:02:00 | AAPL | Stock | 8.9564 | 8.9564 | 8.9554 | 8.9564 | 33600.0 |
| 2010-05-27 07:03:00 | AAPL | Stock | 8.955 | 8.955 | 8.9482 | 8.9482 | 46900.0 |
| 2010-05-27 07:04:00 | AAPL | Stock | 8.9457 | 8.9464 | 8.9457 | 8.9464 | 8400.0 |
| 2010-05-27 07:05:00 | AAPL | Stock | 8.9361 | 8.9464 | 8.9286 | 8.9286 | 143920.0 |
| 2010-05-27 07:07:00 | AAPL | Stock | 8.9286 | 8.9286 | 8.9079 | 8.91 | 40600.0 |
| 2010-05-27 07:08:00 | AAPL | Stock | 8.9107 | 8.9114 | 8.9036 | 8.9104 | 47488.0 |
| 2010-05-27 07:10:00 | AAPL | Stock | 8.9021 | 8.9021 | 8.9021 | 8.9021 | 2800.0 |
| 2010-05-27 07:11:00 | AAPL | Stock | 8.9107 | 8.925 | 8.91 | 8.9111 | 27216.0 |
| 2010-05-27 07:12:00 | AAPL | Stock | 8.9107 | 8.9107 | 8.9107 | 8.9107 | 5600.0 |
| 2010-05-27 07:13:00 | AAPL | Stock | 8.9232 | 8.925 | 8.9129 | 8.9204 | 58800.0 |
| 2010-05-27 07:14:00 | AAPL | Stock | 8.9229 | 8.9229 | 8.9229 | 8.9229 | 2800.0 |
| 2010-05-27 07:16:00 | AAPL | Stock | 8.9232 | 8.925 | 8.9232 | 8.925 | 36400.0 |
| 2010-05-27 07:17:00 | AAPL | Stock | 8.925 | 8.9261 | 8.9218 | 8.9218 | 11200.0 |
| 2010-05-27 07:18:00 | AAPL | Stock | 8.9221 | 8.925 | 8.9214 | 8.925 | 57400.0 |
| 2010-05-27 07:19:00 | AAPL | Stock | 8.925 | 8.925 | 8.925 | 8.925 | 8400.0 |
| 2010-05-27 07:20:00 | AAPL | Stock | 8.925 | 8.9268 | 8.925 | 8.9268 | 46396.0 |
| 2010-05-27 07:21:00 | AAPL | Stock | 8.9243 | 8.9286 | 8.9243 | 8.9286 | 106400.0 |
| 2010-05-27 07:22:00 | AAPL | Stock | 8.9321 | 8.9375 | 8.9321 | 8.9375 | 28000.0 |
| 2010-05-27 07:24:00 | AAPL | Stock | 8.9371 | 8.9375 | 8.9357 | 8.9357 | 19292.0 |
| 2010-05-27 07:25:00 | AAPL | Stock | 8.9375 | 8.9375 | 8.9321 | 8.9321 | 5600.0 |
| 2010-05-27 07:26:00 | AAPL | Stock | 8.9289 | 8.9289 | 8.9204 | 8.9279 | 42308.0 |
| 2010-05-27 07:28:00 | AAPL | Stock | 8.9211 | 8.9257 | 8.9204 | 8.9214 | 33600.0 |
| 2010-05-27 07:29:00 | AAPL | Stock | 8.9214 | 8.9214 | 8.9175 | 8.9175 | 30800.0 |
| 2010-05-27 07:31:00 | AAPL | Stock | 8.9161 | 8.9179 | 8.9161 | 8.9179 | 10500.0 |
| 2010-05-27 07:32:00 | AAPL | Stock | 8.9193 | 8.9193 | 8.9079 | 8.9079 | 67340.0 |
| 2010-05-27 07:35:00 | AAPL | Stock | 8.9104 | 8.9104 | 8.9104 | 8.9104 | 5600.0 |
| 2010-05-27 07:36:00 | AAPL | Stock | 8.9064 | 8.9107 | 8.9064 | 8.9107 | 15400.0 |
| 2010-05-27 07:37:00 | AAPL | Stock | 8.9107 | 8.9107 | 8.9075 | 8.9075 | 19600.0 |
| 2010-05-27 07:38:00 | AAPL | Stock | 8.9193 | 8.9193 | 8.9193 | 8.9193 | 5600.0 |
| 2010-05-27 07:39:00 | AAPL | Stock | 8.9118 | 8.9189 | 8.9118 | 8.9189 | 11200.0 |
| 2010-05-27 07:41:00 | AAPL | Stock | 8.9193 | 8.9193 | 8.9193 | 8.9193 | 2800.0 |
| 2010-05-27 07:42:00 | AAPL | Stock | 8.9193 | 8.9193 | 8.9129 | 8.9129 | 8400.0 |
| 2010-05-27 07:43:00 | AAPL | Stock | 8.9196 | 8.9196 | 8.9196 | 8.9196 | 35980.0 |
| 2010-05-27 07:48:00 | AAPL | Stock | 8.9282 | 8.9282 | 8.9282 | 8.9282 | 2800.0 |
> showing 50 of 1,023,415 rows — these rows as CSV