PREVIEW / stock_5min / 2013-12-05
file: by_date/stock_5min/2013/2013-12-05.parquet size: 5.3 MB rows: 357,041 symbols: 3,533
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-12-05 04:00:00 | AAPL | Stock | 20.1821 | 20.5 | 20.1821 | 20.4975 | 95900.0 |
| 2013-12-05 04:05:00 | AAPL | Stock | 20.5071 | 20.5575 | 20.5071 | 20.5575 | 33600.0 |
| 2013-12-05 04:10:00 | AAPL | Stock | 20.56 | 20.56 | 20.56 | 20.56 | 2800.0 |
| 2013-12-05 04:15:00 | AAPL | Stock | 20.5182 | 20.5593 | 20.5182 | 20.5268 | 14000.0 |
| 2013-12-05 04:20:00 | AAPL | Stock | 20.5064 | 20.5268 | 20.5046 | 20.5268 | 22400.0 |
| 2013-12-05 04:30:00 | AAPL | Stock | 20.5457 | 20.5457 | 20.5457 | 20.5457 | 2800.0 |
| 2013-12-05 04:40:00 | AAPL | Stock | 20.555 | 20.5714 | 20.555 | 20.5704 | 29624.0 |
| 2013-12-05 04:50:00 | AAPL | Stock | 20.5654 | 20.5654 | 20.5357 | 20.5357 | 76020.0 |
| 2013-12-05 04:55:00 | AAPL | Stock | 20.5357 | 20.5357 | 20.5321 | 20.5321 | 20496.0 |
| 2013-12-05 05:00:00 | AAPL | Stock | 20.5321 | 20.5321 | 20.5107 | 20.5179 | 98504.0 |
| 2013-12-05 05:05:00 | AAPL | Stock | 20.5179 | 20.5214 | 20.5179 | 20.5214 | 15400.0 |
| 2013-12-05 05:10:00 | AAPL | Stock | 20.5179 | 20.5179 | 20.5143 | 20.5143 | 22428.0 |
| 2013-12-05 05:15:00 | AAPL | Stock | 20.5046 | 20.5046 | 20.4757 | 20.4757 | 63868.0 |
| 2013-12-05 05:20:00 | AAPL | Stock | 20.4921 | 20.4921 | 20.4821 | 20.4821 | 11200.0 |
| 2013-12-05 05:25:00 | AAPL | Stock | 20.4643 | 20.4643 | 20.4643 | 20.4643 | 15820.0 |
| 2013-12-05 05:30:00 | AAPL | Stock | 20.4857 | 20.4857 | 20.4857 | 20.4857 | 11200.0 |
| 2013-12-05 05:35:00 | AAPL | Stock | 20.4646 | 20.4743 | 20.4643 | 20.4643 | 45472.0 |
| 2013-12-05 05:40:00 | AAPL | Stock | 20.4646 | 20.4743 | 20.4643 | 20.4643 | 35000.0 |
| 2013-12-05 05:45:00 | AAPL | Stock | 20.4757 | 20.4757 | 20.4643 | 20.4643 | 8680.0 |
| 2013-12-05 05:50:00 | AAPL | Stock | 20.465 | 20.4757 | 20.465 | 20.4757 | 14224.0 |
| 2013-12-05 05:55:00 | AAPL | Stock | 20.4757 | 20.4757 | 20.4718 | 20.4718 | 8400.0 |
| 2013-12-05 06:00:00 | AAPL | Stock | 20.4757 | 20.5071 | 20.4757 | 20.5 | 110600.0 |
| 2013-12-05 06:05:00 | AAPL | Stock | 20.5 | 20.5114 | 20.4971 | 20.5 | 138656.0 |
| 2013-12-05 06:10:00 | AAPL | Stock | 20.5 | 20.5 | 20.4929 | 20.4929 | 53704.0 |
| 2013-12-05 06:15:00 | AAPL | Stock | 20.4929 | 20.5018 | 20.4929 | 20.5 | 52920.0 |
| 2013-12-05 06:20:00 | AAPL | Stock | 20.5 | 20.5314 | 20.5 | 20.5314 | 57988.0 |
| 2013-12-05 06:25:00 | AAPL | Stock | 20.5286 | 20.54 | 20.5179 | 20.5179 | 118132.0 |
| 2013-12-05 06:30:00 | AAPL | Stock | 20.52 | 20.5332 | 20.5071 | 20.5071 | 49308.0 |
| 2013-12-05 06:35:00 | AAPL | Stock | 20.5107 | 20.5179 | 20.5061 | 20.5143 | 72100.0 |
| 2013-12-05 06:40:00 | AAPL | Stock | 20.5179 | 20.5179 | 20.4643 | 20.47 | 182616.0 |
| 2013-12-05 06:45:00 | AAPL | Stock | 20.4696 | 20.4696 | 20.4464 | 20.4643 | 44240.0 |
| 2013-12-05 06:50:00 | AAPL | Stock | 20.4732 | 20.4732 | 20.4643 | 20.4643 | 80640.0 |
| 2013-12-05 06:55:00 | AAPL | Stock | 20.4643 | 20.4643 | 20.4589 | 20.4589 | 14700.0 |
| 2013-12-05 07:00:00 | AAPL | Stock | 20.4554 | 20.525 | 20.4482 | 20.5179 | 522508.0 |
| 2013-12-05 07:05:00 | AAPL | Stock | 20.5175 | 20.5893 | 20.5143 | 20.5893 | 492800.0 |
| 2013-12-05 07:10:00 | AAPL | Stock | 20.5893 | 20.5893 | 20.5714 | 20.5857 | 171220.0 |
| 2013-12-05 07:15:00 | AAPL | Stock | 20.5775 | 20.6018 | 20.5714 | 20.5804 | 119252.0 |
| 2013-12-05 07:20:00 | AAPL | Stock | 20.5886 | 20.6207 | 20.5825 | 20.6 | 354984.0 |
| 2013-12-05 07:25:00 | AAPL | Stock | 20.6036 | 20.6093 | 20.5643 | 20.5661 | 423220.0 |
| 2013-12-05 07:30:00 | AAPL | Stock | 20.5661 | 20.5757 | 20.5357 | 20.5357 | 329728.0 |
| 2013-12-05 07:35:00 | AAPL | Stock | 20.5311 | 20.5321 | 20.4996 | 20.4996 | 210140.0 |
| 2013-12-05 07:40:00 | AAPL | Stock | 20.49 | 20.5196 | 20.4668 | 20.5129 | 567252.0 |
| 2013-12-05 07:45:00 | AAPL | Stock | 20.5107 | 20.5168 | 20.4857 | 20.5082 | 272104.0 |
| 2013-12-05 07:50:00 | AAPL | Stock | 20.4975 | 20.5079 | 20.4818 | 20.4854 | 180796.0 |
| 2013-12-05 07:55:00 | AAPL | Stock | 20.4821 | 20.4875 | 20.4289 | 20.4614 | 951832.0 |
| 2013-12-05 08:00:00 | AAPL | Stock | 20.4604 | 20.5786 | 20.1607 | 20.4993 | 2278948.0 |
| 2013-12-05 08:05:00 | AAPL | Stock | 20.4482 | 20.5 | 20.4482 | 20.5 | 1146852.0 |
| 2013-12-05 08:10:00 | AAPL | Stock | 20.4929 | 20.5 | 20.4857 | 20.5 | 686840.0 |
| 2013-12-05 08:15:00 | AAPL | Stock | 20.4996 | 20.5107 | 20.4643 | 20.4657 | 1548680.0 |
| 2013-12-05 08:20:00 | AAPL | Stock | 20.4729 | 20.475 | 20.4121 | 20.4375 | 1802220.0 |
> showing 50 of 357,041 rows — these rows as CSV