PREVIEW / stock_1min / 2007-06-12
file: by_date/stock_1min/2007/2007-06-12.parquet size: 11.2 MB rows: 923,832 symbols: 2,479
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-06-12 09:30:00 | AAPL | Stock | 4.2625 | 4.2768 | 4.2589 | 4.2589 | 14204792.0 |
| 2007-06-12 09:31:00 | AAPL | Stock | 4.2586 | 4.2704 | 4.2389 | 4.2457 | 19934264.0 |
| 2007-06-12 09:32:00 | AAPL | Stock | 4.2536 | 4.2579 | 4.2293 | 4.2332 | 12407360.0 |
| 2007-06-12 09:33:00 | AAPL | Stock | 4.2329 | 4.2532 | 4.2254 | 4.2464 | 12181428.0 |
| 2007-06-12 09:34:00 | AAPL | Stock | 4.2464 | 4.2518 | 4.2261 | 4.2496 | 11289936.0 |
| 2007-06-12 09:35:00 | AAPL | Stock | 4.2489 | 4.2639 | 4.2479 | 4.2543 | 8054676.0 |
| 2007-06-12 09:36:00 | AAPL | Stock | 4.2546 | 4.2657 | 4.2429 | 4.2589 | 10090836.0 |
| 2007-06-12 09:37:00 | AAPL | Stock | 4.2589 | 4.2696 | 4.2539 | 4.2689 | 8287244.0 |
| 2007-06-12 09:38:00 | AAPL | Stock | 4.2689 | 4.29 | 4.2557 | 4.2832 | 12327056.0 |
| 2007-06-12 09:39:00 | AAPL | Stock | 4.2832 | 4.2836 | 4.2679 | 4.2693 | 9590392.0 |
| 2007-06-12 09:40:00 | AAPL | Stock | 4.2693 | 4.2782 | 4.2664 | 4.2711 | 4963140.0 |
| 2007-06-12 09:41:00 | AAPL | Stock | 4.2711 | 4.2786 | 4.2702 | 4.2775 | 6160840.0 |
| 2007-06-12 09:42:00 | AAPL | Stock | 4.2775 | 4.2779 | 4.2668 | 4.2718 | 7047572.0 |
| 2007-06-12 09:43:00 | AAPL | Stock | 4.2729 | 4.275 | 4.2607 | 4.2624 | 7135716.0 |
| 2007-06-12 09:44:00 | AAPL | Stock | 4.2643 | 4.2871 | 4.2618 | 4.2861 | 9201304.0 |
| 2007-06-12 09:45:00 | AAPL | Stock | 4.2862 | 4.2996 | 4.2821 | 4.2971 | 11759636.0 |
| 2007-06-12 09:46:00 | AAPL | Stock | 4.2975 | 4.31 | 4.2914 | 4.3011 | 13577592.0 |
| 2007-06-12 09:47:00 | AAPL | Stock | 4.3025 | 4.3121 | 4.2968 | 4.3104 | 8396500.0 |
| 2007-06-12 09:48:00 | AAPL | Stock | 4.3104 | 4.3111 | 4.3018 | 4.3029 | 8363656.0 |
| 2007-06-12 09:49:00 | AAPL | Stock | 4.3032 | 4.3093 | 4.3021 | 4.3054 | 5001640.0 |
| 2007-06-12 09:50:00 | AAPL | Stock | 4.305 | 4.3054 | 4.2964 | 4.2979 | 9017372.0 |
| 2007-06-12 09:51:00 | AAPL | Stock | 4.2982 | 4.3036 | 4.2964 | 4.3007 | 7928956.0 |
| 2007-06-12 09:52:00 | AAPL | Stock | 4.3018 | 4.3032 | 4.2982 | 4.2993 | 5161660.0 |
| 2007-06-12 09:53:00 | AAPL | Stock | 4.2993 | 4.3025 | 4.2964 | 4.3004 | 7034356.0 |
| 2007-06-12 09:54:00 | AAPL | Stock | 4.3011 | 4.3018 | 4.2964 | 4.2982 | 5716508.0 |
| 2007-06-12 09:55:00 | AAPL | Stock | 4.2982 | 4.3007 | 4.2893 | 4.2964 | 10014060.0 |
| 2007-06-12 09:56:00 | AAPL | Stock | 4.2975 | 4.3018 | 4.2957 | 4.2989 | 4878552.0 |
| 2007-06-12 09:57:00 | AAPL | Stock | 4.3 | 4.3 | 4.2825 | 4.2829 | 9756012.0 |
| 2007-06-12 09:58:00 | AAPL | Stock | 4.2825 | 4.2857 | 4.2779 | 4.2811 | 8202684.0 |
| 2007-06-12 09:59:00 | AAPL | Stock | 4.2811 | 4.2868 | 4.2793 | 4.2829 | 4551484.0 |
| 2007-06-12 10:00:00 | AAPL | Stock | 4.2832 | 4.2857 | 4.2796 | 4.2854 | 4766664.0 |
| 2007-06-12 10:01:00 | AAPL | Stock | 4.2854 | 4.2875 | 4.2821 | 4.2832 | 4394404.0 |
| 2007-06-12 10:02:00 | AAPL | Stock | 4.2832 | 4.2946 | 4.2811 | 4.29 | 6329148.0 |
| 2007-06-12 10:03:00 | AAPL | Stock | 4.2896 | 4.2954 | 4.2861 | 4.2914 | 4301836.0 |
| 2007-06-12 10:04:00 | AAPL | Stock | 4.2914 | 4.2982 | 4.2825 | 4.2968 | 6726412.0 |
| 2007-06-12 10:05:00 | AAPL | Stock | 4.2968 | 4.3096 | 4.2957 | 4.3089 | 9323356.0 |
| 2007-06-12 10:06:00 | AAPL | Stock | 4.3086 | 4.3171 | 4.3043 | 4.31 | 10407292.0 |
| 2007-06-12 10:07:00 | AAPL | Stock | 4.3104 | 4.3211 | 4.3096 | 4.3154 | 8625456.0 |
| 2007-06-12 10:08:00 | AAPL | Stock | 4.3157 | 4.3204 | 4.3132 | 4.3171 | 6743772.0 |
| 2007-06-12 10:09:00 | AAPL | Stock | 4.3168 | 4.3243 | 4.3157 | 4.3218 | 7204232.0 |
| 2007-06-12 10:10:00 | AAPL | Stock | 4.3218 | 4.3314 | 4.3196 | 4.3275 | 8138368.0 |
| 2007-06-12 10:11:00 | AAPL | Stock | 4.3279 | 4.3289 | 4.3232 | 4.3254 | 4632880.0 |
| 2007-06-12 10:12:00 | AAPL | Stock | 4.325 | 4.3254 | 4.3157 | 4.3164 | 7060312.0 |
| 2007-06-12 10:13:00 | AAPL | Stock | 4.3161 | 4.3179 | 4.3089 | 4.3096 | 6240780.0 |
| 2007-06-12 10:14:00 | AAPL | Stock | 4.3096 | 4.315 | 4.3071 | 4.3136 | 4311272.0 |
| 2007-06-12 10:15:00 | AAPL | Stock | 4.3136 | 4.3168 | 4.3125 | 4.3136 | 2898588.0 |
| 2007-06-12 10:16:00 | AAPL | Stock | 4.3139 | 4.3179 | 4.3132 | 4.3136 | 4720128.0 |
| 2007-06-12 10:17:00 | AAPL | Stock | 4.3132 | 4.3168 | 4.31 | 4.31 | 4248776.0 |
| 2007-06-12 10:18:00 | AAPL | Stock | 4.3104 | 4.3104 | 4.3018 | 4.3018 | 6677076.0 |
| 2007-06-12 10:19:00 | AAPL | Stock | 4.3018 | 4.3064 | 4.2996 | 4.3043 | 7341460.0 |
> showing 50 of 923,832 rows — these rows as CSV