PREVIEW / stock_5min / 2006-10-11
file: by_date/stock_5min/2006/2006-10-11.parquet size: 3.1 MB rows: 225,719 symbols: 2,381
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 |
|---|---|---|---|---|---|---|---|
| 2006-10-11 08:00:00 | AAPL | Stock | 2.6239 | 2.6286 | 2.6179 | 2.6182 | 119840.0 |
| 2006-10-11 08:05:00 | AAPL | Stock | 2.6182 | 2.6186 | 2.6182 | 2.6186 | 84000.0 |
| 2006-10-11 08:15:00 | AAPL | Stock | 2.6186 | 2.6186 | 2.6161 | 2.6161 | 235760.0 |
| 2006-10-11 08:20:00 | AAPL | Stock | 2.6175 | 2.6229 | 2.6175 | 2.6229 | 78400.0 |
| 2006-10-11 08:25:00 | AAPL | Stock | 2.6179 | 2.6211 | 2.6179 | 2.6211 | 70000.0 |
| 2006-10-11 08:30:00 | AAPL | Stock | 2.62 | 2.62 | 2.6179 | 2.6182 | 78400.0 |
| 2006-10-11 08:35:00 | AAPL | Stock | 2.6179 | 2.6179 | 2.6179 | 2.6179 | 18200.0 |
| 2006-10-11 08:40:00 | AAPL | Stock | 2.6179 | 2.6214 | 2.6179 | 2.6214 | 78400.0 |
| 2006-10-11 08:45:00 | AAPL | Stock | 2.6225 | 2.6232 | 2.6182 | 2.6186 | 82040.0 |
| 2006-10-11 08:50:00 | AAPL | Stock | 2.6182 | 2.6182 | 2.6182 | 2.6182 | 39200.0 |
| 2006-10-11 08:55:00 | AAPL | Stock | 2.6214 | 2.6214 | 2.6204 | 2.6214 | 38808.0 |
| 2006-10-11 09:00:00 | AAPL | Stock | 2.6214 | 2.6214 | 2.6214 | 2.6214 | 20104.0 |
| 2006-10-11 09:05:00 | AAPL | Stock | 2.6214 | 2.6214 | 2.6186 | 2.6186 | 49476.0 |
| 2006-10-11 09:10:00 | AAPL | Stock | 2.6196 | 2.6211 | 2.6196 | 2.6196 | 26600.0 |
| 2006-10-11 09:15:00 | AAPL | Stock | 2.6179 | 2.6186 | 2.6179 | 2.6186 | 42000.0 |
| 2006-10-11 09:20:00 | AAPL | Stock | 2.6179 | 2.6429 | 2.6179 | 2.625 | 398720.0 |
| 2006-10-11 09:25:00 | AAPL | Stock | 2.6239 | 2.6339 | 2.6161 | 2.63 | 884828.0 |
| 2006-10-11 09:30:00 | AAPL | Stock | 2.6221 | 2.6271 | 2.6071 | 2.6118 | 17157924.0 |
| 2006-10-11 09:35:00 | AAPL | Stock | 2.6118 | 2.6171 | 2.6096 | 2.6107 | 12938744.0 |
| 2006-10-11 09:40:00 | AAPL | Stock | 2.6118 | 2.6271 | 2.6075 | 2.6104 | 13783448.0 |
| 2006-10-11 09:45:00 | AAPL | Stock | 2.61 | 2.6107 | 2.6018 | 2.605 | 21132384.0 |
| 2006-10-11 09:50:00 | AAPL | Stock | 2.605 | 2.6093 | 2.6043 | 2.6068 | 14367136.0 |
| 2006-10-11 09:55:00 | AAPL | Stock | 2.6071 | 2.6088 | 2.5946 | 2.6007 | 14413840.0 |
| 2006-10-11 10:00:00 | AAPL | Stock | 2.6004 | 2.6021 | 2.5964 | 2.5979 | 14513128.0 |
| 2006-10-11 10:05:00 | AAPL | Stock | 2.5979 | 2.6054 | 2.5971 | 2.6043 | 13074208.0 |
| 2006-10-11 10:10:00 | AAPL | Stock | 2.6046 | 2.6104 | 2.6039 | 2.6071 | 12289676.0 |
| 2006-10-11 10:15:00 | AAPL | Stock | 2.6075 | 2.6075 | 2.6032 | 2.6068 | 7311976.0 |
| 2006-10-11 10:20:00 | AAPL | Stock | 2.6068 | 2.61 | 2.6057 | 2.6071 | 7680624.0 |
| 2006-10-11 10:25:00 | AAPL | Stock | 2.6071 | 2.6104 | 2.605 | 2.61 | 7196056.0 |
| 2006-10-11 10:30:00 | AAPL | Stock | 2.6096 | 2.6175 | 2.6096 | 2.6161 | 11653040.0 |
| 2006-10-11 10:35:00 | AAPL | Stock | 2.6161 | 2.6168 | 2.6114 | 2.6136 | 6245764.0 |
| 2006-10-11 10:40:00 | AAPL | Stock | 2.6136 | 2.615 | 2.6096 | 2.61 | 5290712.0 |
| 2006-10-11 10:45:00 | AAPL | Stock | 2.61 | 2.6118 | 2.6082 | 2.6107 | 5469604.0 |
| 2006-10-11 10:50:00 | AAPL | Stock | 2.6104 | 2.6154 | 2.6101 | 2.6136 | 4328156.0 |
| 2006-10-11 10:55:00 | AAPL | Stock | 2.6136 | 2.6154 | 2.6089 | 2.6129 | 4911816.0 |
| 2006-10-11 11:00:00 | AAPL | Stock | 2.6129 | 2.615 | 2.6111 | 2.6139 | 2250948.0 |
| 2006-10-11 11:05:00 | AAPL | Stock | 2.6139 | 2.6161 | 2.6139 | 2.615 | 4031412.0 |
| 2006-10-11 11:10:00 | AAPL | Stock | 2.6154 | 2.6189 | 2.615 | 2.6179 | 8237180.0 |
| 2006-10-11 11:15:00 | AAPL | Stock | 2.6157 | 2.6193 | 2.6139 | 2.6193 | 5473748.0 |
| 2006-10-11 11:20:00 | AAPL | Stock | 2.6193 | 2.6232 | 2.6179 | 2.6204 | 7243516.0 |
| 2006-10-11 11:25:00 | AAPL | Stock | 2.6207 | 2.6207 | 2.6146 | 2.6179 | 3821300.0 |
| 2006-10-11 11:30:00 | AAPL | Stock | 2.6182 | 2.6196 | 2.6164 | 2.6175 | 3902136.0 |
| 2006-10-11 11:35:00 | AAPL | Stock | 2.6175 | 2.6254 | 2.6171 | 2.625 | 6791176.0 |
| 2006-10-11 11:40:00 | AAPL | Stock | 2.6246 | 2.6336 | 2.6243 | 2.6321 | 12684560.0 |
| 2006-10-11 11:45:00 | AAPL | Stock | 2.6321 | 2.6332 | 2.6239 | 2.6275 | 6792968.0 |
| 2006-10-11 11:50:00 | AAPL | Stock | 2.6268 | 2.6304 | 2.6268 | 2.6279 | 3461528.0 |
| 2006-10-11 11:55:00 | AAPL | Stock | 2.6275 | 2.6318 | 2.6271 | 2.6289 | 3654644.0 |
| 2006-10-11 12:00:00 | AAPL | Stock | 2.6289 | 2.6343 | 2.6289 | 2.6321 | 3989104.0 |
| 2006-10-11 12:05:00 | AAPL | Stock | 2.6321 | 2.6332 | 2.6286 | 2.6307 | 3145408.0 |
| 2006-10-11 12:10:00 | AAPL | Stock | 2.6307 | 2.6336 | 2.6229 | 2.6254 | 5496624.0 |
> showing 50 of 225,719 rows — these rows as CSV