PREVIEW / stock_5min / 2006-10-30
file: by_date/stock_5min/2006/2006-10-30.parquet size: 3.2 MB rows: 233,659 symbols: 2,427
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-10-30 04:35:00 | AAPL | Stock | 2.8643 | 2.8643 | 2.8643 | 2.8643 | 2800.0 |
| 2006-10-30 07:45:00 | AAPL | Stock | 2.8643 | 2.8643 | 2.8643 | 2.8643 | 2800.0 |
| 2006-10-30 08:00:00 | AAPL | Stock | 2.8643 | 2.8643 | 2.8607 | 2.8607 | 208600.0 |
| 2006-10-30 08:05:00 | AAPL | Stock | 2.8625 | 2.8682 | 2.8611 | 2.8682 | 249228.0 |
| 2006-10-30 08:10:00 | AAPL | Stock | 2.8625 | 2.8679 | 2.8625 | 2.8679 | 8400.0 |
| 2006-10-30 08:15:00 | AAPL | Stock | 2.8696 | 2.8696 | 2.8629 | 2.8629 | 19600.0 |
| 2006-10-30 08:20:00 | AAPL | Stock | 2.8629 | 2.8629 | 2.8625 | 2.8625 | 27972.0 |
| 2006-10-30 08:25:00 | AAPL | Stock | 2.8625 | 2.8696 | 2.8625 | 2.8629 | 102788.0 |
| 2006-10-30 08:30:00 | AAPL | Stock | 2.8629 | 2.8639 | 2.8625 | 2.8625 | 37800.0 |
| 2006-10-30 08:35:00 | AAPL | Stock | 2.8625 | 2.8639 | 2.8625 | 2.8636 | 89600.0 |
| 2006-10-30 08:40:00 | AAPL | Stock | 2.8639 | 2.8646 | 2.8639 | 2.8643 | 28000.0 |
| 2006-10-30 08:45:00 | AAPL | Stock | 2.8643 | 2.8643 | 2.8643 | 2.8643 | 68600.0 |
| 2006-10-30 08:50:00 | AAPL | Stock | 2.8643 | 2.8643 | 2.8643 | 2.8643 | 7000.0 |
| 2006-10-30 09:00:00 | AAPL | Stock | 2.8657 | 2.8657 | 2.8654 | 2.8654 | 112000.0 |
| 2006-10-30 09:05:00 | AAPL | Stock | 2.8643 | 2.8643 | 2.8639 | 2.8639 | 62440.0 |
| 2006-10-30 09:10:00 | AAPL | Stock | 2.8654 | 2.8654 | 2.8618 | 2.8618 | 14000.0 |
| 2006-10-30 09:20:00 | AAPL | Stock | 2.8654 | 2.8707 | 2.8621 | 2.8621 | 209580.0 |
| 2006-10-30 09:25:00 | AAPL | Stock | 2.8661 | 2.8679 | 2.8557 | 2.8575 | 1119692.0 |
| 2006-10-30 09:30:00 | AAPL | Stock | 2.8566 | 2.8607 | 2.8393 | 2.8479 | 35585648.0 |
| 2006-10-30 09:35:00 | AAPL | Stock | 2.8486 | 2.8571 | 2.8461 | 2.8525 | 14485744.0 |
| 2006-10-30 09:40:00 | AAPL | Stock | 2.8525 | 2.8571 | 2.8489 | 2.8561 | 14564676.0 |
| 2006-10-30 09:45:00 | AAPL | Stock | 2.8561 | 2.8625 | 2.855 | 2.8589 | 13693344.0 |
| 2006-10-30 09:50:00 | AAPL | Stock | 2.8589 | 2.8646 | 2.8554 | 2.8611 | 10522848.0 |
| 2006-10-30 09:55:00 | AAPL | Stock | 2.8607 | 2.8607 | 2.8525 | 2.8561 | 11984308.0 |
| 2006-10-30 10:00:00 | AAPL | Stock | 2.8561 | 2.8568 | 2.85 | 2.8539 | 7988904.0 |
| 2006-10-30 10:05:00 | AAPL | Stock | 2.8532 | 2.8554 | 2.8482 | 2.8543 | 6772836.0 |
| 2006-10-30 10:10:00 | AAPL | Stock | 2.8546 | 2.8557 | 2.8504 | 2.8546 | 8039696.0 |
| 2006-10-30 10:15:00 | AAPL | Stock | 2.8546 | 2.8621 | 2.8546 | 2.86 | 13814024.0 |
| 2006-10-30 10:20:00 | AAPL | Stock | 2.8598 | 2.8661 | 2.8586 | 2.8611 | 9531340.0 |
| 2006-10-30 10:25:00 | AAPL | Stock | 2.8611 | 2.8611 | 2.8554 | 2.8561 | 7365820.0 |
| 2006-10-30 10:30:00 | AAPL | Stock | 2.8561 | 2.8604 | 2.8554 | 2.8557 | 5720064.0 |
| 2006-10-30 10:35:00 | AAPL | Stock | 2.8561 | 2.8604 | 2.8557 | 2.8593 | 5874932.0 |
| 2006-10-30 10:40:00 | AAPL | Stock | 2.8593 | 2.8643 | 2.8586 | 2.8587 | 8912932.0 |
| 2006-10-30 10:45:00 | AAPL | Stock | 2.8604 | 2.8607 | 2.8564 | 2.8596 | 4662084.0 |
| 2006-10-30 10:50:00 | AAPL | Stock | 2.8596 | 2.8625 | 2.8586 | 2.8607 | 4868500.0 |
| 2006-10-30 10:55:00 | AAPL | Stock | 2.8611 | 2.865 | 2.8604 | 2.8643 | 6704068.0 |
| 2006-10-30 11:00:00 | AAPL | Stock | 2.8643 | 2.8743 | 2.8643 | 2.8736 | 14129052.0 |
| 2006-10-30 11:05:00 | AAPL | Stock | 2.8739 | 2.8779 | 2.8729 | 2.8761 | 9140012.0 |
| 2006-10-30 11:10:00 | AAPL | Stock | 2.8761 | 2.8846 | 2.8746 | 2.8814 | 12182128.0 |
| 2006-10-30 11:15:00 | AAPL | Stock | 2.8817 | 2.8832 | 2.8789 | 2.8807 | 6679764.0 |
| 2006-10-30 11:20:00 | AAPL | Stock | 2.8807 | 2.8843 | 2.8796 | 2.8829 | 6237616.0 |
| 2006-10-30 11:25:00 | AAPL | Stock | 2.8832 | 2.8854 | 2.8786 | 2.8839 | 7369348.0 |
| 2006-10-30 11:30:00 | AAPL | Stock | 2.8843 | 2.885 | 2.8771 | 2.8782 | 5173364.0 |
| 2006-10-30 11:35:00 | AAPL | Stock | 2.8779 | 2.8804 | 2.8607 | 2.8751 | 5306980.0 |
| 2006-10-30 11:40:00 | AAPL | Stock | 2.8754 | 2.8768 | 2.8721 | 2.8729 | 4557588.0 |
| 2006-10-30 11:45:00 | AAPL | Stock | 2.8725 | 2.8732 | 2.8704 | 2.8711 | 2730252.0 |
| 2006-10-30 11:50:00 | AAPL | Stock | 2.8714 | 2.8739 | 2.8686 | 2.8693 | 4119500.0 |
| 2006-10-30 11:55:00 | AAPL | Stock | 2.8693 | 2.8718 | 2.8661 | 2.8675 | 7407316.0 |
| 2006-10-30 12:00:00 | AAPL | Stock | 2.8679 | 2.8689 | 2.8629 | 2.8668 | 5364912.0 |
| 2006-10-30 12:05:00 | AAPL | Stock | 2.8668 | 2.8668 | 2.8586 | 2.8625 | 4314268.0 |
> showing 50 of 233,659 rows — these rows as CSV