PREVIEW / stock_5min / 2011-05-10
file: by_date/stock_5min/2011/2011-05-10.parquet size: 4.9 MB rows: 329,813 symbols: 3,549
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 |
|---|---|---|---|---|---|---|---|
| 2011-05-10 04:00:00 | AAPL | Stock | 12.4464 | 12.4464 | 12.4304 | 12.4304 | 5600.0 |
| 2011-05-10 04:30:00 | AAPL | Stock | 12.4425 | 12.4425 | 12.4425 | 12.4425 | 2800.0 |
| 2011-05-10 04:40:00 | AAPL | Stock | 12.4454 | 12.4454 | 12.4454 | 12.4454 | 2800.0 |
| 2011-05-10 04:45:00 | AAPL | Stock | 12.4425 | 12.4425 | 12.4425 | 12.4425 | 5600.0 |
| 2011-05-10 05:40:00 | AAPL | Stock | 12.4393 | 12.4393 | 12.4393 | 12.4393 | 84000.0 |
| 2011-05-10 06:25:00 | AAPL | Stock | 12.4304 | 12.4304 | 12.4304 | 12.4304 | 5600.0 |
| 2011-05-10 07:00:00 | AAPL | Stock | 12.4468 | 12.4504 | 12.4464 | 12.4464 | 67200.0 |
| 2011-05-10 07:05:00 | AAPL | Stock | 12.4532 | 12.4532 | 12.4446 | 12.4461 | 28000.0 |
| 2011-05-10 07:15:00 | AAPL | Stock | 12.4446 | 12.4446 | 12.4421 | 12.4429 | 19600.0 |
| 2011-05-10 07:20:00 | AAPL | Stock | 12.4429 | 12.4429 | 12.4425 | 12.4425 | 14308.0 |
| 2011-05-10 07:25:00 | AAPL | Stock | 12.4382 | 12.4382 | 12.4382 | 12.4382 | 5292.0 |
| 2011-05-10 07:30:00 | AAPL | Stock | 12.4357 | 12.4425 | 12.4357 | 12.4393 | 78400.0 |
| 2011-05-10 07:35:00 | AAPL | Stock | 12.4439 | 12.445 | 12.4382 | 12.445 | 31780.0 |
| 2011-05-10 07:40:00 | AAPL | Stock | 12.4414 | 12.445 | 12.44 | 12.445 | 25200.0 |
| 2011-05-10 07:45:00 | AAPL | Stock | 12.4464 | 12.4464 | 12.4464 | 12.4464 | 5600.0 |
| 2011-05-10 07:50:00 | AAPL | Stock | 12.4464 | 12.4821 | 12.4464 | 12.465 | 143640.0 |
| 2011-05-10 07:55:00 | AAPL | Stock | 12.4775 | 12.48 | 12.4575 | 12.4707 | 119168.0 |
| 2011-05-10 08:00:00 | AAPL | Stock | 12.4679 | 12.4707 | 12.4375 | 12.4457 | 334824.0 |
| 2011-05-10 08:05:00 | AAPL | Stock | 12.4482 | 12.4493 | 12.4389 | 12.4389 | 107716.0 |
| 2011-05-10 08:10:00 | AAPL | Stock | 12.4396 | 12.46 | 12.4357 | 12.4582 | 197288.0 |
| 2011-05-10 08:15:00 | AAPL | Stock | 12.4557 | 12.4575 | 12.4475 | 12.4575 | 107940.0 |
| 2011-05-10 08:20:00 | AAPL | Stock | 12.4571 | 12.4607 | 12.4543 | 12.4543 | 102032.0 |
| 2011-05-10 08:25:00 | AAPL | Stock | 12.4554 | 12.4582 | 12.4143 | 12.4582 | 196560.0 |
| 2011-05-10 08:30:00 | AAPL | Stock | 12.4582 | 12.4614 | 12.4143 | 12.4571 | 397068.0 |
| 2011-05-10 08:35:00 | AAPL | Stock | 12.4568 | 12.4579 | 12.4504 | 12.4571 | 41636.0 |
| 2011-05-10 08:40:00 | AAPL | Stock | 12.4571 | 12.4571 | 12.4475 | 12.4475 | 26740.0 |
| 2011-05-10 08:45:00 | AAPL | Stock | 12.4554 | 12.4564 | 12.4554 | 12.4564 | 11200.0 |
| 2011-05-10 08:50:00 | AAPL | Stock | 12.4532 | 12.4554 | 12.4532 | 12.4554 | 11200.0 |
| 2011-05-10 08:55:00 | AAPL | Stock | 12.4554 | 12.4554 | 12.4532 | 12.4536 | 14000.0 |
| 2011-05-10 09:00:00 | AAPL | Stock | 12.4554 | 12.4554 | 12.45 | 12.4511 | 29064.0 |
| 2011-05-10 09:05:00 | AAPL | Stock | 12.4554 | 12.4554 | 12.4464 | 12.4464 | 79520.0 |
| 2011-05-10 09:10:00 | AAPL | Stock | 12.4436 | 12.4464 | 12.4429 | 12.4429 | 52108.0 |
| 2011-05-10 09:15:00 | AAPL | Stock | 12.4479 | 12.45 | 12.4429 | 12.45 | 16800.0 |
| 2011-05-10 09:20:00 | AAPL | Stock | 12.4496 | 12.4496 | 12.4429 | 12.4429 | 30800.0 |
| 2011-05-10 09:25:00 | AAPL | Stock | 12.4464 | 12.4625 | 12.4429 | 12.4625 | 420028.0 |
| 2011-05-10 09:30:00 | AAPL | Stock | 12.4596 | 12.4629 | 12.413 | 12.4379 | 10371284.0 |
| 2011-05-10 09:35:00 | AAPL | Stock | 12.4384 | 12.4421 | 12.4189 | 12.4189 | 6152356.0 |
| 2011-05-10 09:40:00 | AAPL | Stock | 12.4196 | 12.4261 | 12.3946 | 12.3975 | 7418180.0 |
| 2011-05-10 09:45:00 | AAPL | Stock | 12.3975 | 12.4096 | 12.3807 | 12.4096 | 9347016.0 |
| 2011-05-10 09:50:00 | AAPL | Stock | 12.4086 | 12.41 | 12.3929 | 12.3982 | 4611796.0 |
| 2011-05-10 09:55:00 | AAPL | Stock | 12.3961 | 12.4254 | 12.3943 | 12.4232 | 6801340.0 |
| 2011-05-10 10:00:00 | AAPL | Stock | 12.4254 | 12.4279 | 12.4118 | 12.4225 | 5693408.0 |
| 2011-05-10 10:05:00 | AAPL | Stock | 12.4214 | 12.4357 | 12.4143 | 12.4216 | 5201504.0 |
| 2011-05-10 10:10:00 | AAPL | Stock | 12.4207 | 12.4236 | 12.4082 | 12.4186 | 3329564.0 |
| 2011-05-10 10:15:00 | AAPL | Stock | 12.4193 | 12.4232 | 12.4011 | 12.4039 | 3310468.0 |
| 2011-05-10 10:20:00 | AAPL | Stock | 12.4046 | 12.4268 | 12.4032 | 12.4125 | 4007220.0 |
| 2011-05-10 10:25:00 | AAPL | Stock | 12.4125 | 12.4204 | 12.4054 | 12.4122 | 2655772.0 |
| 2011-05-10 10:30:00 | AAPL | Stock | 12.4121 | 12.4239 | 12.4096 | 12.4146 | 1864240.0 |
| 2011-05-10 10:35:00 | AAPL | Stock | 12.4146 | 12.4239 | 12.4125 | 12.4164 | 1657096.0 |
| 2011-05-10 10:40:00 | AAPL | Stock | 12.415 | 12.415 | 12.405 | 12.4068 | 3056844.0 |
> showing 50 of 329,813 rows — these rows as CSV