PREVIEW / stock_5min / 2004-10-12
file: by_date/stock_5min/2004/2004-10-12.parquet size: 2.4 MB rows: 175,173 symbols: 1,841
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 |
|---|---|---|---|---|---|---|---|
| 2004-10-12 08:00:00 | AAPL | Stock | 0.6888 | 0.6938 | 0.6888 | 0.6888 | 100800.0 |
| 2004-10-12 08:05:00 | AAPL | Stock | 0.6888 | 0.6893 | 0.6857 | 0.6857 | 67200.0 |
| 2004-10-12 08:10:00 | AAPL | Stock | 0.6857 | 0.6857 | 0.6857 | 0.6857 | 5600.0 |
| 2004-10-12 08:25:00 | AAPL | Stock | 0.6827 | 0.6827 | 0.6827 | 0.6827 | 5600.0 |
| 2004-10-12 08:30:00 | AAPL | Stock | 0.6836 | 0.6836 | 0.6836 | 0.6836 | 5600.0 |
| 2004-10-12 09:00:00 | AAPL | Stock | 0.6834 | 0.6834 | 0.6834 | 0.6834 | 28000.0 |
| 2004-10-12 09:20:00 | AAPL | Stock | 0.6836 | 0.6836 | 0.6836 | 0.6836 | 5600.0 |
| 2004-10-12 09:25:00 | AAPL | Stock | 0.683 | 0.6873 | 0.683 | 0.6861 | 789600.0 |
| 2004-10-12 09:30:00 | AAPL | Stock | 0.6875 | 0.6875 | 0.6807 | 0.6832 | 11742136.0 |
| 2004-10-12 09:35:00 | AAPL | Stock | 0.6832 | 0.6846 | 0.682 | 0.6829 | 7090944.0 |
| 2004-10-12 09:40:00 | AAPL | Stock | 0.6829 | 0.6839 | 0.6798 | 0.6802 | 10708488.0 |
| 2004-10-12 09:45:00 | AAPL | Stock | 0.68 | 0.6821 | 0.6759 | 0.678 | 19223512.0 |
| 2004-10-12 09:50:00 | AAPL | Stock | 0.6784 | 0.6784 | 0.6757 | 0.6763 | 6951560.0 |
| 2004-10-12 09:55:00 | AAPL | Stock | 0.6763 | 0.6766 | 0.6752 | 0.6764 | 5075784.0 |
| 2004-10-12 10:00:00 | AAPL | Stock | 0.6763 | 0.6764 | 0.675 | 0.6755 | 6255256.0 |
| 2004-10-12 10:05:00 | AAPL | Stock | 0.6755 | 0.6759 | 0.6723 | 0.6757 | 9670752.0 |
| 2004-10-12 10:10:00 | AAPL | Stock | 0.6757 | 0.6798 | 0.675 | 0.6798 | 9375016.0 |
| 2004-10-12 10:15:00 | AAPL | Stock | 0.6796 | 0.68 | 0.6757 | 0.6775 | 10082632.0 |
| 2004-10-12 10:20:00 | AAPL | Stock | 0.6775 | 0.6782 | 0.6763 | 0.6777 | 5235440.0 |
| 2004-10-12 10:25:00 | AAPL | Stock | 0.6777 | 0.6777 | 0.6759 | 0.6764 | 3933048.0 |
| 2004-10-12 10:30:00 | AAPL | Stock | 0.6764 | 0.6798 | 0.6763 | 0.6788 | 4201176.0 |
| 2004-10-12 10:35:00 | AAPL | Stock | 0.6788 | 0.6798 | 0.678 | 0.6789 | 5916120.0 |
| 2004-10-12 10:40:00 | AAPL | Stock | 0.6786 | 0.6804 | 0.6773 | 0.6775 | 4495512.0 |
| 2004-10-12 10:45:00 | AAPL | Stock | 0.6775 | 0.68 | 0.6766 | 0.68 | 4557280.0 |
| 2004-10-12 10:50:00 | AAPL | Stock | 0.68 | 0.6807 | 0.6782 | 0.6795 | 2276568.0 |
| 2004-10-12 10:55:00 | AAPL | Stock | 0.6795 | 0.6798 | 0.6788 | 0.6795 | 1248240.0 |
| 2004-10-12 11:00:00 | AAPL | Stock | 0.6798 | 0.6811 | 0.6795 | 0.6804 | 2947728.0 |
| 2004-10-12 11:05:00 | AAPL | Stock | 0.6804 | 0.6811 | 0.6802 | 0.6807 | 4954040.0 |
| 2004-10-12 11:10:00 | AAPL | Stock | 0.6805 | 0.6821 | 0.68 | 0.6818 | 3723328.0 |
| 2004-10-12 11:15:00 | AAPL | Stock | 0.6818 | 0.6839 | 0.6814 | 0.683 | 4311776.0 |
| 2004-10-12 11:20:00 | AAPL | Stock | 0.6829 | 0.6845 | 0.6825 | 0.6845 | 3220672.0 |
| 2004-10-12 11:25:00 | AAPL | Stock | 0.6843 | 0.6845 | 0.6821 | 0.683 | 2267608.0 |
| 2004-10-12 11:30:00 | AAPL | Stock | 0.6832 | 0.687 | 0.6829 | 0.6868 | 6097952.0 |
| 2004-10-12 11:35:00 | AAPL | Stock | 0.6864 | 0.6873 | 0.6839 | 0.6843 | 4738272.0 |
| 2004-10-12 11:40:00 | AAPL | Stock | 0.6843 | 0.6861 | 0.683 | 0.6855 | 4227328.0 |
| 2004-10-12 11:45:00 | AAPL | Stock | 0.6857 | 0.6884 | 0.6845 | 0.687 | 6263600.0 |
| 2004-10-12 11:50:00 | AAPL | Stock | 0.6868 | 0.6889 | 0.6868 | 0.688 | 7337624.0 |
| 2004-10-12 11:55:00 | AAPL | Stock | 0.688 | 0.688 | 0.6866 | 0.6868 | 3014368.0 |
| 2004-10-12 12:00:00 | AAPL | Stock | 0.6868 | 0.687 | 0.6857 | 0.6863 | 3844960.0 |
| 2004-10-12 12:05:00 | AAPL | Stock | 0.6864 | 0.687 | 0.6846 | 0.6848 | 11043928.0 |
| 2004-10-12 12:10:00 | AAPL | Stock | 0.6848 | 0.6861 | 0.6836 | 0.6838 | 4958296.0 |
| 2004-10-12 12:15:00 | AAPL | Stock | 0.6841 | 0.6857 | 0.6839 | 0.685 | 6591088.0 |
| 2004-10-12 12:20:00 | AAPL | Stock | 0.685 | 0.6868 | 0.6841 | 0.685 | 3662344.0 |
| 2004-10-12 12:25:00 | AAPL | Stock | 0.6852 | 0.6866 | 0.6845 | 0.6866 | 7205464.0 |
| 2004-10-12 12:30:00 | AAPL | Stock | 0.6863 | 0.6864 | 0.6855 | 0.6859 | 910280.0 |
| 2004-10-12 12:35:00 | AAPL | Stock | 0.6855 | 0.6864 | 0.6855 | 0.6864 | 522032.0 |
| 2004-10-12 12:40:00 | AAPL | Stock | 0.6864 | 0.6866 | 0.6864 | 0.6864 | 800800.0 |
| 2004-10-12 12:45:00 | AAPL | Stock | 0.6864 | 0.6868 | 0.6846 | 0.685 | 3294872.0 |
| 2004-10-12 12:50:00 | AAPL | Stock | 0.685 | 0.6859 | 0.6841 | 0.6843 | 2001440.0 |
| 2004-10-12 12:55:00 | AAPL | Stock | 0.6843 | 0.6863 | 0.6843 | 0.6855 | 1729840.0 |
> showing 50 of 175,173 rows — these rows as CSV