PREVIEW / stock_5min / 2007-06-28
file: by_date/stock_5min/2007/2007-06-28.parquet size: 3.9 MB rows: 291,207 symbols: 3,007
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-28 09:30:00 | AAPL | Stock | 4.37 | 4.3746 | 4.3407 | 4.3525 | 26467784.0 |
| 2007-06-28 09:35:00 | AAPL | Stock | 4.3529 | 4.3529 | 4.315 | 4.3154 | 31793272.0 |
| 2007-06-28 09:40:00 | AAPL | Stock | 4.3164 | 4.3286 | 4.3079 | 4.315 | 18911956.0 |
| 2007-06-28 09:45:00 | AAPL | Stock | 4.3143 | 4.3357 | 4.3079 | 4.3229 | 18252220.0 |
| 2007-06-28 09:50:00 | AAPL | Stock | 4.3232 | 4.3339 | 4.3136 | 4.3171 | 13010256.0 |
| 2007-06-28 09:55:00 | AAPL | Stock | 4.3171 | 4.32 | 4.31 | 4.3136 | 11248244.0 |
| 2007-06-28 10:00:00 | AAPL | Stock | 4.315 | 4.315 | 4.2957 | 4.2971 | 22313732.0 |
| 2007-06-28 10:05:00 | AAPL | Stock | 4.2975 | 4.3107 | 4.2964 | 4.2993 | 14891296.0 |
| 2007-06-28 10:10:00 | AAPL | Stock | 4.2993 | 4.2993 | 4.2889 | 4.2929 | 17209864.0 |
| 2007-06-28 10:15:00 | AAPL | Stock | 4.2932 | 4.3036 | 4.2857 | 4.2911 | 16104396.0 |
| 2007-06-28 10:20:00 | AAPL | Stock | 4.2914 | 4.3036 | 4.2857 | 4.2879 | 21781004.0 |
| 2007-06-28 10:25:00 | AAPL | Stock | 4.2879 | 4.2959 | 4.2864 | 4.2932 | 12066320.0 |
| 2007-06-28 10:30:00 | AAPL | Stock | 4.2936 | 4.3029 | 4.2921 | 4.2996 | 10898916.0 |
| 2007-06-28 10:35:00 | AAPL | Stock | 4.2993 | 4.3004 | 4.2911 | 4.2925 | 9429756.0 |
| 2007-06-28 10:40:00 | AAPL | Stock | 4.2929 | 4.3029 | 4.2921 | 4.3007 | 5638360.0 |
| 2007-06-28 10:45:00 | AAPL | Stock | 4.3007 | 4.3107 | 4.2986 | 4.3032 | 13104700.0 |
| 2007-06-28 10:50:00 | AAPL | Stock | 4.3032 | 4.3096 | 4.3025 | 4.3075 | 5013904.0 |
| 2007-06-28 10:55:00 | AAPL | Stock | 4.3079 | 4.3129 | 4.2986 | 4.3061 | 9517144.0 |
| 2007-06-28 11:00:00 | AAPL | Stock | 4.3061 | 4.3107 | 4.3018 | 4.3029 | 7651784.0 |
| 2007-06-28 11:05:00 | AAPL | Stock | 4.3029 | 4.3046 | 4.2936 | 4.3007 | 8614116.0 |
| 2007-06-28 11:10:00 | AAPL | Stock | 4.3007 | 4.3054 | 4.2993 | 4.3004 | 7009520.0 |
| 2007-06-28 11:15:00 | AAPL | Stock | 4.3 | 4.3 | 4.29 | 4.2968 | 9516024.0 |
| 2007-06-28 11:20:00 | AAPL | Stock | 4.2971 | 4.3018 | 4.2964 | 4.3004 | 5085528.0 |
| 2007-06-28 11:25:00 | AAPL | Stock | 4.3004 | 4.3029 | 4.2921 | 4.2954 | 11355680.0 |
| 2007-06-28 11:30:00 | AAPL | Stock | 4.2954 | 4.3014 | 4.2943 | 4.3 | 5742884.0 |
| 2007-06-28 11:35:00 | AAPL | Stock | 4.2996 | 4.3075 | 4.2986 | 4.305 | 6054300.0 |
| 2007-06-28 11:40:00 | AAPL | Stock | 4.305 | 4.3068 | 4.2986 | 4.2989 | 4953116.0 |
| 2007-06-28 11:45:00 | AAPL | Stock | 4.2989 | 4.3007 | 4.2975 | 4.3004 | 2801960.0 |
| 2007-06-28 11:50:00 | AAPL | Stock | 4.3 | 4.3032 | 4.2982 | 4.3021 | 5483492.0 |
| 2007-06-28 11:55:00 | AAPL | Stock | 4.3025 | 4.3032 | 4.3004 | 4.3011 | 7437276.0 |
| 2007-06-28 12:00:00 | AAPL | Stock | 4.3011 | 4.3032 | 4.2993 | 4.3007 | 3962252.0 |
| 2007-06-28 12:05:00 | AAPL | Stock | 4.3006 | 4.3032 | 4.2996 | 4.3014 | 6032348.0 |
| 2007-06-28 12:10:00 | AAPL | Stock | 4.3018 | 4.3021 | 4.2993 | 4.2993 | 3680320.0 |
| 2007-06-28 12:15:00 | AAPL | Stock | 4.2993 | 4.31 | 4.2989 | 4.3082 | 6357652.0 |
| 2007-06-28 12:20:00 | AAPL | Stock | 4.3082 | 4.3114 | 4.3068 | 4.3104 | 7457100.0 |
| 2007-06-28 12:25:00 | AAPL | Stock | 4.3104 | 4.3182 | 4.3093 | 4.3172 | 7279720.0 |
| 2007-06-28 12:30:00 | AAPL | Stock | 4.3175 | 4.3214 | 4.3086 | 4.3129 | 11851700.0 |
| 2007-06-28 12:35:00 | AAPL | Stock | 4.3132 | 4.3196 | 4.313 | 4.3185 | 9334136.0 |
| 2007-06-28 12:40:00 | AAPL | Stock | 4.3182 | 4.3182 | 4.3132 | 4.3161 | 3042676.0 |
| 2007-06-28 12:45:00 | AAPL | Stock | 4.3161 | 4.3207 | 4.3154 | 4.3171 | 3627932.0 |
| 2007-06-28 12:50:00 | AAPL | Stock | 4.3171 | 4.3204 | 4.3146 | 4.3154 | 4612384.0 |
| 2007-06-28 12:55:00 | AAPL | Stock | 4.3157 | 4.3164 | 4.3125 | 4.3151 | 3762500.0 |
| 2007-06-28 13:00:00 | AAPL | Stock | 4.3154 | 4.3157 | 4.3082 | 4.3132 | 6783224.0 |
| 2007-06-28 13:05:00 | AAPL | Stock | 4.3136 | 4.3168 | 4.3093 | 4.3107 | 3140256.0 |
| 2007-06-28 13:10:00 | AAPL | Stock | 4.3104 | 4.3157 | 4.3054 | 4.3071 | 3582124.0 |
| 2007-06-28 13:15:00 | AAPL | Stock | 4.3043 | 4.3107 | 4.3043 | 4.3082 | 4088504.0 |
| 2007-06-28 13:20:00 | AAPL | Stock | 4.3082 | 4.3121 | 4.3071 | 4.3114 | 1796116.0 |
| 2007-06-28 13:25:00 | AAPL | Stock | 4.3118 | 4.3161 | 4.3114 | 4.3132 | 2449944.0 |
| 2007-06-28 13:30:00 | AAPL | Stock | 4.3132 | 4.315 | 4.3118 | 4.315 | 2320052.0 |
| 2007-06-28 13:35:00 | AAPL | Stock | 4.315 | 4.3182 | 4.3146 | 4.3158 | 3168200.0 |
> showing 50 of 291,207 rows — these rows as CSV