PREVIEW / stock_1min / 2011-12-06
file: by_date/stock_1min/2011/2011-12-06.parquet size: 12.7 MB rows: 957,740 symbols: 2,857
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-12-06 04:00:00 | AAPL | Stock | 14.0107 | 14.0107 | 14.0107 | 14.0107 | 2800.0 |
| 2011-12-06 04:04:00 | AAPL | Stock | 14.0429 | 14.0429 | 14.0429 | 14.0429 | 5600.0 |
| 2011-12-06 04:05:00 | AAPL | Stock | 14.0429 | 14.0429 | 14.0429 | 14.0429 | 5600.0 |
| 2011-12-06 04:06:00 | AAPL | Stock | 14.0429 | 14.0429 | 14.0429 | 14.0429 | 5600.0 |
| 2011-12-06 04:27:00 | AAPL | Stock | 14.0357 | 14.0357 | 14.0357 | 14.0357 | 14000.0 |
| 2011-12-06 04:56:00 | AAPL | Stock | 14.0179 | 14.0179 | 14.0179 | 14.0179 | 14000.0 |
| 2011-12-06 05:04:00 | AAPL | Stock | 14.0179 | 14.0179 | 14.0179 | 14.0179 | 2800.0 |
| 2011-12-06 05:05:00 | AAPL | Stock | 14.0179 | 14.0179 | 14.0179 | 14.0179 | 11200.0 |
| 2011-12-06 05:24:00 | AAPL | Stock | 14.0179 | 14.0179 | 14.0179 | 14.0179 | 14000.0 |
| 2011-12-06 05:38:00 | AAPL | Stock | 14.0286 | 14.0286 | 14.0286 | 14.0286 | 5600.0 |
| 2011-12-06 05:39:00 | AAPL | Stock | 14.0286 | 14.0286 | 14.0286 | 14.0286 | 5600.0 |
| 2011-12-06 05:43:00 | AAPL | Stock | 14.0357 | 14.0357 | 14.0357 | 14.0357 | 14000.0 |
| 2011-12-06 05:45:00 | AAPL | Stock | 14.0357 | 14.0357 | 14.0232 | 14.0232 | 11200.0 |
| 2011-12-06 05:51:00 | AAPL | Stock | 14.0339 | 14.0339 | 14.0339 | 14.0339 | 3108.0 |
| 2011-12-06 05:54:00 | AAPL | Stock | 14.0357 | 14.0357 | 14.0357 | 14.0357 | 5600.0 |
| 2011-12-06 05:59:00 | AAPL | Stock | 14.0429 | 14.0429 | 14.0429 | 14.0429 | 5600.0 |
| 2011-12-06 06:23:00 | AAPL | Stock | 14.0446 | 14.0446 | 14.0446 | 14.0446 | 2800.0 |
| 2011-12-06 06:47:00 | AAPL | Stock | 14.0143 | 14.0143 | 14.0143 | 14.0143 | 5600.0 |
| 2011-12-06 07:00:00 | AAPL | Stock | 14.0536 | 14.0536 | 14.0536 | 14.0536 | 2800.0 |
| 2011-12-06 07:04:00 | AAPL | Stock | 14.0357 | 14.0357 | 14.0357 | 14.0357 | 2800.0 |
| 2011-12-06 07:08:00 | AAPL | Stock | 14.0286 | 14.0286 | 14.0286 | 14.0286 | 8400.0 |
| 2011-12-06 07:23:00 | AAPL | Stock | 14.0393 | 14.0393 | 14.0393 | 14.0393 | 2800.0 |
| 2011-12-06 07:38:00 | AAPL | Stock | 14.0464 | 14.0464 | 14.0464 | 14.0464 | 8400.0 |
| 2011-12-06 07:39:00 | AAPL | Stock | 14.0464 | 14.0471 | 14.0464 | 14.0471 | 14000.0 |
| 2011-12-06 07:40:00 | AAPL | Stock | 14.0486 | 14.05 | 14.0486 | 14.05 | 14000.0 |
| 2011-12-06 07:42:00 | AAPL | Stock | 14.04 | 14.04 | 14.04 | 14.04 | 2800.0 |
| 2011-12-06 07:47:00 | AAPL | Stock | 14.0361 | 14.0361 | 14.0361 | 14.0361 | 2800.0 |
| 2011-12-06 07:48:00 | AAPL | Stock | 14.0275 | 14.0275 | 14.0275 | 14.0275 | 5600.0 |
| 2011-12-06 07:52:00 | AAPL | Stock | 14.0271 | 14.0271 | 14.0271 | 14.0271 | 2800.0 |
| 2011-12-06 08:00:00 | AAPL | Stock | 14.0357 | 14.0411 | 14.0357 | 14.0411 | 33600.0 |
| 2011-12-06 08:02:00 | AAPL | Stock | 14.0325 | 14.0368 | 14.0325 | 14.0368 | 8400.0 |
| 2011-12-06 08:03:00 | AAPL | Stock | 14.0286 | 14.0286 | 14.0286 | 14.0286 | 7000.0 |
| 2011-12-06 08:04:00 | AAPL | Stock | 14.0357 | 14.0357 | 14.0357 | 14.0357 | 8400.0 |
| 2011-12-06 08:05:00 | AAPL | Stock | 14.0357 | 14.0357 | 14.03 | 14.0314 | 28980.0 |
| 2011-12-06 08:06:00 | AAPL | Stock | 14.0314 | 14.0314 | 14.025 | 14.025 | 54320.0 |
| 2011-12-06 08:07:00 | AAPL | Stock | 14.025 | 14.025 | 14.0239 | 14.0239 | 14000.0 |
| 2011-12-06 08:08:00 | AAPL | Stock | 14.0179 | 14.0214 | 14.0179 | 14.0182 | 29680.0 |
| 2011-12-06 08:09:00 | AAPL | Stock | 14.0304 | 14.0304 | 14.0304 | 14.0304 | 2800.0 |
| 2011-12-06 08:17:00 | AAPL | Stock | 14.0225 | 14.0225 | 14.0107 | 14.0107 | 32900.0 |
| 2011-12-06 08:19:00 | AAPL | Stock | 14.0107 | 14.0107 | 14.0036 | 14.0036 | 29680.0 |
| 2011-12-06 08:21:00 | AAPL | Stock | 14.0071 | 14.0071 | 14.0071 | 14.0071 | 2800.0 |
| 2011-12-06 08:22:00 | AAPL | Stock | 14.0061 | 14.0061 | 14.0 | 14.0 | 31164.0 |
| 2011-12-06 08:24:00 | AAPL | Stock | 13.9929 | 13.995 | 13.9904 | 13.9904 | 46200.0 |
| 2011-12-06 08:25:00 | AAPL | Stock | 13.9904 | 13.9904 | 13.9904 | 13.9904 | 2800.0 |
| 2011-12-06 08:26:00 | AAPL | Stock | 13.9779 | 13.9779 | 13.9757 | 13.9757 | 26180.0 |
| 2011-12-06 08:27:00 | AAPL | Stock | 13.9821 | 13.9821 | 13.9821 | 13.9821 | 2800.0 |
| 2011-12-06 08:28:00 | AAPL | Stock | 13.9732 | 13.9732 | 13.9732 | 13.9732 | 2800.0 |
| 2011-12-06 08:29:00 | AAPL | Stock | 13.9754 | 13.9754 | 13.9754 | 13.9754 | 2800.0 |
| 2011-12-06 08:30:00 | AAPL | Stock | 13.9736 | 13.9736 | 13.9736 | 13.9736 | 5880.0 |
| 2011-12-06 08:31:00 | AAPL | Stock | 13.9736 | 13.9757 | 13.9736 | 13.9757 | 19880.0 |
> showing 50 of 957,740 rows — these rows as CSV