PREVIEW / stock_5min / 2006-01-24
file: by_date/stock_5min/2006/2006-01-24.parquet size: 3.0 MB rows: 217,432 symbols: 2,183
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 |
|---|---|---|---|---|---|---|---|
| 2006-01-24 06:10:00 | AAPL | Stock | 2.7768 | 2.7768 | 2.7768 | 2.7768 | 5600.0 |
| 2006-01-24 06:45:00 | AAPL | Stock | 2.7786 | 2.7786 | 2.7786 | 2.7786 | 5600.0 |
| 2006-01-24 07:00:00 | AAPL | Stock | 2.7946 | 2.7946 | 2.7946 | 2.7946 | 16800.0 |
| 2006-01-24 07:05:00 | AAPL | Stock | 2.7982 | 2.7982 | 2.7982 | 2.7982 | 2800.0 |
| 2006-01-24 07:25:00 | AAPL | Stock | 2.8071 | 2.8071 | 2.8071 | 2.8071 | 50400.0 |
| 2006-01-24 07:30:00 | AAPL | Stock | 2.8071 | 2.8071 | 2.8054 | 2.8054 | 29708.0 |
| 2006-01-24 07:45:00 | AAPL | Stock | 2.8054 | 2.8054 | 2.8054 | 2.8054 | 5600.0 |
| 2006-01-24 07:50:00 | AAPL | Stock | 2.8054 | 2.8054 | 2.8054 | 2.8054 | 8400.0 |
| 2006-01-24 08:00:00 | AAPL | Stock | 2.8054 | 2.8179 | 2.8054 | 2.8107 | 415240.0 |
| 2006-01-24 08:05:00 | AAPL | Stock | 2.8107 | 2.8143 | 2.8064 | 2.8139 | 458080.0 |
| 2006-01-24 08:10:00 | AAPL | Stock | 2.8139 | 2.8143 | 2.8107 | 2.8136 | 219996.0 |
| 2006-01-24 08:15:00 | AAPL | Stock | 2.8125 | 2.815 | 2.8071 | 2.8143 | 162624.0 |
| 2006-01-24 08:20:00 | AAPL | Stock | 2.8143 | 2.8211 | 2.8143 | 2.8211 | 480200.0 |
| 2006-01-24 08:25:00 | AAPL | Stock | 2.8211 | 2.8254 | 2.8157 | 2.8175 | 417676.0 |
| 2006-01-24 08:30:00 | AAPL | Stock | 2.8196 | 2.8204 | 2.8175 | 2.8193 | 194208.0 |
| 2006-01-24 08:35:00 | AAPL | Stock | 2.8143 | 2.8189 | 2.8143 | 2.8189 | 136500.0 |
| 2006-01-24 08:40:00 | AAPL | Stock | 2.8171 | 2.8189 | 2.81 | 2.8125 | 263480.0 |
| 2006-01-24 08:45:00 | AAPL | Stock | 2.8125 | 2.8136 | 2.8107 | 2.8111 | 62300.0 |
| 2006-01-24 08:50:00 | AAPL | Stock | 2.8111 | 2.8136 | 2.8104 | 2.8114 | 408940.0 |
| 2006-01-24 08:55:00 | AAPL | Stock | 2.8107 | 2.8107 | 2.8068 | 2.8071 | 486080.0 |
| 2006-01-24 09:00:00 | AAPL | Stock | 2.8061 | 2.8107 | 2.8061 | 2.81 | 238448.0 |
| 2006-01-24 09:05:00 | AAPL | Stock | 2.81 | 2.8136 | 2.81 | 2.8136 | 435316.0 |
| 2006-01-24 09:10:00 | AAPL | Stock | 2.8132 | 2.8132 | 2.81 | 2.8107 | 167720.0 |
| 2006-01-24 09:15:00 | AAPL | Stock | 2.8114 | 2.8125 | 2.8089 | 2.8114 | 64400.0 |
| 2006-01-24 09:20:00 | AAPL | Stock | 2.8125 | 2.8139 | 2.8107 | 2.8129 | 209412.0 |
| 2006-01-24 09:25:00 | AAPL | Stock | 2.8129 | 2.8161 | 2.8071 | 2.8154 | 3828440.0 |
| 2006-01-24 09:30:00 | AAPL | Stock | 2.8129 | 2.8204 | 2.8057 | 2.8182 | 28819504.0 |
| 2006-01-24 09:35:00 | AAPL | Stock | 2.8182 | 2.8364 | 2.8137 | 2.8296 | 28240968.0 |
| 2006-01-24 09:40:00 | AAPL | Stock | 2.83 | 2.8307 | 2.8143 | 2.8257 | 26154380.0 |
| 2006-01-24 09:45:00 | AAPL | Stock | 2.8257 | 2.8279 | 2.8196 | 2.8279 | 19992644.0 |
| 2006-01-24 09:50:00 | AAPL | Stock | 2.8282 | 2.8289 | 2.8236 | 2.8239 | 11797604.0 |
| 2006-01-24 09:55:00 | AAPL | Stock | 2.8239 | 2.8364 | 2.8236 | 2.8289 | 17094812.0 |
| 2006-01-24 10:00:00 | AAPL | Stock | 2.8286 | 2.8325 | 2.8196 | 2.8236 | 16896992.0 |
| 2006-01-24 10:05:00 | AAPL | Stock | 2.8236 | 2.8239 | 2.8125 | 2.8157 | 14635264.0 |
| 2006-01-24 10:10:00 | AAPL | Stock | 2.8157 | 2.8243 | 2.8143 | 2.8211 | 11245472.0 |
| 2006-01-24 10:15:00 | AAPL | Stock | 2.8193 | 2.8232 | 2.8179 | 2.8218 | 7260820.0 |
| 2006-01-24 10:20:00 | AAPL | Stock | 2.8218 | 2.8286 | 2.8164 | 2.8168 | 12769008.0 |
| 2006-01-24 10:25:00 | AAPL | Stock | 2.8164 | 2.8207 | 2.8096 | 2.8175 | 16058000.0 |
| 2006-01-24 10:30:00 | AAPL | Stock | 2.8178 | 2.8196 | 2.8114 | 2.8125 | 11006576.0 |
| 2006-01-24 10:35:00 | AAPL | Stock | 2.8132 | 2.8154 | 2.8036 | 2.8036 | 13231092.0 |
| 2006-01-24 10:40:00 | AAPL | Stock | 2.8036 | 2.8107 | 2.8018 | 2.805 | 15777160.0 |
| 2006-01-24 10:45:00 | AAPL | Stock | 2.805 | 2.8093 | 2.8 | 2.8 | 10484880.0 |
| 2006-01-24 10:50:00 | AAPL | Stock | 2.8 | 2.8054 | 2.7882 | 2.7889 | 13352864.0 |
| 2006-01-24 10:55:00 | AAPL | Stock | 2.7889 | 2.7911 | 2.7793 | 2.7868 | 22705928.0 |
| 2006-01-24 11:00:00 | AAPL | Stock | 2.7868 | 2.7882 | 2.7793 | 2.7836 | 17164168.0 |
| 2006-01-24 11:05:00 | AAPL | Stock | 2.7832 | 2.7832 | 2.7721 | 2.7775 | 18599112.0 |
| 2006-01-24 11:10:00 | AAPL | Stock | 2.7775 | 2.7821 | 2.7714 | 2.7718 | 11684848.0 |
| 2006-01-24 11:15:00 | AAPL | Stock | 2.7718 | 2.7804 | 2.7718 | 2.7793 | 11101944.0 |
| 2006-01-24 11:20:00 | AAPL | Stock | 2.78 | 2.7857 | 2.7793 | 2.7807 | 11659872.0 |
| 2006-01-24 11:25:00 | AAPL | Stock | 2.7811 | 2.7875 | 2.7804 | 2.7854 | 9105152.0 |
> showing 50 of 217,432 rows — these rows as CSV