PREVIEW / stock_5min / 2004-12-03
file: by_date/stock_5min/2004/2004-12-03.parquet size: 2.6 MB rows: 188,691 symbols: 1,889
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 |
|---|---|---|---|---|---|---|---|
| 2004-12-03 08:00:00 | AAPL | Stock | 1.1777 | 1.1798 | 1.1777 | 1.1777 | 313432.0 |
| 2004-12-03 08:05:00 | AAPL | Stock | 1.1786 | 1.1804 | 1.1777 | 1.1786 | 505680.0 |
| 2004-12-03 08:10:00 | AAPL | Stock | 1.1786 | 1.1788 | 1.1768 | 1.1786 | 120400.0 |
| 2004-12-03 08:15:00 | AAPL | Stock | 1.1786 | 1.1795 | 1.1786 | 1.1795 | 56000.0 |
| 2004-12-03 08:20:00 | AAPL | Stock | 1.1798 | 1.1798 | 1.1795 | 1.1795 | 50400.0 |
| 2004-12-03 08:25:00 | AAPL | Stock | 1.1786 | 1.1795 | 1.1688 | 1.1741 | 1066800.0 |
| 2004-12-03 08:30:00 | AAPL | Stock | 1.1693 | 1.1741 | 1.1616 | 1.1616 | 1703296.0 |
| 2004-12-03 08:35:00 | AAPL | Stock | 1.1607 | 1.1643 | 1.1584 | 1.1634 | 1218560.0 |
| 2004-12-03 08:40:00 | AAPL | Stock | 1.1634 | 1.1675 | 1.1625 | 1.1652 | 661752.0 |
| 2004-12-03 08:45:00 | AAPL | Stock | 1.1666 | 1.1696 | 1.1643 | 1.1679 | 360080.0 |
| 2004-12-03 08:50:00 | AAPL | Stock | 1.1679 | 1.1679 | 1.1643 | 1.1652 | 322000.0 |
| 2004-12-03 08:55:00 | AAPL | Stock | 1.1654 | 1.1655 | 1.1652 | 1.1655 | 351120.0 |
| 2004-12-03 09:00:00 | AAPL | Stock | 1.1661 | 1.1668 | 1.1639 | 1.165 | 571760.0 |
| 2004-12-03 09:05:00 | AAPL | Stock | 1.1645 | 1.1645 | 1.1625 | 1.1625 | 1444800.0 |
| 2004-12-03 09:10:00 | AAPL | Stock | 1.1625 | 1.1625 | 1.1625 | 1.1625 | 148400.0 |
| 2004-12-03 09:15:00 | AAPL | Stock | 1.1645 | 1.1645 | 1.1625 | 1.1627 | 719600.0 |
| 2004-12-03 09:20:00 | AAPL | Stock | 1.1627 | 1.1627 | 1.1625 | 1.1625 | 173600.0 |
| 2004-12-03 09:25:00 | AAPL | Stock | 1.1625 | 1.1638 | 1.1518 | 1.1532 | 3126816.0 |
| 2004-12-03 09:30:00 | AAPL | Stock | 1.1529 | 1.1607 | 1.1466 | 1.1498 | 39588752.0 |
| 2004-12-03 09:35:00 | AAPL | Stock | 1.15 | 1.1555 | 1.1482 | 1.1546 | 29560720.0 |
| 2004-12-03 09:40:00 | AAPL | Stock | 1.1545 | 1.1598 | 1.1539 | 1.1559 | 23119712.0 |
| 2004-12-03 09:45:00 | AAPL | Stock | 1.1563 | 1.1588 | 1.1523 | 1.1584 | 17581424.0 |
| 2004-12-03 09:50:00 | AAPL | Stock | 1.1586 | 1.1596 | 1.153 | 1.1534 | 15995168.0 |
| 2004-12-03 09:55:00 | AAPL | Stock | 1.1534 | 1.1541 | 1.1473 | 1.1514 | 23810416.0 |
| 2004-12-03 10:00:00 | AAPL | Stock | 1.1516 | 1.1536 | 1.15 | 1.1525 | 16943640.0 |
| 2004-12-03 10:05:00 | AAPL | Stock | 1.1521 | 1.1523 | 1.138 | 1.1411 | 44870000.0 |
| 2004-12-03 10:10:00 | AAPL | Stock | 1.1409 | 1.142 | 1.1327 | 1.1357 | 44376640.0 |
| 2004-12-03 10:15:00 | AAPL | Stock | 1.1354 | 1.1357 | 1.1248 | 1.125 | 41271216.0 |
| 2004-12-03 10:20:00 | AAPL | Stock | 1.1246 | 1.1277 | 1.1191 | 1.1216 | 59294536.0 |
| 2004-12-03 10:25:00 | AAPL | Stock | 1.1221 | 1.1232 | 1.1102 | 1.1138 | 71618176.0 |
| 2004-12-03 10:30:00 | AAPL | Stock | 1.1141 | 1.1189 | 1.1116 | 1.1177 | 53581808.0 |
| 2004-12-03 10:35:00 | AAPL | Stock | 1.1175 | 1.1245 | 1.1171 | 1.1209 | 44666384.0 |
| 2004-12-03 10:40:00 | AAPL | Stock | 1.1209 | 1.1246 | 1.1136 | 1.1139 | 30089248.0 |
| 2004-12-03 10:45:00 | AAPL | Stock | 1.1139 | 1.1148 | 1.1027 | 1.1046 | 81278512.0 |
| 2004-12-03 10:50:00 | AAPL | Stock | 1.1046 | 1.1193 | 1.1036 | 1.1186 | 45715488.0 |
| 2004-12-03 10:55:00 | AAPL | Stock | 1.1177 | 1.1218 | 1.1159 | 1.1193 | 30704240.0 |
| 2004-12-03 11:00:00 | AAPL | Stock | 1.1193 | 1.1223 | 1.1177 | 1.1207 | 17157784.0 |
| 2004-12-03 11:05:00 | AAPL | Stock | 1.1205 | 1.1248 | 1.1196 | 1.1223 | 20374088.0 |
| 2004-12-03 11:10:00 | AAPL | Stock | 1.1223 | 1.123 | 1.1179 | 1.1195 | 17237024.0 |
| 2004-12-03 11:15:00 | AAPL | Stock | 1.1195 | 1.1207 | 1.1163 | 1.1189 | 15792784.0 |
| 2004-12-03 11:20:00 | AAPL | Stock | 1.1189 | 1.1198 | 1.115 | 1.1155 | 11418736.0 |
| 2004-12-03 11:25:00 | AAPL | Stock | 1.1157 | 1.1188 | 1.1114 | 1.1175 | 13510560.0 |
| 2004-12-03 11:30:00 | AAPL | Stock | 1.1175 | 1.1207 | 1.1168 | 1.1205 | 12846064.0 |
| 2004-12-03 11:35:00 | AAPL | Stock | 1.1204 | 1.1207 | 1.1157 | 1.1195 | 13807304.0 |
| 2004-12-03 11:40:00 | AAPL | Stock | 1.1195 | 1.1207 | 1.118 | 1.1186 | 6069168.0 |
| 2004-12-03 11:45:00 | AAPL | Stock | 1.1188 | 1.1204 | 1.1173 | 1.1186 | 3789912.0 |
| 2004-12-03 11:50:00 | AAPL | Stock | 1.1188 | 1.1196 | 1.1179 | 1.1189 | 7120792.0 |
| 2004-12-03 11:55:00 | AAPL | Stock | 1.1191 | 1.1193 | 1.1179 | 1.1182 | 2419760.0 |
| 2004-12-03 12:00:00 | AAPL | Stock | 1.1186 | 1.1195 | 1.1182 | 1.1186 | 2908416.0 |
| 2004-12-03 12:05:00 | AAPL | Stock | 1.1186 | 1.1205 | 1.1184 | 1.1198 | 3571736.0 |
> showing 50 of 188,691 rows — these rows as CSV