PREVIEW / stock_5min / 2006-05-01
file: by_date/stock_5min/2006/2006-05-01.parquet size: 3.1 MB rows: 228,052 symbols: 2,246
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-05-01 08:00:00 | AAPL | Stock | 2.5179 | 2.5268 | 2.5179 | 2.5246 | 225428.0 |
| 2006-05-01 08:05:00 | AAPL | Stock | 2.5257 | 2.5257 | 2.525 | 2.525 | 25200.0 |
| 2006-05-01 08:10:00 | AAPL | Stock | 2.5257 | 2.5268 | 2.525 | 2.525 | 22400.0 |
| 2006-05-01 08:15:00 | AAPL | Stock | 2.525 | 2.5268 | 2.5232 | 2.5268 | 61600.0 |
| 2006-05-01 08:20:00 | AAPL | Stock | 2.5279 | 2.5307 | 2.5279 | 2.5304 | 185780.0 |
| 2006-05-01 08:25:00 | AAPL | Stock | 2.5304 | 2.5314 | 2.5271 | 2.5271 | 47600.0 |
| 2006-05-01 08:30:00 | AAPL | Stock | 2.5282 | 2.5282 | 2.5264 | 2.5268 | 44800.0 |
| 2006-05-01 08:35:00 | AAPL | Stock | 2.5268 | 2.5293 | 2.5264 | 2.5264 | 70000.0 |
| 2006-05-01 08:40:00 | AAPL | Stock | 2.5275 | 2.5275 | 2.5275 | 2.5275 | 2800.0 |
| 2006-05-01 08:45:00 | AAPL | Stock | 2.5268 | 2.5275 | 2.5232 | 2.5232 | 168140.0 |
| 2006-05-01 08:50:00 | AAPL | Stock | 2.5221 | 2.5221 | 2.5139 | 2.5139 | 420000.0 |
| 2006-05-01 08:55:00 | AAPL | Stock | 2.5214 | 2.5214 | 2.5107 | 2.5107 | 1762880.0 |
| 2006-05-01 09:00:00 | AAPL | Stock | 2.5214 | 2.5214 | 2.5196 | 2.5196 | 26600.0 |
| 2006-05-01 09:05:00 | AAPL | Stock | 2.5211 | 2.5221 | 2.5204 | 2.5221 | 153552.0 |
| 2006-05-01 09:10:00 | AAPL | Stock | 2.5139 | 2.5243 | 2.5139 | 2.5239 | 78680.0 |
| 2006-05-01 09:15:00 | AAPL | Stock | 2.5257 | 2.5257 | 2.5257 | 2.5257 | 2800.0 |
| 2006-05-01 09:20:00 | AAPL | Stock | 2.5239 | 2.5239 | 2.515 | 2.515 | 104720.0 |
| 2006-05-01 09:25:00 | AAPL | Stock | 2.5182 | 2.5293 | 2.5179 | 2.5271 | 1242724.0 |
| 2006-05-01 09:30:00 | AAPL | Stock | 2.5275 | 2.5536 | 2.5221 | 2.535 | 22876224.0 |
| 2006-05-01 09:35:00 | AAPL | Stock | 2.5346 | 2.5421 | 2.5236 | 2.5318 | 17333344.0 |
| 2006-05-01 09:40:00 | AAPL | Stock | 2.5321 | 2.5425 | 2.5246 | 2.5411 | 17405276.0 |
| 2006-05-01 09:45:00 | AAPL | Stock | 2.5411 | 2.5421 | 2.5271 | 2.5321 | 10225740.0 |
| 2006-05-01 09:50:00 | AAPL | Stock | 2.5325 | 2.5364 | 2.5296 | 2.5321 | 10431736.0 |
| 2006-05-01 09:55:00 | AAPL | Stock | 2.5318 | 2.5386 | 2.53 | 2.5368 | 10116484.0 |
| 2006-05-01 10:00:00 | AAPL | Stock | 2.5368 | 2.5375 | 2.5296 | 2.5354 | 12277804.0 |
| 2006-05-01 10:05:00 | AAPL | Stock | 2.535 | 2.5357 | 2.5268 | 2.5336 | 10383352.0 |
| 2006-05-01 10:10:00 | AAPL | Stock | 2.5332 | 2.5464 | 2.5289 | 2.5414 | 17227028.0 |
| 2006-05-01 10:15:00 | AAPL | Stock | 2.5414 | 2.5429 | 2.5307 | 2.5332 | 13219528.0 |
| 2006-05-01 10:20:00 | AAPL | Stock | 2.5332 | 2.5393 | 2.5271 | 2.5354 | 11788196.0 |
| 2006-05-01 10:25:00 | AAPL | Stock | 2.535 | 2.5429 | 2.535 | 2.5396 | 10426836.0 |
| 2006-05-01 10:30:00 | AAPL | Stock | 2.5396 | 2.5507 | 2.5389 | 2.5482 | 18679332.0 |
| 2006-05-01 10:35:00 | AAPL | Stock | 2.5479 | 2.5507 | 2.5436 | 2.5486 | 16842784.0 |
| 2006-05-01 10:40:00 | AAPL | Stock | 2.5486 | 2.5536 | 2.5443 | 2.5525 | 16591288.0 |
| 2006-05-01 10:45:00 | AAPL | Stock | 2.5521 | 2.555 | 2.5504 | 2.5543 | 16419536.0 |
| 2006-05-01 10:50:00 | AAPL | Stock | 2.5539 | 2.555 | 2.5464 | 2.5468 | 12942412.0 |
| 2006-05-01 10:55:00 | AAPL | Stock | 2.5468 | 2.55 | 2.5393 | 2.5457 | 12530476.0 |
| 2006-05-01 11:00:00 | AAPL | Stock | 2.5457 | 2.5482 | 2.5429 | 2.5454 | 6451956.0 |
| 2006-05-01 11:05:00 | AAPL | Stock | 2.5454 | 2.5471 | 2.5429 | 2.5443 | 5534424.0 |
| 2006-05-01 11:10:00 | AAPL | Stock | 2.5443 | 2.5457 | 2.5407 | 2.5439 | 8586340.0 |
| 2006-05-01 11:15:00 | AAPL | Stock | 2.5439 | 2.5457 | 2.5425 | 2.5436 | 5417664.0 |
| 2006-05-01 11:20:00 | AAPL | Stock | 2.5439 | 2.5479 | 2.5429 | 2.5461 | 4701676.0 |
| 2006-05-01 11:25:00 | AAPL | Stock | 2.5464 | 2.5496 | 2.545 | 2.5471 | 5188960.0 |
| 2006-05-01 11:30:00 | AAPL | Stock | 2.5471 | 2.5486 | 2.5457 | 2.5482 | 4731076.0 |
| 2006-05-01 11:35:00 | AAPL | Stock | 2.5482 | 2.5496 | 2.5479 | 2.5489 | 3263988.0 |
| 2006-05-01 11:40:00 | AAPL | Stock | 2.5486 | 2.5493 | 2.5464 | 2.5468 | 4059524.0 |
| 2006-05-01 11:45:00 | AAPL | Stock | 2.5469 | 2.5479 | 2.5446 | 2.5453 | 4058908.0 |
| 2006-05-01 11:50:00 | AAPL | Stock | 2.5454 | 2.5486 | 2.545 | 2.5461 | 3117688.0 |
| 2006-05-01 11:55:00 | AAPL | Stock | 2.5461 | 2.5461 | 2.5414 | 2.5429 | 3279192.0 |
| 2006-05-01 12:00:00 | AAPL | Stock | 2.5429 | 2.5439 | 2.5421 | 2.5429 | 2306584.0 |
| 2006-05-01 12:05:00 | AAPL | Stock | 2.5429 | 2.5432 | 2.5375 | 2.5389 | 8503712.0 |
> showing 50 of 228,052 rows — these rows as CSV