PREVIEW / stock_5min / 2009-04-21
file: by_date/stock_5min/2009/2009-04-21.parquet size: 4.5 MB rows: 310,504 symbols: 3,307
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-04-21 07:55:00 | AAPL | Stock | 4.3036 | 4.3036 | 4.3036 | 4.3036 | 2800.0 |
| 2009-04-21 08:00:00 | AAPL | Stock | 4.3025 | 4.3061 | 4.2896 | 4.2918 | 37800.0 |
| 2009-04-21 08:05:00 | AAPL | Stock | 4.2943 | 4.3018 | 4.2875 | 4.2875 | 37800.0 |
| 2009-04-21 08:10:00 | AAPL | Stock | 4.2875 | 4.2886 | 4.2804 | 4.2804 | 65800.0 |
| 2009-04-21 08:15:00 | AAPL | Stock | 4.2804 | 4.2804 | 4.2804 | 4.2804 | 31696.0 |
| 2009-04-21 08:20:00 | AAPL | Stock | 4.2857 | 4.2857 | 4.2786 | 4.2786 | 34244.0 |
| 2009-04-21 08:30:00 | AAPL | Stock | 4.28 | 4.2821 | 4.2786 | 4.2821 | 16800.0 |
| 2009-04-21 08:35:00 | AAPL | Stock | 4.2807 | 4.2807 | 4.2679 | 4.2679 | 266924.0 |
| 2009-04-21 08:40:00 | AAPL | Stock | 4.2696 | 4.2725 | 4.2696 | 4.2696 | 98896.0 |
| 2009-04-21 08:45:00 | AAPL | Stock | 4.2686 | 4.2686 | 4.2675 | 4.2679 | 97496.0 |
| 2009-04-21 08:50:00 | AAPL | Stock | 4.2675 | 4.2675 | 4.2618 | 4.2618 | 70056.0 |
| 2009-04-21 08:55:00 | AAPL | Stock | 4.2614 | 4.2643 | 4.2589 | 4.2607 | 86800.0 |
| 2009-04-21 09:00:00 | AAPL | Stock | 4.2618 | 4.2629 | 4.2589 | 4.2589 | 131600.0 |
| 2009-04-21 09:05:00 | AAPL | Stock | 4.2579 | 4.2607 | 4.2539 | 4.2539 | 251608.0 |
| 2009-04-21 09:10:00 | AAPL | Stock | 4.2518 | 4.2539 | 4.2457 | 4.2496 | 201488.0 |
| 2009-04-21 09:15:00 | AAPL | Stock | 4.25 | 4.2579 | 4.2457 | 4.2543 | 238644.0 |
| 2009-04-21 09:20:00 | AAPL | Stock | 4.2543 | 4.2575 | 4.2496 | 4.2496 | 103516.0 |
| 2009-04-21 09:25:00 | AAPL | Stock | 4.25 | 4.2554 | 4.2489 | 4.2489 | 330456.0 |
| 2009-04-21 09:30:00 | AAPL | Stock | 4.2461 | 4.275 | 4.2357 | 4.268 | 18562292.0 |
| 2009-04-21 09:35:00 | AAPL | Stock | 4.2679 | 4.3179 | 4.2671 | 4.3111 | 13979532.0 |
| 2009-04-21 09:40:00 | AAPL | Stock | 4.3125 | 4.3286 | 4.3 | 4.3164 | 11956196.0 |
| 2009-04-21 09:45:00 | AAPL | Stock | 4.3175 | 4.3307 | 4.3036 | 4.3107 | 10332952.0 |
| 2009-04-21 09:50:00 | AAPL | Stock | 4.3107 | 4.3436 | 4.3107 | 4.3344 | 11447632.0 |
| 2009-04-21 09:55:00 | AAPL | Stock | 4.3346 | 4.3393 | 4.3257 | 4.335 | 6570900.0 |
| 2009-04-21 10:00:00 | AAPL | Stock | 4.335 | 4.3364 | 4.32 | 4.32 | 10337544.0 |
| 2009-04-21 10:05:00 | AAPL | Stock | 4.32 | 4.3304 | 4.3179 | 4.3257 | 6342532.0 |
| 2009-04-21 10:10:00 | AAPL | Stock | 4.3275 | 4.3296 | 4.3204 | 4.3214 | 3865092.0 |
| 2009-04-21 10:15:00 | AAPL | Stock | 4.3221 | 4.3221 | 4.3046 | 4.3054 | 5884844.0 |
| 2009-04-21 10:20:00 | AAPL | Stock | 4.3054 | 4.3068 | 4.2936 | 4.2989 | 5471144.0 |
| 2009-04-21 10:25:00 | AAPL | Stock | 4.2989 | 4.3 | 4.2929 | 4.2936 | 4471908.0 |
| 2009-04-21 10:30:00 | AAPL | Stock | 4.2934 | 4.2954 | 4.2832 | 4.2886 | 5916176.0 |
| 2009-04-21 10:35:00 | AAPL | Stock | 4.2889 | 4.3093 | 4.2882 | 4.3061 | 5181540.0 |
| 2009-04-21 10:40:00 | AAPL | Stock | 4.3057 | 4.3164 | 4.3029 | 4.3139 | 3986696.0 |
| 2009-04-21 10:45:00 | AAPL | Stock | 4.3139 | 4.3232 | 4.3125 | 4.3168 | 4618908.0 |
| 2009-04-21 10:50:00 | AAPL | Stock | 4.3171 | 4.3189 | 4.3086 | 4.3118 | 2778132.0 |
| 2009-04-21 10:55:00 | AAPL | Stock | 4.3107 | 4.3321 | 4.3104 | 4.3311 | 5153484.0 |
| 2009-04-21 11:00:00 | AAPL | Stock | 4.3311 | 4.3429 | 4.3214 | 4.3411 | 7308896.0 |
| 2009-04-21 11:05:00 | AAPL | Stock | 4.3404 | 4.3464 | 4.3368 | 4.3368 | 5154828.0 |
| 2009-04-21 11:10:00 | AAPL | Stock | 4.3364 | 4.3482 | 4.3346 | 4.3461 | 5110308.0 |
| 2009-04-21 11:15:00 | AAPL | Stock | 4.3461 | 4.3579 | 4.3457 | 4.3561 | 7533904.0 |
| 2009-04-21 11:20:00 | AAPL | Stock | 4.3561 | 4.3621 | 4.3464 | 4.3564 | 5527480.0 |
| 2009-04-21 11:25:00 | AAPL | Stock | 4.3564 | 4.3571 | 4.3486 | 4.35 | 3819256.0 |
| 2009-04-21 11:30:00 | AAPL | Stock | 4.3496 | 4.3504 | 4.3371 | 4.3411 | 5772284.0 |
| 2009-04-21 11:35:00 | AAPL | Stock | 4.3416 | 4.3421 | 4.3282 | 4.3296 | 5017432.0 |
| 2009-04-21 11:40:00 | AAPL | Stock | 4.3304 | 4.3421 | 4.3289 | 4.3379 | 4184880.0 |
| 2009-04-21 11:45:00 | AAPL | Stock | 4.3382 | 4.3546 | 4.3379 | 4.3511 | 5155780.0 |
| 2009-04-21 11:50:00 | AAPL | Stock | 4.3514 | 4.3514 | 4.3357 | 4.3407 | 4825464.0 |
| 2009-04-21 11:55:00 | AAPL | Stock | 4.3404 | 4.3536 | 4.3375 | 4.347 | 3763340.0 |
| 2009-04-21 12:00:00 | AAPL | Stock | 4.3471 | 4.3518 | 4.3396 | 4.3454 | 3498320.0 |
| 2009-04-21 12:05:00 | AAPL | Stock | 4.3457 | 4.3507 | 4.345 | 4.3489 | 3553200.0 |
> showing 50 of 310,504 rows — these rows as CSV