PREVIEW / stock_1min / 2010-03-05
file: by_date/stock_1min/2010/2010-03-05.parquet size: 13.0 MB rows: 978,234 symbols: 2,808
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-03-05 05:28:00 | AAPL | Stock | 7.5871 | 7.5871 | 7.5871 | 7.5871 | 2800.0 |
| 2010-03-05 05:36:00 | AAPL | Stock | 7.59 | 7.59 | 7.59 | 7.59 | 2800.0 |
| 2010-03-05 05:37:00 | AAPL | Stock | 7.5925 | 7.5925 | 7.5925 | 7.5925 | 14000.0 |
| 2010-03-05 05:55:00 | AAPL | Stock | 7.5993 | 7.5993 | 7.5993 | 7.5993 | 2800.0 |
| 2010-03-05 05:57:00 | AAPL | Stock | 7.6 | 7.6 | 7.6 | 7.6 | 2800.0 |
| 2010-03-05 06:03:00 | AAPL | Stock | 7.5929 | 7.5932 | 7.5929 | 7.5932 | 16800.0 |
| 2010-03-05 07:00:00 | AAPL | Stock | 7.6061 | 7.6064 | 7.6061 | 7.6064 | 8400.0 |
| 2010-03-05 07:01:00 | AAPL | Stock | 7.5982 | 7.5982 | 7.5982 | 7.5982 | 2800.0 |
| 2010-03-05 07:02:00 | AAPL | Stock | 7.5982 | 7.5982 | 7.5979 | 7.5982 | 8400.0 |
| 2010-03-05 07:03:00 | AAPL | Stock | 7.6007 | 7.6007 | 7.6007 | 7.6007 | 2800.0 |
| 2010-03-05 07:04:00 | AAPL | Stock | 7.5975 | 7.5975 | 7.5975 | 7.5975 | 2800.0 |
| 2010-03-05 07:05:00 | AAPL | Stock | 7.5975 | 7.6061 | 7.5975 | 7.6061 | 8400.0 |
| 2010-03-05 07:13:00 | AAPL | Stock | 7.6193 | 7.6193 | 7.6193 | 7.6193 | 26040.0 |
| 2010-03-05 07:14:00 | AAPL | Stock | 7.6189 | 7.6189 | 7.6189 | 7.6189 | 2800.0 |
| 2010-03-05 07:15:00 | AAPL | Stock | 7.6193 | 7.6193 | 7.6193 | 7.6193 | 2800.0 |
| 2010-03-05 07:17:00 | AAPL | Stock | 7.6232 | 7.6232 | 7.6232 | 7.6232 | 2800.0 |
| 2010-03-05 07:19:00 | AAPL | Stock | 7.6125 | 7.6125 | 7.6054 | 7.6071 | 87136.0 |
| 2010-03-05 07:20:00 | AAPL | Stock | 7.6161 | 7.6161 | 7.6161 | 7.6161 | 2800.0 |
| 2010-03-05 07:21:00 | AAPL | Stock | 7.6182 | 7.6182 | 7.6182 | 7.6182 | 11200.0 |
| 2010-03-05 07:23:00 | AAPL | Stock | 7.6182 | 7.6182 | 7.6079 | 7.6079 | 19600.0 |
| 2010-03-05 07:25:00 | AAPL | Stock | 7.6179 | 7.6179 | 7.6179 | 7.6179 | 5600.0 |
| 2010-03-05 07:27:00 | AAPL | Stock | 7.6175 | 7.6179 | 7.6175 | 7.6179 | 5600.0 |
| 2010-03-05 07:30:00 | AAPL | Stock | 7.6214 | 7.6214 | 7.6214 | 7.6214 | 2800.0 |
| 2010-03-05 07:36:00 | AAPL | Stock | 7.6179 | 7.6214 | 7.6179 | 7.6207 | 14000.0 |
| 2010-03-05 07:37:00 | AAPL | Stock | 7.6204 | 7.6214 | 7.6179 | 7.6179 | 22400.0 |
| 2010-03-05 07:38:00 | AAPL | Stock | 7.6161 | 7.6161 | 7.615 | 7.615 | 8372.0 |
| 2010-03-05 07:39:00 | AAPL | Stock | 7.6143 | 7.6161 | 7.6143 | 7.6161 | 21000.0 |
| 2010-03-05 07:40:00 | AAPL | Stock | 7.6146 | 7.6171 | 7.6146 | 7.6171 | 5600.0 |
| 2010-03-05 07:41:00 | AAPL | Stock | 7.6204 | 7.6204 | 7.6171 | 7.6171 | 5600.0 |
| 2010-03-05 07:44:00 | AAPL | Stock | 7.6171 | 7.6171 | 7.6171 | 7.6171 | 5516.0 |
| 2010-03-05 07:46:00 | AAPL | Stock | 7.6171 | 7.6171 | 7.6171 | 7.6171 | 4200.0 |
| 2010-03-05 07:47:00 | AAPL | Stock | 7.6161 | 7.6196 | 7.6143 | 7.6143 | 69104.0 |
| 2010-03-05 07:55:00 | AAPL | Stock | 7.6107 | 7.6107 | 7.61 | 7.61 | 39172.0 |
| 2010-03-05 07:58:00 | AAPL | Stock | 7.6093 | 7.6093 | 7.6071 | 7.6071 | 16800.0 |
| 2010-03-05 07:59:00 | AAPL | Stock | 7.6061 | 7.6071 | 7.6029 | 7.6029 | 145600.0 |
| 2010-03-05 08:00:00 | AAPL | Stock | 7.6071 | 7.6211 | 7.6025 | 7.6075 | 270564.0 |
| 2010-03-05 08:01:00 | AAPL | Stock | 7.61 | 7.6104 | 7.6054 | 7.6054 | 103404.0 |
| 2010-03-05 08:02:00 | AAPL | Stock | 7.61 | 7.6107 | 7.6089 | 7.6089 | 11200.0 |
| 2010-03-05 08:03:00 | AAPL | Stock | 7.61 | 7.6107 | 7.6089 | 7.6107 | 35000.0 |
| 2010-03-05 08:04:00 | AAPL | Stock | 7.6125 | 7.6125 | 7.6107 | 7.6107 | 14000.0 |
| 2010-03-05 08:05:00 | AAPL | Stock | 7.6107 | 7.6125 | 7.6054 | 7.6057 | 394324.0 |
| 2010-03-05 08:06:00 | AAPL | Stock | 7.6071 | 7.6071 | 7.6071 | 7.6071 | 5600.0 |
| 2010-03-05 08:07:00 | AAPL | Stock | 7.6071 | 7.6121 | 7.6071 | 7.6121 | 11200.0 |
| 2010-03-05 08:08:00 | AAPL | Stock | 7.6107 | 7.6136 | 7.6107 | 7.6129 | 38864.0 |
| 2010-03-05 08:09:00 | AAPL | Stock | 7.6139 | 7.615 | 7.6129 | 7.615 | 30772.0 |
| 2010-03-05 08:10:00 | AAPL | Stock | 7.615 | 7.6161 | 7.6143 | 7.6143 | 99512.0 |
| 2010-03-05 08:11:00 | AAPL | Stock | 7.6136 | 7.6136 | 7.6107 | 7.6107 | 93856.0 |
| 2010-03-05 08:12:00 | AAPL | Stock | 7.6107 | 7.6107 | 7.6107 | 7.6107 | 30772.0 |
| 2010-03-05 08:13:00 | AAPL | Stock | 7.6111 | 7.6121 | 7.6082 | 7.6089 | 70000.0 |
| 2010-03-05 08:14:00 | AAPL | Stock | 7.6114 | 7.6136 | 7.6089 | 7.6107 | 57148.0 |
> showing 50 of 978,234 rows — these rows as CSV