PREVIEW / stock_5min / 2008-02-08
file: by_date/stock_5min/2008/2008-02-08.parquet size: 4.3 MB rows: 312,060 symbols: 3,256
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 |
|---|---|---|---|---|---|---|---|
| 2008-02-08 06:10:00 | AAPL | Stock | 4.3464 | 4.3464 | 4.3464 | 4.3464 | 9800.0 |
| 2008-02-08 06:40:00 | AAPL | Stock | 4.3382 | 4.3382 | 4.3382 | 4.3382 | 2800.0 |
| 2008-02-08 07:00:00 | AAPL | Stock | 4.3311 | 4.3311 | 4.3304 | 4.3304 | 161000.0 |
| 2008-02-08 07:05:00 | AAPL | Stock | 4.3429 | 4.3429 | 4.3271 | 4.3271 | 14000.0 |
| 2008-02-08 07:10:00 | AAPL | Stock | 4.295 | 4.2989 | 4.295 | 4.2964 | 40880.0 |
| 2008-02-08 07:15:00 | AAPL | Stock | 4.2964 | 4.3104 | 4.295 | 4.3104 | 60984.0 |
| 2008-02-08 07:20:00 | AAPL | Stock | 4.3175 | 4.3175 | 4.3175 | 4.3175 | 8400.0 |
| 2008-02-08 07:25:00 | AAPL | Stock | 4.3071 | 4.3107 | 4.3036 | 4.3107 | 44800.0 |
| 2008-02-08 07:30:00 | AAPL | Stock | 4.3107 | 4.3214 | 4.3107 | 4.3179 | 42140.0 |
| 2008-02-08 07:35:00 | AAPL | Stock | 4.3214 | 4.3214 | 4.3179 | 4.3179 | 11200.0 |
| 2008-02-08 07:40:00 | AAPL | Stock | 4.3179 | 4.3179 | 4.3179 | 4.3179 | 8400.0 |
| 2008-02-08 07:45:00 | AAPL | Stock | 4.3179 | 4.3179 | 4.3179 | 4.3179 | 22400.0 |
| 2008-02-08 07:50:00 | AAPL | Stock | 4.3179 | 4.3179 | 4.3075 | 4.3075 | 8400.0 |
| 2008-02-08 07:55:00 | AAPL | Stock | 4.3089 | 4.3089 | 4.3089 | 4.3089 | 2800.0 |
| 2008-02-08 08:00:00 | AAPL | Stock | 4.3157 | 4.3486 | 4.3129 | 4.3443 | 322224.0 |
| 2008-02-08 08:05:00 | AAPL | Stock | 4.3496 | 4.3514 | 4.3393 | 4.3482 | 197960.0 |
| 2008-02-08 08:10:00 | AAPL | Stock | 4.3482 | 4.3486 | 4.3357 | 4.3364 | 195216.0 |
| 2008-02-08 08:15:00 | AAPL | Stock | 4.3357 | 4.3429 | 4.3336 | 4.3336 | 116676.0 |
| 2008-02-08 08:20:00 | AAPL | Stock | 4.3339 | 4.3339 | 4.3257 | 4.3268 | 277620.0 |
| 2008-02-08 08:25:00 | AAPL | Stock | 4.3257 | 4.3282 | 4.3189 | 4.3214 | 505792.0 |
| 2008-02-08 08:30:00 | AAPL | Stock | 4.3211 | 4.3354 | 4.3211 | 4.3354 | 325780.0 |
| 2008-02-08 08:35:00 | AAPL | Stock | 4.335 | 4.3429 | 4.335 | 4.3393 | 300552.0 |
| 2008-02-08 08:40:00 | AAPL | Stock | 4.3393 | 4.3393 | 4.3286 | 4.3286 | 227332.0 |
| 2008-02-08 08:45:00 | AAPL | Stock | 4.3254 | 4.3311 | 4.3189 | 4.3254 | 730184.0 |
| 2008-02-08 08:50:00 | AAPL | Stock | 4.325 | 4.3321 | 4.3214 | 4.3318 | 309708.0 |
| 2008-02-08 08:55:00 | AAPL | Stock | 4.3318 | 4.345 | 4.3318 | 4.3446 | 227164.0 |
| 2008-02-08 09:00:00 | AAPL | Stock | 4.3464 | 4.3736 | 4.3464 | 4.3646 | 1170876.0 |
| 2008-02-08 09:05:00 | AAPL | Stock | 4.3657 | 4.3721 | 4.3543 | 4.3579 | 928172.0 |
| 2008-02-08 09:10:00 | AAPL | Stock | 4.3604 | 4.3639 | 4.35 | 4.3507 | 529424.0 |
| 2008-02-08 09:15:00 | AAPL | Stock | 4.3507 | 4.3618 | 4.3507 | 4.3607 | 226800.0 |
| 2008-02-08 09:20:00 | AAPL | Stock | 4.3604 | 4.3736 | 4.36 | 4.3643 | 733180.0 |
| 2008-02-08 09:25:00 | AAPL | Stock | 4.3639 | 4.37 | 4.3571 | 4.3604 | 470260.0 |
| 2008-02-08 09:30:00 | AAPL | Stock | 4.3604 | 4.41 | 4.3596 | 4.4096 | 39048184.0 |
| 2008-02-08 09:35:00 | AAPL | Stock | 4.4096 | 4.4196 | 4.3771 | 4.3894 | 30107532.0 |
| 2008-02-08 09:40:00 | AAPL | Stock | 4.3857 | 4.39 | 4.365 | 4.3829 | 26186496.0 |
| 2008-02-08 09:45:00 | AAPL | Stock | 4.3829 | 4.4079 | 4.375 | 4.3943 | 25424392.0 |
| 2008-02-08 09:50:00 | AAPL | Stock | 4.395 | 4.4146 | 4.3864 | 4.4118 | 23109016.0 |
| 2008-02-08 09:55:00 | AAPL | Stock | 4.4116 | 4.4243 | 4.3975 | 4.4211 | 24209360.0 |
| 2008-02-08 10:00:00 | AAPL | Stock | 4.42 | 4.4339 | 4.4061 | 4.43 | 35514836.0 |
| 2008-02-08 10:05:00 | AAPL | Stock | 4.43 | 4.4496 | 4.415 | 4.4257 | 32723656.0 |
| 2008-02-08 10:10:00 | AAPL | Stock | 4.4259 | 4.4532 | 4.4255 | 4.4411 | 22953812.0 |
| 2008-02-08 10:15:00 | AAPL | Stock | 4.4407 | 4.4568 | 4.4336 | 4.4417 | 17300248.0 |
| 2008-02-08 10:20:00 | AAPL | Stock | 4.4425 | 4.4643 | 4.4396 | 4.4606 | 24253572.0 |
| 2008-02-08 10:25:00 | AAPL | Stock | 4.4602 | 4.4614 | 4.445 | 4.4557 | 16533160.0 |
| 2008-02-08 10:30:00 | AAPL | Stock | 4.4564 | 4.4564 | 4.4296 | 4.4321 | 20680800.0 |
| 2008-02-08 10:35:00 | AAPL | Stock | 4.4321 | 4.4407 | 4.4232 | 4.4392 | 20499752.0 |
| 2008-02-08 10:40:00 | AAPL | Stock | 4.4393 | 4.4464 | 4.4389 | 4.4454 | 12196576.0 |
| 2008-02-08 10:45:00 | AAPL | Stock | 4.4454 | 4.4636 | 4.4421 | 4.4461 | 17287648.0 |
| 2008-02-08 10:50:00 | AAPL | Stock | 4.4461 | 4.4679 | 4.4418 | 4.4575 | 20016388.0 |
| 2008-02-08 10:55:00 | AAPL | Stock | 4.4575 | 4.465 | 4.4429 | 4.4518 | 18808216.0 |
> showing 50 of 312,060 rows — these rows as CSV