PREVIEW / stock_5min / 2006-05-18
file: by_date/stock_5min/2006/2006-05-18.parquet size: 3.1 MB rows: 225,135 symbols: 2,267
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-05-18 04:25:00 | AAPL | Stock | 2.3321 | 2.3321 | 2.3321 | 2.3321 | 33600.0 |
| 2006-05-18 07:00:00 | AAPL | Stock | 2.3464 | 2.3464 | 2.3464 | 2.3464 | 16800.0 |
| 2006-05-18 08:00:00 | AAPL | Stock | 2.3464 | 2.3554 | 2.3357 | 2.3554 | 691320.0 |
| 2006-05-18 08:05:00 | AAPL | Stock | 2.3486 | 2.3486 | 2.3464 | 2.3464 | 16800.0 |
| 2006-05-18 08:10:00 | AAPL | Stock | 2.3486 | 2.3532 | 2.3446 | 2.3482 | 103852.0 |
| 2006-05-18 08:15:00 | AAPL | Stock | 2.3479 | 2.3493 | 2.3479 | 2.3493 | 55720.0 |
| 2006-05-18 08:20:00 | AAPL | Stock | 2.3496 | 2.3496 | 2.3464 | 2.3464 | 58800.0 |
| 2006-05-18 08:25:00 | AAPL | Stock | 2.3482 | 2.3482 | 2.3429 | 2.3429 | 124236.0 |
| 2006-05-18 08:30:00 | AAPL | Stock | 2.3482 | 2.3482 | 2.3461 | 2.3461 | 117628.0 |
| 2006-05-18 08:35:00 | AAPL | Stock | 2.3482 | 2.3496 | 2.3482 | 2.3482 | 64400.0 |
| 2006-05-18 08:40:00 | AAPL | Stock | 2.3482 | 2.3482 | 2.3482 | 2.3482 | 28924.0 |
| 2006-05-18 08:45:00 | AAPL | Stock | 2.3496 | 2.3514 | 2.3429 | 2.3429 | 180012.0 |
| 2006-05-18 08:50:00 | AAPL | Stock | 2.3411 | 2.3411 | 2.3411 | 2.3411 | 13272.0 |
| 2006-05-18 08:55:00 | AAPL | Stock | 2.3446 | 2.3475 | 2.3446 | 2.3475 | 168504.0 |
| 2006-05-18 09:00:00 | AAPL | Stock | 2.3475 | 2.3475 | 2.3475 | 2.3475 | 64400.0 |
| 2006-05-18 09:05:00 | AAPL | Stock | 2.3475 | 2.3486 | 2.3464 | 2.3482 | 151592.0 |
| 2006-05-18 09:10:00 | AAPL | Stock | 2.3471 | 2.3486 | 2.3468 | 2.3482 | 210420.0 |
| 2006-05-18 09:15:00 | AAPL | Stock | 2.3482 | 2.3482 | 2.3482 | 2.3482 | 47600.0 |
| 2006-05-18 09:20:00 | AAPL | Stock | 2.3482 | 2.3482 | 2.3479 | 2.3479 | 50400.0 |
| 2006-05-18 09:25:00 | AAPL | Stock | 2.345 | 2.3464 | 2.3411 | 2.3457 | 497420.0 |
| 2006-05-18 09:30:00 | AAPL | Stock | 2.3457 | 2.3664 | 2.3411 | 2.3629 | 32020716.0 |
| 2006-05-18 09:35:00 | AAPL | Stock | 2.3636 | 2.365 | 2.3439 | 2.3479 | 20780816.0 |
| 2006-05-18 09:40:00 | AAPL | Stock | 2.3479 | 2.3482 | 2.3343 | 2.34 | 19638220.0 |
| 2006-05-18 09:45:00 | AAPL | Stock | 2.3396 | 2.3482 | 2.3379 | 2.3425 | 11387488.0 |
| 2006-05-18 09:50:00 | AAPL | Stock | 2.3425 | 2.3464 | 2.3254 | 2.3304 | 20573672.0 |
| 2006-05-18 09:55:00 | AAPL | Stock | 2.3304 | 2.3361 | 2.3268 | 2.3314 | 9980600.0 |
| 2006-05-18 10:00:00 | AAPL | Stock | 2.3314 | 2.3361 | 2.3221 | 2.3246 | 12336520.0 |
| 2006-05-18 10:05:00 | AAPL | Stock | 2.325 | 2.3354 | 2.3221 | 2.3325 | 10990840.0 |
| 2006-05-18 10:10:00 | AAPL | Stock | 2.3329 | 2.3407 | 2.3239 | 2.3239 | 13147848.0 |
| 2006-05-18 10:15:00 | AAPL | Stock | 2.3243 | 2.3314 | 2.3189 | 2.3296 | 12879608.0 |
| 2006-05-18 10:20:00 | AAPL | Stock | 2.3293 | 2.3321 | 2.3229 | 2.3257 | 9519300.0 |
| 2006-05-18 10:25:00 | AAPL | Stock | 2.3257 | 2.3354 | 2.3254 | 2.3325 | 7838768.0 |
| 2006-05-18 10:30:00 | AAPL | Stock | 2.3325 | 2.3357 | 2.3293 | 2.33 | 7968632.0 |
| 2006-05-18 10:35:00 | AAPL | Stock | 2.3296 | 2.3436 | 2.325 | 2.3304 | 5611004.0 |
| 2006-05-18 10:40:00 | AAPL | Stock | 2.3304 | 2.3321 | 2.3214 | 2.325 | 7824320.0 |
| 2006-05-18 10:45:00 | AAPL | Stock | 2.3243 | 2.3286 | 2.3204 | 2.3257 | 7101276.0 |
| 2006-05-18 10:50:00 | AAPL | Stock | 2.3257 | 2.3311 | 2.3243 | 2.3261 | 7396088.0 |
| 2006-05-18 10:55:00 | AAPL | Stock | 2.3268 | 2.3307 | 2.325 | 2.3254 | 4510828.0 |
| 2006-05-18 11:00:00 | AAPL | Stock | 2.325 | 2.3261 | 2.3179 | 2.3182 | 8758596.0 |
| 2006-05-18 11:05:00 | AAPL | Stock | 2.3182 | 2.3229 | 2.3129 | 2.3182 | 11219180.0 |
| 2006-05-18 11:10:00 | AAPL | Stock | 2.3182 | 2.32 | 2.3114 | 2.3143 | 4439344.0 |
| 2006-05-18 11:15:00 | AAPL | Stock | 2.3143 | 2.3221 | 2.3125 | 2.3168 | 10534104.0 |
| 2006-05-18 11:20:00 | AAPL | Stock | 2.3164 | 2.3196 | 2.3146 | 2.3189 | 5818960.0 |
| 2006-05-18 11:25:00 | AAPL | Stock | 2.3186 | 2.325 | 2.3179 | 2.3246 | 8087044.0 |
| 2006-05-18 11:30:00 | AAPL | Stock | 2.3239 | 2.3261 | 2.3196 | 2.3236 | 6028540.0 |
| 2006-05-18 11:35:00 | AAPL | Stock | 2.3236 | 2.3268 | 2.3207 | 2.3261 | 4851336.0 |
| 2006-05-18 11:40:00 | AAPL | Stock | 2.3261 | 2.3264 | 2.3229 | 2.3254 | 3877440.0 |
| 2006-05-18 11:45:00 | AAPL | Stock | 2.3257 | 2.3268 | 2.3186 | 2.3196 | 4347560.0 |
| 2006-05-18 11:50:00 | AAPL | Stock | 2.3193 | 2.3196 | 2.3121 | 2.3143 | 14292796.0 |
| 2006-05-18 11:55:00 | AAPL | Stock | 2.3143 | 2.3193 | 2.3143 | 2.3186 | 3449852.0 |
> showing 50 of 225,135 rows — these rows as CSV