PREVIEW / stock_5min / 2003-05-28
file: by_date/stock_5min/2003/2003-05-28.parquet size: 2.1 MB rows: 151,674 symbols: 1,582
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-28 08:00:00 | AAPL | Stock | 0.3371 | 0.3371 | 0.3357 | 0.3357 | 84000.0 |
| 2003-05-28 08:15:00 | AAPL | Stock | 0.3371 | 0.3371 | 0.3371 | 0.3371 | 5600.0 |
| 2003-05-28 08:20:00 | AAPL | Stock | 0.3371 | 0.3371 | 0.3371 | 0.3371 | 16800.0 |
| 2003-05-28 08:35:00 | AAPL | Stock | 0.337 | 0.337 | 0.337 | 0.337 | 56000.0 |
| 2003-05-28 08:55:00 | AAPL | Stock | 0.3373 | 0.3373 | 0.3373 | 0.3373 | 117600.0 |
| 2003-05-28 09:00:00 | AAPL | Stock | 0.3361 | 0.3361 | 0.3357 | 0.3357 | 33600.0 |
| 2003-05-28 09:05:00 | AAPL | Stock | 0.3357 | 0.3368 | 0.3357 | 0.3368 | 67200.0 |
| 2003-05-28 09:10:00 | AAPL | Stock | 0.3346 | 0.3346 | 0.333 | 0.333 | 28000.0 |
| 2003-05-28 09:20:00 | AAPL | Stock | 0.3339 | 0.3355 | 0.3338 | 0.3338 | 319200.0 |
| 2003-05-28 09:25:00 | AAPL | Stock | 0.3339 | 0.3355 | 0.33 | 0.33 | 2769200.0 |
| 2003-05-28 09:30:00 | AAPL | Stock | 0.3304 | 0.3331 | 0.3277 | 0.3318 | 12980520.0 |
| 2003-05-28 09:35:00 | AAPL | Stock | 0.332 | 0.333 | 0.3254 | 0.3268 | 14981624.0 |
| 2003-05-28 09:40:00 | AAPL | Stock | 0.327 | 0.3311 | 0.3264 | 0.3298 | 10763200.0 |
| 2003-05-28 09:45:00 | AAPL | Stock | 0.3298 | 0.3307 | 0.3295 | 0.33 | 5742856.0 |
| 2003-05-28 09:50:00 | AAPL | Stock | 0.33 | 0.3302 | 0.3286 | 0.3293 | 5545008.0 |
| 2003-05-28 09:55:00 | AAPL | Stock | 0.3295 | 0.3298 | 0.328 | 0.3293 | 5380872.0 |
| 2003-05-28 10:00:00 | AAPL | Stock | 0.3296 | 0.3298 | 0.3282 | 0.3286 | 4628680.0 |
| 2003-05-28 10:05:00 | AAPL | Stock | 0.3286 | 0.3288 | 0.3259 | 0.3259 | 8452416.0 |
| 2003-05-28 10:10:00 | AAPL | Stock | 0.3266 | 0.3293 | 0.3259 | 0.3271 | 5022472.0 |
| 2003-05-28 10:15:00 | AAPL | Stock | 0.3271 | 0.3279 | 0.3261 | 0.3268 | 6298376.0 |
| 2003-05-28 10:20:00 | AAPL | Stock | 0.327 | 0.3284 | 0.3266 | 0.3282 | 5549208.0 |
| 2003-05-28 10:25:00 | AAPL | Stock | 0.328 | 0.33 | 0.3277 | 0.3288 | 6181952.0 |
| 2003-05-28 10:30:00 | AAPL | Stock | 0.3291 | 0.3296 | 0.3291 | 0.3291 | 1319136.0 |
| 2003-05-28 10:35:00 | AAPL | Stock | 0.3293 | 0.3295 | 0.3289 | 0.3291 | 2802240.0 |
| 2003-05-28 10:40:00 | AAPL | Stock | 0.3291 | 0.3295 | 0.3284 | 0.3289 | 3453240.0 |
| 2003-05-28 10:45:00 | AAPL | Stock | 0.3289 | 0.3291 | 0.3286 | 0.3288 | 1937600.0 |
| 2003-05-28 10:50:00 | AAPL | Stock | 0.3288 | 0.3291 | 0.3288 | 0.3288 | 817600.0 |
| 2003-05-28 10:55:00 | AAPL | Stock | 0.3289 | 0.3291 | 0.3288 | 0.3288 | 2510200.0 |
| 2003-05-28 11:00:00 | AAPL | Stock | 0.3288 | 0.3302 | 0.3288 | 0.3302 | 3623424.0 |
| 2003-05-28 11:05:00 | AAPL | Stock | 0.3302 | 0.3304 | 0.3298 | 0.3302 | 3785600.0 |
| 2003-05-28 11:10:00 | AAPL | Stock | 0.3302 | 0.3304 | 0.3296 | 0.3298 | 2089360.0 |
| 2003-05-28 11:15:00 | AAPL | Stock | 0.3298 | 0.3305 | 0.3298 | 0.33 | 1036000.0 |
| 2003-05-28 11:20:00 | AAPL | Stock | 0.3304 | 0.3304 | 0.33 | 0.3303 | 173600.0 |
| 2003-05-28 11:25:00 | AAPL | Stock | 0.3302 | 0.3304 | 0.3298 | 0.33 | 1185016.0 |
| 2003-05-28 11:30:00 | AAPL | Stock | 0.33 | 0.3305 | 0.3298 | 0.3302 | 2248344.0 |
| 2003-05-28 11:35:00 | AAPL | Stock | 0.3302 | 0.3305 | 0.3293 | 0.3304 | 1511104.0 |
| 2003-05-28 11:40:00 | AAPL | Stock | 0.33 | 0.3304 | 0.3296 | 0.3298 | 2676800.0 |
| 2003-05-28 11:45:00 | AAPL | Stock | 0.33 | 0.3301 | 0.3298 | 0.33 | 926800.0 |
| 2003-05-28 11:50:00 | AAPL | Stock | 0.33 | 0.3304 | 0.33 | 0.3302 | 924000.0 |
| 2003-05-28 11:55:00 | AAPL | Stock | 0.3302 | 0.3304 | 0.3298 | 0.3298 | 1778784.0 |
| 2003-05-28 12:00:00 | AAPL | Stock | 0.3297 | 0.3298 | 0.3291 | 0.3291 | 2519384.0 |
| 2003-05-28 12:05:00 | AAPL | Stock | 0.3291 | 0.3291 | 0.3291 | 0.3291 | 433104.0 |
| 2003-05-28 12:10:00 | AAPL | Stock | 0.3291 | 0.3293 | 0.3291 | 0.3291 | 1764000.0 |
| 2003-05-28 12:15:00 | AAPL | Stock | 0.3291 | 0.3293 | 0.3291 | 0.3291 | 1130640.0 |
| 2003-05-28 12:20:00 | AAPL | Stock | 0.3291 | 0.3293 | 0.3285 | 0.3286 | 2150400.0 |
| 2003-05-28 12:25:00 | AAPL | Stock | 0.3286 | 0.3289 | 0.3284 | 0.3288 | 1788640.0 |
| 2003-05-28 12:30:00 | AAPL | Stock | 0.3287 | 0.3288 | 0.3277 | 0.3277 | 3083136.0 |
| 2003-05-28 12:35:00 | AAPL | Stock | 0.328 | 0.3284 | 0.3277 | 0.3282 | 1065568.0 |
| 2003-05-28 12:40:00 | AAPL | Stock | 0.3281 | 0.3286 | 0.328 | 0.3284 | 1512112.0 |
| 2003-05-28 12:45:00 | AAPL | Stock | 0.3284 | 0.3284 | 0.3273 | 0.3277 | 1293600.0 |
> showing 50 of 151,674 rows — these rows as CSV