PREVIEW / stock_5min / 2003-05-09
file: by_date/stock_5min/2003/2003-05-09.parquet size: 1.9 MB rows: 142,167 symbols: 1,583
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-09 08:00:00 | AAPL | Stock | 0.322 | 0.322 | 0.322 | 0.322 | 11200.0 |
| 2003-05-09 08:05:00 | AAPL | Stock | 0.3216 | 0.3224 | 0.3216 | 0.3223 | 78400.0 |
| 2003-05-09 08:10:00 | AAPL | Stock | 0.3236 | 0.3245 | 0.3235 | 0.3236 | 151200.0 |
| 2003-05-09 08:20:00 | AAPL | Stock | 0.3245 | 0.3245 | 0.3245 | 0.3245 | 100800.0 |
| 2003-05-09 08:30:00 | AAPL | Stock | 0.325 | 0.325 | 0.325 | 0.325 | 22400.0 |
| 2003-05-09 08:35:00 | AAPL | Stock | 0.325 | 0.325 | 0.325 | 0.325 | 28000.0 |
| 2003-05-09 08:40:00 | AAPL | Stock | 0.3255 | 0.3259 | 0.3255 | 0.3259 | 50400.0 |
| 2003-05-09 08:45:00 | AAPL | Stock | 0.3266 | 0.3268 | 0.3259 | 0.3268 | 352800.0 |
| 2003-05-09 08:50:00 | AAPL | Stock | 0.3268 | 0.3268 | 0.3263 | 0.3263 | 162400.0 |
| 2003-05-09 08:55:00 | AAPL | Stock | 0.3268 | 0.3268 | 0.3268 | 0.3268 | 56000.0 |
| 2003-05-09 09:00:00 | AAPL | Stock | 0.3268 | 0.3271 | 0.3268 | 0.3271 | 193200.0 |
| 2003-05-09 09:05:00 | AAPL | Stock | 0.3268 | 0.3271 | 0.3268 | 0.3271 | 156800.0 |
| 2003-05-09 09:10:00 | AAPL | Stock | 0.327 | 0.327 | 0.3268 | 0.3268 | 50400.0 |
| 2003-05-09 09:15:00 | AAPL | Stock | 0.3268 | 0.327 | 0.3268 | 0.3268 | 117600.0 |
| 2003-05-09 09:20:00 | AAPL | Stock | 0.327 | 0.327 | 0.327 | 0.327 | 89600.0 |
| 2003-05-09 09:25:00 | AAPL | Stock | 0.3261 | 0.327 | 0.3259 | 0.327 | 1027600.0 |
| 2003-05-09 09:30:00 | AAPL | Stock | 0.3273 | 0.3286 | 0.3255 | 0.3257 | 39689664.0 |
| 2003-05-09 09:35:00 | AAPL | Stock | 0.3257 | 0.3273 | 0.3255 | 0.3273 | 21399224.0 |
| 2003-05-09 09:40:00 | AAPL | Stock | 0.3273 | 0.3275 | 0.3239 | 0.325 | 17722656.0 |
| 2003-05-09 09:45:00 | AAPL | Stock | 0.325 | 0.3257 | 0.3243 | 0.3252 | 13321280.0 |
| 2003-05-09 09:50:00 | AAPL | Stock | 0.3252 | 0.3261 | 0.325 | 0.325 | 12234880.0 |
| 2003-05-09 09:55:00 | AAPL | Stock | 0.3254 | 0.3268 | 0.3245 | 0.3266 | 16482704.0 |
| 2003-05-09 10:00:00 | AAPL | Stock | 0.3266 | 0.3271 | 0.3252 | 0.3257 | 7033600.0 |
| 2003-05-09 10:05:00 | AAPL | Stock | 0.3257 | 0.3264 | 0.3252 | 0.3257 | 12096000.0 |
| 2003-05-09 10:10:00 | AAPL | Stock | 0.3257 | 0.3263 | 0.3236 | 0.3243 | 9718464.0 |
| 2003-05-09 10:15:00 | AAPL | Stock | 0.3245 | 0.3255 | 0.3241 | 0.3245 | 9571800.0 |
| 2003-05-09 10:20:00 | AAPL | Stock | 0.3245 | 0.3246 | 0.3232 | 0.3243 | 9956072.0 |
| 2003-05-09 10:25:00 | AAPL | Stock | 0.3243 | 0.3248 | 0.3238 | 0.3248 | 11499768.0 |
| 2003-05-09 10:30:00 | AAPL | Stock | 0.3248 | 0.3252 | 0.3241 | 0.3241 | 4089064.0 |
| 2003-05-09 10:35:00 | AAPL | Stock | 0.3243 | 0.3246 | 0.3239 | 0.3246 | 4953144.0 |
| 2003-05-09 10:40:00 | AAPL | Stock | 0.3243 | 0.3248 | 0.3241 | 0.3246 | 4513544.0 |
| 2003-05-09 10:45:00 | AAPL | Stock | 0.3246 | 0.325 | 0.3243 | 0.3245 | 2021936.0 |
| 2003-05-09 10:50:00 | AAPL | Stock | 0.3245 | 0.3246 | 0.3238 | 0.3239 | 4725504.0 |
| 2003-05-09 10:55:00 | AAPL | Stock | 0.3239 | 0.3245 | 0.3232 | 0.3245 | 5370400.0 |
| 2003-05-09 11:00:00 | AAPL | Stock | 0.3245 | 0.325 | 0.3241 | 0.3243 | 8649256.0 |
| 2003-05-09 11:05:00 | AAPL | Stock | 0.3243 | 0.3245 | 0.3236 | 0.3239 | 5752600.0 |
| 2003-05-09 11:10:00 | AAPL | Stock | 0.3243 | 0.3246 | 0.3239 | 0.324 | 4558400.0 |
| 2003-05-09 11:15:00 | AAPL | Stock | 0.3239 | 0.3241 | 0.3236 | 0.3238 | 4636800.0 |
| 2003-05-09 11:20:00 | AAPL | Stock | 0.3238 | 0.3239 | 0.3236 | 0.3236 | 3480232.0 |
| 2003-05-09 11:25:00 | AAPL | Stock | 0.3236 | 0.3245 | 0.3236 | 0.3238 | 6812792.0 |
| 2003-05-09 11:30:00 | AAPL | Stock | 0.3238 | 0.3245 | 0.3236 | 0.3243 | 4561760.0 |
| 2003-05-09 11:35:00 | AAPL | Stock | 0.3241 | 0.3245 | 0.3238 | 0.3238 | 6011824.0 |
| 2003-05-09 11:40:00 | AAPL | Stock | 0.3238 | 0.3238 | 0.3218 | 0.322 | 10766560.0 |
| 2003-05-09 11:45:00 | AAPL | Stock | 0.3218 | 0.3225 | 0.3218 | 0.3223 | 2388176.0 |
| 2003-05-09 11:50:00 | AAPL | Stock | 0.3223 | 0.3223 | 0.3196 | 0.3198 | 11441024.0 |
| 2003-05-09 11:55:00 | AAPL | Stock | 0.32 | 0.3214 | 0.3193 | 0.3214 | 10208800.0 |
| 2003-05-09 12:00:00 | AAPL | Stock | 0.3214 | 0.3232 | 0.3214 | 0.3223 | 7239456.0 |
| 2003-05-09 12:05:00 | AAPL | Stock | 0.3223 | 0.3225 | 0.322 | 0.3221 | 3664416.0 |
| 2003-05-09 12:10:00 | AAPL | Stock | 0.3223 | 0.3232 | 0.3221 | 0.3227 | 6281576.0 |
| 2003-05-09 12:15:00 | AAPL | Stock | 0.3227 | 0.3238 | 0.3227 | 0.323 | 7319088.0 |
> showing 50 of 142,167 rows — these rows as CSV