PREVIEW / stock_5min / 2003-07-18
file: by_date/stock_5min/2003/2003-07-18.parquet size: 2.1 MB rows: 146,384 symbols: 1,585
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-07-18 08:00:00 | AAPL | Stock | 0.3736 | 0.375 | 0.3736 | 0.375 | 386400.0 |
| 2003-07-18 09:05:00 | AAPL | Stock | 0.3734 | 0.3734 | 0.3734 | 0.3734 | 28000.0 |
| 2003-07-18 09:10:00 | AAPL | Stock | 0.3732 | 0.3734 | 0.3732 | 0.3734 | 84000.0 |
| 2003-07-18 09:15:00 | AAPL | Stock | 0.3732 | 0.375 | 0.3732 | 0.375 | 25200.0 |
| 2003-07-18 09:20:00 | AAPL | Stock | 0.3732 | 0.3746 | 0.3732 | 0.3732 | 145600.0 |
| 2003-07-18 09:25:00 | AAPL | Stock | 0.3714 | 0.3723 | 0.37 | 0.3723 | 1792000.0 |
| 2003-07-18 09:30:00 | AAPL | Stock | 0.3732 | 0.3739 | 0.3688 | 0.3691 | 16084376.0 |
| 2003-07-18 09:35:00 | AAPL | Stock | 0.3689 | 0.3705 | 0.3679 | 0.3702 | 7061600.0 |
| 2003-07-18 09:40:00 | AAPL | Stock | 0.3702 | 0.3702 | 0.3686 | 0.3695 | 6120800.0 |
| 2003-07-18 09:45:00 | AAPL | Stock | 0.3695 | 0.3714 | 0.3682 | 0.3705 | 7204568.0 |
| 2003-07-18 09:50:00 | AAPL | Stock | 0.3707 | 0.3707 | 0.3686 | 0.3689 | 5562200.0 |
| 2003-07-18 09:55:00 | AAPL | Stock | 0.3691 | 0.3704 | 0.3686 | 0.3686 | 4824792.0 |
| 2003-07-18 10:00:00 | AAPL | Stock | 0.3686 | 0.3693 | 0.368 | 0.3686 | 4149600.0 |
| 2003-07-18 10:05:00 | AAPL | Stock | 0.3691 | 0.3691 | 0.367 | 0.367 | 5638864.0 |
| 2003-07-18 10:10:00 | AAPL | Stock | 0.367 | 0.3673 | 0.3661 | 0.3664 | 4670400.0 |
| 2003-07-18 10:15:00 | AAPL | Stock | 0.3664 | 0.3664 | 0.3645 | 0.3645 | 4708256.0 |
| 2003-07-18 10:20:00 | AAPL | Stock | 0.3646 | 0.3654 | 0.3643 | 0.3643 | 3239432.0 |
| 2003-07-18 10:25:00 | AAPL | Stock | 0.3646 | 0.3666 | 0.3645 | 0.3664 | 3326176.0 |
| 2003-07-18 10:30:00 | AAPL | Stock | 0.3661 | 0.3671 | 0.3655 | 0.3664 | 3014648.0 |
| 2003-07-18 10:35:00 | AAPL | Stock | 0.3664 | 0.3679 | 0.3663 | 0.3663 | 2927344.0 |
| 2003-07-18 10:40:00 | AAPL | Stock | 0.3663 | 0.3679 | 0.3654 | 0.3675 | 2964808.0 |
| 2003-07-18 10:45:00 | AAPL | Stock | 0.3673 | 0.3695 | 0.3666 | 0.3689 | 2388120.0 |
| 2003-07-18 10:50:00 | AAPL | Stock | 0.3688 | 0.3698 | 0.3688 | 0.3691 | 3397800.0 |
| 2003-07-18 10:55:00 | AAPL | Stock | 0.3691 | 0.3693 | 0.3682 | 0.3686 | 2607024.0 |
| 2003-07-18 11:00:00 | AAPL | Stock | 0.3689 | 0.3689 | 0.3671 | 0.3673 | 2075640.0 |
| 2003-07-18 11:05:00 | AAPL | Stock | 0.3673 | 0.3675 | 0.3666 | 0.367 | 1941352.0 |
| 2003-07-18 11:10:00 | AAPL | Stock | 0.367 | 0.3679 | 0.3668 | 0.3677 | 2620800.0 |
| 2003-07-18 11:15:00 | AAPL | Stock | 0.3677 | 0.3679 | 0.3661 | 0.3666 | 2541280.0 |
| 2003-07-18 11:20:00 | AAPL | Stock | 0.3668 | 0.3675 | 0.3665 | 0.3675 | 2940000.0 |
| 2003-07-18 11:25:00 | AAPL | Stock | 0.3673 | 0.368 | 0.3673 | 0.368 | 1372000.0 |
| 2003-07-18 11:30:00 | AAPL | Stock | 0.3684 | 0.3693 | 0.3682 | 0.3691 | 2234400.0 |
| 2003-07-18 11:35:00 | AAPL | Stock | 0.3691 | 0.3695 | 0.3689 | 0.3691 | 2584568.0 |
| 2003-07-18 11:40:00 | AAPL | Stock | 0.3693 | 0.3693 | 0.3684 | 0.3686 | 1674400.0 |
| 2003-07-18 11:45:00 | AAPL | Stock | 0.3686 | 0.3689 | 0.3682 | 0.3686 | 1394400.0 |
| 2003-07-18 11:50:00 | AAPL | Stock | 0.3686 | 0.3688 | 0.3679 | 0.3679 | 1523200.0 |
| 2003-07-18 11:55:00 | AAPL | Stock | 0.3677 | 0.368 | 0.367 | 0.3675 | 2722944.0 |
| 2003-07-18 12:00:00 | AAPL | Stock | 0.3675 | 0.3679 | 0.3671 | 0.3679 | 1556800.0 |
| 2003-07-18 12:05:00 | AAPL | Stock | 0.3679 | 0.3688 | 0.3678 | 0.368 | 1414336.0 |
| 2003-07-18 12:10:00 | AAPL | Stock | 0.3682 | 0.3688 | 0.368 | 0.3688 | 2385600.0 |
| 2003-07-18 12:15:00 | AAPL | Stock | 0.3686 | 0.3698 | 0.3686 | 0.3698 | 2251088.0 |
| 2003-07-18 12:20:00 | AAPL | Stock | 0.3698 | 0.3718 | 0.3698 | 0.3718 | 3911768.0 |
| 2003-07-18 12:25:00 | AAPL | Stock | 0.372 | 0.3727 | 0.3716 | 0.3725 | 3645600.0 |
| 2003-07-18 12:30:00 | AAPL | Stock | 0.3727 | 0.3727 | 0.3711 | 0.3713 | 1534400.0 |
| 2003-07-18 12:35:00 | AAPL | Stock | 0.3713 | 0.3721 | 0.3711 | 0.3713 | 2053520.0 |
| 2003-07-18 12:40:00 | AAPL | Stock | 0.3713 | 0.3714 | 0.3705 | 0.3707 | 1504328.0 |
| 2003-07-18 12:45:00 | AAPL | Stock | 0.3707 | 0.372 | 0.3707 | 0.3714 | 3892000.0 |
| 2003-07-18 12:50:00 | AAPL | Stock | 0.3711 | 0.3716 | 0.3711 | 0.3713 | 442400.0 |
| 2003-07-18 12:55:00 | AAPL | Stock | 0.3716 | 0.3727 | 0.3716 | 0.3727 | 2688000.0 |
| 2003-07-18 13:00:00 | AAPL | Stock | 0.3725 | 0.3727 | 0.372 | 0.3721 | 1792000.0 |
| 2003-07-18 13:05:00 | AAPL | Stock | 0.372 | 0.3721 | 0.3714 | 0.3714 | 1067360.0 |
> showing 50 of 146,384 rows — these rows as CSV