PREVIEW / stock_5min / 2003-12-24
file: by_date/stock_5min/2003/2003-12-24.parquet size: 1.3 MB rows: 84,288 symbols: 1,675
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-12-24 08:00:00 | AAPL | Stock | 0.3542 | 0.3542 | 0.3542 | 0.3542 | 1086400.0 |
| 2003-12-24 08:45:00 | AAPL | Stock | 0.3538 | 0.3538 | 0.3538 | 0.3538 | 1000048.0 |
| 2003-12-24 09:00:00 | AAPL | Stock | 0.3538 | 0.3538 | 0.3538 | 0.3538 | 50400.0 |
| 2003-12-24 09:05:00 | AAPL | Stock | 0.352 | 0.352 | 0.352 | 0.352 | 11200.0 |
| 2003-12-24 09:15:00 | AAPL | Stock | 0.3538 | 0.3538 | 0.3538 | 0.3538 | 33600.0 |
| 2003-12-24 09:25:00 | AAPL | Stock | 0.3538 | 0.3538 | 0.3521 | 0.3521 | 100800.0 |
| 2003-12-24 09:30:00 | AAPL | Stock | 0.3521 | 0.3523 | 0.3509 | 0.3518 | 3892560.0 |
| 2003-12-24 09:35:00 | AAPL | Stock | 0.352 | 0.3545 | 0.352 | 0.3534 | 2438408.0 |
| 2003-12-24 09:40:00 | AAPL | Stock | 0.3534 | 0.3543 | 0.3527 | 0.3543 | 1176224.0 |
| 2003-12-24 09:45:00 | AAPL | Stock | 0.3543 | 0.355 | 0.3541 | 0.3548 | 1302840.0 |
| 2003-12-24 09:50:00 | AAPL | Stock | 0.3549 | 0.3559 | 0.3545 | 0.3559 | 2611560.0 |
| 2003-12-24 09:55:00 | AAPL | Stock | 0.3557 | 0.3568 | 0.3557 | 0.3564 | 2212000.0 |
| 2003-12-24 10:00:00 | AAPL | Stock | 0.3559 | 0.3566 | 0.3541 | 0.3564 | 1507408.0 |
| 2003-12-24 10:05:00 | AAPL | Stock | 0.3563 | 0.3564 | 0.3557 | 0.3559 | 2460248.0 |
| 2003-12-24 10:10:00 | AAPL | Stock | 0.3561 | 0.3566 | 0.3559 | 0.3563 | 2660000.0 |
| 2003-12-24 10:15:00 | AAPL | Stock | 0.3564 | 0.3566 | 0.3563 | 0.3564 | 2190384.0 |
| 2003-12-24 10:20:00 | AAPL | Stock | 0.3564 | 0.3586 | 0.3564 | 0.3577 | 9437176.0 |
| 2003-12-24 10:25:00 | AAPL | Stock | 0.3578 | 0.3593 | 0.3577 | 0.3588 | 4471600.0 |
| 2003-12-24 10:30:00 | AAPL | Stock | 0.3588 | 0.3589 | 0.358 | 0.358 | 4317488.0 |
| 2003-12-24 10:35:00 | AAPL | Stock | 0.358 | 0.3586 | 0.3579 | 0.3579 | 1674456.0 |
| 2003-12-24 10:40:00 | AAPL | Stock | 0.3579 | 0.358 | 0.3571 | 0.3575 | 1020096.0 |
| 2003-12-24 10:45:00 | AAPL | Stock | 0.3575 | 0.3598 | 0.3575 | 0.3596 | 6734112.0 |
| 2003-12-24 10:50:00 | AAPL | Stock | 0.3595 | 0.3596 | 0.3588 | 0.3589 | 1875440.0 |
| 2003-12-24 10:55:00 | AAPL | Stock | 0.3591 | 0.3604 | 0.3591 | 0.36 | 2591568.0 |
| 2003-12-24 11:00:00 | AAPL | Stock | 0.36 | 0.3611 | 0.36 | 0.3609 | 1608712.0 |
| 2003-12-24 11:05:00 | AAPL | Stock | 0.3609 | 0.3621 | 0.3607 | 0.362 | 9541728.0 |
| 2003-12-24 11:10:00 | AAPL | Stock | 0.3618 | 0.3632 | 0.3618 | 0.3632 | 5707072.0 |
| 2003-12-24 11:15:00 | AAPL | Stock | 0.363 | 0.3638 | 0.363 | 0.3634 | 6469400.0 |
| 2003-12-24 11:20:00 | AAPL | Stock | 0.3632 | 0.3636 | 0.363 | 0.3632 | 2338000.0 |
| 2003-12-24 11:25:00 | AAPL | Stock | 0.363 | 0.3639 | 0.363 | 0.3638 | 5549656.0 |
| 2003-12-24 11:30:00 | AAPL | Stock | 0.3638 | 0.3639 | 0.3634 | 0.3636 | 2519440.0 |
| 2003-12-24 11:35:00 | AAPL | Stock | 0.3636 | 0.3646 | 0.3634 | 0.3645 | 5600000.0 |
| 2003-12-24 11:40:00 | AAPL | Stock | 0.3645 | 0.3648 | 0.3643 | 0.3643 | 1802864.0 |
| 2003-12-24 11:45:00 | AAPL | Stock | 0.3646 | 0.3654 | 0.3643 | 0.3652 | 6710704.0 |
| 2003-12-24 11:50:00 | AAPL | Stock | 0.3652 | 0.3655 | 0.365 | 0.3652 | 5619600.0 |
| 2003-12-24 11:55:00 | AAPL | Stock | 0.3654 | 0.3655 | 0.3652 | 0.3654 | 4010552.0 |
| 2003-12-24 12:00:00 | AAPL | Stock | 0.3654 | 0.3655 | 0.3652 | 0.3655 | 1753528.0 |
| 2003-12-24 12:05:00 | AAPL | Stock | 0.3655 | 0.3663 | 0.3652 | 0.3659 | 6027448.0 |
| 2003-12-24 12:10:00 | AAPL | Stock | 0.3659 | 0.3677 | 0.3655 | 0.3677 | 17077984.0 |
| 2003-12-24 12:15:00 | AAPL | Stock | 0.3677 | 0.3677 | 0.367 | 0.367 | 5807984.0 |
| 2003-12-24 12:20:00 | AAPL | Stock | 0.367 | 0.3671 | 0.3663 | 0.3663 | 4065096.0 |
| 2003-12-24 12:25:00 | AAPL | Stock | 0.3663 | 0.3664 | 0.3657 | 0.3657 | 6089664.0 |
| 2003-12-24 12:30:00 | AAPL | Stock | 0.3657 | 0.3659 | 0.3652 | 0.3654 | 2378656.0 |
| 2003-12-24 12:35:00 | AAPL | Stock | 0.3654 | 0.3654 | 0.3652 | 0.3652 | 2870056.0 |
| 2003-12-24 12:40:00 | AAPL | Stock | 0.3652 | 0.3654 | 0.3643 | 0.3654 | 4921560.0 |
| 2003-12-24 12:45:00 | AAPL | Stock | 0.3654 | 0.3654 | 0.3643 | 0.3646 | 3703168.0 |
| 2003-12-24 12:50:00 | AAPL | Stock | 0.3646 | 0.365 | 0.3643 | 0.3643 | 2627240.0 |
| 2003-12-24 12:55:00 | AAPL | Stock | 0.3644 | 0.3646 | 0.3638 | 0.3643 | 4090240.0 |
| 2003-12-24 13:00:00 | AAPL | Stock | 0.3646 | 0.3655 | 0.3643 | 0.3645 | 278152.0 |
| 2003-12-24 08:00:00 | MSFT | Stock | 27.1 | 27.17 | 27.1 | 27.17 | 1250.0 |
> showing 50 of 84,288 rows — these rows as CSV