PREVIEW / stock_5min / 2009-01-29
file: by_date/stock_5min/2009/2009-01-29.parquet size: 4.2 MB rows: 298,206 symbols: 3,291
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 |
|---|---|---|---|---|---|---|---|
| 2009-01-29 05:55:00 | AAPL | Stock | 3.3096 | 3.3096 | 3.3096 | 3.3096 | 6132.0 |
| 2009-01-29 08:00:00 | AAPL | Stock | 3.3214 | 3.3364 | 3.3214 | 3.3357 | 54600.0 |
| 2009-01-29 08:05:00 | AAPL | Stock | 3.3357 | 3.3371 | 3.3304 | 3.3304 | 53592.0 |
| 2009-01-29 08:10:00 | AAPL | Stock | 3.3304 | 3.3304 | 3.3232 | 3.3286 | 61600.0 |
| 2009-01-29 08:15:00 | AAPL | Stock | 3.3289 | 3.3304 | 3.3286 | 3.3304 | 58100.0 |
| 2009-01-29 08:20:00 | AAPL | Stock | 3.3304 | 3.3321 | 3.3304 | 3.3321 | 22400.0 |
| 2009-01-29 08:25:00 | AAPL | Stock | 3.3321 | 3.3357 | 3.3311 | 3.3339 | 43904.0 |
| 2009-01-29 08:30:00 | AAPL | Stock | 3.3339 | 3.3339 | 3.3232 | 3.325 | 280952.0 |
| 2009-01-29 08:35:00 | AAPL | Stock | 3.3268 | 3.3346 | 3.3268 | 3.3286 | 47320.0 |
| 2009-01-29 08:40:00 | AAPL | Stock | 3.3314 | 3.3339 | 3.3314 | 3.3339 | 23996.0 |
| 2009-01-29 08:45:00 | AAPL | Stock | 3.3293 | 3.33 | 3.3286 | 3.33 | 10500.0 |
| 2009-01-29 08:50:00 | AAPL | Stock | 3.3286 | 3.3286 | 3.3254 | 3.3254 | 61432.0 |
| 2009-01-29 08:55:00 | AAPL | Stock | 3.3232 | 3.325 | 3.3225 | 3.325 | 35084.0 |
| 2009-01-29 09:00:00 | AAPL | Stock | 3.3268 | 3.3271 | 3.3225 | 3.3232 | 102340.0 |
| 2009-01-29 09:05:00 | AAPL | Stock | 3.3232 | 3.325 | 3.3225 | 3.325 | 194600.0 |
| 2009-01-29 09:10:00 | AAPL | Stock | 3.3246 | 3.3271 | 3.3232 | 3.3271 | 62188.0 |
| 2009-01-29 09:15:00 | AAPL | Stock | 3.3236 | 3.3236 | 3.3236 | 3.3236 | 17696.0 |
| 2009-01-29 09:20:00 | AAPL | Stock | 3.3246 | 3.3271 | 3.3243 | 3.3261 | 33600.0 |
| 2009-01-29 09:25:00 | AAPL | Stock | 3.3282 | 3.3282 | 3.3214 | 3.3239 | 176372.0 |
| 2009-01-29 09:30:00 | AAPL | Stock | 3.3246 | 3.3393 | 3.3211 | 3.3346 | 21954184.0 |
| 2009-01-29 09:35:00 | AAPL | Stock | 3.3357 | 3.3454 | 3.3257 | 3.3304 | 17032568.0 |
| 2009-01-29 09:40:00 | AAPL | Stock | 3.3307 | 3.3371 | 3.3164 | 3.3268 | 15205148.0 |
| 2009-01-29 09:45:00 | AAPL | Stock | 3.3264 | 3.3332 | 3.3179 | 3.3254 | 12065200.0 |
| 2009-01-29 09:50:00 | AAPL | Stock | 3.3264 | 3.3332 | 3.3146 | 3.3204 | 9692172.0 |
| 2009-01-29 09:55:00 | AAPL | Stock | 3.3196 | 3.3289 | 3.3196 | 3.3275 | 7842044.0 |
| 2009-01-29 10:00:00 | AAPL | Stock | 3.3275 | 3.3364 | 3.3196 | 3.3361 | 15765064.0 |
| 2009-01-29 10:05:00 | AAPL | Stock | 3.3361 | 3.3489 | 3.3357 | 3.3418 | 13203064.0 |
| 2009-01-29 10:10:00 | AAPL | Stock | 3.3418 | 3.3432 | 3.3311 | 3.3421 | 9978080.0 |
| 2009-01-29 10:15:00 | AAPL | Stock | 3.3421 | 3.3436 | 3.3279 | 3.3289 | 8147832.0 |
| 2009-01-29 10:20:00 | AAPL | Stock | 3.3296 | 3.3321 | 3.32 | 3.3246 | 7208544.0 |
| 2009-01-29 10:25:00 | AAPL | Stock | 3.3236 | 3.3329 | 3.3221 | 3.3304 | 5506704.0 |
| 2009-01-29 10:30:00 | AAPL | Stock | 3.33 | 3.3318 | 3.3168 | 3.3264 | 9883216.0 |
| 2009-01-29 10:35:00 | AAPL | Stock | 3.3268 | 3.3382 | 3.3214 | 3.3355 | 9703484.0 |
| 2009-01-29 10:40:00 | AAPL | Stock | 3.3359 | 3.3414 | 3.3332 | 3.3379 | 7226968.0 |
| 2009-01-29 10:45:00 | AAPL | Stock | 3.3382 | 3.3486 | 3.3361 | 3.3421 | 7757596.0 |
| 2009-01-29 10:50:00 | AAPL | Stock | 3.3429 | 3.3546 | 3.3382 | 3.3529 | 7906668.0 |
| 2009-01-29 10:55:00 | AAPL | Stock | 3.3532 | 3.3575 | 3.35 | 3.3504 | 10089184.0 |
| 2009-01-29 11:00:00 | AAPL | Stock | 3.3504 | 3.3554 | 3.3446 | 3.3468 | 7344652.0 |
| 2009-01-29 11:05:00 | AAPL | Stock | 3.3479 | 3.3557 | 3.3454 | 3.3529 | 5909764.0 |
| 2009-01-29 11:10:00 | AAPL | Stock | 3.3536 | 3.3614 | 3.3507 | 3.3614 | 6845412.0 |
| 2009-01-29 11:15:00 | AAPL | Stock | 3.3618 | 3.3693 | 3.3439 | 3.3579 | 9542848.0 |
| 2009-01-29 11:20:00 | AAPL | Stock | 3.3582 | 3.3664 | 3.3571 | 3.3629 | 6638296.0 |
| 2009-01-29 11:25:00 | AAPL | Stock | 3.3629 | 3.3643 | 3.3507 | 3.3521 | 7687120.0 |
| 2009-01-29 11:30:00 | AAPL | Stock | 3.3518 | 3.3546 | 3.3504 | 3.3543 | 3629472.0 |
| 2009-01-29 11:35:00 | AAPL | Stock | 3.3543 | 3.3639 | 3.3539 | 3.3561 | 6845608.0 |
| 2009-01-29 11:40:00 | AAPL | Stock | 3.3568 | 3.3625 | 3.3539 | 3.3571 | 5222364.0 |
| 2009-01-29 11:45:00 | AAPL | Stock | 3.3568 | 3.3571 | 3.35 | 3.3529 | 5993484.0 |
| 2009-01-29 11:50:00 | AAPL | Stock | 3.3525 | 3.3561 | 3.3489 | 3.3536 | 4355932.0 |
| 2009-01-29 11:55:00 | AAPL | Stock | 3.3536 | 3.3579 | 3.3511 | 3.3518 | 3769864.0 |
| 2009-01-29 12:00:00 | AAPL | Stock | 3.3514 | 3.3514 | 3.3375 | 3.3382 | 8649088.0 |
> showing 50 of 298,206 rows — these rows as CSV