PREVIEW / stock_5min / 2007-04-11
file: by_date/stock_5min/2007/2007-04-11.parquet size: 3.6 MB rows: 257,915 symbols: 2,574
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-04-11 08:00:00 | AAPL | Stock | 3.3711 | 3.3711 | 3.3571 | 3.3571 | 227500.0 |
| 2007-04-11 08:05:00 | AAPL | Stock | 3.3571 | 3.3636 | 3.3571 | 3.3571 | 53200.0 |
| 2007-04-11 08:15:00 | AAPL | Stock | 3.3575 | 3.3575 | 3.3575 | 3.3575 | 2800.0 |
| 2007-04-11 08:25:00 | AAPL | Stock | 3.3575 | 3.3575 | 3.3575 | 3.3575 | 5628.0 |
| 2007-04-11 08:30:00 | AAPL | Stock | 3.3575 | 3.3575 | 3.3561 | 3.3571 | 95228.0 |
| 2007-04-11 08:35:00 | AAPL | Stock | 3.3571 | 3.3571 | 3.3529 | 3.3529 | 307300.0 |
| 2007-04-11 08:40:00 | AAPL | Stock | 3.3529 | 3.3571 | 3.3514 | 3.3571 | 127540.0 |
| 2007-04-11 08:45:00 | AAPL | Stock | 3.3554 | 3.3564 | 3.3536 | 3.3564 | 103376.0 |
| 2007-04-11 08:55:00 | AAPL | Stock | 3.3536 | 3.3536 | 3.3536 | 3.3536 | 19600.0 |
| 2007-04-11 09:00:00 | AAPL | Stock | 3.3543 | 3.3571 | 3.3536 | 3.3536 | 539980.0 |
| 2007-04-11 09:05:00 | AAPL | Stock | 3.3536 | 3.3539 | 3.3532 | 3.3536 | 113064.0 |
| 2007-04-11 09:10:00 | AAPL | Stock | 3.3539 | 3.3593 | 3.3539 | 3.3593 | 18200.0 |
| 2007-04-11 09:15:00 | AAPL | Stock | 3.3546 | 3.3582 | 3.3546 | 3.3582 | 81200.0 |
| 2007-04-11 09:20:00 | AAPL | Stock | 3.3571 | 3.3579 | 3.3554 | 3.3571 | 525000.0 |
| 2007-04-11 09:25:00 | AAPL | Stock | 3.3571 | 3.3571 | 3.3482 | 3.3546 | 5574800.0 |
| 2007-04-11 09:30:00 | AAPL | Stock | 3.3536 | 3.3554 | 3.3421 | 3.3471 | 10829308.0 |
| 2007-04-11 09:35:00 | AAPL | Stock | 3.3468 | 3.3468 | 3.3393 | 3.3432 | 12613664.0 |
| 2007-04-11 09:40:00 | AAPL | Stock | 3.3434 | 3.3457 | 3.3411 | 3.3429 | 9101148.0 |
| 2007-04-11 09:45:00 | AAPL | Stock | 3.3429 | 3.3536 | 3.3411 | 3.3428 | 7935424.0 |
| 2007-04-11 09:50:00 | AAPL | Stock | 3.3425 | 3.3425 | 3.3321 | 3.3404 | 14728028.0 |
| 2007-04-11 09:55:00 | AAPL | Stock | 3.3404 | 3.3404 | 3.3339 | 3.3364 | 7236628.0 |
| 2007-04-11 10:00:00 | AAPL | Stock | 3.3364 | 3.3414 | 3.3364 | 3.3379 | 6881504.0 |
| 2007-04-11 10:05:00 | AAPL | Stock | 3.3382 | 3.3418 | 3.3346 | 3.3411 | 5901644.0 |
| 2007-04-11 10:10:00 | AAPL | Stock | 3.3407 | 3.3436 | 3.3379 | 3.3434 | 4993128.0 |
| 2007-04-11 10:15:00 | AAPL | Stock | 3.3436 | 3.3439 | 3.3282 | 3.3286 | 13860280.0 |
| 2007-04-11 10:20:00 | AAPL | Stock | 3.3286 | 3.3318 | 3.3225 | 3.3251 | 17764572.0 |
| 2007-04-11 10:25:00 | AAPL | Stock | 3.3254 | 3.3325 | 3.3239 | 3.3317 | 8019732.0 |
| 2007-04-11 10:30:00 | AAPL | Stock | 3.3314 | 3.3339 | 3.3271 | 3.3286 | 6634880.0 |
| 2007-04-11 10:35:00 | AAPL | Stock | 3.3286 | 3.3311 | 3.3232 | 3.3239 | 7202944.0 |
| 2007-04-11 10:40:00 | AAPL | Stock | 3.3236 | 3.3257 | 3.3182 | 3.3211 | 17328612.0 |
| 2007-04-11 10:45:00 | AAPL | Stock | 3.3207 | 3.3243 | 3.315 | 3.3236 | 11628456.0 |
| 2007-04-11 10:50:00 | AAPL | Stock | 3.3239 | 3.3243 | 3.3107 | 3.3111 | 16322460.0 |
| 2007-04-11 10:55:00 | AAPL | Stock | 3.3111 | 3.3129 | 3.305 | 3.3106 | 17839528.0 |
| 2007-04-11 11:00:00 | AAPL | Stock | 3.3104 | 3.3132 | 3.3082 | 3.3104 | 10942400.0 |
| 2007-04-11 11:05:00 | AAPL | Stock | 3.31 | 3.3146 | 3.3096 | 3.3114 | 9672712.0 |
| 2007-04-11 11:10:00 | AAPL | Stock | 3.3118 | 3.3125 | 3.3089 | 3.3125 | 6567820.0 |
| 2007-04-11 11:15:00 | AAPL | Stock | 3.3125 | 3.3179 | 3.3111 | 3.3146 | 18231920.0 |
| 2007-04-11 11:20:00 | AAPL | Stock | 3.3146 | 3.3157 | 3.3121 | 3.314 | 5434660.0 |
| 2007-04-11 11:25:00 | AAPL | Stock | 3.3143 | 3.3157 | 3.3121 | 3.3143 | 4537008.0 |
| 2007-04-11 11:30:00 | AAPL | Stock | 3.3139 | 3.3169 | 3.3136 | 3.3168 | 4101328.0 |
| 2007-04-11 11:35:00 | AAPL | Stock | 3.3164 | 3.3179 | 3.3125 | 3.3164 | 4618376.0 |
| 2007-04-11 11:40:00 | AAPL | Stock | 3.3164 | 3.3175 | 3.3143 | 3.3164 | 3139696.0 |
| 2007-04-11 11:45:00 | AAPL | Stock | 3.3164 | 3.32 | 3.3164 | 3.3193 | 6005356.0 |
| 2007-04-11 11:50:00 | AAPL | Stock | 3.3193 | 3.32 | 3.3182 | 3.3182 | 2623460.0 |
| 2007-04-11 11:55:00 | AAPL | Stock | 3.3182 | 3.3193 | 3.3164 | 3.3193 | 2819628.0 |
| 2007-04-11 12:00:00 | AAPL | Stock | 3.3193 | 3.3304 | 3.3179 | 3.3257 | 15039500.0 |
| 2007-04-11 12:05:00 | AAPL | Stock | 3.3257 | 3.3264 | 3.3221 | 3.3236 | 8285060.0 |
| 2007-04-11 12:10:00 | AAPL | Stock | 3.3236 | 3.3246 | 3.3196 | 3.3221 | 3148516.0 |
| 2007-04-11 12:15:00 | AAPL | Stock | 3.3218 | 3.3225 | 3.3207 | 3.3225 | 2599380.0 |
| 2007-04-11 12:20:00 | AAPL | Stock | 3.3229 | 3.3236 | 3.3214 | 3.3236 | 3516380.0 |
> showing 50 of 257,915 rows — these rows as CSV