PREVIEW / stock_5min / 2003-05-07
file: by_date/stock_5min/2003/2003-05-07.parquet size: 2.0 MB rows: 147,056 symbols: 1,578
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 |
|---|---|---|---|---|---|---|---|
| 2003-05-07 08:00:00 | AAPL | Stock | 0.3071 | 0.3125 | 0.3045 | 0.3125 | 140000.0 |
| 2003-05-07 08:25:00 | AAPL | Stock | 0.3121 | 0.3123 | 0.3109 | 0.3116 | 173600.0 |
| 2003-05-07 08:35:00 | AAPL | Stock | 0.3104 | 0.3104 | 0.3104 | 0.3104 | 44800.0 |
| 2003-05-07 08:40:00 | AAPL | Stock | 0.3104 | 0.3104 | 0.3104 | 0.3104 | 5600.0 |
| 2003-05-07 08:45:00 | AAPL | Stock | 0.3098 | 0.3098 | 0.3098 | 0.3098 | 56000.0 |
| 2003-05-07 08:50:00 | AAPL | Stock | 0.3098 | 0.3098 | 0.3098 | 0.3098 | 28000.0 |
| 2003-05-07 08:55:00 | AAPL | Stock | 0.308 | 0.3096 | 0.3079 | 0.308 | 280000.0 |
| 2003-05-07 09:05:00 | AAPL | Stock | 0.308 | 0.3123 | 0.308 | 0.3123 | 123200.0 |
| 2003-05-07 09:15:00 | AAPL | Stock | 0.3097 | 0.3097 | 0.3089 | 0.3089 | 151200.0 |
| 2003-05-07 09:20:00 | AAPL | Stock | 0.3089 | 0.3089 | 0.308 | 0.3086 | 224000.0 |
| 2003-05-07 09:25:00 | AAPL | Stock | 0.308 | 0.3114 | 0.3075 | 0.3095 | 950992.0 |
| 2003-05-07 09:30:00 | AAPL | Stock | 0.3095 | 0.3098 | 0.3077 | 0.3079 | 55628216.0 |
| 2003-05-07 09:35:00 | AAPL | Stock | 0.308 | 0.3086 | 0.3055 | 0.3075 | 32778144.0 |
| 2003-05-07 09:40:00 | AAPL | Stock | 0.3075 | 0.3116 | 0.3071 | 0.3107 | 21539616.0 |
| 2003-05-07 09:45:00 | AAPL | Stock | 0.3109 | 0.3113 | 0.3086 | 0.3089 | 24579016.0 |
| 2003-05-07 09:50:00 | AAPL | Stock | 0.3091 | 0.3107 | 0.3082 | 0.3084 | 13991096.0 |
| 2003-05-07 09:55:00 | AAPL | Stock | 0.3082 | 0.3093 | 0.3079 | 0.3089 | 14188608.0 |
| 2003-05-07 10:00:00 | AAPL | Stock | 0.3089 | 0.3098 | 0.3084 | 0.3089 | 10112872.0 |
| 2003-05-07 10:05:00 | AAPL | Stock | 0.3089 | 0.3096 | 0.3088 | 0.3089 | 10016440.0 |
| 2003-05-07 10:10:00 | AAPL | Stock | 0.3089 | 0.3105 | 0.3084 | 0.3105 | 10424064.0 |
| 2003-05-07 10:15:00 | AAPL | Stock | 0.3104 | 0.3111 | 0.31 | 0.3102 | 8621256.0 |
| 2003-05-07 10:20:00 | AAPL | Stock | 0.3102 | 0.3125 | 0.31 | 0.3125 | 15926288.0 |
| 2003-05-07 10:25:00 | AAPL | Stock | 0.3125 | 0.3136 | 0.3109 | 0.3113 | 14852040.0 |
| 2003-05-07 10:30:00 | AAPL | Stock | 0.3113 | 0.312 | 0.3095 | 0.3118 | 6965392.0 |
| 2003-05-07 10:35:00 | AAPL | Stock | 0.3118 | 0.3139 | 0.3113 | 0.3134 | 7750400.0 |
| 2003-05-07 10:40:00 | AAPL | Stock | 0.3132 | 0.315 | 0.3129 | 0.3148 | 11200112.0 |
| 2003-05-07 10:45:00 | AAPL | Stock | 0.3148 | 0.317 | 0.3148 | 0.3164 | 20574288.0 |
| 2003-05-07 10:50:00 | AAPL | Stock | 0.3166 | 0.317 | 0.3154 | 0.3157 | 15140384.0 |
| 2003-05-07 10:55:00 | AAPL | Stock | 0.3157 | 0.3173 | 0.3155 | 0.317 | 11077248.0 |
| 2003-05-07 11:00:00 | AAPL | Stock | 0.317 | 0.3195 | 0.3168 | 0.3191 | 16576672.0 |
| 2003-05-07 11:05:00 | AAPL | Stock | 0.3191 | 0.3196 | 0.3177 | 0.318 | 10311672.0 |
| 2003-05-07 11:10:00 | AAPL | Stock | 0.3179 | 0.318 | 0.3164 | 0.317 | 12045768.0 |
| 2003-05-07 11:15:00 | AAPL | Stock | 0.317 | 0.3179 | 0.3169 | 0.3171 | 10170216.0 |
| 2003-05-07 11:20:00 | AAPL | Stock | 0.3171 | 0.3179 | 0.3168 | 0.3173 | 6720000.0 |
| 2003-05-07 11:25:00 | AAPL | Stock | 0.3175 | 0.3195 | 0.3173 | 0.3188 | 5338480.0 |
| 2003-05-07 11:30:00 | AAPL | Stock | 0.3188 | 0.3211 | 0.3188 | 0.3211 | 11293296.0 |
| 2003-05-07 11:35:00 | AAPL | Stock | 0.3211 | 0.3214 | 0.3204 | 0.3213 | 12090848.0 |
| 2003-05-07 11:40:00 | AAPL | Stock | 0.3213 | 0.3243 | 0.3211 | 0.3239 | 28526848.0 |
| 2003-05-07 11:45:00 | AAPL | Stock | 0.3241 | 0.3257 | 0.3236 | 0.3248 | 32257568.0 |
| 2003-05-07 11:50:00 | AAPL | Stock | 0.3249 | 0.325 | 0.3234 | 0.3234 | 17490536.0 |
| 2003-05-07 11:55:00 | AAPL | Stock | 0.3234 | 0.3241 | 0.3209 | 0.3209 | 13371792.0 |
| 2003-05-07 12:00:00 | AAPL | Stock | 0.3211 | 0.3216 | 0.3198 | 0.3211 | 15575448.0 |
| 2003-05-07 12:05:00 | AAPL | Stock | 0.3209 | 0.3218 | 0.3207 | 0.3214 | 19100480.0 |
| 2003-05-07 12:10:00 | AAPL | Stock | 0.3211 | 0.3215 | 0.3205 | 0.3205 | 7688800.0 |
| 2003-05-07 12:15:00 | AAPL | Stock | 0.3205 | 0.3216 | 0.3205 | 0.3209 | 8388296.0 |
| 2003-05-07 12:20:00 | AAPL | Stock | 0.3207 | 0.3209 | 0.3188 | 0.3198 | 7251664.0 |
| 2003-05-07 12:25:00 | AAPL | Stock | 0.3198 | 0.3209 | 0.3196 | 0.3209 | 26706400.0 |
| 2003-05-07 12:30:00 | AAPL | Stock | 0.3209 | 0.3211 | 0.3196 | 0.3204 | 7090440.0 |
| 2003-05-07 12:35:00 | AAPL | Stock | 0.3207 | 0.3216 | 0.3207 | 0.3216 | 7880992.0 |
| 2003-05-07 12:40:00 | AAPL | Stock | 0.3218 | 0.3227 | 0.3214 | 0.3214 | 8377544.0 |
> showing 50 of 147,056 rows — these rows as CSV