PREVIEW / stock_5min / 2005-06-16
file: by_date/stock_5min/2005/2005-06-16.parquet size: 2.7 MB rows: 199,021 symbols: 1,990
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 |
|---|---|---|---|---|---|---|---|
| 2005-06-16 08:00:00 | AAPL | Stock | 1.3218 | 1.3296 | 1.3218 | 1.3296 | 14000.0 |
| 2005-06-16 08:05:00 | AAPL | Stock | 1.3293 | 1.3293 | 1.3293 | 1.3293 | 2800.0 |
| 2005-06-16 08:10:00 | AAPL | Stock | 1.3296 | 1.3296 | 1.3296 | 1.3296 | 5600.0 |
| 2005-06-16 08:15:00 | AAPL | Stock | 1.3286 | 1.3286 | 1.3286 | 1.3286 | 14000.0 |
| 2005-06-16 08:25:00 | AAPL | Stock | 1.325 | 1.3254 | 1.325 | 1.3254 | 16800.0 |
| 2005-06-16 08:30:00 | AAPL | Stock | 1.325 | 1.325 | 1.3193 | 1.3193 | 36400.0 |
| 2005-06-16 08:35:00 | AAPL | Stock | 1.3214 | 1.3286 | 1.3214 | 1.3214 | 109200.0 |
| 2005-06-16 08:40:00 | AAPL | Stock | 1.3218 | 1.3232 | 1.32 | 1.32 | 61600.0 |
| 2005-06-16 08:45:00 | AAPL | Stock | 1.3196 | 1.3214 | 1.3196 | 1.3207 | 45640.0 |
| 2005-06-16 08:50:00 | AAPL | Stock | 1.3196 | 1.3196 | 1.3196 | 1.3196 | 11200.0 |
| 2005-06-16 08:55:00 | AAPL | Stock | 1.3189 | 1.3189 | 1.3189 | 1.3189 | 42840.0 |
| 2005-06-16 09:05:00 | AAPL | Stock | 1.3171 | 1.3171 | 1.3171 | 1.3171 | 20440.0 |
| 2005-06-16 09:10:00 | AAPL | Stock | 1.3179 | 1.3179 | 1.3179 | 1.3179 | 16800.0 |
| 2005-06-16 09:20:00 | AAPL | Stock | 1.3204 | 1.3204 | 1.3204 | 1.3204 | 44800.0 |
| 2005-06-16 09:25:00 | AAPL | Stock | 1.3214 | 1.33 | 1.3214 | 1.3293 | 730492.0 |
| 2005-06-16 09:30:00 | AAPL | Stock | 1.3282 | 1.3292 | 1.315 | 1.3282 | 16208276.0 |
| 2005-06-16 09:35:00 | AAPL | Stock | 1.3286 | 1.3411 | 1.3239 | 1.3329 | 33572364.0 |
| 2005-06-16 09:40:00 | AAPL | Stock | 1.3325 | 1.3421 | 1.3311 | 1.3414 | 23673608.0 |
| 2005-06-16 09:45:00 | AAPL | Stock | 1.3411 | 1.3479 | 1.3354 | 1.3432 | 24320352.0 |
| 2005-06-16 09:50:00 | AAPL | Stock | 1.3436 | 1.3471 | 1.3411 | 1.3425 | 13973932.0 |
| 2005-06-16 09:55:00 | AAPL | Stock | 1.3425 | 1.3429 | 1.3382 | 1.3404 | 10359076.0 |
| 2005-06-16 10:00:00 | AAPL | Stock | 1.3404 | 1.3432 | 1.3389 | 1.3418 | 10534776.0 |
| 2005-06-16 10:05:00 | AAPL | Stock | 1.3421 | 1.3439 | 1.3407 | 1.3436 | 7149464.0 |
| 2005-06-16 10:10:00 | AAPL | Stock | 1.3436 | 1.3439 | 1.3414 | 1.3436 | 7568148.0 |
| 2005-06-16 10:15:00 | AAPL | Stock | 1.3432 | 1.35 | 1.3425 | 1.3464 | 11618964.0 |
| 2005-06-16 10:20:00 | AAPL | Stock | 1.3468 | 1.3554 | 1.3461 | 1.355 | 21988288.0 |
| 2005-06-16 10:25:00 | AAPL | Stock | 1.355 | 1.3554 | 1.35 | 1.3543 | 21019684.0 |
| 2005-06-16 10:30:00 | AAPL | Stock | 1.3539 | 1.3546 | 1.3511 | 1.3543 | 10713528.0 |
| 2005-06-16 10:35:00 | AAPL | Stock | 1.3543 | 1.3571 | 1.3511 | 1.3536 | 16772336.0 |
| 2005-06-16 10:40:00 | AAPL | Stock | 1.3536 | 1.36 | 1.3532 | 1.3589 | 15933764.0 |
| 2005-06-16 10:45:00 | AAPL | Stock | 1.3593 | 1.3593 | 1.3525 | 1.3536 | 9705556.0 |
| 2005-06-16 10:50:00 | AAPL | Stock | 1.3532 | 1.3539 | 1.3519 | 1.3532 | 6150368.0 |
| 2005-06-16 10:55:00 | AAPL | Stock | 1.3532 | 1.355 | 1.3525 | 1.3529 | 3302236.0 |
| 2005-06-16 11:00:00 | AAPL | Stock | 1.3529 | 1.3536 | 1.3518 | 1.3518 | 3567816.0 |
| 2005-06-16 11:05:00 | AAPL | Stock | 1.3521 | 1.3564 | 1.3521 | 1.3535 | 4096484.0 |
| 2005-06-16 11:10:00 | AAPL | Stock | 1.3532 | 1.355 | 1.3507 | 1.3507 | 6406036.0 |
| 2005-06-16 11:15:00 | AAPL | Stock | 1.3507 | 1.3525 | 1.3475 | 1.3486 | 7986496.0 |
| 2005-06-16 11:20:00 | AAPL | Stock | 1.3486 | 1.355 | 1.3482 | 1.3543 | 4912404.0 |
| 2005-06-16 11:25:00 | AAPL | Stock | 1.3543 | 1.3543 | 1.3514 | 1.3532 | 6055700.0 |
| 2005-06-16 11:30:00 | AAPL | Stock | 1.3529 | 1.3554 | 1.3514 | 1.3539 | 5393220.0 |
| 2005-06-16 11:35:00 | AAPL | Stock | 1.3543 | 1.355 | 1.3536 | 1.3536 | 2881872.0 |
| 2005-06-16 11:40:00 | AAPL | Stock | 1.3536 | 1.3539 | 1.3514 | 1.3521 | 2509304.0 |
| 2005-06-16 11:45:00 | AAPL | Stock | 1.3525 | 1.3557 | 1.3518 | 1.3529 | 3828972.0 |
| 2005-06-16 11:50:00 | AAPL | Stock | 1.3529 | 1.3536 | 1.3521 | 1.3529 | 1974728.0 |
| 2005-06-16 11:55:00 | AAPL | Stock | 1.3529 | 1.3554 | 1.3529 | 1.3545 | 5804708.0 |
| 2005-06-16 12:00:00 | AAPL | Stock | 1.3543 | 1.355 | 1.3518 | 1.3518 | 5030648.0 |
| 2005-06-16 12:05:00 | AAPL | Stock | 1.3518 | 1.3536 | 1.3482 | 1.3493 | 5702732.0 |
| 2005-06-16 12:10:00 | AAPL | Stock | 1.3493 | 1.3493 | 1.3421 | 1.3421 | 11265940.0 |
| 2005-06-16 12:15:00 | AAPL | Stock | 1.3425 | 1.3479 | 1.3421 | 1.3479 | 7705628.0 |
| 2005-06-16 12:20:00 | AAPL | Stock | 1.3475 | 1.3493 | 1.3454 | 1.3464 | 6330016.0 |
> showing 50 of 199,021 rows — these rows as CSV