PREVIEW / stock_5min / 2007-07-05
file: by_date/stock_5min/2007/2007-07-05.parquet size: 3.9 MB rows: 292,365 symbols: 3,033
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 |
|---|---|---|---|---|---|---|---|
| 2007-07-05 09:30:00 | AAPL | Stock | 4.6 | 4.6604 | 4.5961 | 4.6382 | 77680792.0 |
| 2007-07-05 09:35:00 | AAPL | Stock | 4.6386 | 4.7054 | 4.6361 | 4.6755 | 77408688.0 |
| 2007-07-05 09:40:00 | AAPL | Stock | 4.6754 | 4.6961 | 4.6521 | 4.6539 | 56398972.0 |
| 2007-07-05 09:45:00 | AAPL | Stock | 4.6539 | 4.6561 | 4.63 | 4.6364 | 55046376.0 |
| 2007-07-05 09:50:00 | AAPL | Stock | 4.6364 | 4.6718 | 4.6342 | 4.6514 | 33645192.0 |
| 2007-07-05 09:55:00 | AAPL | Stock | 4.6514 | 4.6554 | 4.6375 | 4.6507 | 29508332.0 |
| 2007-07-05 10:00:00 | AAPL | Stock | 4.6504 | 4.6643 | 4.6464 | 4.6571 | 25553724.0 |
| 2007-07-05 10:05:00 | AAPL | Stock | 4.6564 | 4.6571 | 4.6429 | 4.6539 | 28778568.0 |
| 2007-07-05 10:10:00 | AAPL | Stock | 4.6546 | 4.6639 | 4.6357 | 4.6529 | 34730052.0 |
| 2007-07-05 10:15:00 | AAPL | Stock | 4.6525 | 4.6718 | 4.6514 | 4.6711 | 29171072.0 |
| 2007-07-05 10:20:00 | AAPL | Stock | 4.6711 | 4.6786 | 4.6607 | 4.6704 | 25526676.0 |
| 2007-07-05 10:25:00 | AAPL | Stock | 4.67 | 4.6836 | 4.6582 | 4.67 | 25021276.0 |
| 2007-07-05 10:30:00 | AAPL | Stock | 4.67 | 4.6782 | 4.6682 | 4.6779 | 17513076.0 |
| 2007-07-05 10:35:00 | AAPL | Stock | 4.6773 | 4.6857 | 4.6714 | 4.6779 | 23729804.0 |
| 2007-07-05 10:40:00 | AAPL | Stock | 4.6775 | 4.6882 | 4.675 | 4.6857 | 19048764.0 |
| 2007-07-05 10:45:00 | AAPL | Stock | 4.6857 | 4.6939 | 4.6779 | 4.6871 | 25130952.0 |
| 2007-07-05 10:50:00 | AAPL | Stock | 4.6871 | 4.6879 | 4.6725 | 4.6839 | 20623288.0 |
| 2007-07-05 10:55:00 | AAPL | Stock | 4.684 | 4.6964 | 4.6825 | 4.6939 | 18386676.0 |
| 2007-07-05 11:00:00 | AAPL | Stock | 4.6946 | 4.6961 | 4.6696 | 4.6764 | 29904112.0 |
| 2007-07-05 11:05:00 | AAPL | Stock | 4.6768 | 4.6843 | 4.6675 | 4.67 | 18807460.0 |
| 2007-07-05 11:10:00 | AAPL | Stock | 4.67 | 4.6775 | 4.6657 | 4.6739 | 15626492.0 |
| 2007-07-05 11:15:00 | AAPL | Stock | 4.6739 | 4.6814 | 4.6625 | 4.6654 | 13247472.0 |
| 2007-07-05 11:20:00 | AAPL | Stock | 4.6668 | 4.6743 | 4.6654 | 4.6664 | 11391716.0 |
| 2007-07-05 11:25:00 | AAPL | Stock | 4.6666 | 4.6775 | 4.6661 | 4.675 | 7719152.0 |
| 2007-07-05 11:30:00 | AAPL | Stock | 4.6746 | 4.6768 | 4.6686 | 4.6764 | 7472332.0 |
| 2007-07-05 11:35:00 | AAPL | Stock | 4.6761 | 4.6854 | 4.6757 | 4.6804 | 10873856.0 |
| 2007-07-05 11:40:00 | AAPL | Stock | 4.6804 | 4.6861 | 4.6771 | 4.6807 | 11097884.0 |
| 2007-07-05 11:45:00 | AAPL | Stock | 4.6811 | 4.6839 | 4.6779 | 4.6829 | 8737764.0 |
| 2007-07-05 11:50:00 | AAPL | Stock | 4.6829 | 4.6829 | 4.6736 | 4.6743 | 7125832.0 |
| 2007-07-05 11:55:00 | AAPL | Stock | 4.6754 | 4.6768 | 4.6696 | 4.6732 | 7807632.0 |
| 2007-07-05 12:00:00 | AAPL | Stock | 4.6729 | 4.6768 | 4.67 | 4.6736 | 7116732.0 |
| 2007-07-05 12:05:00 | AAPL | Stock | 4.6736 | 4.6757 | 4.6711 | 4.6721 | 7606312.0 |
| 2007-07-05 12:10:00 | AAPL | Stock | 4.6718 | 4.6743 | 4.6696 | 4.6718 | 9338756.0 |
| 2007-07-05 12:15:00 | AAPL | Stock | 4.6718 | 4.6743 | 4.6679 | 4.6714 | 8387736.0 |
| 2007-07-05 12:20:00 | AAPL | Stock | 4.6714 | 4.6786 | 4.6714 | 4.675 | 7763056.0 |
| 2007-07-05 12:25:00 | AAPL | Stock | 4.675 | 4.6757 | 4.6679 | 4.6718 | 9633652.0 |
| 2007-07-05 12:30:00 | AAPL | Stock | 4.6718 | 4.6743 | 4.6629 | 4.6679 | 11108776.0 |
| 2007-07-05 12:35:00 | AAPL | Stock | 4.6679 | 4.6689 | 4.6539 | 4.6575 | 19493320.0 |
| 2007-07-05 12:40:00 | AAPL | Stock | 4.6569 | 4.6614 | 4.6532 | 4.6614 | 9481500.0 |
| 2007-07-05 12:45:00 | AAPL | Stock | 4.6614 | 4.6671 | 4.6579 | 4.6621 | 8571164.0 |
| 2007-07-05 12:50:00 | AAPL | Stock | 4.6625 | 4.6732 | 4.6604 | 4.6696 | 7458864.0 |
| 2007-07-05 12:55:00 | AAPL | Stock | 4.67 | 4.6721 | 4.6643 | 4.6654 | 5818708.0 |
| 2007-07-05 13:00:00 | AAPL | Stock | 4.6654 | 4.6693 | 4.6646 | 4.6686 | 3685248.0 |
| 2007-07-05 13:05:00 | AAPL | Stock | 4.6689 | 4.6693 | 4.6668 | 4.6686 | 2612260.0 |
| 2007-07-05 13:10:00 | AAPL | Stock | 4.6689 | 4.6746 | 4.6682 | 4.6732 | 7755076.0 |
| 2007-07-05 13:15:00 | AAPL | Stock | 4.6732 | 4.6764 | 4.6721 | 4.6736 | 6514480.0 |
| 2007-07-05 13:20:00 | AAPL | Stock | 4.6739 | 4.6757 | 4.6696 | 4.6739 | 4945248.0 |
| 2007-07-05 13:25:00 | AAPL | Stock | 4.6739 | 4.6742 | 4.67 | 4.6721 | 2850456.0 |
| 2007-07-05 13:30:00 | AAPL | Stock | 4.6721 | 4.6786 | 4.6711 | 4.6775 | 6532400.0 |
| 2007-07-05 13:35:00 | AAPL | Stock | 4.6775 | 4.6868 | 4.6768 | 4.6836 | 12643372.0 |
> showing 50 of 292,365 rows — these rows as CSV