PREVIEW / stock_1min / 2005-02-04
file: by_date/stock_1min/2005/2005-02-04.parquet size: 6.7 MB rows: 547,720 symbols: 1,583
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 |
|---|---|---|---|---|---|---|---|
| 2005-02-04 08:01:00 | AAPL | Stock | 1.3889 | 1.3889 | 1.3889 | 1.3889 | 22400.0 |
| 2005-02-04 08:04:00 | AAPL | Stock | 1.3889 | 1.3889 | 1.3889 | 1.3889 | 5600.0 |
| 2005-02-04 08:05:00 | AAPL | Stock | 1.3889 | 1.3889 | 1.3889 | 1.3889 | 5600.0 |
| 2005-02-04 08:12:00 | AAPL | Stock | 1.3893 | 1.3893 | 1.3893 | 1.3893 | 19600.0 |
| 2005-02-04 08:16:00 | AAPL | Stock | 1.3973 | 1.3973 | 1.3973 | 1.3973 | 98000.0 |
| 2005-02-04 08:30:00 | AAPL | Stock | 1.3929 | 1.3929 | 1.3889 | 1.3929 | 172424.0 |
| 2005-02-04 08:31:00 | AAPL | Stock | 1.3929 | 1.3929 | 1.3929 | 1.3929 | 24640.0 |
| 2005-02-04 08:32:00 | AAPL | Stock | 1.3929 | 1.3929 | 1.3893 | 1.3893 | 109200.0 |
| 2005-02-04 08:33:00 | AAPL | Stock | 1.3927 | 1.3927 | 1.3927 | 1.3927 | 16800.0 |
| 2005-02-04 08:35:00 | AAPL | Stock | 1.3929 | 1.3929 | 1.3893 | 1.3893 | 16800.0 |
| 2005-02-04 08:36:00 | AAPL | Stock | 1.3929 | 1.3929 | 1.3929 | 1.3929 | 28000.0 |
| 2005-02-04 08:39:00 | AAPL | Stock | 1.392 | 1.3929 | 1.392 | 1.3929 | 83440.0 |
| 2005-02-04 08:41:00 | AAPL | Stock | 1.3955 | 1.3955 | 1.3955 | 1.3955 | 52640.0 |
| 2005-02-04 08:45:00 | AAPL | Stock | 1.3929 | 1.3929 | 1.3929 | 1.3929 | 5600.0 |
| 2005-02-04 08:46:00 | AAPL | Stock | 1.3921 | 1.3929 | 1.3902 | 1.3929 | 187600.0 |
| 2005-02-04 08:47:00 | AAPL | Stock | 1.3929 | 1.3929 | 1.3929 | 1.3929 | 106400.0 |
| 2005-02-04 08:48:00 | AAPL | Stock | 1.3929 | 1.3929 | 1.3929 | 1.3929 | 5600.0 |
| 2005-02-04 08:50:00 | AAPL | Stock | 1.3902 | 1.3902 | 1.3902 | 1.3902 | 56000.0 |
| 2005-02-04 08:51:00 | AAPL | Stock | 1.3911 | 1.3911 | 1.3911 | 1.3911 | 56000.0 |
| 2005-02-04 09:01:00 | AAPL | Stock | 1.3905 | 1.3905 | 1.3905 | 1.3905 | 5600.0 |
| 2005-02-04 09:05:00 | AAPL | Stock | 1.3902 | 1.3902 | 1.3893 | 1.3893 | 14000.0 |
| 2005-02-04 09:07:00 | AAPL | Stock | 1.3909 | 1.3909 | 1.3909 | 1.3909 | 22400.0 |
| 2005-02-04 09:09:00 | AAPL | Stock | 1.3895 | 1.3902 | 1.3895 | 1.3902 | 23520.0 |
| 2005-02-04 09:11:00 | AAPL | Stock | 1.3902 | 1.3902 | 1.3902 | 1.3902 | 11200.0 |
| 2005-02-04 09:19:00 | AAPL | Stock | 1.3902 | 1.3902 | 1.3902 | 1.3902 | 61040.0 |
| 2005-02-04 09:20:00 | AAPL | Stock | 1.3911 | 1.3911 | 1.3909 | 1.3909 | 33600.0 |
| 2005-02-04 09:25:00 | AAPL | Stock | 1.3902 | 1.3902 | 1.3902 | 1.3902 | 5600.0 |
| 2005-02-04 09:28:00 | AAPL | Stock | 1.3904 | 1.3945 | 1.3904 | 1.3945 | 392784.0 |
| 2005-02-04 09:29:00 | AAPL | Stock | 1.3946 | 1.3959 | 1.3925 | 1.3936 | 414400.0 |
| 2005-02-04 09:30:00 | AAPL | Stock | 1.3905 | 1.3946 | 1.388 | 1.3893 | 8072512.0 |
| 2005-02-04 09:31:00 | AAPL | Stock | 1.3889 | 1.3923 | 1.3871 | 1.3877 | 2682232.0 |
| 2005-02-04 09:32:00 | AAPL | Stock | 1.3877 | 1.3907 | 1.3845 | 1.3854 | 2874424.0 |
| 2005-02-04 09:33:00 | AAPL | Stock | 1.385 | 1.3884 | 1.3845 | 1.3879 | 4500160.0 |
| 2005-02-04 09:34:00 | AAPL | Stock | 1.3879 | 1.3907 | 1.3857 | 1.39 | 4691568.0 |
| 2005-02-04 09:35:00 | AAPL | Stock | 1.3896 | 1.3921 | 1.3893 | 1.3921 | 2212672.0 |
| 2005-02-04 09:36:00 | AAPL | Stock | 1.392 | 1.3941 | 1.3905 | 1.3938 | 4593736.0 |
| 2005-02-04 09:37:00 | AAPL | Stock | 1.3938 | 1.3968 | 1.3932 | 1.3955 | 5144832.0 |
| 2005-02-04 09:38:00 | AAPL | Stock | 1.3961 | 1.397 | 1.3929 | 1.3968 | 3677520.0 |
| 2005-02-04 09:39:00 | AAPL | Stock | 1.3968 | 1.3991 | 1.3966 | 1.3966 | 4376680.0 |
| 2005-02-04 09:40:00 | AAPL | Stock | 1.3973 | 1.3982 | 1.397 | 1.398 | 2527112.0 |
| 2005-02-04 09:41:00 | AAPL | Stock | 1.3982 | 1.3996 | 1.398 | 1.3986 | 3968944.0 |
| 2005-02-04 09:42:00 | AAPL | Stock | 1.3988 | 1.3995 | 1.3984 | 1.3986 | 2143680.0 |
| 2005-02-04 09:43:00 | AAPL | Stock | 1.3986 | 1.4004 | 1.3984 | 1.3998 | 3432576.0 |
| 2005-02-04 09:44:00 | AAPL | Stock | 1.4 | 1.4002 | 1.3971 | 1.3979 | 3325952.0 |
| 2005-02-04 09:45:00 | AAPL | Stock | 1.3982 | 1.3993 | 1.3975 | 1.3988 | 2340016.0 |
| 2005-02-04 09:46:00 | AAPL | Stock | 1.3988 | 1.3996 | 1.3979 | 1.3993 | 3168256.0 |
| 2005-02-04 09:47:00 | AAPL | Stock | 1.3991 | 1.3998 | 1.3977 | 1.3982 | 3158624.0 |
| 2005-02-04 09:48:00 | AAPL | Stock | 1.3984 | 1.4005 | 1.3982 | 1.3998 | 2916536.0 |
| 2005-02-04 09:49:00 | AAPL | Stock | 1.3996 | 1.3998 | 1.3973 | 1.3982 | 3281656.0 |
| 2005-02-04 09:50:00 | AAPL | Stock | 1.3982 | 1.3993 | 1.3982 | 1.3988 | 801528.0 |
> showing 50 of 547,720 rows — these rows as CSV