PREVIEW / stock_1min / 2011-09-21
file: by_date/stock_1min/2011/2011-09-21.parquet size: 13.2 MB rows: 986,554 symbols: 2,830
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-09-21 04:05:00 | AAPL | Stock | 14.8457 | 14.8475 | 14.8457 | 14.8475 | 16800.0 |
| 2011-09-21 04:06:00 | AAPL | Stock | 14.8468 | 14.8468 | 14.8393 | 14.8393 | 8400.0 |
| 2011-09-21 04:10:00 | AAPL | Stock | 14.8475 | 14.8475 | 14.8475 | 14.8475 | 2800.0 |
| 2011-09-21 04:17:00 | AAPL | Stock | 14.8214 | 14.8214 | 14.8214 | 14.8214 | 2800.0 |
| 2011-09-21 04:37:00 | AAPL | Stock | 14.7793 | 14.7793 | 14.7793 | 14.7793 | 2800.0 |
| 2011-09-21 04:38:00 | AAPL | Stock | 14.7964 | 14.7964 | 14.7964 | 14.7964 | 13720.0 |
| 2011-09-21 04:41:00 | AAPL | Stock | 14.7818 | 14.7818 | 14.7818 | 14.7818 | 2800.0 |
| 2011-09-21 04:53:00 | AAPL | Stock | 14.8039 | 14.8039 | 14.8039 | 14.8039 | 2800.0 |
| 2011-09-21 05:09:00 | AAPL | Stock | 14.8129 | 14.8129 | 14.8129 | 14.8129 | 2800.0 |
| 2011-09-21 05:16:00 | AAPL | Stock | 14.8343 | 14.8343 | 14.8343 | 14.8343 | 2800.0 |
| 2011-09-21 05:20:00 | AAPL | Stock | 14.8457 | 14.8468 | 14.8457 | 14.8468 | 8400.0 |
| 2011-09-21 05:21:00 | AAPL | Stock | 14.8343 | 14.8343 | 14.8343 | 14.8343 | 2800.0 |
| 2011-09-21 05:36:00 | AAPL | Stock | 14.8736 | 14.8736 | 14.8736 | 14.8736 | 2800.0 |
| 2011-09-21 05:47:00 | AAPL | Stock | 14.8557 | 14.8557 | 14.8557 | 14.8557 | 2800.0 |
| 2011-09-21 06:01:00 | AAPL | Stock | 14.8321 | 14.8321 | 14.8321 | 14.8321 | 2800.0 |
| 2011-09-21 06:02:00 | AAPL | Stock | 14.8286 | 14.8286 | 14.8286 | 14.8286 | 2800.0 |
| 2011-09-21 06:28:00 | AAPL | Stock | 14.8364 | 14.8364 | 14.8364 | 14.8364 | 2800.0 |
| 2011-09-21 06:32:00 | AAPL | Stock | 14.8386 | 14.8386 | 14.8386 | 14.8386 | 2800.0 |
| 2011-09-21 06:54:00 | AAPL | Stock | 14.8254 | 14.8254 | 14.8254 | 14.8254 | 2800.0 |
| 2011-09-21 07:01:00 | AAPL | Stock | 14.8254 | 14.8254 | 14.8254 | 14.8254 | 8400.0 |
| 2011-09-21 07:02:00 | AAPL | Stock | 14.8257 | 14.8543 | 14.825 | 14.8543 | 28000.0 |
| 2011-09-21 07:03:00 | AAPL | Stock | 14.8571 | 14.8664 | 14.8546 | 14.8546 | 107800.0 |
| 2011-09-21 07:04:00 | AAPL | Stock | 14.8611 | 14.8696 | 14.8611 | 14.8696 | 8400.0 |
| 2011-09-21 07:05:00 | AAPL | Stock | 14.8796 | 14.8807 | 14.8746 | 14.8807 | 12600.0 |
| 2011-09-21 07:06:00 | AAPL | Stock | 14.8886 | 14.91 | 14.8796 | 14.91 | 25200.0 |
| 2011-09-21 07:07:00 | AAPL | Stock | 14.8986 | 14.9179 | 14.8936 | 14.9179 | 82880.0 |
| 2011-09-21 07:08:00 | AAPL | Stock | 14.9104 | 14.9104 | 14.9104 | 14.9104 | 2800.0 |
| 2011-09-21 07:11:00 | AAPL | Stock | 14.9107 | 14.9107 | 14.9107 | 14.9107 | 14000.0 |
| 2011-09-21 07:12:00 | AAPL | Stock | 14.9107 | 14.9107 | 14.9107 | 14.9107 | 8400.0 |
| 2011-09-21 07:15:00 | AAPL | Stock | 14.8929 | 14.8929 | 14.8929 | 14.8929 | 2800.0 |
| 2011-09-21 07:16:00 | AAPL | Stock | 14.8929 | 14.8929 | 14.8696 | 14.875 | 74368.0 |
| 2011-09-21 07:17:00 | AAPL | Stock | 14.8696 | 14.8696 | 14.8696 | 14.8696 | 14000.0 |
| 2011-09-21 07:18:00 | AAPL | Stock | 14.87 | 14.8889 | 14.8696 | 14.8889 | 39200.0 |
| 2011-09-21 07:19:00 | AAPL | Stock | 14.8839 | 14.8839 | 14.875 | 14.875 | 14000.0 |
| 2011-09-21 07:20:00 | AAPL | Stock | 14.8696 | 14.8736 | 14.8429 | 14.8604 | 42532.0 |
| 2011-09-21 07:21:00 | AAPL | Stock | 14.875 | 14.875 | 14.875 | 14.875 | 11200.0 |
| 2011-09-21 07:22:00 | AAPL | Stock | 14.875 | 14.875 | 14.875 | 14.875 | 17920.0 |
| 2011-09-21 07:23:00 | AAPL | Stock | 14.8804 | 14.8804 | 14.8804 | 14.8804 | 2800.0 |
| 2011-09-21 07:24:00 | AAPL | Stock | 14.875 | 14.875 | 14.875 | 14.875 | 2800.0 |
| 2011-09-21 07:25:00 | AAPL | Stock | 14.8804 | 14.8804 | 14.8804 | 14.8804 | 8120.0 |
| 2011-09-21 07:26:00 | AAPL | Stock | 14.8929 | 14.8946 | 14.8929 | 14.8936 | 45640.0 |
| 2011-09-21 07:27:00 | AAPL | Stock | 14.9029 | 14.9029 | 14.9029 | 14.9029 | 2800.0 |
| 2011-09-21 07:28:00 | AAPL | Stock | 14.8936 | 14.9107 | 14.8929 | 14.9107 | 74200.0 |
| 2011-09-21 07:29:00 | AAPL | Stock | 14.9221 | 14.9221 | 14.9221 | 14.9221 | 2800.0 |
| 2011-09-21 07:30:00 | AAPL | Stock | 14.9221 | 14.9221 | 14.8957 | 14.8957 | 142100.0 |
| 2011-09-21 07:31:00 | AAPL | Stock | 14.9014 | 14.9018 | 14.9014 | 14.9018 | 19600.0 |
| 2011-09-21 07:34:00 | AAPL | Stock | 14.8989 | 14.8989 | 14.8989 | 14.8989 | 2800.0 |
| 2011-09-21 07:35:00 | AAPL | Stock | 14.8982 | 14.9071 | 14.8982 | 14.9071 | 5600.0 |
| 2011-09-21 07:36:00 | AAPL | Stock | 14.9032 | 14.9032 | 14.9032 | 14.9032 | 2800.0 |
| 2011-09-21 07:37:00 | AAPL | Stock | 14.9032 | 14.9032 | 14.9032 | 14.9032 | 2800.0 |
> showing 50 of 986,554 rows — these rows as CSV