PREVIEW / stock_5min / 2009-03-12
file: by_date/stock_5min/2009/2009-03-12.parquet size: 4.5 MB rows: 312,354 symbols: 3,318
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 |
|---|---|---|---|---|---|---|---|
| 2009-03-12 04:15:00 | AAPL | Stock | 3.3186 | 3.3186 | 3.3186 | 3.3186 | 16800.0 |
| 2009-03-12 04:20:00 | AAPL | Stock | 3.3232 | 3.3236 | 3.3232 | 3.3236 | 5600.0 |
| 2009-03-12 04:45:00 | AAPL | Stock | 3.3036 | 3.3036 | 3.2946 | 3.2946 | 22400.0 |
| 2009-03-12 07:15:00 | AAPL | Stock | 3.2814 | 3.2814 | 3.2814 | 3.2814 | 15960.0 |
| 2009-03-12 07:20:00 | AAPL | Stock | 3.2839 | 3.2839 | 3.2839 | 3.2839 | 2800.0 |
| 2009-03-12 07:30:00 | AAPL | Stock | 3.2929 | 3.2943 | 3.2929 | 3.2943 | 5600.0 |
| 2009-03-12 07:35:00 | AAPL | Stock | 3.2893 | 3.2893 | 3.2886 | 3.2886 | 5600.0 |
| 2009-03-12 07:45:00 | AAPL | Stock | 3.2886 | 3.2893 | 3.2886 | 3.2893 | 21588.0 |
| 2009-03-12 08:00:00 | AAPL | Stock | 3.3068 | 3.3068 | 3.295 | 3.295 | 29876.0 |
| 2009-03-12 08:05:00 | AAPL | Stock | 3.3036 | 3.3036 | 3.3036 | 3.3036 | 8400.0 |
| 2009-03-12 08:10:00 | AAPL | Stock | 3.295 | 3.3071 | 3.2904 | 3.3071 | 107744.0 |
| 2009-03-12 08:15:00 | AAPL | Stock | 3.2964 | 3.2964 | 3.2964 | 3.2964 | 8400.0 |
| 2009-03-12 08:20:00 | AAPL | Stock | 3.2968 | 3.3057 | 3.2968 | 3.3 | 16492.0 |
| 2009-03-12 08:25:00 | AAPL | Stock | 3.3036 | 3.3107 | 3.3036 | 3.3107 | 82488.0 |
| 2009-03-12 08:30:00 | AAPL | Stock | 3.31 | 3.3146 | 3.3071 | 3.3143 | 56000.0 |
| 2009-03-12 08:35:00 | AAPL | Stock | 3.3189 | 3.3189 | 3.3161 | 3.3182 | 47600.0 |
| 2009-03-12 08:40:00 | AAPL | Stock | 3.3186 | 3.3321 | 3.3186 | 3.3321 | 93128.0 |
| 2009-03-12 08:45:00 | AAPL | Stock | 3.3321 | 3.3321 | 3.3286 | 3.3286 | 270200.0 |
| 2009-03-12 08:50:00 | AAPL | Stock | 3.3264 | 3.3286 | 3.3214 | 3.3214 | 274484.0 |
| 2009-03-12 08:55:00 | AAPL | Stock | 3.3204 | 3.3232 | 3.3139 | 3.3139 | 84140.0 |
| 2009-03-12 09:00:00 | AAPL | Stock | 3.3161 | 3.3161 | 3.3125 | 3.3132 | 62160.0 |
| 2009-03-12 09:05:00 | AAPL | Stock | 3.3132 | 3.3229 | 3.3129 | 3.3229 | 100800.0 |
| 2009-03-12 09:10:00 | AAPL | Stock | 3.3232 | 3.3257 | 3.3211 | 3.3257 | 205380.0 |
| 2009-03-12 09:15:00 | AAPL | Stock | 3.325 | 3.3268 | 3.3232 | 3.3268 | 156212.0 |
| 2009-03-12 09:20:00 | AAPL | Stock | 3.3286 | 3.3286 | 3.3282 | 3.3282 | 6972.0 |
| 2009-03-12 09:25:00 | AAPL | Stock | 3.3261 | 3.3286 | 3.3129 | 3.3182 | 255444.0 |
| 2009-03-12 09:30:00 | AAPL | Stock | 3.3179 | 3.3554 | 3.31 | 3.3543 | 15825684.0 |
| 2009-03-12 09:35:00 | AAPL | Stock | 3.3546 | 3.3568 | 3.3329 | 3.3521 | 17370248.0 |
| 2009-03-12 09:40:00 | AAPL | Stock | 3.3518 | 3.3661 | 3.3244 | 3.3268 | 21328916.0 |
| 2009-03-12 09:45:00 | AAPL | Stock | 3.3271 | 3.3304 | 3.3089 | 3.3282 | 15239504.0 |
| 2009-03-12 09:50:00 | AAPL | Stock | 3.3289 | 3.3304 | 3.2857 | 3.2911 | 19481392.0 |
| 2009-03-12 09:55:00 | AAPL | Stock | 3.2907 | 3.3118 | 3.2893 | 3.3107 | 12462408.0 |
| 2009-03-12 10:00:00 | AAPL | Stock | 3.3114 | 3.3207 | 3.2971 | 3.3161 | 14982996.0 |
| 2009-03-12 10:05:00 | AAPL | Stock | 3.3157 | 3.3357 | 3.3096 | 3.3318 | 13956432.0 |
| 2009-03-12 10:10:00 | AAPL | Stock | 3.3311 | 3.3318 | 3.3132 | 3.3214 | 10967768.0 |
| 2009-03-12 10:15:00 | AAPL | Stock | 3.3221 | 3.3489 | 3.3211 | 3.3329 | 14358316.0 |
| 2009-03-12 10:20:00 | AAPL | Stock | 3.3332 | 3.3518 | 3.3322 | 3.335 | 9487492.0 |
| 2009-03-12 10:25:00 | AAPL | Stock | 3.3354 | 3.3464 | 3.3289 | 3.3296 | 6896680.0 |
| 2009-03-12 10:30:00 | AAPL | Stock | 3.3296 | 3.3357 | 3.3214 | 3.3289 | 6434008.0 |
| 2009-03-12 10:35:00 | AAPL | Stock | 3.3293 | 3.3357 | 3.3201 | 3.3229 | 4821852.0 |
| 2009-03-12 10:40:00 | AAPL | Stock | 3.3229 | 3.3482 | 3.3204 | 3.3475 | 7280280.0 |
| 2009-03-12 10:45:00 | AAPL | Stock | 3.3482 | 3.3529 | 3.3411 | 3.3446 | 5623240.0 |
| 2009-03-12 10:50:00 | AAPL | Stock | 3.3443 | 3.3518 | 3.3382 | 3.345 | 6327272.0 |
| 2009-03-12 10:55:00 | AAPL | Stock | 3.3446 | 3.3536 | 3.3432 | 3.3496 | 5349400.0 |
| 2009-03-12 11:00:00 | AAPL | Stock | 3.35 | 3.3554 | 3.34 | 3.3429 | 6320720.0 |
| 2009-03-12 11:05:00 | AAPL | Stock | 3.3432 | 3.3489 | 3.3386 | 3.3486 | 5097568.0 |
| 2009-03-12 11:10:00 | AAPL | Stock | 3.3482 | 3.3554 | 3.3418 | 3.3543 | 4810148.0 |
| 2009-03-12 11:15:00 | AAPL | Stock | 3.3543 | 3.36 | 3.3525 | 3.3571 | 6582940.0 |
| 2009-03-12 11:20:00 | AAPL | Stock | 3.3571 | 3.3575 | 3.3361 | 3.3396 | 8178940.0 |
| 2009-03-12 11:25:00 | AAPL | Stock | 3.3396 | 3.348 | 3.3389 | 3.345 | 4510520.0 |
> showing 50 of 312,354 rows — these rows as CSV