PREVIEW / stock_5min / 2009-11-11
file: by_date/stock_5min/2009/2009-11-11.parquet size: 4.6 MB rows: 315,847 symbols: 3,402
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-11 04:15:00 | AAPL | Stock | 7.2632 | 7.2632 | 7.2632 | 7.2632 | 2800.0 |
| 2009-11-11 04:20:00 | AAPL | Stock | 7.2632 | 7.2686 | 7.2632 | 7.2686 | 5600.0 |
| 2009-11-11 06:10:00 | AAPL | Stock | 7.2857 | 7.2857 | 7.2857 | 7.2857 | 2800.0 |
| 2009-11-11 06:35:00 | AAPL | Stock | 7.2839 | 7.2839 | 7.2839 | 7.2839 | 2800.0 |
| 2009-11-11 06:55:00 | AAPL | Stock | 7.2857 | 7.2857 | 7.2857 | 7.2857 | 3920.0 |
| 2009-11-11 07:00:00 | AAPL | Stock | 7.3054 | 7.3071 | 7.3036 | 7.3071 | 33600.0 |
| 2009-11-11 07:05:00 | AAPL | Stock | 7.2914 | 7.2914 | 7.2914 | 7.2914 | 10220.0 |
| 2009-11-11 07:10:00 | AAPL | Stock | 7.2918 | 7.2943 | 7.2918 | 7.2929 | 35728.0 |
| 2009-11-11 07:15:00 | AAPL | Stock | 7.2943 | 7.2943 | 7.2911 | 7.2911 | 32900.0 |
| 2009-11-11 07:20:00 | AAPL | Stock | 7.2982 | 7.2982 | 7.2982 | 7.2982 | 3500.0 |
| 2009-11-11 07:25:00 | AAPL | Stock | 7.3 | 7.3 | 7.3 | 7.3 | 2800.0 |
| 2009-11-11 07:30:00 | AAPL | Stock | 7.2996 | 7.2996 | 7.2996 | 7.2996 | 11200.0 |
| 2009-11-11 07:35:00 | AAPL | Stock | 7.2982 | 7.2982 | 7.2929 | 7.2939 | 34384.0 |
| 2009-11-11 07:40:00 | AAPL | Stock | 7.2964 | 7.2996 | 7.2939 | 7.2939 | 16800.0 |
| 2009-11-11 07:45:00 | AAPL | Stock | 7.3 | 7.3036 | 7.2989 | 7.3036 | 58660.0 |
| 2009-11-11 07:50:00 | AAPL | Stock | 7.3036 | 7.3064 | 7.3021 | 7.3021 | 62300.0 |
| 2009-11-11 07:55:00 | AAPL | Stock | 7.3036 | 7.3107 | 7.3036 | 7.3107 | 19600.0 |
| 2009-11-11 08:00:00 | AAPL | Stock | 7.3061 | 7.3089 | 7.3025 | 7.3089 | 508844.0 |
| 2009-11-11 08:05:00 | AAPL | Stock | 7.305 | 7.3121 | 7.3018 | 7.3093 | 312060.0 |
| 2009-11-11 08:10:00 | AAPL | Stock | 7.3089 | 7.3157 | 7.3089 | 7.3143 | 223440.0 |
| 2009-11-11 08:15:00 | AAPL | Stock | 7.3125 | 7.3132 | 7.3071 | 7.3114 | 814548.0 |
| 2009-11-11 08:20:00 | AAPL | Stock | 7.3121 | 7.3121 | 7.3032 | 7.3032 | 201600.0 |
| 2009-11-11 08:25:00 | AAPL | Stock | 7.3018 | 7.3054 | 7.3011 | 7.3054 | 83888.0 |
| 2009-11-11 08:30:00 | AAPL | Stock | 7.3071 | 7.3114 | 7.3036 | 7.3043 | 189560.0 |
| 2009-11-11 08:35:00 | AAPL | Stock | 7.3068 | 7.3068 | 7.3018 | 7.3036 | 126784.0 |
| 2009-11-11 08:40:00 | AAPL | Stock | 7.3025 | 7.3071 | 7.3 | 7.3071 | 144900.0 |
| 2009-11-11 08:45:00 | AAPL | Stock | 7.3071 | 7.3107 | 7.3071 | 7.3089 | 47908.0 |
| 2009-11-11 08:50:00 | AAPL | Stock | 7.3089 | 7.3125 | 7.3079 | 7.3104 | 428372.0 |
| 2009-11-11 08:55:00 | AAPL | Stock | 7.3107 | 7.3121 | 7.3079 | 7.3107 | 158200.0 |
| 2009-11-11 09:00:00 | AAPL | Stock | 7.3093 | 7.3114 | 7.3075 | 7.3114 | 117880.0 |
| 2009-11-11 09:05:00 | AAPL | Stock | 7.3107 | 7.3118 | 7.3093 | 7.31 | 89600.0 |
| 2009-11-11 09:10:00 | AAPL | Stock | 7.3104 | 7.3143 | 7.3104 | 7.3125 | 446656.0 |
| 2009-11-11 09:15:00 | AAPL | Stock | 7.3125 | 7.3125 | 7.3082 | 7.3082 | 71960.0 |
| 2009-11-11 09:20:00 | AAPL | Stock | 7.31 | 7.31 | 7.3071 | 7.3082 | 142996.0 |
| 2009-11-11 09:25:00 | AAPL | Stock | 7.3039 | 7.3082 | 7.3004 | 7.3079 | 94024.0 |
| 2009-11-11 09:30:00 | AAPL | Stock | 7.3082 | 7.3136 | 7.2857 | 7.3111 | 16770264.0 |
| 2009-11-11 09:35:00 | AAPL | Stock | 7.3107 | 7.3207 | 7.3054 | 7.3138 | 19373060.0 |
| 2009-11-11 09:40:00 | AAPL | Stock | 7.3139 | 7.3214 | 7.3093 | 7.3179 | 17879036.0 |
| 2009-11-11 09:45:00 | AAPL | Stock | 7.3189 | 7.3195 | 7.275 | 7.2807 | 19712476.0 |
| 2009-11-11 09:50:00 | AAPL | Stock | 7.2811 | 7.3029 | 7.2768 | 7.2989 | 7677292.0 |
| 2009-11-11 09:55:00 | AAPL | Stock | 7.2986 | 7.3118 | 7.2904 | 7.3025 | 9467108.0 |
| 2009-11-11 10:00:00 | AAPL | Stock | 7.3025 | 7.3107 | 7.2857 | 7.2857 | 9255120.0 |
| 2009-11-11 10:05:00 | AAPL | Stock | 7.2868 | 7.2889 | 7.275 | 7.2839 | 11231584.0 |
| 2009-11-11 10:10:00 | AAPL | Stock | 7.2839 | 7.3114 | 7.2814 | 7.3097 | 10125668.0 |
| 2009-11-11 10:15:00 | AAPL | Stock | 7.3097 | 7.3168 | 7.2975 | 7.3046 | 7613816.0 |
| 2009-11-11 10:20:00 | AAPL | Stock | 7.3057 | 7.3089 | 7.2911 | 7.3018 | 6171872.0 |
| 2009-11-11 10:25:00 | AAPL | Stock | 7.3018 | 7.3086 | 7.2943 | 7.3025 | 7992404.0 |
| 2009-11-11 10:30:00 | AAPL | Stock | 7.3025 | 7.3036 | 7.2879 | 7.2993 | 4730376.0 |
| 2009-11-11 10:35:00 | AAPL | Stock | 7.2993 | 7.3132 | 7.2965 | 7.3057 | 8261176.0 |
| 2009-11-11 10:40:00 | AAPL | Stock | 7.3054 | 7.3129 | 7.2936 | 7.2975 | 5846344.0 |
> showing 50 of 315,847 rows — these rows as CSV