PREVIEW / stock_5min / 2005-03-21
file: by_date/stock_5min/2005/2005-03-21.parquet size: 2.6 MB rows: 192,110 symbols: 1,953
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-21 08:00:00 | AAPL | Stock | 1.5375 | 1.5375 | 1.5375 | 1.5375 | 184800.0 |
| 2005-03-21 08:05:00 | AAPL | Stock | 1.5421 | 1.5421 | 1.5393 | 1.5407 | 413112.0 |
| 2005-03-21 08:10:00 | AAPL | Stock | 1.5407 | 1.5407 | 1.5364 | 1.5364 | 112616.0 |
| 2005-03-21 08:15:00 | AAPL | Stock | 1.5382 | 1.5386 | 1.5321 | 1.5321 | 67200.0 |
| 2005-03-21 08:20:00 | AAPL | Stock | 1.5407 | 1.5432 | 1.5396 | 1.5429 | 423920.0 |
| 2005-03-21 08:25:00 | AAPL | Stock | 1.5414 | 1.5414 | 1.5407 | 1.5407 | 16800.0 |
| 2005-03-21 08:30:00 | AAPL | Stock | 1.5396 | 1.5396 | 1.5389 | 1.5389 | 167720.0 |
| 2005-03-21 08:35:00 | AAPL | Stock | 1.5389 | 1.5393 | 1.5382 | 1.5393 | 44800.0 |
| 2005-03-21 08:40:00 | AAPL | Stock | 1.5393 | 1.5396 | 1.5379 | 1.5386 | 244216.0 |
| 2005-03-21 08:45:00 | AAPL | Stock | 1.5379 | 1.5393 | 1.5379 | 1.5389 | 64400.0 |
| 2005-03-21 08:50:00 | AAPL | Stock | 1.5379 | 1.5393 | 1.5375 | 1.5389 | 76160.0 |
| 2005-03-21 08:55:00 | AAPL | Stock | 1.5389 | 1.5393 | 1.5389 | 1.5389 | 98000.0 |
| 2005-03-21 09:00:00 | AAPL | Stock | 1.5389 | 1.5389 | 1.5336 | 1.5336 | 729344.0 |
| 2005-03-21 09:05:00 | AAPL | Stock | 1.5339 | 1.5343 | 1.5339 | 1.5343 | 62300.0 |
| 2005-03-21 09:10:00 | AAPL | Stock | 1.535 | 1.5382 | 1.535 | 1.5371 | 171108.0 |
| 2005-03-21 09:15:00 | AAPL | Stock | 1.5375 | 1.5379 | 1.5375 | 1.5379 | 14000.0 |
| 2005-03-21 09:20:00 | AAPL | Stock | 1.5393 | 1.5393 | 1.5375 | 1.5375 | 138600.0 |
| 2005-03-21 09:25:00 | AAPL | Stock | 1.5379 | 1.5486 | 1.5357 | 1.5464 | 2188116.0 |
| 2005-03-21 09:30:00 | AAPL | Stock | 1.5461 | 1.55 | 1.5414 | 1.5457 | 18901988.0 |
| 2005-03-21 09:35:00 | AAPL | Stock | 1.5457 | 1.5514 | 1.5443 | 1.5486 | 11850608.0 |
| 2005-03-21 09:40:00 | AAPL | Stock | 1.55 | 1.5564 | 1.5486 | 1.5507 | 18624312.0 |
| 2005-03-21 09:45:00 | AAPL | Stock | 1.5504 | 1.5511 | 1.5443 | 1.5482 | 11283608.0 |
| 2005-03-21 09:50:00 | AAPL | Stock | 1.5482 | 1.5525 | 1.5464 | 1.5518 | 9269960.0 |
| 2005-03-21 09:55:00 | AAPL | Stock | 1.5521 | 1.5536 | 1.5496 | 1.5532 | 9572864.0 |
| 2005-03-21 10:00:00 | AAPL | Stock | 1.5532 | 1.5536 | 1.5479 | 1.5489 | 6343260.0 |
| 2005-03-21 10:05:00 | AAPL | Stock | 1.5489 | 1.55 | 1.5457 | 1.5461 | 7864584.0 |
| 2005-03-21 10:10:00 | AAPL | Stock | 1.5464 | 1.5493 | 1.545 | 1.5454 | 7130256.0 |
| 2005-03-21 10:15:00 | AAPL | Stock | 1.5454 | 1.5482 | 1.54 | 1.5454 | 10429636.0 |
| 2005-03-21 10:20:00 | AAPL | Stock | 1.5457 | 1.5475 | 1.5432 | 1.5439 | 4642092.0 |
| 2005-03-21 10:25:00 | AAPL | Stock | 1.5443 | 1.5446 | 1.5407 | 1.5414 | 7113120.0 |
| 2005-03-21 10:30:00 | AAPL | Stock | 1.5411 | 1.5432 | 1.535 | 1.5379 | 9352896.0 |
| 2005-03-21 10:35:00 | AAPL | Stock | 1.5375 | 1.5421 | 1.5368 | 1.5396 | 13713980.0 |
| 2005-03-21 10:40:00 | AAPL | Stock | 1.5396 | 1.5404 | 1.5364 | 1.5404 | 7944608.0 |
| 2005-03-21 10:45:00 | AAPL | Stock | 1.5404 | 1.5407 | 1.5307 | 1.5336 | 10486700.0 |
| 2005-03-21 10:50:00 | AAPL | Stock | 1.5332 | 1.5375 | 1.5314 | 1.5361 | 8569932.0 |
| 2005-03-21 10:55:00 | AAPL | Stock | 1.5361 | 1.5393 | 1.5361 | 1.5389 | 4009376.0 |
| 2005-03-21 11:00:00 | AAPL | Stock | 1.5389 | 1.5429 | 1.5389 | 1.5414 | 4988116.0 |
| 2005-03-21 11:05:00 | AAPL | Stock | 1.5418 | 1.5443 | 1.5393 | 1.5432 | 6534332.0 |
| 2005-03-21 11:10:00 | AAPL | Stock | 1.5429 | 1.5432 | 1.5393 | 1.5418 | 6964860.0 |
| 2005-03-21 11:15:00 | AAPL | Stock | 1.5421 | 1.5443 | 1.5414 | 1.5436 | 4432456.0 |
| 2005-03-21 11:20:00 | AAPL | Stock | 1.5439 | 1.55 | 1.5436 | 1.5496 | 10894436.0 |
| 2005-03-21 11:25:00 | AAPL | Stock | 1.5493 | 1.5504 | 1.5457 | 1.5475 | 7244160.0 |
| 2005-03-21 11:30:00 | AAPL | Stock | 1.5475 | 1.5486 | 1.5464 | 1.5482 | 3179288.0 |
| 2005-03-21 11:35:00 | AAPL | Stock | 1.5482 | 1.5521 | 1.5471 | 1.5518 | 8064784.0 |
| 2005-03-21 11:40:00 | AAPL | Stock | 1.5514 | 1.5536 | 1.5482 | 1.5482 | 10306380.0 |
| 2005-03-21 11:45:00 | AAPL | Stock | 1.5482 | 1.5518 | 1.5475 | 1.5511 | 3564316.0 |
| 2005-03-21 11:50:00 | AAPL | Stock | 1.5511 | 1.5514 | 1.5486 | 1.5504 | 3155544.0 |
| 2005-03-21 11:55:00 | AAPL | Stock | 1.5504 | 1.5504 | 1.5475 | 1.5489 | 3529904.0 |
| 2005-03-21 12:00:00 | AAPL | Stock | 1.5493 | 1.5611 | 1.5489 | 1.5607 | 15334340.0 |
| 2005-03-21 12:05:00 | AAPL | Stock | 1.5607 | 1.5643 | 1.5571 | 1.5589 | 12945044.0 |
> showing 50 of 192,110 rows — these rows as CSV