PREVIEW / stock_5min / 2010-05-03
file: by_date/stock_5min/2010/2010-05-03.parquet size: 5.1 MB rows: 342,552 symbols: 3,505
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-05-03 04:15:00 | AAPL | Stock | 9.3704 | 9.3704 | 9.3704 | 9.3704 | 2800.0 |
| 2010-05-03 06:10:00 | AAPL | Stock | 9.3429 | 9.3429 | 9.3318 | 9.3318 | 14000.0 |
| 2010-05-03 06:20:00 | AAPL | Stock | 9.3321 | 9.3321 | 9.3321 | 9.3321 | 5600.0 |
| 2010-05-03 06:25:00 | AAPL | Stock | 9.3396 | 9.3396 | 9.3396 | 9.3396 | 2800.0 |
| 2010-05-03 06:30:00 | AAPL | Stock | 9.3396 | 9.3414 | 9.3396 | 9.3414 | 11200.0 |
| 2010-05-03 06:45:00 | AAPL | Stock | 9.3554 | 9.3575 | 9.3554 | 9.3575 | 28000.0 |
| 2010-05-03 06:50:00 | AAPL | Stock | 9.3579 | 9.3579 | 9.3579 | 9.3579 | 2800.0 |
| 2010-05-03 06:55:00 | AAPL | Stock | 9.36 | 9.3679 | 9.36 | 9.3679 | 22400.0 |
| 2010-05-03 07:00:00 | AAPL | Stock | 9.3814 | 9.3832 | 9.3814 | 9.3832 | 14000.0 |
| 2010-05-03 07:05:00 | AAPL | Stock | 9.3871 | 9.4071 | 9.3871 | 9.4071 | 33600.0 |
| 2010-05-03 07:15:00 | AAPL | Stock | 9.4068 | 9.4068 | 9.4068 | 9.4068 | 2800.0 |
| 2010-05-03 07:20:00 | AAPL | Stock | 9.4 | 9.4 | 9.3968 | 9.3968 | 5600.0 |
| 2010-05-03 07:25:00 | AAPL | Stock | 9.3968 | 9.3968 | 9.3968 | 9.3968 | 2800.0 |
| 2010-05-03 07:30:00 | AAPL | Stock | 9.3932 | 9.3932 | 9.3839 | 9.3843 | 38780.0 |
| 2010-05-03 07:35:00 | AAPL | Stock | 9.3857 | 9.3875 | 9.3846 | 9.3875 | 32900.0 |
| 2010-05-03 07:45:00 | AAPL | Stock | 9.3929 | 9.3946 | 9.3929 | 9.3946 | 9800.0 |
| 2010-05-03 07:50:00 | AAPL | Stock | 9.3946 | 9.4161 | 9.3946 | 9.4132 | 289800.0 |
| 2010-05-03 07:55:00 | AAPL | Stock | 9.4154 | 9.4179 | 9.4071 | 9.4161 | 107800.0 |
| 2010-05-03 08:00:00 | AAPL | Stock | 9.4161 | 9.4161 | 9.3246 | 9.3929 | 318136.0 |
| 2010-05-03 08:05:00 | AAPL | Stock | 9.3932 | 9.4054 | 9.3932 | 9.4046 | 117376.0 |
| 2010-05-03 08:10:00 | AAPL | Stock | 9.4054 | 9.4196 | 9.4054 | 9.415 | 206220.0 |
| 2010-05-03 08:15:00 | AAPL | Stock | 9.4171 | 9.4339 | 9.4146 | 9.4314 | 251132.0 |
| 2010-05-03 08:20:00 | AAPL | Stock | 9.4371 | 9.4425 | 9.4296 | 9.4329 | 428092.0 |
| 2010-05-03 08:25:00 | AAPL | Stock | 9.4321 | 9.4446 | 9.4293 | 9.4414 | 522368.0 |
| 2010-05-03 08:30:00 | AAPL | Stock | 9.4382 | 9.4511 | 9.4379 | 9.4464 | 691068.0 |
| 2010-05-03 08:35:00 | AAPL | Stock | 9.4464 | 9.4532 | 9.4464 | 9.45 | 141932.0 |
| 2010-05-03 08:40:00 | AAPL | Stock | 9.4514 | 9.4532 | 9.4468 | 9.4489 | 182140.0 |
| 2010-05-03 08:45:00 | AAPL | Stock | 9.4493 | 9.4536 | 9.4464 | 9.4514 | 343000.0 |
| 2010-05-03 08:50:00 | AAPL | Stock | 9.4511 | 9.4511 | 9.3246 | 9.4507 | 357280.0 |
| 2010-05-03 08:55:00 | AAPL | Stock | 9.4514 | 9.4521 | 9.4482 | 9.4496 | 343336.0 |
| 2010-05-03 09:00:00 | AAPL | Stock | 9.4486 | 9.4486 | 9.43 | 9.4318 | 657300.0 |
| 2010-05-03 09:05:00 | AAPL | Stock | 9.4314 | 9.4329 | 9.4289 | 9.4293 | 214172.0 |
| 2010-05-03 09:10:00 | AAPL | Stock | 9.4304 | 9.4314 | 9.4236 | 9.4286 | 450688.0 |
| 2010-05-03 09:15:00 | AAPL | Stock | 9.4286 | 9.4304 | 9.4225 | 9.4275 | 117600.0 |
| 2010-05-03 09:20:00 | AAPL | Stock | 9.4232 | 9.425 | 9.4079 | 9.4114 | 410480.0 |
| 2010-05-03 09:25:00 | AAPL | Stock | 9.4139 | 9.4214 | 9.4114 | 9.4186 | 871080.0 |
| 2010-05-03 09:30:00 | AAPL | Stock | 9.4229 | 9.4436 | 9.3886 | 9.42 | 19719504.0 |
| 2010-05-03 09:35:00 | AAPL | Stock | 9.4196 | 9.4475 | 9.4143 | 9.4346 | 22030652.0 |
| 2010-05-03 09:40:00 | AAPL | Stock | 9.4361 | 9.4571 | 9.4286 | 9.4318 | 16828420.0 |
| 2010-05-03 09:45:00 | AAPL | Stock | 9.43 | 9.4414 | 9.4214 | 9.4325 | 6820268.0 |
| 2010-05-03 09:50:00 | AAPL | Stock | 9.4325 | 9.4364 | 9.4225 | 9.4282 | 6284068.0 |
| 2010-05-03 09:55:00 | AAPL | Stock | 9.4275 | 9.4461 | 9.4275 | 9.4339 | 7363720.0 |
| 2010-05-03 10:00:00 | AAPL | Stock | 9.4339 | 9.4446 | 9.425 | 9.4404 | 7652540.0 |
| 2010-05-03 10:05:00 | AAPL | Stock | 9.4425 | 9.4907 | 9.4386 | 9.4893 | 13743856.0 |
| 2010-05-03 10:10:00 | AAPL | Stock | 9.4893 | 9.5193 | 9.4875 | 9.5111 | 14553308.0 |
| 2010-05-03 10:15:00 | AAPL | Stock | 9.5107 | 9.5318 | 9.5104 | 9.5125 | 7850192.0 |
| 2010-05-03 10:20:00 | AAPL | Stock | 9.5139 | 9.5268 | 9.5043 | 9.5075 | 8087464.0 |
| 2010-05-03 10:25:00 | AAPL | Stock | 9.51 | 9.5193 | 9.5054 | 9.5105 | 4311524.0 |
| 2010-05-03 10:30:00 | AAPL | Stock | 9.5093 | 9.5157 | 9.4771 | 9.4809 | 9775920.0 |
| 2010-05-03 10:35:00 | AAPL | Stock | 9.4801 | 9.5025 | 9.48 | 9.4986 | 5101376.0 |
> showing 50 of 342,552 rows — these rows as CSV