PREVIEW / stock_5min / 2001-08-24
file: by_date/stock_5min/2001/2001-08-24.parquet size: 1.5 MB rows: 105,310 symbols: 1,321
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 |
|---|---|---|---|---|---|---|---|
| 2001-08-24 08:30:00 | AAPL | Stock | 0.3214 | 0.3232 | 0.3214 | 0.3232 | 61600.0 |
| 2001-08-24 09:00:00 | AAPL | Stock | 0.3236 | 0.3236 | 0.3214 | 0.3214 | 44800.0 |
| 2001-08-24 09:10:00 | AAPL | Stock | 0.3223 | 0.3223 | 0.3223 | 0.3223 | 5600.0 |
| 2001-08-24 09:20:00 | AAPL | Stock | 0.3223 | 0.3223 | 0.3214 | 0.3214 | 408800.0 |
| 2001-08-24 09:25:00 | AAPL | Stock | 0.3218 | 0.3218 | 0.3218 | 0.3218 | 61600.0 |
| 2001-08-24 09:30:00 | AAPL | Stock | 0.3214 | 0.3223 | 0.3209 | 0.3209 | 3455200.0 |
| 2001-08-24 09:35:00 | AAPL | Stock | 0.3209 | 0.3211 | 0.3152 | 0.3154 | 8428000.0 |
| 2001-08-24 09:40:00 | AAPL | Stock | 0.3154 | 0.3189 | 0.3152 | 0.3173 | 2956800.0 |
| 2001-08-24 09:45:00 | AAPL | Stock | 0.3173 | 0.3179 | 0.3164 | 0.3175 | 1932000.0 |
| 2001-08-24 09:50:00 | AAPL | Stock | 0.3173 | 0.3186 | 0.3168 | 0.3171 | 1568000.0 |
| 2001-08-24 09:55:00 | AAPL | Stock | 0.3168 | 0.3179 | 0.3166 | 0.3173 | 1859200.0 |
| 2001-08-24 10:00:00 | AAPL | Stock | 0.3177 | 0.3196 | 0.3175 | 0.3195 | 3684800.0 |
| 2001-08-24 10:05:00 | AAPL | Stock | 0.3195 | 0.3196 | 0.3186 | 0.3191 | 6865600.0 |
| 2001-08-24 10:10:00 | AAPL | Stock | 0.3189 | 0.3205 | 0.3189 | 0.3196 | 6272000.0 |
| 2001-08-24 10:15:00 | AAPL | Stock | 0.3195 | 0.3202 | 0.3195 | 0.3196 | 5040000.0 |
| 2001-08-24 10:20:00 | AAPL | Stock | 0.32 | 0.32 | 0.3173 | 0.3182 | 2318400.0 |
| 2001-08-24 10:25:00 | AAPL | Stock | 0.3179 | 0.3195 | 0.3179 | 0.3194 | 2027200.0 |
| 2001-08-24 10:30:00 | AAPL | Stock | 0.3195 | 0.3209 | 0.3188 | 0.3207 | 5482400.0 |
| 2001-08-24 10:35:00 | AAPL | Stock | 0.3202 | 0.3216 | 0.3202 | 0.3214 | 4054400.0 |
| 2001-08-24 10:40:00 | AAPL | Stock | 0.3213 | 0.3214 | 0.3195 | 0.3205 | 4211200.0 |
| 2001-08-24 10:45:00 | AAPL | Stock | 0.3205 | 0.3211 | 0.3196 | 0.32 | 5488000.0 |
| 2001-08-24 10:50:00 | AAPL | Stock | 0.3198 | 0.3213 | 0.3196 | 0.3213 | 2094400.0 |
| 2001-08-24 10:55:00 | AAPL | Stock | 0.3211 | 0.3211 | 0.3198 | 0.3202 | 851200.0 |
| 2001-08-24 11:00:00 | AAPL | Stock | 0.3204 | 0.3218 | 0.3193 | 0.3214 | 2167200.0 |
| 2001-08-24 11:05:00 | AAPL | Stock | 0.3214 | 0.323 | 0.3214 | 0.3223 | 3662400.0 |
| 2001-08-24 11:10:00 | AAPL | Stock | 0.3223 | 0.3223 | 0.3214 | 0.3223 | 1036000.0 |
| 2001-08-24 11:15:00 | AAPL | Stock | 0.3223 | 0.3223 | 0.3214 | 0.3221 | 1836800.0 |
| 2001-08-24 11:20:00 | AAPL | Stock | 0.3221 | 0.3223 | 0.3196 | 0.3209 | 1232000.0 |
| 2001-08-24 11:25:00 | AAPL | Stock | 0.3214 | 0.3214 | 0.32 | 0.3213 | 2396800.0 |
| 2001-08-24 11:30:00 | AAPL | Stock | 0.3214 | 0.3214 | 0.3207 | 0.3207 | 3522400.0 |
| 2001-08-24 11:35:00 | AAPL | Stock | 0.3209 | 0.3214 | 0.3202 | 0.3214 | 2044000.0 |
| 2001-08-24 11:40:00 | AAPL | Stock | 0.3214 | 0.322 | 0.3205 | 0.3216 | 3640000.0 |
| 2001-08-24 11:45:00 | AAPL | Stock | 0.3214 | 0.322 | 0.3213 | 0.3218 | 2139200.0 |
| 2001-08-24 11:50:00 | AAPL | Stock | 0.322 | 0.3229 | 0.3216 | 0.322 | 2940000.0 |
| 2001-08-24 11:55:00 | AAPL | Stock | 0.322 | 0.3247 | 0.322 | 0.3241 | 7072800.0 |
| 2001-08-24 12:00:00 | AAPL | Stock | 0.3232 | 0.325 | 0.3232 | 0.3245 | 1372000.0 |
| 2001-08-24 12:05:00 | AAPL | Stock | 0.3243 | 0.3252 | 0.3239 | 0.325 | 7879200.0 |
| 2001-08-24 12:10:00 | AAPL | Stock | 0.325 | 0.3264 | 0.3241 | 0.3259 | 7453600.0 |
| 2001-08-24 12:15:00 | AAPL | Stock | 0.3255 | 0.3263 | 0.3254 | 0.3263 | 6020000.0 |
| 2001-08-24 12:20:00 | AAPL | Stock | 0.3263 | 0.3268 | 0.3257 | 0.3257 | 3102400.0 |
| 2001-08-24 12:25:00 | AAPL | Stock | 0.3257 | 0.3266 | 0.3254 | 0.3257 | 1192800.0 |
| 2001-08-24 12:30:00 | AAPL | Stock | 0.3255 | 0.3264 | 0.325 | 0.3257 | 4491200.0 |
| 2001-08-24 12:35:00 | AAPL | Stock | 0.3255 | 0.3271 | 0.3255 | 0.3271 | 1220800.0 |
| 2001-08-24 12:40:00 | AAPL | Stock | 0.3271 | 0.3279 | 0.3264 | 0.3268 | 5180000.0 |
| 2001-08-24 12:45:00 | AAPL | Stock | 0.327 | 0.3282 | 0.3264 | 0.3264 | 8047200.0 |
| 2001-08-24 12:50:00 | AAPL | Stock | 0.3264 | 0.3268 | 0.3259 | 0.3261 | 1618400.0 |
| 2001-08-24 12:55:00 | AAPL | Stock | 0.3261 | 0.3263 | 0.3254 | 0.3257 | 1030400.0 |
| 2001-08-24 13:00:00 | AAPL | Stock | 0.3257 | 0.3277 | 0.3257 | 0.3277 | 2212000.0 |
| 2001-08-24 13:05:00 | AAPL | Stock | 0.3277 | 0.3286 | 0.3271 | 0.3277 | 2536800.0 |
| 2001-08-24 13:10:00 | AAPL | Stock | 0.3277 | 0.3293 | 0.3271 | 0.3286 | 2643200.0 |
> showing 50 of 105,310 rows — these rows as CSV