PREVIEW / stock_5min / 2001-07-12
file: by_date/stock_5min/2001/2001-07-12.parquet size: 1.6 MB rows: 108,908 symbols: 1,314
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 |
|---|---|---|---|---|---|---|---|
| 2001-07-12 08:00:00 | AAPL | Stock | 0.4163 | 0.4163 | 0.4161 | 0.4161 | 336000.0 |
| 2001-07-12 08:10:00 | AAPL | Stock | 0.4161 | 0.4161 | 0.4161 | 0.4161 | 140000.0 |
| 2001-07-12 08:15:00 | AAPL | Stock | 0.4161 | 0.4161 | 0.4161 | 0.4161 | 61600.0 |
| 2001-07-12 08:20:00 | AAPL | Stock | 0.417 | 0.417 | 0.417 | 0.417 | 28000.0 |
| 2001-07-12 08:25:00 | AAPL | Stock | 0.4205 | 0.4241 | 0.4196 | 0.4207 | 476000.0 |
| 2001-07-12 08:30:00 | AAPL | Stock | 0.4214 | 0.4216 | 0.4179 | 0.4179 | 1159200.0 |
| 2001-07-12 08:35:00 | AAPL | Stock | 0.4179 | 0.4179 | 0.4143 | 0.4143 | 39200.0 |
| 2001-07-12 08:45:00 | AAPL | Stock | 0.4134 | 0.4134 | 0.4134 | 0.4134 | 112000.0 |
| 2001-07-12 08:50:00 | AAPL | Stock | 0.4109 | 0.4116 | 0.4109 | 0.4116 | 134400.0 |
| 2001-07-12 08:55:00 | AAPL | Stock | 0.4143 | 0.4143 | 0.4134 | 0.4134 | 448000.0 |
| 2001-07-12 09:00:00 | AAPL | Stock | 0.4134 | 0.4134 | 0.4125 | 0.4134 | 145600.0 |
| 2001-07-12 09:05:00 | AAPL | Stock | 0.4134 | 0.4134 | 0.4134 | 0.4134 | 117600.0 |
| 2001-07-12 09:10:00 | AAPL | Stock | 0.4134 | 0.4134 | 0.413 | 0.413 | 84000.0 |
| 2001-07-12 09:15:00 | AAPL | Stock | 0.4134 | 0.4164 | 0.4134 | 0.4139 | 123200.0 |
| 2001-07-12 09:20:00 | AAPL | Stock | 0.4134 | 0.4152 | 0.4134 | 0.415 | 313600.0 |
| 2001-07-12 09:25:00 | AAPL | Stock | 0.4161 | 0.417 | 0.4109 | 0.417 | 817600.0 |
| 2001-07-12 09:30:00 | AAPL | Stock | 0.4161 | 0.4221 | 0.4161 | 0.4188 | 18793600.0 |
| 2001-07-12 09:35:00 | AAPL | Stock | 0.4189 | 0.4259 | 0.4186 | 0.425 | 12230400.0 |
| 2001-07-12 09:40:00 | AAPL | Stock | 0.4255 | 0.4263 | 0.4214 | 0.4214 | 19740000.0 |
| 2001-07-12 09:45:00 | AAPL | Stock | 0.4214 | 0.4263 | 0.4204 | 0.4254 | 16833600.0 |
| 2001-07-12 09:50:00 | AAPL | Stock | 0.427 | 0.4271 | 0.4232 | 0.4245 | 14431200.0 |
| 2001-07-12 09:55:00 | AAPL | Stock | 0.425 | 0.4286 | 0.425 | 0.428 | 9480800.0 |
| 2001-07-12 10:00:00 | AAPL | Stock | 0.4282 | 0.4298 | 0.4273 | 0.4277 | 17511200.0 |
| 2001-07-12 10:05:00 | AAPL | Stock | 0.4279 | 0.4279 | 0.4268 | 0.427 | 6216000.0 |
| 2001-07-12 10:10:00 | AAPL | Stock | 0.427 | 0.4309 | 0.4263 | 0.43 | 6395200.0 |
| 2001-07-12 10:15:00 | AAPL | Stock | 0.4298 | 0.4305 | 0.4286 | 0.4286 | 6669600.0 |
| 2001-07-12 10:20:00 | AAPL | Stock | 0.4282 | 0.4284 | 0.4243 | 0.4261 | 10354400.0 |
| 2001-07-12 10:25:00 | AAPL | Stock | 0.4261 | 0.4279 | 0.4241 | 0.4277 | 6501600.0 |
| 2001-07-12 10:30:00 | AAPL | Stock | 0.4277 | 0.4286 | 0.4263 | 0.4268 | 9189600.0 |
| 2001-07-12 10:35:00 | AAPL | Stock | 0.427 | 0.4304 | 0.427 | 0.4289 | 10707200.0 |
| 2001-07-12 10:40:00 | AAPL | Stock | 0.4289 | 0.4302 | 0.4288 | 0.4298 | 3595200.0 |
| 2001-07-12 10:45:00 | AAPL | Stock | 0.4298 | 0.4329 | 0.4289 | 0.4307 | 12773600.0 |
| 2001-07-12 10:50:00 | AAPL | Stock | 0.4302 | 0.4318 | 0.4295 | 0.4295 | 5482400.0 |
| 2001-07-12 10:55:00 | AAPL | Stock | 0.4295 | 0.4302 | 0.4275 | 0.4277 | 8892800.0 |
| 2001-07-12 11:00:00 | AAPL | Stock | 0.4277 | 0.4293 | 0.4266 | 0.4268 | 8747200.0 |
| 2001-07-12 11:05:00 | AAPL | Stock | 0.4268 | 0.4288 | 0.4259 | 0.4286 | 5969600.0 |
| 2001-07-12 11:10:00 | AAPL | Stock | 0.4288 | 0.4291 | 0.4268 | 0.4271 | 11132800.0 |
| 2001-07-12 11:15:00 | AAPL | Stock | 0.4273 | 0.4286 | 0.4259 | 0.4263 | 7050400.0 |
| 2001-07-12 11:20:00 | AAPL | Stock | 0.4266 | 0.4273 | 0.4255 | 0.4271 | 7296800.0 |
| 2001-07-12 11:25:00 | AAPL | Stock | 0.4275 | 0.4275 | 0.4261 | 0.4271 | 3091200.0 |
| 2001-07-12 11:30:00 | AAPL | Stock | 0.4268 | 0.4286 | 0.4268 | 0.428 | 1237600.0 |
| 2001-07-12 11:35:00 | AAPL | Stock | 0.4282 | 0.4282 | 0.4268 | 0.4271 | 2060800.0 |
| 2001-07-12 11:40:00 | AAPL | Stock | 0.4266 | 0.4291 | 0.4266 | 0.4284 | 2968000.0 |
| 2001-07-12 11:45:00 | AAPL | Stock | 0.4282 | 0.4289 | 0.4271 | 0.4282 | 3992800.0 |
| 2001-07-12 11:50:00 | AAPL | Stock | 0.4282 | 0.4295 | 0.428 | 0.4295 | 3080000.0 |
| 2001-07-12 11:55:00 | AAPL | Stock | 0.4293 | 0.4298 | 0.4282 | 0.4291 | 2867200.0 |
| 2001-07-12 12:00:00 | AAPL | Stock | 0.4291 | 0.4291 | 0.4275 | 0.4282 | 2279200.0 |
| 2001-07-12 12:05:00 | AAPL | Stock | 0.428 | 0.4288 | 0.4279 | 0.4282 | 5880000.0 |
| 2001-07-12 12:10:00 | AAPL | Stock | 0.4284 | 0.4293 | 0.4277 | 0.4286 | 4457600.0 |
| 2001-07-12 12:15:00 | AAPL | Stock | 0.4286 | 0.4286 | 0.4271 | 0.428 | 1943200.0 |
> showing 50 of 108,908 rows — these rows as CSV