PREVIEW / stock_5min / 2006-11-14
file: by_date/stock_5min/2006/2006-11-14.parquet size: 3.3 MB rows: 239,068 symbols: 2,445
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-11-14 07:25:00 | AAPL | Stock | 3.0054 | 3.0054 | 3.0054 | 3.0054 | 5600.0 |
| 2006-11-14 07:30:00 | AAPL | Stock | 3.0054 | 3.0054 | 3.0054 | 3.0054 | 75600.0 |
| 2006-11-14 07:45:00 | AAPL | Stock | 3.0036 | 3.0036 | 3.0036 | 3.0036 | 5600.0 |
| 2006-11-14 07:55:00 | AAPL | Stock | 2.9964 | 2.9964 | 2.9964 | 2.9964 | 14000.0 |
| 2006-11-14 08:00:00 | AAPL | Stock | 3.0036 | 3.0111 | 3.0 | 3.0018 | 126840.0 |
| 2006-11-14 08:05:00 | AAPL | Stock | 3.0032 | 3.0036 | 3.0018 | 3.0032 | 49896.0 |
| 2006-11-14 08:10:00 | AAPL | Stock | 3.0032 | 3.0032 | 3.0004 | 3.0014 | 155904.0 |
| 2006-11-14 08:15:00 | AAPL | Stock | 3.0014 | 3.0018 | 3.0014 | 3.0018 | 23520.0 |
| 2006-11-14 08:20:00 | AAPL | Stock | 3.0018 | 3.0018 | 2.9982 | 2.9986 | 205968.0 |
| 2006-11-14 08:25:00 | AAPL | Stock | 2.9986 | 3.0 | 2.9986 | 3.0 | 64400.0 |
| 2006-11-14 08:30:00 | AAPL | Stock | 3.0014 | 3.0089 | 3.0014 | 3.0068 | 306880.0 |
| 2006-11-14 08:35:00 | AAPL | Stock | 3.0054 | 3.0179 | 3.0054 | 3.0179 | 196168.0 |
| 2006-11-14 08:40:00 | AAPL | Stock | 3.0179 | 3.0336 | 3.0143 | 3.0232 | 627452.0 |
| 2006-11-14 08:45:00 | AAPL | Stock | 3.0232 | 3.025 | 3.0214 | 3.0246 | 154196.0 |
| 2006-11-14 08:50:00 | AAPL | Stock | 3.0232 | 3.0268 | 3.0232 | 3.025 | 349440.0 |
| 2006-11-14 08:55:00 | AAPL | Stock | 3.0232 | 3.0279 | 3.0229 | 3.0279 | 332164.0 |
| 2006-11-14 09:00:00 | AAPL | Stock | 3.0261 | 3.0261 | 3.0232 | 3.0254 | 249200.0 |
| 2006-11-14 09:05:00 | AAPL | Stock | 3.0275 | 3.0382 | 3.0261 | 3.0354 | 856072.0 |
| 2006-11-14 09:10:00 | AAPL | Stock | 3.0336 | 3.0457 | 3.0321 | 3.0411 | 1599724.0 |
| 2006-11-14 09:15:00 | AAPL | Stock | 3.0418 | 3.0457 | 3.0382 | 3.0425 | 681128.0 |
| 2006-11-14 09:20:00 | AAPL | Stock | 3.0411 | 3.0475 | 3.0411 | 3.045 | 731640.0 |
| 2006-11-14 09:25:00 | AAPL | Stock | 3.045 | 3.0514 | 3.0286 | 3.0286 | 4462052.0 |
| 2006-11-14 09:30:00 | AAPL | Stock | 3.0286 | 3.0357 | 3.0268 | 3.0314 | 22453900.0 |
| 2006-11-14 09:35:00 | AAPL | Stock | 3.0314 | 3.0329 | 3.0179 | 3.0239 | 12379164.0 |
| 2006-11-14 09:40:00 | AAPL | Stock | 3.0236 | 3.0296 | 3.0214 | 3.0268 | 9578604.0 |
| 2006-11-14 09:45:00 | AAPL | Stock | 3.0268 | 3.0357 | 3.0254 | 3.0329 | 13956124.0 |
| 2006-11-14 09:50:00 | AAPL | Stock | 3.0332 | 3.0346 | 3.0286 | 3.0314 | 6816964.0 |
| 2006-11-14 09:55:00 | AAPL | Stock | 3.0316 | 3.0339 | 3.0271 | 3.0329 | 9257276.0 |
| 2006-11-14 10:00:00 | AAPL | Stock | 3.0325 | 3.035 | 3.0179 | 3.0336 | 8812748.0 |
| 2006-11-14 10:05:00 | AAPL | Stock | 3.0339 | 3.0357 | 3.0325 | 3.035 | 8554924.0 |
| 2006-11-14 10:10:00 | AAPL | Stock | 3.0346 | 3.0354 | 3.0264 | 3.0282 | 10647924.0 |
| 2006-11-14 10:15:00 | AAPL | Stock | 3.0282 | 3.0321 | 3.0207 | 3.0221 | 14077364.0 |
| 2006-11-14 10:20:00 | AAPL | Stock | 3.0221 | 3.0224 | 3.0043 | 3.0143 | 20500172.0 |
| 2006-11-14 10:25:00 | AAPL | Stock | 3.0139 | 3.0154 | 3.0043 | 3.0054 | 13002612.0 |
| 2006-11-14 10:30:00 | AAPL | Stock | 3.0054 | 3.0061 | 2.9968 | 3.0018 | 13084512.0 |
| 2006-11-14 10:35:00 | AAPL | Stock | 3.0018 | 3.0086 | 3.0007 | 3.0057 | 8914052.0 |
| 2006-11-14 10:40:00 | AAPL | Stock | 3.0054 | 3.0129 | 3.0054 | 3.0096 | 9965088.0 |
| 2006-11-14 10:45:00 | AAPL | Stock | 3.0093 | 3.01 | 3.0032 | 3.0068 | 9844744.0 |
| 2006-11-14 10:50:00 | AAPL | Stock | 3.0064 | 3.0069 | 2.9964 | 3.0043 | 10215576.0 |
| 2006-11-14 10:55:00 | AAPL | Stock | 3.0046 | 3.01 | 3.0037 | 3.0089 | 7660884.0 |
| 2006-11-14 11:00:00 | AAPL | Stock | 3.0092 | 3.0114 | 3.0043 | 3.0054 | 5215672.0 |
| 2006-11-14 11:05:00 | AAPL | Stock | 3.0054 | 3.0286 | 3.0036 | 3.0057 | 2966768.0 |
| 2006-11-14 11:10:00 | AAPL | Stock | 3.0057 | 3.0062 | 3.0 | 3.0011 | 4297608.0 |
| 2006-11-14 11:15:00 | AAPL | Stock | 3.0011 | 3.0082 | 3.0007 | 3.0068 | 6416844.0 |
| 2006-11-14 11:20:00 | AAPL | Stock | 3.0068 | 3.0121 | 3.0057 | 3.0093 | 4906832.0 |
| 2006-11-14 11:25:00 | AAPL | Stock | 3.0086 | 3.0224 | 3.0064 | 3.02 | 11960536.0 |
| 2006-11-14 11:30:00 | AAPL | Stock | 3.0196 | 3.025 | 3.0189 | 3.0204 | 7486332.0 |
| 2006-11-14 11:35:00 | AAPL | Stock | 3.0204 | 3.0254 | 3.0196 | 3.0243 | 7799092.0 |
| 2006-11-14 11:40:00 | AAPL | Stock | 3.0246 | 3.0246 | 3.02 | 3.02 | 5172832.0 |
| 2006-11-14 11:45:00 | AAPL | Stock | 3.0204 | 3.0268 | 3.0193 | 3.0232 | 7434644.0 |
> showing 50 of 239,068 rows — these rows as CSV