PREVIEW / stock_5min / 2005-04-12
file: by_date/stock_5min/2005/2005-04-12.parquet size: 2.7 MB rows: 194,859 symbols: 1,955
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-04-12 07:45:00 | AAPL | Stock | 1.5157 | 1.5157 | 1.5143 | 1.5143 | 5600.0 |
| 2005-04-12 07:50:00 | AAPL | Stock | 1.5086 | 1.5086 | 1.5057 | 1.5086 | 142800.0 |
| 2005-04-12 07:55:00 | AAPL | Stock | 1.5086 | 1.5086 | 1.5086 | 1.5086 | 8400.0 |
| 2005-04-12 08:00:00 | AAPL | Stock | 1.5071 | 1.5143 | 1.5071 | 1.5132 | 656320.0 |
| 2005-04-12 08:05:00 | AAPL | Stock | 1.5132 | 1.515 | 1.5114 | 1.515 | 1388240.0 |
| 2005-04-12 08:10:00 | AAPL | Stock | 1.5154 | 1.5168 | 1.5143 | 1.5161 | 804076.0 |
| 2005-04-12 08:15:00 | AAPL | Stock | 1.5161 | 1.5175 | 1.5129 | 1.5171 | 433076.0 |
| 2005-04-12 08:20:00 | AAPL | Stock | 1.5171 | 1.5207 | 1.515 | 1.5175 | 1549240.0 |
| 2005-04-12 08:25:00 | AAPL | Stock | 1.5179 | 1.5204 | 1.5143 | 1.5186 | 398860.0 |
| 2005-04-12 08:30:00 | AAPL | Stock | 1.5189 | 1.5207 | 1.5157 | 1.5189 | 726964.0 |
| 2005-04-12 08:35:00 | AAPL | Stock | 1.5193 | 1.5214 | 1.5132 | 1.5132 | 505036.0 |
| 2005-04-12 08:40:00 | AAPL | Stock | 1.5139 | 1.5161 | 1.5107 | 1.5146 | 1190140.0 |
| 2005-04-12 08:45:00 | AAPL | Stock | 1.5161 | 1.5179 | 1.5161 | 1.5168 | 160076.0 |
| 2005-04-12 08:50:00 | AAPL | Stock | 1.5168 | 1.5214 | 1.5168 | 1.5196 | 693532.0 |
| 2005-04-12 08:55:00 | AAPL | Stock | 1.5211 | 1.5211 | 1.5164 | 1.5175 | 275520.0 |
| 2005-04-12 09:00:00 | AAPL | Stock | 1.5175 | 1.5179 | 1.5161 | 1.5161 | 295148.0 |
| 2005-04-12 09:05:00 | AAPL | Stock | 1.5161 | 1.5161 | 1.5118 | 1.5154 | 590324.0 |
| 2005-04-12 09:10:00 | AAPL | Stock | 1.5154 | 1.5154 | 1.5114 | 1.5121 | 657468.0 |
| 2005-04-12 09:15:00 | AAPL | Stock | 1.5132 | 1.5143 | 1.5129 | 1.5136 | 170800.0 |
| 2005-04-12 09:20:00 | AAPL | Stock | 1.5136 | 1.5139 | 1.5107 | 1.5114 | 147448.0 |
| 2005-04-12 09:25:00 | AAPL | Stock | 1.5118 | 1.52 | 1.5096 | 1.5179 | 4401404.0 |
| 2005-04-12 09:30:00 | AAPL | Stock | 1.5175 | 1.5293 | 1.5125 | 1.5286 | 37051112.0 |
| 2005-04-12 09:35:00 | AAPL | Stock | 1.5236 | 1.5286 | 1.515 | 1.5179 | 23912028.0 |
| 2005-04-12 09:40:00 | AAPL | Stock | 1.5179 | 1.5207 | 1.515 | 1.5207 | 17494512.0 |
| 2005-04-12 09:45:00 | AAPL | Stock | 1.5207 | 1.5307 | 1.5189 | 1.5293 | 26726784.0 |
| 2005-04-12 09:50:00 | AAPL | Stock | 1.5289 | 1.5343 | 1.5218 | 1.5257 | 31571792.0 |
| 2005-04-12 09:55:00 | AAPL | Stock | 1.5257 | 1.5325 | 1.5257 | 1.53 | 16812712.0 |
| 2005-04-12 10:00:00 | AAPL | Stock | 1.53 | 1.5321 | 1.5279 | 1.5311 | 14524048.0 |
| 2005-04-12 10:05:00 | AAPL | Stock | 1.5314 | 1.5314 | 1.5279 | 1.5296 | 13511008.0 |
| 2005-04-12 10:10:00 | AAPL | Stock | 1.5293 | 1.5307 | 1.5268 | 1.5282 | 8560524.0 |
| 2005-04-12 10:15:00 | AAPL | Stock | 1.5279 | 1.5375 | 1.5275 | 1.5368 | 20271160.0 |
| 2005-04-12 10:20:00 | AAPL | Stock | 1.5364 | 1.5371 | 1.5286 | 1.5336 | 15476020.0 |
| 2005-04-12 10:25:00 | AAPL | Stock | 1.5336 | 1.5343 | 1.5293 | 1.5325 | 12804848.0 |
| 2005-04-12 10:30:00 | AAPL | Stock | 1.5321 | 1.5343 | 1.5296 | 1.5321 | 11943596.0 |
| 2005-04-12 10:35:00 | AAPL | Stock | 1.5332 | 1.5393 | 1.5314 | 1.5368 | 16388176.0 |
| 2005-04-12 10:40:00 | AAPL | Stock | 1.5368 | 1.5379 | 1.5343 | 1.5361 | 12708052.0 |
| 2005-04-12 10:45:00 | AAPL | Stock | 1.5361 | 1.5425 | 1.535 | 1.5364 | 19734904.0 |
| 2005-04-12 10:50:00 | AAPL | Stock | 1.5371 | 1.5396 | 1.5354 | 1.5361 | 15473892.0 |
| 2005-04-12 10:55:00 | AAPL | Stock | 1.5361 | 1.5368 | 1.5325 | 1.5364 | 10054744.0 |
| 2005-04-12 11:00:00 | AAPL | Stock | 1.5364 | 1.5364 | 1.5332 | 1.5354 | 6230952.0 |
| 2005-04-12 11:05:00 | AAPL | Stock | 1.5354 | 1.5357 | 1.5332 | 1.5336 | 4065124.0 |
| 2005-04-12 11:10:00 | AAPL | Stock | 1.5332 | 1.5336 | 1.5279 | 1.5318 | 12604788.0 |
| 2005-04-12 11:15:00 | AAPL | Stock | 1.5318 | 1.5329 | 1.5293 | 1.5304 | 8182300.0 |
| 2005-04-12 11:20:00 | AAPL | Stock | 1.5304 | 1.5304 | 1.5232 | 1.5243 | 13148380.0 |
| 2005-04-12 11:25:00 | AAPL | Stock | 1.5239 | 1.5277 | 1.5161 | 1.5175 | 23630768.0 |
| 2005-04-12 11:30:00 | AAPL | Stock | 1.5179 | 1.5218 | 1.5136 | 1.5157 | 17930080.0 |
| 2005-04-12 11:35:00 | AAPL | Stock | 1.5161 | 1.5214 | 1.5157 | 1.5204 | 11368980.0 |
| 2005-04-12 11:40:00 | AAPL | Stock | 1.5204 | 1.5218 | 1.5182 | 1.5189 | 6076448.0 |
| 2005-04-12 11:45:00 | AAPL | Stock | 1.5189 | 1.5214 | 1.5186 | 1.5196 | 7573356.0 |
| 2005-04-12 11:50:00 | AAPL | Stock | 1.52 | 1.5232 | 1.5197 | 1.5204 | 10356500.0 |
> showing 50 of 194,859 rows — these rows as CSV