PREVIEW / stock_5min / 2007-03-22
file: by_date/stock_5min/2007/2007-03-22.parquet size: 3.6 MB rows: 260,460 symbols: 2,552
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-03-22 06:05:00 | AAPL | Stock | 3.3489 | 3.3489 | 3.3489 | 3.3489 | 14000.0 |
| 2007-03-22 07:50:00 | AAPL | Stock | 3.3511 | 3.3514 | 3.3511 | 3.3514 | 16800.0 |
| 2007-03-22 08:00:00 | AAPL | Stock | 3.3493 | 3.3493 | 3.3411 | 3.3411 | 157080.0 |
| 2007-03-22 08:05:00 | AAPL | Stock | 3.3429 | 3.3429 | 3.3429 | 3.3429 | 22400.0 |
| 2007-03-22 08:10:00 | AAPL | Stock | 3.3429 | 3.3446 | 3.3429 | 3.3446 | 42980.0 |
| 2007-03-22 08:15:00 | AAPL | Stock | 3.3446 | 3.3446 | 3.3418 | 3.3418 | 14000.0 |
| 2007-03-22 08:20:00 | AAPL | Stock | 3.3418 | 3.3418 | 3.3382 | 3.3393 | 112504.0 |
| 2007-03-22 08:25:00 | AAPL | Stock | 3.3382 | 3.3393 | 3.3368 | 3.3389 | 112700.0 |
| 2007-03-22 08:30:00 | AAPL | Stock | 3.3375 | 3.3439 | 3.3375 | 3.3436 | 106400.0 |
| 2007-03-22 08:35:00 | AAPL | Stock | 3.3425 | 3.3425 | 3.3375 | 3.3375 | 162120.0 |
| 2007-03-22 08:40:00 | AAPL | Stock | 3.3375 | 3.3393 | 3.3375 | 3.3393 | 25480.0 |
| 2007-03-22 08:45:00 | AAPL | Stock | 3.3404 | 3.3421 | 3.3404 | 3.3421 | 92120.0 |
| 2007-03-22 08:50:00 | AAPL | Stock | 3.3411 | 3.3457 | 3.3411 | 3.3457 | 171332.0 |
| 2007-03-22 08:55:00 | AAPL | Stock | 3.3421 | 3.345 | 3.3421 | 3.345 | 43344.0 |
| 2007-03-22 09:00:00 | AAPL | Stock | 3.3446 | 3.3464 | 3.3439 | 3.3454 | 153552.0 |
| 2007-03-22 09:05:00 | AAPL | Stock | 3.3454 | 3.3454 | 3.3421 | 3.3421 | 47628.0 |
| 2007-03-22 09:10:00 | AAPL | Stock | 3.3429 | 3.3429 | 3.3396 | 3.3396 | 176680.0 |
| 2007-03-22 09:15:00 | AAPL | Stock | 3.3411 | 3.3464 | 3.3411 | 3.3464 | 104076.0 |
| 2007-03-22 09:20:00 | AAPL | Stock | 3.3479 | 3.3479 | 3.3446 | 3.3461 | 59080.0 |
| 2007-03-22 09:25:00 | AAPL | Stock | 3.3479 | 3.3482 | 3.3446 | 3.3482 | 638176.0 |
| 2007-03-22 09:30:00 | AAPL | Stock | 3.3475 | 3.355 | 3.3214 | 3.3489 | 18333588.0 |
| 2007-03-22 09:35:00 | AAPL | Stock | 3.3489 | 3.3507 | 3.3332 | 3.3393 | 12664176.0 |
| 2007-03-22 09:40:00 | AAPL | Stock | 3.3393 | 3.3439 | 3.3293 | 3.3332 | 14833812.0 |
| 2007-03-22 09:45:00 | AAPL | Stock | 3.3343 | 3.3493 | 3.3307 | 3.3361 | 7742364.0 |
| 2007-03-22 09:50:00 | AAPL | Stock | 3.3354 | 3.3421 | 3.3321 | 3.3354 | 11194904.0 |
| 2007-03-22 09:55:00 | AAPL | Stock | 3.335 | 3.3382 | 3.3293 | 3.3371 | 10438484.0 |
| 2007-03-22 10:00:00 | AAPL | Stock | 3.3364 | 3.3429 | 3.3329 | 3.3382 | 11318748.0 |
| 2007-03-22 10:05:00 | AAPL | Stock | 3.3386 | 3.3479 | 3.3371 | 3.3464 | 13144432.0 |
| 2007-03-22 10:10:00 | AAPL | Stock | 3.3464 | 3.3525 | 3.3439 | 3.35 | 12595772.0 |
| 2007-03-22 10:15:00 | AAPL | Stock | 3.3496 | 3.3529 | 3.3457 | 3.3468 | 10194716.0 |
| 2007-03-22 10:20:00 | AAPL | Stock | 3.3468 | 3.3493 | 3.3436 | 3.3485 | 8149596.0 |
| 2007-03-22 10:25:00 | AAPL | Stock | 3.3479 | 3.3529 | 3.3461 | 3.3507 | 10559192.0 |
| 2007-03-22 10:30:00 | AAPL | Stock | 3.3504 | 3.3521 | 3.3457 | 3.3496 | 11471376.0 |
| 2007-03-22 10:35:00 | AAPL | Stock | 3.35 | 3.3507 | 3.3432 | 3.3432 | 9903292.0 |
| 2007-03-22 10:40:00 | AAPL | Stock | 3.3443 | 3.3471 | 3.3421 | 3.3471 | 8686216.0 |
| 2007-03-22 10:45:00 | AAPL | Stock | 3.3464 | 3.3518 | 3.3454 | 3.3486 | 5996592.0 |
| 2007-03-22 10:50:00 | AAPL | Stock | 3.3486 | 3.3511 | 3.3421 | 3.3429 | 8530732.0 |
| 2007-03-22 10:55:00 | AAPL | Stock | 3.3429 | 3.3514 | 3.3404 | 3.3407 | 9288888.0 |
| 2007-03-22 11:00:00 | AAPL | Stock | 3.3407 | 3.3486 | 3.3404 | 3.3425 | 6553792.0 |
| 2007-03-22 11:05:00 | AAPL | Stock | 3.3425 | 3.3482 | 3.3414 | 3.3443 | 4531128.0 |
| 2007-03-22 11:10:00 | AAPL | Stock | 3.3443 | 3.3521 | 3.3432 | 3.345 | 4573268.0 |
| 2007-03-22 11:15:00 | AAPL | Stock | 3.3454 | 3.3518 | 3.3425 | 3.3439 | 4961628.0 |
| 2007-03-22 11:20:00 | AAPL | Stock | 3.3439 | 3.3493 | 3.3436 | 3.3457 | 5509280.0 |
| 2007-03-22 11:25:00 | AAPL | Stock | 3.3461 | 3.3486 | 3.3457 | 3.3471 | 3014396.0 |
| 2007-03-22 11:30:00 | AAPL | Stock | 3.3471 | 3.3604 | 3.3464 | 3.36 | 10924396.0 |
| 2007-03-22 11:35:00 | AAPL | Stock | 3.3604 | 3.3604 | 3.3521 | 3.3564 | 8977528.0 |
| 2007-03-22 11:40:00 | AAPL | Stock | 3.3568 | 3.3568 | 3.3504 | 3.3526 | 5217940.0 |
| 2007-03-22 11:45:00 | AAPL | Stock | 3.3531 | 3.3546 | 3.3518 | 3.3546 | 4633776.0 |
| 2007-03-22 11:50:00 | AAPL | Stock | 3.3546 | 3.3561 | 3.3536 | 3.3546 | 3548972.0 |
| 2007-03-22 11:55:00 | AAPL | Stock | 3.3546 | 3.3561 | 3.3536 | 3.3539 | 6759648.0 |
> showing 50 of 260,460 rows — these rows as CSV