PREVIEW / stock_5min / 2013-03-14
file: by_date/stock_5min/2013/2013-03-14.parquet size: 5.0 MB rows: 333,622 symbols: 3,455
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 |
|---|---|---|---|---|---|---|---|
| 2013-03-14 04:25:00 | AAPL | Stock | 15.3464 | 15.3464 | 15.3464 | 15.3464 | 2800.0 |
| 2013-03-14 04:50:00 | AAPL | Stock | 15.3571 | 15.3571 | 15.3571 | 15.3571 | 21840.0 |
| 2013-03-14 06:30:00 | AAPL | Stock | 15.3571 | 15.3571 | 15.3571 | 15.3571 | 16800.0 |
| 2013-03-14 06:40:00 | AAPL | Stock | 15.3589 | 15.3589 | 15.3589 | 15.3589 | 5572.0 |
| 2013-03-14 06:45:00 | AAPL | Stock | 15.3589 | 15.3589 | 15.3571 | 15.3571 | 16800.0 |
| 2013-03-14 06:50:00 | AAPL | Stock | 15.3329 | 15.3329 | 15.3329 | 15.3329 | 5600.0 |
| 2013-03-14 07:00:00 | AAPL | Stock | 15.3464 | 15.3464 | 15.3414 | 15.3464 | 16800.0 |
| 2013-03-14 07:15:00 | AAPL | Stock | 15.3429 | 15.3461 | 15.3429 | 15.3461 | 6720.0 |
| 2013-03-14 07:20:00 | AAPL | Stock | 15.3504 | 15.3504 | 15.35 | 15.35 | 11200.0 |
| 2013-03-14 07:25:00 | AAPL | Stock | 15.3571 | 15.3607 | 15.3571 | 15.3607 | 5600.0 |
| 2013-03-14 07:35:00 | AAPL | Stock | 15.3568 | 15.3568 | 15.3568 | 15.3568 | 10500.0 |
| 2013-03-14 07:40:00 | AAPL | Stock | 15.3486 | 15.3571 | 15.3482 | 15.3571 | 19600.0 |
| 2013-03-14 07:45:00 | AAPL | Stock | 15.3518 | 15.375 | 15.3518 | 15.375 | 61516.0 |
| 2013-03-14 07:50:00 | AAPL | Stock | 15.3875 | 15.5214 | 15.3782 | 15.4821 | 687372.0 |
| 2013-03-14 07:55:00 | AAPL | Stock | 15.47 | 15.4954 | 15.4579 | 15.4614 | 522760.0 |
| 2013-03-14 08:00:00 | AAPL | Stock | 15.4557 | 15.5236 | 15.375 | 15.4679 | 1004864.0 |
| 2013-03-14 08:05:00 | AAPL | Stock | 15.4743 | 15.4764 | 15.4464 | 15.4689 | 422548.0 |
| 2013-03-14 08:10:00 | AAPL | Stock | 15.4682 | 15.4821 | 15.4643 | 15.4732 | 383684.0 |
| 2013-03-14 08:15:00 | AAPL | Stock | 15.4804 | 15.4954 | 15.4718 | 15.4893 | 517468.0 |
| 2013-03-14 08:20:00 | AAPL | Stock | 15.485 | 15.5086 | 15.485 | 15.4964 | 593600.0 |
| 2013-03-14 08:25:00 | AAPL | Stock | 15.4929 | 15.4979 | 15.4857 | 15.4911 | 291620.0 |
| 2013-03-14 08:30:00 | AAPL | Stock | 15.4961 | 15.5 | 15.4839 | 15.4839 | 316708.0 |
| 2013-03-14 08:35:00 | AAPL | Stock | 15.4936 | 15.495 | 15.25 | 15.47 | 238728.0 |
| 2013-03-14 08:40:00 | AAPL | Stock | 15.4746 | 15.4811 | 15.4732 | 15.4732 | 212772.0 |
| 2013-03-14 08:45:00 | AAPL | Stock | 15.4679 | 15.4679 | 15.45 | 15.45 | 219100.0 |
| 2013-03-14 08:50:00 | AAPL | Stock | 15.4471 | 15.45 | 15.4325 | 15.4496 | 476784.0 |
| 2013-03-14 08:55:00 | AAPL | Stock | 15.4493 | 15.4493 | 15.4343 | 15.4468 | 352464.0 |
| 2013-03-14 09:00:00 | AAPL | Stock | 15.445 | 15.45 | 15.4321 | 15.4321 | 537180.0 |
| 2013-03-14 09:05:00 | AAPL | Stock | 15.4304 | 15.4354 | 15.4179 | 15.4354 | 421400.0 |
| 2013-03-14 09:10:00 | AAPL | Stock | 15.4375 | 15.4671 | 15.4332 | 15.4518 | 727916.0 |
| 2013-03-14 09:15:00 | AAPL | Stock | 15.4486 | 15.4536 | 15.4464 | 15.4464 | 191800.0 |
| 2013-03-14 09:20:00 | AAPL | Stock | 15.4464 | 15.4479 | 15.4396 | 15.4479 | 136052.0 |
| 2013-03-14 09:25:00 | AAPL | Stock | 15.4464 | 15.4643 | 15.4436 | 15.4604 | 247520.0 |
| 2013-03-14 09:30:00 | AAPL | Stock | 15.4582 | 15.4961 | 15.4214 | 15.4521 | 17856412.0 |
| 2013-03-14 09:35:00 | AAPL | Stock | 15.4554 | 15.5 | 15.4154 | 15.4454 | 10925040.0 |
| 2013-03-14 09:40:00 | AAPL | Stock | 15.4457 | 15.4507 | 15.3982 | 15.4214 | 8419740.0 |
| 2013-03-14 09:45:00 | AAPL | Stock | 15.4212 | 15.5086 | 15.4196 | 15.45 | 10513356.0 |
| 2013-03-14 09:50:00 | AAPL | Stock | 15.4496 | 15.4718 | 15.4179 | 15.4304 | 7629524.0 |
| 2013-03-14 09:55:00 | AAPL | Stock | 15.4268 | 15.4739 | 15.4246 | 15.4739 | 6798904.0 |
| 2013-03-14 10:00:00 | AAPL | Stock | 15.4736 | 15.4943 | 15.4554 | 15.4775 | 6886264.0 |
| 2013-03-14 10:05:00 | AAPL | Stock | 15.4786 | 15.5229 | 15.4607 | 15.4679 | 10285576.0 |
| 2013-03-14 10:10:00 | AAPL | Stock | 15.4699 | 15.4746 | 15.4395 | 15.4443 | 6029072.0 |
| 2013-03-14 10:15:00 | AAPL | Stock | 15.4475 | 15.4546 | 15.4196 | 15.4221 | 6388620.0 |
| 2013-03-14 10:20:00 | AAPL | Stock | 15.4268 | 15.4518 | 15.4225 | 15.4375 | 3321192.0 |
| 2013-03-14 10:25:00 | AAPL | Stock | 15.4361 | 15.4661 | 15.4254 | 15.4388 | 5672604.0 |
| 2013-03-14 10:30:00 | AAPL | Stock | 15.4461 | 15.4639 | 15.425 | 15.435 | 5458488.0 |
| 2013-03-14 10:35:00 | AAPL | Stock | 15.4339 | 15.4514 | 15.4025 | 15.4332 | 5836992.0 |
| 2013-03-14 10:40:00 | AAPL | Stock | 15.4348 | 15.445 | 15.4254 | 15.4321 | 1882076.0 |
| 2013-03-14 10:45:00 | AAPL | Stock | 15.4296 | 15.4296 | 15.3993 | 15.4054 | 3718456.0 |
| 2013-03-14 10:50:00 | AAPL | Stock | 15.4029 | 15.4175 | 15.3775 | 15.3971 | 5413100.0 |
> showing 50 of 333,622 rows — these rows as CSV