PREVIEW / stock_1min / 2010-06-17
file: by_date/stock_1min/2010/2010-06-17.parquet size: 12.2 MB rows: 931,841 symbols: 2,792
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 |
|---|---|---|---|---|---|---|---|
| 2010-06-17 04:49:00 | AAPL | Stock | 9.5789 | 9.5789 | 9.5789 | 9.5789 | 2800.0 |
| 2010-06-17 05:49:00 | AAPL | Stock | 9.6054 | 9.6054 | 9.6054 | 9.6054 | 5600.0 |
| 2010-06-17 05:57:00 | AAPL | Stock | 9.6054 | 9.6054 | 9.6054 | 9.6054 | 2800.0 |
| 2010-06-17 07:01:00 | AAPL | Stock | 9.5896 | 9.5896 | 9.5896 | 9.5896 | 2800.0 |
| 2010-06-17 07:02:00 | AAPL | Stock | 9.5896 | 9.5896 | 9.5896 | 9.5896 | 10640.0 |
| 2010-06-17 07:06:00 | AAPL | Stock | 9.5893 | 9.6043 | 9.5893 | 9.6043 | 12852.0 |
| 2010-06-17 07:07:00 | AAPL | Stock | 9.5982 | 9.5982 | 9.5982 | 9.5982 | 5600.0 |
| 2010-06-17 07:10:00 | AAPL | Stock | 9.6018 | 9.6054 | 9.6018 | 9.6054 | 29792.0 |
| 2010-06-17 07:11:00 | AAPL | Stock | 9.6054 | 9.6054 | 9.6018 | 9.6018 | 25200.0 |
| 2010-06-17 07:12:00 | AAPL | Stock | 9.6018 | 9.6018 | 9.6018 | 9.6018 | 2800.0 |
| 2010-06-17 07:13:00 | AAPL | Stock | 9.6054 | 9.6054 | 9.6036 | 9.6036 | 21616.0 |
| 2010-06-17 07:15:00 | AAPL | Stock | 9.6111 | 9.6111 | 9.6111 | 9.6111 | 2800.0 |
| 2010-06-17 07:16:00 | AAPL | Stock | 9.6114 | 9.625 | 9.6111 | 9.6111 | 94220.0 |
| 2010-06-17 07:17:00 | AAPL | Stock | 9.6125 | 9.6125 | 9.6071 | 9.6071 | 21588.0 |
| 2010-06-17 07:18:00 | AAPL | Stock | 9.6107 | 9.6107 | 9.6107 | 9.6107 | 7000.0 |
| 2010-06-17 07:19:00 | AAPL | Stock | 9.5971 | 9.5971 | 9.5964 | 9.5964 | 14000.0 |
| 2010-06-17 07:21:00 | AAPL | Stock | 9.6018 | 9.6054 | 9.6018 | 9.6054 | 30800.0 |
| 2010-06-17 07:22:00 | AAPL | Stock | 9.6193 | 9.6214 | 9.6054 | 9.6214 | 52024.0 |
| 2010-06-17 07:25:00 | AAPL | Stock | 9.6071 | 9.6071 | 9.6018 | 9.6018 | 12376.0 |
| 2010-06-17 07:28:00 | AAPL | Stock | 9.6071 | 9.6118 | 9.6071 | 9.6118 | 8400.0 |
| 2010-06-17 07:30:00 | AAPL | Stock | 9.6071 | 9.6082 | 9.6071 | 9.6082 | 11200.0 |
| 2010-06-17 07:32:00 | AAPL | Stock | 9.6079 | 9.6107 | 9.6079 | 9.6107 | 33320.0 |
| 2010-06-17 07:34:00 | AAPL | Stock | 9.6079 | 9.6079 | 9.6079 | 9.6079 | 28000.0 |
| 2010-06-17 07:35:00 | AAPL | Stock | 9.6071 | 9.6136 | 9.6071 | 9.6136 | 50400.0 |
| 2010-06-17 07:36:00 | AAPL | Stock | 9.6136 | 9.625 | 9.6114 | 9.625 | 135464.0 |
| 2010-06-17 07:37:00 | AAPL | Stock | 9.625 | 9.6261 | 9.6246 | 9.6261 | 86772.0 |
| 2010-06-17 07:38:00 | AAPL | Stock | 9.6243 | 9.6261 | 9.6243 | 9.6246 | 26628.0 |
| 2010-06-17 07:39:00 | AAPL | Stock | 9.6246 | 9.625 | 9.6243 | 9.625 | 41076.0 |
| 2010-06-17 07:40:00 | AAPL | Stock | 9.63 | 9.63 | 9.63 | 9.63 | 2800.0 |
| 2010-06-17 07:44:00 | AAPL | Stock | 9.6214 | 9.6214 | 9.6214 | 9.6214 | 14000.0 |
| 2010-06-17 07:45:00 | AAPL | Stock | 9.6275 | 9.6275 | 9.6275 | 9.6275 | 2800.0 |
| 2010-06-17 07:46:00 | AAPL | Stock | 9.6214 | 9.6214 | 9.6179 | 9.6179 | 8400.0 |
| 2010-06-17 07:47:00 | AAPL | Stock | 9.6179 | 9.6179 | 9.6179 | 9.6179 | 28000.0 |
| 2010-06-17 07:48:00 | AAPL | Stock | 9.625 | 9.625 | 9.6239 | 9.625 | 45640.0 |
| 2010-06-17 07:50:00 | AAPL | Stock | 9.6243 | 9.6243 | 9.6243 | 9.6243 | 5600.0 |
| 2010-06-17 07:53:00 | AAPL | Stock | 9.6189 | 9.6189 | 9.6189 | 9.6189 | 2800.0 |
| 2010-06-17 07:54:00 | AAPL | Stock | 9.625 | 9.625 | 9.6193 | 9.6243 | 14000.0 |
| 2010-06-17 07:55:00 | AAPL | Stock | 9.6246 | 9.63 | 9.6246 | 9.6275 | 111160.0 |
| 2010-06-17 07:56:00 | AAPL | Stock | 9.63 | 9.6304 | 9.63 | 9.6304 | 59276.0 |
| 2010-06-17 07:57:00 | AAPL | Stock | 9.6268 | 9.6268 | 9.6146 | 9.6189 | 28000.0 |
| 2010-06-17 07:58:00 | AAPL | Stock | 9.6179 | 9.6179 | 9.6179 | 9.6179 | 4200.0 |
| 2010-06-17 07:59:00 | AAPL | Stock | 9.6146 | 9.6146 | 9.6143 | 9.6143 | 8400.0 |
| 2010-06-17 08:00:00 | AAPL | Stock | 9.6143 | 9.6182 | 9.6014 | 9.6143 | 394940.0 |
| 2010-06-17 08:01:00 | AAPL | Stock | 9.6143 | 9.6175 | 9.6082 | 9.6161 | 89180.0 |
| 2010-06-17 08:02:00 | AAPL | Stock | 9.6179 | 9.6179 | 9.6136 | 9.6143 | 40936.0 |
| 2010-06-17 08:03:00 | AAPL | Stock | 9.6196 | 9.62 | 9.6196 | 9.62 | 39508.0 |
| 2010-06-17 08:04:00 | AAPL | Stock | 9.6214 | 9.6232 | 9.6146 | 9.6196 | 47180.0 |
| 2010-06-17 08:05:00 | AAPL | Stock | 9.6179 | 9.6196 | 9.6161 | 9.6171 | 28000.0 |
| 2010-06-17 08:06:00 | AAPL | Stock | 9.6168 | 9.6175 | 9.6143 | 9.6175 | 13132.0 |
| 2010-06-17 08:07:00 | AAPL | Stock | 9.5446 | 9.617 | 9.5446 | 9.6143 | 68236.0 |
> showing 50 of 931,841 rows — these rows as CSV