PREVIEW / stock_5min / 2001-04-04
file: by_date/stock_5min/2001/2001-04-04.parquet size: 1.5 MB rows: 104,206 symbols: 1,285
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-04-04 08:00:00 | AAPL | Stock | 0.3607 | 0.3613 | 0.3571 | 0.3613 | 392000.0 |
| 2001-04-04 08:15:00 | AAPL | Stock | 0.3607 | 0.3616 | 0.3607 | 0.3611 | 173600.0 |
| 2001-04-04 08:20:00 | AAPL | Stock | 0.3611 | 0.3623 | 0.3611 | 0.3623 | 380800.0 |
| 2001-04-04 08:30:00 | AAPL | Stock | 0.3613 | 0.3613 | 0.3613 | 0.3613 | 11200.0 |
| 2001-04-04 08:35:00 | AAPL | Stock | 0.3618 | 0.3618 | 0.3611 | 0.3611 | 156800.0 |
| 2001-04-04 08:40:00 | AAPL | Stock | 0.3611 | 0.3611 | 0.3611 | 0.3611 | 78400.0 |
| 2001-04-04 08:45:00 | AAPL | Stock | 0.3598 | 0.3598 | 0.3598 | 0.3598 | 22400.0 |
| 2001-04-04 08:50:00 | AAPL | Stock | 0.3598 | 0.3598 | 0.3598 | 0.3598 | 84000.0 |
| 2001-04-04 08:55:00 | AAPL | Stock | 0.3607 | 0.3607 | 0.3598 | 0.3598 | 100800.0 |
| 2001-04-04 09:05:00 | AAPL | Stock | 0.3593 | 0.3593 | 0.3582 | 0.3589 | 145600.0 |
| 2001-04-04 09:15:00 | AAPL | Stock | 0.3589 | 0.3589 | 0.3589 | 0.3589 | 56000.0 |
| 2001-04-04 09:20:00 | AAPL | Stock | 0.3591 | 0.3591 | 0.3571 | 0.3571 | 117600.0 |
| 2001-04-04 09:25:00 | AAPL | Stock | 0.3579 | 0.3579 | 0.3527 | 0.3529 | 408800.0 |
| 2001-04-04 09:30:00 | AAPL | Stock | 0.3529 | 0.3536 | 0.3518 | 0.3532 | 12773600.0 |
| 2001-04-04 09:35:00 | AAPL | Stock | 0.353 | 0.3616 | 0.3518 | 0.3589 | 16027200.0 |
| 2001-04-04 09:40:00 | AAPL | Stock | 0.3589 | 0.3607 | 0.3543 | 0.3557 | 10348800.0 |
| 2001-04-04 09:45:00 | AAPL | Stock | 0.3559 | 0.3571 | 0.3543 | 0.3554 | 10147200.0 |
| 2001-04-04 09:50:00 | AAPL | Stock | 0.3554 | 0.3568 | 0.3518 | 0.3518 | 7392000.0 |
| 2001-04-04 09:55:00 | AAPL | Stock | 0.352 | 0.352 | 0.3461 | 0.3463 | 11463200.0 |
| 2001-04-04 10:00:00 | AAPL | Stock | 0.3461 | 0.347 | 0.3434 | 0.3439 | 9542400.0 |
| 2001-04-04 10:05:00 | AAPL | Stock | 0.3439 | 0.3445 | 0.342 | 0.343 | 12012000.0 |
| 2001-04-04 10:10:00 | AAPL | Stock | 0.3429 | 0.3439 | 0.3418 | 0.3439 | 13098400.0 |
| 2001-04-04 10:15:00 | AAPL | Stock | 0.3439 | 0.3455 | 0.3425 | 0.3443 | 19667200.0 |
| 2001-04-04 10:20:00 | AAPL | Stock | 0.3443 | 0.3445 | 0.3375 | 0.3375 | 19297600.0 |
| 2001-04-04 10:25:00 | AAPL | Stock | 0.338 | 0.3391 | 0.3355 | 0.3373 | 13311200.0 |
| 2001-04-04 10:30:00 | AAPL | Stock | 0.3373 | 0.3418 | 0.3366 | 0.3413 | 14588000.0 |
| 2001-04-04 10:35:00 | AAPL | Stock | 0.3413 | 0.3421 | 0.3384 | 0.3407 | 9542400.0 |
| 2001-04-04 10:40:00 | AAPL | Stock | 0.3404 | 0.3429 | 0.3398 | 0.3429 | 14207200.0 |
| 2001-04-04 10:45:00 | AAPL | Stock | 0.3429 | 0.3445 | 0.3411 | 0.3445 | 8629600.0 |
| 2001-04-04 10:50:00 | AAPL | Stock | 0.3446 | 0.3488 | 0.3429 | 0.348 | 9760800.0 |
| 2001-04-04 10:55:00 | AAPL | Stock | 0.3477 | 0.3482 | 0.3448 | 0.3452 | 7588000.0 |
| 2001-04-04 11:00:00 | AAPL | Stock | 0.3448 | 0.3505 | 0.3446 | 0.3498 | 6585600.0 |
| 2001-04-04 11:05:00 | AAPL | Stock | 0.35 | 0.3518 | 0.3482 | 0.3504 | 5432000.0 |
| 2001-04-04 11:10:00 | AAPL | Stock | 0.3507 | 0.3571 | 0.3504 | 0.3571 | 13182400.0 |
| 2001-04-04 11:15:00 | AAPL | Stock | 0.3577 | 0.3593 | 0.3559 | 0.3593 | 8842400.0 |
| 2001-04-04 11:20:00 | AAPL | Stock | 0.3589 | 0.3616 | 0.358 | 0.3593 | 14123200.0 |
| 2001-04-04 11:25:00 | AAPL | Stock | 0.3602 | 0.3616 | 0.3573 | 0.358 | 9413600.0 |
| 2001-04-04 11:30:00 | AAPL | Stock | 0.3579 | 0.3589 | 0.3561 | 0.357 | 8708000.0 |
| 2001-04-04 11:35:00 | AAPL | Stock | 0.357 | 0.3595 | 0.3561 | 0.3582 | 9996000.0 |
| 2001-04-04 11:40:00 | AAPL | Stock | 0.3561 | 0.3571 | 0.352 | 0.352 | 9699200.0 |
| 2001-04-04 11:45:00 | AAPL | Stock | 0.352 | 0.3534 | 0.3516 | 0.3518 | 14000000.0 |
| 2001-04-04 11:50:00 | AAPL | Stock | 0.3518 | 0.3529 | 0.3509 | 0.3514 | 8932000.0 |
| 2001-04-04 11:55:00 | AAPL | Stock | 0.3514 | 0.3536 | 0.3514 | 0.3536 | 5118400.0 |
| 2001-04-04 12:00:00 | AAPL | Stock | 0.3534 | 0.355 | 0.3527 | 0.3543 | 2839200.0 |
| 2001-04-04 12:05:00 | AAPL | Stock | 0.3545 | 0.355 | 0.3532 | 0.3536 | 2900800.0 |
| 2001-04-04 12:10:00 | AAPL | Stock | 0.3536 | 0.3536 | 0.3527 | 0.3527 | 2335200.0 |
| 2001-04-04 12:15:00 | AAPL | Stock | 0.353 | 0.3534 | 0.3509 | 0.3513 | 2055200.0 |
| 2001-04-04 12:20:00 | AAPL | Stock | 0.3513 | 0.3513 | 0.35 | 0.3507 | 4552800.0 |
| 2001-04-04 12:25:00 | AAPL | Stock | 0.3507 | 0.3509 | 0.3502 | 0.3507 | 4048800.0 |
| 2001-04-04 12:30:00 | AAPL | Stock | 0.3504 | 0.3516 | 0.3498 | 0.3498 | 4054400.0 |
> showing 50 of 104,206 rows — these rows as CSV