PREVIEW / stock_1min / 2012-11-06
file: by_date/stock_1min/2012/2012-11-06.parquet size: 12.5 MB rows: 936,235 symbols: 2,813
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-11-06 05:25:00 | AAPL | Stock | 20.9786 | 20.9786 | 20.9786 | 20.9786 | 2800.0 |
| 2012-11-06 05:57:00 | AAPL | Stock | 20.9786 | 20.9786 | 20.9786 | 20.9786 | 2800.0 |
| 2012-11-06 05:59:00 | AAPL | Stock | 20.9786 | 20.9786 | 20.9786 | 20.9786 | 2800.0 |
| 2012-11-06 06:00:00 | AAPL | Stock | 20.9786 | 20.9786 | 20.9786 | 20.9786 | 2800.0 |
| 2012-11-06 06:01:00 | AAPL | Stock | 20.9786 | 20.9786 | 20.9786 | 20.9786 | 5460.0 |
| 2012-11-06 06:04:00 | AAPL | Stock | 20.9782 | 20.9782 | 20.9782 | 20.9782 | 2800.0 |
| 2012-11-06 06:05:00 | AAPL | Stock | 20.9786 | 20.9786 | 20.9786 | 20.9786 | 5600.0 |
| 2012-11-06 06:25:00 | AAPL | Stock | 20.9893 | 21.0107 | 20.9893 | 21.0107 | 6440.0 |
| 2012-11-06 06:31:00 | AAPL | Stock | 21.0107 | 21.0107 | 21.0107 | 21.0107 | 26264.0 |
| 2012-11-06 06:32:00 | AAPL | Stock | 21.0107 | 21.0107 | 21.0107 | 21.0107 | 56364.0 |
| 2012-11-06 06:34:00 | AAPL | Stock | 21.0107 | 21.0107 | 21.0107 | 21.0107 | 15456.0 |
| 2012-11-06 06:44:00 | AAPL | Stock | 21.0221 | 21.0221 | 21.0221 | 21.0221 | 2800.0 |
| 2012-11-06 06:46:00 | AAPL | Stock | 21.0221 | 21.0221 | 21.0221 | 21.0221 | 2800.0 |
| 2012-11-06 06:50:00 | AAPL | Stock | 21.0179 | 21.0179 | 21.0179 | 21.0179 | 2800.0 |
| 2012-11-06 06:51:00 | AAPL | Stock | 21.0179 | 21.0179 | 21.0179 | 21.0179 | 12600.0 |
| 2012-11-06 06:53:00 | AAPL | Stock | 21.0261 | 21.0261 | 21.0261 | 21.0261 | 2800.0 |
| 2012-11-06 07:00:00 | AAPL | Stock | 21.0179 | 21.0357 | 21.0179 | 21.0182 | 56392.0 |
| 2012-11-06 07:02:00 | AAPL | Stock | 21.0357 | 21.0357 | 21.0357 | 21.0357 | 2800.0 |
| 2012-11-06 07:04:00 | AAPL | Stock | 21.0357 | 21.0357 | 21.0357 | 21.0357 | 5880.0 |
| 2012-11-06 07:05:00 | AAPL | Stock | 21.0493 | 21.0493 | 21.0361 | 21.0361 | 30800.0 |
| 2012-11-06 07:06:00 | AAPL | Stock | 21.0371 | 21.0371 | 21.0371 | 21.0371 | 2968.0 |
| 2012-11-06 07:07:00 | AAPL | Stock | 21.0357 | 21.0357 | 21.0357 | 21.0357 | 11424.0 |
| 2012-11-06 07:08:00 | AAPL | Stock | 21.0411 | 21.0496 | 21.0364 | 21.0368 | 33040.0 |
| 2012-11-06 07:09:00 | AAPL | Stock | 21.0375 | 21.0489 | 21.0375 | 21.0489 | 5600.0 |
| 2012-11-06 07:10:00 | AAPL | Stock | 21.0446 | 21.0471 | 21.0446 | 21.0464 | 25900.0 |
| 2012-11-06 07:11:00 | AAPL | Stock | 21.0375 | 21.0375 | 21.0375 | 21.0375 | 2800.0 |
| 2012-11-06 07:12:00 | AAPL | Stock | 21.0371 | 21.0371 | 21.0371 | 21.0371 | 2800.0 |
| 2012-11-06 07:13:00 | AAPL | Stock | 21.0446 | 21.0461 | 21.0446 | 21.0461 | 5600.0 |
| 2012-11-06 07:16:00 | AAPL | Stock | 21.0396 | 21.0396 | 21.0357 | 21.0357 | 83188.0 |
| 2012-11-06 07:17:00 | AAPL | Stock | 21.0296 | 21.0357 | 21.0289 | 21.0357 | 14000.0 |
| 2012-11-06 07:19:00 | AAPL | Stock | 21.0357 | 21.0396 | 21.0357 | 21.0396 | 10612.0 |
| 2012-11-06 07:20:00 | AAPL | Stock | 21.0304 | 21.0304 | 21.0304 | 21.0304 | 2800.0 |
| 2012-11-06 07:21:00 | AAPL | Stock | 21.0287 | 21.0287 | 21.0211 | 21.0211 | 88872.0 |
| 2012-11-06 07:23:00 | AAPL | Stock | 21.0282 | 21.0304 | 21.0282 | 21.0304 | 5600.0 |
| 2012-11-06 07:25:00 | AAPL | Stock | 21.0296 | 21.0304 | 21.0296 | 21.0304 | 12628.0 |
| 2012-11-06 07:26:00 | AAPL | Stock | 21.0446 | 21.0446 | 21.0446 | 21.0446 | 24780.0 |
| 2012-11-06 07:27:00 | AAPL | Stock | 21.0461 | 21.0461 | 21.0461 | 21.0461 | 2800.0 |
| 2012-11-06 07:33:00 | AAPL | Stock | 21.0446 | 21.0446 | 21.0364 | 21.0364 | 14000.0 |
| 2012-11-06 07:34:00 | AAPL | Stock | 21.0379 | 21.0596 | 21.0379 | 21.0596 | 25760.0 |
| 2012-11-06 07:35:00 | AAPL | Stock | 21.0604 | 21.0632 | 21.0593 | 21.0593 | 22904.0 |
| 2012-11-06 07:36:00 | AAPL | Stock | 21.0586 | 21.0586 | 21.0568 | 21.0568 | 12040.0 |
| 2012-11-06 07:37:00 | AAPL | Stock | 21.0511 | 21.0514 | 21.0511 | 21.0514 | 6160.0 |
| 2012-11-06 07:38:00 | AAPL | Stock | 21.0518 | 21.0518 | 21.0357 | 21.0357 | 56196.0 |
| 2012-11-06 07:39:00 | AAPL | Stock | 21.0354 | 21.0375 | 21.0179 | 21.0179 | 120092.0 |
| 2012-11-06 07:40:00 | AAPL | Stock | 21.0229 | 21.0304 | 21.0179 | 21.0304 | 70000.0 |
| 2012-11-06 07:42:00 | AAPL | Stock | 21.0311 | 21.0321 | 21.0311 | 21.0321 | 5600.0 |
| 2012-11-06 07:43:00 | AAPL | Stock | 21.0321 | 21.0357 | 21.0314 | 21.0357 | 26376.0 |
| 2012-11-06 07:45:00 | AAPL | Stock | 21.0357 | 21.0357 | 21.0357 | 21.0357 | 2800.0 |
| 2012-11-06 07:46:00 | AAPL | Stock | 21.0357 | 21.0357 | 21.0357 | 21.0357 | 2800.0 |
| 2012-11-06 07:49:00 | AAPL | Stock | 21.0357 | 21.0357 | 21.0352 | 21.0357 | 46872.0 |
> showing 50 of 936,235 rows — these rows as CSV