PREVIEW / stock_5min / 2003-06-17
file: by_date/stock_5min/2003/2003-06-17.parquet size: 2.2 MB rows: 153,715 symbols: 1,585
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-06-17 08:35:00 | AAPL | Stock | 0.3263 | 0.3263 | 0.3263 | 0.3263 | 48552.0 |
| 2003-06-17 08:45:00 | AAPL | Stock | 0.3268 | 0.3268 | 0.3268 | 0.3268 | 11200.0 |
| 2003-06-17 08:55:00 | AAPL | Stock | 0.3264 | 0.3268 | 0.3264 | 0.3264 | 2878400.0 |
| 2003-06-17 09:25:00 | AAPL | Stock | 0.327 | 0.3275 | 0.3268 | 0.3275 | 509600.0 |
| 2003-06-17 09:30:00 | AAPL | Stock | 0.3288 | 0.3302 | 0.3255 | 0.3259 | 8141504.0 |
| 2003-06-17 09:35:00 | AAPL | Stock | 0.3262 | 0.3304 | 0.3259 | 0.3289 | 7215040.0 |
| 2003-06-17 09:40:00 | AAPL | Stock | 0.3288 | 0.33 | 0.3282 | 0.3282 | 3298400.0 |
| 2003-06-17 09:45:00 | AAPL | Stock | 0.3282 | 0.3282 | 0.3223 | 0.3232 | 5381600.0 |
| 2003-06-17 09:50:00 | AAPL | Stock | 0.3234 | 0.3263 | 0.3232 | 0.3252 | 3402224.0 |
| 2003-06-17 09:55:00 | AAPL | Stock | 0.325 | 0.3257 | 0.3246 | 0.3246 | 7638400.0 |
| 2003-06-17 10:00:00 | AAPL | Stock | 0.3245 | 0.3271 | 0.3241 | 0.3266 | 4121600.0 |
| 2003-06-17 10:05:00 | AAPL | Stock | 0.3266 | 0.3275 | 0.3259 | 0.3266 | 1394400.0 |
| 2003-06-17 10:10:00 | AAPL | Stock | 0.3263 | 0.3264 | 0.3259 | 0.3259 | 1388800.0 |
| 2003-06-17 10:15:00 | AAPL | Stock | 0.3259 | 0.3259 | 0.323 | 0.3239 | 4160800.0 |
| 2003-06-17 10:20:00 | AAPL | Stock | 0.3241 | 0.3245 | 0.3234 | 0.3238 | 1664040.0 |
| 2003-06-17 10:25:00 | AAPL | Stock | 0.3239 | 0.3239 | 0.3213 | 0.3229 | 6385120.0 |
| 2003-06-17 10:30:00 | AAPL | Stock | 0.3229 | 0.3239 | 0.3227 | 0.3238 | 2895200.0 |
| 2003-06-17 10:35:00 | AAPL | Stock | 0.3238 | 0.3239 | 0.323 | 0.3234 | 3427200.0 |
| 2003-06-17 10:40:00 | AAPL | Stock | 0.3234 | 0.3236 | 0.3229 | 0.3232 | 1977416.0 |
| 2003-06-17 10:45:00 | AAPL | Stock | 0.3232 | 0.3243 | 0.3227 | 0.3239 | 2317056.0 |
| 2003-06-17 10:50:00 | AAPL | Stock | 0.3239 | 0.3241 | 0.3238 | 0.3241 | 481600.0 |
| 2003-06-17 10:55:00 | AAPL | Stock | 0.3241 | 0.3245 | 0.3239 | 0.3239 | 3864000.0 |
| 2003-06-17 11:00:00 | AAPL | Stock | 0.3239 | 0.3245 | 0.3237 | 0.3243 | 1780800.0 |
| 2003-06-17 11:05:00 | AAPL | Stock | 0.3243 | 0.3245 | 0.3241 | 0.3245 | 985488.0 |
| 2003-06-17 11:10:00 | AAPL | Stock | 0.3244 | 0.3245 | 0.3241 | 0.3243 | 711200.0 |
| 2003-06-17 11:15:00 | AAPL | Stock | 0.3245 | 0.3246 | 0.3239 | 0.3241 | 835016.0 |
| 2003-06-17 11:20:00 | AAPL | Stock | 0.3241 | 0.3246 | 0.3241 | 0.3241 | 1596000.0 |
| 2003-06-17 11:25:00 | AAPL | Stock | 0.3241 | 0.3245 | 0.3239 | 0.3243 | 1316000.0 |
| 2003-06-17 11:30:00 | AAPL | Stock | 0.3243 | 0.3245 | 0.3241 | 0.3243 | 1394400.0 |
| 2003-06-17 11:35:00 | AAPL | Stock | 0.3243 | 0.3248 | 0.3241 | 0.3248 | 1369984.0 |
| 2003-06-17 11:40:00 | AAPL | Stock | 0.3248 | 0.3252 | 0.3245 | 0.3245 | 1187200.0 |
| 2003-06-17 11:45:00 | AAPL | Stock | 0.3246 | 0.3246 | 0.3241 | 0.3241 | 375200.0 |
| 2003-06-17 11:50:00 | AAPL | Stock | 0.3241 | 0.3241 | 0.3234 | 0.3234 | 1176000.0 |
| 2003-06-17 11:55:00 | AAPL | Stock | 0.3234 | 0.3241 | 0.3234 | 0.3239 | 3774400.0 |
| 2003-06-17 12:00:00 | AAPL | Stock | 0.3239 | 0.3241 | 0.3238 | 0.3238 | 834400.0 |
| 2003-06-17 12:05:00 | AAPL | Stock | 0.3238 | 0.3239 | 0.3238 | 0.3238 | 756000.0 |
| 2003-06-17 12:10:00 | AAPL | Stock | 0.3239 | 0.3239 | 0.3236 | 0.3236 | 240800.0 |
| 2003-06-17 12:15:00 | AAPL | Stock | 0.3236 | 0.3236 | 0.3216 | 0.3221 | 2080960.0 |
| 2003-06-17 12:20:00 | AAPL | Stock | 0.3223 | 0.323 | 0.3221 | 0.3229 | 632800.0 |
| 2003-06-17 12:25:00 | AAPL | Stock | 0.3229 | 0.3232 | 0.3223 | 0.3225 | 397600.0 |
| 2003-06-17 12:30:00 | AAPL | Stock | 0.3229 | 0.323 | 0.3223 | 0.3223 | 504000.0 |
| 2003-06-17 12:35:00 | AAPL | Stock | 0.3223 | 0.3232 | 0.3223 | 0.323 | 392000.0 |
| 2003-06-17 12:40:00 | AAPL | Stock | 0.3229 | 0.3236 | 0.3227 | 0.3234 | 638960.0 |
| 2003-06-17 12:45:00 | AAPL | Stock | 0.3234 | 0.3236 | 0.323 | 0.3232 | 498400.0 |
| 2003-06-17 12:50:00 | AAPL | Stock | 0.3236 | 0.3236 | 0.3227 | 0.3234 | 705600.0 |
| 2003-06-17 12:55:00 | AAPL | Stock | 0.3234 | 0.3234 | 0.3229 | 0.3229 | 1104656.0 |
| 2003-06-17 13:00:00 | AAPL | Stock | 0.3229 | 0.3234 | 0.3227 | 0.323 | 3617600.0 |
| 2003-06-17 13:05:00 | AAPL | Stock | 0.323 | 0.3236 | 0.3229 | 0.3236 | 812000.0 |
| 2003-06-17 13:10:00 | AAPL | Stock | 0.3234 | 0.3236 | 0.3234 | 0.3234 | 207200.0 |
| 2003-06-17 13:15:00 | AAPL | Stock | 0.3234 | 0.3239 | 0.3234 | 0.3238 | 285600.0 |
> showing 50 of 153,715 rows — these rows as CSV