PREVIEW / stock_1min / 2012-06-04
file: by_date/stock_1min/2012/2012-06-04.parquet size: 13.4 MB rows: 1,000,465 symbols: 2,858
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-06-04 04:00:00 | AAPL | Stock | 19.9643 | 19.9643 | 19.8682 | 19.8682 | 5600.0 |
| 2012-06-04 04:03:00 | AAPL | Stock | 19.8936 | 19.8936 | 19.8936 | 19.8936 | 2800.0 |
| 2012-06-04 04:05:00 | AAPL | Stock | 19.8646 | 19.8646 | 19.8646 | 19.8646 | 9044.0 |
| 2012-06-04 04:06:00 | AAPL | Stock | 19.8625 | 19.8625 | 19.8625 | 19.8625 | 8400.0 |
| 2012-06-04 04:07:00 | AAPL | Stock | 19.8625 | 19.8625 | 19.8625 | 19.8625 | 8400.0 |
| 2012-06-04 04:08:00 | AAPL | Stock | 19.8625 | 19.8625 | 19.8625 | 19.8625 | 5600.0 |
| 2012-06-04 04:10:00 | AAPL | Stock | 19.8821 | 19.8821 | 19.8821 | 19.8821 | 7000.0 |
| 2012-06-04 04:11:00 | AAPL | Stock | 19.875 | 19.875 | 19.875 | 19.875 | 5600.0 |
| 2012-06-04 04:12:00 | AAPL | Stock | 19.8857 | 19.8857 | 19.8857 | 19.8857 | 3444.0 |
| 2012-06-04 04:13:00 | AAPL | Stock | 19.8857 | 19.8857 | 19.8857 | 19.8857 | 8400.0 |
| 2012-06-04 04:19:00 | AAPL | Stock | 19.8893 | 19.8893 | 19.8893 | 19.8893 | 11200.0 |
| 2012-06-04 04:20:00 | AAPL | Stock | 19.8893 | 19.8893 | 19.8893 | 19.8893 | 2800.0 |
| 2012-06-04 04:31:00 | AAPL | Stock | 19.8536 | 19.8536 | 19.8536 | 19.8536 | 2800.0 |
| 2012-06-04 04:46:00 | AAPL | Stock | 19.8529 | 19.8529 | 19.8529 | 19.8529 | 25760.0 |
| 2012-06-04 04:58:00 | AAPL | Stock | 19.8571 | 19.8571 | 19.8571 | 19.8571 | 5460.0 |
| 2012-06-04 05:13:00 | AAPL | Stock | 19.8571 | 19.8571 | 19.8571 | 19.8571 | 5600.0 |
| 2012-06-04 05:16:00 | AAPL | Stock | 19.8857 | 19.8857 | 19.8857 | 19.8857 | 14000.0 |
| 2012-06-04 05:17:00 | AAPL | Stock | 19.8857 | 19.8857 | 19.8857 | 19.8857 | 14000.0 |
| 2012-06-04 05:30:00 | AAPL | Stock | 19.8929 | 19.8929 | 19.8929 | 19.8929 | 2800.0 |
| 2012-06-04 05:35:00 | AAPL | Stock | 19.8932 | 19.8932 | 19.8932 | 19.8932 | 2800.0 |
| 2012-06-04 05:36:00 | AAPL | Stock | 19.8929 | 19.8929 | 19.8929 | 19.8929 | 2800.0 |
| 2012-06-04 05:49:00 | AAPL | Stock | 19.9071 | 19.9071 | 19.9071 | 19.9071 | 5600.0 |
| 2012-06-04 05:50:00 | AAPL | Stock | 19.9071 | 19.9071 | 19.9071 | 19.9071 | 2800.0 |
| 2012-06-04 05:51:00 | AAPL | Stock | 19.9107 | 19.9286 | 19.9107 | 19.9286 | 8876.0 |
| 2012-06-04 05:52:00 | AAPL | Stock | 19.9107 | 19.9107 | 19.9107 | 19.9107 | 2800.0 |
| 2012-06-04 05:53:00 | AAPL | Stock | 19.9107 | 19.9107 | 19.9107 | 19.9107 | 2800.0 |
| 2012-06-04 06:05:00 | AAPL | Stock | 19.9321 | 19.9357 | 19.9321 | 19.9357 | 11200.0 |
| 2012-06-04 06:08:00 | AAPL | Stock | 19.9446 | 19.9446 | 19.9446 | 19.9446 | 2800.0 |
| 2012-06-04 06:10:00 | AAPL | Stock | 19.9525 | 19.9643 | 19.9525 | 19.9643 | 26320.0 |
| 2012-06-04 06:16:00 | AAPL | Stock | 19.9321 | 19.9321 | 19.9321 | 19.9321 | 5600.0 |
| 2012-06-04 06:20:00 | AAPL | Stock | 19.9339 | 19.9339 | 19.9339 | 19.9339 | 2800.0 |
| 2012-06-04 06:21:00 | AAPL | Stock | 19.9339 | 19.9339 | 19.9339 | 19.9339 | 5180.0 |
| 2012-06-04 06:25:00 | AAPL | Stock | 19.9536 | 19.9536 | 19.9536 | 19.9536 | 2800.0 |
| 2012-06-04 06:28:00 | AAPL | Stock | 19.9536 | 19.9639 | 19.9536 | 19.9639 | 11200.0 |
| 2012-06-04 06:32:00 | AAPL | Stock | 19.9643 | 19.9643 | 19.9643 | 19.9643 | 2800.0 |
| 2012-06-04 06:38:00 | AAPL | Stock | 19.9714 | 19.9714 | 19.9714 | 19.9714 | 5600.0 |
| 2012-06-04 06:49:00 | AAPL | Stock | 20.0321 | 20.0321 | 20.0321 | 20.0321 | 5600.0 |
| 2012-06-04 06:51:00 | AAPL | Stock | 20.0354 | 20.0357 | 20.0354 | 20.0357 | 29400.0 |
| 2012-06-04 06:52:00 | AAPL | Stock | 20.0357 | 20.0357 | 20.0357 | 20.0357 | 2800.0 |
| 2012-06-04 06:53:00 | AAPL | Stock | 20.0357 | 20.0357 | 20.0357 | 20.0357 | 2800.0 |
| 2012-06-04 06:54:00 | AAPL | Stock | 20.0357 | 20.0357 | 20.0357 | 20.0357 | 15960.0 |
| 2012-06-04 07:00:00 | AAPL | Stock | 20.0357 | 20.0357 | 20.0357 | 20.0357 | 5684.0 |
| 2012-06-04 07:01:00 | AAPL | Stock | 20.0186 | 20.0186 | 20.0186 | 20.0186 | 8400.0 |
| 2012-06-04 07:02:00 | AAPL | Stock | 20.0 | 20.0 | 20.0 | 20.0 | 2800.0 |
| 2012-06-04 07:03:00 | AAPL | Stock | 20.0179 | 20.0179 | 20.0179 | 20.0179 | 16800.0 |
| 2012-06-04 07:04:00 | AAPL | Stock | 20.025 | 20.0357 | 20.025 | 20.0357 | 18116.0 |
| 2012-06-04 07:05:00 | AAPL | Stock | 20.0361 | 20.0368 | 20.0354 | 20.0354 | 8400.0 |
| 2012-06-04 07:07:00 | AAPL | Stock | 20.0489 | 20.0489 | 20.0489 | 20.0489 | 2800.0 |
| 2012-06-04 07:09:00 | AAPL | Stock | 20.0357 | 20.0357 | 20.0357 | 20.0357 | 12600.0 |
| 2012-06-04 07:11:00 | AAPL | Stock | 20.0389 | 20.0389 | 20.0357 | 20.0357 | 16380.0 |
> showing 50 of 1,000,465 rows — these rows as CSV