PREVIEW / stock_5min / 2009-09-17
file: by_date/stock_5min/2009/2009-09-17.parquet size: 4.8 MB rows: 321,940 symbols: 3,384
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 |
|---|---|---|---|---|---|---|---|
| 2009-09-17 07:00:00 | AAPL | Stock | 6.4968 | 6.4968 | 6.4968 | 6.4968 | 8400.0 |
| 2009-09-17 07:05:00 | AAPL | Stock | 6.5 | 6.5 | 6.5 | 6.5 | 2800.0 |
| 2009-09-17 07:15:00 | AAPL | Stock | 6.4911 | 6.4911 | 6.4911 | 6.4911 | 8400.0 |
| 2009-09-17 07:25:00 | AAPL | Stock | 6.4893 | 6.4893 | 6.4893 | 6.4893 | 5600.0 |
| 2009-09-17 07:35:00 | AAPL | Stock | 6.5089 | 6.51 | 6.5068 | 6.5068 | 11200.0 |
| 2009-09-17 07:40:00 | AAPL | Stock | 6.5004 | 6.5004 | 6.5 | 6.5 | 32732.0 |
| 2009-09-17 07:45:00 | AAPL | Stock | 6.5046 | 6.5046 | 6.5046 | 6.5046 | 2800.0 |
| 2009-09-17 07:50:00 | AAPL | Stock | 6.4936 | 6.4936 | 6.4936 | 6.4936 | 4900.0 |
| 2009-09-17 07:55:00 | AAPL | Stock | 6.4936 | 6.4982 | 6.4936 | 6.4982 | 5600.0 |
| 2009-09-17 08:00:00 | AAPL | Stock | 6.5 | 6.5039 | 6.4954 | 6.4964 | 124684.0 |
| 2009-09-17 08:05:00 | AAPL | Stock | 6.4964 | 6.5221 | 6.4964 | 6.5161 | 786548.0 |
| 2009-09-17 08:10:00 | AAPL | Stock | 6.5143 | 6.5196 | 6.5143 | 6.515 | 149128.0 |
| 2009-09-17 08:15:00 | AAPL | Stock | 6.5161 | 6.5193 | 6.5143 | 6.5189 | 153580.0 |
| 2009-09-17 08:20:00 | AAPL | Stock | 6.5179 | 6.5186 | 6.5146 | 6.5161 | 108780.0 |
| 2009-09-17 08:25:00 | AAPL | Stock | 6.5161 | 6.5261 | 6.5161 | 6.5261 | 187628.0 |
| 2009-09-17 08:30:00 | AAPL | Stock | 6.525 | 6.5321 | 6.5082 | 6.515 | 772828.0 |
| 2009-09-17 08:35:00 | AAPL | Stock | 6.5107 | 6.5111 | 6.5021 | 6.5111 | 353556.0 |
| 2009-09-17 08:40:00 | AAPL | Stock | 6.5114 | 6.5114 | 6.5025 | 6.5057 | 229600.0 |
| 2009-09-17 08:45:00 | AAPL | Stock | 6.5043 | 6.5075 | 6.5036 | 6.5039 | 111076.0 |
| 2009-09-17 08:50:00 | AAPL | Stock | 6.5057 | 6.5082 | 6.4968 | 6.4979 | 212576.0 |
| 2009-09-17 08:55:00 | AAPL | Stock | 6.4986 | 6.5011 | 6.4921 | 6.4921 | 139356.0 |
| 2009-09-17 09:00:00 | AAPL | Stock | 6.4943 | 6.5071 | 6.4943 | 6.5036 | 148428.0 |
| 2009-09-17 09:05:00 | AAPL | Stock | 6.5036 | 6.5054 | 6.5004 | 6.5021 | 71456.0 |
| 2009-09-17 09:10:00 | AAPL | Stock | 6.5004 | 6.5036 | 6.4957 | 6.5036 | 233800.0 |
| 2009-09-17 09:15:00 | AAPL | Stock | 6.5004 | 6.5043 | 6.4968 | 6.4968 | 64848.0 |
| 2009-09-17 09:20:00 | AAPL | Stock | 6.4936 | 6.4975 | 6.4932 | 6.4936 | 102088.0 |
| 2009-09-17 09:25:00 | AAPL | Stock | 6.4961 | 6.5014 | 6.4961 | 6.5 | 89824.0 |
| 2009-09-17 09:30:00 | AAPL | Stock | 6.4986 | 6.5311 | 6.4986 | 6.5186 | 23796780.0 |
| 2009-09-17 09:35:00 | AAPL | Stock | 6.5186 | 6.545 | 6.5182 | 6.5443 | 17111332.0 |
| 2009-09-17 09:40:00 | AAPL | Stock | 6.545 | 6.545 | 6.5129 | 6.5268 | 22203972.0 |
| 2009-09-17 09:45:00 | AAPL | Stock | 6.5264 | 6.5532 | 6.5143 | 6.5484 | 15299536.0 |
| 2009-09-17 09:50:00 | AAPL | Stock | 6.5479 | 6.5775 | 6.5472 | 6.5771 | 16371852.0 |
| 2009-09-17 09:55:00 | AAPL | Stock | 6.5771 | 6.5786 | 6.5636 | 6.5671 | 18948552.0 |
| 2009-09-17 10:00:00 | AAPL | Stock | 6.5679 | 6.5789 | 6.5536 | 6.5639 | 20513892.0 |
| 2009-09-17 10:05:00 | AAPL | Stock | 6.5636 | 6.605 | 6.56 | 6.5996 | 19693128.0 |
| 2009-09-17 10:10:00 | AAPL | Stock | 6.6018 | 6.605 | 6.5861 | 6.5875 | 14415520.0 |
| 2009-09-17 10:15:00 | AAPL | Stock | 6.5875 | 6.5968 | 6.5714 | 6.5804 | 15271536.0 |
| 2009-09-17 10:20:00 | AAPL | Stock | 6.581 | 6.5868 | 6.575 | 6.5761 | 10896620.0 |
| 2009-09-17 10:25:00 | AAPL | Stock | 6.5771 | 6.5782 | 6.5714 | 6.5775 | 11049556.0 |
| 2009-09-17 10:30:00 | AAPL | Stock | 6.5779 | 6.5882 | 6.5771 | 6.5871 | 7654192.0 |
| 2009-09-17 10:35:00 | AAPL | Stock | 6.5879 | 6.6036 | 6.5879 | 6.6019 | 12024908.0 |
| 2009-09-17 10:40:00 | AAPL | Stock | 6.6018 | 6.6107 | 6.5882 | 6.5911 | 17228596.0 |
| 2009-09-17 10:45:00 | AAPL | Stock | 6.5918 | 6.6039 | 6.5868 | 6.6021 | 7492464.0 |
| 2009-09-17 10:50:00 | AAPL | Stock | 6.6016 | 6.6239 | 6.6011 | 6.6186 | 14083216.0 |
| 2009-09-17 10:55:00 | AAPL | Stock | 6.6182 | 6.6196 | 6.6082 | 6.6111 | 7623672.0 |
| 2009-09-17 11:00:00 | AAPL | Stock | 6.6128 | 6.6279 | 6.61 | 6.6157 | 10786160.0 |
| 2009-09-17 11:05:00 | AAPL | Stock | 6.6157 | 6.6246 | 6.6157 | 6.6234 | 8429680.0 |
| 2009-09-17 11:10:00 | AAPL | Stock | 6.6232 | 6.6332 | 6.6214 | 6.6265 | 12098856.0 |
| 2009-09-17 11:15:00 | AAPL | Stock | 6.6264 | 6.6368 | 6.6239 | 6.6321 | 11705848.0 |
| 2009-09-17 11:20:00 | AAPL | Stock | 6.6325 | 6.6421 | 6.6314 | 6.6364 | 10887212.0 |
> showing 50 of 321,940 rows — these rows as CSV