PREVIEW / stock_5min / 2011-12-28
file: by_date/stock_5min/2011/2011-12-28.parquet size: 4.6 MB rows: 312,791 symbols: 3,558
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-12-28 04:15:00 | AAPL | Stock | 14.4779 | 14.4779 | 14.4643 | 14.4643 | 8400.0 |
| 2011-12-28 04:40:00 | AAPL | Stock | 14.4829 | 14.4829 | 14.4829 | 14.4829 | 5600.0 |
| 2011-12-28 05:00:00 | AAPL | Stock | 14.475 | 14.475 | 14.475 | 14.475 | 5600.0 |
| 2011-12-28 05:25:00 | AAPL | Stock | 14.4875 | 14.4875 | 14.4875 | 14.4875 | 2800.0 |
| 2011-12-28 05:35:00 | AAPL | Stock | 14.5 | 14.5036 | 14.5 | 14.5036 | 8400.0 |
| 2011-12-28 06:15:00 | AAPL | Stock | 14.5357 | 14.5357 | 14.5357 | 14.5357 | 2800.0 |
| 2011-12-28 07:00:00 | AAPL | Stock | 14.5382 | 14.5654 | 14.5357 | 14.5382 | 78400.0 |
| 2011-12-28 07:05:00 | AAPL | Stock | 14.5357 | 14.5357 | 14.5268 | 14.5268 | 6300.0 |
| 2011-12-28 07:10:00 | AAPL | Stock | 14.5357 | 14.5536 | 14.5357 | 14.5536 | 49560.0 |
| 2011-12-28 07:15:00 | AAPL | Stock | 14.5661 | 14.5661 | 14.5661 | 14.5661 | 7700.0 |
| 2011-12-28 07:20:00 | AAPL | Stock | 14.5661 | 14.5661 | 14.5657 | 14.5657 | 25060.0 |
| 2011-12-28 07:25:00 | AAPL | Stock | 14.5654 | 14.5696 | 14.5643 | 14.5693 | 30800.0 |
| 2011-12-28 07:30:00 | AAPL | Stock | 14.5686 | 14.5686 | 14.5536 | 14.5561 | 11200.0 |
| 2011-12-28 07:35:00 | AAPL | Stock | 14.5707 | 14.58 | 14.5646 | 14.5704 | 110600.0 |
| 2011-12-28 07:40:00 | AAPL | Stock | 14.5707 | 14.5711 | 14.5679 | 14.5711 | 47600.0 |
| 2011-12-28 07:45:00 | AAPL | Stock | 14.5711 | 14.5711 | 14.565 | 14.565 | 16800.0 |
| 2011-12-28 07:50:00 | AAPL | Stock | 14.5668 | 14.5671 | 14.5539 | 14.5607 | 48160.0 |
| 2011-12-28 07:55:00 | AAPL | Stock | 14.5511 | 14.5511 | 14.53 | 14.5446 | 62300.0 |
| 2011-12-28 08:00:00 | AAPL | Stock | 14.5536 | 14.5554 | 14.5529 | 14.5532 | 51296.0 |
| 2011-12-28 08:05:00 | AAPL | Stock | 14.5536 | 14.5643 | 14.5536 | 14.5643 | 42140.0 |
| 2011-12-28 08:10:00 | AAPL | Stock | 14.5589 | 14.5589 | 14.55 | 14.5536 | 74760.0 |
| 2011-12-28 08:15:00 | AAPL | Stock | 14.5536 | 14.5536 | 14.5532 | 14.5532 | 8400.0 |
| 2011-12-28 08:20:00 | AAPL | Stock | 14.5536 | 14.5536 | 14.5507 | 14.5532 | 74312.0 |
| 2011-12-28 08:25:00 | AAPL | Stock | 14.5532 | 14.5536 | 14.5464 | 14.5464 | 60564.0 |
| 2011-12-28 08:30:00 | AAPL | Stock | 14.5464 | 14.5482 | 14.5464 | 14.5468 | 32900.0 |
| 2011-12-28 08:35:00 | AAPL | Stock | 14.5482 | 14.5707 | 14.5482 | 14.5704 | 145992.0 |
| 2011-12-28 08:40:00 | AAPL | Stock | 14.5679 | 14.5714 | 14.5561 | 14.5625 | 180320.0 |
| 2011-12-28 08:45:00 | AAPL | Stock | 14.5625 | 14.5714 | 14.5625 | 14.5714 | 93660.0 |
| 2011-12-28 08:50:00 | AAPL | Stock | 14.5714 | 14.5732 | 14.5646 | 14.5714 | 116060.0 |
| 2011-12-28 08:55:00 | AAPL | Stock | 14.5629 | 14.5679 | 14.5629 | 14.5661 | 44996.0 |
| 2011-12-28 09:00:00 | AAPL | Stock | 14.5661 | 14.5714 | 14.5614 | 14.5714 | 160860.0 |
| 2011-12-28 09:05:00 | AAPL | Stock | 14.5761 | 14.5779 | 14.5714 | 14.5714 | 55384.0 |
| 2011-12-28 09:10:00 | AAPL | Stock | 14.5714 | 14.5714 | 14.5714 | 14.5714 | 24696.0 |
| 2011-12-28 09:15:00 | AAPL | Stock | 14.5743 | 14.5743 | 14.5668 | 14.5668 | 116200.0 |
| 2011-12-28 09:20:00 | AAPL | Stock | 14.5643 | 14.5696 | 14.5607 | 14.5607 | 141260.0 |
| 2011-12-28 09:25:00 | AAPL | Stock | 14.5629 | 14.5714 | 14.5339 | 14.5339 | 596596.0 |
| 2011-12-28 09:30:00 | AAPL | Stock | 14.5339 | 14.5725 | 14.5275 | 14.5504 | 11718784.0 |
| 2011-12-28 09:35:00 | AAPL | Stock | 14.5507 | 14.5804 | 14.5425 | 14.5539 | 7289268.0 |
| 2011-12-28 09:40:00 | AAPL | Stock | 14.5539 | 14.5589 | 14.5179 | 14.52 | 6312208.0 |
| 2011-12-28 09:45:00 | AAPL | Stock | 14.5186 | 14.5224 | 14.4882 | 14.5093 | 5486824.0 |
| 2011-12-28 09:50:00 | AAPL | Stock | 14.5096 | 14.5146 | 14.4464 | 14.4493 | 9778944.0 |
| 2011-12-28 09:55:00 | AAPL | Stock | 14.4482 | 14.4675 | 14.4464 | 14.4625 | 7033880.0 |
| 2011-12-28 10:00:00 | AAPL | Stock | 14.465 | 14.4704 | 14.4518 | 14.4546 | 4442284.0 |
| 2011-12-28 10:05:00 | AAPL | Stock | 14.4579 | 14.5032 | 14.4536 | 14.4986 | 4999764.0 |
| 2011-12-28 10:10:00 | AAPL | Stock | 14.4986 | 14.5004 | 14.4761 | 14.482 | 2696540.0 |
| 2011-12-28 10:15:00 | AAPL | Stock | 14.4793 | 14.4802 | 14.45 | 14.4714 | 4188436.0 |
| 2011-12-28 10:20:00 | AAPL | Stock | 14.4714 | 14.4818 | 14.4554 | 14.4554 | 2682204.0 |
| 2011-12-28 10:25:00 | AAPL | Stock | 14.4547 | 14.4625 | 14.4504 | 14.4557 | 2797788.0 |
| 2011-12-28 10:30:00 | AAPL | Stock | 14.4535 | 14.4607 | 14.4464 | 14.4603 | 3986164.0 |
| 2011-12-28 10:35:00 | AAPL | Stock | 14.4604 | 14.4626 | 14.4482 | 14.4611 | 2543996.0 |
> showing 50 of 312,791 rows — these rows as CSV