PREVIEW / stock_5min / 2005-09-26
file: by_date/stock_5min/2005/2005-09-26.parquet size: 2.8 MB rows: 204,231 symbols: 2,074
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 |
|---|---|---|---|---|---|---|---|
| 2005-09-26 08:00:00 | AAPL | Stock | 1.9179 | 1.9279 | 1.9139 | 1.9196 | 145320.0 |
| 2005-09-26 08:05:00 | AAPL | Stock | 1.9196 | 1.9286 | 1.9196 | 1.9268 | 598360.0 |
| 2005-09-26 08:10:00 | AAPL | Stock | 1.925 | 1.9314 | 1.9232 | 1.925 | 440160.0 |
| 2005-09-26 08:15:00 | AAPL | Stock | 1.9282 | 1.9286 | 1.9268 | 1.9286 | 49000.0 |
| 2005-09-26 08:20:00 | AAPL | Stock | 1.9261 | 1.9318 | 1.925 | 1.9304 | 322420.0 |
| 2005-09-26 08:25:00 | AAPL | Stock | 1.9304 | 1.9354 | 1.9304 | 1.9346 | 664720.0 |
| 2005-09-26 08:30:00 | AAPL | Stock | 1.9346 | 1.9357 | 1.9329 | 1.9329 | 626612.0 |
| 2005-09-26 08:35:00 | AAPL | Stock | 1.9321 | 1.9321 | 1.9293 | 1.9311 | 84560.0 |
| 2005-09-26 08:40:00 | AAPL | Stock | 1.9318 | 1.9325 | 1.9286 | 1.9321 | 148400.0 |
| 2005-09-26 08:45:00 | AAPL | Stock | 1.9318 | 1.9321 | 1.9318 | 1.9321 | 137200.0 |
| 2005-09-26 08:50:00 | AAPL | Stock | 1.9321 | 1.9329 | 1.9311 | 1.9314 | 209188.0 |
| 2005-09-26 08:55:00 | AAPL | Stock | 1.9311 | 1.9339 | 1.9311 | 1.9325 | 403200.0 |
| 2005-09-26 09:00:00 | AAPL | Stock | 1.9332 | 1.9332 | 1.9286 | 1.9304 | 411040.0 |
| 2005-09-26 09:05:00 | AAPL | Stock | 1.9296 | 1.9339 | 1.9286 | 1.9304 | 422324.0 |
| 2005-09-26 09:10:00 | AAPL | Stock | 1.9321 | 1.9329 | 1.9289 | 1.9307 | 306600.0 |
| 2005-09-26 09:15:00 | AAPL | Stock | 1.9311 | 1.9311 | 1.93 | 1.9307 | 252000.0 |
| 2005-09-26 09:20:00 | AAPL | Stock | 1.9293 | 1.93 | 1.9282 | 1.9289 | 753564.0 |
| 2005-09-26 09:25:00 | AAPL | Stock | 1.9286 | 1.9361 | 1.925 | 1.93 | 1507268.0 |
| 2005-09-26 09:30:00 | AAPL | Stock | 1.9296 | 1.9393 | 1.9254 | 1.9296 | 31051608.0 |
| 2005-09-26 09:35:00 | AAPL | Stock | 1.9293 | 1.9357 | 1.9271 | 1.9314 | 22383956.0 |
| 2005-09-26 09:40:00 | AAPL | Stock | 1.9311 | 1.9321 | 1.9179 | 1.9207 | 17198552.0 |
| 2005-09-26 09:45:00 | AAPL | Stock | 1.9207 | 1.93 | 1.92 | 1.9293 | 8741656.0 |
| 2005-09-26 09:50:00 | AAPL | Stock | 1.9296 | 1.9304 | 1.9254 | 1.9304 | 7226408.0 |
| 2005-09-26 09:55:00 | AAPL | Stock | 1.93 | 1.9304 | 1.925 | 1.9279 | 8373400.0 |
| 2005-09-26 10:00:00 | AAPL | Stock | 1.9279 | 1.9325 | 1.9175 | 1.9211 | 15619464.0 |
| 2005-09-26 10:05:00 | AAPL | Stock | 1.9211 | 1.9332 | 1.92 | 1.9318 | 9234904.0 |
| 2005-09-26 10:10:00 | AAPL | Stock | 1.9311 | 1.9354 | 1.9279 | 1.9339 | 11724076.0 |
| 2005-09-26 10:15:00 | AAPL | Stock | 1.9339 | 1.9396 | 1.9286 | 1.9371 | 21972244.0 |
| 2005-09-26 10:20:00 | AAPL | Stock | 1.9375 | 1.9421 | 1.9343 | 1.9414 | 11677176.0 |
| 2005-09-26 10:25:00 | AAPL | Stock | 1.9407 | 1.9443 | 1.9364 | 1.9393 | 11373572.0 |
| 2005-09-26 10:30:00 | AAPL | Stock | 1.9393 | 1.9432 | 1.9382 | 1.9432 | 8414924.0 |
| 2005-09-26 10:35:00 | AAPL | Stock | 1.9429 | 1.9457 | 1.94 | 1.9439 | 14121548.0 |
| 2005-09-26 10:40:00 | AAPL | Stock | 1.9443 | 1.9464 | 1.9404 | 1.946 | 11204928.0 |
| 2005-09-26 10:45:00 | AAPL | Stock | 1.9457 | 1.9486 | 1.9375 | 1.9389 | 17785068.0 |
| 2005-09-26 10:50:00 | AAPL | Stock | 1.9389 | 1.9425 | 1.9386 | 1.9421 | 5349932.0 |
| 2005-09-26 10:55:00 | AAPL | Stock | 1.9421 | 1.9425 | 1.9343 | 1.9361 | 5707352.0 |
| 2005-09-26 11:00:00 | AAPL | Stock | 1.9364 | 1.9393 | 1.9343 | 1.9386 | 5893496.0 |
| 2005-09-26 11:05:00 | AAPL | Stock | 1.9389 | 1.9389 | 1.9361 | 1.9364 | 4057172.0 |
| 2005-09-26 11:10:00 | AAPL | Stock | 1.9364 | 1.9393 | 1.9361 | 1.9393 | 2989364.0 |
| 2005-09-26 11:15:00 | AAPL | Stock | 1.9393 | 1.94 | 1.9379 | 1.9396 | 2905868.0 |
| 2005-09-26 11:20:00 | AAPL | Stock | 1.9396 | 1.9414 | 1.9371 | 1.9396 | 3998232.0 |
| 2005-09-26 11:25:00 | AAPL | Stock | 1.9399 | 1.9411 | 1.9368 | 1.9396 | 3569720.0 |
| 2005-09-26 11:30:00 | AAPL | Stock | 1.9396 | 1.9407 | 1.9371 | 1.939 | 2974328.0 |
| 2005-09-26 11:35:00 | AAPL | Stock | 1.9389 | 1.9393 | 1.935 | 1.9361 | 3974908.0 |
| 2005-09-26 11:40:00 | AAPL | Stock | 1.9364 | 1.9364 | 1.9286 | 1.9343 | 13924540.0 |
| 2005-09-26 11:45:00 | AAPL | Stock | 1.9343 | 1.935 | 1.9325 | 1.9339 | 3627568.0 |
| 2005-09-26 11:50:00 | AAPL | Stock | 1.934 | 1.9343 | 1.9318 | 1.9329 | 3295348.0 |
| 2005-09-26 11:55:00 | AAPL | Stock | 1.9325 | 1.9357 | 1.9325 | 1.9343 | 3427312.0 |
| 2005-09-26 12:00:00 | AAPL | Stock | 1.9343 | 1.9382 | 1.9336 | 1.9379 | 3449992.0 |
| 2005-09-26 12:05:00 | AAPL | Stock | 1.9375 | 1.94 | 1.9364 | 1.9389 | 2938656.0 |
> showing 50 of 204,231 rows — these rows as CSV