PREVIEW / stock_5min / 2009-02-13
file: by_date/stock_5min/2009/2009-02-13.parquet size: 4.1 MB rows: 290,552 symbols: 3,317
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 |
|---|---|---|---|---|---|---|---|
| 2009-02-13 05:05:00 | AAPL | Stock | 3.5589 | 3.5589 | 3.5589 | 3.5589 | 2800.0 |
| 2009-02-13 05:30:00 | AAPL | Stock | 3.5693 | 3.5693 | 3.5693 | 3.5693 | 2800.0 |
| 2009-02-13 06:10:00 | AAPL | Stock | 3.5607 | 3.5607 | 3.5607 | 3.5607 | 2800.0 |
| 2009-02-13 07:15:00 | AAPL | Stock | 3.5604 | 3.5604 | 3.5604 | 3.5604 | 8400.0 |
| 2009-02-13 07:20:00 | AAPL | Stock | 3.5571 | 3.5571 | 3.5571 | 3.5571 | 2800.0 |
| 2009-02-13 07:30:00 | AAPL | Stock | 3.5571 | 3.5571 | 3.5571 | 3.5571 | 2800.0 |
| 2009-02-13 08:00:00 | AAPL | Stock | 3.5554 | 3.5554 | 3.5111 | 3.5432 | 30800.0 |
| 2009-02-13 08:05:00 | AAPL | Stock | 3.5357 | 3.5464 | 3.5357 | 3.5464 | 166348.0 |
| 2009-02-13 08:10:00 | AAPL | Stock | 3.5464 | 3.5546 | 3.5464 | 3.5507 | 369740.0 |
| 2009-02-13 08:15:00 | AAPL | Stock | 3.5461 | 3.5536 | 3.5429 | 3.55 | 49000.0 |
| 2009-02-13 08:20:00 | AAPL | Stock | 3.5429 | 3.5489 | 3.5429 | 3.5489 | 29400.0 |
| 2009-02-13 08:25:00 | AAPL | Stock | 3.5457 | 3.5464 | 3.5457 | 3.5461 | 65800.0 |
| 2009-02-13 08:30:00 | AAPL | Stock | 3.5461 | 3.5468 | 3.5432 | 3.5457 | 131264.0 |
| 2009-02-13 08:35:00 | AAPL | Stock | 3.5432 | 3.5432 | 3.5364 | 3.5364 | 87052.0 |
| 2009-02-13 08:40:00 | AAPL | Stock | 3.5357 | 3.5357 | 3.5321 | 3.5325 | 17500.0 |
| 2009-02-13 08:45:00 | AAPL | Stock | 3.5357 | 3.5446 | 3.5357 | 3.5396 | 66528.0 |
| 2009-02-13 08:50:00 | AAPL | Stock | 3.5439 | 3.5507 | 3.5439 | 3.5507 | 92456.0 |
| 2009-02-13 08:55:00 | AAPL | Stock | 3.5496 | 3.5496 | 3.5357 | 3.5357 | 92008.0 |
| 2009-02-13 09:00:00 | AAPL | Stock | 3.5343 | 3.5357 | 3.5343 | 3.5357 | 58520.0 |
| 2009-02-13 09:05:00 | AAPL | Stock | 3.5357 | 3.5357 | 3.53 | 3.53 | 86800.0 |
| 2009-02-13 09:10:00 | AAPL | Stock | 3.5307 | 3.5339 | 3.5286 | 3.5304 | 77168.0 |
| 2009-02-13 09:15:00 | AAPL | Stock | 3.5296 | 3.5357 | 3.5246 | 3.5325 | 271180.0 |
| 2009-02-13 09:20:00 | AAPL | Stock | 3.5325 | 3.5325 | 3.5261 | 3.5304 | 33600.0 |
| 2009-02-13 09:25:00 | AAPL | Stock | 3.5307 | 3.5429 | 3.5286 | 3.5421 | 290976.0 |
| 2009-02-13 09:30:00 | AAPL | Stock | 3.5354 | 3.5536 | 3.5304 | 3.5383 | 14618100.0 |
| 2009-02-13 09:35:00 | AAPL | Stock | 3.5386 | 3.5518 | 3.52 | 3.5268 | 13470632.0 |
| 2009-02-13 09:40:00 | AAPL | Stock | 3.5268 | 3.5386 | 3.5196 | 3.5264 | 10402504.0 |
| 2009-02-13 09:45:00 | AAPL | Stock | 3.5268 | 3.527 | 3.5061 | 3.5141 | 13415164.0 |
| 2009-02-13 09:50:00 | AAPL | Stock | 3.5139 | 3.5196 | 3.5043 | 3.5071 | 8698088.0 |
| 2009-02-13 09:55:00 | AAPL | Stock | 3.5071 | 3.5311 | 3.5057 | 3.5264 | 9673860.0 |
| 2009-02-13 10:00:00 | AAPL | Stock | 3.5264 | 3.5343 | 3.5196 | 3.5321 | 9488192.0 |
| 2009-02-13 10:05:00 | AAPL | Stock | 3.5321 | 3.5375 | 3.5268 | 3.5318 | 13169688.0 |
| 2009-02-13 10:10:00 | AAPL | Stock | 3.5318 | 3.5375 | 3.5286 | 3.5332 | 9451232.0 |
| 2009-02-13 10:15:00 | AAPL | Stock | 3.5332 | 3.5336 | 3.5107 | 3.5149 | 12000212.0 |
| 2009-02-13 10:20:00 | AAPL | Stock | 3.5161 | 3.5346 | 3.5136 | 3.5346 | 10750432.0 |
| 2009-02-13 10:25:00 | AAPL | Stock | 3.5346 | 3.5386 | 3.5271 | 3.5375 | 7969444.0 |
| 2009-02-13 10:30:00 | AAPL | Stock | 3.5371 | 3.5479 | 3.535 | 3.5471 | 11385808.0 |
| 2009-02-13 10:35:00 | AAPL | Stock | 3.5468 | 3.5504 | 3.5421 | 3.5496 | 11785844.0 |
| 2009-02-13 10:40:00 | AAPL | Stock | 3.5495 | 3.5514 | 3.5414 | 3.5421 | 9984828.0 |
| 2009-02-13 10:45:00 | AAPL | Stock | 3.5421 | 3.5454 | 3.5357 | 3.5404 | 7933268.0 |
| 2009-02-13 10:50:00 | AAPL | Stock | 3.54 | 3.5482 | 3.5393 | 3.5439 | 6137908.0 |
| 2009-02-13 10:55:00 | AAPL | Stock | 3.5443 | 3.5568 | 3.5436 | 3.5514 | 8868916.0 |
| 2009-02-13 11:00:00 | AAPL | Stock | 3.5507 | 3.5518 | 3.5375 | 3.5439 | 7832524.0 |
| 2009-02-13 11:05:00 | AAPL | Stock | 3.5432 | 3.5486 | 3.5392 | 3.5454 | 6597752.0 |
| 2009-02-13 11:10:00 | AAPL | Stock | 3.5454 | 3.5514 | 3.5354 | 3.5357 | 10401020.0 |
| 2009-02-13 11:15:00 | AAPL | Stock | 3.5354 | 3.5393 | 3.5307 | 3.5339 | 9965452.0 |
| 2009-02-13 11:20:00 | AAPL | Stock | 3.5339 | 3.5371 | 3.5311 | 3.5336 | 6297872.0 |
| 2009-02-13 11:25:00 | AAPL | Stock | 3.5339 | 3.5446 | 3.5325 | 3.5414 | 8023484.0 |
| 2009-02-13 11:30:00 | AAPL | Stock | 3.5418 | 3.5518 | 3.5393 | 3.5514 | 7050932.0 |
| 2009-02-13 11:35:00 | AAPL | Stock | 3.5514 | 3.5543 | 3.5489 | 3.5518 | 7826084.0 |
> showing 50 of 290,552 rows — these rows as CSV