PREVIEW / stock_5min / 2006-12-12
file: by_date/stock_5min/2006/2006-12-12.parquet size: 3.3 MB rows: 238,676 symbols: 2,462
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 |
|---|---|---|---|---|---|---|---|
| 2006-12-12 07:25:00 | AAPL | Stock | 3.1768 | 3.1768 | 3.1768 | 3.1768 | 11200.0 |
| 2006-12-12 07:50:00 | AAPL | Stock | 3.1764 | 3.1768 | 3.1764 | 3.1764 | 14000.0 |
| 2006-12-12 07:55:00 | AAPL | Stock | 3.1768 | 3.1768 | 3.1764 | 3.1768 | 8400.0 |
| 2006-12-12 08:00:00 | AAPL | Stock | 3.175 | 3.1829 | 3.175 | 3.1782 | 673064.0 |
| 2006-12-12 08:05:00 | AAPL | Stock | 3.1768 | 3.1768 | 3.1729 | 3.1729 | 74200.0 |
| 2006-12-12 08:10:00 | AAPL | Stock | 3.1743 | 3.1779 | 3.1696 | 3.1696 | 248780.0 |
| 2006-12-12 08:15:00 | AAPL | Stock | 3.1686 | 3.1732 | 3.1686 | 3.1732 | 19600.0 |
| 2006-12-12 08:20:00 | AAPL | Stock | 3.1729 | 3.1732 | 3.1729 | 3.1732 | 57400.0 |
| 2006-12-12 08:25:00 | AAPL | Stock | 3.1725 | 3.1736 | 3.1725 | 3.1725 | 78400.0 |
| 2006-12-12 08:30:00 | AAPL | Stock | 3.1736 | 3.175 | 3.1721 | 3.1721 | 30296.0 |
| 2006-12-12 08:35:00 | AAPL | Stock | 3.1714 | 3.1714 | 3.17 | 3.17 | 44800.0 |
| 2006-12-12 08:40:00 | AAPL | Stock | 3.1696 | 3.1696 | 3.1679 | 3.1679 | 70000.0 |
| 2006-12-12 08:45:00 | AAPL | Stock | 3.1689 | 3.1696 | 3.1661 | 3.1679 | 117600.0 |
| 2006-12-12 08:50:00 | AAPL | Stock | 3.1679 | 3.1679 | 3.1671 | 3.1675 | 58044.0 |
| 2006-12-12 08:55:00 | AAPL | Stock | 3.1671 | 3.1679 | 3.1671 | 3.1679 | 13244.0 |
| 2006-12-12 09:00:00 | AAPL | Stock | 3.1671 | 3.17 | 3.1671 | 3.1693 | 42000.0 |
| 2006-12-12 09:05:00 | AAPL | Stock | 3.1696 | 3.1696 | 3.1696 | 3.1696 | 2800.0 |
| 2006-12-12 09:10:00 | AAPL | Stock | 3.1671 | 3.1689 | 3.165 | 3.1661 | 141400.0 |
| 2006-12-12 09:15:00 | AAPL | Stock | 3.1671 | 3.1671 | 3.1657 | 3.1661 | 1459892.0 |
| 2006-12-12 09:20:00 | AAPL | Stock | 3.1661 | 3.1661 | 3.1657 | 3.1657 | 73360.0 |
| 2006-12-12 09:25:00 | AAPL | Stock | 3.1654 | 3.1654 | 3.1607 | 3.165 | 308000.0 |
| 2006-12-12 09:30:00 | AAPL | Stock | 3.1646 | 3.1686 | 3.1518 | 3.1621 | 15447600.0 |
| 2006-12-12 09:35:00 | AAPL | Stock | 3.1614 | 3.1704 | 3.1614 | 3.1696 | 8223600.0 |
| 2006-12-12 09:40:00 | AAPL | Stock | 3.1696 | 3.1729 | 3.1604 | 3.1618 | 10037972.0 |
| 2006-12-12 09:45:00 | AAPL | Stock | 3.1618 | 3.1707 | 3.1589 | 3.1689 | 6871424.0 |
| 2006-12-12 09:50:00 | AAPL | Stock | 3.1693 | 3.1721 | 3.1596 | 3.16 | 8661156.0 |
| 2006-12-12 09:55:00 | AAPL | Stock | 3.16 | 3.1654 | 3.1557 | 3.16 | 6765892.0 |
| 2006-12-12 10:00:00 | AAPL | Stock | 3.16 | 3.1629 | 3.1407 | 3.1411 | 16954476.0 |
| 2006-12-12 10:05:00 | AAPL | Stock | 3.1411 | 3.15 | 3.1179 | 3.1193 | 45590552.0 |
| 2006-12-12 10:10:00 | AAPL | Stock | 3.1186 | 3.1196 | 3.0825 | 3.1036 | 59948644.0 |
| 2006-12-12 10:15:00 | AAPL | Stock | 3.1036 | 3.1268 | 3.1029 | 3.1193 | 42295008.0 |
| 2006-12-12 10:20:00 | AAPL | Stock | 3.1193 | 3.1211 | 3.1046 | 3.1061 | 20976340.0 |
| 2006-12-12 10:25:00 | AAPL | Stock | 3.1064 | 3.1196 | 3.1046 | 3.1161 | 12066936.0 |
| 2006-12-12 10:30:00 | AAPL | Stock | 3.1157 | 3.1296 | 3.1154 | 3.1279 | 19480104.0 |
| 2006-12-12 10:35:00 | AAPL | Stock | 3.1275 | 3.1307 | 3.1189 | 3.1232 | 11860548.0 |
| 2006-12-12 10:40:00 | AAPL | Stock | 3.1225 | 3.1375 | 3.1225 | 3.1311 | 15124004.0 |
| 2006-12-12 10:45:00 | AAPL | Stock | 3.1307 | 3.1321 | 3.1179 | 3.1225 | 12119240.0 |
| 2006-12-12 10:50:00 | AAPL | Stock | 3.1218 | 3.1307 | 3.1218 | 3.1271 | 6979700.0 |
| 2006-12-12 10:55:00 | AAPL | Stock | 3.1282 | 3.1304 | 3.1239 | 3.1268 | 9551864.0 |
| 2006-12-12 11:00:00 | AAPL | Stock | 3.1271 | 3.1286 | 3.1154 | 3.1189 | 9692508.0 |
| 2006-12-12 11:05:00 | AAPL | Stock | 3.1188 | 3.1232 | 3.1157 | 3.1221 | 7099036.0 |
| 2006-12-12 11:10:00 | AAPL | Stock | 3.1225 | 3.1243 | 3.1107 | 3.1154 | 7786744.0 |
| 2006-12-12 11:15:00 | AAPL | Stock | 3.1157 | 3.1229 | 3.1136 | 3.1168 | 4194428.0 |
| 2006-12-12 11:20:00 | AAPL | Stock | 3.1164 | 3.1207 | 3.1143 | 3.1175 | 3660272.0 |
| 2006-12-12 11:25:00 | AAPL | Stock | 3.1171 | 3.1236 | 3.1168 | 3.1214 | 3783836.0 |
| 2006-12-12 11:30:00 | AAPL | Stock | 3.119 | 3.1204 | 3.115 | 3.1192 | 3380776.0 |
| 2006-12-12 11:35:00 | AAPL | Stock | 3.1189 | 3.1204 | 3.1139 | 3.1154 | 3853556.0 |
| 2006-12-12 11:40:00 | AAPL | Stock | 3.1154 | 3.1154 | 3.1071 | 3.1132 | 11209548.0 |
| 2006-12-12 11:45:00 | AAPL | Stock | 3.1129 | 3.1186 | 3.11 | 3.1157 | 7145236.0 |
| 2006-12-12 11:50:00 | AAPL | Stock | 3.1154 | 3.1157 | 3.1096 | 3.1103 | 5283292.0 |
> showing 50 of 238,676 rows — these rows as CSV