PREVIEW / stock_5min / 2005-03-23
file: by_date/stock_5min/2005/2005-03-23.parquet size: 2.7 MB rows: 198,872 symbols: 1,960
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-23 08:00:00 | AAPL | Stock | 1.5243 | 1.5243 | 1.4982 | 1.5036 | 243320.0 |
| 2005-03-23 08:05:00 | AAPL | Stock | 1.5054 | 1.5179 | 1.5036 | 1.5175 | 500808.0 |
| 2005-03-23 08:10:00 | AAPL | Stock | 1.5179 | 1.5214 | 1.5129 | 1.5179 | 203812.0 |
| 2005-03-23 08:15:00 | AAPL | Stock | 1.5168 | 1.5196 | 1.5139 | 1.5196 | 132104.0 |
| 2005-03-23 08:25:00 | AAPL | Stock | 1.5168 | 1.5171 | 1.5164 | 1.5171 | 28000.0 |
| 2005-03-23 08:30:00 | AAPL | Stock | 1.5171 | 1.5171 | 1.5039 | 1.5054 | 699048.0 |
| 2005-03-23 08:35:00 | AAPL | Stock | 1.5093 | 1.5125 | 1.5061 | 1.5125 | 218400.0 |
| 2005-03-23 08:40:00 | AAPL | Stock | 1.5121 | 1.515 | 1.5107 | 1.5107 | 266896.0 |
| 2005-03-23 08:45:00 | AAPL | Stock | 1.5118 | 1.5143 | 1.5096 | 1.5096 | 312788.0 |
| 2005-03-23 08:50:00 | AAPL | Stock | 1.51 | 1.5171 | 1.5093 | 1.5161 | 665812.0 |
| 2005-03-23 08:55:00 | AAPL | Stock | 1.5146 | 1.5168 | 1.5136 | 1.5143 | 316904.0 |
| 2005-03-23 09:00:00 | AAPL | Stock | 1.5154 | 1.5157 | 1.5118 | 1.5118 | 184800.0 |
| 2005-03-23 09:05:00 | AAPL | Stock | 1.5146 | 1.515 | 1.5125 | 1.5139 | 215320.0 |
| 2005-03-23 09:10:00 | AAPL | Stock | 1.5129 | 1.5154 | 1.5121 | 1.5154 | 188748.0 |
| 2005-03-23 09:15:00 | AAPL | Stock | 1.5154 | 1.5168 | 1.5154 | 1.5157 | 531860.0 |
| 2005-03-23 09:20:00 | AAPL | Stock | 1.5164 | 1.5168 | 1.5164 | 1.5168 | 44800.0 |
| 2005-03-23 09:25:00 | AAPL | Stock | 1.5211 | 1.5239 | 1.5161 | 1.5168 | 1072904.0 |
| 2005-03-23 09:30:00 | AAPL | Stock | 1.5161 | 1.5204 | 1.5064 | 1.5118 | 23540328.0 |
| 2005-03-23 09:35:00 | AAPL | Stock | 1.5118 | 1.5143 | 1.5007 | 1.5093 | 26391344.0 |
| 2005-03-23 09:40:00 | AAPL | Stock | 1.5096 | 1.5143 | 1.5071 | 1.5107 | 12322240.0 |
| 2005-03-23 09:45:00 | AAPL | Stock | 1.5111 | 1.5139 | 1.5021 | 1.5036 | 16222024.0 |
| 2005-03-23 09:50:00 | AAPL | Stock | 1.5039 | 1.5121 | 1.5032 | 1.5114 | 14094220.0 |
| 2005-03-23 09:55:00 | AAPL | Stock | 1.5111 | 1.5161 | 1.5071 | 1.5086 | 13613544.0 |
| 2005-03-23 10:00:00 | AAPL | Stock | 1.5089 | 1.5214 | 1.5068 | 1.5168 | 16672796.0 |
| 2005-03-23 10:05:00 | AAPL | Stock | 1.5168 | 1.5268 | 1.5154 | 1.5236 | 11887456.0 |
| 2005-03-23 10:10:00 | AAPL | Stock | 1.5243 | 1.5268 | 1.5189 | 1.5221 | 11252584.0 |
| 2005-03-23 10:15:00 | AAPL | Stock | 1.5218 | 1.5264 | 1.5182 | 1.5246 | 8162868.0 |
| 2005-03-23 10:20:00 | AAPL | Stock | 1.525 | 1.5254 | 1.52 | 1.5204 | 10229072.0 |
| 2005-03-23 10:25:00 | AAPL | Stock | 1.5214 | 1.5242 | 1.5146 | 1.5232 | 11237240.0 |
| 2005-03-23 10:30:00 | AAPL | Stock | 1.5232 | 1.5268 | 1.5193 | 1.5221 | 11073048.0 |
| 2005-03-23 10:35:00 | AAPL | Stock | 1.5221 | 1.5236 | 1.5189 | 1.5207 | 5789812.0 |
| 2005-03-23 10:40:00 | AAPL | Stock | 1.5208 | 1.525 | 1.5179 | 1.5243 | 6305264.0 |
| 2005-03-23 10:45:00 | AAPL | Stock | 1.5239 | 1.5243 | 1.5204 | 1.5232 | 4925620.0 |
| 2005-03-23 10:50:00 | AAPL | Stock | 1.5232 | 1.5293 | 1.5182 | 1.5293 | 7263872.0 |
| 2005-03-23 10:55:00 | AAPL | Stock | 1.5293 | 1.5375 | 1.525 | 1.5375 | 17209836.0 |
| 2005-03-23 11:00:00 | AAPL | Stock | 1.5375 | 1.5382 | 1.5325 | 1.5343 | 9416232.0 |
| 2005-03-23 11:05:00 | AAPL | Stock | 1.5346 | 1.5404 | 1.5346 | 1.54 | 11195772.0 |
| 2005-03-23 11:10:00 | AAPL | Stock | 1.5396 | 1.55 | 1.5396 | 1.5446 | 20862352.0 |
| 2005-03-23 11:15:00 | AAPL | Stock | 1.5446 | 1.5479 | 1.5446 | 1.5454 | 9282504.0 |
| 2005-03-23 11:20:00 | AAPL | Stock | 1.545 | 1.5464 | 1.5375 | 1.5396 | 8372084.0 |
| 2005-03-23 11:25:00 | AAPL | Stock | 1.5393 | 1.5429 | 1.5393 | 1.5411 | 5480860.0 |
| 2005-03-23 11:30:00 | AAPL | Stock | 1.5411 | 1.5414 | 1.5364 | 1.5375 | 6927200.0 |
| 2005-03-23 11:35:00 | AAPL | Stock | 1.5379 | 1.5389 | 1.5332 | 1.5336 | 8213716.0 |
| 2005-03-23 11:40:00 | AAPL | Stock | 1.5339 | 1.5343 | 1.5304 | 1.5325 | 8761536.0 |
| 2005-03-23 11:45:00 | AAPL | Stock | 1.5329 | 1.5361 | 1.5325 | 1.5357 | 4818856.0 |
| 2005-03-23 11:50:00 | AAPL | Stock | 1.5357 | 1.5357 | 1.5261 | 1.5282 | 9322320.0 |
| 2005-03-23 11:55:00 | AAPL | Stock | 1.5282 | 1.5314 | 1.5257 | 1.5286 | 6450808.0 |
| 2005-03-23 12:00:00 | AAPL | Stock | 1.5282 | 1.5332 | 1.5282 | 1.53 | 4841648.0 |
| 2005-03-23 12:05:00 | AAPL | Stock | 1.53 | 1.5357 | 1.5296 | 1.5357 | 7172900.0 |
| 2005-03-23 12:10:00 | AAPL | Stock | 1.5354 | 1.5429 | 1.5354 | 1.5404 | 8980020.0 |
> showing 50 of 198,872 rows — these rows as CSV