PREVIEW / stock_5min / 2006-04-18
file: by_date/stock_5min/2006/2006-04-18.parquet size: 3.2 MB rows: 230,757 symbols: 2,240
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-04-18 06:45:00 | AAPL | Stock | 2.3214 | 2.3214 | 2.3214 | 2.3214 | 2800.0 |
| 2006-04-18 07:15:00 | AAPL | Stock | 2.3146 | 2.3146 | 2.3146 | 2.3146 | 14000.0 |
| 2006-04-18 07:20:00 | AAPL | Stock | 2.3082 | 2.3214 | 2.3079 | 2.3214 | 50848.0 |
| 2006-04-18 07:25:00 | AAPL | Stock | 2.3179 | 2.3179 | 2.3179 | 2.3179 | 2800.0 |
| 2006-04-18 07:35:00 | AAPL | Stock | 2.3211 | 2.3214 | 2.3211 | 2.3214 | 19600.0 |
| 2006-04-18 07:50:00 | AAPL | Stock | 2.3225 | 2.3225 | 2.3225 | 2.3225 | 2800.0 |
| 2006-04-18 08:00:00 | AAPL | Stock | 2.3232 | 2.3268 | 2.3225 | 2.3239 | 142576.0 |
| 2006-04-18 08:05:00 | AAPL | Stock | 2.3257 | 2.3257 | 2.3214 | 2.3214 | 109200.0 |
| 2006-04-18 08:10:00 | AAPL | Stock | 2.3214 | 2.3218 | 2.3186 | 2.3193 | 131824.0 |
| 2006-04-18 08:15:00 | AAPL | Stock | 2.3207 | 2.3207 | 2.3207 | 2.3207 | 5824.0 |
| 2006-04-18 08:20:00 | AAPL | Stock | 2.3182 | 2.3211 | 2.3182 | 2.3211 | 25200.0 |
| 2006-04-18 08:25:00 | AAPL | Stock | 2.3207 | 2.3214 | 2.3186 | 2.3189 | 105028.0 |
| 2006-04-18 08:30:00 | AAPL | Stock | 2.3196 | 2.3207 | 2.3196 | 2.3196 | 64400.0 |
| 2006-04-18 08:35:00 | AAPL | Stock | 2.3196 | 2.3196 | 2.3186 | 2.3186 | 30352.0 |
| 2006-04-18 08:40:00 | AAPL | Stock | 2.3189 | 2.3189 | 2.3182 | 2.3182 | 51240.0 |
| 2006-04-18 08:45:00 | AAPL | Stock | 2.3182 | 2.32 | 2.3182 | 2.32 | 41580.0 |
| 2006-04-18 08:50:00 | AAPL | Stock | 2.32 | 2.3236 | 2.32 | 2.3236 | 449008.0 |
| 2006-04-18 08:55:00 | AAPL | Stock | 2.3236 | 2.3246 | 2.3214 | 2.3229 | 172760.0 |
| 2006-04-18 09:00:00 | AAPL | Stock | 2.3239 | 2.3254 | 2.3221 | 2.3221 | 112000.0 |
| 2006-04-18 09:05:00 | AAPL | Stock | 2.3236 | 2.3236 | 2.3146 | 2.3214 | 3633000.0 |
| 2006-04-18 09:10:00 | AAPL | Stock | 2.32 | 2.3236 | 2.32 | 2.3232 | 147420.0 |
| 2006-04-18 09:15:00 | AAPL | Stock | 2.3236 | 2.3236 | 2.3221 | 2.3221 | 71400.0 |
| 2006-04-18 09:20:00 | AAPL | Stock | 2.3229 | 2.3232 | 2.3229 | 2.3229 | 130760.0 |
| 2006-04-18 09:25:00 | AAPL | Stock | 2.3229 | 2.3239 | 2.3214 | 2.3225 | 579320.0 |
| 2006-04-18 09:30:00 | AAPL | Stock | 2.323 | 2.3396 | 2.3214 | 2.3321 | 27523692.0 |
| 2006-04-18 09:35:00 | AAPL | Stock | 2.3314 | 2.3321 | 2.3218 | 2.3257 | 15322832.0 |
| 2006-04-18 09:40:00 | AAPL | Stock | 2.3257 | 2.3375 | 2.3246 | 2.3368 | 16476740.0 |
| 2006-04-18 09:45:00 | AAPL | Stock | 2.3364 | 2.3368 | 2.3289 | 2.3318 | 11042836.0 |
| 2006-04-18 09:50:00 | AAPL | Stock | 2.3314 | 2.3346 | 2.3261 | 2.3286 | 11659816.0 |
| 2006-04-18 09:55:00 | AAPL | Stock | 2.3286 | 2.3329 | 2.3282 | 2.3304 | 12145196.0 |
| 2006-04-18 10:00:00 | AAPL | Stock | 2.3304 | 2.3343 | 2.3282 | 2.3304 | 12856956.0 |
| 2006-04-18 10:05:00 | AAPL | Stock | 2.33 | 2.3314 | 2.3164 | 2.3189 | 18537764.0 |
| 2006-04-18 10:10:00 | AAPL | Stock | 2.3193 | 2.3239 | 2.3161 | 2.32 | 22393700.0 |
| 2006-04-18 10:15:00 | AAPL | Stock | 2.3192 | 2.3246 | 2.3171 | 2.3236 | 11658192.0 |
| 2006-04-18 10:20:00 | AAPL | Stock | 2.3232 | 2.3236 | 2.3146 | 2.3146 | 13302660.0 |
| 2006-04-18 10:25:00 | AAPL | Stock | 2.3146 | 2.3204 | 2.3139 | 2.3164 | 12717096.0 |
| 2006-04-18 10:30:00 | AAPL | Stock | 2.3161 | 2.3321 | 2.3161 | 2.33 | 15016876.0 |
| 2006-04-18 10:35:00 | AAPL | Stock | 2.3293 | 2.3343 | 2.3275 | 2.3332 | 12680024.0 |
| 2006-04-18 10:40:00 | AAPL | Stock | 2.3329 | 2.3339 | 2.3254 | 2.3289 | 9578100.0 |
| 2006-04-18 10:45:00 | AAPL | Stock | 2.3289 | 2.3318 | 2.3268 | 2.3314 | 3107244.0 |
| 2006-04-18 10:50:00 | AAPL | Stock | 2.3311 | 2.3357 | 2.3307 | 2.3343 | 7859208.0 |
| 2006-04-18 10:55:00 | AAPL | Stock | 2.3343 | 2.3357 | 2.3243 | 2.3246 | 8660792.0 |
| 2006-04-18 11:00:00 | AAPL | Stock | 2.3246 | 2.3261 | 2.3236 | 2.3243 | 4050284.0 |
| 2006-04-18 11:05:00 | AAPL | Stock | 2.3243 | 2.3307 | 2.3225 | 2.3289 | 6905584.0 |
| 2006-04-18 11:10:00 | AAPL | Stock | 2.3289 | 2.3332 | 2.3289 | 2.3307 | 5234852.0 |
| 2006-04-18 11:15:00 | AAPL | Stock | 2.3311 | 2.3346 | 2.3268 | 2.3332 | 6697852.0 |
| 2006-04-18 11:20:00 | AAPL | Stock | 2.3332 | 2.3332 | 2.3293 | 2.3304 | 3757236.0 |
| 2006-04-18 11:25:00 | AAPL | Stock | 2.3303 | 2.3339 | 2.3279 | 2.3321 | 4943148.0 |
| 2006-04-18 11:30:00 | AAPL | Stock | 2.3318 | 2.3346 | 2.3296 | 2.3321 | 5359060.0 |
| 2006-04-18 11:35:00 | AAPL | Stock | 2.3321 | 2.3325 | 2.325 | 2.3275 | 6818560.0 |
> showing 50 of 230,757 rows — these rows as CSV