PREVIEW / stock_5min / 2010-05-13
file: by_date/stock_5min/2010/2010-05-13.parquet size: 4.9 MB rows: 333,055 symbols: 3,484
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-13 05:00:00 | AAPL | Stock | 9.3261 | 9.3261 | 9.3236 | 9.3236 | 5600.0 |
| 2010-05-13 05:05:00 | AAPL | Stock | 9.3179 | 9.3179 | 9.3179 | 9.3179 | 4200.0 |
| 2010-05-13 05:40:00 | AAPL | Stock | 9.3511 | 9.3511 | 9.3179 | 9.3179 | 14560.0 |
| 2010-05-13 06:15:00 | AAPL | Stock | 9.3339 | 9.3589 | 9.3339 | 9.3589 | 8400.0 |
| 2010-05-13 07:00:00 | AAPL | Stock | 9.3564 | 9.3568 | 9.3554 | 9.3568 | 14000.0 |
| 2010-05-13 07:10:00 | AAPL | Stock | 9.3593 | 9.3811 | 9.3575 | 9.375 | 33600.0 |
| 2010-05-13 07:15:00 | AAPL | Stock | 9.375 | 9.3786 | 9.375 | 9.3786 | 16800.0 |
| 2010-05-13 07:20:00 | AAPL | Stock | 9.3857 | 9.3857 | 9.3786 | 9.3786 | 42000.0 |
| 2010-05-13 07:25:00 | AAPL | Stock | 9.3886 | 9.4071 | 9.3886 | 9.4071 | 96600.0 |
| 2010-05-13 07:30:00 | AAPL | Stock | 9.4036 | 9.4107 | 9.3929 | 9.4068 | 103880.0 |
| 2010-05-13 07:35:00 | AAPL | Stock | 9.4054 | 9.4093 | 9.4018 | 9.4093 | 11200.0 |
| 2010-05-13 07:40:00 | AAPL | Stock | 9.4018 | 9.405 | 9.3982 | 9.3982 | 38780.0 |
| 2010-05-13 07:45:00 | AAPL | Stock | 9.3982 | 9.4054 | 9.3982 | 9.4054 | 58800.0 |
| 2010-05-13 07:50:00 | AAPL | Stock | 9.405 | 9.4075 | 9.4004 | 9.4075 | 97720.0 |
| 2010-05-13 07:55:00 | AAPL | Stock | 9.3993 | 9.3993 | 9.3986 | 9.3986 | 15400.0 |
| 2010-05-13 08:00:00 | AAPL | Stock | 9.3964 | 9.4 | 9.3893 | 9.3936 | 450464.0 |
| 2010-05-13 08:05:00 | AAPL | Stock | 9.3932 | 9.4079 | 9.3929 | 9.4071 | 451220.0 |
| 2010-05-13 08:10:00 | AAPL | Stock | 9.4057 | 9.41 | 9.4036 | 9.4036 | 343588.0 |
| 2010-05-13 08:15:00 | AAPL | Stock | 9.405 | 9.4079 | 9.4025 | 9.4061 | 342720.0 |
| 2010-05-13 08:20:00 | AAPL | Stock | 9.4093 | 9.4446 | 9.4071 | 9.4446 | 495796.0 |
| 2010-05-13 08:25:00 | AAPL | Stock | 9.4411 | 9.4411 | 9.4289 | 9.4393 | 421680.0 |
| 2010-05-13 08:30:00 | AAPL | Stock | 9.4361 | 9.4368 | 9.4146 | 9.4286 | 688800.0 |
| 2010-05-13 08:35:00 | AAPL | Stock | 9.4257 | 9.4261 | 9.4146 | 9.4146 | 194180.0 |
| 2010-05-13 08:40:00 | AAPL | Stock | 9.4186 | 9.4189 | 9.4071 | 9.4112 | 516404.0 |
| 2010-05-13 08:45:00 | AAPL | Stock | 9.4111 | 9.4175 | 9.4036 | 9.4154 | 502796.0 |
| 2010-05-13 08:50:00 | AAPL | Stock | 9.4125 | 9.4125 | 9.4036 | 9.4104 | 348208.0 |
| 2010-05-13 08:55:00 | AAPL | Stock | 9.4157 | 9.4157 | 9.4021 | 9.4039 | 471072.0 |
| 2010-05-13 09:00:00 | AAPL | Stock | 9.4032 | 9.4032 | 9.3861 | 9.3871 | 281680.0 |
| 2010-05-13 09:05:00 | AAPL | Stock | 9.3886 | 9.3914 | 9.3643 | 9.3729 | 431956.0 |
| 2010-05-13 09:10:00 | AAPL | Stock | 9.3737 | 9.3845 | 9.3729 | 9.3789 | 135464.0 |
| 2010-05-13 09:15:00 | AAPL | Stock | 9.3804 | 9.3857 | 9.3768 | 9.3857 | 199416.0 |
| 2010-05-13 09:20:00 | AAPL | Stock | 9.3857 | 9.4014 | 9.3604 | 9.3946 | 418908.0 |
| 2010-05-13 09:25:00 | AAPL | Stock | 9.3929 | 9.3989 | 9.3889 | 9.3979 | 230580.0 |
| 2010-05-13 09:30:00 | AAPL | Stock | 9.3979 | 9.405 | 9.3571 | 9.3589 | 19381348.0 |
| 2010-05-13 09:35:00 | AAPL | Stock | 9.3625 | 9.4232 | 9.3532 | 9.4019 | 15752828.0 |
| 2010-05-13 09:40:00 | AAPL | Stock | 9.4054 | 9.4068 | 9.3614 | 9.3893 | 12609940.0 |
| 2010-05-13 09:45:00 | AAPL | Stock | 9.39 | 9.4179 | 9.3696 | 9.4136 | 14924560.0 |
| 2010-05-13 09:50:00 | AAPL | Stock | 9.4161 | 9.4518 | 9.4086 | 9.4489 | 16934232.0 |
| 2010-05-13 09:55:00 | AAPL | Stock | 9.4482 | 9.4571 | 9.4357 | 9.442 | 14828380.0 |
| 2010-05-13 10:00:00 | AAPL | Stock | 9.4421 | 9.4614 | 9.4321 | 9.4561 | 14661024.0 |
| 2010-05-13 10:05:00 | AAPL | Stock | 9.4575 | 9.4582 | 9.4196 | 9.4525 | 11939284.0 |
| 2010-05-13 10:10:00 | AAPL | Stock | 9.4514 | 9.455 | 9.4325 | 9.4525 | 6362048.0 |
| 2010-05-13 10:15:00 | AAPL | Stock | 9.453 | 9.4625 | 9.4471 | 9.4624 | 11075904.0 |
| 2010-05-13 10:20:00 | AAPL | Stock | 9.4621 | 9.4632 | 9.4457 | 9.4557 | 7886788.0 |
| 2010-05-13 10:25:00 | AAPL | Stock | 9.4554 | 9.4643 | 9.4429 | 9.4536 | 10479000.0 |
| 2010-05-13 10:30:00 | AAPL | Stock | 9.4511 | 9.4536 | 9.4379 | 9.4382 | 5995332.0 |
| 2010-05-13 10:35:00 | AAPL | Stock | 9.4417 | 9.4457 | 9.4246 | 9.425 | 8453172.0 |
| 2010-05-13 10:40:00 | AAPL | Stock | 9.4261 | 9.4421 | 9.425 | 9.44 | 5546212.0 |
| 2010-05-13 10:45:00 | AAPL | Stock | 9.4396 | 9.4421 | 9.4325 | 9.4357 | 2957388.0 |
| 2010-05-13 10:50:00 | AAPL | Stock | 9.4361 | 9.4375 | 9.4225 | 9.427 | 5403384.0 |
> showing 50 of 333,055 rows — these rows as CSV