PREVIEW / stock_1min / 2013-08-19
file: by_date/stock_1min/2013/2013-08-19.parquet size: 13.6 MB rows: 994,697 symbols: 2,873
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 |
|---|---|---|---|---|---|---|---|
| 2013-08-19 04:00:00 | AAPL | Stock | 18.0696 | 18.0696 | 18.0696 | 18.0696 | 4200.0 |
| 2013-08-19 04:19:00 | AAPL | Stock | 18.05 | 18.05 | 18.05 | 18.05 | 8400.0 |
| 2013-08-19 04:20:00 | AAPL | Stock | 18.05 | 18.05 | 18.05 | 18.05 | 16800.0 |
| 2013-08-19 04:22:00 | AAPL | Stock | 18.0393 | 18.0393 | 18.0393 | 18.0393 | 4480.0 |
| 2013-08-19 04:23:00 | AAPL | Stock | 18.0586 | 18.0689 | 18.0586 | 18.0689 | 11060.0 |
| 2013-08-19 04:24:00 | AAPL | Stock | 18.0604 | 18.0604 | 18.0604 | 18.0604 | 2800.0 |
| 2013-08-19 04:35:00 | AAPL | Stock | 18.0464 | 18.0464 | 18.0443 | 18.0443 | 14000.0 |
| 2013-08-19 04:47:00 | AAPL | Stock | 18.0286 | 18.0286 | 18.0286 | 18.0286 | 2800.0 |
| 2013-08-19 04:54:00 | AAPL | Stock | 18.0214 | 18.0214 | 18.0214 | 18.0214 | 2800.0 |
| 2013-08-19 05:11:00 | AAPL | Stock | 18.0196 | 18.0196 | 18.0189 | 18.0189 | 15316.0 |
| 2013-08-19 05:17:00 | AAPL | Stock | 18.0232 | 18.0232 | 18.0232 | 18.0232 | 2800.0 |
| 2013-08-19 05:26:00 | AAPL | Stock | 18.0204 | 18.0204 | 18.0204 | 18.0204 | 5600.0 |
| 2013-08-19 05:41:00 | AAPL | Stock | 18.0511 | 18.0511 | 18.0511 | 18.0511 | 2800.0 |
| 2013-08-19 05:43:00 | AAPL | Stock | 18.0375 | 18.0375 | 18.0321 | 18.0321 | 9436.0 |
| 2013-08-19 05:45:00 | AAPL | Stock | 18.0357 | 18.0357 | 18.0357 | 18.0357 | 2800.0 |
| 2013-08-19 05:47:00 | AAPL | Stock | 18.0321 | 18.0354 | 18.0321 | 18.0354 | 5600.0 |
| 2013-08-19 05:50:00 | AAPL | Stock | 18.0321 | 18.0321 | 18.0321 | 18.0321 | 7420.0 |
| 2013-08-19 05:54:00 | AAPL | Stock | 18.0275 | 18.0275 | 18.0275 | 18.0275 | 2800.0 |
| 2013-08-19 06:07:00 | AAPL | Stock | 18.0357 | 18.0357 | 18.0357 | 18.0357 | 2800.0 |
| 2013-08-19 06:08:00 | AAPL | Stock | 18.0357 | 18.0357 | 18.0357 | 18.0357 | 9604.0 |
| 2013-08-19 06:13:00 | AAPL | Stock | 18.0357 | 18.0357 | 18.0357 | 18.0357 | 5600.0 |
| 2013-08-19 06:16:00 | AAPL | Stock | 18.0357 | 18.0357 | 18.0357 | 18.0357 | 2800.0 |
| 2013-08-19 06:29:00 | AAPL | Stock | 18.035 | 18.035 | 18.035 | 18.035 | 2800.0 |
| 2013-08-19 06:31:00 | AAPL | Stock | 18.0268 | 18.0268 | 18.0204 | 18.0264 | 25200.0 |
| 2013-08-19 06:35:00 | AAPL | Stock | 18.0179 | 18.0214 | 18.0179 | 18.0214 | 19600.0 |
| 2013-08-19 06:36:00 | AAPL | Stock | 18.0214 | 18.0214 | 18.0214 | 18.0214 | 14000.0 |
| 2013-08-19 06:42:00 | AAPL | Stock | 18.0171 | 18.0214 | 18.0171 | 18.0214 | 19600.0 |
| 2013-08-19 06:43:00 | AAPL | Stock | 18.0214 | 18.0518 | 18.0214 | 18.0518 | 72744.0 |
| 2013-08-19 06:46:00 | AAPL | Stock | 18.0289 | 18.0289 | 18.0268 | 18.0268 | 8400.0 |
| 2013-08-19 06:48:00 | AAPL | Stock | 18.0232 | 18.0232 | 18.0232 | 18.0232 | 13720.0 |
| 2013-08-19 06:49:00 | AAPL | Stock | 18.0182 | 18.0182 | 18.0182 | 18.0182 | 5600.0 |
| 2013-08-19 06:50:00 | AAPL | Stock | 18.0089 | 18.0357 | 18.0089 | 18.0357 | 63336.0 |
| 2013-08-19 06:55:00 | AAPL | Stock | 18.025 | 18.025 | 18.0232 | 18.0232 | 8400.0 |
| 2013-08-19 07:00:00 | AAPL | Stock | 18.0239 | 18.0357 | 18.0239 | 18.0357 | 5600.0 |
| 2013-08-19 07:01:00 | AAPL | Stock | 18.0357 | 18.0411 | 18.0357 | 18.0411 | 26124.0 |
| 2013-08-19 07:02:00 | AAPL | Stock | 18.045 | 18.045 | 18.0411 | 18.0414 | 16800.0 |
| 2013-08-19 07:04:00 | AAPL | Stock | 18.0411 | 18.0411 | 18.0411 | 18.0411 | 7840.0 |
| 2013-08-19 07:09:00 | AAPL | Stock | 18.0464 | 18.0464 | 18.0411 | 18.0411 | 28000.0 |
| 2013-08-19 07:10:00 | AAPL | Stock | 18.0411 | 18.0411 | 18.0357 | 18.0357 | 16800.0 |
| 2013-08-19 07:11:00 | AAPL | Stock | 18.0357 | 18.0357 | 18.0357 | 18.0357 | 16800.0 |
| 2013-08-19 07:12:00 | AAPL | Stock | 18.025 | 18.025 | 18.025 | 18.025 | 3080.0 |
| 2013-08-19 07:13:00 | AAPL | Stock | 18.03 | 18.0336 | 18.03 | 18.0336 | 8400.0 |
| 2013-08-19 07:14:00 | AAPL | Stock | 18.03 | 18.0339 | 18.03 | 18.0339 | 11200.0 |
| 2013-08-19 07:15:00 | AAPL | Stock | 18.0375 | 18.0375 | 18.0375 | 18.0375 | 2800.0 |
| 2013-08-19 07:18:00 | AAPL | Stock | 18.03 | 18.035 | 18.03 | 18.035 | 7000.0 |
| 2013-08-19 07:20:00 | AAPL | Stock | 18.0243 | 18.0243 | 18.0171 | 18.0171 | 28000.0 |
| 2013-08-19 07:21:00 | AAPL | Stock | 18.0107 | 18.0107 | 18.0089 | 18.0089 | 29680.0 |
| 2013-08-19 07:24:00 | AAPL | Stock | 18.0171 | 18.0314 | 18.0171 | 18.0314 | 11200.0 |
| 2013-08-19 07:25:00 | AAPL | Stock | 18.0186 | 18.0186 | 18.0186 | 18.0186 | 2800.0 |
| 2013-08-19 07:28:00 | AAPL | Stock | 18.0161 | 18.0161 | 18.0161 | 18.0161 | 2800.0 |
> showing 50 of 994,697 rows — these rows as CSV