PREVIEW / stock_1min / 2011-12-01
file: by_date/stock_1min/2011/2011-12-01.parquet size: 13.3 MB rows: 999,582 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 |
|---|---|---|---|---|---|---|---|
| 2011-12-01 04:11:00 | AAPL | Stock | 13.5957 | 13.5957 | 13.5957 | 13.5957 | 5600.0 |
| 2011-12-01 04:26:00 | AAPL | Stock | 13.5954 | 13.5954 | 13.5954 | 13.5954 | 5600.0 |
| 2011-12-01 04:27:00 | AAPL | Stock | 13.5954 | 13.5954 | 13.5954 | 13.5954 | 2800.0 |
| 2011-12-01 04:34:00 | AAPL | Stock | 13.6 | 13.6 | 13.6 | 13.6 | 2800.0 |
| 2011-12-01 04:38:00 | AAPL | Stock | 13.6 | 13.6 | 13.6 | 13.6 | 2800.0 |
| 2011-12-01 04:40:00 | AAPL | Stock | 13.6 | 13.6 | 13.6 | 13.6 | 2800.0 |
| 2011-12-01 04:46:00 | AAPL | Stock | 13.6 | 13.6 | 13.6 | 13.6 | 2800.0 |
| 2011-12-01 05:18:00 | AAPL | Stock | 13.625 | 13.625 | 13.625 | 13.625 | 2800.0 |
| 2011-12-01 05:19:00 | AAPL | Stock | 13.625 | 13.625 | 13.625 | 13.625 | 2800.0 |
| 2011-12-01 05:25:00 | AAPL | Stock | 13.6321 | 13.6321 | 13.6321 | 13.6321 | 2800.0 |
| 2011-12-01 05:29:00 | AAPL | Stock | 13.6321 | 13.6321 | 13.6321 | 13.6321 | 2800.0 |
| 2011-12-01 05:39:00 | AAPL | Stock | 13.6429 | 13.6429 | 13.6429 | 13.6429 | 10640.0 |
| 2011-12-01 06:56:00 | AAPL | Stock | 13.6379 | 13.6429 | 13.6379 | 13.6429 | 33740.0 |
| 2011-12-01 07:01:00 | AAPL | Stock | 13.65 | 13.65 | 13.65 | 13.65 | 5600.0 |
| 2011-12-01 07:02:00 | AAPL | Stock | 13.6782 | 13.6782 | 13.6782 | 13.6782 | 2800.0 |
| 2011-12-01 07:03:00 | AAPL | Stock | 13.6889 | 13.6889 | 13.6786 | 13.6786 | 16800.0 |
| 2011-12-01 07:04:00 | AAPL | Stock | 13.6786 | 13.6789 | 13.6786 | 13.6786 | 16800.0 |
| 2011-12-01 07:05:00 | AAPL | Stock | 13.6882 | 13.6996 | 13.6882 | 13.6996 | 28000.0 |
| 2011-12-01 07:12:00 | AAPL | Stock | 13.6954 | 13.6954 | 13.6954 | 13.6954 | 5600.0 |
| 2011-12-01 07:13:00 | AAPL | Stock | 13.6893 | 13.695 | 13.6893 | 13.6893 | 16800.0 |
| 2011-12-01 07:18:00 | AAPL | Stock | 13.6875 | 13.6875 | 13.6875 | 13.6875 | 25200.0 |
| 2011-12-01 07:19:00 | AAPL | Stock | 13.6875 | 13.6879 | 13.6875 | 13.6875 | 33600.0 |
| 2011-12-01 07:24:00 | AAPL | Stock | 13.6875 | 13.6875 | 13.6875 | 13.6875 | 2800.0 |
| 2011-12-01 07:25:00 | AAPL | Stock | 13.6957 | 13.6957 | 13.6957 | 13.6957 | 28000.0 |
| 2011-12-01 07:27:00 | AAPL | Stock | 13.6846 | 13.6846 | 13.6846 | 13.6846 | 2800.0 |
| 2011-12-01 07:32:00 | AAPL | Stock | 13.6957 | 13.6964 | 13.6957 | 13.6964 | 12460.0 |
| 2011-12-01 07:33:00 | AAPL | Stock | 13.7 | 13.7 | 13.7 | 13.7 | 8260.0 |
| 2011-12-01 07:34:00 | AAPL | Stock | 13.7 | 13.7 | 13.7 | 13.7 | 75600.0 |
| 2011-12-01 07:35:00 | AAPL | Stock | 13.7071 | 13.7071 | 13.7071 | 13.7071 | 2800.0 |
| 2011-12-01 07:36:00 | AAPL | Stock | 13.7071 | 13.7104 | 13.7071 | 13.7096 | 16800.0 |
| 2011-12-01 07:37:00 | AAPL | Stock | 13.7071 | 13.7071 | 13.7071 | 13.7071 | 4480.0 |
| 2011-12-01 07:38:00 | AAPL | Stock | 13.7096 | 13.7096 | 13.7086 | 13.7086 | 5600.0 |
| 2011-12-01 07:39:00 | AAPL | Stock | 13.7107 | 13.7107 | 13.7107 | 13.7107 | 2800.0 |
| 2011-12-01 07:40:00 | AAPL | Stock | 13.7104 | 13.7104 | 13.7104 | 13.7104 | 2800.0 |
| 2011-12-01 07:41:00 | AAPL | Stock | 13.7021 | 13.7021 | 13.7021 | 13.7021 | 2800.0 |
| 2011-12-01 07:43:00 | AAPL | Stock | 13.7 | 13.7 | 13.7 | 13.7 | 8400.0 |
| 2011-12-01 07:47:00 | AAPL | Stock | 13.7054 | 13.7107 | 13.7054 | 13.7107 | 5600.0 |
| 2011-12-01 07:48:00 | AAPL | Stock | 13.7093 | 13.7093 | 13.7093 | 13.7093 | 5600.0 |
| 2011-12-01 07:49:00 | AAPL | Stock | 13.7107 | 13.7107 | 13.7107 | 13.7107 | 14000.0 |
| 2011-12-01 07:50:00 | AAPL | Stock | 13.7107 | 13.7107 | 13.7107 | 13.7107 | 14000.0 |
| 2011-12-01 07:51:00 | AAPL | Stock | 13.7039 | 13.7039 | 13.6964 | 13.6964 | 42000.0 |
| 2011-12-01 07:52:00 | AAPL | Stock | 13.6971 | 13.6971 | 13.6964 | 13.6964 | 30800.0 |
| 2011-12-01 07:54:00 | AAPL | Stock | 13.6964 | 13.6964 | 13.6964 | 13.6964 | 13300.0 |
| 2011-12-01 07:55:00 | AAPL | Stock | 13.6964 | 13.7032 | 13.6964 | 13.7032 | 8400.0 |
| 2011-12-01 07:56:00 | AAPL | Stock | 13.7032 | 13.7039 | 13.7032 | 13.7036 | 61600.0 |
| 2011-12-01 07:57:00 | AAPL | Stock | 13.7036 | 13.7075 | 13.7036 | 13.7075 | 22400.0 |
| 2011-12-01 07:58:00 | AAPL | Stock | 13.7071 | 13.7071 | 13.7046 | 13.7046 | 5992.0 |
| 2011-12-01 07:59:00 | AAPL | Stock | 13.7054 | 13.7054 | 13.7054 | 13.7054 | 8400.0 |
| 2011-12-01 08:00:00 | AAPL | Stock | 13.71 | 13.71 | 13.65 | 13.7032 | 18788.0 |
| 2011-12-01 08:01:00 | AAPL | Stock | 13.7018 | 13.7018 | 13.7018 | 13.7018 | 6832.0 |
> showing 50 of 999,582 rows — these rows as CSV