PREVIEW / stock_5min / 2007-07-02
file: by_date/stock_5min/2007/2007-07-02.parquet size: 4.0 MB rows: 298,061 symbols: 3,039
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 |
|---|---|---|---|---|---|---|---|
| 2007-07-02 09:30:00 | AAPL | Stock | 4.3232 | 4.3471 | 4.3036 | 4.3041 | 70302204.0 |
| 2007-07-02 09:35:00 | AAPL | Stock | 4.3036 | 4.3354 | 4.2607 | 4.2821 | 67212516.0 |
| 2007-07-02 09:40:00 | AAPL | Stock | 4.2821 | 4.3018 | 4.2811 | 4.2921 | 33735940.0 |
| 2007-07-02 09:45:00 | AAPL | Stock | 4.2918 | 4.3143 | 4.285 | 4.3143 | 30210964.0 |
| 2007-07-02 09:50:00 | AAPL | Stock | 4.3146 | 4.3536 | 4.3005 | 4.3146 | 32228756.0 |
| 2007-07-02 09:55:00 | AAPL | Stock | 4.3143 | 4.3604 | 4.3093 | 4.3464 | 39321996.0 |
| 2007-07-02 10:00:00 | AAPL | Stock | 4.3464 | 4.3571 | 4.3239 | 4.3282 | 32852120.0 |
| 2007-07-02 10:05:00 | AAPL | Stock | 4.3282 | 4.3482 | 4.3157 | 4.326 | 20537552.0 |
| 2007-07-02 10:10:00 | AAPL | Stock | 4.3261 | 4.3371 | 4.3132 | 4.3321 | 14596204.0 |
| 2007-07-02 10:15:00 | AAPL | Stock | 4.3321 | 4.3354 | 4.3036 | 4.3189 | 13207180.0 |
| 2007-07-02 10:20:00 | AAPL | Stock | 4.3193 | 4.3257 | 4.3114 | 4.3189 | 13639108.0 |
| 2007-07-02 10:25:00 | AAPL | Stock | 4.3189 | 4.33 | 4.3161 | 4.3186 | 11396336.0 |
| 2007-07-02 10:30:00 | AAPL | Stock | 4.3189 | 4.3282 | 4.3179 | 4.3261 | 10401804.0 |
| 2007-07-02 10:35:00 | AAPL | Stock | 4.3257 | 4.3293 | 4.3218 | 4.3239 | 6529572.0 |
| 2007-07-02 10:40:00 | AAPL | Stock | 4.3239 | 4.3279 | 4.3171 | 4.3175 | 12295612.0 |
| 2007-07-02 10:45:00 | AAPL | Stock | 4.3168 | 4.3225 | 4.315 | 4.3193 | 9344664.0 |
| 2007-07-02 10:50:00 | AAPL | Stock | 4.3193 | 4.32 | 4.3057 | 4.3143 | 14913836.0 |
| 2007-07-02 10:55:00 | AAPL | Stock | 4.3143 | 4.3268 | 4.3139 | 4.3264 | 8422680.0 |
| 2007-07-02 11:00:00 | AAPL | Stock | 4.3257 | 4.3275 | 4.3204 | 4.325 | 7405748.0 |
| 2007-07-02 11:05:00 | AAPL | Stock | 4.325 | 4.3393 | 4.3218 | 4.3361 | 12073096.0 |
| 2007-07-02 11:10:00 | AAPL | Stock | 4.3361 | 4.3536 | 4.3357 | 4.3407 | 21982576.0 |
| 2007-07-02 11:15:00 | AAPL | Stock | 4.3407 | 4.3457 | 4.3375 | 4.3404 | 7379232.0 |
| 2007-07-02 11:20:00 | AAPL | Stock | 4.3404 | 4.3407 | 4.3321 | 4.3359 | 9290344.0 |
| 2007-07-02 11:25:00 | AAPL | Stock | 4.3364 | 4.3421 | 4.3321 | 4.3368 | 9087008.0 |
| 2007-07-02 11:30:00 | AAPL | Stock | 4.3361 | 4.3432 | 4.3343 | 4.3364 | 4815720.0 |
| 2007-07-02 11:35:00 | AAPL | Stock | 4.3371 | 4.3389 | 4.3286 | 4.3357 | 5875240.0 |
| 2007-07-02 11:40:00 | AAPL | Stock | 4.335 | 4.3371 | 4.3304 | 4.3314 | 3998372.0 |
| 2007-07-02 11:45:00 | AAPL | Stock | 4.3314 | 4.3318 | 4.3179 | 4.3271 | 8156204.0 |
| 2007-07-02 11:50:00 | AAPL | Stock | 4.3266 | 4.3321 | 4.325 | 4.3311 | 4480168.0 |
| 2007-07-02 11:55:00 | AAPL | Stock | 4.3307 | 4.3318 | 4.3286 | 4.3293 | 3133312.0 |
| 2007-07-02 12:00:00 | AAPL | Stock | 4.3289 | 4.3471 | 4.3289 | 4.3439 | 12663504.0 |
| 2007-07-02 12:05:00 | AAPL | Stock | 4.3446 | 4.3496 | 4.3386 | 4.3496 | 9452744.0 |
| 2007-07-02 12:10:00 | AAPL | Stock | 4.3496 | 4.3571 | 4.3479 | 4.355 | 16024064.0 |
| 2007-07-02 12:15:00 | AAPL | Stock | 4.355 | 4.3557 | 4.3486 | 4.3511 | 6811812.0 |
| 2007-07-02 12:20:00 | AAPL | Stock | 4.3507 | 4.3536 | 4.3443 | 4.3457 | 6403544.0 |
| 2007-07-02 12:25:00 | AAPL | Stock | 4.3454 | 4.3455 | 4.3357 | 4.3393 | 11265800.0 |
| 2007-07-02 12:30:00 | AAPL | Stock | 4.3391 | 4.3411 | 4.3339 | 4.3343 | 5533724.0 |
| 2007-07-02 12:35:00 | AAPL | Stock | 4.3343 | 4.335 | 4.3282 | 4.3296 | 9390696.0 |
| 2007-07-02 12:40:00 | AAPL | Stock | 4.3293 | 4.3304 | 4.3236 | 4.3282 | 8781248.0 |
| 2007-07-02 12:45:00 | AAPL | Stock | 4.3282 | 4.3293 | 4.3186 | 4.3239 | 12366004.0 |
| 2007-07-02 12:50:00 | AAPL | Stock | 4.3239 | 4.3286 | 4.3236 | 4.3282 | 6466292.0 |
| 2007-07-02 12:55:00 | AAPL | Stock | 4.3286 | 4.3321 | 4.325 | 4.3321 | 5777940.0 |
| 2007-07-02 13:00:00 | AAPL | Stock | 4.3318 | 4.3354 | 4.3314 | 4.3354 | 5916848.0 |
| 2007-07-02 13:05:00 | AAPL | Stock | 4.3354 | 4.3375 | 4.3332 | 4.335 | 6249376.0 |
| 2007-07-02 13:10:00 | AAPL | Stock | 4.3343 | 4.3357 | 4.3314 | 4.3329 | 3132164.0 |
| 2007-07-02 13:15:00 | AAPL | Stock | 4.3329 | 4.3339 | 4.3289 | 4.3289 | 5274612.0 |
| 2007-07-02 13:20:00 | AAPL | Stock | 4.3289 | 4.3296 | 4.3268 | 4.3289 | 3645180.0 |
| 2007-07-02 13:25:00 | AAPL | Stock | 4.3289 | 4.3321 | 4.3282 | 4.3321 | 3454192.0 |
| 2007-07-02 13:30:00 | AAPL | Stock | 4.3314 | 4.3325 | 4.3304 | 4.3314 | 2898924.0 |
| 2007-07-02 13:35:00 | AAPL | Stock | 4.3319 | 4.3321 | 4.33 | 4.3304 | 1940876.0 |
> showing 50 of 298,061 rows — these rows as CSV