PREVIEW / stock_5min / 2006-11-29
file: by_date/stock_5min/2006/2006-11-29.parquet size: 3.3 MB rows: 237,730 symbols: 2,460
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 |
|---|---|---|---|---|---|---|---|
| 2006-11-29 07:05:00 | AAPL | Stock | 3.3021 | 3.3025 | 3.3021 | 3.3025 | 61600.0 |
| 2006-11-29 07:10:00 | AAPL | Stock | 3.3064 | 3.3214 | 3.3064 | 3.3164 | 188720.0 |
| 2006-11-29 07:15:00 | AAPL | Stock | 3.3211 | 3.3214 | 3.3168 | 3.3214 | 191800.0 |
| 2006-11-29 07:20:00 | AAPL | Stock | 3.3214 | 3.3214 | 3.3214 | 3.3214 | 49000.0 |
| 2006-11-29 07:25:00 | AAPL | Stock | 3.3171 | 3.3171 | 3.3171 | 3.3171 | 10080.0 |
| 2006-11-29 07:30:00 | AAPL | Stock | 3.3211 | 3.3286 | 3.3164 | 3.3214 | 388080.0 |
| 2006-11-29 07:35:00 | AAPL | Stock | 3.3214 | 3.3239 | 3.3211 | 3.3239 | 159880.0 |
| 2006-11-29 07:40:00 | AAPL | Stock | 3.3239 | 3.3286 | 3.3239 | 3.3286 | 169120.0 |
| 2006-11-29 07:45:00 | AAPL | Stock | 3.3286 | 3.3393 | 3.3286 | 3.3393 | 604800.0 |
| 2006-11-29 07:50:00 | AAPL | Stock | 3.3393 | 3.3536 | 3.3325 | 3.3325 | 910000.0 |
| 2006-11-29 07:55:00 | AAPL | Stock | 3.3336 | 3.3357 | 3.3293 | 3.3357 | 347200.0 |
| 2006-11-29 08:00:00 | AAPL | Stock | 3.3339 | 3.3357 | 3.325 | 3.3286 | 2458316.0 |
| 2006-11-29 08:05:00 | AAPL | Stock | 3.3286 | 3.3286 | 3.3232 | 3.3232 | 703192.0 |
| 2006-11-29 08:10:00 | AAPL | Stock | 3.3232 | 3.325 | 3.3164 | 3.3214 | 798420.0 |
| 2006-11-29 08:15:00 | AAPL | Stock | 3.3214 | 3.3246 | 3.3193 | 3.3207 | 585480.0 |
| 2006-11-29 08:20:00 | AAPL | Stock | 3.3207 | 3.3282 | 3.3196 | 3.3268 | 502544.0 |
| 2006-11-29 08:25:00 | AAPL | Stock | 3.3271 | 3.3271 | 3.3218 | 3.3236 | 327264.0 |
| 2006-11-29 08:30:00 | AAPL | Stock | 3.3243 | 3.3336 | 3.3243 | 3.3304 | 962500.0 |
| 2006-11-29 08:35:00 | AAPL | Stock | 3.3296 | 3.3336 | 3.3296 | 3.3304 | 505680.0 |
| 2006-11-29 08:40:00 | AAPL | Stock | 3.3314 | 3.3318 | 3.325 | 3.3293 | 508592.0 |
| 2006-11-29 08:45:00 | AAPL | Stock | 3.3304 | 3.3321 | 3.3286 | 3.33 | 752668.0 |
| 2006-11-29 08:50:00 | AAPL | Stock | 3.3304 | 3.3318 | 3.33 | 3.3314 | 214200.0 |
| 2006-11-29 08:55:00 | AAPL | Stock | 3.3304 | 3.335 | 3.3304 | 3.3346 | 717360.0 |
| 2006-11-29 09:00:00 | AAPL | Stock | 3.335 | 3.3357 | 3.3321 | 3.3325 | 687148.0 |
| 2006-11-29 09:05:00 | AAPL | Stock | 3.3339 | 3.3339 | 3.3307 | 3.3318 | 520156.0 |
| 2006-11-29 09:10:00 | AAPL | Stock | 3.3311 | 3.3329 | 3.3307 | 3.3311 | 625940.0 |
| 2006-11-29 09:15:00 | AAPL | Stock | 3.3311 | 3.3314 | 3.3257 | 3.3271 | 636384.0 |
| 2006-11-29 09:20:00 | AAPL | Stock | 3.3268 | 3.3339 | 3.3268 | 3.3304 | 670040.0 |
| 2006-11-29 09:25:00 | AAPL | Stock | 3.3304 | 3.3314 | 3.3196 | 3.3221 | 1903216.0 |
| 2006-11-29 09:30:00 | AAPL | Stock | 3.3214 | 3.3261 | 3.3079 | 3.32 | 34606600.0 |
| 2006-11-29 09:35:00 | AAPL | Stock | 3.3207 | 3.3268 | 3.3125 | 3.3204 | 21976612.0 |
| 2006-11-29 09:40:00 | AAPL | Stock | 3.3204 | 3.3207 | 3.3051 | 3.3143 | 21579124.0 |
| 2006-11-29 09:45:00 | AAPL | Stock | 3.3139 | 3.3157 | 3.3029 | 3.3029 | 23956296.0 |
| 2006-11-29 09:50:00 | AAPL | Stock | 3.3029 | 3.3214 | 3.2964 | 3.3043 | 21413364.0 |
| 2006-11-29 09:55:00 | AAPL | Stock | 3.3046 | 3.305 | 3.295 | 3.2996 | 13070344.0 |
| 2006-11-29 10:00:00 | AAPL | Stock | 3.2999 | 3.3011 | 3.2893 | 3.2932 | 20736296.0 |
| 2006-11-29 10:05:00 | AAPL | Stock | 3.2939 | 3.3104 | 3.2925 | 3.3079 | 29842848.0 |
| 2006-11-29 10:10:00 | AAPL | Stock | 3.3082 | 3.31 | 3.2993 | 3.3029 | 18016096.0 |
| 2006-11-29 10:15:00 | AAPL | Stock | 3.3032 | 3.3054 | 3.2964 | 3.3 | 12179496.0 |
| 2006-11-29 10:20:00 | AAPL | Stock | 3.3 | 3.3129 | 3.2946 | 3.3125 | 18141508.0 |
| 2006-11-29 10:25:00 | AAPL | Stock | 3.3125 | 3.3175 | 3.3079 | 3.3129 | 23069592.0 |
| 2006-11-29 10:30:00 | AAPL | Stock | 3.3132 | 3.3161 | 3.2964 | 3.3014 | 19804400.0 |
| 2006-11-29 10:35:00 | AAPL | Stock | 3.3014 | 3.3043 | 3.2946 | 3.2957 | 13007736.0 |
| 2006-11-29 10:40:00 | AAPL | Stock | 3.2957 | 3.3025 | 3.2946 | 3.2957 | 12171096.0 |
| 2006-11-29 10:45:00 | AAPL | Stock | 3.2954 | 3.2957 | 3.2875 | 3.2882 | 20449968.0 |
| 2006-11-29 10:50:00 | AAPL | Stock | 3.2879 | 3.2893 | 3.2804 | 3.2832 | 23087904.0 |
| 2006-11-29 10:55:00 | AAPL | Stock | 3.2832 | 3.2943 | 3.2807 | 3.2943 | 15818124.0 |
| 2006-11-29 11:00:00 | AAPL | Stock | 3.2936 | 3.3 | 3.2911 | 3.2986 | 11159008.0 |
| 2006-11-29 11:05:00 | AAPL | Stock | 3.2989 | 3.3011 | 3.295 | 3.2968 | 10401272.0 |
| 2006-11-29 11:10:00 | AAPL | Stock | 3.2971 | 3.2989 | 3.2907 | 3.295 | 9485756.0 |
> showing 50 of 237,730 rows — these rows as CSV