PREVIEW / stock_5min / 2010-09-24
file: by_date/stock_5min/2010/2010-09-24.parquet size: 4.7 MB rows: 322,376 symbols: 3,486
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-09-24 06:15:00 | AAPL | Stock | 10.3557 | 10.3557 | 10.3554 | 10.3554 | 5600.0 |
| 2010-09-24 06:35:00 | AAPL | Stock | 10.3557 | 10.3557 | 10.3554 | 10.3557 | 11200.0 |
| 2010-09-24 06:45:00 | AAPL | Stock | 10.3554 | 10.3554 | 10.3554 | 10.3554 | 2800.0 |
| 2010-09-24 07:00:00 | AAPL | Stock | 10.3557 | 10.3661 | 10.3557 | 10.3661 | 15456.0 |
| 2010-09-24 07:05:00 | AAPL | Stock | 10.3661 | 10.3661 | 10.3661 | 10.3661 | 2800.0 |
| 2010-09-24 07:10:00 | AAPL | Stock | 10.375 | 10.375 | 10.375 | 10.375 | 2800.0 |
| 2010-09-24 07:15:00 | AAPL | Stock | 10.3743 | 10.3743 | 10.3743 | 10.3743 | 5600.0 |
| 2010-09-24 07:20:00 | AAPL | Stock | 10.3743 | 10.3743 | 10.3743 | 10.3743 | 2800.0 |
| 2010-09-24 07:25:00 | AAPL | Stock | 10.3743 | 10.375 | 10.3743 | 10.375 | 40600.0 |
| 2010-09-24 07:30:00 | AAPL | Stock | 10.375 | 10.375 | 10.3746 | 10.375 | 21280.0 |
| 2010-09-24 07:35:00 | AAPL | Stock | 10.3718 | 10.3889 | 10.3679 | 10.3786 | 91560.0 |
| 2010-09-24 07:45:00 | AAPL | Stock | 10.3693 | 10.3693 | 10.3693 | 10.3693 | 2800.0 |
| 2010-09-24 07:50:00 | AAPL | Stock | 10.3871 | 10.3871 | 10.3868 | 10.3868 | 14000.0 |
| 2010-09-24 08:00:00 | AAPL | Stock | 10.375 | 10.4061 | 10.37 | 10.4061 | 648704.0 |
| 2010-09-24 08:05:00 | AAPL | Stock | 10.4018 | 10.4061 | 10.3946 | 10.4018 | 336644.0 |
| 2010-09-24 08:10:00 | AAPL | Stock | 10.4029 | 10.4168 | 10.4 | 10.4129 | 369796.0 |
| 2010-09-24 08:15:00 | AAPL | Stock | 10.4129 | 10.4182 | 10.41 | 10.4129 | 420588.0 |
| 2010-09-24 08:20:00 | AAPL | Stock | 10.4164 | 10.4221 | 10.4143 | 10.4221 | 378616.0 |
| 2010-09-24 08:25:00 | AAPL | Stock | 10.4232 | 10.4243 | 10.4143 | 10.4143 | 387492.0 |
| 2010-09-24 08:30:00 | AAPL | Stock | 10.4196 | 10.4454 | 10.4193 | 10.4411 | 1218728.0 |
| 2010-09-24 08:35:00 | AAPL | Stock | 10.4421 | 10.4446 | 10.4314 | 10.4321 | 1074752.0 |
| 2010-09-24 08:40:00 | AAPL | Stock | 10.4321 | 10.4354 | 10.4193 | 10.4286 | 951132.0 |
| 2010-09-24 08:45:00 | AAPL | Stock | 10.4275 | 10.4286 | 10.4239 | 10.4286 | 406588.0 |
| 2010-09-24 08:50:00 | AAPL | Stock | 10.4293 | 10.4339 | 10.4289 | 10.4321 | 341600.0 |
| 2010-09-24 08:55:00 | AAPL | Stock | 10.4321 | 10.4339 | 10.4286 | 10.43 | 385756.0 |
| 2010-09-24 09:00:00 | AAPL | Stock | 10.4318 | 10.4393 | 10.4257 | 10.4393 | 984956.0 |
| 2010-09-24 09:05:00 | AAPL | Stock | 10.4396 | 10.4439 | 10.425 | 10.425 | 1523088.0 |
| 2010-09-24 09:10:00 | AAPL | Stock | 10.4279 | 10.4286 | 10.4186 | 10.4196 | 688296.0 |
| 2010-09-24 09:15:00 | AAPL | Stock | 10.4182 | 10.4186 | 10.4036 | 10.4104 | 1383788.0 |
| 2010-09-24 09:20:00 | AAPL | Stock | 10.4107 | 10.4257 | 10.4071 | 10.425 | 842016.0 |
| 2010-09-24 09:25:00 | AAPL | Stock | 10.4239 | 10.4461 | 10.4146 | 10.4286 | 1040368.0 |
| 2010-09-24 09:30:00 | AAPL | Stock | 10.4286 | 10.4321 | 10.4036 | 10.4046 | 34931960.0 |
| 2010-09-24 09:35:00 | AAPL | Stock | 10.405 | 10.4732 | 10.3979 | 10.4725 | 32505844.0 |
| 2010-09-24 09:40:00 | AAPL | Stock | 10.4725 | 10.4832 | 10.4464 | 10.4504 | 24969616.0 |
| 2010-09-24 09:45:00 | AAPL | Stock | 10.4521 | 10.4593 | 10.4016 | 10.425 | 23807028.0 |
| 2010-09-24 09:50:00 | AAPL | Stock | 10.4254 | 10.445 | 10.4071 | 10.4325 | 16353820.0 |
| 2010-09-24 09:55:00 | AAPL | Stock | 10.434 | 10.4479 | 10.4321 | 10.4348 | 10500476.0 |
| 2010-09-24 10:00:00 | AAPL | Stock | 10.4396 | 10.46 | 10.4111 | 10.4566 | 20587756.0 |
| 2010-09-24 10:05:00 | AAPL | Stock | 10.4557 | 10.4679 | 10.4207 | 10.425 | 16250780.0 |
| 2010-09-24 10:10:00 | AAPL | Stock | 10.425 | 10.435 | 10.4125 | 10.4236 | 10913308.0 |
| 2010-09-24 10:15:00 | AAPL | Stock | 10.4257 | 10.4325 | 10.4175 | 10.4268 | 9028404.0 |
| 2010-09-24 10:20:00 | AAPL | Stock | 10.4271 | 10.4379 | 10.4143 | 10.4214 | 8982484.0 |
| 2010-09-24 10:25:00 | AAPL | Stock | 10.4215 | 10.4361 | 10.4004 | 10.4196 | 15436428.0 |
| 2010-09-24 10:30:00 | AAPL | Stock | 10.4196 | 10.4243 | 10.4111 | 10.4146 | 5956720.0 |
| 2010-09-24 10:35:00 | AAPL | Stock | 10.4147 | 10.425 | 10.4114 | 10.4204 | 5966520.0 |
| 2010-09-24 10:40:00 | AAPL | Stock | 10.4189 | 10.4493 | 10.4183 | 10.42 | 12361244.0 |
| 2010-09-24 10:45:00 | AAPL | Stock | 10.4221 | 10.4382 | 10.4221 | 10.4354 | 9938292.0 |
| 2010-09-24 10:50:00 | AAPL | Stock | 10.4354 | 10.4367 | 10.425 | 10.4318 | 4990860.0 |
| 2010-09-24 10:55:00 | AAPL | Stock | 10.4325 | 10.4375 | 10.425 | 10.4325 | 4683476.0 |
| 2010-09-24 11:00:00 | AAPL | Stock | 10.4325 | 10.4375 | 10.4286 | 10.4328 | 4380964.0 |
> showing 50 of 322,376 rows — these rows as CSV