PREVIEW / stock_5min / 2007-12-04
file: by_date/stock_5min/2007/2007-12-04.parquet size: 4.3 MB rows: 314,925 symbols: 3,218
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-12-04 05:25:00 | AAPL | Stock | 6.375 | 6.375 | 6.3729 | 6.3729 | 14000.0 |
| 2007-12-04 05:40:00 | AAPL | Stock | 6.3721 | 6.3721 | 6.3721 | 6.3721 | 2800.0 |
| 2007-12-04 06:40:00 | AAPL | Stock | 6.3571 | 6.3571 | 6.3571 | 6.3571 | 53200.0 |
| 2007-12-04 07:10:00 | AAPL | Stock | 6.3571 | 6.375 | 6.3571 | 6.375 | 16800.0 |
| 2007-12-04 07:15:00 | AAPL | Stock | 6.3554 | 6.3571 | 6.3554 | 6.3571 | 14000.0 |
| 2007-12-04 07:20:00 | AAPL | Stock | 6.3521 | 6.3521 | 6.3521 | 6.3521 | 14000.0 |
| 2007-12-04 07:25:00 | AAPL | Stock | 6.3518 | 6.3518 | 6.3371 | 6.3429 | 54376.0 |
| 2007-12-04 07:30:00 | AAPL | Stock | 6.3429 | 6.3429 | 6.3429 | 6.3429 | 91084.0 |
| 2007-12-04 07:35:00 | AAPL | Stock | 6.3325 | 6.3325 | 6.3325 | 6.3325 | 4424.0 |
| 2007-12-04 07:40:00 | AAPL | Stock | 6.3325 | 6.3393 | 6.3325 | 6.3393 | 35840.0 |
| 2007-12-04 07:45:00 | AAPL | Stock | 6.3393 | 6.3464 | 6.3325 | 6.3464 | 81760.0 |
| 2007-12-04 07:50:00 | AAPL | Stock | 6.3464 | 6.35 | 6.3393 | 6.3393 | 35420.0 |
| 2007-12-04 07:55:00 | AAPL | Stock | 6.345 | 6.345 | 6.345 | 6.345 | 2800.0 |
| 2007-12-04 08:00:00 | AAPL | Stock | 6.345 | 6.35 | 6.3161 | 6.3207 | 805364.0 |
| 2007-12-04 08:05:00 | AAPL | Stock | 6.3179 | 6.3268 | 6.3161 | 6.3232 | 458444.0 |
| 2007-12-04 08:10:00 | AAPL | Stock | 6.3261 | 6.3268 | 6.3089 | 6.31 | 664748.0 |
| 2007-12-04 08:15:00 | AAPL | Stock | 6.3136 | 6.3161 | 6.2996 | 6.3039 | 579236.0 |
| 2007-12-04 08:20:00 | AAPL | Stock | 6.3057 | 6.3068 | 6.2975 | 6.2979 | 574812.0 |
| 2007-12-04 08:25:00 | AAPL | Stock | 6.2979 | 6.3 | 6.2925 | 6.3 | 485940.0 |
| 2007-12-04 08:30:00 | AAPL | Stock | 6.3014 | 6.3164 | 6.3 | 6.3104 | 879704.0 |
| 2007-12-04 08:35:00 | AAPL | Stock | 6.31 | 6.3196 | 6.31 | 6.3171 | 370720.0 |
| 2007-12-04 08:40:00 | AAPL | Stock | 6.3143 | 6.3171 | 6.3096 | 6.3132 | 220164.0 |
| 2007-12-04 08:45:00 | AAPL | Stock | 6.3132 | 6.3286 | 6.3132 | 6.3232 | 563276.0 |
| 2007-12-04 08:50:00 | AAPL | Stock | 6.3254 | 6.3286 | 6.3157 | 6.3232 | 378448.0 |
| 2007-12-04 08:55:00 | AAPL | Stock | 6.3239 | 6.3318 | 6.3143 | 6.3157 | 401576.0 |
| 2007-12-04 09:00:00 | AAPL | Stock | 6.3157 | 6.3232 | 6.3157 | 6.32 | 265216.0 |
| 2007-12-04 09:05:00 | AAPL | Stock | 6.3179 | 6.325 | 6.3161 | 6.325 | 595980.0 |
| 2007-12-04 09:10:00 | AAPL | Stock | 6.325 | 6.3254 | 6.3079 | 6.3196 | 638848.0 |
| 2007-12-04 09:15:00 | AAPL | Stock | 6.3186 | 6.3218 | 6.3161 | 6.3161 | 189924.0 |
| 2007-12-04 09:20:00 | AAPL | Stock | 6.3161 | 6.3214 | 6.3121 | 6.3193 | 536592.0 |
| 2007-12-04 09:25:00 | AAPL | Stock | 6.3207 | 6.335 | 6.3171 | 6.3268 | 758604.0 |
| 2007-12-04 09:30:00 | AAPL | Stock | 6.3257 | 6.3875 | 6.3211 | 6.3671 | 36733508.0 |
| 2007-12-04 09:35:00 | AAPL | Stock | 6.3639 | 6.4107 | 6.3443 | 6.4068 | 26127472.0 |
| 2007-12-04 09:40:00 | AAPL | Stock | 6.4068 | 6.425 | 6.4018 | 6.4111 | 25921028.0 |
| 2007-12-04 09:45:00 | AAPL | Stock | 6.4107 | 6.4418 | 6.4018 | 6.4243 | 23535484.0 |
| 2007-12-04 09:50:00 | AAPL | Stock | 6.4243 | 6.4264 | 6.3807 | 6.3886 | 23731176.0 |
| 2007-12-04 09:55:00 | AAPL | Stock | 6.3889 | 6.4221 | 6.3843 | 6.42 | 13041644.0 |
| 2007-12-04 10:00:00 | AAPL | Stock | 6.4189 | 6.4357 | 6.4096 | 6.4111 | 14681548.0 |
| 2007-12-04 10:05:00 | AAPL | Stock | 6.41 | 6.4246 | 6.405 | 6.4093 | 9117584.0 |
| 2007-12-04 10:10:00 | AAPL | Stock | 6.4079 | 6.4339 | 6.4039 | 6.4254 | 13092016.0 |
| 2007-12-04 10:15:00 | AAPL | Stock | 6.4254 | 6.435 | 6.415 | 6.42 | 10409196.0 |
| 2007-12-04 10:20:00 | AAPL | Stock | 6.4204 | 6.4229 | 6.3936 | 6.3964 | 10843420.0 |
| 2007-12-04 10:25:00 | AAPL | Stock | 6.3982 | 6.4304 | 6.3982 | 6.4205 | 9735516.0 |
| 2007-12-04 10:30:00 | AAPL | Stock | 6.4218 | 6.4518 | 6.4211 | 6.4343 | 19145700.0 |
| 2007-12-04 10:35:00 | AAPL | Stock | 6.4346 | 6.4425 | 6.4246 | 6.4379 | 12102412.0 |
| 2007-12-04 10:40:00 | AAPL | Stock | 6.4382 | 6.4404 | 6.4239 | 6.4368 | 8726872.0 |
| 2007-12-04 10:45:00 | AAPL | Stock | 6.4368 | 6.4446 | 6.4125 | 6.4168 | 13553736.0 |
| 2007-12-04 10:50:00 | AAPL | Stock | 6.4168 | 6.4229 | 6.4086 | 6.4104 | 7996632.0 |
| 2007-12-04 10:55:00 | AAPL | Stock | 6.4107 | 6.425 | 6.4021 | 6.4046 | 8591856.0 |
| 2007-12-04 11:00:00 | AAPL | Stock | 6.4046 | 6.4114 | 6.3968 | 6.4039 | 9437372.0 |
> showing 50 of 314,925 rows — these rows as CSV