PREVIEW / stock_5min / 2001-06-14
file: by_date/stock_5min/2001/2001-06-14.parquet size: 1.5 MB rows: 103,520 symbols: 1,303
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-06-14 08:00:00 | AAPL | Stock | 0.3654 | 0.3654 | 0.3654 | 0.3654 | 2055200.0 |
| 2001-06-14 08:30:00 | AAPL | Stock | 0.3673 | 0.3673 | 0.3673 | 0.3673 | 33600.0 |
| 2001-06-14 08:40:00 | AAPL | Stock | 0.3655 | 0.3655 | 0.3655 | 0.3655 | 106400.0 |
| 2001-06-14 08:55:00 | AAPL | Stock | 0.3625 | 0.3625 | 0.3625 | 0.3625 | 5600.0 |
| 2001-06-14 09:00:00 | AAPL | Stock | 0.3618 | 0.3625 | 0.3618 | 0.3625 | 72800.0 |
| 2001-06-14 09:10:00 | AAPL | Stock | 0.3616 | 0.3616 | 0.3607 | 0.3616 | 1209600.0 |
| 2001-06-14 09:20:00 | AAPL | Stock | 0.36 | 0.36 | 0.3589 | 0.3589 | 140000.0 |
| 2001-06-14 09:25:00 | AAPL | Stock | 0.3582 | 0.3588 | 0.3579 | 0.3579 | 896000.0 |
| 2001-06-14 09:30:00 | AAPL | Stock | 0.3579 | 0.3595 | 0.3571 | 0.3577 | 12846400.0 |
| 2001-06-14 09:35:00 | AAPL | Stock | 0.3579 | 0.3591 | 0.3577 | 0.3579 | 19068000.0 |
| 2001-06-14 09:40:00 | AAPL | Stock | 0.3584 | 0.3584 | 0.353 | 0.3559 | 10662400.0 |
| 2001-06-14 09:45:00 | AAPL | Stock | 0.355 | 0.3571 | 0.355 | 0.3555 | 10690400.0 |
| 2001-06-14 09:50:00 | AAPL | Stock | 0.3554 | 0.358 | 0.3552 | 0.3577 | 8108800.0 |
| 2001-06-14 09:55:00 | AAPL | Stock | 0.3577 | 0.36 | 0.3571 | 0.3595 | 8836800.0 |
| 2001-06-14 10:00:00 | AAPL | Stock | 0.3596 | 0.3596 | 0.3575 | 0.3584 | 3035200.0 |
| 2001-06-14 10:05:00 | AAPL | Stock | 0.3588 | 0.3589 | 0.3573 | 0.358 | 6232800.0 |
| 2001-06-14 10:10:00 | AAPL | Stock | 0.358 | 0.3595 | 0.3579 | 0.3588 | 10012800.0 |
| 2001-06-14 10:15:00 | AAPL | Stock | 0.3588 | 0.3625 | 0.3586 | 0.3596 | 27053600.0 |
| 2001-06-14 10:20:00 | AAPL | Stock | 0.3602 | 0.3625 | 0.3602 | 0.3614 | 4989600.0 |
| 2001-06-14 10:25:00 | AAPL | Stock | 0.3614 | 0.3616 | 0.3589 | 0.3605 | 1612800.0 |
| 2001-06-14 10:30:00 | AAPL | Stock | 0.36 | 0.3602 | 0.3573 | 0.3575 | 2833600.0 |
| 2001-06-14 10:35:00 | AAPL | Stock | 0.3575 | 0.3589 | 0.3568 | 0.3575 | 4698400.0 |
| 2001-06-14 10:40:00 | AAPL | Stock | 0.3577 | 0.358 | 0.3555 | 0.3557 | 2553600.0 |
| 2001-06-14 10:45:00 | AAPL | Stock | 0.3559 | 0.3596 | 0.3557 | 0.3589 | 3987200.0 |
| 2001-06-14 10:50:00 | AAPL | Stock | 0.3591 | 0.3605 | 0.3584 | 0.3604 | 4110400.0 |
| 2001-06-14 10:55:00 | AAPL | Stock | 0.3605 | 0.3605 | 0.3593 | 0.3596 | 817600.0 |
| 2001-06-14 11:00:00 | AAPL | Stock | 0.3598 | 0.3604 | 0.358 | 0.358 | 2044000.0 |
| 2001-06-14 11:05:00 | AAPL | Stock | 0.3586 | 0.3593 | 0.358 | 0.3582 | 2900800.0 |
| 2001-06-14 11:10:00 | AAPL | Stock | 0.3582 | 0.3586 | 0.3564 | 0.3571 | 2598400.0 |
| 2001-06-14 11:15:00 | AAPL | Stock | 0.3573 | 0.3584 | 0.3564 | 0.3579 | 1747200.0 |
| 2001-06-14 11:20:00 | AAPL | Stock | 0.3584 | 0.3598 | 0.3577 | 0.3591 | 2486400.0 |
| 2001-06-14 11:25:00 | AAPL | Stock | 0.3584 | 0.3596 | 0.358 | 0.3589 | 1506400.0 |
| 2001-06-14 11:30:00 | AAPL | Stock | 0.3589 | 0.3589 | 0.358 | 0.3584 | 694400.0 |
| 2001-06-14 11:35:00 | AAPL | Stock | 0.3588 | 0.3589 | 0.3586 | 0.3586 | 464800.0 |
| 2001-06-14 11:40:00 | AAPL | Stock | 0.3582 | 0.3607 | 0.358 | 0.3605 | 918400.0 |
| 2001-06-14 11:45:00 | AAPL | Stock | 0.3604 | 0.3607 | 0.36 | 0.3605 | 985600.0 |
| 2001-06-14 11:50:00 | AAPL | Stock | 0.3602 | 0.3611 | 0.3598 | 0.3598 | 4446400.0 |
| 2001-06-14 11:55:00 | AAPL | Stock | 0.3604 | 0.3632 | 0.3604 | 0.3632 | 4379200.0 |
| 2001-06-14 12:00:00 | AAPL | Stock | 0.363 | 0.3652 | 0.3625 | 0.3625 | 3085600.0 |
| 2001-06-14 12:05:00 | AAPL | Stock | 0.3625 | 0.3627 | 0.3614 | 0.3614 | 834400.0 |
| 2001-06-14 12:10:00 | AAPL | Stock | 0.3614 | 0.3625 | 0.3609 | 0.3614 | 1579200.0 |
| 2001-06-14 12:15:00 | AAPL | Stock | 0.3614 | 0.3616 | 0.3598 | 0.3598 | 1052800.0 |
| 2001-06-14 12:20:00 | AAPL | Stock | 0.36 | 0.3611 | 0.3593 | 0.3598 | 767200.0 |
| 2001-06-14 12:25:00 | AAPL | Stock | 0.3598 | 0.3611 | 0.3595 | 0.3602 | 509600.0 |
| 2001-06-14 12:30:00 | AAPL | Stock | 0.3602 | 0.362 | 0.3602 | 0.3614 | 3746400.0 |
| 2001-06-14 12:35:00 | AAPL | Stock | 0.3616 | 0.3618 | 0.3605 | 0.3616 | 392000.0 |
| 2001-06-14 12:40:00 | AAPL | Stock | 0.3613 | 0.3618 | 0.3607 | 0.3607 | 1064000.0 |
| 2001-06-14 12:45:00 | AAPL | Stock | 0.3618 | 0.3618 | 0.3613 | 0.3614 | 453600.0 |
| 2001-06-14 12:50:00 | AAPL | Stock | 0.3613 | 0.3618 | 0.3607 | 0.3614 | 1887200.0 |
| 2001-06-14 12:55:00 | AAPL | Stock | 0.3609 | 0.362 | 0.3609 | 0.3609 | 1590400.0 |
> showing 50 of 103,520 rows — these rows as CSV