PREVIEW / stock_5min / 2007-01-10
file: by_date/stock_5min/2007/2007-01-10.parquet size: 3.3 MB rows: 242,973 symbols: 2,483
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 |
|---|---|---|---|---|---|---|---|
| 2007-01-10 04:50:00 | AAPL | Stock | 3.3018 | 3.3018 | 3.3018 | 3.3018 | 14000.0 |
| 2007-01-10 05:25:00 | AAPL | Stock | 3.2975 | 3.2975 | 3.2968 | 3.2968 | 25480.0 |
| 2007-01-10 05:45:00 | AAPL | Stock | 3.2975 | 3.2975 | 3.2971 | 3.2971 | 16800.0 |
| 2007-01-10 05:50:00 | AAPL | Stock | 3.2979 | 3.2979 | 3.2971 | 3.2971 | 15260.0 |
| 2007-01-10 05:55:00 | AAPL | Stock | 3.2971 | 3.2971 | 3.2971 | 3.2971 | 2800.0 |
| 2007-01-10 06:10:00 | AAPL | Stock | 3.2982 | 3.2982 | 3.2982 | 3.2982 | 3220.0 |
| 2007-01-10 06:15:00 | AAPL | Stock | 3.2993 | 3.2993 | 3.2989 | 3.2989 | 8400.0 |
| 2007-01-10 06:35:00 | AAPL | Stock | 3.3 | 3.3 | 3.3 | 3.3 | 2800.0 |
| 2007-01-10 06:40:00 | AAPL | Stock | 3.3032 | 3.3089 | 3.3032 | 3.3089 | 260400.0 |
| 2007-01-10 06:50:00 | AAPL | Stock | 3.3068 | 3.3211 | 3.3068 | 3.3211 | 260904.0 |
| 2007-01-10 06:55:00 | AAPL | Stock | 3.3089 | 3.3089 | 3.3071 | 3.3071 | 140000.0 |
| 2007-01-10 07:00:00 | AAPL | Stock | 3.3143 | 3.3286 | 3.3143 | 3.3286 | 539728.0 |
| 2007-01-10 07:05:00 | AAPL | Stock | 3.3279 | 3.3314 | 3.3218 | 3.3286 | 435400.0 |
| 2007-01-10 07:10:00 | AAPL | Stock | 3.3286 | 3.3339 | 3.3286 | 3.3321 | 372904.0 |
| 2007-01-10 07:15:00 | AAPL | Stock | 3.3321 | 3.3393 | 3.3214 | 3.3346 | 1028720.0 |
| 2007-01-10 07:20:00 | AAPL | Stock | 3.3346 | 3.3468 | 3.3325 | 3.3379 | 797048.0 |
| 2007-01-10 07:25:00 | AAPL | Stock | 3.3386 | 3.345 | 3.3386 | 3.3414 | 190400.0 |
| 2007-01-10 07:30:00 | AAPL | Stock | 3.3429 | 3.3429 | 3.3382 | 3.3429 | 376740.0 |
| 2007-01-10 07:35:00 | AAPL | Stock | 3.3429 | 3.3429 | 3.3321 | 3.3364 | 765632.0 |
| 2007-01-10 07:40:00 | AAPL | Stock | 3.3329 | 3.3357 | 3.3182 | 3.3214 | 1493520.0 |
| 2007-01-10 07:45:00 | AAPL | Stock | 3.3214 | 3.3321 | 3.3196 | 3.3304 | 721196.0 |
| 2007-01-10 07:50:00 | AAPL | Stock | 3.3304 | 3.3371 | 3.3286 | 3.3364 | 1049608.0 |
| 2007-01-10 07:55:00 | AAPL | Stock | 3.3368 | 3.3368 | 3.3304 | 3.3304 | 227612.0 |
| 2007-01-10 08:00:00 | AAPL | Stock | 3.3268 | 3.3371 | 3.3179 | 3.3268 | 5883668.0 |
| 2007-01-10 08:05:00 | AAPL | Stock | 3.3268 | 3.3339 | 3.3268 | 3.3321 | 2292696.0 |
| 2007-01-10 08:10:00 | AAPL | Stock | 3.3321 | 3.3389 | 3.3321 | 3.3371 | 2375100.0 |
| 2007-01-10 08:15:00 | AAPL | Stock | 3.3375 | 3.3464 | 3.3346 | 3.3346 | 4053028.0 |
| 2007-01-10 08:20:00 | AAPL | Stock | 3.3461 | 3.3586 | 3.3425 | 3.3586 | 5048428.0 |
| 2007-01-10 08:25:00 | AAPL | Stock | 3.3586 | 3.3636 | 3.3561 | 3.3586 | 5935608.0 |
| 2007-01-10 08:30:00 | AAPL | Stock | 3.3586 | 3.3593 | 3.3518 | 3.3575 | 3171896.0 |
| 2007-01-10 08:35:00 | AAPL | Stock | 3.3571 | 3.3636 | 3.3546 | 3.3621 | 3259368.0 |
| 2007-01-10 08:40:00 | AAPL | Stock | 3.3618 | 3.3646 | 3.3589 | 3.3643 | 3957688.0 |
| 2007-01-10 08:45:00 | AAPL | Stock | 3.3643 | 3.3664 | 3.3607 | 3.3629 | 6400072.0 |
| 2007-01-10 08:50:00 | AAPL | Stock | 3.3632 | 3.3643 | 3.3607 | 3.3625 | 4475940.0 |
| 2007-01-10 08:55:00 | AAPL | Stock | 3.3625 | 3.3654 | 3.3607 | 3.365 | 4185440.0 |
| 2007-01-10 09:00:00 | AAPL | Stock | 3.365 | 3.3711 | 3.3625 | 3.3711 | 7848904.0 |
| 2007-01-10 09:05:00 | AAPL | Stock | 3.3704 | 3.3764 | 3.3696 | 3.3732 | 6306720.0 |
| 2007-01-10 09:10:00 | AAPL | Stock | 3.3732 | 3.3804 | 3.3711 | 3.3725 | 6725936.0 |
| 2007-01-10 09:15:00 | AAPL | Stock | 3.3725 | 3.3739 | 3.3618 | 3.3646 | 8059352.0 |
| 2007-01-10 09:20:00 | AAPL | Stock | 3.3646 | 3.3736 | 3.3618 | 3.3732 | 3742452.0 |
| 2007-01-10 09:25:00 | AAPL | Stock | 3.3718 | 3.3839 | 3.3664 | 3.3839 | 12168912.0 |
| 2007-01-10 09:30:00 | AAPL | Stock | 3.3839 | 3.3943 | 3.3511 | 3.3521 | 140879340.0 |
| 2007-01-10 09:35:00 | AAPL | Stock | 3.3521 | 3.3875 | 3.3411 | 3.3611 | 90727140.0 |
| 2007-01-10 09:40:00 | AAPL | Stock | 3.3614 | 3.3936 | 3.3375 | 3.3571 | 67612468.0 |
| 2007-01-10 09:45:00 | AAPL | Stock | 3.3571 | 3.3939 | 3.3464 | 3.3682 | 52541328.0 |
| 2007-01-10 09:50:00 | AAPL | Stock | 3.3689 | 3.3854 | 3.3639 | 3.3854 | 59065328.0 |
| 2007-01-10 09:55:00 | AAPL | Stock | 3.3854 | 3.3907 | 3.3746 | 3.3871 | 65190776.0 |
| 2007-01-10 10:00:00 | AAPL | Stock | 3.3875 | 3.3975 | 3.3804 | 3.3814 | 68117532.0 |
| 2007-01-10 10:05:00 | AAPL | Stock | 3.3821 | 3.3964 | 3.3811 | 3.3857 | 39061820.0 |
| 2007-01-10 10:10:00 | AAPL | Stock | 3.385 | 3.39 | 3.3764 | 3.3818 | 38500980.0 |
> showing 50 of 242,973 rows — these rows as CSV