PREVIEW / stock_5min / 2008-03-04
file: by_date/stock_5min/2008/2008-03-04.parquet size: 4.5 MB rows: 324,562 symbols: 3,281
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-03-04 04:20:00 | AAPL | Stock | 4.3436 | 4.3436 | 4.3436 | 4.3436 | 2800.0 |
| 2008-03-04 04:30:00 | AAPL | Stock | 4.3436 | 4.3436 | 4.3436 | 4.3436 | 2800.0 |
| 2008-03-04 04:45:00 | AAPL | Stock | 4.3436 | 4.3436 | 4.3436 | 4.3436 | 2800.0 |
| 2008-03-04 05:25:00 | AAPL | Stock | 4.3393 | 4.3393 | 4.3221 | 4.3221 | 8400.0 |
| 2008-03-04 05:55:00 | AAPL | Stock | 4.3221 | 4.3221 | 4.3039 | 4.3039 | 64400.0 |
| 2008-03-04 06:15:00 | AAPL | Stock | 4.305 | 4.305 | 4.2857 | 4.2857 | 75432.0 |
| 2008-03-04 06:30:00 | AAPL | Stock | 4.2857 | 4.2857 | 4.2857 | 4.2857 | 2800.0 |
| 2008-03-04 06:40:00 | AAPL | Stock | 4.2857 | 4.2857 | 4.2857 | 4.2857 | 5600.0 |
| 2008-03-04 06:45:00 | AAPL | Stock | 4.2857 | 4.2857 | 4.2857 | 4.2857 | 2800.0 |
| 2008-03-04 07:05:00 | AAPL | Stock | 4.2861 | 4.3025 | 4.2861 | 4.3025 | 5600.0 |
| 2008-03-04 07:10:00 | AAPL | Stock | 4.2896 | 4.2896 | 4.2857 | 4.2857 | 49672.0 |
| 2008-03-04 07:15:00 | AAPL | Stock | 4.2857 | 4.2857 | 4.2857 | 4.2857 | 22400.0 |
| 2008-03-04 07:20:00 | AAPL | Stock | 4.3025 | 4.3025 | 4.2857 | 4.2857 | 21000.0 |
| 2008-03-04 07:25:00 | AAPL | Stock | 4.2893 | 4.2893 | 4.2893 | 4.2893 | 5600.0 |
| 2008-03-04 07:30:00 | AAPL | Stock | 4.2896 | 4.2896 | 4.2896 | 4.2896 | 3780.0 |
| 2008-03-04 07:35:00 | AAPL | Stock | 4.2925 | 4.3036 | 4.2925 | 4.3036 | 35896.0 |
| 2008-03-04 07:40:00 | AAPL | Stock | 4.3036 | 4.3036 | 4.2968 | 4.2968 | 5600.0 |
| 2008-03-04 07:45:00 | AAPL | Stock | 4.3182 | 4.3182 | 4.3182 | 4.3182 | 4200.0 |
| 2008-03-04 07:50:00 | AAPL | Stock | 4.3168 | 4.3175 | 4.3168 | 4.3171 | 25200.0 |
| 2008-03-04 08:00:00 | AAPL | Stock | 4.3082 | 4.3136 | 4.2957 | 4.2964 | 343616.0 |
| 2008-03-04 08:05:00 | AAPL | Stock | 4.2932 | 4.3036 | 4.2911 | 4.3032 | 644224.0 |
| 2008-03-04 08:10:00 | AAPL | Stock | 4.2986 | 4.3036 | 4.2968 | 4.3018 | 248640.0 |
| 2008-03-04 08:15:00 | AAPL | Stock | 4.3036 | 4.3125 | 4.3036 | 4.3089 | 200200.0 |
| 2008-03-04 08:20:00 | AAPL | Stock | 4.3114 | 4.3232 | 4.3093 | 4.3093 | 297164.0 |
| 2008-03-04 08:25:00 | AAPL | Stock | 4.3143 | 4.3196 | 4.3125 | 4.3179 | 60060.0 |
| 2008-03-04 08:30:00 | AAPL | Stock | 4.3168 | 4.3286 | 4.3143 | 4.3243 | 339528.0 |
| 2008-03-04 08:35:00 | AAPL | Stock | 4.3243 | 4.3282 | 4.3214 | 4.3239 | 147700.0 |
| 2008-03-04 08:40:00 | AAPL | Stock | 4.3221 | 4.3282 | 4.3182 | 4.3182 | 276052.0 |
| 2008-03-04 08:45:00 | AAPL | Stock | 4.3189 | 4.3246 | 4.3189 | 4.3204 | 84756.0 |
| 2008-03-04 08:50:00 | AAPL | Stock | 4.3207 | 4.3286 | 4.3207 | 4.3286 | 130900.0 |
| 2008-03-04 08:55:00 | AAPL | Stock | 4.3286 | 4.3389 | 4.3286 | 4.3357 | 892500.0 |
| 2008-03-04 09:00:00 | AAPL | Stock | 4.3357 | 4.3379 | 4.3229 | 4.3229 | 281400.0 |
| 2008-03-04 09:05:00 | AAPL | Stock | 4.3229 | 4.3229 | 4.3146 | 4.3157 | 477736.0 |
| 2008-03-04 09:10:00 | AAPL | Stock | 4.3146 | 4.3321 | 4.3143 | 4.3307 | 308112.0 |
| 2008-03-04 09:15:00 | AAPL | Stock | 4.325 | 4.325 | 4.3143 | 4.3236 | 476980.0 |
| 2008-03-04 09:20:00 | AAPL | Stock | 4.3232 | 4.3464 | 4.3214 | 4.3411 | 841484.0 |
| 2008-03-04 09:25:00 | AAPL | Stock | 4.3414 | 4.3618 | 4.3411 | 4.3557 | 3849496.0 |
| 2008-03-04 09:30:00 | AAPL | Stock | 4.3554 | 4.385 | 4.3357 | 4.3411 | 44307676.0 |
| 2008-03-04 09:35:00 | AAPL | Stock | 4.3411 | 4.3432 | 4.3 | 4.3061 | 40578524.0 |
| 2008-03-04 09:40:00 | AAPL | Stock | 4.3057 | 4.3368 | 4.3054 | 4.325 | 27981520.0 |
| 2008-03-04 09:45:00 | AAPL | Stock | 4.3232 | 4.3525 | 4.3196 | 4.3466 | 31152324.0 |
| 2008-03-04 09:50:00 | AAPL | Stock | 4.3491 | 4.3839 | 4.3396 | 4.3775 | 39379256.0 |
| 2008-03-04 09:55:00 | AAPL | Stock | 4.3775 | 4.3811 | 4.3429 | 4.3493 | 34695640.0 |
| 2008-03-04 10:00:00 | AAPL | Stock | 4.3493 | 4.3589 | 4.3361 | 4.345 | 24198524.0 |
| 2008-03-04 10:05:00 | AAPL | Stock | 4.3454 | 4.3496 | 4.3245 | 4.3482 | 21428904.0 |
| 2008-03-04 10:10:00 | AAPL | Stock | 4.344 | 4.3671 | 4.344 | 4.3561 | 20741084.0 |
| 2008-03-04 10:15:00 | AAPL | Stock | 4.3575 | 4.3671 | 4.35 | 4.365 | 18711868.0 |
| 2008-03-04 10:20:00 | AAPL | Stock | 4.3657 | 4.3761 | 4.3613 | 4.3621 | 22245664.0 |
| 2008-03-04 10:25:00 | AAPL | Stock | 4.3621 | 4.3786 | 4.3332 | 4.3371 | 17478020.0 |
| 2008-03-04 10:30:00 | AAPL | Stock | 4.3382 | 4.3446 | 4.3261 | 4.3368 | 16397080.0 |
> showing 50 of 324,562 rows — these rows as CSV