PREVIEW / stock_5min / 2005-09-01
file: by_date/stock_5min/2005/2005-09-01.parquet size: 2.9 MB rows: 208,571 symbols: 2,077
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-09-01 08:00:00 | AAPL | Stock | 1.675 | 1.6757 | 1.675 | 1.6754 | 36400.0 |
| 2005-09-01 08:10:00 | AAPL | Stock | 1.6754 | 1.6754 | 1.6754 | 1.6754 | 8400.0 |
| 2005-09-01 08:20:00 | AAPL | Stock | 1.6757 | 1.6757 | 1.6757 | 1.6757 | 2800.0 |
| 2005-09-01 08:25:00 | AAPL | Stock | 1.6779 | 1.6779 | 1.6768 | 1.6768 | 8456.0 |
| 2005-09-01 08:30:00 | AAPL | Stock | 1.6757 | 1.6757 | 1.6746 | 1.6746 | 50400.0 |
| 2005-09-01 08:35:00 | AAPL | Stock | 1.6764 | 1.6786 | 1.6746 | 1.6786 | 86800.0 |
| 2005-09-01 08:40:00 | AAPL | Stock | 1.6786 | 1.6804 | 1.6786 | 1.6804 | 73696.0 |
| 2005-09-01 08:45:00 | AAPL | Stock | 1.6804 | 1.6843 | 1.6804 | 1.6843 | 224000.0 |
| 2005-09-01 08:50:00 | AAPL | Stock | 1.6821 | 1.6829 | 1.6821 | 1.6821 | 61600.0 |
| 2005-09-01 08:55:00 | AAPL | Stock | 1.6804 | 1.6804 | 1.6804 | 1.6804 | 16296.0 |
| 2005-09-01 09:00:00 | AAPL | Stock | 1.6746 | 1.6804 | 1.6746 | 1.6804 | 30772.0 |
| 2005-09-01 09:15:00 | AAPL | Stock | 1.6804 | 1.6804 | 1.6804 | 1.6804 | 8400.0 |
| 2005-09-01 09:20:00 | AAPL | Stock | 1.6761 | 1.6789 | 1.6761 | 1.6786 | 2259600.0 |
| 2005-09-01 09:25:00 | AAPL | Stock | 1.6782 | 1.6786 | 1.675 | 1.675 | 1070132.0 |
| 2005-09-01 09:30:00 | AAPL | Stock | 1.6786 | 1.6786 | 1.6668 | 1.6679 | 21670236.0 |
| 2005-09-01 09:35:00 | AAPL | Stock | 1.6682 | 1.6786 | 1.6679 | 1.6775 | 16680440.0 |
| 2005-09-01 09:40:00 | AAPL | Stock | 1.6779 | 1.6789 | 1.6739 | 1.6757 | 8536864.0 |
| 2005-09-01 09:45:00 | AAPL | Stock | 1.6757 | 1.6814 | 1.6754 | 1.6807 | 6360900.0 |
| 2005-09-01 09:50:00 | AAPL | Stock | 1.6811 | 1.6846 | 1.68 | 1.6815 | 9596664.0 |
| 2005-09-01 09:55:00 | AAPL | Stock | 1.6818 | 1.6818 | 1.6761 | 1.6775 | 4654664.0 |
| 2005-09-01 10:00:00 | AAPL | Stock | 1.6775 | 1.6775 | 1.6714 | 1.6739 | 8888180.0 |
| 2005-09-01 10:05:00 | AAPL | Stock | 1.6739 | 1.6746 | 1.6696 | 1.67 | 4793236.0 |
| 2005-09-01 10:10:00 | AAPL | Stock | 1.6696 | 1.6721 | 1.6689 | 1.6718 | 5699204.0 |
| 2005-09-01 10:15:00 | AAPL | Stock | 1.6718 | 1.6739 | 1.6675 | 1.6686 | 6296136.0 |
| 2005-09-01 10:20:00 | AAPL | Stock | 1.6685 | 1.6768 | 1.6682 | 1.6711 | 5279148.0 |
| 2005-09-01 10:25:00 | AAPL | Stock | 1.6707 | 1.6714 | 1.6664 | 1.6689 | 4376764.0 |
| 2005-09-01 10:30:00 | AAPL | Stock | 1.6689 | 1.6689 | 1.6621 | 1.6621 | 6010928.0 |
| 2005-09-01 10:35:00 | AAPL | Stock | 1.6629 | 1.6664 | 1.6614 | 1.6618 | 4544008.0 |
| 2005-09-01 10:40:00 | AAPL | Stock | 1.6615 | 1.6664 | 1.6615 | 1.6657 | 4351956.0 |
| 2005-09-01 10:45:00 | AAPL | Stock | 1.6657 | 1.6671 | 1.6646 | 1.665 | 3267068.0 |
| 2005-09-01 10:50:00 | AAPL | Stock | 1.665 | 1.6693 | 1.665 | 1.6689 | 3713024.0 |
| 2005-09-01 10:55:00 | AAPL | Stock | 1.6689 | 1.6786 | 1.6679 | 1.6682 | 2047388.0 |
| 2005-09-01 11:00:00 | AAPL | Stock | 1.6682 | 1.67 | 1.6679 | 1.6686 | 2965816.0 |
| 2005-09-01 11:05:00 | AAPL | Stock | 1.6682 | 1.6682 | 1.6636 | 1.6639 | 3973088.0 |
| 2005-09-01 11:10:00 | AAPL | Stock | 1.6643 | 1.6679 | 1.6632 | 1.6661 | 10088316.0 |
| 2005-09-01 11:15:00 | AAPL | Stock | 1.6664 | 1.675 | 1.6646 | 1.665 | 6146084.0 |
| 2005-09-01 11:20:00 | AAPL | Stock | 1.6654 | 1.6714 | 1.665 | 1.6668 | 7438956.0 |
| 2005-09-01 11:25:00 | AAPL | Stock | 1.6668 | 1.6671 | 1.6643 | 1.6661 | 4079768.0 |
| 2005-09-01 11:30:00 | AAPL | Stock | 1.6664 | 1.6693 | 1.6639 | 1.6679 | 4307604.0 |
| 2005-09-01 11:35:00 | AAPL | Stock | 1.6675 | 1.6707 | 1.6661 | 1.6693 | 4417980.0 |
| 2005-09-01 11:40:00 | AAPL | Stock | 1.6693 | 1.6743 | 1.6693 | 1.6696 | 8210384.0 |
| 2005-09-01 11:45:00 | AAPL | Stock | 1.6693 | 1.6721 | 1.6675 | 1.6686 | 3260908.0 |
| 2005-09-01 11:50:00 | AAPL | Stock | 1.6686 | 1.6693 | 1.6664 | 1.6693 | 3751272.0 |
| 2005-09-01 11:55:00 | AAPL | Stock | 1.6693 | 1.67 | 1.6668 | 1.6679 | 2127580.0 |
| 2005-09-01 12:00:00 | AAPL | Stock | 1.6679 | 1.6679 | 1.6643 | 1.6661 | 3120544.0 |
| 2005-09-01 12:05:00 | AAPL | Stock | 1.6657 | 1.6686 | 1.6657 | 1.6682 | 2095548.0 |
| 2005-09-01 12:10:00 | AAPL | Stock | 1.6682 | 1.6689 | 1.6643 | 1.6668 | 1619072.0 |
| 2005-09-01 12:15:00 | AAPL | Stock | 1.6671 | 1.6675 | 1.6646 | 1.6646 | 939008.0 |
| 2005-09-01 12:20:00 | AAPL | Stock | 1.665 | 1.6661 | 1.6636 | 1.6646 | 3319596.0 |
| 2005-09-01 12:25:00 | AAPL | Stock | 1.6646 | 1.6654 | 1.6629 | 1.665 | 1826552.0 |
> showing 50 of 208,571 rows — these rows as CSV