PREVIEW / stock_1min / 2011-08-03
file: by_date/stock_1min/2011/2011-08-03.parquet size: 14.8 MB rows: 1,080,418 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-08-03 04:00:00 | AAPL | Stock | 13.9254 | 13.9254 | 13.9254 | 13.9254 | 2800.0 |
| 2011-08-03 04:06:00 | AAPL | Stock | 13.9054 | 13.9054 | 13.9054 | 13.9054 | 2800.0 |
| 2011-08-03 04:15:00 | AAPL | Stock | 13.9286 | 13.9286 | 13.9286 | 13.9286 | 2800.0 |
| 2011-08-03 04:22:00 | AAPL | Stock | 13.9364 | 13.9368 | 13.9364 | 13.9368 | 5600.0 |
| 2011-08-03 04:27:00 | AAPL | Stock | 13.9464 | 13.9464 | 13.9464 | 13.9464 | 2800.0 |
| 2011-08-03 04:34:00 | AAPL | Stock | 13.9464 | 13.9464 | 13.9357 | 13.9357 | 8400.0 |
| 2011-08-03 04:35:00 | AAPL | Stock | 13.9464 | 13.9464 | 13.9357 | 13.9357 | 8400.0 |
| 2011-08-03 04:38:00 | AAPL | Stock | 13.9411 | 13.9411 | 13.9407 | 13.9407 | 5600.0 |
| 2011-08-03 04:40:00 | AAPL | Stock | 13.9411 | 13.9411 | 13.9411 | 13.9411 | 5600.0 |
| 2011-08-03 04:44:00 | AAPL | Stock | 13.9368 | 13.9368 | 13.9368 | 13.9368 | 2800.0 |
| 2011-08-03 04:48:00 | AAPL | Stock | 13.9286 | 13.9286 | 13.9286 | 13.9286 | 2800.0 |
| 2011-08-03 04:49:00 | AAPL | Stock | 13.9286 | 13.9286 | 13.9286 | 13.9286 | 2800.0 |
| 2011-08-03 04:50:00 | AAPL | Stock | 13.9286 | 13.9286 | 13.9286 | 13.9286 | 2800.0 |
| 2011-08-03 04:51:00 | AAPL | Stock | 13.9286 | 13.9286 | 13.9286 | 13.9286 | 5600.0 |
| 2011-08-03 05:09:00 | AAPL | Stock | 13.9446 | 13.9446 | 13.9446 | 13.9446 | 2800.0 |
| 2011-08-03 05:16:00 | AAPL | Stock | 13.9446 | 13.9446 | 13.9446 | 13.9446 | 8400.0 |
| 2011-08-03 05:18:00 | AAPL | Stock | 13.9518 | 13.9518 | 13.9518 | 13.9518 | 2800.0 |
| 2011-08-03 05:25:00 | AAPL | Stock | 13.9536 | 13.9536 | 13.9536 | 13.9536 | 2800.0 |
| 2011-08-03 05:29:00 | AAPL | Stock | 13.9568 | 13.9568 | 13.9568 | 13.9568 | 2800.0 |
| 2011-08-03 05:30:00 | AAPL | Stock | 13.9571 | 13.9571 | 13.9571 | 13.9571 | 2800.0 |
| 2011-08-03 05:41:00 | AAPL | Stock | 13.9571 | 13.9571 | 13.9571 | 13.9571 | 2800.0 |
| 2011-08-03 05:47:00 | AAPL | Stock | 13.9107 | 13.9107 | 13.9107 | 13.9107 | 30772.0 |
| 2011-08-03 05:48:00 | AAPL | Stock | 13.9 | 13.9 | 13.9 | 13.9 | 26628.0 |
| 2011-08-03 05:59:00 | AAPL | Stock | 13.9293 | 13.9293 | 13.9293 | 13.9293 | 2800.0 |
| 2011-08-03 06:00:00 | AAPL | Stock | 13.9304 | 13.9304 | 13.9304 | 13.9304 | 7000.0 |
| 2011-08-03 06:01:00 | AAPL | Stock | 13.9393 | 13.9571 | 13.9393 | 13.9571 | 26600.0 |
| 2011-08-03 06:11:00 | AAPL | Stock | 13.9229 | 13.9229 | 13.9229 | 13.9229 | 2800.0 |
| 2011-08-03 06:15:00 | AAPL | Stock | 13.9393 | 13.9429 | 13.9393 | 13.9429 | 11200.0 |
| 2011-08-03 06:17:00 | AAPL | Stock | 13.9379 | 13.9407 | 13.9296 | 13.9296 | 8400.0 |
| 2011-08-03 06:21:00 | AAPL | Stock | 13.9329 | 13.9329 | 13.9329 | 13.9329 | 2800.0 |
| 2011-08-03 06:32:00 | AAPL | Stock | 13.9464 | 13.9464 | 13.9464 | 13.9464 | 5880.0 |
| 2011-08-03 06:33:00 | AAPL | Stock | 13.9346 | 13.9346 | 13.9346 | 13.9346 | 5600.0 |
| 2011-08-03 06:36:00 | AAPL | Stock | 13.9493 | 13.9493 | 13.9493 | 13.9493 | 19600.0 |
| 2011-08-03 06:37:00 | AAPL | Stock | 13.9571 | 13.9621 | 13.9571 | 13.9621 | 23772.0 |
| 2011-08-03 06:39:00 | AAPL | Stock | 13.975 | 13.975 | 13.975 | 13.975 | 22400.0 |
| 2011-08-03 06:40:00 | AAPL | Stock | 13.975 | 14.0093 | 13.975 | 14.0093 | 44800.0 |
| 2011-08-03 06:41:00 | AAPL | Stock | 14.0007 | 14.0007 | 14.0007 | 14.0007 | 3388.0 |
| 2011-08-03 06:45:00 | AAPL | Stock | 13.9821 | 13.9821 | 13.9821 | 13.9821 | 2800.0 |
| 2011-08-03 06:46:00 | AAPL | Stock | 13.9821 | 13.9821 | 13.9821 | 13.9821 | 5600.0 |
| 2011-08-03 06:47:00 | AAPL | Stock | 13.9846 | 13.9846 | 13.9846 | 13.9846 | 2800.0 |
| 2011-08-03 06:51:00 | AAPL | Stock | 13.9821 | 13.9821 | 13.9821 | 13.9821 | 2800.0 |
| 2011-08-03 06:52:00 | AAPL | Stock | 13.9793 | 13.9793 | 13.975 | 13.975 | 19600.0 |
| 2011-08-03 06:56:00 | AAPL | Stock | 13.975 | 13.9786 | 13.975 | 13.9786 | 14000.0 |
| 2011-08-03 06:58:00 | AAPL | Stock | 13.975 | 13.975 | 13.975 | 13.975 | 2800.0 |
| 2011-08-03 06:59:00 | AAPL | Stock | 13.975 | 13.975 | 13.975 | 13.975 | 8540.0 |
| 2011-08-03 07:00:00 | AAPL | Stock | 13.975 | 13.98 | 13.975 | 13.98 | 36260.0 |
| 2011-08-03 07:01:00 | AAPL | Stock | 13.975 | 13.975 | 13.975 | 13.975 | 5600.0 |
| 2011-08-03 07:02:00 | AAPL | Stock | 13.9725 | 13.9725 | 13.9714 | 13.9714 | 8400.0 |
| 2011-08-03 07:04:00 | AAPL | Stock | 13.9643 | 13.9643 | 13.9643 | 13.9643 | 12712.0 |
| 2011-08-03 07:05:00 | AAPL | Stock | 13.9643 | 13.9643 | 13.9643 | 13.9643 | 7700.0 |
> showing 50 of 1,080,418 rows — these rows as CSV