PREVIEW / stock_5min / 2000-01-27
file: by_date/stock_5min/2000/2000-01-27.parquet size: 1.1 MB rows: 86,337 symbols: 1,129
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 |
|---|---|---|---|---|---|---|---|
| 2000-01-27 09:30:00 | AAPL | Stock | 0.9715 | 0.9754 | 0.9688 | 0.9688 | 7280000.0 |
| 2000-01-27 09:35:00 | AAPL | Stock | 0.9704 | 0.9933 | 0.9648 | 0.9916 | 8344000.0 |
| 2000-01-27 09:40:00 | AAPL | Stock | 0.9916 | 0.9922 | 0.9732 | 0.9908 | 6126400.0 |
| 2000-01-27 09:45:00 | AAPL | Stock | 0.9908 | 1.0033 | 0.9821 | 0.9989 | 6753600.0 |
| 2000-01-27 09:50:00 | AAPL | Stock | 0.9939 | 0.9967 | 0.9866 | 0.995 | 3147200.0 |
| 2000-01-27 09:55:00 | AAPL | Stock | 0.9972 | 1.0028 | 0.995 | 1.0011 | 4211200.0 |
| 2000-01-27 10:00:00 | AAPL | Stock | 1.0014 | 1.0089 | 0.9994 | 1.0067 | 6384000.0 |
| 2000-01-27 10:05:00 | AAPL | Stock | 1.0089 | 1.0089 | 0.9978 | 0.9983 | 7347200.0 |
| 2000-01-27 10:10:00 | AAPL | Stock | 1.0 | 1.0 | 0.9972 | 0.9978 | 2161600.0 |
| 2000-01-27 10:15:00 | AAPL | Stock | 0.9978 | 1.0067 | 0.9978 | 1.0047 | 3976000.0 |
| 2000-01-27 10:20:00 | AAPL | Stock | 1.0033 | 1.0061 | 0.9978 | 0.9983 | 3696000.0 |
| 2000-01-27 10:25:00 | AAPL | Stock | 0.9978 | 0.9989 | 0.99 | 0.99 | 4390400.0 |
| 2000-01-27 10:30:00 | AAPL | Stock | 0.9902 | 0.9922 | 0.9866 | 0.9922 | 4715200.0 |
| 2000-01-27 10:35:00 | AAPL | Stock | 0.9877 | 0.9922 | 0.9844 | 0.9855 | 3203200.0 |
| 2000-01-27 10:40:00 | AAPL | Stock | 0.9849 | 1.0 | 0.9849 | 0.9916 | 3718400.0 |
| 2000-01-27 10:45:00 | AAPL | Stock | 0.9916 | 0.9989 | 0.99 | 0.9983 | 2912000.0 |
| 2000-01-27 10:50:00 | AAPL | Stock | 0.9989 | 1.0022 | 0.9955 | 1.0017 | 4267200.0 |
| 2000-01-27 10:55:00 | AAPL | Stock | 0.9989 | 1.0033 | 0.9978 | 1.0022 | 2867200.0 |
| 2000-01-27 11:00:00 | AAPL | Stock | 1.0022 | 1.005 | 1.0 | 1.0039 | 3315200.0 |
| 2000-01-27 11:05:00 | AAPL | Stock | 1.0033 | 1.005 | 1.0 | 1.0022 | 2195200.0 |
| 2000-01-27 11:10:00 | AAPL | Stock | 1.0017 | 1.0056 | 0.9955 | 0.9955 | 1859200.0 |
| 2000-01-27 11:15:00 | AAPL | Stock | 0.9944 | 0.9983 | 0.9877 | 0.9911 | 5051200.0 |
| 2000-01-27 11:20:00 | AAPL | Stock | 0.9911 | 0.9922 | 0.9877 | 0.9911 | 1243200.0 |
| 2000-01-27 11:25:00 | AAPL | Stock | 0.9922 | 0.9939 | 0.9821 | 0.9833 | 3113600.0 |
| 2000-01-27 11:30:00 | AAPL | Stock | 0.9833 | 0.9888 | 0.9827 | 0.9888 | 1680000.0 |
| 2000-01-27 11:35:00 | AAPL | Stock | 0.9888 | 0.9911 | 0.9844 | 0.9844 | 2184000.0 |
| 2000-01-27 11:40:00 | AAPL | Stock | 0.9855 | 0.99 | 0.9821 | 0.99 | 4412800.0 |
| 2000-01-27 11:45:00 | AAPL | Stock | 0.99 | 0.9911 | 0.9844 | 0.9849 | 4345600.0 |
| 2000-01-27 11:50:00 | AAPL | Stock | 0.9844 | 0.9849 | 0.9821 | 0.9827 | 4300800.0 |
| 2000-01-27 11:55:00 | AAPL | Stock | 0.9821 | 0.9888 | 0.9821 | 0.9874 | 4614400.0 |
| 2000-01-27 12:00:00 | AAPL | Stock | 0.9844 | 0.99 | 0.9844 | 0.9888 | 1545600.0 |
| 2000-01-27 12:05:00 | AAPL | Stock | 0.9888 | 0.9933 | 0.9888 | 0.99 | 3584000.0 |
| 2000-01-27 12:10:00 | AAPL | Stock | 0.9894 | 0.9933 | 0.9888 | 0.99 | 2016000.0 |
| 2000-01-27 12:15:00 | AAPL | Stock | 0.9916 | 0.9916 | 0.99 | 0.99 | 22400.0 |
| 2000-01-27 12:20:00 | AAPL | Stock | 0.9911 | 0.9969 | 0.99 | 0.9916 | 1142400.0 |
| 2000-01-27 12:25:00 | AAPL | Stock | 0.9927 | 0.9955 | 0.9866 | 0.9866 | 2072000.0 |
| 2000-01-27 12:30:00 | AAPL | Stock | 0.9866 | 0.9872 | 0.9821 | 0.9821 | 2520000.0 |
| 2000-01-27 12:35:00 | AAPL | Stock | 0.9827 | 0.9827 | 0.9788 | 0.9805 | 4513600.0 |
| 2000-01-27 12:40:00 | AAPL | Stock | 0.9805 | 0.9816 | 0.9777 | 0.9777 | 3785600.0 |
| 2000-01-27 12:45:00 | AAPL | Stock | 0.9766 | 0.9766 | 0.971 | 0.971 | 3225600.0 |
| 2000-01-27 12:50:00 | AAPL | Stock | 0.971 | 0.971 | 0.9643 | 0.9643 | 3572800.0 |
| 2000-01-27 12:55:00 | AAPL | Stock | 0.9643 | 0.9699 | 0.9643 | 0.9693 | 3427200.0 |
| 2000-01-27 13:00:00 | AAPL | Stock | 0.9688 | 0.9754 | 0.9688 | 0.9754 | 2262400.0 |
| 2000-01-27 13:05:00 | AAPL | Stock | 0.9754 | 0.9805 | 0.9743 | 0.9766 | 1892800.0 |
| 2000-01-27 13:10:00 | AAPL | Stock | 0.9766 | 0.9805 | 0.9704 | 0.9788 | 5622400.0 |
| 2000-01-27 13:15:00 | AAPL | Stock | 0.9788 | 0.9788 | 0.9721 | 0.9732 | 2744000.0 |
| 2000-01-27 13:20:00 | AAPL | Stock | 0.9732 | 0.9799 | 0.9721 | 0.9794 | 2665600.0 |
| 2000-01-27 13:25:00 | AAPL | Stock | 0.9821 | 0.9821 | 0.9743 | 0.9749 | 1568000.0 |
| 2000-01-27 13:30:00 | AAPL | Stock | 0.9749 | 0.981 | 0.9743 | 0.9749 | 940800.0 |
| 2000-01-27 13:35:00 | AAPL | Stock | 0.9749 | 0.9766 | 0.9749 | 0.9749 | 448000.0 |
> showing 50 of 86,337 rows — these rows as CSV