PREVIEW / stock_1min / 2005-02-02
file: by_date/stock_1min/2005/2005-02-02.parquet size: 6.7 MB rows: 559,570 symbols: 1,579
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-02 08:00:00 | AAPL | Stock | 1.3964 | 1.3964 | 1.3929 | 1.3929 | 19040.0 |
| 2005-02-02 08:01:00 | AAPL | Stock | 1.398 | 1.398 | 1.398 | 1.398 | 614376.0 |
| 2005-02-02 08:12:00 | AAPL | Stock | 1.3979 | 1.3979 | 1.3979 | 1.3979 | 5600.0 |
| 2005-02-02 08:15:00 | AAPL | Stock | 1.3932 | 1.3932 | 1.3929 | 1.3929 | 47600.0 |
| 2005-02-02 08:16:00 | AAPL | Stock | 1.3911 | 1.3982 | 1.3911 | 1.3973 | 171864.0 |
| 2005-02-02 08:17:00 | AAPL | Stock | 1.3929 | 1.3932 | 1.3929 | 1.3932 | 49840.0 |
| 2005-02-02 08:20:00 | AAPL | Stock | 1.3964 | 1.3964 | 1.3929 | 1.3929 | 202664.0 |
| 2005-02-02 08:23:00 | AAPL | Stock | 1.3932 | 1.3932 | 1.3932 | 1.3932 | 28000.0 |
| 2005-02-02 08:25:00 | AAPL | Stock | 1.3943 | 1.3973 | 1.3943 | 1.3973 | 16800.0 |
| 2005-02-02 08:28:00 | AAPL | Stock | 1.3952 | 1.3952 | 1.3952 | 1.3952 | 11200.0 |
| 2005-02-02 08:29:00 | AAPL | Stock | 1.3963 | 1.3964 | 1.3963 | 1.3964 | 38024.0 |
| 2005-02-02 08:31:00 | AAPL | Stock | 1.3964 | 1.3964 | 1.3964 | 1.3964 | 5600.0 |
| 2005-02-02 08:32:00 | AAPL | Stock | 1.3964 | 1.3964 | 1.3964 | 1.3964 | 238560.0 |
| 2005-02-02 08:33:00 | AAPL | Stock | 1.3964 | 1.3964 | 1.3964 | 1.3964 | 93240.0 |
| 2005-02-02 08:34:00 | AAPL | Stock | 1.3964 | 1.3964 | 1.3961 | 1.3961 | 83664.0 |
| 2005-02-02 08:35:00 | AAPL | Stock | 1.3964 | 1.3964 | 1.3964 | 1.3964 | 28000.0 |
| 2005-02-02 08:37:00 | AAPL | Stock | 1.3964 | 1.3964 | 1.3964 | 1.3964 | 5600.0 |
| 2005-02-02 08:38:00 | AAPL | Stock | 1.3961 | 1.3961 | 1.3961 | 1.3961 | 16800.0 |
| 2005-02-02 08:46:00 | AAPL | Stock | 1.3961 | 1.3961 | 1.3961 | 1.3961 | 16800.0 |
| 2005-02-02 08:55:00 | AAPL | Stock | 1.3959 | 1.3959 | 1.3959 | 1.3959 | 84000.0 |
| 2005-02-02 08:57:00 | AAPL | Stock | 1.395 | 1.395 | 1.3948 | 1.3948 | 67536.0 |
| 2005-02-02 08:58:00 | AAPL | Stock | 1.3946 | 1.3946 | 1.3945 | 1.3945 | 39200.0 |
| 2005-02-02 08:59:00 | AAPL | Stock | 1.3936 | 1.3936 | 1.3936 | 1.3936 | 16800.0 |
| 2005-02-02 09:00:00 | AAPL | Stock | 1.3939 | 1.3939 | 1.3939 | 1.3939 | 56000.0 |
| 2005-02-02 09:01:00 | AAPL | Stock | 1.3939 | 1.3939 | 1.3939 | 1.3939 | 28000.0 |
| 2005-02-02 09:05:00 | AAPL | Stock | 1.3955 | 1.3955 | 1.3955 | 1.3955 | 50400.0 |
| 2005-02-02 09:06:00 | AAPL | Stock | 1.3963 | 1.3963 | 1.3955 | 1.3955 | 63000.0 |
| 2005-02-02 09:08:00 | AAPL | Stock | 1.3955 | 1.3961 | 1.3954 | 1.3961 | 143920.0 |
| 2005-02-02 09:09:00 | AAPL | Stock | 1.3955 | 1.3955 | 1.3955 | 1.3955 | 112000.0 |
| 2005-02-02 09:10:00 | AAPL | Stock | 1.3955 | 1.3955 | 1.3955 | 1.3955 | 33600.0 |
| 2005-02-02 09:11:00 | AAPL | Stock | 1.3955 | 1.3955 | 1.3955 | 1.3955 | 47880.0 |
| 2005-02-02 09:12:00 | AAPL | Stock | 1.3955 | 1.3955 | 1.3955 | 1.3955 | 5600.0 |
| 2005-02-02 09:13:00 | AAPL | Stock | 1.3964 | 1.3964 | 1.3964 | 1.3964 | 39200.0 |
| 2005-02-02 09:14:00 | AAPL | Stock | 1.3955 | 1.3955 | 1.3955 | 1.3955 | 5600.0 |
| 2005-02-02 09:19:00 | AAPL | Stock | 1.3955 | 1.3955 | 1.3955 | 1.3955 | 28000.0 |
| 2005-02-02 09:20:00 | AAPL | Stock | 1.3952 | 1.3952 | 1.3911 | 1.3929 | 195552.0 |
| 2005-02-02 09:22:00 | AAPL | Stock | 1.3929 | 1.3929 | 1.3929 | 1.3929 | 5600.0 |
| 2005-02-02 09:23:00 | AAPL | Stock | 1.3927 | 1.3927 | 1.3927 | 1.3927 | 5600.0 |
| 2005-02-02 09:25:00 | AAPL | Stock | 1.3884 | 1.3929 | 1.3884 | 1.3929 | 22400.0 |
| 2005-02-02 09:26:00 | AAPL | Stock | 1.3929 | 1.3929 | 1.3929 | 1.3929 | 11200.0 |
| 2005-02-02 09:27:00 | AAPL | Stock | 1.3929 | 1.3929 | 1.3925 | 1.3925 | 56000.0 |
| 2005-02-02 09:28:00 | AAPL | Stock | 1.3932 | 1.3936 | 1.392 | 1.3929 | 698376.0 |
| 2005-02-02 09:29:00 | AAPL | Stock | 1.3929 | 1.3934 | 1.3911 | 1.3911 | 358792.0 |
| 2005-02-02 09:30:00 | AAPL | Stock | 1.392 | 1.3939 | 1.3904 | 1.3914 | 10323768.0 |
| 2005-02-02 09:31:00 | AAPL | Stock | 1.3913 | 1.3929 | 1.3895 | 1.3913 | 3466120.0 |
| 2005-02-02 09:32:00 | AAPL | Stock | 1.39 | 1.3929 | 1.3888 | 1.3896 | 2443336.0 |
| 2005-02-02 09:33:00 | AAPL | Stock | 1.3898 | 1.392 | 1.3893 | 1.3911 | 1785616.0 |
| 2005-02-02 09:34:00 | AAPL | Stock | 1.3911 | 1.3914 | 1.3893 | 1.3898 | 2588936.0 |
| 2005-02-02 09:35:00 | AAPL | Stock | 1.3896 | 1.3913 | 1.3884 | 1.3884 | 3308368.0 |
| 2005-02-02 09:36:00 | AAPL | Stock | 1.3886 | 1.3902 | 1.3879 | 1.388 | 2836568.0 |
> showing 50 of 559,570 rows — these rows as CSV