PREVIEW / stock_5min / 2008-04-02
file: by_date/stock_5min/2008/2008-04-02.parquet size: 4.3 MB rows: 313,540 symbols: 3,279
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-04-02 04:40:00 | AAPL | Stock | 5.3614 | 5.3614 | 5.3614 | 5.3614 | 5600.0 |
| 2008-04-02 04:45:00 | AAPL | Stock | 5.3546 | 5.3546 | 5.3546 | 5.3546 | 14000.0 |
| 2008-04-02 07:05:00 | AAPL | Stock | 5.3493 | 5.3493 | 5.3493 | 5.3493 | 16800.0 |
| 2008-04-02 07:10:00 | AAPL | Stock | 5.35 | 5.35 | 5.3443 | 5.3443 | 25200.0 |
| 2008-04-02 07:15:00 | AAPL | Stock | 5.3446 | 5.3614 | 5.3446 | 5.3571 | 276864.0 |
| 2008-04-02 07:20:00 | AAPL | Stock | 5.3607 | 5.3661 | 5.3539 | 5.3539 | 144928.0 |
| 2008-04-02 07:25:00 | AAPL | Stock | 5.3507 | 5.3554 | 5.3504 | 5.3536 | 117600.0 |
| 2008-04-02 07:30:00 | AAPL | Stock | 5.3482 | 5.3482 | 5.3321 | 5.3321 | 58688.0 |
| 2008-04-02 07:35:00 | AAPL | Stock | 5.3321 | 5.3446 | 5.3321 | 5.3393 | 270676.0 |
| 2008-04-02 07:40:00 | AAPL | Stock | 5.3393 | 5.3393 | 5.3143 | 5.3282 | 397908.0 |
| 2008-04-02 07:45:00 | AAPL | Stock | 5.3318 | 5.3357 | 5.3318 | 5.3357 | 67732.0 |
| 2008-04-02 07:50:00 | AAPL | Stock | 5.3357 | 5.3382 | 5.3329 | 5.3329 | 81396.0 |
| 2008-04-02 07:55:00 | AAPL | Stock | 5.3296 | 5.33 | 5.3179 | 5.3282 | 184128.0 |
| 2008-04-02 08:00:00 | AAPL | Stock | 5.3282 | 5.3404 | 5.3239 | 5.3339 | 1426628.0 |
| 2008-04-02 08:05:00 | AAPL | Stock | 5.3321 | 5.3329 | 5.3239 | 5.3268 | 1209488.0 |
| 2008-04-02 08:10:00 | AAPL | Stock | 5.3271 | 5.3286 | 5.3179 | 5.3246 | 1503460.0 |
| 2008-04-02 08:15:00 | AAPL | Stock | 5.3243 | 5.3386 | 5.3139 | 5.3168 | 1737428.0 |
| 2008-04-02 08:20:00 | AAPL | Stock | 5.3179 | 5.3279 | 5.3107 | 5.3161 | 911400.0 |
| 2008-04-02 08:25:00 | AAPL | Stock | 5.3161 | 5.3193 | 5.3036 | 5.3132 | 871136.0 |
| 2008-04-02 08:30:00 | AAPL | Stock | 5.3143 | 5.3143 | 5.3075 | 5.3132 | 292264.0 |
| 2008-04-02 08:35:00 | AAPL | Stock | 5.3132 | 5.3179 | 5.3129 | 5.3164 | 105756.0 |
| 2008-04-02 08:40:00 | AAPL | Stock | 5.3193 | 5.3264 | 5.3193 | 5.3243 | 476364.0 |
| 2008-04-02 08:45:00 | AAPL | Stock | 5.3246 | 5.3246 | 5.3186 | 5.3214 | 306012.0 |
| 2008-04-02 08:50:00 | AAPL | Stock | 5.3214 | 5.3225 | 5.3179 | 5.3182 | 347424.0 |
| 2008-04-02 08:55:00 | AAPL | Stock | 5.3193 | 5.3214 | 5.3182 | 5.3214 | 81200.0 |
| 2008-04-02 09:00:00 | AAPL | Stock | 5.3196 | 5.3432 | 5.3143 | 5.3143 | 14253680.0 |
| 2008-04-02 09:05:00 | AAPL | Stock | 5.3146 | 5.3179 | 5.3132 | 5.3179 | 107996.0 |
| 2008-04-02 09:10:00 | AAPL | Stock | 5.3179 | 5.3196 | 5.3143 | 5.3154 | 156156.0 |
| 2008-04-02 09:15:00 | AAPL | Stock | 5.3171 | 5.3243 | 5.3171 | 5.3236 | 174664.0 |
| 2008-04-02 09:20:00 | AAPL | Stock | 5.3236 | 5.3246 | 5.3179 | 5.3211 | 158928.0 |
| 2008-04-02 09:25:00 | AAPL | Stock | 5.3193 | 5.3207 | 5.3036 | 5.3114 | 1007860.0 |
| 2008-04-02 09:30:00 | AAPL | Stock | 5.3136 | 5.3404 | 5.3064 | 5.34 | 28433608.0 |
| 2008-04-02 09:35:00 | AAPL | Stock | 5.3396 | 5.35 | 5.3029 | 5.31 | 27461168.0 |
| 2008-04-02 09:40:00 | AAPL | Stock | 5.3082 | 5.315 | 5.2875 | 5.3032 | 23031344.0 |
| 2008-04-02 09:45:00 | AAPL | Stock | 5.3036 | 5.3064 | 5.2832 | 5.2932 | 19375356.0 |
| 2008-04-02 09:50:00 | AAPL | Stock | 5.2936 | 5.3132 | 5.2929 | 5.3004 | 18515896.0 |
| 2008-04-02 09:55:00 | AAPL | Stock | 5.3007 | 5.3236 | 5.295 | 5.3229 | 16080792.0 |
| 2008-04-02 10:00:00 | AAPL | Stock | 5.3221 | 5.3354 | 5.3011 | 5.3307 | 17428572.0 |
| 2008-04-02 10:05:00 | AAPL | Stock | 5.3314 | 5.3529 | 5.3268 | 5.3511 | 20876632.0 |
| 2008-04-02 10:10:00 | AAPL | Stock | 5.3489 | 5.3529 | 5.3432 | 5.3489 | 14029764.0 |
| 2008-04-02 10:15:00 | AAPL | Stock | 5.3493 | 5.3718 | 5.3489 | 5.3654 | 25909268.0 |
| 2008-04-02 10:20:00 | AAPL | Stock | 5.3654 | 5.38 | 5.3618 | 5.3761 | 21233912.0 |
| 2008-04-02 10:25:00 | AAPL | Stock | 5.3775 | 5.3964 | 5.3714 | 5.3875 | 23715048.0 |
| 2008-04-02 10:30:00 | AAPL | Stock | 5.3875 | 5.4 | 5.3736 | 5.3789 | 23207072.0 |
| 2008-04-02 10:35:00 | AAPL | Stock | 5.3789 | 5.3964 | 5.3768 | 5.3882 | 14335972.0 |
| 2008-04-02 10:40:00 | AAPL | Stock | 5.3882 | 5.3968 | 5.3804 | 5.3821 | 15067584.0 |
| 2008-04-02 10:45:00 | AAPL | Stock | 5.3818 | 5.3946 | 5.3804 | 5.3839 | 9119096.0 |
| 2008-04-02 10:50:00 | AAPL | Stock | 5.3825 | 5.3946 | 5.3768 | 5.3829 | 12273912.0 |
| 2008-04-02 10:55:00 | AAPL | Stock | 5.3821 | 5.3932 | 5.3768 | 5.3782 | 11209996.0 |
| 2008-04-02 11:00:00 | AAPL | Stock | 5.3782 | 5.3821 | 5.3729 | 5.3786 | 9377340.0 |
> showing 50 of 313,540 rows — these rows as CSV