PREVIEW / stock_5min / 2000-01-24
file: by_date/stock_5min/2000/2000-01-24.parquet size: 1.2 MB rows: 90,677 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-24 09:30:00 | AAPL | Stock | 0.9682 | 0.9754 | 0.9665 | 0.9682 | 9396800.0 |
| 2000-01-24 09:35:00 | AAPL | Stock | 0.966 | 0.9732 | 0.9643 | 0.9685 | 11547200.0 |
| 2000-01-24 09:40:00 | AAPL | Stock | 0.9665 | 0.9754 | 0.9665 | 0.9752 | 4513600.0 |
| 2000-01-24 09:45:00 | AAPL | Stock | 0.9749 | 0.9933 | 0.9749 | 0.9866 | 11233600.0 |
| 2000-01-24 09:50:00 | AAPL | Stock | 0.9911 | 0.9911 | 0.9863 | 0.9877 | 3068800.0 |
| 2000-01-24 09:55:00 | AAPL | Stock | 0.9877 | 0.9911 | 0.9788 | 0.9844 | 4267200.0 |
| 2000-01-24 10:00:00 | AAPL | Stock | 0.9844 | 0.9911 | 0.9821 | 0.983 | 3012800.0 |
| 2000-01-24 10:05:00 | AAPL | Stock | 0.9841 | 0.9888 | 0.9827 | 0.9866 | 2352000.0 |
| 2000-01-24 10:10:00 | AAPL | Stock | 0.9866 | 0.9983 | 0.9866 | 0.9955 | 15825600.0 |
| 2000-01-24 10:15:00 | AAPL | Stock | 0.9961 | 1.0067 | 0.9927 | 1.0017 | 10080000.0 |
| 2000-01-24 10:20:00 | AAPL | Stock | 1.0 | 1.0061 | 1.0 | 1.0028 | 4905600.0 |
| 2000-01-24 10:25:00 | AAPL | Stock | 1.0039 | 1.0053 | 0.9922 | 0.9922 | 4939200.0 |
| 2000-01-24 10:30:00 | AAPL | Stock | 0.9944 | 0.9994 | 0.9911 | 0.9989 | 5476800.0 |
| 2000-01-24 10:35:00 | AAPL | Stock | 0.9955 | 0.9978 | 0.99 | 0.9911 | 5622400.0 |
| 2000-01-24 10:40:00 | AAPL | Stock | 0.9933 | 0.9939 | 0.9877 | 0.9939 | 17796800.0 |
| 2000-01-24 10:45:00 | AAPL | Stock | 0.9936 | 0.9939 | 0.9821 | 0.9821 | 5006400.0 |
| 2000-01-24 10:50:00 | AAPL | Stock | 0.9855 | 0.9855 | 0.9788 | 0.9799 | 7649600.0 |
| 2000-01-24 10:55:00 | AAPL | Stock | 0.9799 | 0.9855 | 0.9788 | 0.9821 | 4524800.0 |
| 2000-01-24 11:00:00 | AAPL | Stock | 0.9816 | 0.9872 | 0.9816 | 0.986 | 5499200.0 |
| 2000-01-24 11:05:00 | AAPL | Stock | 0.9849 | 0.986 | 0.9799 | 0.9833 | 3024000.0 |
| 2000-01-24 11:10:00 | AAPL | Stock | 0.9821 | 0.9835 | 0.9799 | 0.9805 | 3539200.0 |
| 2000-01-24 11:15:00 | AAPL | Stock | 0.981 | 0.9844 | 0.9799 | 0.9838 | 18961600.0 |
| 2000-01-24 11:20:00 | AAPL | Stock | 0.9838 | 0.9849 | 0.981 | 0.981 | 5353600.0 |
| 2000-01-24 11:25:00 | AAPL | Stock | 0.981 | 0.9833 | 0.9799 | 0.981 | 6854400.0 |
| 2000-01-24 11:30:00 | AAPL | Stock | 0.9821 | 0.9827 | 0.9799 | 0.981 | 6496000.0 |
| 2000-01-24 11:35:00 | AAPL | Stock | 0.981 | 0.9821 | 0.9777 | 0.9805 | 1142400.0 |
| 2000-01-24 11:40:00 | AAPL | Stock | 0.9816 | 0.986 | 0.9799 | 0.9855 | 2284800.0 |
| 2000-01-24 11:45:00 | AAPL | Stock | 0.9844 | 0.9844 | 0.9816 | 0.9827 | 1859200.0 |
| 2000-01-24 11:50:00 | AAPL | Stock | 0.9816 | 0.9844 | 0.9816 | 0.9833 | 1881600.0 |
| 2000-01-24 11:55:00 | AAPL | Stock | 0.9833 | 0.9877 | 0.981 | 0.9833 | 1276800.0 |
| 2000-01-24 12:00:00 | AAPL | Stock | 0.9821 | 0.986 | 0.9816 | 0.9833 | 2240000.0 |
| 2000-01-24 12:05:00 | AAPL | Stock | 0.9833 | 0.986 | 0.9833 | 0.986 | 2195200.0 |
| 2000-01-24 12:10:00 | AAPL | Stock | 0.9849 | 0.9905 | 0.9833 | 0.9905 | 3740800.0 |
| 2000-01-24 12:15:00 | AAPL | Stock | 0.9905 | 0.9911 | 0.9877 | 0.9877 | 3180800.0 |
| 2000-01-24 12:20:00 | AAPL | Stock | 0.9883 | 0.9894 | 0.9883 | 0.9894 | 1299200.0 |
| 2000-01-24 12:25:00 | AAPL | Stock | 0.99 | 0.99 | 0.986 | 0.9888 | 6708800.0 |
| 2000-01-24 12:30:00 | AAPL | Stock | 0.9888 | 0.9888 | 0.9866 | 0.9883 | 1310400.0 |
| 2000-01-24 12:35:00 | AAPL | Stock | 0.9894 | 0.9944 | 0.9888 | 0.9927 | 3292800.0 |
| 2000-01-24 12:40:00 | AAPL | Stock | 0.9939 | 0.9944 | 0.9888 | 0.9927 | 5174400.0 |
| 2000-01-24 12:45:00 | AAPL | Stock | 0.9911 | 0.9944 | 0.9911 | 0.9944 | 1344000.0 |
| 2000-01-24 12:50:00 | AAPL | Stock | 0.9944 | 0.9944 | 0.9888 | 0.9888 | 1859200.0 |
| 2000-01-24 12:55:00 | AAPL | Stock | 0.9888 | 0.9927 | 0.9888 | 0.9922 | 2486400.0 |
| 2000-01-24 13:00:00 | AAPL | Stock | 0.9911 | 0.9911 | 0.9894 | 0.9905 | 1198400.0 |
| 2000-01-24 13:05:00 | AAPL | Stock | 0.9902 | 0.9905 | 0.9894 | 0.9894 | 1982400.0 |
| 2000-01-24 13:10:00 | AAPL | Stock | 0.99 | 0.99 | 0.9894 | 0.9894 | 3886400.0 |
| 2000-01-24 13:15:00 | AAPL | Stock | 0.9894 | 0.99 | 0.9872 | 0.9888 | 1937600.0 |
| 2000-01-24 13:20:00 | AAPL | Stock | 0.9888 | 0.9897 | 0.9883 | 0.9883 | 1086400.0 |
| 2000-01-24 13:25:00 | AAPL | Stock | 0.9883 | 0.9894 | 0.9877 | 0.9877 | 2598400.0 |
| 2000-01-24 13:30:00 | AAPL | Stock | 0.9877 | 0.9883 | 0.9866 | 0.9866 | 1736000.0 |
| 2000-01-24 13:35:00 | AAPL | Stock | 0.9872 | 0.9894 | 0.986 | 0.9877 | 1534400.0 |
> showing 50 of 90,677 rows — these rows as CSV