PREVIEW / stock_5min / 2005-06-09
file: by_date/stock_5min/2005/2005-06-09.parquet size: 2.7 MB rows: 193,777 symbols: 1,983
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 |
|---|---|---|---|---|---|---|---|
| 2005-06-09 08:15:00 | AAPL | Stock | 1.3143 | 1.3143 | 1.3143 | 1.3143 | 11900.0 |
| 2005-06-09 08:20:00 | AAPL | Stock | 1.3157 | 1.3157 | 1.3157 | 1.3157 | 14000.0 |
| 2005-06-09 08:35:00 | AAPL | Stock | 1.3157 | 1.3157 | 1.3157 | 1.3157 | 25200.0 |
| 2005-06-09 09:05:00 | AAPL | Stock | 1.3168 | 1.3168 | 1.3164 | 1.3164 | 35280.0 |
| 2005-06-09 09:10:00 | AAPL | Stock | 1.3164 | 1.3168 | 1.3164 | 1.3168 | 33600.0 |
| 2005-06-09 09:15:00 | AAPL | Stock | 1.3211 | 1.3214 | 1.3207 | 1.3214 | 112000.0 |
| 2005-06-09 09:20:00 | AAPL | Stock | 1.3218 | 1.3218 | 1.3218 | 1.3218 | 5600.0 |
| 2005-06-09 09:25:00 | AAPL | Stock | 1.3218 | 1.3218 | 1.3196 | 1.3196 | 819952.0 |
| 2005-06-09 09:30:00 | AAPL | Stock | 1.3214 | 1.3296 | 1.3189 | 1.3286 | 10304056.0 |
| 2005-06-09 09:35:00 | AAPL | Stock | 1.3286 | 1.3289 | 1.325 | 1.3268 | 6314532.0 |
| 2005-06-09 09:40:00 | AAPL | Stock | 1.3268 | 1.33 | 1.325 | 1.3296 | 6460608.0 |
| 2005-06-09 09:45:00 | AAPL | Stock | 1.3296 | 1.3339 | 1.3289 | 1.3304 | 8267840.0 |
| 2005-06-09 09:50:00 | AAPL | Stock | 1.3304 | 1.3332 | 1.33 | 1.3318 | 5297208.0 |
| 2005-06-09 09:55:00 | AAPL | Stock | 1.3318 | 1.3339 | 1.3286 | 1.3311 | 4880932.0 |
| 2005-06-09 10:00:00 | AAPL | Stock | 1.3307 | 1.3325 | 1.3264 | 1.33 | 8249360.0 |
| 2005-06-09 10:05:00 | AAPL | Stock | 1.3296 | 1.3321 | 1.3296 | 1.3311 | 3779300.0 |
| 2005-06-09 10:10:00 | AAPL | Stock | 1.3311 | 1.3314 | 1.3275 | 1.3282 | 2366924.0 |
| 2005-06-09 10:15:00 | AAPL | Stock | 1.3282 | 1.3293 | 1.3232 | 1.325 | 8581804.0 |
| 2005-06-09 10:20:00 | AAPL | Stock | 1.325 | 1.3257 | 1.3193 | 1.3229 | 7676872.0 |
| 2005-06-09 10:25:00 | AAPL | Stock | 1.3232 | 1.3232 | 1.3175 | 1.3225 | 5752068.0 |
| 2005-06-09 10:30:00 | AAPL | Stock | 1.3221 | 1.3232 | 1.3207 | 1.3214 | 3677128.0 |
| 2005-06-09 10:35:00 | AAPL | Stock | 1.3218 | 1.3221 | 1.315 | 1.3179 | 7388136.0 |
| 2005-06-09 10:40:00 | AAPL | Stock | 1.3179 | 1.3196 | 1.3164 | 1.3168 | 4772992.0 |
| 2005-06-09 10:45:00 | AAPL | Stock | 1.3171 | 1.3225 | 1.3164 | 1.3211 | 4579736.0 |
| 2005-06-09 10:50:00 | AAPL | Stock | 1.3214 | 1.325 | 1.3204 | 1.3221 | 3707816.0 |
| 2005-06-09 10:55:00 | AAPL | Stock | 1.3225 | 1.3257 | 1.3218 | 1.3246 | 4505732.0 |
| 2005-06-09 11:00:00 | AAPL | Stock | 1.3246 | 1.3271 | 1.3243 | 1.3246 | 3553480.0 |
| 2005-06-09 11:05:00 | AAPL | Stock | 1.3243 | 1.3286 | 1.3243 | 1.3271 | 6045648.0 |
| 2005-06-09 11:10:00 | AAPL | Stock | 1.3271 | 1.3279 | 1.3246 | 1.325 | 2618448.0 |
| 2005-06-09 11:15:00 | AAPL | Stock | 1.325 | 1.3282 | 1.3236 | 1.3257 | 8879584.0 |
| 2005-06-09 11:20:00 | AAPL | Stock | 1.3257 | 1.3282 | 1.3243 | 1.3271 | 2844072.0 |
| 2005-06-09 11:25:00 | AAPL | Stock | 1.3275 | 1.33 | 1.3261 | 1.3286 | 6697600.0 |
| 2005-06-09 11:30:00 | AAPL | Stock | 1.3286 | 1.3304 | 1.3279 | 1.3282 | 2695392.0 |
| 2005-06-09 11:35:00 | AAPL | Stock | 1.3282 | 1.3314 | 1.3282 | 1.3304 | 6485108.0 |
| 2005-06-09 11:40:00 | AAPL | Stock | 1.3304 | 1.3343 | 1.3286 | 1.3325 | 7477960.0 |
| 2005-06-09 11:45:00 | AAPL | Stock | 1.3325 | 1.3336 | 1.3314 | 1.3325 | 2814560.0 |
| 2005-06-09 11:50:00 | AAPL | Stock | 1.3329 | 1.3346 | 1.3318 | 1.3343 | 3282860.0 |
| 2005-06-09 11:55:00 | AAPL | Stock | 1.3339 | 1.3346 | 1.3314 | 1.3346 | 3698548.0 |
| 2005-06-09 12:00:00 | AAPL | Stock | 1.3343 | 1.3375 | 1.3343 | 1.335 | 6938820.0 |
| 2005-06-09 12:05:00 | AAPL | Stock | 1.335 | 1.3389 | 1.335 | 1.3379 | 6224372.0 |
| 2005-06-09 12:10:00 | AAPL | Stock | 1.3379 | 1.3386 | 1.3371 | 1.3382 | 3735368.0 |
| 2005-06-09 12:15:00 | AAPL | Stock | 1.3382 | 1.3396 | 1.3371 | 1.3389 | 4023040.0 |
| 2005-06-09 12:20:00 | AAPL | Stock | 1.3386 | 1.3393 | 1.3375 | 1.3393 | 4806368.0 |
| 2005-06-09 12:25:00 | AAPL | Stock | 1.3389 | 1.3457 | 1.3389 | 1.3439 | 11163572.0 |
| 2005-06-09 12:30:00 | AAPL | Stock | 1.3443 | 1.345 | 1.3425 | 1.3436 | 5210716.0 |
| 2005-06-09 12:35:00 | AAPL | Stock | 1.3436 | 1.345 | 1.3418 | 1.3436 | 3868676.0 |
| 2005-06-09 12:40:00 | AAPL | Stock | 1.3436 | 1.3461 | 1.3436 | 1.3454 | 6758780.0 |
| 2005-06-09 12:45:00 | AAPL | Stock | 1.3454 | 1.3461 | 1.3436 | 1.3446 | 2986284.0 |
| 2005-06-09 12:50:00 | AAPL | Stock | 1.3446 | 1.345 | 1.3432 | 1.3436 | 3516716.0 |
| 2005-06-09 12:55:00 | AAPL | Stock | 1.3432 | 1.3507 | 1.3432 | 1.3493 | 8319164.0 |
> showing 50 of 193,777 rows — these rows as CSV