PREVIEW / stock_5min / 2003-07-22
file: by_date/stock_5min/2003/2003-07-22.parquet size: 2.1 MB rows: 148,533 symbols: 1,594
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-22 08:20:00 | AAPL | Stock | 0.3696 | 0.3696 | 0.3696 | 0.3696 | 11200.0 |
| 2003-07-22 08:55:00 | AAPL | Stock | 0.3705 | 0.3705 | 0.3705 | 0.3705 | 16800.0 |
| 2003-07-22 09:05:00 | AAPL | Stock | 0.3714 | 0.3714 | 0.3698 | 0.3698 | 45920.0 |
| 2003-07-22 09:10:00 | AAPL | Stock | 0.3698 | 0.3698 | 0.3698 | 0.3698 | 72800.0 |
| 2003-07-22 09:20:00 | AAPL | Stock | 0.37 | 0.37 | 0.37 | 0.37 | 11200.0 |
| 2003-07-22 09:25:00 | AAPL | Stock | 0.37 | 0.3718 | 0.37 | 0.3716 | 327768.0 |
| 2003-07-22 09:30:00 | AAPL | Stock | 0.3727 | 0.3732 | 0.3697 | 0.3718 | 7006216.0 |
| 2003-07-22 09:35:00 | AAPL | Stock | 0.3716 | 0.3721 | 0.367 | 0.367 | 7252000.0 |
| 2003-07-22 09:40:00 | AAPL | Stock | 0.367 | 0.3691 | 0.3668 | 0.3673 | 1736000.0 |
| 2003-07-22 09:45:00 | AAPL | Stock | 0.3671 | 0.3689 | 0.3668 | 0.3688 | 1273496.0 |
| 2003-07-22 09:50:00 | AAPL | Stock | 0.3689 | 0.3709 | 0.3682 | 0.3682 | 2486792.0 |
| 2003-07-22 09:55:00 | AAPL | Stock | 0.3684 | 0.3738 | 0.3682 | 0.3732 | 3211768.0 |
| 2003-07-22 10:00:00 | AAPL | Stock | 0.373 | 0.3732 | 0.3714 | 0.3716 | 3119816.0 |
| 2003-07-22 10:05:00 | AAPL | Stock | 0.372 | 0.3727 | 0.3719 | 0.3725 | 1789648.0 |
| 2003-07-22 10:10:00 | AAPL | Stock | 0.3725 | 0.3727 | 0.3721 | 0.3721 | 2914128.0 |
| 2003-07-22 10:15:00 | AAPL | Stock | 0.3721 | 0.3723 | 0.3718 | 0.372 | 1883504.0 |
| 2003-07-22 10:20:00 | AAPL | Stock | 0.372 | 0.3721 | 0.3713 | 0.372 | 5952800.0 |
| 2003-07-22 10:25:00 | AAPL | Stock | 0.372 | 0.3723 | 0.372 | 0.3723 | 3138576.0 |
| 2003-07-22 10:30:00 | AAPL | Stock | 0.372 | 0.3725 | 0.3716 | 0.3721 | 2380000.0 |
| 2003-07-22 10:35:00 | AAPL | Stock | 0.3723 | 0.3725 | 0.3718 | 0.3723 | 2757776.0 |
| 2003-07-22 10:40:00 | AAPL | Stock | 0.3721 | 0.3725 | 0.3713 | 0.3713 | 2566872.0 |
| 2003-07-22 10:45:00 | AAPL | Stock | 0.3713 | 0.3714 | 0.3695 | 0.3696 | 2940000.0 |
| 2003-07-22 10:50:00 | AAPL | Stock | 0.3696 | 0.3704 | 0.3694 | 0.3696 | 1827840.0 |
| 2003-07-22 10:55:00 | AAPL | Stock | 0.3696 | 0.3696 | 0.368 | 0.3682 | 2380000.0 |
| 2003-07-22 11:00:00 | AAPL | Stock | 0.3684 | 0.3705 | 0.3679 | 0.3682 | 6522880.0 |
| 2003-07-22 11:05:00 | AAPL | Stock | 0.368 | 0.3689 | 0.3673 | 0.3687 | 4754120.0 |
| 2003-07-22 11:10:00 | AAPL | Stock | 0.3687 | 0.3693 | 0.3687 | 0.3688 | 2105600.0 |
| 2003-07-22 11:15:00 | AAPL | Stock | 0.3688 | 0.3688 | 0.3679 | 0.3684 | 1422400.0 |
| 2003-07-22 11:20:00 | AAPL | Stock | 0.3684 | 0.3684 | 0.3679 | 0.3682 | 629720.0 |
| 2003-07-22 11:25:00 | AAPL | Stock | 0.3682 | 0.3689 | 0.368 | 0.3689 | 3980480.0 |
| 2003-07-22 11:30:00 | AAPL | Stock | 0.3688 | 0.3702 | 0.3688 | 0.3696 | 3612000.0 |
| 2003-07-22 11:35:00 | AAPL | Stock | 0.3696 | 0.3709 | 0.3693 | 0.3693 | 3579800.0 |
| 2003-07-22 11:40:00 | AAPL | Stock | 0.3693 | 0.3696 | 0.3689 | 0.3696 | 560224.0 |
| 2003-07-22 11:45:00 | AAPL | Stock | 0.3695 | 0.37 | 0.3695 | 0.37 | 1024576.0 |
| 2003-07-22 11:50:00 | AAPL | Stock | 0.3698 | 0.37 | 0.3696 | 0.37 | 515200.0 |
| 2003-07-22 11:55:00 | AAPL | Stock | 0.37 | 0.3716 | 0.37 | 0.3709 | 6531392.0 |
| 2003-07-22 12:00:00 | AAPL | Stock | 0.3709 | 0.3718 | 0.3704 | 0.3718 | 3082800.0 |
| 2003-07-22 12:05:00 | AAPL | Stock | 0.3718 | 0.3718 | 0.3707 | 0.3714 | 2682400.0 |
| 2003-07-22 12:10:00 | AAPL | Stock | 0.3714 | 0.3718 | 0.3707 | 0.3714 | 2036048.0 |
| 2003-07-22 12:15:00 | AAPL | Stock | 0.3714 | 0.3714 | 0.3698 | 0.3709 | 854000.0 |
| 2003-07-22 12:20:00 | AAPL | Stock | 0.3709 | 0.3716 | 0.3698 | 0.3711 | 2525152.0 |
| 2003-07-22 12:25:00 | AAPL | Stock | 0.3707 | 0.3711 | 0.3702 | 0.3702 | 940800.0 |
| 2003-07-22 12:30:00 | AAPL | Stock | 0.3704 | 0.3707 | 0.3702 | 0.3707 | 837872.0 |
| 2003-07-22 12:35:00 | AAPL | Stock | 0.3705 | 0.3707 | 0.3698 | 0.37 | 624736.0 |
| 2003-07-22 12:40:00 | AAPL | Stock | 0.37 | 0.3707 | 0.3698 | 0.3707 | 560000.0 |
| 2003-07-22 12:45:00 | AAPL | Stock | 0.3705 | 0.3711 | 0.3704 | 0.3707 | 1875048.0 |
| 2003-07-22 12:50:00 | AAPL | Stock | 0.3705 | 0.3705 | 0.37 | 0.37 | 308000.0 |
| 2003-07-22 12:55:00 | AAPL | Stock | 0.3702 | 0.3705 | 0.3695 | 0.3696 | 1864800.0 |
| 2003-07-22 13:00:00 | AAPL | Stock | 0.3696 | 0.3696 | 0.3689 | 0.3691 | 1170400.0 |
| 2003-07-22 13:05:00 | AAPL | Stock | 0.3693 | 0.3705 | 0.3693 | 0.3697 | 1165080.0 |
> showing 50 of 148,533 rows — these rows as CSV