PREVIEW / stock_5min / 2008-01-10
file: by_date/stock_5min/2008/2008-01-10.parquet size: 4.5 MB rows: 323,233 symbols: 3,261
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-01-10 04:20:00 | AAPL | Stock | 6.4286 | 6.4286 | 6.4286 | 6.4286 | 2800.0 |
| 2008-01-10 04:45:00 | AAPL | Stock | 6.4018 | 6.4071 | 6.4018 | 6.4071 | 8400.0 |
| 2008-01-10 04:55:00 | AAPL | Stock | 6.4068 | 6.4071 | 6.4068 | 6.4071 | 8400.0 |
| 2008-01-10 05:00:00 | AAPL | Stock | 6.4075 | 6.4075 | 6.4075 | 6.4075 | 2800.0 |
| 2008-01-10 05:40:00 | AAPL | Stock | 6.4175 | 6.4175 | 6.4175 | 6.4175 | 8400.0 |
| 2008-01-10 06:30:00 | AAPL | Stock | 6.3932 | 6.3932 | 6.3932 | 6.3932 | 14000.0 |
| 2008-01-10 06:50:00 | AAPL | Stock | 6.4004 | 6.4214 | 6.4004 | 6.4214 | 42000.0 |
| 2008-01-10 07:00:00 | AAPL | Stock | 6.4004 | 6.4004 | 6.3939 | 6.4004 | 75600.0 |
| 2008-01-10 07:10:00 | AAPL | Stock | 6.3929 | 6.3929 | 6.3929 | 6.3929 | 4200.0 |
| 2008-01-10 07:15:00 | AAPL | Stock | 6.3946 | 6.3946 | 6.3929 | 6.3929 | 33600.0 |
| 2008-01-10 07:20:00 | AAPL | Stock | 6.3982 | 6.42 | 6.3979 | 6.42 | 28000.0 |
| 2008-01-10 07:25:00 | AAPL | Stock | 6.4207 | 6.4214 | 6.4207 | 6.4214 | 11200.0 |
| 2008-01-10 07:30:00 | AAPL | Stock | 6.4243 | 6.4268 | 6.4196 | 6.425 | 141540.0 |
| 2008-01-10 07:35:00 | AAPL | Stock | 6.4261 | 6.4304 | 6.425 | 6.4268 | 124264.0 |
| 2008-01-10 07:40:00 | AAPL | Stock | 6.4275 | 6.4275 | 6.4196 | 6.4196 | 91756.0 |
| 2008-01-10 07:45:00 | AAPL | Stock | 6.4071 | 6.4104 | 6.3975 | 6.3975 | 61880.0 |
| 2008-01-10 07:50:00 | AAPL | Stock | 6.4107 | 6.4179 | 6.4107 | 6.4143 | 68600.0 |
| 2008-01-10 07:55:00 | AAPL | Stock | 6.4143 | 6.4143 | 6.4086 | 6.4086 | 70140.0 |
| 2008-01-10 08:00:00 | AAPL | Stock | 6.4171 | 6.4311 | 6.3721 | 6.3768 | 1297352.0 |
| 2008-01-10 08:05:00 | AAPL | Stock | 6.3725 | 6.3839 | 6.3482 | 6.3625 | 1428700.0 |
| 2008-01-10 08:10:00 | AAPL | Stock | 6.3625 | 6.3768 | 6.3625 | 6.3768 | 375704.0 |
| 2008-01-10 08:15:00 | AAPL | Stock | 6.3768 | 6.3768 | 6.3582 | 6.3725 | 478296.0 |
| 2008-01-10 08:20:00 | AAPL | Stock | 6.3689 | 6.3689 | 6.3504 | 6.3571 | 834512.0 |
| 2008-01-10 08:25:00 | AAPL | Stock | 6.3539 | 6.3679 | 6.3536 | 6.3571 | 478884.0 |
| 2008-01-10 08:30:00 | AAPL | Stock | 6.3611 | 6.3804 | 6.3414 | 6.3457 | 926492.0 |
| 2008-01-10 08:35:00 | AAPL | Stock | 6.3457 | 6.355 | 6.3321 | 6.3429 | 1857520.0 |
| 2008-01-10 08:40:00 | AAPL | Stock | 6.3429 | 6.3475 | 6.3389 | 6.34 | 579852.0 |
| 2008-01-10 08:45:00 | AAPL | Stock | 6.34 | 6.3457 | 6.3286 | 6.3393 | 916664.0 |
| 2008-01-10 08:50:00 | AAPL | Stock | 6.3393 | 6.3464 | 6.3357 | 6.3364 | 849856.0 |
| 2008-01-10 08:55:00 | AAPL | Stock | 6.3364 | 6.3464 | 6.3214 | 6.3461 | 1418144.0 |
| 2008-01-10 09:00:00 | AAPL | Stock | 6.3454 | 6.3564 | 6.3382 | 6.3432 | 668696.0 |
| 2008-01-10 09:05:00 | AAPL | Stock | 6.3432 | 6.3446 | 6.3293 | 6.3375 | 693700.0 |
| 2008-01-10 09:10:00 | AAPL | Stock | 6.3371 | 6.3411 | 6.3286 | 6.3304 | 386904.0 |
| 2008-01-10 09:15:00 | AAPL | Stock | 6.3304 | 6.3321 | 6.3086 | 6.3107 | 799904.0 |
| 2008-01-10 09:20:00 | AAPL | Stock | 6.3107 | 6.3179 | 6.2857 | 6.3143 | 1367996.0 |
| 2008-01-10 09:25:00 | AAPL | Stock | 6.3143 | 6.3439 | 6.3036 | 6.3439 | 1421532.0 |
| 2008-01-10 09:30:00 | AAPL | Stock | 6.3443 | 6.345 | 6.2939 | 6.3064 | 38020640.0 |
| 2008-01-10 09:35:00 | AAPL | Stock | 6.3057 | 6.3368 | 6.2675 | 6.2725 | 39095168.0 |
| 2008-01-10 09:40:00 | AAPL | Stock | 6.2725 | 6.3179 | 6.2646 | 6.3089 | 29642508.0 |
| 2008-01-10 09:45:00 | AAPL | Stock | 6.3079 | 6.3489 | 6.295 | 6.3207 | 30789724.0 |
| 2008-01-10 09:50:00 | AAPL | Stock | 6.3211 | 6.3221 | 6.2757 | 6.2821 | 26565756.0 |
| 2008-01-10 09:55:00 | AAPL | Stock | 6.2825 | 6.3286 | 6.2796 | 6.2925 | 26135928.0 |
| 2008-01-10 10:00:00 | AAPL | Stock | 6.2921 | 6.3307 | 6.2804 | 6.315 | 24164196.0 |
| 2008-01-10 10:05:00 | AAPL | Stock | 6.3161 | 6.3321 | 6.2907 | 6.3007 | 29849344.0 |
| 2008-01-10 10:10:00 | AAPL | Stock | 6.3021 | 6.3054 | 6.2768 | 6.3021 | 21573580.0 |
| 2008-01-10 10:15:00 | AAPL | Stock | 6.3014 | 6.3321 | 6.2982 | 6.3168 | 24109988.0 |
| 2008-01-10 10:20:00 | AAPL | Stock | 6.3164 | 6.3336 | 6.3004 | 6.3254 | 21705124.0 |
| 2008-01-10 10:25:00 | AAPL | Stock | 6.3254 | 6.3254 | 6.275 | 6.2893 | 26125960.0 |
| 2008-01-10 10:30:00 | AAPL | Stock | 6.2893 | 6.3143 | 6.2804 | 6.3139 | 19074160.0 |
| 2008-01-10 10:35:00 | AAPL | Stock | 6.3143 | 6.3196 | 6.2861 | 6.2946 | 17830652.0 |
> showing 50 of 323,233 rows — these rows as CSV