PREVIEW / stock_5min / 2012-11-26
file: by_date/stock_5min/2012/2012-11-26.parquet size: 4.8 MB rows: 322,435 symbols: 3,497
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 |
|---|---|---|---|---|---|---|---|
| 2012-11-26 04:00:00 | AAPL | Stock | 20.4643 | 20.4643 | 20.4579 | 20.4579 | 30800.0 |
| 2012-11-26 04:05:00 | AAPL | Stock | 20.4714 | 20.4821 | 20.4714 | 20.4821 | 14700.0 |
| 2012-11-26 04:10:00 | AAPL | Stock | 20.4996 | 20.4996 | 20.4996 | 20.4996 | 3500.0 |
| 2012-11-26 04:30:00 | AAPL | Stock | 20.4993 | 20.535 | 20.4993 | 20.535 | 30520.0 |
| 2012-11-26 04:40:00 | AAPL | Stock | 20.4893 | 20.5082 | 20.4893 | 20.5 | 26040.0 |
| 2012-11-26 04:50:00 | AAPL | Stock | 20.5 | 20.5 | 20.5 | 20.5 | 21420.0 |
| 2012-11-26 04:55:00 | AAPL | Stock | 20.5 | 20.5 | 20.4821 | 20.4821 | 21448.0 |
| 2012-11-26 05:00:00 | AAPL | Stock | 20.4768 | 20.4768 | 20.4768 | 20.4768 | 4200.0 |
| 2012-11-26 05:20:00 | AAPL | Stock | 20.4946 | 20.4946 | 20.4946 | 20.4946 | 7000.0 |
| 2012-11-26 05:30:00 | AAPL | Stock | 20.475 | 20.475 | 20.475 | 20.475 | 5600.0 |
| 2012-11-26 05:35:00 | AAPL | Stock | 20.4554 | 20.4636 | 20.4554 | 20.4636 | 14000.0 |
| 2012-11-26 05:40:00 | AAPL | Stock | 20.5 | 20.5 | 20.5 | 20.5 | 2800.0 |
| 2012-11-26 05:45:00 | AAPL | Stock | 20.5 | 20.5 | 20.5 | 20.5 | 14952.0 |
| 2012-11-26 05:55:00 | AAPL | Stock | 20.5143 | 20.5143 | 20.5143 | 20.5143 | 5600.0 |
| 2012-11-26 06:00:00 | AAPL | Stock | 20.4979 | 20.4979 | 20.4821 | 20.4821 | 9800.0 |
| 2012-11-26 06:05:00 | AAPL | Stock | 20.4879 | 20.4971 | 20.4879 | 20.4971 | 11200.0 |
| 2012-11-26 06:10:00 | AAPL | Stock | 20.4904 | 20.4904 | 20.4904 | 20.4904 | 2800.0 |
| 2012-11-26 06:15:00 | AAPL | Stock | 20.4979 | 20.4979 | 20.4979 | 20.4979 | 2940.0 |
| 2012-11-26 06:20:00 | AAPL | Stock | 20.5121 | 20.5143 | 20.5 | 20.5 | 22400.0 |
| 2012-11-26 06:45:00 | AAPL | Stock | 20.4911 | 20.4911 | 20.4911 | 20.4911 | 5600.0 |
| 2012-11-26 06:55:00 | AAPL | Stock | 20.4929 | 20.4929 | 20.4607 | 20.4643 | 46032.0 |
| 2012-11-26 07:00:00 | AAPL | Stock | 20.4643 | 20.4664 | 20.4571 | 20.4657 | 66640.0 |
| 2012-11-26 07:05:00 | AAPL | Stock | 20.4721 | 20.4786 | 20.4536 | 20.4643 | 122080.0 |
| 2012-11-26 07:10:00 | AAPL | Stock | 20.4643 | 20.4786 | 20.4579 | 20.4579 | 80080.0 |
| 2012-11-26 07:15:00 | AAPL | Stock | 20.4557 | 20.4632 | 20.4307 | 20.4418 | 70868.0 |
| 2012-11-26 07:20:00 | AAPL | Stock | 20.4396 | 20.4571 | 20.4396 | 20.4529 | 28000.0 |
| 2012-11-26 07:25:00 | AAPL | Stock | 20.4525 | 20.4536 | 20.4468 | 20.45 | 30800.0 |
| 2012-11-26 07:30:00 | AAPL | Stock | 20.455 | 20.4607 | 20.4539 | 20.4571 | 39200.0 |
| 2012-11-26 07:35:00 | AAPL | Stock | 20.4507 | 20.4696 | 20.4482 | 20.4554 | 148288.0 |
| 2012-11-26 07:40:00 | AAPL | Stock | 20.4507 | 20.4507 | 20.4107 | 20.4107 | 256256.0 |
| 2012-11-26 07:45:00 | AAPL | Stock | 20.4114 | 20.4189 | 20.4071 | 20.4189 | 81060.0 |
| 2012-11-26 07:50:00 | AAPL | Stock | 20.4246 | 20.4286 | 20.4196 | 20.4286 | 64624.0 |
| 2012-11-26 07:55:00 | AAPL | Stock | 20.4189 | 20.4361 | 20.3779 | 20.4286 | 541576.0 |
| 2012-11-26 08:00:00 | AAPL | Stock | 20.4521 | 20.4811 | 20.4196 | 20.4464 | 644644.0 |
| 2012-11-26 08:05:00 | AAPL | Stock | 20.4514 | 20.4729 | 20.4507 | 20.4571 | 356384.0 |
| 2012-11-26 08:10:00 | AAPL | Stock | 20.4607 | 20.4643 | 20.4554 | 20.4571 | 192724.0 |
| 2012-11-26 08:15:00 | AAPL | Stock | 20.4554 | 20.4664 | 20.45 | 20.4529 | 353556.0 |
| 2012-11-26 08:20:00 | AAPL | Stock | 20.45 | 20.4536 | 20.4321 | 20.4468 | 233744.0 |
| 2012-11-26 08:25:00 | AAPL | Stock | 20.4514 | 20.4536 | 20.4464 | 20.45 | 84000.0 |
| 2012-11-26 08:30:00 | AAPL | Stock | 20.4482 | 20.4536 | 20.4339 | 20.4536 | 253736.0 |
| 2012-11-26 08:35:00 | AAPL | Stock | 20.4529 | 20.4554 | 20.4464 | 20.4536 | 194740.0 |
| 2012-11-26 08:40:00 | AAPL | Stock | 20.4536 | 20.4536 | 20.4332 | 20.45 | 367192.0 |
| 2012-11-26 08:45:00 | AAPL | Stock | 20.4521 | 20.455 | 20.4407 | 20.4496 | 147000.0 |
| 2012-11-26 08:50:00 | AAPL | Stock | 20.4496 | 20.4564 | 20.4461 | 20.4564 | 289660.0 |
| 2012-11-26 08:55:00 | AAPL | Stock | 20.4561 | 20.4643 | 20.4514 | 20.4607 | 582428.0 |
| 2012-11-26 09:00:00 | AAPL | Stock | 20.4596 | 20.4889 | 20.4596 | 20.4889 | 583996.0 |
| 2012-11-26 09:05:00 | AAPL | Stock | 20.4839 | 20.5114 | 20.4839 | 20.5 | 872536.0 |
| 2012-11-26 09:10:00 | AAPL | Stock | 20.4996 | 20.5257 | 20.4996 | 20.5257 | 510048.0 |
| 2012-11-26 09:15:00 | AAPL | Stock | 20.5229 | 20.5339 | 20.5189 | 20.5339 | 652372.0 |
| 2012-11-26 09:20:00 | AAPL | Stock | 20.535 | 20.5393 | 20.5175 | 20.5179 | 787724.0 |
> showing 50 of 322,435 rows — these rows as CSV