PREVIEW / stock_1min / 2007-07-26
file: by_date/stock_1min/2007/2007-07-26.parquet size: 13.5 MB rows: 1,065,202 symbols: 2,552
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-07-26 09:30:00 | AAPL | Stock | 5.2111 | 5.2464 | 5.2061 | 5.2436 | 20703816.0 |
| 2007-07-26 09:31:00 | AAPL | Stock | 5.2432 | 5.2679 | 5.1829 | 5.261 | 17257548.0 |
| 2007-07-26 09:32:00 | AAPL | Stock | 5.2604 | 5.2664 | 5.2143 | 5.2143 | 15087940.0 |
| 2007-07-26 09:33:00 | AAPL | Stock | 5.2143 | 5.2191 | 5.1861 | 5.1968 | 12188820.0 |
| 2007-07-26 09:34:00 | AAPL | Stock | 5.1968 | 5.2054 | 5.1764 | 5.1868 | 14062720.0 |
| 2007-07-26 09:35:00 | AAPL | Stock | 5.1868 | 5.19 | 5.1232 | 5.125 | 15131116.0 |
| 2007-07-26 09:36:00 | AAPL | Stock | 5.125 | 5.1582 | 5.0732 | 5.1071 | 20718180.0 |
| 2007-07-26 09:37:00 | AAPL | Stock | 5.1139 | 5.1425 | 5.0996 | 5.1414 | 13641796.0 |
| 2007-07-26 09:38:00 | AAPL | Stock | 5.1425 | 5.1464 | 5.1286 | 5.1371 | 11451272.0 |
| 2007-07-26 09:39:00 | AAPL | Stock | 5.1368 | 5.155 | 5.1071 | 5.1504 | 11484844.0 |
| 2007-07-26 09:40:00 | AAPL | Stock | 5.15 | 5.1686 | 5.1071 | 5.1511 | 11164720.0 |
| 2007-07-26 09:41:00 | AAPL | Stock | 5.1518 | 5.1732 | 5.1429 | 5.1539 | 9448012.0 |
| 2007-07-26 09:42:00 | AAPL | Stock | 5.1732 | 5.1796 | 5.1651 | 5.1711 | 9841328.0 |
| 2007-07-26 09:43:00 | AAPL | Stock | 5.1721 | 5.18 | 5.1696 | 5.1739 | 6337688.0 |
| 2007-07-26 09:44:00 | AAPL | Stock | 5.1739 | 5.1875 | 5.1734 | 5.1857 | 9901332.0 |
| 2007-07-26 09:45:00 | AAPL | Stock | 5.1857 | 5.1875 | 5.1593 | 5.1611 | 12976768.0 |
| 2007-07-26 09:46:00 | AAPL | Stock | 5.1611 | 5.1746 | 5.1543 | 5.1743 | 6007148.0 |
| 2007-07-26 09:47:00 | AAPL | Stock | 5.1737 | 5.2054 | 5.1729 | 5.2054 | 12176808.0 |
| 2007-07-26 09:48:00 | AAPL | Stock | 5.2054 | 5.2054 | 5.1889 | 5.1946 | 9109828.0 |
| 2007-07-26 09:49:00 | AAPL | Stock | 5.1964 | 5.2143 | 5.1839 | 5.2143 | 10679480.0 |
| 2007-07-26 09:50:00 | AAPL | Stock | 5.2143 | 5.2321 | 5.1825 | 5.2068 | 14626192.0 |
| 2007-07-26 09:51:00 | AAPL | Stock | 5.2067 | 5.2146 | 5.1957 | 5.1996 | 10246264.0 |
| 2007-07-26 09:52:00 | AAPL | Stock | 5.2007 | 5.21 | 5.1739 | 5.2086 | 10619700.0 |
| 2007-07-26 09:53:00 | AAPL | Stock | 5.2086 | 5.2132 | 5.2056 | 5.2064 | 7049952.0 |
| 2007-07-26 09:54:00 | AAPL | Stock | 5.2061 | 5.2136 | 5.1746 | 5.1811 | 11520684.0 |
| 2007-07-26 09:55:00 | AAPL | Stock | 5.1802 | 5.2054 | 5.1762 | 5.1946 | 8026116.0 |
| 2007-07-26 09:56:00 | AAPL | Stock | 5.1964 | 5.205 | 5.19 | 5.2011 | 6262956.0 |
| 2007-07-26 09:57:00 | AAPL | Stock | 5.2018 | 5.2211 | 5.1971 | 5.2161 | 10461052.0 |
| 2007-07-26 09:58:00 | AAPL | Stock | 5.2157 | 5.2389 | 5.2093 | 5.2364 | 15618232.0 |
| 2007-07-26 09:59:00 | AAPL | Stock | 5.2364 | 5.2404 | 5.2143 | 5.22 | 10746176.0 |
| 2007-07-26 10:00:00 | AAPL | Stock | 5.2204 | 5.2296 | 5.2043 | 5.2164 | 10534692.0 |
| 2007-07-26 10:01:00 | AAPL | Stock | 5.2164 | 5.2171 | 5.1925 | 5.2007 | 10766588.0 |
| 2007-07-26 10:02:00 | AAPL | Stock | 5.2011 | 5.2143 | 5.1921 | 5.1971 | 9972256.0 |
| 2007-07-26 10:03:00 | AAPL | Stock | 5.1975 | 5.2054 | 5.1964 | 5.2029 | 6543348.0 |
| 2007-07-26 10:04:00 | AAPL | Stock | 5.2025 | 5.2168 | 5.1964 | 5.2143 | 7436352.0 |
| 2007-07-26 10:05:00 | AAPL | Stock | 5.2143 | 5.2193 | 5.1982 | 5.2 | 6231512.0 |
| 2007-07-26 10:06:00 | AAPL | Stock | 5.1993 | 5.2104 | 5.1943 | 5.2093 | 6692476.0 |
| 2007-07-26 10:07:00 | AAPL | Stock | 5.2089 | 5.2229 | 5.2029 | 5.2079 | 4499600.0 |
| 2007-07-26 10:08:00 | AAPL | Stock | 5.2079 | 5.2104 | 5.1993 | 5.2043 | 4429460.0 |
| 2007-07-26 10:09:00 | AAPL | Stock | 5.2043 | 5.2168 | 5.1964 | 5.2164 | 6831664.0 |
| 2007-07-26 10:10:00 | AAPL | Stock | 5.2157 | 5.2321 | 5.2028 | 5.2321 | 11480952.0 |
| 2007-07-26 10:11:00 | AAPL | Stock | 5.2321 | 5.2393 | 5.2028 | 5.2343 | 8914864.0 |
| 2007-07-26 10:12:00 | AAPL | Stock | 5.2346 | 5.2425 | 5.2028 | 5.2393 | 8481144.0 |
| 2007-07-26 10:13:00 | AAPL | Stock | 5.2389 | 5.2479 | 5.2389 | 5.2464 | 8221836.0 |
| 2007-07-26 10:14:00 | AAPL | Stock | 5.2464 | 5.2486 | 5.2028 | 5.2425 | 11012204.0 |
| 2007-07-26 10:15:00 | AAPL | Stock | 5.2418 | 5.2436 | 5.2028 | 5.2425 | 6758724.0 |
| 2007-07-26 10:16:00 | AAPL | Stock | 5.2436 | 5.25 | 5.2028 | 5.25 | 8843100.0 |
| 2007-07-26 10:17:00 | AAPL | Stock | 5.25 | 5.2511 | 5.2379 | 5.2386 | 6781040.0 |
| 2007-07-26 10:18:00 | AAPL | Stock | 5.2389 | 5.2448 | 5.2271 | 5.235 | 8164800.0 |
| 2007-07-26 10:19:00 | AAPL | Stock | 5.2343 | 5.2375 | 5.2282 | 5.2282 | 4159568.0 |
> showing 50 of 1,065,202 rows — these rows as CSV