PREVIEW / stock_5min / 2006-03-13
file: by_date/stock_5min/2006/2006-03-13.parquet size: 3.0 MB rows: 217,789 symbols: 2,196
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-03-13 07:15:00 | AAPL | Stock | 2.2689 | 2.2743 | 2.2689 | 2.2743 | 134400.0 |
| 2006-03-13 07:20:00 | AAPL | Stock | 2.2743 | 2.2743 | 2.2743 | 2.2743 | 14000.0 |
| 2006-03-13 07:25:00 | AAPL | Stock | 2.2793 | 2.2793 | 2.2793 | 2.2793 | 34300.0 |
| 2006-03-13 07:30:00 | AAPL | Stock | 2.2793 | 2.325 | 2.2793 | 2.3214 | 478296.0 |
| 2006-03-13 07:35:00 | AAPL | Stock | 2.3196 | 2.3354 | 2.3157 | 2.3304 | 255360.0 |
| 2006-03-13 07:40:00 | AAPL | Stock | 2.3246 | 2.3246 | 2.3207 | 2.3207 | 44800.0 |
| 2006-03-13 07:45:00 | AAPL | Stock | 2.3196 | 2.3214 | 2.3161 | 2.3214 | 73920.0 |
| 2006-03-13 07:50:00 | AAPL | Stock | 2.3182 | 2.3182 | 2.3168 | 2.3168 | 33320.0 |
| 2006-03-13 07:55:00 | AAPL | Stock | 2.3214 | 2.325 | 2.3179 | 2.3214 | 131600.0 |
| 2006-03-13 08:00:00 | AAPL | Stock | 2.3214 | 2.325 | 2.3121 | 2.3146 | 3973676.0 |
| 2006-03-13 08:05:00 | AAPL | Stock | 2.315 | 2.3196 | 2.3107 | 2.3196 | 911960.0 |
| 2006-03-13 08:10:00 | AAPL | Stock | 2.3196 | 2.325 | 2.3179 | 2.3239 | 1543444.0 |
| 2006-03-13 08:15:00 | AAPL | Stock | 2.3221 | 2.3232 | 2.3182 | 2.3225 | 1189160.0 |
| 2006-03-13 08:20:00 | AAPL | Stock | 2.3225 | 2.3243 | 2.3196 | 2.3221 | 2773540.0 |
| 2006-03-13 08:25:00 | AAPL | Stock | 2.3221 | 2.3225 | 2.3168 | 2.3179 | 405272.0 |
| 2006-03-13 08:30:00 | AAPL | Stock | 2.3168 | 2.3225 | 2.3168 | 2.3218 | 480312.0 |
| 2006-03-13 08:35:00 | AAPL | Stock | 2.3218 | 2.3225 | 2.3193 | 2.3214 | 818748.0 |
| 2006-03-13 08:40:00 | AAPL | Stock | 2.3214 | 2.3225 | 2.3204 | 2.3207 | 875056.0 |
| 2006-03-13 08:45:00 | AAPL | Stock | 2.3207 | 2.3279 | 2.3207 | 2.3268 | 1112384.0 |
| 2006-03-13 08:50:00 | AAPL | Stock | 2.3264 | 2.3268 | 2.3243 | 2.325 | 659540.0 |
| 2006-03-13 08:55:00 | AAPL | Stock | 2.3261 | 2.3261 | 2.3221 | 2.3243 | 1132656.0 |
| 2006-03-13 09:00:00 | AAPL | Stock | 2.3236 | 2.3246 | 2.3214 | 2.3246 | 450240.0 |
| 2006-03-13 09:05:00 | AAPL | Stock | 2.3246 | 2.3246 | 2.3211 | 2.3211 | 3352552.0 |
| 2006-03-13 09:10:00 | AAPL | Stock | 2.3207 | 2.3214 | 2.3196 | 2.3211 | 497700.0 |
| 2006-03-13 09:15:00 | AAPL | Stock | 2.3214 | 2.3214 | 2.3204 | 2.3214 | 598360.0 |
| 2006-03-13 09:20:00 | AAPL | Stock | 2.3204 | 2.3214 | 2.315 | 2.3207 | 888104.0 |
| 2006-03-13 09:25:00 | AAPL | Stock | 2.3207 | 2.3268 | 2.3168 | 2.3232 | 3131436.0 |
| 2006-03-13 09:30:00 | AAPL | Stock | 2.3232 | 2.3354 | 2.3139 | 2.3339 | 57993488.0 |
| 2006-03-13 09:35:00 | AAPL | Stock | 2.3339 | 2.3532 | 2.3336 | 2.3442 | 54466860.0 |
| 2006-03-13 09:40:00 | AAPL | Stock | 2.3436 | 2.3561 | 2.3414 | 2.3536 | 36069488.0 |
| 2006-03-13 09:45:00 | AAPL | Stock | 2.3539 | 2.3607 | 2.3507 | 2.3518 | 42740432.0 |
| 2006-03-13 09:50:00 | AAPL | Stock | 2.3525 | 2.3571 | 2.3482 | 2.3521 | 21316708.0 |
| 2006-03-13 09:55:00 | AAPL | Stock | 2.3525 | 2.3568 | 2.35 | 2.3568 | 19540332.0 |
| 2006-03-13 10:00:00 | AAPL | Stock | 2.3568 | 2.3657 | 2.3525 | 2.3557 | 34256992.0 |
| 2006-03-13 10:05:00 | AAPL | Stock | 2.3557 | 2.3607 | 2.35 | 2.3521 | 15870512.0 |
| 2006-03-13 10:10:00 | AAPL | Stock | 2.3518 | 2.36 | 2.3518 | 2.3568 | 13314084.0 |
| 2006-03-13 10:15:00 | AAPL | Stock | 2.3571 | 2.3604 | 2.3518 | 2.3539 | 10318700.0 |
| 2006-03-13 10:20:00 | AAPL | Stock | 2.3539 | 2.3607 | 2.3525 | 2.3546 | 10861844.0 |
| 2006-03-13 10:25:00 | AAPL | Stock | 2.3554 | 2.3625 | 2.3518 | 2.3518 | 17026492.0 |
| 2006-03-13 10:30:00 | AAPL | Stock | 2.3514 | 2.3568 | 2.3479 | 2.3529 | 14725760.0 |
| 2006-03-13 10:35:00 | AAPL | Stock | 2.3529 | 2.3536 | 2.3443 | 2.3464 | 13383552.0 |
| 2006-03-13 10:40:00 | AAPL | Stock | 2.3464 | 2.3532 | 2.3439 | 2.35 | 14961212.0 |
| 2006-03-13 10:45:00 | AAPL | Stock | 2.35 | 2.3571 | 2.3496 | 2.3571 | 9783480.0 |
| 2006-03-13 10:50:00 | AAPL | Stock | 2.3571 | 2.3589 | 2.3511 | 2.3536 | 9326156.0 |
| 2006-03-13 10:55:00 | AAPL | Stock | 2.3539 | 2.3614 | 2.3536 | 2.3604 | 12428556.0 |
| 2006-03-13 11:00:00 | AAPL | Stock | 2.3604 | 2.3671 | 2.3571 | 2.3571 | 17822028.0 |
| 2006-03-13 11:05:00 | AAPL | Stock | 2.3571 | 2.3596 | 2.3464 | 2.3532 | 16430932.0 |
| 2006-03-13 11:10:00 | AAPL | Stock | 2.3532 | 2.3554 | 2.3479 | 2.3507 | 8052100.0 |
| 2006-03-13 11:15:00 | AAPL | Stock | 2.3507 | 2.3561 | 2.3486 | 2.3536 | 6333516.0 |
| 2006-03-13 11:20:00 | AAPL | Stock | 2.3536 | 2.3579 | 2.35 | 2.3521 | 5115320.0 |
> showing 50 of 217,789 rows — these rows as CSV