PREVIEW / stock_5min / 2007-08-23
file: by_date/stock_5min/2007/2007-08-23.parquet size: 4.0 MB rows: 296,832 symbols: 3,108
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-08-23 09:30:00 | AAPL | Stock | 4.7532 | 4.7621 | 4.7243 | 4.7264 | 34249376.0 |
| 2007-08-23 09:35:00 | AAPL | Stock | 4.7261 | 4.7371 | 4.7057 | 4.7186 | 31439128.0 |
| 2007-08-23 09:40:00 | AAPL | Stock | 4.7186 | 4.7214 | 4.7007 | 4.7111 | 24847508.0 |
| 2007-08-23 09:45:00 | AAPL | Stock | 4.7118 | 4.7229 | 4.7086 | 4.7154 | 16816632.0 |
| 2007-08-23 09:50:00 | AAPL | Stock | 4.7154 | 4.7286 | 4.6921 | 4.702 | 20526660.0 |
| 2007-08-23 09:55:00 | AAPL | Stock | 4.7025 | 4.7243 | 4.7007 | 4.7214 | 14054600.0 |
| 2007-08-23 10:00:00 | AAPL | Stock | 4.7207 | 4.7454 | 4.7161 | 4.7268 | 23413292.0 |
| 2007-08-23 10:05:00 | AAPL | Stock | 4.7268 | 4.7343 | 4.7115 | 4.7125 | 12834248.0 |
| 2007-08-23 10:10:00 | AAPL | Stock | 4.7121 | 4.7207 | 4.7071 | 4.7129 | 12124784.0 |
| 2007-08-23 10:15:00 | AAPL | Stock | 4.7136 | 4.7143 | 4.7029 | 4.7054 | 10933888.0 |
| 2007-08-23 10:20:00 | AAPL | Stock | 4.705 | 4.7096 | 4.6975 | 4.7043 | 12616352.0 |
| 2007-08-23 10:25:00 | AAPL | Stock | 4.7036 | 4.7071 | 4.6754 | 4.6868 | 22511048.0 |
| 2007-08-23 10:30:00 | AAPL | Stock | 4.6868 | 4.6889 | 4.6732 | 4.6809 | 9353148.0 |
| 2007-08-23 10:35:00 | AAPL | Stock | 4.6804 | 4.6918 | 4.6804 | 4.685 | 7184324.0 |
| 2007-08-23 10:40:00 | AAPL | Stock | 4.6854 | 4.6904 | 4.68 | 4.6829 | 6961668.0 |
| 2007-08-23 10:45:00 | AAPL | Stock | 4.6832 | 4.6954 | 4.6821 | 4.6946 | 7525448.0 |
| 2007-08-23 10:50:00 | AAPL | Stock | 4.6948 | 4.7054 | 4.6946 | 4.695 | 11855788.0 |
| 2007-08-23 10:55:00 | AAPL | Stock | 4.6964 | 4.6971 | 4.6871 | 4.6896 | 7217980.0 |
| 2007-08-23 11:00:00 | AAPL | Stock | 4.69 | 4.6904 | 4.6786 | 4.681 | 10341884.0 |
| 2007-08-23 11:05:00 | AAPL | Stock | 4.6789 | 4.6829 | 4.6743 | 4.6782 | 7741804.0 |
| 2007-08-23 11:10:00 | AAPL | Stock | 4.6779 | 4.6786 | 4.6607 | 4.6686 | 16342480.0 |
| 2007-08-23 11:15:00 | AAPL | Stock | 4.6679 | 4.6821 | 4.6643 | 4.6811 | 6874308.0 |
| 2007-08-23 11:20:00 | AAPL | Stock | 4.6811 | 4.6871 | 4.6714 | 4.6857 | 7321244.0 |
| 2007-08-23 11:25:00 | AAPL | Stock | 4.6857 | 4.6954 | 4.6711 | 4.6711 | 10033072.0 |
| 2007-08-23 11:30:00 | AAPL | Stock | 4.6711 | 4.675 | 4.6661 | 4.6707 | 8278592.0 |
| 2007-08-23 11:35:00 | AAPL | Stock | 4.6707 | 4.6801 | 4.6661 | 4.6801 | 7395836.0 |
| 2007-08-23 11:40:00 | AAPL | Stock | 4.6796 | 4.685 | 4.6768 | 4.6786 | 5729808.0 |
| 2007-08-23 11:45:00 | AAPL | Stock | 4.6779 | 4.6843 | 4.6739 | 4.675 | 4440212.0 |
| 2007-08-23 11:50:00 | AAPL | Stock | 4.675 | 4.675 | 4.6629 | 4.6668 | 8900752.0 |
| 2007-08-23 11:55:00 | AAPL | Stock | 4.6664 | 4.6689 | 4.6482 | 4.6486 | 12401900.0 |
| 2007-08-23 12:00:00 | AAPL | Stock | 4.6482 | 4.665 | 4.6482 | 4.6622 | 9635052.0 |
| 2007-08-23 12:05:00 | AAPL | Stock | 4.6625 | 4.6732 | 4.6618 | 4.6625 | 11861108.0 |
| 2007-08-23 12:10:00 | AAPL | Stock | 4.6629 | 4.6786 | 4.6604 | 4.6764 | 8467396.0 |
| 2007-08-23 12:15:00 | AAPL | Stock | 4.6768 | 4.6846 | 4.6761 | 4.6821 | 7120092.0 |
| 2007-08-23 12:20:00 | AAPL | Stock | 4.6821 | 4.69 | 4.6809 | 4.6879 | 7806400.0 |
| 2007-08-23 12:25:00 | AAPL | Stock | 4.6886 | 4.6889 | 4.6775 | 4.6846 | 6169632.0 |
| 2007-08-23 12:30:00 | AAPL | Stock | 4.685 | 4.6871 | 4.6761 | 4.6786 | 5547640.0 |
| 2007-08-23 12:35:00 | AAPL | Stock | 4.6786 | 4.6921 | 4.6782 | 4.6857 | 6905052.0 |
| 2007-08-23 12:40:00 | AAPL | Stock | 4.6858 | 4.6929 | 4.6786 | 4.6789 | 6701380.0 |
| 2007-08-23 12:45:00 | AAPL | Stock | 4.6789 | 4.6832 | 4.6746 | 4.6807 | 6345444.0 |
| 2007-08-23 12:50:00 | AAPL | Stock | 4.6811 | 4.6829 | 4.6539 | 4.6586 | 10948504.0 |
| 2007-08-23 12:55:00 | AAPL | Stock | 4.6589 | 4.6625 | 4.6518 | 4.6554 | 10136616.0 |
| 2007-08-23 13:00:00 | AAPL | Stock | 4.6554 | 4.6596 | 4.6343 | 4.635 | 20255312.0 |
| 2007-08-23 13:05:00 | AAPL | Stock | 4.6357 | 4.655 | 4.6346 | 4.65 | 13206284.0 |
| 2007-08-23 13:10:00 | AAPL | Stock | 4.6504 | 4.6689 | 4.6482 | 4.6644 | 11453008.0 |
| 2007-08-23 13:15:00 | AAPL | Stock | 4.6646 | 4.6657 | 4.6543 | 4.6561 | 6621356.0 |
| 2007-08-23 13:20:00 | AAPL | Stock | 4.6561 | 4.66 | 4.6471 | 4.6509 | 4513236.0 |
| 2007-08-23 13:25:00 | AAPL | Stock | 4.6518 | 4.6518 | 4.6457 | 4.6511 | 4464152.0 |
| 2007-08-23 13:30:00 | AAPL | Stock | 4.6514 | 4.6546 | 4.645 | 4.6454 | 5790484.0 |
| 2007-08-23 13:35:00 | AAPL | Stock | 4.6461 | 4.6593 | 4.645 | 4.6557 | 7051576.0 |
> showing 50 of 296,832 rows — these rows as CSV