PREVIEW / stock_5min / 2004-11-12
file: by_date/stock_5min/2004/2004-11-12.parquet size: 2.5 MB rows: 181,927 symbols: 1,864
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-11-12 08:05:00 | AAPL | Stock | 0.9882 | 0.9882 | 0.9882 | 0.9882 | 5600.0 |
| 2004-11-12 08:10:00 | AAPL | Stock | 0.9882 | 0.9882 | 0.9882 | 0.9882 | 5600.0 |
| 2004-11-12 08:25:00 | AAPL | Stock | 0.9882 | 0.9882 | 0.9882 | 0.9882 | 11200.0 |
| 2004-11-12 08:30:00 | AAPL | Stock | 0.9863 | 0.9863 | 0.9832 | 0.9832 | 56560.0 |
| 2004-11-12 08:35:00 | AAPL | Stock | 0.9898 | 0.9898 | 0.9857 | 0.9871 | 61600.0 |
| 2004-11-12 08:50:00 | AAPL | Stock | 0.9871 | 0.9871 | 0.9871 | 0.9871 | 22400.0 |
| 2004-11-12 08:55:00 | AAPL | Stock | 0.9871 | 0.9871 | 0.987 | 0.9871 | 67200.0 |
| 2004-11-12 09:00:00 | AAPL | Stock | 0.9864 | 0.9864 | 0.9864 | 0.9864 | 28000.0 |
| 2004-11-12 09:15:00 | AAPL | Stock | 0.9854 | 0.9866 | 0.9852 | 0.9863 | 61600.0 |
| 2004-11-12 09:20:00 | AAPL | Stock | 0.9863 | 0.9863 | 0.9857 | 0.9857 | 50400.0 |
| 2004-11-12 09:25:00 | AAPL | Stock | 0.9866 | 0.9866 | 0.9827 | 0.9827 | 392000.0 |
| 2004-11-12 09:30:00 | AAPL | Stock | 0.9823 | 0.9884 | 0.982 | 0.9832 | 16228128.0 |
| 2004-11-12 09:35:00 | AAPL | Stock | 0.9832 | 0.9843 | 0.9793 | 0.9823 | 7615944.0 |
| 2004-11-12 09:40:00 | AAPL | Stock | 0.9827 | 0.9855 | 0.9813 | 0.9839 | 8440488.0 |
| 2004-11-12 09:45:00 | AAPL | Stock | 0.9843 | 0.9882 | 0.9832 | 0.9832 | 6742960.0 |
| 2004-11-12 09:50:00 | AAPL | Stock | 0.9834 | 0.9848 | 0.9827 | 0.9838 | 5241488.0 |
| 2004-11-12 09:55:00 | AAPL | Stock | 0.9838 | 0.9879 | 0.9834 | 0.9868 | 5402096.0 |
| 2004-11-12 10:00:00 | AAPL | Stock | 0.9871 | 0.9945 | 0.9864 | 0.9916 | 26811960.0 |
| 2004-11-12 10:05:00 | AAPL | Stock | 0.9911 | 0.9911 | 0.9891 | 0.9898 | 7838880.0 |
| 2004-11-12 10:10:00 | AAPL | Stock | 0.9898 | 0.9902 | 0.9846 | 0.9852 | 7068208.0 |
| 2004-11-12 10:15:00 | AAPL | Stock | 0.9852 | 0.9886 | 0.9836 | 0.9877 | 6123264.0 |
| 2004-11-12 10:20:00 | AAPL | Stock | 0.988 | 0.9904 | 0.9879 | 0.9893 | 7326536.0 |
| 2004-11-12 10:25:00 | AAPL | Stock | 0.9893 | 0.9905 | 0.9873 | 0.9879 | 7233968.0 |
| 2004-11-12 10:30:00 | AAPL | Stock | 0.9877 | 0.9895 | 0.9866 | 0.9879 | 5752824.0 |
| 2004-11-12 10:35:00 | AAPL | Stock | 0.9879 | 0.9895 | 0.9875 | 0.988 | 6800024.0 |
| 2004-11-12 10:40:00 | AAPL | Stock | 0.9884 | 0.9898 | 0.9866 | 0.9871 | 11025056.0 |
| 2004-11-12 10:45:00 | AAPL | Stock | 0.987 | 0.9886 | 0.9868 | 0.9875 | 3001600.0 |
| 2004-11-12 10:50:00 | AAPL | Stock | 0.9877 | 0.9879 | 0.9863 | 0.9877 | 4308752.0 |
| 2004-11-12 10:55:00 | AAPL | Stock | 0.9873 | 0.9882 | 0.9868 | 0.9875 | 2960384.0 |
| 2004-11-12 11:00:00 | AAPL | Stock | 0.9877 | 0.9879 | 0.9866 | 0.9871 | 3672088.0 |
| 2004-11-12 11:05:00 | AAPL | Stock | 0.987 | 0.9882 | 0.9868 | 0.9875 | 4279576.0 |
| 2004-11-12 11:10:00 | AAPL | Stock | 0.9877 | 0.9884 | 0.987 | 0.987 | 4482576.0 |
| 2004-11-12 11:15:00 | AAPL | Stock | 0.987 | 0.988 | 0.9866 | 0.988 | 2285360.0 |
| 2004-11-12 11:20:00 | AAPL | Stock | 0.9875 | 0.9882 | 0.9871 | 0.9879 | 2230536.0 |
| 2004-11-12 11:25:00 | AAPL | Stock | 0.988 | 0.9884 | 0.9875 | 0.9875 | 1841112.0 |
| 2004-11-12 11:30:00 | AAPL | Stock | 0.9875 | 0.988 | 0.987 | 0.9871 | 1354696.0 |
| 2004-11-12 11:35:00 | AAPL | Stock | 0.9873 | 0.9882 | 0.9857 | 0.9857 | 2793504.0 |
| 2004-11-12 11:40:00 | AAPL | Stock | 0.9857 | 0.9863 | 0.9841 | 0.9855 | 4004728.0 |
| 2004-11-12 11:45:00 | AAPL | Stock | 0.9855 | 0.9855 | 0.983 | 0.9832 | 4884768.0 |
| 2004-11-12 11:50:00 | AAPL | Stock | 0.9832 | 0.9846 | 0.983 | 0.9841 | 2670640.0 |
| 2004-11-12 11:55:00 | AAPL | Stock | 0.9839 | 0.9861 | 0.9832 | 0.9839 | 7191016.0 |
| 2004-11-12 12:00:00 | AAPL | Stock | 0.9841 | 0.985 | 0.9827 | 0.985 | 2429952.0 |
| 2004-11-12 12:05:00 | AAPL | Stock | 0.985 | 0.9866 | 0.9845 | 0.9863 | 2775528.0 |
| 2004-11-12 12:10:00 | AAPL | Stock | 0.9864 | 0.9871 | 0.9859 | 0.987 | 2132760.0 |
| 2004-11-12 12:15:00 | AAPL | Stock | 0.9868 | 0.9875 | 0.9859 | 0.987 | 2019752.0 |
| 2004-11-12 12:20:00 | AAPL | Stock | 0.9866 | 0.988 | 0.9866 | 0.988 | 3430392.0 |
| 2004-11-12 12:25:00 | AAPL | Stock | 0.9875 | 0.988 | 0.9868 | 0.9868 | 2840432.0 |
| 2004-11-12 12:30:00 | AAPL | Stock | 0.9868 | 0.9873 | 0.9861 | 0.9863 | 1935304.0 |
| 2004-11-12 12:35:00 | AAPL | Stock | 0.9859 | 0.9866 | 0.9855 | 0.9863 | 2463608.0 |
| 2004-11-12 12:40:00 | AAPL | Stock | 0.9864 | 0.9866 | 0.9854 | 0.9864 | 1426600.0 |
> showing 50 of 181,927 rows — these rows as CSV