PREVIEW / stock_5min / 2010-11-26
file: by_date/stock_5min/2010/2010-11-26.parquet size: 2.6 MB rows: 171,520 symbols: 3,376
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 |
|---|---|---|---|---|---|---|---|
| 2010-11-26 04:00:00 | AAPL | Stock | 11.2429 | 11.2429 | 11.2429 | 11.2429 | 2800.0 |
| 2010-11-26 04:05:00 | AAPL | Stock | 11.1704 | 11.1704 | 11.1679 | 11.1679 | 33600.0 |
| 2010-11-26 04:20:00 | AAPL | Stock | 11.1721 | 11.1721 | 11.1543 | 11.1543 | 5600.0 |
| 2010-11-26 04:40:00 | AAPL | Stock | 11.0957 | 11.0957 | 11.0957 | 11.0957 | 2800.0 |
| 2010-11-26 05:05:00 | AAPL | Stock | 11.1071 | 11.1071 | 11.1071 | 11.1071 | 2800.0 |
| 2010-11-26 05:10:00 | AAPL | Stock | 11.1214 | 11.1214 | 11.1214 | 11.1214 | 2800.0 |
| 2010-11-26 05:20:00 | AAPL | Stock | 11.1161 | 11.1161 | 11.0804 | 11.0804 | 5600.0 |
| 2010-11-26 05:25:00 | AAPL | Stock | 11.1161 | 11.1161 | 11.1161 | 11.1161 | 5600.0 |
| 2010-11-26 05:30:00 | AAPL | Stock | 11.0911 | 11.0911 | 11.0911 | 11.0911 | 2800.0 |
| 2010-11-26 06:10:00 | AAPL | Stock | 11.0982 | 11.0982 | 11.0982 | 11.0982 | 2800.0 |
| 2010-11-26 06:15:00 | AAPL | Stock | 11.0982 | 11.0982 | 11.0982 | 11.0982 | 5600.0 |
| 2010-11-26 06:20:00 | AAPL | Stock | 11.1161 | 11.1161 | 11.1161 | 11.1161 | 2800.0 |
| 2010-11-26 06:30:00 | AAPL | Stock | 11.1061 | 11.1061 | 11.1061 | 11.1061 | 2800.0 |
| 2010-11-26 06:45:00 | AAPL | Stock | 11.1071 | 11.1071 | 11.1071 | 11.1071 | 19600.0 |
| 2010-11-26 06:50:00 | AAPL | Stock | 11.1071 | 11.125 | 11.1071 | 11.125 | 28000.0 |
| 2010-11-26 06:55:00 | AAPL | Stock | 11.125 | 11.1282 | 11.125 | 11.1282 | 12600.0 |
| 2010-11-26 07:00:00 | AAPL | Stock | 11.1271 | 11.1336 | 11.1271 | 11.1336 | 16800.0 |
| 2010-11-26 07:10:00 | AAPL | Stock | 11.1375 | 11.1429 | 11.1375 | 11.1429 | 5600.0 |
| 2010-11-26 07:15:00 | AAPL | Stock | 11.1611 | 11.1786 | 11.1611 | 11.1786 | 103320.0 |
| 2010-11-26 07:20:00 | AAPL | Stock | 11.1786 | 11.2118 | 11.1346 | 11.2118 | 94472.0 |
| 2010-11-26 07:25:00 | AAPL | Stock | 11.1854 | 11.1857 | 11.1764 | 11.1768 | 68208.0 |
| 2010-11-26 07:30:00 | AAPL | Stock | 11.1746 | 11.1746 | 11.1643 | 11.1643 | 8400.0 |
| 2010-11-26 07:35:00 | AAPL | Stock | 11.1643 | 11.1786 | 11.1643 | 11.1643 | 32228.0 |
| 2010-11-26 07:40:00 | AAPL | Stock | 11.1696 | 11.1696 | 11.1696 | 11.1696 | 3752.0 |
| 2010-11-26 07:45:00 | AAPL | Stock | 11.1661 | 11.1779 | 11.1661 | 11.1661 | 17360.0 |
| 2010-11-26 07:50:00 | AAPL | Stock | 11.1696 | 11.1821 | 11.1696 | 11.1786 | 27636.0 |
| 2010-11-26 07:55:00 | AAPL | Stock | 11.175 | 11.1946 | 11.175 | 11.1907 | 70000.0 |
| 2010-11-26 08:00:00 | AAPL | Stock | 11.1879 | 11.1946 | 11.1786 | 11.1918 | 322084.0 |
| 2010-11-26 08:05:00 | AAPL | Stock | 11.1893 | 11.1921 | 11.1832 | 11.1886 | 226184.0 |
| 2010-11-26 08:10:00 | AAPL | Stock | 11.1875 | 11.2036 | 11.185 | 11.2029 | 462280.0 |
| 2010-11-26 08:15:00 | AAPL | Stock | 11.2032 | 11.205 | 11.1875 | 11.1929 | 358960.0 |
| 2010-11-26 08:20:00 | AAPL | Stock | 11.195 | 11.1964 | 11.1893 | 11.1896 | 207312.0 |
| 2010-11-26 08:25:00 | AAPL | Stock | 11.1918 | 11.1918 | 11.1804 | 11.1804 | 368060.0 |
| 2010-11-26 08:30:00 | AAPL | Stock | 11.1807 | 11.1971 | 11.1793 | 11.1954 | 558292.0 |
| 2010-11-26 08:35:00 | AAPL | Stock | 11.1939 | 11.1975 | 11.1879 | 11.1879 | 113400.0 |
| 2010-11-26 08:40:00 | AAPL | Stock | 11.1857 | 11.1911 | 11.1854 | 11.1875 | 201684.0 |
| 2010-11-26 08:45:00 | AAPL | Stock | 11.1918 | 11.1964 | 11.1882 | 11.1946 | 315952.0 |
| 2010-11-26 08:50:00 | AAPL | Stock | 11.1946 | 11.195 | 11.1893 | 11.1907 | 125552.0 |
| 2010-11-26 08:55:00 | AAPL | Stock | 11.1939 | 11.2018 | 11.1925 | 11.2018 | 628432.0 |
| 2010-11-26 09:00:00 | AAPL | Stock | 11.2018 | 11.2082 | 11.1986 | 11.2061 | 310688.0 |
| 2010-11-26 09:05:00 | AAPL | Stock | 11.2068 | 11.2296 | 11.2036 | 11.2254 | 601468.0 |
| 2010-11-26 09:10:00 | AAPL | Stock | 11.2254 | 11.23 | 11.2214 | 11.2243 | 392112.0 |
| 2010-11-26 09:15:00 | AAPL | Stock | 11.2239 | 11.2254 | 11.2143 | 11.2236 | 227724.0 |
| 2010-11-26 09:20:00 | AAPL | Stock | 11.2218 | 11.2218 | 11.2061 | 11.2061 | 149800.0 |
| 2010-11-26 09:25:00 | AAPL | Stock | 11.2057 | 11.2125 | 11.2057 | 11.2064 | 36400.0 |
| 2010-11-26 09:30:00 | AAPL | Stock | 11.2082 | 11.2182 | 11.1764 | 11.2146 | 16391704.0 |
| 2010-11-26 09:35:00 | AAPL | Stock | 11.2146 | 11.2471 | 11.2107 | 11.2232 | 10925628.0 |
| 2010-11-26 09:40:00 | AAPL | Stock | 11.225 | 11.2568 | 11.2143 | 11.2429 | 10111808.0 |
| 2010-11-26 09:45:00 | AAPL | Stock | 11.2429 | 11.2589 | 11.2325 | 11.2461 | 6438152.0 |
| 2010-11-26 09:50:00 | AAPL | Stock | 11.2464 | 11.2939 | 11.2439 | 11.2834 | 13700372.0 |
> showing 50 of 171,520 rows — these rows as CSV