PREVIEW / stock_5min / 2009-11-23
file: by_date/stock_5min/2009/2009-11-23.parquet size: 4.7 MB rows: 321,613 symbols: 3,416
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-11-23 04:15:00 | AAPL | Stock | 7.1732 | 7.1732 | 7.1732 | 7.1732 | 5600.0 |
| 2009-11-23 07:00:00 | AAPL | Stock | 7.2071 | 7.2071 | 7.2071 | 7.2071 | 5600.0 |
| 2009-11-23 07:10:00 | AAPL | Stock | 7.2082 | 7.2082 | 7.2082 | 7.2082 | 8400.0 |
| 2009-11-23 07:15:00 | AAPL | Stock | 7.215 | 7.2321 | 7.2146 | 7.22 | 44800.0 |
| 2009-11-23 07:20:00 | AAPL | Stock | 7.2143 | 7.2204 | 7.2143 | 7.2196 | 43400.0 |
| 2009-11-23 07:30:00 | AAPL | Stock | 7.215 | 7.2311 | 7.215 | 7.2311 | 16800.0 |
| 2009-11-23 07:35:00 | AAPL | Stock | 7.2182 | 7.2182 | 7.2079 | 7.2079 | 8708.0 |
| 2009-11-23 07:45:00 | AAPL | Stock | 7.2143 | 7.2143 | 7.2143 | 7.2143 | 14000.0 |
| 2009-11-23 07:50:00 | AAPL | Stock | 7.2143 | 7.2189 | 7.2143 | 7.2189 | 55440.0 |
| 2009-11-23 07:55:00 | AAPL | Stock | 7.2143 | 7.2271 | 7.2143 | 7.2271 | 42336.0 |
| 2009-11-23 08:00:00 | AAPL | Stock | 7.2146 | 7.2375 | 7.14 | 7.2325 | 634536.0 |
| 2009-11-23 08:05:00 | AAPL | Stock | 7.2325 | 7.2429 | 7.2325 | 7.2421 | 257964.0 |
| 2009-11-23 08:10:00 | AAPL | Stock | 7.2412 | 7.2439 | 7.2361 | 7.2393 | 173768.0 |
| 2009-11-23 08:15:00 | AAPL | Stock | 7.2411 | 7.2421 | 7.2321 | 7.2339 | 113960.0 |
| 2009-11-23 08:20:00 | AAPL | Stock | 7.235 | 7.2357 | 7.2271 | 7.2286 | 106988.0 |
| 2009-11-23 08:25:00 | AAPL | Stock | 7.2271 | 7.2304 | 7.2271 | 7.23 | 66080.0 |
| 2009-11-23 08:30:00 | AAPL | Stock | 7.2318 | 7.2321 | 7.2271 | 7.2321 | 155400.0 |
| 2009-11-23 08:35:00 | AAPL | Stock | 7.2332 | 7.2336 | 7.2268 | 7.2268 | 57960.0 |
| 2009-11-23 08:40:00 | AAPL | Stock | 7.2286 | 7.2321 | 7.2279 | 7.2289 | 106960.0 |
| 2009-11-23 08:45:00 | AAPL | Stock | 7.2286 | 7.23 | 7.2275 | 7.2286 | 33600.0 |
| 2009-11-23 08:50:00 | AAPL | Stock | 7.2286 | 7.2318 | 7.2286 | 7.2318 | 114100.0 |
| 2009-11-23 08:55:00 | AAPL | Stock | 7.2314 | 7.2321 | 7.2286 | 7.23 | 97720.0 |
| 2009-11-23 09:00:00 | AAPL | Stock | 7.2286 | 7.2368 | 7.2286 | 7.2361 | 394212.0 |
| 2009-11-23 09:05:00 | AAPL | Stock | 7.2368 | 7.2393 | 7.2357 | 7.2368 | 578452.0 |
| 2009-11-23 09:10:00 | AAPL | Stock | 7.2364 | 7.2454 | 7.2361 | 7.2421 | 752976.0 |
| 2009-11-23 09:15:00 | AAPL | Stock | 7.2429 | 7.2496 | 7.2418 | 7.2461 | 414680.0 |
| 2009-11-23 09:20:00 | AAPL | Stock | 7.2446 | 7.2475 | 7.2411 | 7.2446 | 331940.0 |
| 2009-11-23 09:25:00 | AAPL | Stock | 7.2443 | 7.25 | 7.2432 | 7.2486 | 478800.0 |
| 2009-11-23 09:30:00 | AAPL | Stock | 7.2482 | 7.2754 | 7.2482 | 7.2565 | 19234852.0 |
| 2009-11-23 09:35:00 | AAPL | Stock | 7.2571 | 7.2768 | 7.2482 | 7.2711 | 11783772.0 |
| 2009-11-23 09:40:00 | AAPL | Stock | 7.2711 | 7.2882 | 7.2679 | 7.2846 | 13789076.0 |
| 2009-11-23 09:45:00 | AAPL | Stock | 7.2846 | 7.3 | 7.2789 | 7.2939 | 11796876.0 |
| 2009-11-23 09:50:00 | AAPL | Stock | 7.2943 | 7.3118 | 7.2936 | 7.3021 | 11661664.0 |
| 2009-11-23 09:55:00 | AAPL | Stock | 7.3032 | 7.3214 | 7.2989 | 7.3157 | 8645644.0 |
| 2009-11-23 10:00:00 | AAPL | Stock | 7.3179 | 7.3257 | 7.3064 | 7.3189 | 16471896.0 |
| 2009-11-23 10:05:00 | AAPL | Stock | 7.3182 | 7.3207 | 7.3054 | 7.3054 | 10052980.0 |
| 2009-11-23 10:10:00 | AAPL | Stock | 7.3054 | 7.32 | 7.3046 | 7.3179 | 7500220.0 |
| 2009-11-23 10:15:00 | AAPL | Stock | 7.3179 | 7.3289 | 7.3179 | 7.3268 | 8376452.0 |
| 2009-11-23 10:20:00 | AAPL | Stock | 7.3264 | 7.3271 | 7.3107 | 7.3132 | 11163852.0 |
| 2009-11-23 10:25:00 | AAPL | Stock | 7.3134 | 7.3214 | 7.3111 | 7.3198 | 4724496.0 |
| 2009-11-23 10:30:00 | AAPL | Stock | 7.3197 | 7.3257 | 7.3171 | 7.3211 | 4794944.0 |
| 2009-11-23 10:35:00 | AAPL | Stock | 7.321 | 7.3318 | 7.3204 | 7.3286 | 6166216.0 |
| 2009-11-23 10:40:00 | AAPL | Stock | 7.3285 | 7.3371 | 7.3275 | 7.3339 | 5734568.0 |
| 2009-11-23 10:45:00 | AAPL | Stock | 7.3332 | 7.3346 | 7.3182 | 7.3246 | 7467852.0 |
| 2009-11-23 10:50:00 | AAPL | Stock | 7.3246 | 7.3279 | 7.3168 | 7.3207 | 5652500.0 |
| 2009-11-23 10:55:00 | AAPL | Stock | 7.3207 | 7.3214 | 7.3046 | 7.3079 | 9304092.0 |
| 2009-11-23 11:00:00 | AAPL | Stock | 7.3076 | 7.3161 | 7.3075 | 7.3154 | 2853480.0 |
| 2009-11-23 11:05:00 | AAPL | Stock | 7.3147 | 7.3189 | 7.3118 | 7.3136 | 2927456.0 |
| 2009-11-23 11:10:00 | AAPL | Stock | 7.3143 | 7.3186 | 7.3104 | 7.3111 | 2191812.0 |
| 2009-11-23 11:15:00 | AAPL | Stock | 7.3118 | 7.3131 | 7.3075 | 7.3127 | 2467276.0 |
> showing 50 of 321,613 rows — these rows as CSV