PREVIEW / stock_5min / 2005-03-22
file: by_date/stock_5min/2005/2005-03-22.parquet size: 2.7 MB rows: 193,033 symbols: 1,944
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-22 08:00:00 | AAPL | Stock | 1.5625 | 1.5625 | 1.5589 | 1.5589 | 21560.0 |
| 2005-03-22 08:05:00 | AAPL | Stock | 1.5589 | 1.5589 | 1.5589 | 1.5589 | 5600.0 |
| 2005-03-22 08:10:00 | AAPL | Stock | 1.5571 | 1.5571 | 1.5568 | 1.5571 | 75600.0 |
| 2005-03-22 08:15:00 | AAPL | Stock | 1.5571 | 1.5589 | 1.5571 | 1.5589 | 39200.0 |
| 2005-03-22 08:20:00 | AAPL | Stock | 1.5589 | 1.5589 | 1.5589 | 1.5589 | 68320.0 |
| 2005-03-22 08:25:00 | AAPL | Stock | 1.5589 | 1.5589 | 1.5589 | 1.5589 | 84140.0 |
| 2005-03-22 08:30:00 | AAPL | Stock | 1.5589 | 1.5589 | 1.5589 | 1.5589 | 30800.0 |
| 2005-03-22 08:35:00 | AAPL | Stock | 1.5589 | 1.5589 | 1.5589 | 1.5589 | 28000.0 |
| 2005-03-22 08:40:00 | AAPL | Stock | 1.56 | 1.5611 | 1.56 | 1.5611 | 84000.0 |
| 2005-03-22 08:45:00 | AAPL | Stock | 1.5648 | 1.5648 | 1.5611 | 1.5611 | 5314400.0 |
| 2005-03-22 08:50:00 | AAPL | Stock | 1.5611 | 1.5614 | 1.5607 | 1.5607 | 16800.0 |
| 2005-03-22 08:55:00 | AAPL | Stock | 1.5607 | 1.5607 | 1.5589 | 1.5589 | 98112.0 |
| 2005-03-22 09:00:00 | AAPL | Stock | 1.56 | 1.56 | 1.56 | 1.56 | 19600.0 |
| 2005-03-22 09:05:00 | AAPL | Stock | 1.5607 | 1.5618 | 1.5607 | 1.5618 | 19600.0 |
| 2005-03-22 09:10:00 | AAPL | Stock | 1.5621 | 1.5621 | 1.5593 | 1.5593 | 310800.0 |
| 2005-03-22 09:15:00 | AAPL | Stock | 1.56 | 1.5604 | 1.5589 | 1.5589 | 113400.0 |
| 2005-03-22 09:20:00 | AAPL | Stock | 1.5575 | 1.5575 | 1.5564 | 1.5571 | 243600.0 |
| 2005-03-22 09:25:00 | AAPL | Stock | 1.5575 | 1.5643 | 1.5575 | 1.5589 | 1054760.0 |
| 2005-03-22 09:30:00 | AAPL | Stock | 1.5611 | 1.5693 | 1.5596 | 1.5668 | 12946612.0 |
| 2005-03-22 09:35:00 | AAPL | Stock | 1.5668 | 1.57 | 1.5607 | 1.5664 | 11813844.0 |
| 2005-03-22 09:40:00 | AAPL | Stock | 1.5668 | 1.5668 | 1.5614 | 1.5643 | 4919348.0 |
| 2005-03-22 09:45:00 | AAPL | Stock | 1.5614 | 1.5643 | 1.5482 | 1.5511 | 21038612.0 |
| 2005-03-22 09:50:00 | AAPL | Stock | 1.5514 | 1.555 | 1.5482 | 1.555 | 11764396.0 |
| 2005-03-22 09:55:00 | AAPL | Stock | 1.555 | 1.5564 | 1.5496 | 1.5539 | 8762572.0 |
| 2005-03-22 10:00:00 | AAPL | Stock | 1.5543 | 1.555 | 1.5511 | 1.5518 | 8396836.0 |
| 2005-03-22 10:05:00 | AAPL | Stock | 1.5518 | 1.5518 | 1.54 | 1.5429 | 19043808.0 |
| 2005-03-22 10:10:00 | AAPL | Stock | 1.5429 | 1.5518 | 1.5393 | 1.5396 | 11690140.0 |
| 2005-03-22 10:15:00 | AAPL | Stock | 1.5393 | 1.5429 | 1.5325 | 1.5386 | 20029100.0 |
| 2005-03-22 10:20:00 | AAPL | Stock | 1.5386 | 1.5518 | 1.5379 | 1.5468 | 12397504.0 |
| 2005-03-22 10:25:00 | AAPL | Stock | 1.5468 | 1.5507 | 1.5436 | 1.5482 | 8676724.0 |
| 2005-03-22 10:30:00 | AAPL | Stock | 1.5479 | 1.5557 | 1.5479 | 1.5525 | 11544232.0 |
| 2005-03-22 10:35:00 | AAPL | Stock | 1.5525 | 1.5561 | 1.5482 | 1.5482 | 9834496.0 |
| 2005-03-22 10:40:00 | AAPL | Stock | 1.5482 | 1.5507 | 1.5457 | 1.5507 | 6266568.0 |
| 2005-03-22 10:45:00 | AAPL | Stock | 1.5504 | 1.5532 | 1.55 | 1.5507 | 5726168.0 |
| 2005-03-22 10:50:00 | AAPL | Stock | 1.5509 | 1.5529 | 1.5507 | 1.5521 | 2073680.0 |
| 2005-03-22 10:55:00 | AAPL | Stock | 1.5518 | 1.5579 | 1.5514 | 1.5554 | 7162568.0 |
| 2005-03-22 11:00:00 | AAPL | Stock | 1.555 | 1.5557 | 1.5504 | 1.5532 | 5831952.0 |
| 2005-03-22 11:05:00 | AAPL | Stock | 1.5529 | 1.5543 | 1.5518 | 1.5536 | 4958212.0 |
| 2005-03-22 11:10:00 | AAPL | Stock | 1.5536 | 1.5536 | 1.5518 | 1.5532 | 3346168.0 |
| 2005-03-22 11:15:00 | AAPL | Stock | 1.5532 | 1.5532 | 1.5496 | 1.55 | 4089568.0 |
| 2005-03-22 11:20:00 | AAPL | Stock | 1.5496 | 1.5507 | 1.5482 | 1.55 | 2375884.0 |
| 2005-03-22 11:25:00 | AAPL | Stock | 1.55 | 1.5521 | 1.5496 | 1.5507 | 3914036.0 |
| 2005-03-22 11:30:00 | AAPL | Stock | 1.5514 | 1.5532 | 1.5507 | 1.5525 | 2718100.0 |
| 2005-03-22 11:35:00 | AAPL | Stock | 1.5529 | 1.5536 | 1.5521 | 1.5521 | 3615724.0 |
| 2005-03-22 11:40:00 | AAPL | Stock | 1.5521 | 1.5536 | 1.5486 | 1.5493 | 2702728.0 |
| 2005-03-22 11:45:00 | AAPL | Stock | 1.5489 | 1.55 | 1.545 | 1.5468 | 6277488.0 |
| 2005-03-22 11:50:00 | AAPL | Stock | 1.5468 | 1.5489 | 1.5457 | 1.5486 | 4529476.0 |
| 2005-03-22 11:55:00 | AAPL | Stock | 1.5486 | 1.5489 | 1.5476 | 1.5486 | 1839740.0 |
| 2005-03-22 12:00:00 | AAPL | Stock | 1.5486 | 1.5493 | 1.5478 | 1.5479 | 1456504.0 |
| 2005-03-22 12:05:00 | AAPL | Stock | 1.5482 | 1.5489 | 1.5471 | 1.5485 | 1059212.0 |
> showing 50 of 193,033 rows — these rows as CSV