PREVIEW / stock_5min / 2010-08-25
file: by_date/stock_5min/2010/2010-08-25.parquet size: 4.8 MB rows: 326,515 symbols: 3,469
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 |
|---|---|---|---|---|---|---|---|
| 2010-08-25 04:45:00 | AAPL | Stock | 8.6171 | 8.6207 | 8.5893 | 8.6207 | 14000.0 |
| 2010-08-25 04:50:00 | AAPL | Stock | 8.6296 | 8.6296 | 8.6296 | 8.6296 | 7000.0 |
| 2010-08-25 05:05:00 | AAPL | Stock | 8.6071 | 8.6071 | 8.6071 | 8.6071 | 2800.0 |
| 2010-08-25 05:10:00 | AAPL | Stock | 8.5975 | 8.5975 | 8.5975 | 8.5975 | 2800.0 |
| 2010-08-25 05:30:00 | AAPL | Stock | 8.585 | 8.585 | 8.585 | 8.585 | 2800.0 |
| 2010-08-25 07:00:00 | AAPL | Stock | 8.5343 | 8.5375 | 8.5343 | 8.5375 | 10220.0 |
| 2010-08-25 07:05:00 | AAPL | Stock | 8.5571 | 8.5607 | 8.5571 | 8.5607 | 32676.0 |
| 2010-08-25 07:10:00 | AAPL | Stock | 8.5714 | 8.5764 | 8.5582 | 8.5679 | 34972.0 |
| 2010-08-25 07:15:00 | AAPL | Stock | 8.5696 | 8.5696 | 8.5696 | 8.5696 | 16800.0 |
| 2010-08-25 07:25:00 | AAPL | Stock | 8.5632 | 8.5632 | 8.5632 | 8.5632 | 2800.0 |
| 2010-08-25 07:30:00 | AAPL | Stock | 8.5639 | 8.5639 | 8.5571 | 8.5571 | 70000.0 |
| 2010-08-25 07:35:00 | AAPL | Stock | 8.5532 | 8.5532 | 8.5532 | 8.5532 | 5600.0 |
| 2010-08-25 07:40:00 | AAPL | Stock | 8.5539 | 8.5539 | 8.5539 | 8.5539 | 5600.0 |
| 2010-08-25 07:45:00 | AAPL | Stock | 8.5614 | 8.5614 | 8.5546 | 8.5546 | 8400.0 |
| 2010-08-25 07:50:00 | AAPL | Stock | 8.5539 | 8.5539 | 8.5539 | 8.5539 | 2800.0 |
| 2010-08-25 07:55:00 | AAPL | Stock | 8.5539 | 8.5539 | 8.5536 | 8.5536 | 25200.0 |
| 2010-08-25 08:00:00 | AAPL | Stock | 8.5546 | 8.5546 | 8.5379 | 8.5429 | 170100.0 |
| 2010-08-25 08:05:00 | AAPL | Stock | 8.5429 | 8.5436 | 8.5389 | 8.5389 | 178052.0 |
| 2010-08-25 08:10:00 | AAPL | Stock | 8.54 | 8.54 | 8.5314 | 8.5357 | 286188.0 |
| 2010-08-25 08:15:00 | AAPL | Stock | 8.5393 | 8.5429 | 8.5371 | 8.5421 | 66220.0 |
| 2010-08-25 08:20:00 | AAPL | Stock | 8.5446 | 8.5511 | 8.5443 | 8.5493 | 76720.0 |
| 2010-08-25 08:25:00 | AAPL | Stock | 8.5461 | 8.5479 | 8.5404 | 8.5454 | 56112.0 |
| 2010-08-25 08:30:00 | AAPL | Stock | 8.5457 | 8.5536 | 8.5061 | 8.5061 | 998676.0 |
| 2010-08-25 08:35:00 | AAPL | Stock | 8.5093 | 8.5171 | 8.505 | 8.5114 | 355320.0 |
| 2010-08-25 08:40:00 | AAPL | Stock | 8.5139 | 8.5179 | 8.5004 | 8.5029 | 285208.0 |
| 2010-08-25 08:45:00 | AAPL | Stock | 8.5032 | 8.5161 | 8.5 | 8.5021 | 268408.0 |
| 2010-08-25 08:50:00 | AAPL | Stock | 8.5036 | 8.5107 | 8.5036 | 8.5107 | 62720.0 |
| 2010-08-25 08:55:00 | AAPL | Stock | 8.5071 | 8.5089 | 8.5018 | 8.5018 | 210532.0 |
| 2010-08-25 09:00:00 | AAPL | Stock | 8.5025 | 8.5079 | 8.5004 | 8.5036 | 209524.0 |
| 2010-08-25 09:05:00 | AAPL | Stock | 8.5018 | 8.5064 | 8.4968 | 8.5004 | 317576.0 |
| 2010-08-25 09:10:00 | AAPL | Stock | 8.5004 | 8.5071 | 8.5 | 8.5036 | 435596.0 |
| 2010-08-25 09:15:00 | AAPL | Stock | 8.5054 | 8.5125 | 8.5039 | 8.5071 | 303828.0 |
| 2010-08-25 09:20:00 | AAPL | Stock | 8.5086 | 8.5125 | 8.5071 | 8.5125 | 129500.0 |
| 2010-08-25 09:25:00 | AAPL | Stock | 8.5143 | 8.5171 | 8.5029 | 8.5029 | 729344.0 |
| 2010-08-25 09:30:00 | AAPL | Stock | 8.5014 | 8.5536 | 8.4839 | 8.5496 | 26774552.0 |
| 2010-08-25 09:35:00 | AAPL | Stock | 8.5493 | 8.5661 | 8.5307 | 8.564 | 17995292.0 |
| 2010-08-25 09:40:00 | AAPL | Stock | 8.5646 | 8.5796 | 8.5346 | 8.5411 | 18229988.0 |
| 2010-08-25 09:45:00 | AAPL | Stock | 8.5416 | 8.5479 | 8.5321 | 8.535 | 9181956.0 |
| 2010-08-25 09:50:00 | AAPL | Stock | 8.5353 | 8.5407 | 8.5 | 8.507 | 13253800.0 |
| 2010-08-25 09:55:00 | AAPL | Stock | 8.5071 | 8.5171 | 8.49 | 8.5161 | 12727568.0 |
| 2010-08-25 10:00:00 | AAPL | Stock | 8.5161 | 8.5354 | 8.4789 | 8.5261 | 19862472.0 |
| 2010-08-25 10:05:00 | AAPL | Stock | 8.5261 | 8.5454 | 8.5204 | 8.5375 | 13209028.0 |
| 2010-08-25 10:10:00 | AAPL | Stock | 8.5386 | 8.5396 | 8.5054 | 8.5157 | 8416660.0 |
| 2010-08-25 10:15:00 | AAPL | Stock | 8.5164 | 8.5296 | 8.4936 | 8.5068 | 10320072.0 |
| 2010-08-25 10:20:00 | AAPL | Stock | 8.5075 | 8.5179 | 8.4971 | 8.5125 | 6428324.0 |
| 2010-08-25 10:25:00 | AAPL | Stock | 8.5136 | 8.5268 | 8.5093 | 8.5179 | 6415220.0 |
| 2010-08-25 10:30:00 | AAPL | Stock | 8.5175 | 8.5229 | 8.4893 | 8.4929 | 11665444.0 |
| 2010-08-25 10:35:00 | AAPL | Stock | 8.4929 | 8.5 | 8.4714 | 8.49 | 12443704.0 |
| 2010-08-25 10:40:00 | AAPL | Stock | 8.4897 | 8.515 | 8.4843 | 8.5139 | 9047612.0 |
| 2010-08-25 10:45:00 | AAPL | Stock | 8.5139 | 8.5207 | 8.5079 | 8.5186 | 5365976.0 |
> showing 50 of 326,515 rows — these rows as CSV