PREVIEW / stock_5min / 2006-04-12
file: by_date/stock_5min/2006/2006-04-12.parquet size: 3.0 MB rows: 219,426 symbols: 2,228
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-04-12 06:20:00 | AAPL | Stock | 2.4232 | 2.4232 | 2.4232 | 2.4232 | 2800.0 |
| 2006-04-12 06:25:00 | AAPL | Stock | 2.4232 | 2.4232 | 2.4232 | 2.4232 | 2800.0 |
| 2006-04-12 07:05:00 | AAPL | Stock | 2.4232 | 2.4232 | 2.4232 | 2.4232 | 11200.0 |
| 2006-04-12 08:00:00 | AAPL | Stock | 2.4268 | 2.4304 | 2.4232 | 2.4304 | 37800.0 |
| 2006-04-12 08:05:00 | AAPL | Stock | 2.4304 | 2.4304 | 2.4286 | 2.4286 | 57400.0 |
| 2006-04-12 08:10:00 | AAPL | Stock | 2.4318 | 2.4321 | 2.4318 | 2.4321 | 84000.0 |
| 2006-04-12 08:15:00 | AAPL | Stock | 2.4321 | 2.4321 | 2.4318 | 2.4321 | 44800.0 |
| 2006-04-12 08:20:00 | AAPL | Stock | 2.4304 | 2.4318 | 2.4304 | 2.4318 | 5600.0 |
| 2006-04-12 08:25:00 | AAPL | Stock | 2.4304 | 2.4429 | 2.4304 | 2.4425 | 172200.0 |
| 2006-04-12 08:30:00 | AAPL | Stock | 2.4368 | 2.4386 | 2.4343 | 2.4375 | 134400.0 |
| 2006-04-12 08:35:00 | AAPL | Stock | 2.4389 | 2.4446 | 2.4282 | 2.4425 | 1911000.0 |
| 2006-04-12 08:40:00 | AAPL | Stock | 2.4421 | 2.4432 | 2.4343 | 2.4432 | 225400.0 |
| 2006-04-12 08:45:00 | AAPL | Stock | 2.4371 | 2.4386 | 2.4343 | 2.4343 | 144200.0 |
| 2006-04-12 08:50:00 | AAPL | Stock | 2.4346 | 2.4346 | 2.4346 | 2.4346 | 25200.0 |
| 2006-04-12 08:55:00 | AAPL | Stock | 2.4346 | 2.4382 | 2.4343 | 2.4382 | 273840.0 |
| 2006-04-12 09:00:00 | AAPL | Stock | 2.4382 | 2.4425 | 2.4382 | 2.4389 | 373436.0 |
| 2006-04-12 09:05:00 | AAPL | Stock | 2.4389 | 2.4389 | 2.4364 | 2.4371 | 81200.0 |
| 2006-04-12 09:10:00 | AAPL | Stock | 2.4382 | 2.4386 | 2.4368 | 2.4368 | 148400.0 |
| 2006-04-12 09:15:00 | AAPL | Stock | 2.4361 | 2.4371 | 2.4354 | 2.4354 | 316400.0 |
| 2006-04-12 09:20:00 | AAPL | Stock | 2.4354 | 2.4357 | 2.4329 | 2.435 | 273700.0 |
| 2006-04-12 09:25:00 | AAPL | Stock | 2.4357 | 2.4368 | 2.4304 | 2.4304 | 1112188.0 |
| 2006-04-12 09:30:00 | AAPL | Stock | 2.4289 | 2.4348 | 2.4146 | 2.4175 | 24250800.0 |
| 2006-04-12 09:35:00 | AAPL | Stock | 2.4175 | 2.4311 | 2.4164 | 2.4275 | 15830948.0 |
| 2006-04-12 09:40:00 | AAPL | Stock | 2.4275 | 2.4286 | 2.4218 | 2.425 | 9877840.0 |
| 2006-04-12 09:45:00 | AAPL | Stock | 2.425 | 2.4346 | 2.4211 | 2.4264 | 18369428.0 |
| 2006-04-12 09:50:00 | AAPL | Stock | 2.4261 | 2.4275 | 2.4143 | 2.4161 | 11581528.0 |
| 2006-04-12 09:55:00 | AAPL | Stock | 2.4161 | 2.4179 | 2.4082 | 2.4139 | 16238264.0 |
| 2006-04-12 10:00:00 | AAPL | Stock | 2.4143 | 2.4196 | 2.4054 | 2.4096 | 18833136.0 |
| 2006-04-12 10:05:00 | AAPL | Stock | 2.4096 | 2.4186 | 2.4082 | 2.4182 | 12833016.0 |
| 2006-04-12 10:10:00 | AAPL | Stock | 2.4182 | 2.4243 | 2.4157 | 2.4186 | 13701800.0 |
| 2006-04-12 10:15:00 | AAPL | Stock | 2.4182 | 2.4207 | 2.4136 | 2.4161 | 7074648.0 |
| 2006-04-12 10:20:00 | AAPL | Stock | 2.4161 | 2.4221 | 2.415 | 2.4186 | 5453112.0 |
| 2006-04-12 10:25:00 | AAPL | Stock | 2.4186 | 2.4211 | 2.4154 | 2.4154 | 6649720.0 |
| 2006-04-12 10:30:00 | AAPL | Stock | 2.4157 | 2.4179 | 2.4107 | 2.4128 | 8925952.0 |
| 2006-04-12 10:35:00 | AAPL | Stock | 2.4129 | 2.4207 | 2.4129 | 2.4207 | 7641872.0 |
| 2006-04-12 10:40:00 | AAPL | Stock | 2.4207 | 2.4239 | 2.4161 | 2.4164 | 7449400.0 |
| 2006-04-12 10:45:00 | AAPL | Stock | 2.4161 | 2.4168 | 2.4104 | 2.4125 | 7139328.0 |
| 2006-04-12 10:50:00 | AAPL | Stock | 2.4125 | 2.4135 | 2.4068 | 2.4129 | 11592364.0 |
| 2006-04-12 10:55:00 | AAPL | Stock | 2.4129 | 2.4175 | 2.4107 | 2.4175 | 6848464.0 |
| 2006-04-12 11:00:00 | AAPL | Stock | 2.4171 | 2.4171 | 2.4125 | 2.4132 | 4510212.0 |
| 2006-04-12 11:05:00 | AAPL | Stock | 2.4132 | 2.4157 | 2.4111 | 2.4143 | 6069840.0 |
| 2006-04-12 11:10:00 | AAPL | Stock | 2.4143 | 2.42 | 2.4136 | 2.4193 | 7649628.0 |
| 2006-04-12 11:15:00 | AAPL | Stock | 2.4186 | 2.4221 | 2.4168 | 2.4171 | 7044296.0 |
| 2006-04-12 11:20:00 | AAPL | Stock | 2.4171 | 2.425 | 2.4171 | 2.4246 | 9265872.0 |
| 2006-04-12 11:25:00 | AAPL | Stock | 2.4246 | 2.4289 | 2.4218 | 2.4254 | 15184932.0 |
| 2006-04-12 11:30:00 | AAPL | Stock | 2.4254 | 2.4304 | 2.4239 | 2.4246 | 10112480.0 |
| 2006-04-12 11:35:00 | AAPL | Stock | 2.4246 | 2.425 | 2.4125 | 2.4129 | 10764376.0 |
| 2006-04-12 11:40:00 | AAPL | Stock | 2.4132 | 2.4164 | 2.4093 | 2.4164 | 10170188.0 |
| 2006-04-12 11:45:00 | AAPL | Stock | 2.4164 | 2.4175 | 2.4125 | 2.4171 | 6043380.0 |
| 2006-04-12 11:50:00 | AAPL | Stock | 2.4175 | 2.4179 | 2.4089 | 2.4096 | 6478276.0 |
> showing 50 of 219,426 rows — these rows as CSV