PREVIEW / stock_5min / 2009-06-29
file: by_date/stock_5min/2009/2009-06-29.parquet size: 4.6 MB rows: 326,500 symbols: 3,330
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 |
|---|---|---|---|---|---|---|---|
| 2009-06-29 05:30:00 | AAPL | Stock | 5.0679 | 5.0679 | 5.0679 | 5.0679 | 2800.0 |
| 2009-06-29 06:00:00 | AAPL | Stock | 5.0575 | 5.0575 | 5.0575 | 5.0575 | 2800.0 |
| 2009-06-29 06:15:00 | AAPL | Stock | 5.0661 | 5.0661 | 5.0661 | 5.0661 | 14000.0 |
| 2009-06-29 07:00:00 | AAPL | Stock | 5.1061 | 5.1061 | 5.1061 | 5.1061 | 8400.0 |
| 2009-06-29 07:05:00 | AAPL | Stock | 5.0914 | 5.0914 | 5.0886 | 5.0893 | 16240.0 |
| 2009-06-29 07:10:00 | AAPL | Stock | 5.0929 | 5.0929 | 5.0893 | 5.0893 | 28084.0 |
| 2009-06-29 07:20:00 | AAPL | Stock | 5.0893 | 5.0893 | 5.0893 | 5.0893 | 5600.0 |
| 2009-06-29 07:35:00 | AAPL | Stock | 5.1071 | 5.1071 | 5.1071 | 5.1071 | 28000.0 |
| 2009-06-29 07:50:00 | AAPL | Stock | 5.1132 | 5.1132 | 5.1132 | 5.1132 | 12880.0 |
| 2009-06-29 07:55:00 | AAPL | Stock | 5.1093 | 5.1168 | 5.1093 | 5.1168 | 94080.0 |
| 2009-06-29 08:00:00 | AAPL | Stock | 5.1211 | 5.1225 | 5.1125 | 5.1125 | 305340.0 |
| 2009-06-29 08:05:00 | AAPL | Stock | 5.1129 | 5.12 | 5.1125 | 5.12 | 79884.0 |
| 2009-06-29 08:10:00 | AAPL | Stock | 5.1182 | 5.1239 | 5.1179 | 5.1214 | 106820.0 |
| 2009-06-29 08:15:00 | AAPL | Stock | 5.1179 | 5.1375 | 5.1179 | 5.1375 | 304864.0 |
| 2009-06-29 08:20:00 | AAPL | Stock | 5.14 | 5.1404 | 5.1225 | 5.1293 | 192556.0 |
| 2009-06-29 08:25:00 | AAPL | Stock | 5.1279 | 5.1346 | 5.1268 | 5.1318 | 64596.0 |
| 2009-06-29 08:30:00 | AAPL | Stock | 5.1336 | 5.1339 | 5.1268 | 5.1293 | 63560.0 |
| 2009-06-29 08:35:00 | AAPL | Stock | 5.1279 | 5.1279 | 5.1254 | 5.1261 | 49560.0 |
| 2009-06-29 08:40:00 | AAPL | Stock | 5.1257 | 5.1268 | 5.1225 | 5.1225 | 353500.0 |
| 2009-06-29 08:45:00 | AAPL | Stock | 5.1254 | 5.1261 | 5.1196 | 5.1196 | 42000.0 |
| 2009-06-29 08:50:00 | AAPL | Stock | 5.1179 | 5.1214 | 5.1179 | 5.1211 | 49840.0 |
| 2009-06-29 08:55:00 | AAPL | Stock | 5.1214 | 5.1221 | 5.1143 | 5.1221 | 39816.0 |
| 2009-06-29 09:00:00 | AAPL | Stock | 5.1225 | 5.1225 | 5.1179 | 5.1179 | 35000.0 |
| 2009-06-29 09:05:00 | AAPL | Stock | 5.1186 | 5.1186 | 5.115 | 5.1168 | 82600.0 |
| 2009-06-29 09:10:00 | AAPL | Stock | 5.1179 | 5.1211 | 5.1168 | 5.1168 | 130228.0 |
| 2009-06-29 09:15:00 | AAPL | Stock | 5.1189 | 5.1229 | 5.1171 | 5.1211 | 219296.0 |
| 2009-06-29 09:20:00 | AAPL | Stock | 5.1232 | 5.1261 | 5.1221 | 5.1232 | 129500.0 |
| 2009-06-29 09:25:00 | AAPL | Stock | 5.1236 | 5.1271 | 5.1107 | 5.1232 | 1527484.0 |
| 2009-06-29 09:30:00 | AAPL | Stock | 5.1236 | 5.1411 | 5.1232 | 5.1304 | 21429016.0 |
| 2009-06-29 09:35:00 | AAPL | Stock | 5.1314 | 5.1314 | 5.0989 | 5.1171 | 20057940.0 |
| 2009-06-29 09:40:00 | AAPL | Stock | 5.1175 | 5.1193 | 5.1036 | 5.105 | 12503848.0 |
| 2009-06-29 09:45:00 | AAPL | Stock | 5.1047 | 5.1143 | 5.0954 | 5.1043 | 9504488.0 |
| 2009-06-29 09:50:00 | AAPL | Stock | 5.1039 | 5.1104 | 5.1001 | 5.1075 | 7689472.0 |
| 2009-06-29 09:55:00 | AAPL | Stock | 5.1076 | 5.1093 | 5.0871 | 5.1 | 9549820.0 |
| 2009-06-29 10:00:00 | AAPL | Stock | 5.1 | 5.1068 | 5.0854 | 5.0879 | 9443756.0 |
| 2009-06-29 10:05:00 | AAPL | Stock | 5.0882 | 5.0921 | 5.0668 | 5.0746 | 10971100.0 |
| 2009-06-29 10:10:00 | AAPL | Stock | 5.075 | 5.0907 | 5.0721 | 5.0907 | 6848100.0 |
| 2009-06-29 10:15:00 | AAPL | Stock | 5.0904 | 5.1018 | 5.0893 | 5.0989 | 7436548.0 |
| 2009-06-29 10:20:00 | AAPL | Stock | 5.0996 | 5.1 | 5.0868 | 5.0922 | 5149116.0 |
| 2009-06-29 10:25:00 | AAPL | Stock | 5.0936 | 5.0936 | 5.0793 | 5.0828 | 5483492.0 |
| 2009-06-29 10:30:00 | AAPL | Stock | 5.0821 | 5.0943 | 5.0782 | 5.0941 | 7250712.0 |
| 2009-06-29 10:35:00 | AAPL | Stock | 5.0943 | 5.0957 | 5.0814 | 5.0828 | 4912432.0 |
| 2009-06-29 10:40:00 | AAPL | Stock | 5.0825 | 5.0843 | 5.0696 | 5.0711 | 7824544.0 |
| 2009-06-29 10:45:00 | AAPL | Stock | 5.0711 | 5.0879 | 5.071 | 5.0804 | 6968416.0 |
| 2009-06-29 10:50:00 | AAPL | Stock | 5.08 | 5.0875 | 5.0789 | 5.0812 | 3957044.0 |
| 2009-06-29 10:55:00 | AAPL | Stock | 5.0811 | 5.0875 | 5.0779 | 5.0779 | 3509492.0 |
| 2009-06-29 11:00:00 | AAPL | Stock | 5.0779 | 5.0825 | 5.0764 | 5.0789 | 3662764.0 |
| 2009-06-29 11:05:00 | AAPL | Stock | 5.0782 | 5.0843 | 5.0729 | 5.0829 | 5563264.0 |
| 2009-06-29 11:10:00 | AAPL | Stock | 5.0829 | 5.1029 | 5.0821 | 5.099 | 7918120.0 |
| 2009-06-29 11:15:00 | AAPL | Stock | 5.099 | 5.1007 | 5.0904 | 5.0905 | 4397148.0 |
> showing 50 of 326,500 rows — these rows as CSV