PREVIEW / stock_1min / 2012-12-07
file: by_date/stock_1min/2012/2012-12-07.parquet size: 12.2 MB rows: 908,478 symbols: 2,814
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 |
|---|---|---|---|---|---|---|---|
| 2012-12-07 04:04:00 | AAPL | Stock | 19.5736 | 19.5736 | 19.5736 | 19.5736 | 2800.0 |
| 2012-12-07 04:05:00 | AAPL | Stock | 19.5739 | 19.5739 | 19.5739 | 19.5739 | 2800.0 |
| 2012-12-07 04:14:00 | AAPL | Stock | 19.5739 | 19.5739 | 19.5739 | 19.5739 | 2800.0 |
| 2012-12-07 04:15:00 | AAPL | Stock | 19.5739 | 19.5739 | 19.5739 | 19.5739 | 2800.0 |
| 2012-12-07 04:30:00 | AAPL | Stock | 19.5829 | 19.5829 | 19.5829 | 19.5829 | 2800.0 |
| 2012-12-07 04:45:00 | AAPL | Stock | 19.6 | 19.6 | 19.6 | 19.6 | 2800.0 |
| 2012-12-07 04:57:00 | AAPL | Stock | 19.6 | 19.6 | 19.6 | 19.6 | 2800.0 |
| 2012-12-07 05:29:00 | AAPL | Stock | 19.5743 | 19.5743 | 19.5743 | 19.5743 | 2800.0 |
| 2012-12-07 05:31:00 | AAPL | Stock | 19.5557 | 19.5557 | 19.5557 | 19.5557 | 2800.0 |
| 2012-12-07 05:33:00 | AAPL | Stock | 19.555 | 19.555 | 19.555 | 19.555 | 2800.0 |
| 2012-12-07 05:34:00 | AAPL | Stock | 19.5507 | 19.5507 | 19.5507 | 19.5507 | 2800.0 |
| 2012-12-07 05:35:00 | AAPL | Stock | 19.54 | 19.54 | 19.54 | 19.54 | 2800.0 |
| 2012-12-07 05:41:00 | AAPL | Stock | 19.5361 | 19.5361 | 19.5361 | 19.5361 | 2800.0 |
| 2012-12-07 05:42:00 | AAPL | Stock | 19.5361 | 19.5361 | 19.5361 | 19.5361 | 5600.0 |
| 2012-12-07 05:56:00 | AAPL | Stock | 19.5536 | 19.5536 | 19.5396 | 19.5396 | 9632.0 |
| 2012-12-07 06:06:00 | AAPL | Stock | 19.5393 | 19.5393 | 19.5393 | 19.5393 | 2800.0 |
| 2012-12-07 06:09:00 | AAPL | Stock | 19.5393 | 19.5393 | 19.5393 | 19.5393 | 2800.0 |
| 2012-12-07 06:11:00 | AAPL | Stock | 19.5625 | 19.5625 | 19.5625 | 19.5625 | 2800.0 |
| 2012-12-07 06:13:00 | AAPL | Stock | 19.5429 | 19.5429 | 19.5429 | 19.5429 | 2800.0 |
| 2012-12-07 06:21:00 | AAPL | Stock | 19.5407 | 19.5407 | 19.5407 | 19.5407 | 2800.0 |
| 2012-12-07 06:30:00 | AAPL | Stock | 19.5357 | 19.5357 | 19.5357 | 19.5357 | 6188.0 |
| 2012-12-07 06:52:00 | AAPL | Stock | 19.5496 | 19.5496 | 19.5496 | 19.5496 | 2800.0 |
| 2012-12-07 06:58:00 | AAPL | Stock | 19.5396 | 19.5396 | 19.5396 | 19.5396 | 5600.0 |
| 2012-12-07 06:59:00 | AAPL | Stock | 19.5396 | 19.5396 | 19.5357 | 19.5357 | 8400.0 |
| 2012-12-07 07:02:00 | AAPL | Stock | 19.5568 | 19.5568 | 19.5568 | 19.5568 | 2800.0 |
| 2012-12-07 07:11:00 | AAPL | Stock | 19.5536 | 19.5536 | 19.5536 | 19.5536 | 2800.0 |
| 2012-12-07 07:12:00 | AAPL | Stock | 19.5661 | 19.5675 | 19.5661 | 19.5675 | 16800.0 |
| 2012-12-07 07:13:00 | AAPL | Stock | 19.5796 | 19.6214 | 19.5796 | 19.6071 | 42000.0 |
| 2012-12-07 07:15:00 | AAPL | Stock | 19.5736 | 19.5736 | 19.5736 | 19.5736 | 5600.0 |
| 2012-12-07 07:18:00 | AAPL | Stock | 19.5886 | 19.5886 | 19.5886 | 19.5886 | 5600.0 |
| 2012-12-07 07:20:00 | AAPL | Stock | 19.6054 | 19.6054 | 19.6054 | 19.6054 | 2800.0 |
| 2012-12-07 07:21:00 | AAPL | Stock | 19.6068 | 19.6071 | 19.6068 | 19.6071 | 19600.0 |
| 2012-12-07 07:22:00 | AAPL | Stock | 19.6232 | 19.6232 | 19.6207 | 19.6207 | 7280.0 |
| 2012-12-07 07:23:00 | AAPL | Stock | 19.6232 | 19.625 | 19.6071 | 19.6071 | 28000.0 |
| 2012-12-07 07:25:00 | AAPL | Stock | 19.6086 | 19.6161 | 19.6086 | 19.6161 | 26628.0 |
| 2012-12-07 07:26:00 | AAPL | Stock | 19.6161 | 19.625 | 19.6161 | 19.625 | 22400.0 |
| 2012-12-07 07:27:00 | AAPL | Stock | 19.625 | 19.625 | 19.625 | 19.625 | 11004.0 |
| 2012-12-07 07:28:00 | AAPL | Stock | 19.6268 | 19.6268 | 19.6268 | 19.6268 | 2800.0 |
| 2012-12-07 07:29:00 | AAPL | Stock | 19.625 | 19.6304 | 19.6161 | 19.6304 | 57260.0 |
| 2012-12-07 07:30:00 | AAPL | Stock | 19.6286 | 19.6304 | 19.6286 | 19.6304 | 19600.0 |
| 2012-12-07 07:31:00 | AAPL | Stock | 19.6189 | 19.6189 | 19.6161 | 19.6161 | 5600.0 |
| 2012-12-07 07:33:00 | AAPL | Stock | 19.6179 | 19.6296 | 19.6179 | 19.6296 | 9324.0 |
| 2012-12-07 07:34:00 | AAPL | Stock | 19.6296 | 19.6429 | 19.6296 | 19.6429 | 63000.0 |
| 2012-12-07 07:35:00 | AAPL | Stock | 19.6536 | 19.6536 | 19.6432 | 19.6432 | 16800.0 |
| 2012-12-07 07:36:00 | AAPL | Stock | 19.6429 | 19.655 | 19.6429 | 19.655 | 37800.0 |
| 2012-12-07 07:37:00 | AAPL | Stock | 19.66 | 19.66 | 19.66 | 19.66 | 2800.0 |
| 2012-12-07 07:39:00 | AAPL | Stock | 19.6679 | 19.6782 | 19.6679 | 19.6782 | 5740.0 |
| 2012-12-07 07:40:00 | AAPL | Stock | 19.6871 | 19.6871 | 19.6871 | 19.6871 | 21028.0 |
| 2012-12-07 07:41:00 | AAPL | Stock | 19.6718 | 19.6729 | 19.6536 | 19.6729 | 26600.0 |
| 2012-12-07 07:42:00 | AAPL | Stock | 19.6529 | 19.6529 | 19.6529 | 19.6529 | 2800.0 |
> showing 50 of 908,478 rows — these rows as CSV