PREVIEW / stock_5min / 2008-12-29
file: by_date/stock_5min/2008/2008-12-29.parquet size: 4.4 MB rows: 309,474 symbols: 3,370
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 |
|---|---|---|---|---|---|---|---|
| 2008-12-29 06:10:00 | AAPL | Stock | 3.1089 | 3.1089 | 3.1089 | 3.1089 | 4200.0 |
| 2008-12-29 06:55:00 | AAPL | Stock | 3.1179 | 3.1304 | 3.1179 | 3.1304 | 14000.0 |
| 2008-12-29 07:05:00 | AAPL | Stock | 3.1286 | 3.1286 | 3.1286 | 3.1286 | 11900.0 |
| 2008-12-29 07:15:00 | AAPL | Stock | 3.1089 | 3.1089 | 3.1089 | 3.1089 | 2800.0 |
| 2008-12-29 07:20:00 | AAPL | Stock | 3.1089 | 3.1089 | 3.1089 | 3.1089 | 2800.0 |
| 2008-12-29 07:25:00 | AAPL | Stock | 3.115 | 3.115 | 3.115 | 3.115 | 16800.0 |
| 2008-12-29 07:30:00 | AAPL | Stock | 3.1143 | 3.1143 | 3.1143 | 3.1143 | 2800.0 |
| 2008-12-29 07:35:00 | AAPL | Stock | 3.1143 | 3.1143 | 3.1143 | 3.1143 | 25200.0 |
| 2008-12-29 07:40:00 | AAPL | Stock | 3.1089 | 3.1089 | 3.1089 | 3.1089 | 2800.0 |
| 2008-12-29 07:50:00 | AAPL | Stock | 3.1121 | 3.1143 | 3.1121 | 3.1139 | 17500.0 |
| 2008-12-29 08:00:00 | AAPL | Stock | 3.1071 | 3.1079 | 3.0929 | 3.0979 | 152292.0 |
| 2008-12-29 08:05:00 | AAPL | Stock | 3.1029 | 3.1029 | 3.0911 | 3.0964 | 155260.0 |
| 2008-12-29 08:10:00 | AAPL | Stock | 3.0975 | 3.105 | 3.0946 | 3.1 | 138460.0 |
| 2008-12-29 08:15:00 | AAPL | Stock | 3.1 | 3.1068 | 3.1 | 3.1018 | 18732.0 |
| 2008-12-29 08:20:00 | AAPL | Stock | 3.1 | 3.1046 | 3.1 | 3.1046 | 69692.0 |
| 2008-12-29 08:25:00 | AAPL | Stock | 3.1 | 3.1 | 3.0996 | 3.0996 | 54320.0 |
| 2008-12-29 08:30:00 | AAPL | Stock | 3.1004 | 3.1004 | 3.0982 | 3.1 | 28000.0 |
| 2008-12-29 08:35:00 | AAPL | Stock | 3.0989 | 3.105 | 3.0971 | 3.1018 | 218148.0 |
| 2008-12-29 08:40:00 | AAPL | Stock | 3.0996 | 3.1071 | 3.0989 | 3.1007 | 40572.0 |
| 2008-12-29 08:45:00 | AAPL | Stock | 3.1036 | 3.1071 | 3.0996 | 3.1032 | 226744.0 |
| 2008-12-29 08:50:00 | AAPL | Stock | 3.1 | 3.1029 | 3.0993 | 3.1029 | 76272.0 |
| 2008-12-29 08:55:00 | AAPL | Stock | 3.1029 | 3.1036 | 3.0996 | 3.1036 | 49700.0 |
| 2008-12-29 09:00:00 | AAPL | Stock | 3.1043 | 3.1054 | 3.0982 | 3.0982 | 87780.0 |
| 2008-12-29 09:05:00 | AAPL | Stock | 3.0982 | 3.1032 | 3.0982 | 3.1004 | 141204.0 |
| 2008-12-29 09:10:00 | AAPL | Stock | 3.1018 | 3.1032 | 3.1004 | 3.1004 | 127400.0 |
| 2008-12-29 09:15:00 | AAPL | Stock | 3.1032 | 3.1104 | 3.1032 | 3.1064 | 151172.0 |
| 2008-12-29 09:20:00 | AAPL | Stock | 3.1068 | 3.1075 | 3.1068 | 3.1071 | 126420.0 |
| 2008-12-29 09:25:00 | AAPL | Stock | 3.1082 | 3.1082 | 3.0896 | 3.0957 | 381276.0 |
| 2008-12-29 09:30:00 | AAPL | Stock | 3.0964 | 3.1182 | 3.0879 | 3.1171 | 14212856.0 |
| 2008-12-29 09:35:00 | AAPL | Stock | 3.1175 | 3.125 | 3.1075 | 3.1214 | 10315424.0 |
| 2008-12-29 09:40:00 | AAPL | Stock | 3.1214 | 3.1293 | 3.115 | 3.1204 | 10389232.0 |
| 2008-12-29 09:45:00 | AAPL | Stock | 3.1207 | 3.1254 | 3.1121 | 3.1132 | 8379840.0 |
| 2008-12-29 09:50:00 | AAPL | Stock | 3.1136 | 3.1189 | 3.1061 | 3.1064 | 7079492.0 |
| 2008-12-29 09:55:00 | AAPL | Stock | 3.1064 | 3.1096 | 3.1025 | 3.1067 | 9819040.0 |
| 2008-12-29 10:00:00 | AAPL | Stock | 3.1064 | 3.1114 | 3.1029 | 3.1086 | 7272524.0 |
| 2008-12-29 10:05:00 | AAPL | Stock | 3.1085 | 3.1096 | 3.0936 | 3.0954 | 8638756.0 |
| 2008-12-29 10:10:00 | AAPL | Stock | 3.0952 | 3.1004 | 3.0946 | 3.1 | 6479536.0 |
| 2008-12-29 10:15:00 | AAPL | Stock | 3.1004 | 3.1014 | 3.0825 | 3.0836 | 9120384.0 |
| 2008-12-29 10:20:00 | AAPL | Stock | 3.0832 | 3.0879 | 3.0789 | 3.085 | 10212608.0 |
| 2008-12-29 10:25:00 | AAPL | Stock | 3.0854 | 3.0868 | 3.075 | 3.0821 | 8822800.0 |
| 2008-12-29 10:30:00 | AAPL | Stock | 3.0821 | 3.0879 | 3.0782 | 3.0861 | 6919276.0 |
| 2008-12-29 10:35:00 | AAPL | Stock | 3.0864 | 3.0868 | 3.0764 | 3.0793 | 6123740.0 |
| 2008-12-29 10:40:00 | AAPL | Stock | 3.0799 | 3.0854 | 3.0718 | 3.0743 | 8141056.0 |
| 2008-12-29 10:45:00 | AAPL | Stock | 3.0739 | 3.0804 | 3.0707 | 3.0796 | 8432704.0 |
| 2008-12-29 10:50:00 | AAPL | Stock | 3.08 | 3.0857 | 3.0771 | 3.0825 | 5999728.0 |
| 2008-12-29 10:55:00 | AAPL | Stock | 3.0825 | 3.0896 | 3.0814 | 3.0839 | 6550684.0 |
| 2008-12-29 11:00:00 | AAPL | Stock | 3.0836 | 3.0864 | 3.0804 | 3.0846 | 4338096.0 |
| 2008-12-29 11:05:00 | AAPL | Stock | 3.0846 | 3.0857 | 3.0725 | 3.075 | 7223860.0 |
| 2008-12-29 11:10:00 | AAPL | Stock | 3.075 | 3.0814 | 3.0732 | 3.0782 | 5382076.0 |
| 2008-12-29 11:15:00 | AAPL | Stock | 3.0779 | 3.0829 | 3.0761 | 3.0807 | 4439876.0 |
> showing 50 of 309,474 rows — these rows as CSV