PREVIEW / stock_5min / 2002-01-11
file: by_date/stock_5min/2002/2002-01-11.parquet size: 1.7 MB rows: 115,505 symbols: 1,353
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 |
|---|---|---|---|---|---|---|---|
| 2002-01-11 08:15:00 | AAPL | Stock | 0.3823 | 0.3823 | 0.3823 | 0.3823 | 5600.0 |
| 2002-01-11 08:45:00 | AAPL | Stock | 0.3807 | 0.3807 | 0.3793 | 0.3793 | 78400.0 |
| 2002-01-11 09:00:00 | AAPL | Stock | 0.3796 | 0.3796 | 0.3795 | 0.3795 | 33600.0 |
| 2002-01-11 09:15:00 | AAPL | Stock | 0.3805 | 0.3805 | 0.3805 | 0.3805 | 28000.0 |
| 2002-01-11 09:20:00 | AAPL | Stock | 0.3802 | 0.3802 | 0.3795 | 0.3795 | 235200.0 |
| 2002-01-11 09:25:00 | AAPL | Stock | 0.3811 | 0.3818 | 0.3811 | 0.3818 | 56000.0 |
| 2002-01-11 09:30:00 | AAPL | Stock | 0.382 | 0.3832 | 0.3814 | 0.3832 | 5292000.0 |
| 2002-01-11 09:35:00 | AAPL | Stock | 0.3834 | 0.3863 | 0.3821 | 0.3859 | 6507200.0 |
| 2002-01-11 09:40:00 | AAPL | Stock | 0.3863 | 0.387 | 0.3848 | 0.3855 | 5885600.0 |
| 2002-01-11 09:45:00 | AAPL | Stock | 0.385 | 0.3857 | 0.3818 | 0.3818 | 5398400.0 |
| 2002-01-11 09:50:00 | AAPL | Stock | 0.382 | 0.383 | 0.3818 | 0.383 | 3735200.0 |
| 2002-01-11 09:55:00 | AAPL | Stock | 0.3834 | 0.3846 | 0.383 | 0.3841 | 2940000.0 |
| 2002-01-11 10:00:00 | AAPL | Stock | 0.3841 | 0.3866 | 0.3839 | 0.3866 | 3197600.0 |
| 2002-01-11 10:05:00 | AAPL | Stock | 0.3866 | 0.3896 | 0.3864 | 0.3884 | 5913600.0 |
| 2002-01-11 10:10:00 | AAPL | Stock | 0.3884 | 0.3889 | 0.3866 | 0.3868 | 3175200.0 |
| 2002-01-11 10:15:00 | AAPL | Stock | 0.387 | 0.39 | 0.3866 | 0.3896 | 5124000.0 |
| 2002-01-11 10:20:00 | AAPL | Stock | 0.3895 | 0.3898 | 0.3852 | 0.3852 | 2783200.0 |
| 2002-01-11 10:25:00 | AAPL | Stock | 0.385 | 0.3866 | 0.385 | 0.3857 | 2200800.0 |
| 2002-01-11 10:30:00 | AAPL | Stock | 0.3854 | 0.3855 | 0.3825 | 0.3836 | 6809600.0 |
| 2002-01-11 10:35:00 | AAPL | Stock | 0.3836 | 0.3843 | 0.3813 | 0.3825 | 4614400.0 |
| 2002-01-11 10:40:00 | AAPL | Stock | 0.3828 | 0.3838 | 0.3813 | 0.3838 | 5342400.0 |
| 2002-01-11 10:45:00 | AAPL | Stock | 0.3838 | 0.3852 | 0.3837 | 0.3838 | 1467200.0 |
| 2002-01-11 10:50:00 | AAPL | Stock | 0.3838 | 0.3845 | 0.3814 | 0.3814 | 2794400.0 |
| 2002-01-11 10:55:00 | AAPL | Stock | 0.3814 | 0.3814 | 0.3793 | 0.3804 | 3539200.0 |
| 2002-01-11 11:00:00 | AAPL | Stock | 0.3805 | 0.3811 | 0.3798 | 0.3798 | 806400.0 |
| 2002-01-11 11:05:00 | AAPL | Stock | 0.38 | 0.3804 | 0.3777 | 0.3786 | 7632800.0 |
| 2002-01-11 11:10:00 | AAPL | Stock | 0.3786 | 0.3795 | 0.3759 | 0.3759 | 7907200.0 |
| 2002-01-11 11:15:00 | AAPL | Stock | 0.3763 | 0.3784 | 0.3745 | 0.3782 | 15864800.0 |
| 2002-01-11 11:20:00 | AAPL | Stock | 0.3777 | 0.3811 | 0.3777 | 0.38 | 7828800.0 |
| 2002-01-11 11:25:00 | AAPL | Stock | 0.3798 | 0.3807 | 0.3794 | 0.3796 | 2900800.0 |
| 2002-01-11 11:30:00 | AAPL | Stock | 0.3798 | 0.3813 | 0.3796 | 0.38 | 1052800.0 |
| 2002-01-11 11:35:00 | AAPL | Stock | 0.3798 | 0.3816 | 0.3796 | 0.3816 | 1724800.0 |
| 2002-01-11 11:40:00 | AAPL | Stock | 0.3807 | 0.3821 | 0.3798 | 0.3798 | 1635200.0 |
| 2002-01-11 11:45:00 | AAPL | Stock | 0.3798 | 0.3811 | 0.3788 | 0.3788 | 1467200.0 |
| 2002-01-11 11:50:00 | AAPL | Stock | 0.3788 | 0.3791 | 0.3777 | 0.3784 | 5219200.0 |
| 2002-01-11 11:55:00 | AAPL | Stock | 0.3786 | 0.3791 | 0.3786 | 0.3786 | 604800.0 |
| 2002-01-11 12:00:00 | AAPL | Stock | 0.3784 | 0.3786 | 0.377 | 0.377 | 2766400.0 |
| 2002-01-11 12:05:00 | AAPL | Stock | 0.3775 | 0.378 | 0.3775 | 0.3779 | 492800.0 |
| 2002-01-11 12:10:00 | AAPL | Stock | 0.378 | 0.378 | 0.3771 | 0.3771 | 996800.0 |
| 2002-01-11 12:15:00 | AAPL | Stock | 0.3771 | 0.3771 | 0.3757 | 0.3764 | 2760800.0 |
| 2002-01-11 12:20:00 | AAPL | Stock | 0.3761 | 0.3775 | 0.3757 | 0.3775 | 3477600.0 |
| 2002-01-11 12:25:00 | AAPL | Stock | 0.3773 | 0.378 | 0.3768 | 0.3779 | 481600.0 |
| 2002-01-11 12:30:00 | AAPL | Stock | 0.3784 | 0.3784 | 0.3782 | 0.3782 | 151200.0 |
| 2002-01-11 12:35:00 | AAPL | Stock | 0.377 | 0.3777 | 0.3754 | 0.3777 | 2744000.0 |
| 2002-01-11 12:40:00 | AAPL | Stock | 0.3775 | 0.3775 | 0.3766 | 0.3766 | 515200.0 |
| 2002-01-11 12:45:00 | AAPL | Stock | 0.3766 | 0.3766 | 0.3738 | 0.3745 | 4502400.0 |
| 2002-01-11 12:50:00 | AAPL | Stock | 0.375 | 0.3759 | 0.3745 | 0.3756 | 2559200.0 |
| 2002-01-11 12:55:00 | AAPL | Stock | 0.3757 | 0.3768 | 0.3755 | 0.3759 | 1344000.0 |
| 2002-01-11 13:00:00 | AAPL | Stock | 0.3759 | 0.3761 | 0.3725 | 0.3732 | 2279200.0 |
| 2002-01-11 13:05:00 | AAPL | Stock | 0.3734 | 0.375 | 0.3734 | 0.375 | 2503200.0 |
> showing 50 of 115,505 rows — these rows as CSV