PREVIEW / stock_5min / 2011-03-02
file: by_date/stock_5min/2011/2011-03-02.parquet size: 4.9 MB rows: 334,219 symbols: 3,525
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-03-02 04:05:00 | AAPL | Stock | 12.4607 | 12.4607 | 12.4607 | 12.4607 | 2800.0 |
| 2011-03-02 04:20:00 | AAPL | Stock | 12.4907 | 12.4907 | 12.4907 | 12.4907 | 5600.0 |
| 2011-03-02 05:00:00 | AAPL | Stock | 12.5 | 12.5 | 12.5 | 12.5 | 2800.0 |
| 2011-03-02 05:20:00 | AAPL | Stock | 12.5218 | 12.5218 | 12.5218 | 12.5218 | 2800.0 |
| 2011-03-02 05:25:00 | AAPL | Stock | 12.5232 | 12.5232 | 12.5232 | 12.5232 | 2800.0 |
| 2011-03-02 05:30:00 | AAPL | Stock | 12.5214 | 12.5214 | 12.5214 | 12.5214 | 11200.0 |
| 2011-03-02 05:35:00 | AAPL | Stock | 12.5475 | 12.5725 | 12.5475 | 12.5714 | 28000.0 |
| 2011-03-02 05:55:00 | AAPL | Stock | 12.5346 | 12.5346 | 12.5343 | 12.5343 | 5600.0 |
| 2011-03-02 06:40:00 | AAPL | Stock | 12.5139 | 12.5139 | 12.5139 | 12.5139 | 2800.0 |
| 2011-03-02 06:50:00 | AAPL | Stock | 12.5343 | 12.5343 | 12.5343 | 12.5343 | 2800.0 |
| 2011-03-02 07:00:00 | AAPL | Stock | 12.5071 | 12.5357 | 12.5071 | 12.5214 | 28000.0 |
| 2011-03-02 07:05:00 | AAPL | Stock | 12.525 | 12.525 | 12.5004 | 12.5107 | 76160.0 |
| 2011-03-02 07:10:00 | AAPL | Stock | 12.5107 | 12.5107 | 12.5107 | 12.5107 | 7840.0 |
| 2011-03-02 07:15:00 | AAPL | Stock | 12.5154 | 12.5154 | 12.5107 | 12.5107 | 9632.0 |
| 2011-03-02 07:20:00 | AAPL | Stock | 12.5243 | 12.5243 | 12.5232 | 12.5232 | 5600.0 |
| 2011-03-02 07:25:00 | AAPL | Stock | 12.5236 | 12.5357 | 12.5236 | 12.5357 | 44800.0 |
| 2011-03-02 07:30:00 | AAPL | Stock | 12.5264 | 12.5264 | 12.5264 | 12.5264 | 2800.0 |
| 2011-03-02 07:35:00 | AAPL | Stock | 12.5264 | 12.5307 | 12.5214 | 12.5214 | 19600.0 |
| 2011-03-02 07:45:00 | AAPL | Stock | 12.5261 | 12.5264 | 12.5261 | 12.5261 | 156100.0 |
| 2011-03-02 07:50:00 | AAPL | Stock | 12.5214 | 12.5268 | 12.5214 | 12.5268 | 22120.0 |
| 2011-03-02 07:55:00 | AAPL | Stock | 12.5357 | 12.55 | 12.5357 | 12.55 | 42728.0 |
| 2011-03-02 08:00:00 | AAPL | Stock | 12.5379 | 12.5621 | 12.5179 | 12.5296 | 236432.0 |
| 2011-03-02 08:05:00 | AAPL | Stock | 12.5404 | 12.5404 | 12.5275 | 12.5275 | 204036.0 |
| 2011-03-02 08:10:00 | AAPL | Stock | 12.5343 | 12.5357 | 12.5204 | 12.5336 | 42588.0 |
| 2011-03-02 08:15:00 | AAPL | Stock | 12.5339 | 12.5343 | 12.5071 | 12.5071 | 407456.0 |
| 2011-03-02 08:20:00 | AAPL | Stock | 12.5104 | 12.5143 | 12.4793 | 12.48 | 203560.0 |
| 2011-03-02 08:25:00 | AAPL | Stock | 12.48 | 12.4814 | 12.4604 | 12.4679 | 246372.0 |
| 2011-03-02 08:30:00 | AAPL | Stock | 12.4704 | 12.4807 | 12.4643 | 12.4807 | 114324.0 |
| 2011-03-02 08:35:00 | AAPL | Stock | 12.4793 | 12.4904 | 12.4793 | 12.4896 | 50988.0 |
| 2011-03-02 08:40:00 | AAPL | Stock | 12.4857 | 12.4893 | 12.4786 | 12.4886 | 31584.0 |
| 2011-03-02 08:45:00 | AAPL | Stock | 12.4871 | 12.5114 | 12.4807 | 12.5114 | 230916.0 |
| 2011-03-02 08:50:00 | AAPL | Stock | 12.5057 | 12.5114 | 12.5 | 12.5036 | 171780.0 |
| 2011-03-02 08:55:00 | AAPL | Stock | 12.5004 | 12.5004 | 12.4964 | 12.4964 | 37772.0 |
| 2011-03-02 09:00:00 | AAPL | Stock | 12.4946 | 12.4964 | 12.4857 | 12.4861 | 206584.0 |
| 2011-03-02 09:05:00 | AAPL | Stock | 12.4861 | 12.4979 | 12.4839 | 12.4979 | 92932.0 |
| 2011-03-02 09:10:00 | AAPL | Stock | 12.4979 | 12.5125 | 12.4979 | 12.5125 | 110488.0 |
| 2011-03-02 09:15:00 | AAPL | Stock | 12.5089 | 12.5089 | 12.5014 | 12.5014 | 82040.0 |
| 2011-03-02 09:20:00 | AAPL | Stock | 12.5011 | 12.5054 | 12.4996 | 12.4996 | 122836.0 |
| 2011-03-02 09:25:00 | AAPL | Stock | 12.4964 | 12.5107 | 12.4868 | 12.4993 | 424060.0 |
| 2011-03-02 09:30:00 | AAPL | Stock | 12.5046 | 12.5446 | 12.4504 | 12.4532 | 15374856.0 |
| 2011-03-02 09:35:00 | AAPL | Stock | 12.4539 | 12.5189 | 12.4486 | 12.505 | 11015816.0 |
| 2011-03-02 09:40:00 | AAPL | Stock | 12.5043 | 12.53 | 12.4911 | 12.4911 | 8692656.0 |
| 2011-03-02 09:45:00 | AAPL | Stock | 12.4894 | 12.5143 | 12.4746 | 12.5129 | 7038976.0 |
| 2011-03-02 09:50:00 | AAPL | Stock | 12.5111 | 12.5204 | 12.4964 | 12.5035 | 6202252.0 |
| 2011-03-02 09:55:00 | AAPL | Stock | 12.5036 | 12.5171 | 12.4825 | 12.5168 | 5712252.0 |
| 2011-03-02 10:00:00 | AAPL | Stock | 12.5171 | 12.5218 | 12.5 | 12.5087 | 4769296.0 |
| 2011-03-02 10:05:00 | AAPL | Stock | 12.5087 | 12.5321 | 12.4914 | 12.5009 | 6342700.0 |
| 2011-03-02 10:10:00 | AAPL | Stock | 12.4968 | 12.5007 | 12.4789 | 12.4921 | 5095160.0 |
| 2011-03-02 10:15:00 | AAPL | Stock | 12.4939 | 12.5164 | 12.4907 | 12.5061 | 4449760.0 |
| 2011-03-02 10:20:00 | AAPL | Stock | 12.5082 | 12.5089 | 12.4429 | 12.4543 | 9970856.0 |
> showing 50 of 334,219 rows — these rows as CSV