PREVIEW / stock_1min / 2011-08-19
file: by_date/stock_1min/2011/2011-08-19.parquet size: 14.1 MB rows: 1,054,607 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-19 04:00:00 | AAPL | Stock | 13.1018 | 13.1018 | 12.9875 | 12.9875 | 6132.0 |
| 2011-08-19 04:03:00 | AAPL | Stock | 12.9071 | 12.9071 | 12.9071 | 12.9071 | 2800.0 |
| 2011-08-19 04:16:00 | AAPL | Stock | 12.8396 | 12.8396 | 12.8396 | 12.8396 | 11200.0 |
| 2011-08-19 04:30:00 | AAPL | Stock | 12.8929 | 12.8929 | 12.8929 | 12.8929 | 14000.0 |
| 2011-08-19 04:41:00 | AAPL | Stock | 12.8932 | 12.8932 | 12.8932 | 12.8932 | 11200.0 |
| 2011-08-19 04:51:00 | AAPL | Stock | 12.9246 | 12.9246 | 12.9246 | 12.9246 | 2800.0 |
| 2011-08-19 04:53:00 | AAPL | Stock | 12.9286 | 12.9286 | 12.9286 | 12.9286 | 8400.0 |
| 2011-08-19 04:56:00 | AAPL | Stock | 12.9286 | 12.9286 | 12.9286 | 12.9286 | 2800.0 |
| 2011-08-19 05:21:00 | AAPL | Stock | 12.9357 | 12.9357 | 12.9357 | 12.9357 | 2800.0 |
| 2011-08-19 05:26:00 | AAPL | Stock | 12.9357 | 12.9357 | 12.9357 | 12.9357 | 5600.0 |
| 2011-08-19 05:28:00 | AAPL | Stock | 12.9643 | 12.9643 | 12.9643 | 12.9643 | 2800.0 |
| 2011-08-19 05:38:00 | AAPL | Stock | 12.9357 | 12.9357 | 12.9357 | 12.9357 | 5600.0 |
| 2011-08-19 05:45:00 | AAPL | Stock | 12.9357 | 12.9357 | 12.9357 | 12.9357 | 35840.0 |
| 2011-08-19 05:46:00 | AAPL | Stock | 12.9357 | 12.9357 | 12.9189 | 12.9189 | 5600.0 |
| 2011-08-19 05:57:00 | AAPL | Stock | 12.9414 | 12.9414 | 12.9414 | 12.9414 | 4200.0 |
| 2011-08-19 06:13:00 | AAPL | Stock | 12.9546 | 12.9546 | 12.9546 | 12.9546 | 2800.0 |
| 2011-08-19 06:28:00 | AAPL | Stock | 12.9286 | 12.9286 | 12.9286 | 12.9286 | 5600.0 |
| 2011-08-19 06:29:00 | AAPL | Stock | 12.9286 | 12.9286 | 12.9286 | 12.9286 | 2800.0 |
| 2011-08-19 06:35:00 | AAPL | Stock | 12.9146 | 12.9286 | 12.9146 | 12.9286 | 8400.0 |
| 2011-08-19 06:36:00 | AAPL | Stock | 12.9286 | 12.9286 | 12.9286 | 12.9286 | 5600.0 |
| 2011-08-19 06:41:00 | AAPL | Stock | 12.9279 | 12.9279 | 12.9279 | 12.9279 | 2800.0 |
| 2011-08-19 06:46:00 | AAPL | Stock | 12.9107 | 12.9107 | 12.9107 | 12.9107 | 5600.0 |
| 2011-08-19 06:55:00 | AAPL | Stock | 12.8929 | 12.8929 | 12.8929 | 12.8929 | 16912.0 |
| 2011-08-19 06:58:00 | AAPL | Stock | 12.9246 | 12.9246 | 12.9246 | 12.9246 | 2800.0 |
| 2011-08-19 06:59:00 | AAPL | Stock | 12.9032 | 12.9032 | 12.9032 | 12.9032 | 2800.0 |
| 2011-08-19 07:00:00 | AAPL | Stock | 12.9286 | 12.9293 | 12.9286 | 12.9293 | 14280.0 |
| 2011-08-19 07:01:00 | AAPL | Stock | 12.9425 | 12.9468 | 12.9425 | 12.9468 | 47040.0 |
| 2011-08-19 07:02:00 | AAPL | Stock | 12.9464 | 12.9607 | 12.9436 | 12.9607 | 38976.0 |
| 2011-08-19 07:03:00 | AAPL | Stock | 12.9493 | 12.9493 | 12.9493 | 12.9493 | 8400.0 |
| 2011-08-19 07:04:00 | AAPL | Stock | 12.9379 | 12.9379 | 12.9379 | 12.9379 | 6720.0 |
| 2011-08-19 07:05:00 | AAPL | Stock | 12.9321 | 12.9321 | 12.9286 | 12.9286 | 28700.0 |
| 2011-08-19 07:06:00 | AAPL | Stock | 12.9286 | 12.9296 | 12.9286 | 12.9296 | 19600.0 |
| 2011-08-19 07:07:00 | AAPL | Stock | 12.9286 | 12.9296 | 12.9286 | 12.9286 | 23800.0 |
| 2011-08-19 07:08:00 | AAPL | Stock | 12.9286 | 12.9289 | 12.9286 | 12.9289 | 8400.0 |
| 2011-08-19 07:09:00 | AAPL | Stock | 12.9439 | 12.9446 | 12.9386 | 12.9386 | 25200.0 |
| 2011-08-19 07:12:00 | AAPL | Stock | 12.9464 | 12.9464 | 12.9464 | 12.9464 | 8680.0 |
| 2011-08-19 07:13:00 | AAPL | Stock | 12.9393 | 12.9593 | 12.9393 | 12.9593 | 47600.0 |
| 2011-08-19 07:14:00 | AAPL | Stock | 12.9464 | 12.9468 | 12.9464 | 12.9468 | 5600.0 |
| 2011-08-19 07:15:00 | AAPL | Stock | 12.9464 | 12.9575 | 12.9464 | 12.9575 | 19600.0 |
| 2011-08-19 07:16:00 | AAPL | Stock | 12.9589 | 12.9593 | 12.9589 | 12.9593 | 5600.0 |
| 2011-08-19 07:17:00 | AAPL | Stock | 12.9521 | 12.9521 | 12.9521 | 12.9521 | 2800.0 |
| 2011-08-19 07:18:00 | AAPL | Stock | 12.9593 | 12.9607 | 12.9546 | 12.9546 | 13776.0 |
| 2011-08-19 07:19:00 | AAPL | Stock | 12.9543 | 12.9586 | 12.95 | 12.9546 | 30800.0 |
| 2011-08-19 07:20:00 | AAPL | Stock | 12.9546 | 12.9546 | 12.9464 | 12.9464 | 21420.0 |
| 2011-08-19 07:21:00 | AAPL | Stock | 12.9414 | 12.9414 | 12.9414 | 12.9414 | 6328.0 |
| 2011-08-19 07:23:00 | AAPL | Stock | 12.9446 | 12.9446 | 12.9446 | 12.9446 | 5600.0 |
| 2011-08-19 07:24:00 | AAPL | Stock | 12.9486 | 12.95 | 12.9439 | 12.95 | 27972.0 |
| 2011-08-19 07:25:00 | AAPL | Stock | 12.95 | 12.9518 | 12.95 | 12.9518 | 23436.0 |
| 2011-08-19 07:26:00 | AAPL | Stock | 12.9546 | 12.9546 | 12.9468 | 12.9468 | 5600.0 |
| 2011-08-19 07:28:00 | AAPL | Stock | 12.9543 | 12.9543 | 12.9543 | 12.9543 | 2800.0 |
> showing 50 of 1,054,607 rows — these rows as CSV