PREVIEW / stock_1min / 2007-08-16
file: by_date/stock_1min/2007/2007-08-16.parquet size: 14.2 MB rows: 1,114,926 symbols: 2,579
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-08-16 09:30:00 | AAPL | Stock | 4.1789 | 4.1836 | 4.1393 | 4.1711 | 30336376.0 |
| 2007-08-16 09:31:00 | AAPL | Stock | 4.1711 | 4.1871 | 4.1396 | 4.1711 | 11253172.0 |
| 2007-08-16 09:32:00 | AAPL | Stock | 4.1716 | 4.1911 | 4.1571 | 4.1896 | 11870264.0 |
| 2007-08-16 09:33:00 | AAPL | Stock | 4.19 | 4.2064 | 4.1746 | 4.1786 | 11559296.0 |
| 2007-08-16 09:34:00 | AAPL | Stock | 4.1775 | 4.2107 | 4.1721 | 4.1887 | 8639876.0 |
| 2007-08-16 09:35:00 | AAPL | Stock | 4.1911 | 4.2118 | 4.1746 | 4.2085 | 7099960.0 |
| 2007-08-16 09:36:00 | AAPL | Stock | 4.21 | 4.2143 | 4.1829 | 4.1946 | 7176708.0 |
| 2007-08-16 09:37:00 | AAPL | Stock | 4.1943 | 4.2018 | 4.1943 | 4.2 | 4869144.0 |
| 2007-08-16 09:38:00 | AAPL | Stock | 4.2 | 4.2057 | 4.1832 | 4.185 | 5554136.0 |
| 2007-08-16 09:39:00 | AAPL | Stock | 4.1857 | 4.1989 | 4.1714 | 4.1939 | 6271580.0 |
| 2007-08-16 09:40:00 | AAPL | Stock | 4.1939 | 4.1946 | 4.1821 | 4.1854 | 4863096.0 |
| 2007-08-16 09:41:00 | AAPL | Stock | 4.1864 | 4.1929 | 4.1821 | 4.1907 | 4008172.0 |
| 2007-08-16 09:42:00 | AAPL | Stock | 4.1911 | 4.1996 | 4.1886 | 4.1921 | 5245156.0 |
| 2007-08-16 09:43:00 | AAPL | Stock | 4.1907 | 4.2036 | 4.1875 | 4.2036 | 4879532.0 |
| 2007-08-16 09:44:00 | AAPL | Stock | 4.2021 | 4.2236 | 4.1929 | 4.2214 | 9668232.0 |
| 2007-08-16 09:45:00 | AAPL | Stock | 4.2221 | 4.2261 | 4.2143 | 4.2189 | 7246456.0 |
| 2007-08-16 09:46:00 | AAPL | Stock | 4.2193 | 4.2321 | 4.2179 | 4.2282 | 4390400.0 |
| 2007-08-16 09:47:00 | AAPL | Stock | 4.2279 | 4.2293 | 4.2007 | 4.2093 | 4749136.0 |
| 2007-08-16 09:48:00 | AAPL | Stock | 4.2093 | 4.2175 | 4.2029 | 4.2119 | 3705772.0 |
| 2007-08-16 09:49:00 | AAPL | Stock | 4.2118 | 4.2159 | 4.2046 | 4.21 | 3312064.0 |
| 2007-08-16 09:50:00 | AAPL | Stock | 4.2096 | 4.2154 | 4.1996 | 4.2003 | 2029664.0 |
| 2007-08-16 09:51:00 | AAPL | Stock | 4.2 | 4.2036 | 4.1814 | 4.185 | 4568452.0 |
| 2007-08-16 09:52:00 | AAPL | Stock | 4.1846 | 4.1886 | 4.1764 | 4.1868 | 5153596.0 |
| 2007-08-16 09:53:00 | AAPL | Stock | 4.1864 | 4.1946 | 4.1821 | 4.1873 | 3792712.0 |
| 2007-08-16 09:54:00 | AAPL | Stock | 4.1854 | 4.1871 | 4.1743 | 4.175 | 5132288.0 |
| 2007-08-16 09:55:00 | AAPL | Stock | 4.1746 | 4.1786 | 4.1561 | 4.1577 | 7901824.0 |
| 2007-08-16 09:56:00 | AAPL | Stock | 4.1629 | 4.1736 | 4.1568 | 4.1568 | 5397420.0 |
| 2007-08-16 09:57:00 | AAPL | Stock | 4.1568 | 4.1589 | 4.1466 | 4.1561 | 5060076.0 |
| 2007-08-16 09:58:00 | AAPL | Stock | 4.1546 | 4.1607 | 4.145 | 4.1539 | 6374200.0 |
| 2007-08-16 09:59:00 | AAPL | Stock | 4.1543 | 4.1557 | 4.1375 | 4.1407 | 8684984.0 |
| 2007-08-16 10:00:00 | AAPL | Stock | 4.1406 | 4.1421 | 4.1311 | 4.1357 | 6122900.0 |
| 2007-08-16 10:01:00 | AAPL | Stock | 4.1357 | 4.1446 | 4.1307 | 4.1371 | 8178352.0 |
| 2007-08-16 10:02:00 | AAPL | Stock | 4.1375 | 4.1411 | 4.1282 | 4.1286 | 5159028.0 |
| 2007-08-16 10:03:00 | AAPL | Stock | 4.1293 | 4.135 | 4.0725 | 4.0761 | 14690228.0 |
| 2007-08-16 10:04:00 | AAPL | Stock | 4.075 | 4.0996 | 4.0621 | 4.085 | 17065748.0 |
| 2007-08-16 10:05:00 | AAPL | Stock | 4.085 | 4.105 | 4.0843 | 4.1018 | 8687476.0 |
| 2007-08-16 10:06:00 | AAPL | Stock | 4.1018 | 4.1161 | 4.0982 | 4.1075 | 10676484.0 |
| 2007-08-16 10:07:00 | AAPL | Stock | 4.1082 | 4.11 | 4.0832 | 4.0843 | 8133944.0 |
| 2007-08-16 10:08:00 | AAPL | Stock | 4.0843 | 4.1071 | 4.0821 | 4.1061 | 6187048.0 |
| 2007-08-16 10:09:00 | AAPL | Stock | 4.1011 | 4.1239 | 4.1011 | 4.1218 | 7140140.0 |
| 2007-08-16 10:10:00 | AAPL | Stock | 4.1205 | 4.1221 | 4.1071 | 4.1139 | 6203596.0 |
| 2007-08-16 10:11:00 | AAPL | Stock | 4.1132 | 4.1236 | 4.1036 | 4.105 | 5397896.0 |
| 2007-08-16 10:12:00 | AAPL | Stock | 4.105 | 4.1179 | 4.1036 | 4.1129 | 4992204.0 |
| 2007-08-16 10:13:00 | AAPL | Stock | 4.1121 | 4.1218 | 4.1096 | 4.1171 | 3933356.0 |
| 2007-08-16 10:14:00 | AAPL | Stock | 4.1164 | 4.1336 | 4.1157 | 4.1227 | 5522916.0 |
| 2007-08-16 10:15:00 | AAPL | Stock | 4.1196 | 4.1232 | 4.1157 | 4.1207 | 2876468.0 |
| 2007-08-16 10:16:00 | AAPL | Stock | 4.1204 | 4.1261 | 4.1014 | 4.1093 | 5467616.0 |
| 2007-08-16 10:17:00 | AAPL | Stock | 4.1082 | 4.115 | 4.0929 | 4.0937 | 4851896.0 |
| 2007-08-16 10:18:00 | AAPL | Stock | 4.0925 | 4.0954 | 4.0789 | 4.0793 | 4914616.0 |
| 2007-08-16 10:19:00 | AAPL | Stock | 4.0821 | 4.0918 | 4.0754 | 4.0907 | 2866920.0 |
> showing 50 of 1,114,926 rows — these rows as CSV