PREVIEW / stock_5min / 2005-05-09
file: by_date/stock_5min/2005/2005-05-09.parquet size: 2.6 MB rows: 194,705 symbols: 1,964
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-05-09 08:00:00 | AAPL | Stock | 1.3321 | 1.3321 | 1.33 | 1.33 | 36820.0 |
| 2005-05-09 08:15:00 | AAPL | Stock | 1.3314 | 1.3321 | 1.3314 | 1.3321 | 58800.0 |
| 2005-05-09 08:20:00 | AAPL | Stock | 1.3329 | 1.3329 | 1.3321 | 1.3321 | 46228.0 |
| 2005-05-09 08:30:00 | AAPL | Stock | 1.3339 | 1.3364 | 1.3339 | 1.3364 | 148316.0 |
| 2005-05-09 08:35:00 | AAPL | Stock | 1.3357 | 1.3357 | 1.3357 | 1.3357 | 120400.0 |
| 2005-05-09 08:40:00 | AAPL | Stock | 1.3357 | 1.3357 | 1.3336 | 1.3336 | 7000.0 |
| 2005-05-09 08:45:00 | AAPL | Stock | 1.3343 | 1.3343 | 1.3336 | 1.3336 | 40516.0 |
| 2005-05-09 08:50:00 | AAPL | Stock | 1.3357 | 1.3357 | 1.3357 | 1.3357 | 2800.0 |
| 2005-05-09 08:55:00 | AAPL | Stock | 1.3343 | 1.3354 | 1.3343 | 1.335 | 728616.0 |
| 2005-05-09 09:00:00 | AAPL | Stock | 1.3354 | 1.3357 | 1.335 | 1.335 | 147084.0 |
| 2005-05-09 09:05:00 | AAPL | Stock | 1.3343 | 1.3364 | 1.3343 | 1.3354 | 74116.0 |
| 2005-05-09 09:10:00 | AAPL | Stock | 1.3343 | 1.3354 | 1.3321 | 1.3329 | 104384.0 |
| 2005-05-09 09:15:00 | AAPL | Stock | 1.3346 | 1.3346 | 1.3321 | 1.3321 | 32228.0 |
| 2005-05-09 09:20:00 | AAPL | Stock | 1.3314 | 1.3329 | 1.3314 | 1.3329 | 40600.0 |
| 2005-05-09 09:25:00 | AAPL | Stock | 1.3307 | 1.335 | 1.3264 | 1.3279 | 910336.0 |
| 2005-05-09 09:30:00 | AAPL | Stock | 1.3314 | 1.3375 | 1.3289 | 1.3314 | 11587716.0 |
| 2005-05-09 09:35:00 | AAPL | Stock | 1.3311 | 1.3336 | 1.3293 | 1.33 | 4718000.0 |
| 2005-05-09 09:40:00 | AAPL | Stock | 1.33 | 1.3307 | 1.3268 | 1.3296 | 7382228.0 |
| 2005-05-09 09:45:00 | AAPL | Stock | 1.33 | 1.3304 | 1.3254 | 1.3257 | 5319328.0 |
| 2005-05-09 09:50:00 | AAPL | Stock | 1.3257 | 1.3268 | 1.3189 | 1.3204 | 10311112.0 |
| 2005-05-09 09:55:00 | AAPL | Stock | 1.3207 | 1.3211 | 1.3171 | 1.3196 | 10226412.0 |
| 2005-05-09 10:00:00 | AAPL | Stock | 1.3196 | 1.32 | 1.315 | 1.3157 | 11721584.0 |
| 2005-05-09 10:05:00 | AAPL | Stock | 1.3157 | 1.3189 | 1.3154 | 1.3168 | 6060292.0 |
| 2005-05-09 10:10:00 | AAPL | Stock | 1.3168 | 1.3179 | 1.3125 | 1.3157 | 7745304.0 |
| 2005-05-09 10:15:00 | AAPL | Stock | 1.3154 | 1.3157 | 1.3125 | 1.3132 | 5186132.0 |
| 2005-05-09 10:20:00 | AAPL | Stock | 1.3136 | 1.3157 | 1.3125 | 1.3139 | 5620216.0 |
| 2005-05-09 10:25:00 | AAPL | Stock | 1.3143 | 1.3175 | 1.3143 | 1.3146 | 7589232.0 |
| 2005-05-09 10:30:00 | AAPL | Stock | 1.3146 | 1.3175 | 1.3139 | 1.3175 | 5578888.0 |
| 2005-05-09 10:35:00 | AAPL | Stock | 1.3175 | 1.3193 | 1.3157 | 1.3168 | 9089080.0 |
| 2005-05-09 10:40:00 | AAPL | Stock | 1.3168 | 1.3189 | 1.3139 | 1.3139 | 6718040.0 |
| 2005-05-09 10:45:00 | AAPL | Stock | 1.3136 | 1.3164 | 1.3125 | 1.3157 | 3837764.0 |
| 2005-05-09 10:50:00 | AAPL | Stock | 1.3161 | 1.3164 | 1.3143 | 1.3161 | 2396156.0 |
| 2005-05-09 10:55:00 | AAPL | Stock | 1.3161 | 1.3168 | 1.3146 | 1.3146 | 2212000.0 |
| 2005-05-09 11:00:00 | AAPL | Stock | 1.3146 | 1.3164 | 1.3136 | 1.3161 | 2784012.0 |
| 2005-05-09 11:05:00 | AAPL | Stock | 1.3161 | 1.3164 | 1.3146 | 1.315 | 2213064.0 |
| 2005-05-09 11:10:00 | AAPL | Stock | 1.3146 | 1.3164 | 1.3139 | 1.3157 | 4307632.0 |
| 2005-05-09 11:15:00 | AAPL | Stock | 1.3157 | 1.3175 | 1.3146 | 1.3168 | 3646076.0 |
| 2005-05-09 11:20:00 | AAPL | Stock | 1.3168 | 1.32 | 1.3164 | 1.3196 | 4896304.0 |
| 2005-05-09 11:25:00 | AAPL | Stock | 1.32 | 1.3207 | 1.3179 | 1.3189 | 4341820.0 |
| 2005-05-09 11:30:00 | AAPL | Stock | 1.3189 | 1.3257 | 1.3186 | 1.3243 | 6463744.0 |
| 2005-05-09 11:35:00 | AAPL | Stock | 1.3243 | 1.3261 | 1.3229 | 1.3254 | 4742976.0 |
| 2005-05-09 11:40:00 | AAPL | Stock | 1.3254 | 1.3286 | 1.3246 | 1.3275 | 8070748.0 |
| 2005-05-09 11:45:00 | AAPL | Stock | 1.3275 | 1.3278 | 1.325 | 1.3261 | 4429348.0 |
| 2005-05-09 11:50:00 | AAPL | Stock | 1.3257 | 1.3261 | 1.3225 | 1.3225 | 3516072.0 |
| 2005-05-09 11:55:00 | AAPL | Stock | 1.3229 | 1.3257 | 1.3229 | 1.3232 | 2825536.0 |
| 2005-05-09 12:00:00 | AAPL | Stock | 1.3229 | 1.3236 | 1.3225 | 1.3229 | 1221948.0 |
| 2005-05-09 12:05:00 | AAPL | Stock | 1.3229 | 1.3261 | 1.3225 | 1.3229 | 2711352.0 |
| 2005-05-09 12:10:00 | AAPL | Stock | 1.3229 | 1.325 | 1.3225 | 1.3239 | 2410156.0 |
| 2005-05-09 12:15:00 | AAPL | Stock | 1.3239 | 1.3246 | 1.3229 | 1.3232 | 2332120.0 |
| 2005-05-09 12:20:00 | AAPL | Stock | 1.3232 | 1.3239 | 1.3229 | 1.3229 | 2053352.0 |
> showing 50 of 194,705 rows — these rows as CSV