PREVIEW / stock_1min / 2012-04-27
file: by_date/stock_1min/2012/2012-04-27.parquet size: 12.8 MB rows: 954,941 symbols: 2,856
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-04-27 04:17:00 | AAPL | Stock | 21.6136 | 21.6136 | 21.6136 | 21.6136 | 2800.0 |
| 2012-04-27 04:29:00 | AAPL | Stock | 21.6518 | 21.6518 | 21.6429 | 21.6429 | 17360.0 |
| 2012-04-27 04:32:00 | AAPL | Stock | 21.6536 | 21.6536 | 21.6536 | 21.6536 | 5208.0 |
| 2012-04-27 04:35:00 | AAPL | Stock | 21.6536 | 21.6536 | 21.6536 | 21.6536 | 2800.0 |
| 2012-04-27 04:53:00 | AAPL | Stock | 21.6746 | 21.675 | 21.6746 | 21.675 | 8400.0 |
| 2012-04-27 04:56:00 | AAPL | Stock | 21.675 | 21.675 | 21.675 | 21.675 | 2800.0 |
| 2012-04-27 05:10:00 | AAPL | Stock | 21.6768 | 21.6786 | 21.6768 | 21.6786 | 8400.0 |
| 2012-04-27 05:11:00 | AAPL | Stock | 21.6786 | 21.6786 | 21.6786 | 21.6786 | 3500.0 |
| 2012-04-27 05:12:00 | AAPL | Stock | 21.6786 | 21.6786 | 21.6786 | 21.6786 | 4200.0 |
| 2012-04-27 05:32:00 | AAPL | Stock | 21.6436 | 21.6436 | 21.6436 | 21.6436 | 2800.0 |
| 2012-04-27 05:42:00 | AAPL | Stock | 21.6614 | 21.6614 | 21.6614 | 21.6614 | 2800.0 |
| 2012-04-27 05:51:00 | AAPL | Stock | 21.6607 | 21.6607 | 21.6607 | 21.6607 | 5600.0 |
| 2012-04-27 06:06:00 | AAPL | Stock | 21.6782 | 21.6782 | 21.6782 | 21.6782 | 2800.0 |
| 2012-04-27 06:11:00 | AAPL | Stock | 21.6671 | 21.6671 | 21.6671 | 21.6671 | 3500.0 |
| 2012-04-27 06:16:00 | AAPL | Stock | 21.6786 | 21.6786 | 21.6786 | 21.6786 | 5628.0 |
| 2012-04-27 06:18:00 | AAPL | Stock | 21.6786 | 21.6786 | 21.6786 | 21.6786 | 3360.0 |
| 2012-04-27 06:31:00 | AAPL | Stock | 21.6821 | 21.6821 | 21.6821 | 21.6821 | 3108.0 |
| 2012-04-27 06:47:00 | AAPL | Stock | 21.7036 | 21.7036 | 21.7036 | 21.7036 | 2800.0 |
| 2012-04-27 07:01:00 | AAPL | Stock | 21.6964 | 21.6964 | 21.6964 | 21.6964 | 14672.0 |
| 2012-04-27 07:02:00 | AAPL | Stock | 21.6964 | 21.6964 | 21.6964 | 21.6964 | 2800.0 |
| 2012-04-27 07:03:00 | AAPL | Stock | 21.7125 | 21.7168 | 21.7 | 21.7 | 51800.0 |
| 2012-04-27 07:04:00 | AAPL | Stock | 21.7143 | 21.7143 | 21.7143 | 21.7143 | 2800.0 |
| 2012-04-27 07:06:00 | AAPL | Stock | 21.7143 | 21.7143 | 21.7143 | 21.7143 | 5600.0 |
| 2012-04-27 07:11:00 | AAPL | Stock | 21.7179 | 21.7179 | 21.7179 | 21.7179 | 5600.0 |
| 2012-04-27 07:12:00 | AAPL | Stock | 21.7321 | 21.7321 | 21.7321 | 21.7321 | 2800.0 |
| 2012-04-27 07:15:00 | AAPL | Stock | 21.7143 | 21.7143 | 21.7143 | 21.7143 | 18480.0 |
| 2012-04-27 07:16:00 | AAPL | Stock | 21.7143 | 21.7143 | 21.7143 | 21.7143 | 9772.0 |
| 2012-04-27 07:17:00 | AAPL | Stock | 21.7143 | 21.7143 | 21.7143 | 21.7143 | 2800.0 |
| 2012-04-27 07:26:00 | AAPL | Stock | 21.7143 | 21.7143 | 21.7143 | 21.7143 | 3444.0 |
| 2012-04-27 07:29:00 | AAPL | Stock | 21.7143 | 21.7143 | 21.7143 | 21.7143 | 2800.0 |
| 2012-04-27 07:31:00 | AAPL | Stock | 21.7143 | 21.7143 | 21.7143 | 21.7143 | 5600.0 |
| 2012-04-27 07:32:00 | AAPL | Stock | 21.7229 | 21.7232 | 21.7229 | 21.7232 | 16240.0 |
| 2012-04-27 07:35:00 | AAPL | Stock | 21.7143 | 21.7143 | 21.7143 | 21.7143 | 28000.0 |
| 2012-04-27 07:37:00 | AAPL | Stock | 21.7139 | 21.7143 | 21.7139 | 21.7143 | 29232.0 |
| 2012-04-27 07:39:00 | AAPL | Stock | 21.7089 | 21.7089 | 21.7089 | 21.7089 | 2800.0 |
| 2012-04-27 07:44:00 | AAPL | Stock | 21.7036 | 21.7036 | 21.7036 | 21.7036 | 7000.0 |
| 2012-04-27 07:48:00 | AAPL | Stock | 21.7036 | 21.7036 | 21.7036 | 21.7036 | 5600.0 |
| 2012-04-27 07:49:00 | AAPL | Stock | 21.6879 | 21.6879 | 21.6679 | 21.6679 | 10864.0 |
| 2012-04-27 07:50:00 | AAPL | Stock | 21.6964 | 21.6964 | 21.6964 | 21.6964 | 3556.0 |
| 2012-04-27 07:51:00 | AAPL | Stock | 21.6964 | 21.7046 | 21.6964 | 21.7046 | 12292.0 |
| 2012-04-27 07:52:00 | AAPL | Stock | 21.6793 | 21.6793 | 21.6793 | 21.6793 | 2800.0 |
| 2012-04-27 07:53:00 | AAPL | Stock | 21.6875 | 21.6875 | 21.6875 | 21.6875 | 2800.0 |
| 2012-04-27 07:55:00 | AAPL | Stock | 21.6964 | 21.6964 | 21.6964 | 21.6964 | 2800.0 |
| 2012-04-27 07:56:00 | AAPL | Stock | 21.6875 | 21.7039 | 21.6875 | 21.7039 | 42000.0 |
| 2012-04-27 07:57:00 | AAPL | Stock | 21.7054 | 21.7054 | 21.7054 | 21.7054 | 8400.0 |
| 2012-04-27 07:58:00 | AAPL | Stock | 21.7043 | 21.7043 | 21.7043 | 21.7043 | 2800.0 |
| 2012-04-27 08:00:00 | AAPL | Stock | 21.6911 | 21.6964 | 21.6875 | 21.6875 | 31276.0 |
| 2012-04-27 08:01:00 | AAPL | Stock | 21.68 | 21.6929 | 21.6661 | 21.6907 | 81396.0 |
| 2012-04-27 08:02:00 | AAPL | Stock | 21.6643 | 21.7357 | 21.6643 | 21.7357 | 63448.0 |
| 2012-04-27 08:03:00 | AAPL | Stock | 21.6696 | 21.6696 | 21.6696 | 21.6696 | 28000.0 |
> showing 50 of 954,941 rows — these rows as CSV