PREVIEW / stock_5min / 2007-05-30
file: by_date/stock_5min/2007/2007-05-30.parquet size: 3.9 MB rows: 289,778 symbols: 3,019
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-05-30 09:30:00 | AAPL | Stock | 4.0821 | 4.0875 | 4.0546 | 4.0707 | 50930992.0 |
| 2007-05-30 09:35:00 | AAPL | Stock | 4.0714 | 4.0857 | 4.0604 | 4.0786 | 34106688.0 |
| 2007-05-30 09:40:00 | AAPL | Stock | 4.0786 | 4.0804 | 4.0661 | 4.0665 | 24879344.0 |
| 2007-05-30 09:45:00 | AAPL | Stock | 4.0693 | 4.0768 | 4.0679 | 4.0729 | 15588524.0 |
| 2007-05-30 09:50:00 | AAPL | Stock | 4.0729 | 4.1036 | 4.0718 | 4.1014 | 36203440.0 |
| 2007-05-30 09:55:00 | AAPL | Stock | 4.1011 | 4.1068 | 4.0736 | 4.1018 | 30412704.0 |
| 2007-05-30 10:00:00 | AAPL | Stock | 4.1021 | 4.1229 | 4.0982 | 4.1186 | 49210336.0 |
| 2007-05-30 10:05:00 | AAPL | Stock | 4.1193 | 4.1279 | 4.1118 | 4.1268 | 30137856.0 |
| 2007-05-30 10:10:00 | AAPL | Stock | 4.1268 | 4.1354 | 4.1221 | 4.1286 | 30025548.0 |
| 2007-05-30 10:15:00 | AAPL | Stock | 4.1286 | 4.145 | 4.1286 | 4.1425 | 33103532.0 |
| 2007-05-30 10:20:00 | AAPL | Stock | 4.1425 | 4.1436 | 4.125 | 4.13 | 21306936.0 |
| 2007-05-30 10:25:00 | AAPL | Stock | 4.13 | 4.1304 | 4.1179 | 4.1189 | 23708440.0 |
| 2007-05-30 10:30:00 | AAPL | Stock | 4.1196 | 4.1232 | 4.1071 | 4.1086 | 26861044.0 |
| 2007-05-30 10:35:00 | AAPL | Stock | 4.1089 | 4.1154 | 4.1071 | 4.1104 | 20149360.0 |
| 2007-05-30 10:40:00 | AAPL | Stock | 4.1096 | 4.1139 | 4.1071 | 4.1082 | 17327968.0 |
| 2007-05-30 10:45:00 | AAPL | Stock | 4.1086 | 4.1171 | 4.1071 | 4.1114 | 19429284.0 |
| 2007-05-30 10:50:00 | AAPL | Stock | 4.1118 | 4.1175 | 4.1107 | 4.115 | 9781492.0 |
| 2007-05-30 10:55:00 | AAPL | Stock | 4.1146 | 4.1232 | 4.1107 | 4.1182 | 14182392.0 |
| 2007-05-30 11:00:00 | AAPL | Stock | 4.1181 | 4.1214 | 4.1143 | 4.1157 | 8653400.0 |
| 2007-05-30 11:05:00 | AAPL | Stock | 4.1154 | 4.1207 | 4.1132 | 4.1143 | 12133212.0 |
| 2007-05-30 11:10:00 | AAPL | Stock | 4.1143 | 4.1179 | 4.1139 | 4.1168 | 7846132.0 |
| 2007-05-30 11:15:00 | AAPL | Stock | 4.1168 | 4.1171 | 4.1143 | 4.1168 | 8955772.0 |
| 2007-05-30 11:20:00 | AAPL | Stock | 4.1164 | 4.1339 | 4.1164 | 4.1336 | 19662440.0 |
| 2007-05-30 11:25:00 | AAPL | Stock | 4.134 | 4.1364 | 4.1289 | 4.1325 | 17753960.0 |
| 2007-05-30 11:30:00 | AAPL | Stock | 4.1325 | 4.1379 | 4.1314 | 4.1336 | 8532804.0 |
| 2007-05-30 11:35:00 | AAPL | Stock | 4.1336 | 4.1371 | 4.131 | 4.1343 | 8760360.0 |
| 2007-05-30 11:40:00 | AAPL | Stock | 4.1346 | 4.1443 | 4.1346 | 4.1418 | 18021136.0 |
| 2007-05-30 11:45:00 | AAPL | Stock | 4.1418 | 4.1429 | 4.1307 | 4.1325 | 11864748.0 |
| 2007-05-30 11:50:00 | AAPL | Stock | 4.1325 | 4.1346 | 4.1293 | 4.1343 | 5777016.0 |
| 2007-05-30 11:55:00 | AAPL | Stock | 4.1339 | 4.1354 | 4.1286 | 4.1296 | 5997908.0 |
| 2007-05-30 12:00:00 | AAPL | Stock | 4.1298 | 4.1318 | 4.1254 | 4.1318 | 7119140.0 |
| 2007-05-30 12:05:00 | AAPL | Stock | 4.1318 | 4.14 | 4.1314 | 4.1389 | 6025740.0 |
| 2007-05-30 12:10:00 | AAPL | Stock | 4.1386 | 4.1464 | 4.1347 | 4.1429 | 17447584.0 |
| 2007-05-30 12:15:00 | AAPL | Stock | 4.1432 | 4.1514 | 4.1425 | 4.1493 | 17854620.0 |
| 2007-05-30 12:20:00 | AAPL | Stock | 4.1489 | 4.1586 | 4.1464 | 4.155 | 14264012.0 |
| 2007-05-30 12:25:00 | AAPL | Stock | 4.155 | 4.1607 | 4.1521 | 4.1586 | 14037688.0 |
| 2007-05-30 12:30:00 | AAPL | Stock | 4.1586 | 4.1632 | 4.1561 | 4.1571 | 13370224.0 |
| 2007-05-30 12:35:00 | AAPL | Stock | 4.1564 | 4.1593 | 4.1532 | 4.1564 | 8890000.0 |
| 2007-05-30 12:40:00 | AAPL | Stock | 4.1571 | 4.1671 | 4.155 | 4.1646 | 9634968.0 |
| 2007-05-30 12:45:00 | AAPL | Stock | 4.1646 | 4.1704 | 4.1643 | 4.1668 | 10699584.0 |
| 2007-05-30 12:50:00 | AAPL | Stock | 4.1668 | 4.1768 | 4.1646 | 4.1729 | 15766660.0 |
| 2007-05-30 12:55:00 | AAPL | Stock | 4.1732 | 4.1846 | 4.1721 | 4.1846 | 20123656.0 |
| 2007-05-30 13:00:00 | AAPL | Stock | 4.1843 | 4.1846 | 4.1607 | 4.1625 | 26932948.0 |
| 2007-05-30 13:05:00 | AAPL | Stock | 4.1629 | 4.1821 | 4.1625 | 4.18 | 15935780.0 |
| 2007-05-30 13:10:00 | AAPL | Stock | 4.18 | 4.1893 | 4.1793 | 4.1871 | 18423552.0 |
| 2007-05-30 13:15:00 | AAPL | Stock | 4.1868 | 4.1896 | 4.1821 | 4.185 | 11532696.0 |
| 2007-05-30 13:20:00 | AAPL | Stock | 4.1846 | 4.1982 | 4.1846 | 4.1957 | 17477180.0 |
| 2007-05-30 13:25:00 | AAPL | Stock | 4.1961 | 4.2014 | 4.1904 | 4.1904 | 13630764.0 |
| 2007-05-30 13:30:00 | AAPL | Stock | 4.1907 | 4.2025 | 4.1879 | 4.2021 | 14598444.0 |
| 2007-05-30 13:35:00 | AAPL | Stock | 4.2025 | 4.2064 | 4.1971 | 4.201 | 19511744.0 |
> showing 50 of 289,778 rows — these rows as CSV