PREVIEW / stock_1min / 2010-05-19
file: by_date/stock_1min/2010/2010-05-19.parquet size: 14.1 MB rows: 1,061,572 symbols: 2,826
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-19 04:20:00 | AAPL | Stock | 8.9125 | 8.9125 | 8.9125 | 8.9125 | 2800.0 |
| 2010-05-19 04:31:00 | AAPL | Stock | 8.86 | 8.86 | 8.86 | 8.86 | 6860.0 |
| 2010-05-19 05:10:00 | AAPL | Stock | 8.8814 | 8.8814 | 8.8814 | 8.8814 | 2800.0 |
| 2010-05-19 05:50:00 | AAPL | Stock | 8.9143 | 8.9143 | 8.9143 | 8.9143 | 12600.0 |
| 2010-05-19 06:19:00 | AAPL | Stock | 8.9107 | 8.9107 | 8.9107 | 8.9107 | 5600.0 |
| 2010-05-19 06:44:00 | AAPL | Stock | 8.8771 | 8.8771 | 8.8771 | 8.8771 | 5600.0 |
| 2010-05-19 06:45:00 | AAPL | Stock | 8.8771 | 8.8771 | 8.8771 | 8.8771 | 2800.0 |
| 2010-05-19 06:46:00 | AAPL | Stock | 8.8768 | 8.8768 | 8.8768 | 8.8768 | 5320.0 |
| 2010-05-19 06:47:00 | AAPL | Stock | 8.9032 | 8.9107 | 8.9032 | 8.9107 | 25200.0 |
| 2010-05-19 06:49:00 | AAPL | Stock | 8.905 | 8.905 | 8.905 | 8.905 | 2800.0 |
| 2010-05-19 06:52:00 | AAPL | Stock | 8.905 | 8.905 | 8.905 | 8.905 | 2800.0 |
| 2010-05-19 06:56:00 | AAPL | Stock | 8.905 | 8.905 | 8.905 | 8.905 | 7000.0 |
| 2010-05-19 07:00:00 | AAPL | Stock | 8.9036 | 8.9143 | 8.9036 | 8.9143 | 9520.0 |
| 2010-05-19 07:01:00 | AAPL | Stock | 8.9107 | 8.9107 | 8.9107 | 8.9107 | 2800.0 |
| 2010-05-19 07:02:00 | AAPL | Stock | 8.9036 | 8.9143 | 8.9036 | 8.9107 | 92400.0 |
| 2010-05-19 07:03:00 | AAPL | Stock | 8.8946 | 8.8946 | 8.8946 | 8.8946 | 2800.0 |
| 2010-05-19 07:04:00 | AAPL | Stock | 8.895 | 8.9143 | 8.895 | 8.9143 | 41020.0 |
| 2010-05-19 07:06:00 | AAPL | Stock | 8.9143 | 8.9143 | 8.9143 | 8.9143 | 4480.0 |
| 2010-05-19 07:07:00 | AAPL | Stock | 8.91 | 8.91 | 8.91 | 8.91 | 5180.0 |
| 2010-05-19 07:11:00 | AAPL | Stock | 8.93 | 8.93 | 8.93 | 8.93 | 8400.0 |
| 2010-05-19 07:16:00 | AAPL | Stock | 8.9279 | 8.9279 | 8.9279 | 8.9279 | 8400.0 |
| 2010-05-19 07:18:00 | AAPL | Stock | 8.9286 | 8.9286 | 8.9286 | 8.9286 | 42000.0 |
| 2010-05-19 07:19:00 | AAPL | Stock | 8.9286 | 8.9286 | 8.9286 | 8.9286 | 2800.0 |
| 2010-05-19 07:20:00 | AAPL | Stock | 8.9214 | 8.925 | 8.9018 | 8.9018 | 19040.0 |
| 2010-05-19 07:24:00 | AAPL | Stock | 8.9175 | 8.9196 | 8.9175 | 8.9196 | 16800.0 |
| 2010-05-19 07:25:00 | AAPL | Stock | 8.9261 | 8.9264 | 8.9207 | 8.9264 | 8400.0 |
| 2010-05-19 07:26:00 | AAPL | Stock | 8.9268 | 8.9286 | 8.9268 | 8.9286 | 22400.0 |
| 2010-05-19 07:29:00 | AAPL | Stock | 8.9279 | 8.9279 | 8.9279 | 8.9279 | 2800.0 |
| 2010-05-19 07:30:00 | AAPL | Stock | 8.925 | 8.9286 | 8.925 | 8.9286 | 24948.0 |
| 2010-05-19 07:32:00 | AAPL | Stock | 8.9289 | 8.9289 | 8.9289 | 8.9289 | 5600.0 |
| 2010-05-19 07:33:00 | AAPL | Stock | 8.9286 | 8.9286 | 8.9286 | 8.9286 | 2800.0 |
| 2010-05-19 07:34:00 | AAPL | Stock | 8.9293 | 8.9293 | 8.9286 | 8.9286 | 36092.0 |
| 2010-05-19 07:35:00 | AAPL | Stock | 8.9214 | 8.9214 | 8.9214 | 8.9214 | 11200.0 |
| 2010-05-19 07:38:00 | AAPL | Stock | 8.925 | 8.925 | 8.9218 | 8.9218 | 16800.0 |
| 2010-05-19 07:41:00 | AAPL | Stock | 8.9282 | 8.9286 | 8.9282 | 8.9286 | 5600.0 |
| 2010-05-19 07:42:00 | AAPL | Stock | 8.9289 | 8.9289 | 8.9289 | 8.9289 | 3276.0 |
| 2010-05-19 07:43:00 | AAPL | Stock | 8.9289 | 8.9289 | 8.9289 | 8.9289 | 2800.0 |
| 2010-05-19 07:44:00 | AAPL | Stock | 8.9286 | 8.9286 | 8.9239 | 8.9239 | 29988.0 |
| 2010-05-19 07:47:00 | AAPL | Stock | 8.9282 | 8.9286 | 8.9282 | 8.9286 | 14000.0 |
| 2010-05-19 07:53:00 | AAPL | Stock | 8.9271 | 8.9271 | 8.9271 | 8.9271 | 8400.0 |
| 2010-05-19 07:54:00 | AAPL | Stock | 8.9375 | 8.9375 | 8.9357 | 8.9375 | 14000.0 |
| 2010-05-19 07:58:00 | AAPL | Stock | 8.9371 | 8.9375 | 8.9321 | 8.9375 | 16800.0 |
| 2010-05-19 07:59:00 | AAPL | Stock | 8.9307 | 8.9321 | 8.9307 | 8.9321 | 11200.0 |
| 2010-05-19 08:00:00 | AAPL | Stock | 8.9311 | 8.9321 | 8.9107 | 8.915 | 230020.0 |
| 2010-05-19 08:01:00 | AAPL | Stock | 8.9157 | 8.9232 | 8.9146 | 8.9146 | 89516.0 |
| 2010-05-19 08:02:00 | AAPL | Stock | 8.915 | 8.9225 | 8.9107 | 8.9129 | 188944.0 |
| 2010-05-19 08:03:00 | AAPL | Stock | 8.9179 | 8.9189 | 8.9114 | 8.9125 | 46200.0 |
| 2010-05-19 08:04:00 | AAPL | Stock | 8.915 | 8.9196 | 8.9089 | 8.9089 | 124096.0 |
| 2010-05-19 08:05:00 | AAPL | Stock | 8.9039 | 8.9089 | 8.9036 | 8.9036 | 39200.0 |
| 2010-05-19 08:06:00 | AAPL | Stock | 8.9061 | 8.9089 | 8.8929 | 8.8929 | 175280.0 |
> showing 50 of 1,061,572 rows — these rows as CSV