PREVIEW / stock_5min / 2006-10-20
file: by_date/stock_5min/2006/2006-10-20.parquet size: 3.1 MB rows: 225,001 symbols: 2,390
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-10-20 07:35:00 | AAPL | Stock | 2.8268 | 2.8268 | 2.8268 | 2.8268 | 2800.0 |
| 2006-10-20 07:55:00 | AAPL | Stock | 2.8307 | 2.8314 | 2.8211 | 2.8211 | 46200.0 |
| 2006-10-20 08:00:00 | AAPL | Stock | 2.8268 | 2.8321 | 2.825 | 2.8268 | 488852.0 |
| 2006-10-20 08:05:00 | AAPL | Stock | 2.8268 | 2.8307 | 2.825 | 2.8307 | 153300.0 |
| 2006-10-20 08:10:00 | AAPL | Stock | 2.8307 | 2.8307 | 2.8214 | 2.8214 | 198828.0 |
| 2006-10-20 08:15:00 | AAPL | Stock | 2.8268 | 2.8304 | 2.8214 | 2.8268 | 490448.0 |
| 2006-10-20 08:20:00 | AAPL | Stock | 2.8268 | 2.8268 | 2.825 | 2.8268 | 61600.0 |
| 2006-10-20 08:25:00 | AAPL | Stock | 2.8268 | 2.8268 | 2.8214 | 2.8214 | 288400.0 |
| 2006-10-20 08:30:00 | AAPL | Stock | 2.825 | 2.825 | 2.825 | 2.825 | 56308.0 |
| 2006-10-20 08:35:00 | AAPL | Stock | 2.825 | 2.825 | 2.815 | 2.8196 | 227360.0 |
| 2006-10-20 08:40:00 | AAPL | Stock | 2.8196 | 2.8243 | 2.8182 | 2.82 | 72800.0 |
| 2006-10-20 08:45:00 | AAPL | Stock | 2.8204 | 2.8214 | 2.8204 | 2.8214 | 16240.0 |
| 2006-10-20 08:50:00 | AAPL | Stock | 2.8214 | 2.8214 | 2.8214 | 2.8214 | 93268.0 |
| 2006-10-20 08:55:00 | AAPL | Stock | 2.8214 | 2.8214 | 2.8196 | 2.8196 | 14420.0 |
| 2006-10-20 09:00:00 | AAPL | Stock | 2.8179 | 2.8196 | 2.815 | 2.8196 | 140392.0 |
| 2006-10-20 09:05:00 | AAPL | Stock | 2.8189 | 2.8189 | 2.8179 | 2.8179 | 90860.0 |
| 2006-10-20 09:10:00 | AAPL | Stock | 2.8189 | 2.8189 | 2.8189 | 2.8189 | 5040.0 |
| 2006-10-20 09:15:00 | AAPL | Stock | 2.8189 | 2.8189 | 2.8189 | 2.8189 | 20132.0 |
| 2006-10-20 09:20:00 | AAPL | Stock | 2.8164 | 2.8214 | 2.8164 | 2.8214 | 301868.0 |
| 2006-10-20 09:25:00 | AAPL | Stock | 2.8214 | 2.8293 | 2.8146 | 2.8204 | 1600732.0 |
| 2006-10-20 09:30:00 | AAPL | Stock | 2.8204 | 2.825 | 2.8096 | 2.8107 | 53449536.0 |
| 2006-10-20 09:35:00 | AAPL | Stock | 2.8118 | 2.8179 | 2.8104 | 2.8146 | 15788584.0 |
| 2006-10-20 09:40:00 | AAPL | Stock | 2.8143 | 2.8264 | 2.8125 | 2.8257 | 19722164.0 |
| 2006-10-20 09:45:00 | AAPL | Stock | 2.8264 | 2.8425 | 2.8139 | 2.8164 | 20106968.0 |
| 2006-10-20 09:50:00 | AAPL | Stock | 2.8171 | 2.8236 | 2.8146 | 2.8229 | 14811608.0 |
| 2006-10-20 09:55:00 | AAPL | Stock | 2.8225 | 2.8239 | 2.8154 | 2.8189 | 11178860.0 |
| 2006-10-20 10:00:00 | AAPL | Stock | 2.8196 | 2.8304 | 2.8179 | 2.824 | 10737468.0 |
| 2006-10-20 10:05:00 | AAPL | Stock | 2.8239 | 2.8311 | 2.8236 | 2.8282 | 11510296.0 |
| 2006-10-20 10:10:00 | AAPL | Stock | 2.8282 | 2.8314 | 2.8246 | 2.8304 | 11647608.0 |
| 2006-10-20 10:15:00 | AAPL | Stock | 2.8304 | 2.8332 | 2.8279 | 2.8314 | 9293116.0 |
| 2006-10-20 10:20:00 | AAPL | Stock | 2.8318 | 2.8354 | 2.8282 | 2.8354 | 10745392.0 |
| 2006-10-20 10:25:00 | AAPL | Stock | 2.835 | 2.8371 | 2.8325 | 2.8339 | 8171268.0 |
| 2006-10-20 10:30:00 | AAPL | Stock | 2.8336 | 2.8407 | 2.8314 | 2.8403 | 18023152.0 |
| 2006-10-20 10:35:00 | AAPL | Stock | 2.8396 | 2.8418 | 2.8336 | 2.8368 | 9820356.0 |
| 2006-10-20 10:40:00 | AAPL | Stock | 2.8368 | 2.8368 | 2.8304 | 2.8321 | 7735560.0 |
| 2006-10-20 10:45:00 | AAPL | Stock | 2.832 | 2.8364 | 2.8314 | 2.8346 | 5592048.0 |
| 2006-10-20 10:50:00 | AAPL | Stock | 2.8345 | 2.8375 | 2.8321 | 2.8346 | 6206816.0 |
| 2006-10-20 10:55:00 | AAPL | Stock | 2.8346 | 2.8379 | 2.8342 | 2.8375 | 5358724.0 |
| 2006-10-20 11:00:00 | AAPL | Stock | 2.8379 | 2.8393 | 2.8357 | 2.8368 | 6748336.0 |
| 2006-10-20 11:05:00 | AAPL | Stock | 2.8368 | 2.8368 | 2.8329 | 2.834 | 5858356.0 |
| 2006-10-20 11:10:00 | AAPL | Stock | 2.8336 | 2.8361 | 2.8332 | 2.8357 | 2817444.0 |
| 2006-10-20 11:15:00 | AAPL | Stock | 2.8359 | 2.8361 | 2.8293 | 2.8311 | 6031648.0 |
| 2006-10-20 11:20:00 | AAPL | Stock | 2.8311 | 2.8332 | 2.8279 | 2.8293 | 11207840.0 |
| 2006-10-20 11:25:00 | AAPL | Stock | 2.8293 | 2.8332 | 2.8279 | 2.8296 | 5510288.0 |
| 2006-10-20 11:30:00 | AAPL | Stock | 2.8295 | 2.8332 | 2.8289 | 2.8325 | 3693340.0 |
| 2006-10-20 11:35:00 | AAPL | Stock | 2.8327 | 2.835 | 2.8318 | 2.8339 | 6246968.0 |
| 2006-10-20 11:40:00 | AAPL | Stock | 2.8336 | 2.8393 | 2.8318 | 2.8386 | 6545840.0 |
| 2006-10-20 11:45:00 | AAPL | Stock | 2.8382 | 2.8407 | 2.8379 | 2.8389 | 6129676.0 |
| 2006-10-20 11:50:00 | AAPL | Stock | 2.8393 | 2.8425 | 2.8386 | 2.8414 | 6154736.0 |
| 2006-10-20 11:55:00 | AAPL | Stock | 2.8411 | 2.8461 | 2.8407 | 2.8421 | 7981120.0 |
> showing 50 of 225,001 rows — these rows as CSV