PREVIEW / stock_5min / 2010-11-01
file: by_date/stock_5min/2010/2010-11-01.parquet size: 4.8 MB rows: 325,321 symbols: 3,516
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 |
|---|---|---|---|---|---|---|---|
| 2010-11-01 05:05:00 | AAPL | Stock | 10.8471 | 10.8471 | 10.8471 | 10.8471 | 2800.0 |
| 2010-11-01 05:10:00 | AAPL | Stock | 10.8464 | 10.8464 | 10.8464 | 10.8464 | 2800.0 |
| 2010-11-01 05:15:00 | AAPL | Stock | 10.8468 | 10.8571 | 10.8468 | 10.8571 | 11200.0 |
| 2010-11-01 05:25:00 | AAPL | Stock | 10.8571 | 10.8571 | 10.8571 | 10.8571 | 3080.0 |
| 2010-11-01 05:35:00 | AAPL | Stock | 10.8571 | 10.8571 | 10.8571 | 10.8571 | 2800.0 |
| 2010-11-01 05:50:00 | AAPL | Stock | 10.8425 | 10.8425 | 10.8425 | 10.8425 | 2800.0 |
| 2010-11-01 06:25:00 | AAPL | Stock | 10.8207 | 10.8207 | 10.8207 | 10.8207 | 2800.0 |
| 2010-11-01 06:45:00 | AAPL | Stock | 10.8304 | 10.8304 | 10.8304 | 10.8304 | 2800.0 |
| 2010-11-01 07:00:00 | AAPL | Stock | 10.8179 | 10.8304 | 10.8179 | 10.8304 | 11200.0 |
| 2010-11-01 07:05:00 | AAPL | Stock | 10.8125 | 10.8218 | 10.8125 | 10.8214 | 80080.0 |
| 2010-11-01 07:10:00 | AAPL | Stock | 10.8214 | 10.8214 | 10.8164 | 10.8164 | 11760.0 |
| 2010-11-01 07:15:00 | AAPL | Stock | 10.8211 | 10.8214 | 10.8211 | 10.8214 | 41440.0 |
| 2010-11-01 07:20:00 | AAPL | Stock | 10.8214 | 10.8214 | 10.8211 | 10.8214 | 58800.0 |
| 2010-11-01 07:25:00 | AAPL | Stock | 10.8214 | 10.8214 | 10.8214 | 10.8214 | 8400.0 |
| 2010-11-01 07:35:00 | AAPL | Stock | 10.8214 | 10.8214 | 10.8161 | 10.8204 | 40012.0 |
| 2010-11-01 07:40:00 | AAPL | Stock | 10.8204 | 10.8211 | 10.8171 | 10.8211 | 75600.0 |
| 2010-11-01 07:45:00 | AAPL | Stock | 10.8214 | 10.8243 | 10.815 | 10.815 | 28000.0 |
| 2010-11-01 07:50:00 | AAPL | Stock | 10.8118 | 10.8118 | 10.8029 | 10.8029 | 11200.0 |
| 2010-11-01 07:55:00 | AAPL | Stock | 10.8029 | 10.8029 | 10.8029 | 10.8029 | 2800.0 |
| 2010-11-01 08:00:00 | AAPL | Stock | 10.8039 | 10.8179 | 10.7454 | 10.8071 | 267092.0 |
| 2010-11-01 08:05:00 | AAPL | Stock | 10.7493 | 10.8064 | 10.7493 | 10.7979 | 129668.0 |
| 2010-11-01 08:10:00 | AAPL | Stock | 10.795 | 10.7964 | 10.7454 | 10.7454 | 117516.0 |
| 2010-11-01 08:15:00 | AAPL | Stock | 10.7454 | 10.7907 | 10.7454 | 10.7821 | 168336.0 |
| 2010-11-01 08:20:00 | AAPL | Stock | 10.785 | 10.7943 | 10.785 | 10.7864 | 224140.0 |
| 2010-11-01 08:25:00 | AAPL | Stock | 10.7864 | 10.7964 | 10.7804 | 10.7964 | 221620.0 |
| 2010-11-01 08:30:00 | AAPL | Stock | 10.7982 | 10.7982 | 10.78 | 10.7839 | 315392.0 |
| 2010-11-01 08:35:00 | AAPL | Stock | 10.7846 | 10.7875 | 10.7846 | 10.7854 | 103012.0 |
| 2010-11-01 08:40:00 | AAPL | Stock | 10.7879 | 10.7936 | 10.7871 | 10.7879 | 149800.0 |
| 2010-11-01 08:45:00 | AAPL | Stock | 10.7875 | 10.7929 | 10.7857 | 10.7918 | 149072.0 |
| 2010-11-01 08:50:00 | AAPL | Stock | 10.7893 | 10.7914 | 10.785 | 10.7889 | 91336.0 |
| 2010-11-01 08:55:00 | AAPL | Stock | 10.7857 | 10.7893 | 10.7811 | 10.785 | 78400.0 |
| 2010-11-01 09:00:00 | AAPL | Stock | 10.7846 | 10.7886 | 10.7493 | 10.7864 | 113260.0 |
| 2010-11-01 09:05:00 | AAPL | Stock | 10.7861 | 10.7868 | 10.7836 | 10.7861 | 54600.0 |
| 2010-11-01 09:10:00 | AAPL | Stock | 10.7854 | 10.7854 | 10.7821 | 10.7846 | 80332.0 |
| 2010-11-01 09:15:00 | AAPL | Stock | 10.7843 | 10.7857 | 10.7829 | 10.7854 | 128800.0 |
| 2010-11-01 09:20:00 | AAPL | Stock | 10.7854 | 10.7968 | 10.7854 | 10.7946 | 204680.0 |
| 2010-11-01 09:25:00 | AAPL | Stock | 10.7943 | 10.8132 | 10.7929 | 10.8079 | 413252.0 |
| 2010-11-01 09:30:00 | AAPL | Stock | 10.8025 | 10.8396 | 10.7929 | 10.8393 | 19674228.0 |
| 2010-11-01 09:35:00 | AAPL | Stock | 10.8393 | 10.8618 | 10.8369 | 10.8579 | 15475376.0 |
| 2010-11-01 09:40:00 | AAPL | Stock | 10.8579 | 10.8771 | 10.8571 | 10.8639 | 14500864.0 |
| 2010-11-01 09:45:00 | AAPL | Stock | 10.8639 | 10.8993 | 10.8636 | 10.8971 | 13867700.0 |
| 2010-11-01 09:50:00 | AAPL | Stock | 10.8954 | 10.9082 | 10.8889 | 10.8993 | 15424192.0 |
| 2010-11-01 09:55:00 | AAPL | Stock | 10.8996 | 10.9107 | 10.8796 | 10.8886 | 12433512.0 |
| 2010-11-01 10:00:00 | AAPL | Stock | 10.8892 | 10.9107 | 10.8757 | 10.9036 | 13215048.0 |
| 2010-11-01 10:05:00 | AAPL | Stock | 10.9057 | 10.9143 | 10.8879 | 10.8932 | 11378276.0 |
| 2010-11-01 10:10:00 | AAPL | Stock | 10.8954 | 10.9018 | 10.8871 | 10.8961 | 6524980.0 |
| 2010-11-01 10:15:00 | AAPL | Stock | 10.8961 | 10.9004 | 10.8875 | 10.8886 | 3343480.0 |
| 2010-11-01 10:20:00 | AAPL | Stock | 10.8896 | 10.895 | 10.8779 | 10.8821 | 6563284.0 |
| 2010-11-01 10:25:00 | AAPL | Stock | 10.8804 | 10.8914 | 10.8757 | 10.8893 | 6302912.0 |
| 2010-11-01 10:30:00 | AAPL | Stock | 10.8892 | 10.8914 | 10.875 | 10.8754 | 5800760.0 |
> showing 50 of 325,321 rows — these rows as CSV