PREVIEW / stock_5min / 2007-02-27
file: by_date/stock_5min/2007/2007-02-27.parquet size: 3.6 MB rows: 253,551 symbols: 2,520
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-02-27 04:55:00 | AAPL | Stock | 3.1286 | 3.1286 | 3.1286 | 3.1286 | 8400.0 |
| 2007-02-27 07:00:00 | AAPL | Stock | 3.1143 | 3.1143 | 3.1071 | 3.1071 | 36400.0 |
| 2007-02-27 07:05:00 | AAPL | Stock | 3.1107 | 3.1107 | 3.1107 | 3.1107 | 2800.0 |
| 2007-02-27 07:10:00 | AAPL | Stock | 3.1107 | 3.1111 | 3.1107 | 3.1111 | 30800.0 |
| 2007-02-27 07:15:00 | AAPL | Stock | 3.1136 | 3.1136 | 3.1136 | 3.1136 | 5600.0 |
| 2007-02-27 07:20:00 | AAPL | Stock | 3.1136 | 3.1196 | 3.1114 | 3.1196 | 50400.0 |
| 2007-02-27 07:25:00 | AAPL | Stock | 3.1143 | 3.1143 | 3.1075 | 3.1093 | 50400.0 |
| 2007-02-27 07:30:00 | AAPL | Stock | 3.1089 | 3.1089 | 3.1046 | 3.1046 | 77000.0 |
| 2007-02-27 07:40:00 | AAPL | Stock | 3.1093 | 3.1093 | 3.1093 | 3.1093 | 2800.0 |
| 2007-02-27 07:45:00 | AAPL | Stock | 3.1139 | 3.1139 | 3.1071 | 3.1071 | 203000.0 |
| 2007-02-27 07:50:00 | AAPL | Stock | 3.1089 | 3.1107 | 3.1071 | 3.1107 | 958720.0 |
| 2007-02-27 07:55:00 | AAPL | Stock | 3.1089 | 3.1107 | 3.1089 | 3.1104 | 176400.0 |
| 2007-02-27 08:00:00 | AAPL | Stock | 3.1096 | 3.1193 | 3.1089 | 3.1193 | 1211224.0 |
| 2007-02-27 08:05:00 | AAPL | Stock | 3.1189 | 3.1243 | 3.1071 | 3.1179 | 430640.0 |
| 2007-02-27 08:10:00 | AAPL | Stock | 3.1161 | 3.1196 | 3.115 | 3.115 | 273140.0 |
| 2007-02-27 08:15:00 | AAPL | Stock | 3.115 | 3.1179 | 3.1146 | 3.1146 | 549500.0 |
| 2007-02-27 08:20:00 | AAPL | Stock | 3.1179 | 3.1196 | 3.1161 | 3.1161 | 142520.0 |
| 2007-02-27 08:25:00 | AAPL | Stock | 3.115 | 3.1186 | 3.1125 | 3.1171 | 222516.0 |
| 2007-02-27 08:30:00 | AAPL | Stock | 3.1161 | 3.1161 | 3.1114 | 3.1125 | 582988.0 |
| 2007-02-27 08:35:00 | AAPL | Stock | 3.1125 | 3.1132 | 3.1096 | 3.1132 | 362600.0 |
| 2007-02-27 08:40:00 | AAPL | Stock | 3.1132 | 3.1143 | 3.1021 | 3.1021 | 1018248.0 |
| 2007-02-27 08:45:00 | AAPL | Stock | 3.1029 | 3.1071 | 3.0971 | 3.1068 | 539700.0 |
| 2007-02-27 08:50:00 | AAPL | Stock | 3.1064 | 3.1071 | 3.1032 | 3.1036 | 562240.0 |
| 2007-02-27 08:55:00 | AAPL | Stock | 3.1054 | 3.1064 | 3.1039 | 3.1039 | 149800.0 |
| 2007-02-27 09:00:00 | AAPL | Stock | 3.1036 | 3.1125 | 3.0993 | 3.1 | 659680.0 |
| 2007-02-27 09:05:00 | AAPL | Stock | 3.0993 | 3.1 | 3.0975 | 3.0993 | 649488.0 |
| 2007-02-27 09:10:00 | AAPL | Stock | 3.0986 | 3.1011 | 3.0975 | 3.0982 | 790860.0 |
| 2007-02-27 09:15:00 | AAPL | Stock | 3.0968 | 3.0986 | 3.095 | 3.095 | 383740.0 |
| 2007-02-27 09:20:00 | AAPL | Stock | 3.095 | 3.0979 | 3.0939 | 3.0939 | 332920.0 |
| 2007-02-27 09:25:00 | AAPL | Stock | 3.0946 | 3.0971 | 3.08 | 3.0811 | 2023448.0 |
| 2007-02-27 09:30:00 | AAPL | Stock | 3.0821 | 3.0954 | 3.0807 | 3.0889 | 38112536.0 |
| 2007-02-27 09:35:00 | AAPL | Stock | 3.0889 | 3.095 | 3.0675 | 3.0732 | 36887088.0 |
| 2007-02-27 09:40:00 | AAPL | Stock | 3.0732 | 3.0871 | 3.0711 | 3.0839 | 22891708.0 |
| 2007-02-27 09:45:00 | AAPL | Stock | 3.0843 | 3.1004 | 3.0825 | 3.0989 | 21118356.0 |
| 2007-02-27 09:50:00 | AAPL | Stock | 3.0986 | 3.1057 | 3.09 | 3.1032 | 21868980.0 |
| 2007-02-27 09:55:00 | AAPL | Stock | 3.1032 | 3.1032 | 3.0871 | 3.0882 | 17561656.0 |
| 2007-02-27 10:00:00 | AAPL | Stock | 3.0882 | 3.0996 | 3.0846 | 3.0886 | 20696956.0 |
| 2007-02-27 10:05:00 | AAPL | Stock | 3.0889 | 3.0986 | 3.0839 | 3.095 | 12399380.0 |
| 2007-02-27 10:10:00 | AAPL | Stock | 3.095 | 3.0968 | 3.0914 | 3.0961 | 11311524.0 |
| 2007-02-27 10:15:00 | AAPL | Stock | 3.0954 | 3.0964 | 3.0896 | 3.0929 | 10840172.0 |
| 2007-02-27 10:20:00 | AAPL | Stock | 3.0929 | 3.1007 | 3.0925 | 3.0993 | 12751060.0 |
| 2007-02-27 10:25:00 | AAPL | Stock | 3.0993 | 3.1054 | 3.096 | 3.1032 | 10397324.0 |
| 2007-02-27 10:30:00 | AAPL | Stock | 3.1029 | 3.11 | 3.1014 | 3.1025 | 15823500.0 |
| 2007-02-27 10:35:00 | AAPL | Stock | 3.1025 | 3.1068 | 3.1 | 3.1046 | 10299940.0 |
| 2007-02-27 10:40:00 | AAPL | Stock | 3.1043 | 3.1068 | 3.1 | 3.1007 | 8293908.0 |
| 2007-02-27 10:45:00 | AAPL | Stock | 3.1007 | 3.1029 | 3.0975 | 3.0979 | 9631412.0 |
| 2007-02-27 10:50:00 | AAPL | Stock | 3.0982 | 3.1046 | 3.0964 | 3.1043 | 9976876.0 |
| 2007-02-27 10:55:00 | AAPL | Stock | 3.1039 | 3.1082 | 3.0904 | 3.0929 | 13824216.0 |
| 2007-02-27 11:00:00 | AAPL | Stock | 3.0932 | 3.0979 | 3.0907 | 3.0964 | 8071812.0 |
| 2007-02-27 11:05:00 | AAPL | Stock | 3.0961 | 3.0968 | 3.0893 | 3.0893 | 5998860.0 |
> showing 50 of 253,551 rows — these rows as CSV