PREVIEW / stock_5min / 2009-10-21
file: by_date/stock_5min/2009/2009-10-21.parquet size: 4.7 MB rows: 318,271 symbols: 3,400
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-10-21 04:15:00 | AAPL | Stock | 7.1607 | 7.1607 | 7.1607 | 7.1607 | 2800.0 |
| 2009-10-21 04:25:00 | AAPL | Stock | 7.1343 | 7.1343 | 7.1343 | 7.1343 | 2800.0 |
| 2009-10-21 05:50:00 | AAPL | Stock | 7.1107 | 7.1107 | 7.1107 | 7.1107 | 8400.0 |
| 2009-10-21 06:35:00 | AAPL | Stock | 7.1082 | 7.1082 | 7.1082 | 7.1082 | 2800.0 |
| 2009-10-21 07:00:00 | AAPL | Stock | 7.1086 | 7.1179 | 7.1082 | 7.1179 | 22400.0 |
| 2009-10-21 07:10:00 | AAPL | Stock | 7.1179 | 7.1179 | 7.1179 | 7.1179 | 14000.0 |
| 2009-10-21 07:20:00 | AAPL | Stock | 7.1146 | 7.1146 | 7.1107 | 7.1107 | 39200.0 |
| 2009-10-21 07:25:00 | AAPL | Stock | 7.1225 | 7.1225 | 7.1107 | 7.1125 | 19600.0 |
| 2009-10-21 07:30:00 | AAPL | Stock | 7.1107 | 7.1114 | 7.1107 | 7.1107 | 27664.0 |
| 2009-10-21 07:35:00 | AAPL | Stock | 7.1071 | 7.1071 | 7.1071 | 7.1071 | 14840.0 |
| 2009-10-21 07:40:00 | AAPL | Stock | 7.1107 | 7.1125 | 7.1036 | 7.1125 | 58800.0 |
| 2009-10-21 07:45:00 | AAPL | Stock | 7.1071 | 7.1071 | 7.1036 | 7.1036 | 15316.0 |
| 2009-10-21 07:55:00 | AAPL | Stock | 7.1039 | 7.1189 | 7.1036 | 7.1189 | 64820.0 |
| 2009-10-21 08:00:00 | AAPL | Stock | 7.1164 | 7.125 | 7.1111 | 7.1186 | 283164.0 |
| 2009-10-21 08:05:00 | AAPL | Stock | 7.1186 | 7.1196 | 7.1071 | 7.1107 | 295372.0 |
| 2009-10-21 08:10:00 | AAPL | Stock | 7.1109 | 7.1239 | 7.1109 | 7.1236 | 171024.0 |
| 2009-10-21 08:15:00 | AAPL | Stock | 7.1236 | 7.125 | 7.1186 | 7.1214 | 114800.0 |
| 2009-10-21 08:20:00 | AAPL | Stock | 7.1186 | 7.1214 | 7.1179 | 7.1214 | 129248.0 |
| 2009-10-21 08:25:00 | AAPL | Stock | 7.1214 | 7.1232 | 7.1211 | 7.1232 | 92372.0 |
| 2009-10-21 08:30:00 | AAPL | Stock | 7.1236 | 7.1239 | 7.1154 | 7.1196 | 167048.0 |
| 2009-10-21 08:35:00 | AAPL | Stock | 7.1207 | 7.1243 | 7.1164 | 7.1168 | 250012.0 |
| 2009-10-21 08:40:00 | AAPL | Stock | 7.1168 | 7.1207 | 7.1125 | 7.1207 | 198912.0 |
| 2009-10-21 08:45:00 | AAPL | Stock | 7.1139 | 7.1161 | 7.1136 | 7.115 | 85400.0 |
| 2009-10-21 08:50:00 | AAPL | Stock | 7.1161 | 7.1229 | 7.1154 | 7.1229 | 187516.0 |
| 2009-10-21 08:55:00 | AAPL | Stock | 7.1214 | 7.1221 | 7.1161 | 7.1168 | 120008.0 |
| 2009-10-21 09:00:00 | AAPL | Stock | 7.1161 | 7.1193 | 7.1125 | 7.1129 | 93800.0 |
| 2009-10-21 09:05:00 | AAPL | Stock | 7.1125 | 7.1132 | 7.1004 | 7.1036 | 339080.0 |
| 2009-10-21 09:10:00 | AAPL | Stock | 7.1007 | 7.1046 | 7.0993 | 7.1043 | 288316.0 |
| 2009-10-21 09:15:00 | AAPL | Stock | 7.1039 | 7.1082 | 7.1036 | 7.1054 | 179200.0 |
| 2009-10-21 09:20:00 | AAPL | Stock | 7.1036 | 7.1071 | 7.1036 | 7.1071 | 95564.0 |
| 2009-10-21 09:25:00 | AAPL | Stock | 7.1068 | 7.1296 | 7.105 | 7.1243 | 1214584.0 |
| 2009-10-21 09:30:00 | AAPL | Stock | 7.1257 | 7.1486 | 7.1154 | 7.1475 | 30828168.0 |
| 2009-10-21 09:35:00 | AAPL | Stock | 7.1475 | 7.1786 | 7.1429 | 7.1732 | 25154304.0 |
| 2009-10-21 09:40:00 | AAPL | Stock | 7.1721 | 7.1757 | 7.1357 | 7.1743 | 16978892.0 |
| 2009-10-21 09:45:00 | AAPL | Stock | 7.1743 | 7.1768 | 7.1607 | 7.1693 | 11298224.0 |
| 2009-10-21 09:50:00 | AAPL | Stock | 7.1689 | 7.2046 | 7.1682 | 7.1971 | 23359728.0 |
| 2009-10-21 09:55:00 | AAPL | Stock | 7.1971 | 7.2118 | 7.1882 | 7.2104 | 14697424.0 |
| 2009-10-21 10:00:00 | AAPL | Stock | 7.21 | 7.2304 | 7.2025 | 7.2232 | 25731916.0 |
| 2009-10-21 10:05:00 | AAPL | Stock | 7.2236 | 7.245 | 7.2214 | 7.2436 | 21966728.0 |
| 2009-10-21 10:10:00 | AAPL | Stock | 7.2429 | 7.2482 | 7.2321 | 7.2472 | 17438568.0 |
| 2009-10-21 10:15:00 | AAPL | Stock | 7.2473 | 7.2832 | 7.2462 | 7.2768 | 33660312.0 |
| 2009-10-21 10:20:00 | AAPL | Stock | 7.2771 | 7.3029 | 7.2768 | 7.2932 | 30300452.0 |
| 2009-10-21 10:25:00 | AAPL | Stock | 7.2929 | 7.3079 | 7.2861 | 7.2993 | 22411788.0 |
| 2009-10-21 10:30:00 | AAPL | Stock | 7.2993 | 7.3011 | 7.2832 | 7.2932 | 18126192.0 |
| 2009-10-21 10:35:00 | AAPL | Stock | 7.2939 | 7.3039 | 7.2875 | 7.3 | 20792884.0 |
| 2009-10-21 10:40:00 | AAPL | Stock | 7.3007 | 7.3357 | 7.2979 | 7.3354 | 35497504.0 |
| 2009-10-21 10:45:00 | AAPL | Stock | 7.3357 | 7.3393 | 7.3161 | 7.3186 | 21994308.0 |
| 2009-10-21 10:50:00 | AAPL | Stock | 7.3189 | 7.3282 | 7.31 | 7.3246 | 14291116.0 |
| 2009-10-21 10:55:00 | AAPL | Stock | 7.3254 | 7.3304 | 7.3171 | 7.3271 | 11460484.0 |
| 2009-10-21 11:00:00 | AAPL | Stock | 7.3257 | 7.3339 | 7.3236 | 7.3329 | 11789316.0 |
> showing 50 of 318,271 rows — these rows as CSV