PREVIEW / stock_1min / 2007-05-23
file: by_date/stock_1min/2007/2007-05-23.parquet size: 11.0 MB rows: 904,404 symbols: 2,470
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 |
|---|---|---|---|---|---|---|---|
| 2007-05-23 09:30:00 | AAPL | Stock | 4.0721 | 4.075 | 4.0686 | 4.0739 | 8413188.0 |
| 2007-05-23 09:31:00 | AAPL | Stock | 4.0746 | 4.0786 | 4.0711 | 4.0782 | 4436796.0 |
| 2007-05-23 09:32:00 | AAPL | Stock | 4.0775 | 4.0821 | 4.0736 | 4.0821 | 3385872.0 |
| 2007-05-23 09:33:00 | AAPL | Stock | 4.0821 | 4.0836 | 4.0782 | 4.0825 | 2920540.0 |
| 2007-05-23 09:34:00 | AAPL | Stock | 4.0825 | 4.0829 | 4.0786 | 4.0793 | 3817548.0 |
| 2007-05-23 09:35:00 | AAPL | Stock | 4.0789 | 4.0836 | 4.0789 | 4.0807 | 3169376.0 |
| 2007-05-23 09:36:00 | AAPL | Stock | 4.081 | 4.0832 | 4.0736 | 4.0768 | 3826984.0 |
| 2007-05-23 09:37:00 | AAPL | Stock | 4.0768 | 4.0796 | 4.0732 | 4.0768 | 3292968.0 |
| 2007-05-23 09:38:00 | AAPL | Stock | 4.0771 | 4.0782 | 4.0757 | 4.0764 | 2749740.0 |
| 2007-05-23 09:39:00 | AAPL | Stock | 4.0768 | 4.0821 | 4.0761 | 4.08 | 3094252.0 |
| 2007-05-23 09:40:00 | AAPL | Stock | 4.0793 | 4.0821 | 4.0789 | 4.0814 | 1356376.0 |
| 2007-05-23 09:41:00 | AAPL | Stock | 4.0811 | 4.0814 | 4.0768 | 4.0796 | 1662528.0 |
| 2007-05-23 09:42:00 | AAPL | Stock | 4.0799 | 4.0814 | 4.0793 | 4.0811 | 2187556.0 |
| 2007-05-23 09:43:00 | AAPL | Stock | 4.0811 | 4.0893 | 4.0807 | 4.0882 | 4116196.0 |
| 2007-05-23 09:44:00 | AAPL | Stock | 4.0882 | 4.0893 | 4.0857 | 4.088 | 3725624.0 |
| 2007-05-23 09:45:00 | AAPL | Stock | 4.0886 | 4.09 | 4.0882 | 4.0893 | 3055892.0 |
| 2007-05-23 09:46:00 | AAPL | Stock | 4.0889 | 4.0925 | 4.085 | 4.0907 | 3851092.0 |
| 2007-05-23 09:47:00 | AAPL | Stock | 4.0904 | 4.095 | 4.0896 | 4.095 | 2747836.0 |
| 2007-05-23 09:48:00 | AAPL | Stock | 4.0954 | 4.0954 | 4.0904 | 4.0904 | 2470244.0 |
| 2007-05-23 09:49:00 | AAPL | Stock | 4.0904 | 4.0932 | 4.0879 | 4.0921 | 3032512.0 |
| 2007-05-23 09:50:00 | AAPL | Stock | 4.0918 | 4.0939 | 4.0893 | 4.0914 | 2534476.0 |
| 2007-05-23 09:51:00 | AAPL | Stock | 4.0911 | 4.0932 | 4.0896 | 4.0896 | 1804152.0 |
| 2007-05-23 09:52:00 | AAPL | Stock | 4.0896 | 4.0929 | 4.0886 | 4.0918 | 2123940.0 |
| 2007-05-23 09:53:00 | AAPL | Stock | 4.0918 | 4.0979 | 4.0918 | 4.0979 | 4423216.0 |
| 2007-05-23 09:54:00 | AAPL | Stock | 4.0975 | 4.1004 | 4.0968 | 4.0982 | 3761632.0 |
| 2007-05-23 09:55:00 | AAPL | Stock | 4.0979 | 4.0993 | 4.0964 | 4.0989 | 3356276.0 |
| 2007-05-23 09:56:00 | AAPL | Stock | 4.0993 | 4.1029 | 4.0979 | 4.1007 | 3233804.0 |
| 2007-05-23 09:57:00 | AAPL | Stock | 4.0984 | 4.1007 | 4.0982 | 4.1007 | 2631356.0 |
| 2007-05-23 09:58:00 | AAPL | Stock | 4.1 | 4.1014 | 4.0993 | 4.1 | 2263156.0 |
| 2007-05-23 09:59:00 | AAPL | Stock | 4.1 | 4.1 | 4.0946 | 4.095 | 3705212.0 |
| 2007-05-23 10:00:00 | AAPL | Stock | 4.095 | 4.0993 | 4.0946 | 4.0968 | 4192468.0 |
| 2007-05-23 10:01:00 | AAPL | Stock | 4.0971 | 4.1014 | 4.0968 | 4.1011 | 1963724.0 |
| 2007-05-23 10:02:00 | AAPL | Stock | 4.1004 | 4.1029 | 4.1 | 4.1014 | 2088968.0 |
| 2007-05-23 10:03:00 | AAPL | Stock | 4.1011 | 4.1018 | 4.0993 | 4.1007 | 2110024.0 |
| 2007-05-23 10:04:00 | AAPL | Stock | 4.1011 | 4.1014 | 4.0986 | 4.0996 | 1311632.0 |
| 2007-05-23 10:05:00 | AAPL | Stock | 4.1 | 4.1025 | 4.0993 | 4.1018 | 3879932.0 |
| 2007-05-23 10:06:00 | AAPL | Stock | 4.1015 | 4.1018 | 4.1004 | 4.1011 | 2811536.0 |
| 2007-05-23 10:07:00 | AAPL | Stock | 4.1014 | 4.1014 | 4.0986 | 4.0986 | 3623900.0 |
| 2007-05-23 10:08:00 | AAPL | Stock | 4.0989 | 4.1025 | 4.0986 | 4.1 | 2039828.0 |
| 2007-05-23 10:09:00 | AAPL | Stock | 4.0996 | 4.1004 | 4.0993 | 4.0996 | 1104320.0 |
| 2007-05-23 10:10:00 | AAPL | Stock | 4.1 | 4.1007 | 4.0968 | 4.0971 | 2596832.0 |
| 2007-05-23 10:11:00 | AAPL | Stock | 4.0971 | 4.0982 | 4.0936 | 4.0939 | 3530324.0 |
| 2007-05-23 10:12:00 | AAPL | Stock | 4.0942 | 4.102 | 4.0907 | 4.0914 | 2929276.0 |
| 2007-05-23 10:13:00 | AAPL | Stock | 4.0918 | 4.0946 | 4.09 | 4.0914 | 2227904.0 |
| 2007-05-23 10:14:00 | AAPL | Stock | 4.0914 | 4.0936 | 4.0911 | 4.0925 | 2052176.0 |
| 2007-05-23 10:15:00 | AAPL | Stock | 4.0925 | 4.0982 | 4.0921 | 4.0964 | 2193408.0 |
| 2007-05-23 10:16:00 | AAPL | Stock | 4.0968 | 4.0968 | 4.0943 | 4.0961 | 1416660.0 |
| 2007-05-23 10:17:00 | AAPL | Stock | 4.0957 | 4.0982 | 4.095 | 4.0982 | 1799840.0 |
| 2007-05-23 10:18:00 | AAPL | Stock | 4.0986 | 4.0986 | 4.0954 | 4.0961 | 1532972.0 |
| 2007-05-23 10:19:00 | AAPL | Stock | 4.0957 | 4.0975 | 4.0955 | 4.0971 | 880964.0 |
> showing 50 of 904,404 rows — these rows as CSV