PREVIEW / stock_5min / 2007-05-18
file: by_date/stock_5min/2007/2007-05-18.parquet size: 3.9 MB rows: 291,370 symbols: 3,000
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 |
|---|---|---|---|---|---|---|---|
| 2007-05-18 09:30:00 | AAPL | Stock | 3.9368 | 3.9482 | 3.9239 | 3.9475 | 77826056.0 |
| 2007-05-18 09:35:00 | AAPL | Stock | 3.9475 | 3.9482 | 3.9382 | 3.9429 | 21774452.0 |
| 2007-05-18 09:40:00 | AAPL | Stock | 3.9429 | 3.9468 | 3.9396 | 3.9432 | 12758564.0 |
| 2007-05-18 09:45:00 | AAPL | Stock | 3.9432 | 3.9443 | 3.925 | 3.9332 | 19311880.0 |
| 2007-05-18 09:50:00 | AAPL | Stock | 3.9329 | 3.9464 | 3.9329 | 3.9429 | 12796112.0 |
| 2007-05-18 09:55:00 | AAPL | Stock | 3.9432 | 3.9446 | 3.9364 | 3.9389 | 8459864.0 |
| 2007-05-18 10:00:00 | AAPL | Stock | 3.9393 | 3.9425 | 3.9325 | 3.9346 | 10672144.0 |
| 2007-05-18 10:05:00 | AAPL | Stock | 3.935 | 3.9429 | 3.9343 | 3.9414 | 12332040.0 |
| 2007-05-18 10:10:00 | AAPL | Stock | 3.9414 | 3.9514 | 3.9371 | 3.9511 | 22479968.0 |
| 2007-05-18 10:15:00 | AAPL | Stock | 3.9511 | 3.9511 | 3.9389 | 3.9396 | 12068476.0 |
| 2007-05-18 10:20:00 | AAPL | Stock | 3.9396 | 3.9493 | 3.9396 | 3.9407 | 10285016.0 |
| 2007-05-18 10:25:00 | AAPL | Stock | 3.9404 | 3.9479 | 3.94 | 3.9429 | 6275752.0 |
| 2007-05-18 10:30:00 | AAPL | Stock | 3.9432 | 3.9439 | 3.9371 | 3.9382 | 9092272.0 |
| 2007-05-18 10:35:00 | AAPL | Stock | 3.9379 | 3.9389 | 3.9321 | 3.9354 | 7494312.0 |
| 2007-05-18 10:40:00 | AAPL | Stock | 3.9354 | 3.9364 | 3.9268 | 3.9304 | 14570192.0 |
| 2007-05-18 10:45:00 | AAPL | Stock | 3.9304 | 3.9361 | 3.9304 | 3.9339 | 6655488.0 |
| 2007-05-18 10:50:00 | AAPL | Stock | 3.9343 | 3.9343 | 3.9311 | 3.9325 | 4796988.0 |
| 2007-05-18 10:55:00 | AAPL | Stock | 3.9329 | 3.9332 | 3.9261 | 3.9279 | 11258604.0 |
| 2007-05-18 11:00:00 | AAPL | Stock | 3.9279 | 3.9304 | 3.9221 | 3.9224 | 11625208.0 |
| 2007-05-18 11:05:00 | AAPL | Stock | 3.9225 | 3.9325 | 3.9221 | 3.9314 | 8040424.0 |
| 2007-05-18 11:10:00 | AAPL | Stock | 3.9314 | 3.9321 | 3.9275 | 3.9314 | 4963616.0 |
| 2007-05-18 11:15:00 | AAPL | Stock | 3.9318 | 3.9318 | 3.9268 | 3.9297 | 5127612.0 |
| 2007-05-18 11:20:00 | AAPL | Stock | 3.9299 | 3.9304 | 3.925 | 3.9267 | 3143084.0 |
| 2007-05-18 11:25:00 | AAPL | Stock | 3.9264 | 3.9293 | 3.925 | 3.9286 | 3842636.0 |
| 2007-05-18 11:30:00 | AAPL | Stock | 3.9286 | 3.9293 | 3.9268 | 3.9279 | 3880268.0 |
| 2007-05-18 11:35:00 | AAPL | Stock | 3.9279 | 3.9281 | 3.9257 | 3.9274 | 2613548.0 |
| 2007-05-18 11:40:00 | AAPL | Stock | 3.9275 | 3.9286 | 3.9268 | 3.9269 | 2719052.0 |
| 2007-05-18 11:45:00 | AAPL | Stock | 3.9268 | 3.9286 | 3.9257 | 3.9279 | 4444692.0 |
| 2007-05-18 11:50:00 | AAPL | Stock | 3.9275 | 3.9296 | 3.9271 | 3.9286 | 4734968.0 |
| 2007-05-18 11:55:00 | AAPL | Stock | 3.9289 | 3.9289 | 3.9271 | 3.9282 | 3360644.0 |
| 2007-05-18 12:00:00 | AAPL | Stock | 3.9282 | 3.9282 | 3.9204 | 3.9204 | 5286596.0 |
| 2007-05-18 12:05:00 | AAPL | Stock | 3.9204 | 3.9261 | 3.9204 | 3.9232 | 5055764.0 |
| 2007-05-18 12:10:00 | AAPL | Stock | 3.9232 | 3.93 | 3.9232 | 3.9275 | 5180840.0 |
| 2007-05-18 12:15:00 | AAPL | Stock | 3.9275 | 3.9293 | 3.9271 | 3.9286 | 2129148.0 |
| 2007-05-18 12:20:00 | AAPL | Stock | 3.9289 | 3.9296 | 3.9275 | 3.9293 | 4900896.0 |
| 2007-05-18 12:25:00 | AAPL | Stock | 3.9293 | 3.9321 | 3.9275 | 3.9289 | 4831428.0 |
| 2007-05-18 12:30:00 | AAPL | Stock | 3.9289 | 3.9307 | 3.9286 | 3.9307 | 3442684.0 |
| 2007-05-18 12:35:00 | AAPL | Stock | 3.9304 | 3.9357 | 3.9304 | 3.9336 | 6783364.0 |
| 2007-05-18 12:40:00 | AAPL | Stock | 3.9332 | 3.9375 | 3.9325 | 3.9371 | 8323560.0 |
| 2007-05-18 12:45:00 | AAPL | Stock | 3.9371 | 3.9375 | 3.9307 | 3.9329 | 7511700.0 |
| 2007-05-18 12:50:00 | AAPL | Stock | 3.9325 | 3.9357 | 3.9325 | 3.9339 | 4339608.0 |
| 2007-05-18 12:55:00 | AAPL | Stock | 3.9336 | 3.9354 | 3.9314 | 3.9314 | 2770488.0 |
| 2007-05-18 13:00:00 | AAPL | Stock | 3.9318 | 3.9329 | 3.93 | 3.9321 | 2823464.0 |
| 2007-05-18 13:05:00 | AAPL | Stock | 3.9325 | 3.9339 | 3.9307 | 3.9314 | 2358804.0 |
| 2007-05-18 13:10:00 | AAPL | Stock | 3.9315 | 3.9325 | 3.9304 | 3.9325 | 1834168.0 |
| 2007-05-18 13:15:00 | AAPL | Stock | 3.9325 | 3.9325 | 3.9304 | 3.9311 | 2223452.0 |
| 2007-05-18 13:20:00 | AAPL | Stock | 3.9307 | 3.9311 | 3.9275 | 3.9275 | 3573164.0 |
| 2007-05-18 13:25:00 | AAPL | Stock | 3.9271 | 3.9282 | 3.9268 | 3.9282 | 2463048.0 |
| 2007-05-18 13:30:00 | AAPL | Stock | 3.9282 | 3.9307 | 3.9264 | 3.93 | 2525544.0 |
| 2007-05-18 13:35:00 | AAPL | Stock | 3.93 | 3.9304 | 3.9286 | 3.9289 | 2037588.0 |
> showing 50 of 291,370 rows — these rows as CSV