PREVIEW / stock_5min / 2007-03-02
file: by_date/stock_5min/2007/2007-03-02.parquet size: 3.4 MB rows: 244,513 symbols: 2,490
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-03-02 07:15:00 | AAPL | Stock | 3.0757 | 3.1089 | 3.0757 | 3.1089 | 204400.0 |
| 2007-03-02 07:30:00 | AAPL | Stock | 3.1061 | 3.1061 | 3.0896 | 3.0943 | 140000.0 |
| 2007-03-02 07:35:00 | AAPL | Stock | 3.095 | 3.1032 | 3.0946 | 3.1032 | 37800.0 |
| 2007-03-02 07:40:00 | AAPL | Stock | 3.1061 | 3.1061 | 3.0996 | 3.0996 | 31640.0 |
| 2007-03-02 07:45:00 | AAPL | Stock | 3.0996 | 3.0996 | 3.0996 | 3.0996 | 8400.0 |
| 2007-03-02 07:50:00 | AAPL | Stock | 3.0982 | 3.0982 | 3.0982 | 3.0982 | 9240.0 |
| 2007-03-02 08:00:00 | AAPL | Stock | 3.0982 | 3.1036 | 3.0911 | 3.0946 | 392560.0 |
| 2007-03-02 08:05:00 | AAPL | Stock | 3.0936 | 3.0946 | 3.0904 | 3.0904 | 219996.0 |
| 2007-03-02 08:10:00 | AAPL | Stock | 3.0896 | 3.0918 | 3.0857 | 3.0871 | 290080.0 |
| 2007-03-02 08:15:00 | AAPL | Stock | 3.0875 | 3.0893 | 3.0857 | 3.0857 | 321020.0 |
| 2007-03-02 08:20:00 | AAPL | Stock | 3.0839 | 3.0946 | 3.0839 | 3.0893 | 761712.0 |
| 2007-03-02 08:25:00 | AAPL | Stock | 3.0932 | 3.0982 | 3.0911 | 3.0946 | 602280.0 |
| 2007-03-02 08:30:00 | AAPL | Stock | 3.0946 | 3.0971 | 3.0932 | 3.0971 | 179200.0 |
| 2007-03-02 08:35:00 | AAPL | Stock | 3.0957 | 3.0979 | 3.095 | 3.0979 | 393400.0 |
| 2007-03-02 08:40:00 | AAPL | Stock | 3.0968 | 3.0971 | 3.0946 | 3.095 | 179200.0 |
| 2007-03-02 08:45:00 | AAPL | Stock | 3.0946 | 3.0964 | 3.0932 | 3.0946 | 323120.0 |
| 2007-03-02 08:50:00 | AAPL | Stock | 3.0954 | 3.0975 | 3.0954 | 3.0964 | 367668.0 |
| 2007-03-02 08:55:00 | AAPL | Stock | 3.0971 | 3.0971 | 3.0964 | 3.0964 | 140000.0 |
| 2007-03-02 09:00:00 | AAPL | Stock | 3.0961 | 3.0979 | 3.0929 | 3.0954 | 192640.0 |
| 2007-03-02 09:05:00 | AAPL | Stock | 3.0979 | 3.0982 | 3.0971 | 3.0971 | 154560.0 |
| 2007-03-02 09:10:00 | AAPL | Stock | 3.0971 | 3.0975 | 3.0929 | 3.0929 | 399000.0 |
| 2007-03-02 09:15:00 | AAPL | Stock | 3.0932 | 3.0957 | 3.0932 | 3.0957 | 42000.0 |
| 2007-03-02 09:20:00 | AAPL | Stock | 3.0957 | 3.0982 | 3.0929 | 3.0929 | 280420.0 |
| 2007-03-02 09:25:00 | AAPL | Stock | 3.0929 | 3.0986 | 3.0925 | 3.0986 | 586236.0 |
| 2007-03-02 09:30:00 | AAPL | Stock | 3.0989 | 3.1246 | 3.0968 | 3.1132 | 32623500.0 |
| 2007-03-02 09:35:00 | AAPL | Stock | 3.1129 | 3.1232 | 3.1014 | 3.1157 | 26328624.0 |
| 2007-03-02 09:40:00 | AAPL | Stock | 3.1146 | 3.1264 | 3.1107 | 3.1139 | 23514372.0 |
| 2007-03-02 09:45:00 | AAPL | Stock | 3.1136 | 3.1175 | 3.1036 | 3.1121 | 25077052.0 |
| 2007-03-02 09:50:00 | AAPL | Stock | 3.1114 | 3.1189 | 3.0979 | 3.0989 | 22169588.0 |
| 2007-03-02 09:55:00 | AAPL | Stock | 3.0989 | 3.1011 | 3.0918 | 3.0993 | 22712760.0 |
| 2007-03-02 10:00:00 | AAPL | Stock | 3.0993 | 3.1125 | 3.0929 | 3.1082 | 20087872.0 |
| 2007-03-02 10:05:00 | AAPL | Stock | 3.1086 | 3.1132 | 3.1 | 3.1054 | 11204816.0 |
| 2007-03-02 10:10:00 | AAPL | Stock | 3.1057 | 3.1107 | 3.0943 | 3.0986 | 11870992.0 |
| 2007-03-02 10:15:00 | AAPL | Stock | 3.0989 | 3.1089 | 3.0982 | 3.105 | 10664668.0 |
| 2007-03-02 10:20:00 | AAPL | Stock | 3.105 | 3.1064 | 3.0971 | 3.1036 | 10708740.0 |
| 2007-03-02 10:25:00 | AAPL | Stock | 3.1036 | 3.1054 | 3.0975 | 3.1039 | 10058860.0 |
| 2007-03-02 10:30:00 | AAPL | Stock | 3.1039 | 3.1121 | 3.1007 | 3.1118 | 13534612.0 |
| 2007-03-02 10:35:00 | AAPL | Stock | 3.1118 | 3.1143 | 3.1039 | 3.1054 | 8372924.0 |
| 2007-03-02 10:40:00 | AAPL | Stock | 3.105 | 3.1125 | 3.1036 | 3.1107 | 7347928.0 |
| 2007-03-02 10:45:00 | AAPL | Stock | 3.1114 | 3.1161 | 3.1068 | 3.1116 | 9444428.0 |
| 2007-03-02 10:50:00 | AAPL | Stock | 3.1121 | 3.1143 | 3.1071 | 3.1093 | 9522212.0 |
| 2007-03-02 10:55:00 | AAPL | Stock | 3.1096 | 3.1161 | 3.1079 | 3.1129 | 6908944.0 |
| 2007-03-02 11:00:00 | AAPL | Stock | 3.1125 | 3.1132 | 3.1071 | 3.1111 | 6683908.0 |
| 2007-03-02 11:05:00 | AAPL | Stock | 3.1114 | 3.1118 | 3.1021 | 3.1025 | 7746676.0 |
| 2007-03-02 11:10:00 | AAPL | Stock | 3.1024 | 3.1071 | 3.1018 | 3.1071 | 6294652.0 |
| 2007-03-02 11:15:00 | AAPL | Stock | 3.1069 | 3.11 | 3.1057 | 3.1096 | 6668928.0 |
| 2007-03-02 11:20:00 | AAPL | Stock | 3.1096 | 3.11 | 3.1025 | 3.1054 | 6509580.0 |
| 2007-03-02 11:25:00 | AAPL | Stock | 3.1054 | 3.1061 | 3.1011 | 3.1032 | 4512424.0 |
| 2007-03-02 11:30:00 | AAPL | Stock | 3.1029 | 3.1036 | 3.0957 | 3.0975 | 7518168.0 |
| 2007-03-02 11:35:00 | AAPL | Stock | 3.0971 | 3.1014 | 3.0936 | 3.0946 | 7961352.0 |
> showing 50 of 244,513 rows — these rows as CSV