PREVIEW / stock_5min / 2006-04-28
file: by_date/stock_5min/2006/2006-04-28.parquet size: 3.1 MB rows: 222,356 symbols: 2,243
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 |
|---|---|---|---|---|---|---|---|
| 2006-04-28 07:20:00 | AAPL | Stock | 2.4654 | 2.4654 | 2.4654 | 2.4654 | 14000.0 |
| 2006-04-28 08:00:00 | AAPL | Stock | 2.4643 | 2.4689 | 2.4193 | 2.465 | 454440.0 |
| 2006-04-28 08:05:00 | AAPL | Stock | 2.4643 | 2.4661 | 2.4571 | 2.4611 | 64120.0 |
| 2006-04-28 08:10:00 | AAPL | Stock | 2.4571 | 2.4571 | 2.4571 | 2.4571 | 5600.0 |
| 2006-04-28 08:15:00 | AAPL | Stock | 2.4604 | 2.4604 | 2.4529 | 2.4529 | 190260.0 |
| 2006-04-28 08:20:00 | AAPL | Stock | 2.4554 | 2.4554 | 2.4536 | 2.4543 | 56700.0 |
| 2006-04-28 08:25:00 | AAPL | Stock | 2.4543 | 2.4607 | 2.4543 | 2.4589 | 103880.0 |
| 2006-04-28 08:30:00 | AAPL | Stock | 2.46 | 2.4643 | 2.46 | 2.4643 | 236880.0 |
| 2006-04-28 08:35:00 | AAPL | Stock | 2.4661 | 2.4714 | 2.4661 | 2.4707 | 968156.0 |
| 2006-04-28 08:40:00 | AAPL | Stock | 2.4707 | 2.4707 | 2.4671 | 2.47 | 79800.0 |
| 2006-04-28 08:45:00 | AAPL | Stock | 2.4682 | 2.4704 | 2.4682 | 2.4704 | 89320.0 |
| 2006-04-28 08:50:00 | AAPL | Stock | 2.4704 | 2.4711 | 2.4686 | 2.4707 | 120400.0 |
| 2006-04-28 08:55:00 | AAPL | Stock | 2.4707 | 2.4707 | 2.4686 | 2.4689 | 187600.0 |
| 2006-04-28 09:00:00 | AAPL | Stock | 2.4696 | 2.4704 | 2.4668 | 2.4679 | 151620.0 |
| 2006-04-28 09:05:00 | AAPL | Stock | 2.4686 | 2.4686 | 2.4571 | 2.4679 | 269724.0 |
| 2006-04-28 09:10:00 | AAPL | Stock | 2.4671 | 2.4693 | 2.4664 | 2.4679 | 148260.0 |
| 2006-04-28 09:15:00 | AAPL | Stock | 2.4693 | 2.4707 | 2.4661 | 2.4661 | 75768.0 |
| 2006-04-28 09:20:00 | AAPL | Stock | 2.4679 | 2.4696 | 2.4679 | 2.4696 | 357000.0 |
| 2006-04-28 09:25:00 | AAPL | Stock | 2.4696 | 2.4779 | 2.4696 | 2.4775 | 846216.0 |
| 2006-04-28 09:30:00 | AAPL | Stock | 2.4777 | 2.4896 | 2.4714 | 2.4732 | 22175832.0 |
| 2006-04-28 09:35:00 | AAPL | Stock | 2.4732 | 2.4993 | 2.4718 | 2.495 | 24957128.0 |
| 2006-04-28 09:40:00 | AAPL | Stock | 2.495 | 2.5054 | 2.4914 | 2.5043 | 29405600.0 |
| 2006-04-28 09:45:00 | AAPL | Stock | 2.5043 | 2.5171 | 2.5036 | 2.5125 | 27957468.0 |
| 2006-04-28 09:50:00 | AAPL | Stock | 2.5126 | 2.5157 | 2.505 | 2.5132 | 15744596.0 |
| 2006-04-28 09:55:00 | AAPL | Stock | 2.5132 | 2.5139 | 2.5 | 2.5082 | 12121592.0 |
| 2006-04-28 10:00:00 | AAPL | Stock | 2.5086 | 2.52 | 2.5079 | 2.5175 | 16774128.0 |
| 2006-04-28 10:05:00 | AAPL | Stock | 2.5171 | 2.5321 | 2.5161 | 2.5279 | 18713184.0 |
| 2006-04-28 10:10:00 | AAPL | Stock | 2.5279 | 2.5357 | 2.5254 | 2.5343 | 19658492.0 |
| 2006-04-28 10:15:00 | AAPL | Stock | 2.5346 | 2.5389 | 2.53 | 2.5382 | 26107284.0 |
| 2006-04-28 10:20:00 | AAPL | Stock | 2.5382 | 2.5461 | 2.5354 | 2.5439 | 23398004.0 |
| 2006-04-28 10:25:00 | AAPL | Stock | 2.5439 | 2.5464 | 2.5379 | 2.5421 | 17201184.0 |
| 2006-04-28 10:30:00 | AAPL | Stock | 2.5421 | 2.5436 | 2.5307 | 2.5322 | 17980844.0 |
| 2006-04-28 10:35:00 | AAPL | Stock | 2.5321 | 2.5336 | 2.5286 | 2.5328 | 13621804.0 |
| 2006-04-28 10:40:00 | AAPL | Stock | 2.5325 | 2.5414 | 2.5275 | 2.5293 | 11636940.0 |
| 2006-04-28 10:45:00 | AAPL | Stock | 2.5289 | 2.5371 | 2.5275 | 2.5361 | 10176572.0 |
| 2006-04-28 10:50:00 | AAPL | Stock | 2.5361 | 2.5382 | 2.5311 | 2.5321 | 11656652.0 |
| 2006-04-28 10:55:00 | AAPL | Stock | 2.5321 | 2.535 | 2.5318 | 2.5346 | 6339284.0 |
| 2006-04-28 11:00:00 | AAPL | Stock | 2.5346 | 2.535 | 2.53 | 2.53 | 9011352.0 |
| 2006-04-28 11:05:00 | AAPL | Stock | 2.53 | 2.5332 | 2.5279 | 2.53 | 8771084.0 |
| 2006-04-28 11:10:00 | AAPL | Stock | 2.5304 | 2.5346 | 2.53 | 2.5332 | 8182412.0 |
| 2006-04-28 11:15:00 | AAPL | Stock | 2.5332 | 2.5339 | 2.5304 | 2.5318 | 7293132.0 |
| 2006-04-28 11:20:00 | AAPL | Stock | 2.5314 | 2.5325 | 2.5225 | 2.5246 | 12651520.0 |
| 2006-04-28 11:25:00 | AAPL | Stock | 2.5243 | 2.5269 | 2.5229 | 2.5236 | 5536272.0 |
| 2006-04-28 11:30:00 | AAPL | Stock | 2.5239 | 2.5264 | 2.5218 | 2.5254 | 8840132.0 |
| 2006-04-28 11:35:00 | AAPL | Stock | 2.5254 | 2.5271 | 2.5232 | 2.5239 | 6179544.0 |
| 2006-04-28 11:40:00 | AAPL | Stock | 2.5239 | 2.5307 | 2.5236 | 2.5286 | 7072576.0 |
| 2006-04-28 11:45:00 | AAPL | Stock | 2.5282 | 2.5293 | 2.5254 | 2.5257 | 6395396.0 |
| 2006-04-28 11:50:00 | AAPL | Stock | 2.5261 | 2.5286 | 2.525 | 2.5279 | 4991672.0 |
| 2006-04-28 11:55:00 | AAPL | Stock | 2.5282 | 2.5314 | 2.5268 | 2.528 | 5491668.0 |
| 2006-04-28 12:00:00 | AAPL | Stock | 2.5279 | 2.5282 | 2.5243 | 2.5246 | 5689124.0 |
> showing 50 of 222,356 rows — these rows as CSV