PREVIEW / stock_5min / 2006-07-17
file: by_date/stock_5min/2006/2006-07-17.parquet size: 3.0 MB rows: 224,593 symbols: 2,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 |
|---|---|---|---|---|---|---|---|
| 2006-07-17 04:45:00 | AAPL | Stock | 1.825 | 1.825 | 1.8107 | 1.8143 | 143108.0 |
| 2006-07-17 04:50:00 | AAPL | Stock | 1.8107 | 1.8232 | 1.8107 | 1.8232 | 56000.0 |
| 2006-07-17 04:55:00 | AAPL | Stock | 1.8214 | 1.8214 | 1.8214 | 1.8214 | 28000.0 |
| 2006-07-17 05:35:00 | AAPL | Stock | 1.8282 | 1.8282 | 1.8282 | 1.8282 | 28000.0 |
| 2006-07-17 06:50:00 | AAPL | Stock | 1.8214 | 1.8214 | 1.8214 | 1.8214 | 2800.0 |
| 2006-07-17 06:55:00 | AAPL | Stock | 1.8357 | 1.8375 | 1.8357 | 1.8375 | 8400.0 |
| 2006-07-17 07:25:00 | AAPL | Stock | 1.8357 | 1.8357 | 1.8357 | 1.8357 | 2800.0 |
| 2006-07-17 07:30:00 | AAPL | Stock | 1.8339 | 1.8357 | 1.8339 | 1.8357 | 16800.0 |
| 2006-07-17 07:40:00 | AAPL | Stock | 1.8357 | 1.8482 | 1.8357 | 1.8482 | 63000.0 |
| 2006-07-17 07:45:00 | AAPL | Stock | 1.8393 | 1.8393 | 1.8371 | 1.8371 | 70000.0 |
| 2006-07-17 07:50:00 | AAPL | Stock | 1.8393 | 1.84 | 1.8393 | 1.8393 | 199136.0 |
| 2006-07-17 07:55:00 | AAPL | Stock | 1.8393 | 1.8446 | 1.8393 | 1.8446 | 14000.0 |
| 2006-07-17 08:00:00 | AAPL | Stock | 1.8393 | 1.8457 | 1.83 | 1.8393 | 1231300.0 |
| 2006-07-17 08:05:00 | AAPL | Stock | 1.8393 | 1.8443 | 1.8393 | 1.8439 | 597212.0 |
| 2006-07-17 08:10:00 | AAPL | Stock | 1.8432 | 1.8607 | 1.8429 | 1.8557 | 2009000.0 |
| 2006-07-17 08:15:00 | AAPL | Stock | 1.8557 | 1.8575 | 1.8518 | 1.8521 | 908656.0 |
| 2006-07-17 08:20:00 | AAPL | Stock | 1.8529 | 1.8589 | 1.8521 | 1.8575 | 796880.0 |
| 2006-07-17 08:25:00 | AAPL | Stock | 1.8579 | 1.8621 | 1.855 | 1.8571 | 1068900.0 |
| 2006-07-17 08:30:00 | AAPL | Stock | 1.8575 | 1.8579 | 1.8446 | 1.8493 | 1458072.0 |
| 2006-07-17 08:35:00 | AAPL | Stock | 1.8496 | 1.8546 | 1.8482 | 1.8518 | 513100.0 |
| 2006-07-17 08:40:00 | AAPL | Stock | 1.8532 | 1.8564 | 1.8514 | 1.8518 | 575736.0 |
| 2006-07-17 08:45:00 | AAPL | Stock | 1.8529 | 1.855 | 1.8464 | 1.85 | 936208.0 |
| 2006-07-17 08:50:00 | AAPL | Stock | 1.85 | 1.8514 | 1.8482 | 1.8482 | 551432.0 |
| 2006-07-17 08:55:00 | AAPL | Stock | 1.8496 | 1.8496 | 1.8457 | 1.8475 | 1020628.0 |
| 2006-07-17 09:00:00 | AAPL | Stock | 1.8471 | 1.8471 | 1.8421 | 1.8436 | 545412.0 |
| 2006-07-17 09:05:00 | AAPL | Stock | 1.8436 | 1.8464 | 1.8432 | 1.8446 | 1591800.0 |
| 2006-07-17 09:10:00 | AAPL | Stock | 1.8446 | 1.8464 | 1.8443 | 1.8443 | 495320.0 |
| 2006-07-17 09:15:00 | AAPL | Stock | 1.8443 | 1.845 | 1.8393 | 1.8443 | 466452.0 |
| 2006-07-17 09:20:00 | AAPL | Stock | 1.8436 | 1.8446 | 1.8357 | 1.8429 | 1435588.0 |
| 2006-07-17 09:25:00 | AAPL | Stock | 1.8411 | 1.8475 | 1.8411 | 1.8475 | 2137576.0 |
| 2006-07-17 09:30:00 | AAPL | Stock | 1.8475 | 1.8611 | 1.8446 | 1.8564 | 45149216.0 |
| 2006-07-17 09:35:00 | AAPL | Stock | 1.8571 | 1.8714 | 1.8564 | 1.8682 | 40014576.0 |
| 2006-07-17 09:40:00 | AAPL | Stock | 1.8679 | 1.8732 | 1.8639 | 1.8664 | 32221952.0 |
| 2006-07-17 09:45:00 | AAPL | Stock | 1.8664 | 1.8686 | 1.8604 | 1.8632 | 21805616.0 |
| 2006-07-17 09:50:00 | AAPL | Stock | 1.8636 | 1.8657 | 1.8593 | 1.8593 | 15927436.0 |
| 2006-07-17 09:55:00 | AAPL | Stock | 1.8593 | 1.86 | 1.8479 | 1.8493 | 22702288.0 |
| 2006-07-17 10:00:00 | AAPL | Stock | 1.8493 | 1.8554 | 1.8482 | 1.8539 | 18790240.0 |
| 2006-07-17 10:05:00 | AAPL | Stock | 1.8539 | 1.8593 | 1.8514 | 1.8564 | 19727624.0 |
| 2006-07-17 10:10:00 | AAPL | Stock | 1.8561 | 1.8625 | 1.8489 | 1.8621 | 19300484.0 |
| 2006-07-17 10:15:00 | AAPL | Stock | 1.8621 | 1.8661 | 1.8571 | 1.8632 | 17102680.0 |
| 2006-07-17 10:20:00 | AAPL | Stock | 1.8632 | 1.8657 | 1.86 | 1.8625 | 12965372.0 |
| 2006-07-17 10:25:00 | AAPL | Stock | 1.8621 | 1.8636 | 1.8525 | 1.8568 | 18060896.0 |
| 2006-07-17 10:30:00 | AAPL | Stock | 1.8564 | 1.8596 | 1.8521 | 1.8536 | 13222804.0 |
| 2006-07-17 10:35:00 | AAPL | Stock | 1.8532 | 1.8536 | 1.8471 | 1.8493 | 17728116.0 |
| 2006-07-17 10:40:00 | AAPL | Stock | 1.8489 | 1.8546 | 1.8489 | 1.8543 | 13143508.0 |
| 2006-07-17 10:45:00 | AAPL | Stock | 1.8546 | 1.8582 | 1.8529 | 1.8564 | 14543872.0 |
| 2006-07-17 10:50:00 | AAPL | Stock | 1.8564 | 1.8629 | 1.855 | 1.8625 | 20415080.0 |
| 2006-07-17 10:55:00 | AAPL | Stock | 1.8625 | 1.8714 | 1.8607 | 1.8714 | 23296868.0 |
| 2006-07-17 11:00:00 | AAPL | Stock | 1.8714 | 1.8746 | 1.8654 | 1.8664 | 24675392.0 |
| 2006-07-17 11:05:00 | AAPL | Stock | 1.8664 | 1.8732 | 1.8643 | 1.8729 | 13258868.0 |
> showing 50 of 224,593 rows — these rows as CSV