PREVIEW / stock_5min / 2001-08-01
file: by_date/stock_5min/2001/2001-08-01.parquet size: 1.5 MB rows: 109,669 symbols: 1,324
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-01 09:05:00 | AAPL | Stock | 0.3379 | 0.3379 | 0.3379 | 0.3379 | 56000.0 |
| 2001-08-01 09:10:00 | AAPL | Stock | 0.338 | 0.338 | 0.338 | 0.338 | 33600.0 |
| 2001-08-01 09:25:00 | AAPL | Stock | 0.3377 | 0.3393 | 0.3377 | 0.3393 | 358400.0 |
| 2001-08-01 09:30:00 | AAPL | Stock | 0.3395 | 0.3418 | 0.3393 | 0.3411 | 7095200.0 |
| 2001-08-01 09:35:00 | AAPL | Stock | 0.3413 | 0.3425 | 0.3411 | 0.3411 | 4093600.0 |
| 2001-08-01 09:40:00 | AAPL | Stock | 0.3411 | 0.3416 | 0.3405 | 0.3411 | 2032800.0 |
| 2001-08-01 09:45:00 | AAPL | Stock | 0.3413 | 0.3423 | 0.3411 | 0.3413 | 7924000.0 |
| 2001-08-01 09:50:00 | AAPL | Stock | 0.3423 | 0.3438 | 0.3416 | 0.3436 | 7957600.0 |
| 2001-08-01 09:55:00 | AAPL | Stock | 0.3438 | 0.3446 | 0.3432 | 0.3446 | 6955200.0 |
| 2001-08-01 10:00:00 | AAPL | Stock | 0.3446 | 0.3468 | 0.3421 | 0.3466 | 5622400.0 |
| 2001-08-01 10:05:00 | AAPL | Stock | 0.3468 | 0.3468 | 0.3452 | 0.3457 | 3623200.0 |
| 2001-08-01 10:10:00 | AAPL | Stock | 0.3459 | 0.3479 | 0.3455 | 0.3461 | 5381600.0 |
| 2001-08-01 10:15:00 | AAPL | Stock | 0.3461 | 0.347 | 0.3441 | 0.3441 | 4653600.0 |
| 2001-08-01 10:20:00 | AAPL | Stock | 0.3443 | 0.3461 | 0.3441 | 0.3461 | 2844800.0 |
| 2001-08-01 10:25:00 | AAPL | Stock | 0.3455 | 0.3464 | 0.3445 | 0.3459 | 10970400.0 |
| 2001-08-01 10:30:00 | AAPL | Stock | 0.3459 | 0.3461 | 0.3445 | 0.3446 | 1164800.0 |
| 2001-08-01 10:35:00 | AAPL | Stock | 0.3454 | 0.3473 | 0.3448 | 0.3473 | 1932000.0 |
| 2001-08-01 10:40:00 | AAPL | Stock | 0.3464 | 0.3473 | 0.3454 | 0.3455 | 2867200.0 |
| 2001-08-01 10:45:00 | AAPL | Stock | 0.3457 | 0.3461 | 0.3446 | 0.345 | 1019200.0 |
| 2001-08-01 10:50:00 | AAPL | Stock | 0.345 | 0.3468 | 0.3441 | 0.3457 | 2816800.0 |
| 2001-08-01 10:55:00 | AAPL | Stock | 0.3459 | 0.3466 | 0.3446 | 0.345 | 3701600.0 |
| 2001-08-01 11:00:00 | AAPL | Stock | 0.345 | 0.347 | 0.3448 | 0.347 | 1904000.0 |
| 2001-08-01 11:05:00 | AAPL | Stock | 0.3468 | 0.3488 | 0.3468 | 0.348 | 5532800.0 |
| 2001-08-01 11:10:00 | AAPL | Stock | 0.348 | 0.3491 | 0.3459 | 0.3464 | 8176000.0 |
| 2001-08-01 11:15:00 | AAPL | Stock | 0.3464 | 0.3466 | 0.345 | 0.3454 | 1422400.0 |
| 2001-08-01 11:20:00 | AAPL | Stock | 0.3457 | 0.3471 | 0.3452 | 0.3463 | 1982400.0 |
| 2001-08-01 11:25:00 | AAPL | Stock | 0.3463 | 0.347 | 0.3455 | 0.3461 | 1170400.0 |
| 2001-08-01 11:30:00 | AAPL | Stock | 0.3466 | 0.3482 | 0.3457 | 0.3464 | 1075200.0 |
| 2001-08-01 11:35:00 | AAPL | Stock | 0.3473 | 0.3473 | 0.3457 | 0.3457 | 1176000.0 |
| 2001-08-01 11:40:00 | AAPL | Stock | 0.3457 | 0.3473 | 0.3455 | 0.347 | 2732800.0 |
| 2001-08-01 11:45:00 | AAPL | Stock | 0.347 | 0.3473 | 0.3466 | 0.3473 | 386400.0 |
| 2001-08-01 11:50:00 | AAPL | Stock | 0.3473 | 0.3477 | 0.3466 | 0.3473 | 890400.0 |
| 2001-08-01 11:55:00 | AAPL | Stock | 0.3475 | 0.3477 | 0.3463 | 0.3464 | 3852800.0 |
| 2001-08-01 12:00:00 | AAPL | Stock | 0.3464 | 0.3473 | 0.3464 | 0.3471 | 2212000.0 |
| 2001-08-01 12:05:00 | AAPL | Stock | 0.3471 | 0.3471 | 0.3463 | 0.3466 | 560000.0 |
| 2001-08-01 12:10:00 | AAPL | Stock | 0.3466 | 0.3473 | 0.3466 | 0.3471 | 683200.0 |
| 2001-08-01 12:15:00 | AAPL | Stock | 0.3473 | 0.3491 | 0.3466 | 0.3491 | 7890400.0 |
| 2001-08-01 12:20:00 | AAPL | Stock | 0.3489 | 0.3495 | 0.348 | 0.3488 | 3785600.0 |
| 2001-08-01 12:25:00 | AAPL | Stock | 0.3488 | 0.3488 | 0.3482 | 0.3486 | 688800.0 |
| 2001-08-01 12:30:00 | AAPL | Stock | 0.3488 | 0.3496 | 0.348 | 0.3495 | 4228000.0 |
| 2001-08-01 12:35:00 | AAPL | Stock | 0.3495 | 0.35 | 0.3482 | 0.3493 | 3416000.0 |
| 2001-08-01 12:40:00 | AAPL | Stock | 0.3495 | 0.3527 | 0.3488 | 0.3523 | 6720000.0 |
| 2001-08-01 12:45:00 | AAPL | Stock | 0.3516 | 0.3529 | 0.3482 | 0.3521 | 5952800.0 |
| 2001-08-01 12:50:00 | AAPL | Stock | 0.3521 | 0.3532 | 0.3518 | 0.3521 | 3186400.0 |
| 2001-08-01 12:55:00 | AAPL | Stock | 0.3521 | 0.3527 | 0.352 | 0.3525 | 1176000.0 |
| 2001-08-01 13:00:00 | AAPL | Stock | 0.3521 | 0.3532 | 0.3509 | 0.3509 | 3080000.0 |
| 2001-08-01 13:05:00 | AAPL | Stock | 0.3511 | 0.3523 | 0.35 | 0.35 | 1355200.0 |
| 2001-08-01 13:10:00 | AAPL | Stock | 0.3502 | 0.3507 | 0.3489 | 0.3505 | 1792000.0 |
| 2001-08-01 13:15:00 | AAPL | Stock | 0.3507 | 0.3518 | 0.35 | 0.35 | 2290400.0 |
| 2001-08-01 13:20:00 | AAPL | Stock | 0.3505 | 0.3516 | 0.35 | 0.3514 | 464800.0 |
> showing 50 of 109,669 rows — these rows as CSV