PREVIEW / stock_5min / 2004-07-02
file: by_date/stock_5min/2004/2004-07-02.parquet size: 2.3 MB rows: 172,650 symbols: 1,782
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 |
|---|---|---|---|---|---|---|---|
| 2004-07-02 08:00:00 | AAPL | Stock | 0.5445 | 0.5446 | 0.5402 | 0.5436 | 1546720.0 |
| 2004-07-02 08:05:00 | AAPL | Stock | 0.5411 | 0.5441 | 0.5411 | 0.5413 | 2917600.0 |
| 2004-07-02 08:10:00 | AAPL | Stock | 0.5413 | 0.5413 | 0.5375 | 0.5388 | 873600.0 |
| 2004-07-02 08:15:00 | AAPL | Stock | 0.5389 | 0.5411 | 0.5384 | 0.5393 | 2688000.0 |
| 2004-07-02 08:20:00 | AAPL | Stock | 0.5402 | 0.5402 | 0.5379 | 0.5388 | 2836400.0 |
| 2004-07-02 08:25:00 | AAPL | Stock | 0.5384 | 0.5393 | 0.5384 | 0.5389 | 560000.0 |
| 2004-07-02 08:30:00 | AAPL | Stock | 0.5393 | 0.5393 | 0.5379 | 0.5384 | 2315600.0 |
| 2004-07-02 08:35:00 | AAPL | Stock | 0.5389 | 0.5436 | 0.5389 | 0.5429 | 2895200.0 |
| 2004-07-02 08:40:00 | AAPL | Stock | 0.5429 | 0.5429 | 0.5411 | 0.5423 | 1814400.0 |
| 2004-07-02 08:45:00 | AAPL | Stock | 0.5402 | 0.5464 | 0.5402 | 0.5445 | 2934400.0 |
| 2004-07-02 08:50:00 | AAPL | Stock | 0.5429 | 0.5429 | 0.5429 | 0.5429 | 95200.0 |
| 2004-07-02 08:55:00 | AAPL | Stock | 0.5438 | 0.5454 | 0.5429 | 0.5454 | 3077200.0 |
| 2004-07-02 09:00:00 | AAPL | Stock | 0.5454 | 0.5459 | 0.5445 | 0.5459 | 1993600.0 |
| 2004-07-02 09:05:00 | AAPL | Stock | 0.5452 | 0.5452 | 0.5446 | 0.5446 | 1472800.0 |
| 2004-07-02 09:10:00 | AAPL | Stock | 0.5446 | 0.5448 | 0.5446 | 0.5448 | 423360.0 |
| 2004-07-02 09:15:00 | AAPL | Stock | 0.5454 | 0.5473 | 0.5446 | 0.5473 | 884800.0 |
| 2004-07-02 09:20:00 | AAPL | Stock | 0.5473 | 0.5473 | 0.5438 | 0.5455 | 3399200.0 |
| 2004-07-02 09:25:00 | AAPL | Stock | 0.5455 | 0.5455 | 0.543 | 0.5445 | 6308960.0 |
| 2004-07-02 09:30:00 | AAPL | Stock | 0.5438 | 0.5473 | 0.5366 | 0.537 | 62473880.0 |
| 2004-07-02 09:35:00 | AAPL | Stock | 0.5366 | 0.5413 | 0.5357 | 0.5393 | 48553792.0 |
| 2004-07-02 09:40:00 | AAPL | Stock | 0.5393 | 0.5405 | 0.5363 | 0.5375 | 21092904.0 |
| 2004-07-02 09:45:00 | AAPL | Stock | 0.5375 | 0.5382 | 0.5366 | 0.5368 | 20306272.0 |
| 2004-07-02 09:50:00 | AAPL | Stock | 0.5368 | 0.5375 | 0.5309 | 0.5355 | 44613408.0 |
| 2004-07-02 09:55:00 | AAPL | Stock | 0.5354 | 0.5377 | 0.5338 | 0.5373 | 23823688.0 |
| 2004-07-02 10:00:00 | AAPL | Stock | 0.5375 | 0.5379 | 0.5348 | 0.5354 | 17416560.0 |
| 2004-07-02 10:05:00 | AAPL | Stock | 0.5352 | 0.5364 | 0.5341 | 0.5345 | 15083152.0 |
| 2004-07-02 10:10:00 | AAPL | Stock | 0.5345 | 0.5371 | 0.5345 | 0.5366 | 22013040.0 |
| 2004-07-02 10:15:00 | AAPL | Stock | 0.5368 | 0.5393 | 0.5366 | 0.5386 | 16122400.0 |
| 2004-07-02 10:20:00 | AAPL | Stock | 0.5386 | 0.5464 | 0.5375 | 0.5438 | 48434568.0 |
| 2004-07-02 10:25:00 | AAPL | Stock | 0.5436 | 0.5443 | 0.5414 | 0.5441 | 27715800.0 |
| 2004-07-02 10:30:00 | AAPL | Stock | 0.5439 | 0.5446 | 0.5429 | 0.5443 | 16409568.0 |
| 2004-07-02 10:35:00 | AAPL | Stock | 0.5441 | 0.5495 | 0.5439 | 0.5482 | 32002152.0 |
| 2004-07-02 10:40:00 | AAPL | Stock | 0.548 | 0.5482 | 0.5455 | 0.5459 | 30561888.0 |
| 2004-07-02 10:45:00 | AAPL | Stock | 0.5459 | 0.5463 | 0.5439 | 0.5441 | 19742912.0 |
| 2004-07-02 10:50:00 | AAPL | Stock | 0.5438 | 0.5441 | 0.5421 | 0.5441 | 13207432.0 |
| 2004-07-02 10:55:00 | AAPL | Stock | 0.5441 | 0.5455 | 0.5436 | 0.5439 | 8656592.0 |
| 2004-07-02 11:00:00 | AAPL | Stock | 0.5438 | 0.5448 | 0.542 | 0.5432 | 7539504.0 |
| 2004-07-02 11:05:00 | AAPL | Stock | 0.5432 | 0.5454 | 0.5432 | 0.5439 | 13210344.0 |
| 2004-07-02 11:10:00 | AAPL | Stock | 0.5438 | 0.5452 | 0.5434 | 0.5448 | 3264240.0 |
| 2004-07-02 11:15:00 | AAPL | Stock | 0.5448 | 0.545 | 0.5425 | 0.5425 | 4891096.0 |
| 2004-07-02 11:20:00 | AAPL | Stock | 0.5425 | 0.5425 | 0.5411 | 0.542 | 7420392.0 |
| 2004-07-02 11:25:00 | AAPL | Stock | 0.542 | 0.5443 | 0.5418 | 0.5432 | 4442648.0 |
| 2004-07-02 11:30:00 | AAPL | Stock | 0.5432 | 0.5464 | 0.5432 | 0.5464 | 9663248.0 |
| 2004-07-02 11:35:00 | AAPL | Stock | 0.5464 | 0.5507 | 0.5458 | 0.5496 | 13125000.0 |
| 2004-07-02 11:40:00 | AAPL | Stock | 0.5498 | 0.5513 | 0.5486 | 0.5498 | 14313152.0 |
| 2004-07-02 11:45:00 | AAPL | Stock | 0.5498 | 0.55 | 0.5486 | 0.5495 | 5346152.0 |
| 2004-07-02 11:50:00 | AAPL | Stock | 0.5495 | 0.5507 | 0.5489 | 0.5498 | 6277656.0 |
| 2004-07-02 11:55:00 | AAPL | Stock | 0.5498 | 0.5525 | 0.5496 | 0.5518 | 9891672.0 |
| 2004-07-02 12:00:00 | AAPL | Stock | 0.5516 | 0.5527 | 0.5516 | 0.5523 | 7746032.0 |
| 2004-07-02 12:05:00 | AAPL | Stock | 0.5523 | 0.5563 | 0.5521 | 0.5561 | 15590400.0 |
> showing 50 of 172,650 rows — these rows as CSV