PREVIEW / stock_5min / 2005-03-29
file: by_date/stock_5min/2005/2005-03-29.parquet size: 2.7 MB rows: 197,540 symbols: 1,954
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 |
|---|---|---|---|---|---|---|---|
| 2005-03-29 08:00:00 | AAPL | Stock | 1.5125 | 1.5125 | 1.5107 | 1.5125 | 19600.0 |
| 2005-03-29 08:05:00 | AAPL | Stock | 1.5125 | 1.5125 | 1.5125 | 1.5125 | 22400.0 |
| 2005-03-29 08:10:00 | AAPL | Stock | 1.5125 | 1.5125 | 1.5125 | 1.5125 | 8400.0 |
| 2005-03-29 08:20:00 | AAPL | Stock | 1.5125 | 1.5125 | 1.5125 | 1.5125 | 4200.0 |
| 2005-03-29 08:25:00 | AAPL | Stock | 1.5157 | 1.5161 | 1.5157 | 1.5161 | 28000.0 |
| 2005-03-29 08:30:00 | AAPL | Stock | 1.5157 | 1.5157 | 1.5157 | 1.5157 | 28000.0 |
| 2005-03-29 08:35:00 | AAPL | Stock | 1.5157 | 1.5161 | 1.5157 | 1.5161 | 28000.0 |
| 2005-03-29 08:40:00 | AAPL | Stock | 1.5143 | 1.5143 | 1.5143 | 1.5143 | 10556.0 |
| 2005-03-29 08:45:00 | AAPL | Stock | 1.5143 | 1.515 | 1.5125 | 1.5129 | 29512.0 |
| 2005-03-29 08:55:00 | AAPL | Stock | 1.5179 | 1.5179 | 1.5164 | 1.5164 | 30800.0 |
| 2005-03-29 09:00:00 | AAPL | Stock | 1.5179 | 1.5189 | 1.5179 | 1.5189 | 49616.0 |
| 2005-03-29 09:10:00 | AAPL | Stock | 1.5189 | 1.5189 | 1.5189 | 1.5189 | 2800.0 |
| 2005-03-29 09:25:00 | AAPL | Stock | 1.5189 | 1.5204 | 1.5189 | 1.5204 | 90048.0 |
| 2005-03-29 09:30:00 | AAPL | Stock | 1.52 | 1.5232 | 1.5118 | 1.515 | 10807384.0 |
| 2005-03-29 09:35:00 | AAPL | Stock | 1.5154 | 1.5186 | 1.5093 | 1.5154 | 7793352.0 |
| 2005-03-29 09:40:00 | AAPL | Stock | 1.5154 | 1.5171 | 1.5118 | 1.5154 | 4940992.0 |
| 2005-03-29 09:45:00 | AAPL | Stock | 1.5157 | 1.5161 | 1.5114 | 1.5118 | 6159328.0 |
| 2005-03-29 09:50:00 | AAPL | Stock | 1.5114 | 1.515 | 1.5093 | 1.5096 | 8032416.0 |
| 2005-03-29 09:55:00 | AAPL | Stock | 1.5096 | 1.5121 | 1.5032 | 1.51 | 14866712.0 |
| 2005-03-29 10:00:00 | AAPL | Stock | 1.5104 | 1.5132 | 1.5079 | 1.5118 | 7773724.0 |
| 2005-03-29 10:05:00 | AAPL | Stock | 1.5118 | 1.5164 | 1.5111 | 1.5136 | 7264656.0 |
| 2005-03-29 10:10:00 | AAPL | Stock | 1.5132 | 1.5193 | 1.5132 | 1.5157 | 6905136.0 |
| 2005-03-29 10:15:00 | AAPL | Stock | 1.5161 | 1.5175 | 1.5146 | 1.5154 | 4087496.0 |
| 2005-03-29 10:20:00 | AAPL | Stock | 1.5154 | 1.5229 | 1.5129 | 1.5207 | 8120672.0 |
| 2005-03-29 10:25:00 | AAPL | Stock | 1.5207 | 1.5218 | 1.5154 | 1.5161 | 9763992.0 |
| 2005-03-29 10:30:00 | AAPL | Stock | 1.5161 | 1.5196 | 1.5161 | 1.5171 | 6648180.0 |
| 2005-03-29 10:35:00 | AAPL | Stock | 1.5171 | 1.5257 | 1.5171 | 1.5232 | 11529616.0 |
| 2005-03-29 10:40:00 | AAPL | Stock | 1.5236 | 1.5296 | 1.5229 | 1.5282 | 12391428.0 |
| 2005-03-29 10:45:00 | AAPL | Stock | 1.5282 | 1.5296 | 1.5271 | 1.5282 | 5457508.0 |
| 2005-03-29 10:50:00 | AAPL | Stock | 1.5282 | 1.5282 | 1.5221 | 1.5225 | 6139000.0 |
| 2005-03-29 10:55:00 | AAPL | Stock | 1.5229 | 1.5243 | 1.5207 | 1.5211 | 4017608.0 |
| 2005-03-29 11:00:00 | AAPL | Stock | 1.5211 | 1.5214 | 1.5182 | 1.5189 | 4372172.0 |
| 2005-03-29 11:05:00 | AAPL | Stock | 1.5189 | 1.5193 | 1.5173 | 1.5186 | 4352096.0 |
| 2005-03-29 11:10:00 | AAPL | Stock | 1.5189 | 1.5217 | 1.5175 | 1.5175 | 3404380.0 |
| 2005-03-29 11:15:00 | AAPL | Stock | 1.5178 | 1.52 | 1.5171 | 1.5193 | 3053008.0 |
| 2005-03-29 11:20:00 | AAPL | Stock | 1.5193 | 1.5196 | 1.5175 | 1.5189 | 1621620.0 |
| 2005-03-29 11:25:00 | AAPL | Stock | 1.5193 | 1.5193 | 1.5161 | 1.5182 | 3717812.0 |
| 2005-03-29 11:30:00 | AAPL | Stock | 1.5182 | 1.5193 | 1.5179 | 1.5182 | 1483272.0 |
| 2005-03-29 11:35:00 | AAPL | Stock | 1.5186 | 1.5211 | 1.5182 | 1.5207 | 2354548.0 |
| 2005-03-29 11:40:00 | AAPL | Stock | 1.52 | 1.5214 | 1.5193 | 1.5193 | 1728720.0 |
| 2005-03-29 11:45:00 | AAPL | Stock | 1.5193 | 1.5193 | 1.5171 | 1.5184 | 2160312.0 |
| 2005-03-29 11:50:00 | AAPL | Stock | 1.5184 | 1.5189 | 1.5157 | 1.5171 | 2612400.0 |
| 2005-03-29 11:55:00 | AAPL | Stock | 1.5168 | 1.5179 | 1.5157 | 1.5175 | 2671424.0 |
| 2005-03-29 12:00:00 | AAPL | Stock | 1.5175 | 1.5182 | 1.5145 | 1.515 | 2067772.0 |
| 2005-03-29 12:05:00 | AAPL | Stock | 1.5154 | 1.5168 | 1.5146 | 1.515 | 2046128.0 |
| 2005-03-29 12:10:00 | AAPL | Stock | 1.515 | 1.515 | 1.5136 | 1.5143 | 1989204.0 |
| 2005-03-29 12:15:00 | AAPL | Stock | 1.5143 | 1.5143 | 1.5089 | 1.5089 | 4628540.0 |
| 2005-03-29 12:20:00 | AAPL | Stock | 1.5104 | 1.5104 | 1.5057 | 1.5093 | 7586068.0 |
| 2005-03-29 12:25:00 | AAPL | Stock | 1.5093 | 1.51 | 1.5079 | 1.5093 | 2251088.0 |
| 2005-03-29 12:30:00 | AAPL | Stock | 1.5096 | 1.5096 | 1.505 | 1.5082 | 4006912.0 |
> showing 50 of 197,540 rows — these rows as CSV