PREVIEW / stock_5min / 2008-11-12
file: by_date/stock_5min/2008/2008-11-12.parquet size: 4.4 MB rows: 312,874 symbols: 3,303
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 |
|---|---|---|---|---|---|---|---|
| 2008-11-12 07:45:00 | AAPL | Stock | 3.3821 | 3.3821 | 3.3821 | 3.3821 | 2800.0 |
| 2008-11-12 08:00:00 | AAPL | Stock | 3.3825 | 3.3918 | 3.3464 | 3.3464 | 373380.0 |
| 2008-11-12 08:05:00 | AAPL | Stock | 3.3464 | 3.3504 | 3.3125 | 3.3214 | 539000.0 |
| 2008-11-12 08:10:00 | AAPL | Stock | 3.325 | 3.3311 | 3.3143 | 3.325 | 434280.0 |
| 2008-11-12 08:15:00 | AAPL | Stock | 3.3286 | 3.3286 | 3.3143 | 3.3157 | 256536.0 |
| 2008-11-12 08:20:00 | AAPL | Stock | 3.3143 | 3.3254 | 3.3125 | 3.3211 | 147112.0 |
| 2008-11-12 08:25:00 | AAPL | Stock | 3.3214 | 3.3239 | 3.3157 | 3.3214 | 251552.0 |
| 2008-11-12 08:30:00 | AAPL | Stock | 3.3257 | 3.3257 | 3.3229 | 3.325 | 224280.0 |
| 2008-11-12 08:35:00 | AAPL | Stock | 3.3275 | 3.3286 | 3.3236 | 3.3236 | 82600.0 |
| 2008-11-12 08:40:00 | AAPL | Stock | 3.3246 | 3.325 | 3.3129 | 3.3129 | 353164.0 |
| 2008-11-12 08:45:00 | AAPL | Stock | 3.3161 | 3.3207 | 3.3043 | 3.3075 | 183148.0 |
| 2008-11-12 08:50:00 | AAPL | Stock | 3.3125 | 3.3125 | 3.2982 | 3.3014 | 406028.0 |
| 2008-11-12 08:55:00 | AAPL | Stock | 3.3043 | 3.3171 | 3.3043 | 3.3132 | 567700.0 |
| 2008-11-12 09:00:00 | AAPL | Stock | 3.3132 | 3.3168 | 3.3061 | 3.3089 | 639100.0 |
| 2008-11-12 09:05:00 | AAPL | Stock | 3.3121 | 3.3121 | 3.2954 | 3.3036 | 508620.0 |
| 2008-11-12 09:10:00 | AAPL | Stock | 3.3032 | 3.3089 | 3.3032 | 3.3054 | 265608.0 |
| 2008-11-12 09:15:00 | AAPL | Stock | 3.3068 | 3.3068 | 3.2961 | 3.3036 | 299040.0 |
| 2008-11-12 09:20:00 | AAPL | Stock | 3.3032 | 3.3104 | 3.3032 | 3.3104 | 142800.0 |
| 2008-11-12 09:25:00 | AAPL | Stock | 3.3089 | 3.31 | 3.2989 | 3.2996 | 1274700.0 |
| 2008-11-12 09:30:00 | AAPL | Stock | 3.3029 | 3.3132 | 3.2707 | 3.2943 | 34927424.0 |
| 2008-11-12 09:35:00 | AAPL | Stock | 3.2929 | 3.3036 | 3.2589 | 3.2689 | 26401452.0 |
| 2008-11-12 09:40:00 | AAPL | Stock | 3.2693 | 3.2804 | 3.2496 | 3.2568 | 29546552.0 |
| 2008-11-12 09:45:00 | AAPL | Stock | 3.2564 | 3.2821 | 3.2536 | 3.2721 | 25924080.0 |
| 2008-11-12 09:50:00 | AAPL | Stock | 3.2721 | 3.3025 | 3.2689 | 3.2925 | 27762000.0 |
| 2008-11-12 09:55:00 | AAPL | Stock | 3.2932 | 3.3014 | 3.2696 | 3.2711 | 19074244.0 |
| 2008-11-12 10:00:00 | AAPL | Stock | 3.2704 | 3.2943 | 3.2675 | 3.2918 | 18648672.0 |
| 2008-11-12 10:05:00 | AAPL | Stock | 3.2907 | 3.2912 | 3.2632 | 3.2671 | 17329088.0 |
| 2008-11-12 10:10:00 | AAPL | Stock | 3.2686 | 3.2964 | 3.2671 | 3.29 | 18174436.0 |
| 2008-11-12 10:15:00 | AAPL | Stock | 3.2896 | 3.3021 | 3.2789 | 3.2857 | 19094516.0 |
| 2008-11-12 10:20:00 | AAPL | Stock | 3.2868 | 3.2886 | 3.2714 | 3.2832 | 17709328.0 |
| 2008-11-12 10:25:00 | AAPL | Stock | 3.2836 | 3.2941 | 3.27 | 3.2737 | 17787000.0 |
| 2008-11-12 10:30:00 | AAPL | Stock | 3.2746 | 3.2975 | 3.2689 | 3.2832 | 23057608.0 |
| 2008-11-12 10:35:00 | AAPL | Stock | 3.2829 | 3.2996 | 3.2757 | 3.2914 | 20422808.0 |
| 2008-11-12 10:40:00 | AAPL | Stock | 3.2918 | 3.3267 | 3.2907 | 3.3211 | 30823352.0 |
| 2008-11-12 10:45:00 | AAPL | Stock | 3.3207 | 3.33 | 3.3071 | 3.3121 | 21813932.0 |
| 2008-11-12 10:50:00 | AAPL | Stock | 3.3107 | 3.3286 | 3.3089 | 3.3089 | 17088148.0 |
| 2008-11-12 10:55:00 | AAPL | Stock | 3.3089 | 3.3207 | 3.3032 | 3.3093 | 14612136.0 |
| 2008-11-12 11:00:00 | AAPL | Stock | 3.3096 | 3.3132 | 3.2882 | 3.2946 | 15172136.0 |
| 2008-11-12 11:05:00 | AAPL | Stock | 3.2946 | 3.3018 | 3.2857 | 3.2939 | 11580156.0 |
| 2008-11-12 11:10:00 | AAPL | Stock | 3.2946 | 3.3025 | 3.2857 | 3.3014 | 14961968.0 |
| 2008-11-12 11:15:00 | AAPL | Stock | 3.3 | 3.3196 | 3.2982 | 3.3143 | 14161056.0 |
| 2008-11-12 11:20:00 | AAPL | Stock | 3.3143 | 3.3286 | 3.3114 | 3.3271 | 16521204.0 |
| 2008-11-12 11:25:00 | AAPL | Stock | 3.3264 | 3.3296 | 3.3125 | 3.3177 | 13154932.0 |
| 2008-11-12 11:30:00 | AAPL | Stock | 3.3179 | 3.3189 | 3.2954 | 3.2993 | 13544972.0 |
| 2008-11-12 11:35:00 | AAPL | Stock | 3.2996 | 3.3039 | 3.2929 | 3.2946 | 8948632.0 |
| 2008-11-12 11:40:00 | AAPL | Stock | 3.2946 | 3.3025 | 3.2929 | 3.2939 | 7224028.0 |
| 2008-11-12 11:45:00 | AAPL | Stock | 3.2939 | 3.2989 | 3.2868 | 3.295 | 9827244.0 |
| 2008-11-12 11:50:00 | AAPL | Stock | 3.2954 | 3.297 | 3.2857 | 3.2868 | 9327696.0 |
| 2008-11-12 11:55:00 | AAPL | Stock | 3.2871 | 3.3011 | 3.2857 | 3.2975 | 7719208.0 |
| 2008-11-12 12:00:00 | AAPL | Stock | 3.2968 | 3.3018 | 3.295 | 3.3 | 4901232.0 |
> showing 50 of 312,874 rows — these rows as CSV