PREVIEW / stock_5min / 2010-07-30
file: by_date/stock_5min/2010/2010-07-30.parquet size: 4.7 MB rows: 320,036 symbols: 3,471
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-07-30 05:45:00 | AAPL | Stock | 9.1982 | 9.1982 | 9.1982 | 9.1982 | 2800.0 |
| 2010-07-30 06:45:00 | AAPL | Stock | 9.185 | 9.185 | 9.185 | 9.185 | 41720.0 |
| 2010-07-30 06:50:00 | AAPL | Stock | 9.185 | 9.185 | 9.185 | 9.185 | 5600.0 |
| 2010-07-30 06:55:00 | AAPL | Stock | 9.185 | 9.185 | 9.185 | 9.185 | 5600.0 |
| 2010-07-30 07:00:00 | AAPL | Stock | 9.1846 | 9.2075 | 9.1846 | 9.2075 | 12600.0 |
| 2010-07-30 07:30:00 | AAPL | Stock | 9.1786 | 9.1786 | 9.1782 | 9.1786 | 11200.0 |
| 2010-07-30 07:35:00 | AAPL | Stock | 9.1786 | 9.1786 | 9.1786 | 9.1786 | 2800.0 |
| 2010-07-30 07:40:00 | AAPL | Stock | 9.1789 | 9.1789 | 9.1789 | 9.1789 | 2800.0 |
| 2010-07-30 07:50:00 | AAPL | Stock | 9.1846 | 9.1904 | 9.1846 | 9.1904 | 19600.0 |
| 2010-07-30 07:55:00 | AAPL | Stock | 9.185 | 9.185 | 9.185 | 9.185 | 2800.0 |
| 2010-07-30 08:00:00 | AAPL | Stock | 9.1846 | 9.1893 | 9.1743 | 9.1743 | 230608.0 |
| 2010-07-30 08:05:00 | AAPL | Stock | 9.1714 | 9.1732 | 9.1657 | 9.1704 | 42000.0 |
| 2010-07-30 08:10:00 | AAPL | Stock | 9.1679 | 9.1764 | 9.1625 | 9.1764 | 171444.0 |
| 2010-07-30 08:15:00 | AAPL | Stock | 9.1761 | 9.1768 | 9.1714 | 9.1764 | 58016.0 |
| 2010-07-30 08:20:00 | AAPL | Stock | 9.1746 | 9.1757 | 9.1679 | 9.1696 | 184940.0 |
| 2010-07-30 08:25:00 | AAPL | Stock | 9.1707 | 9.175 | 9.1707 | 9.175 | 47600.0 |
| 2010-07-30 08:30:00 | AAPL | Stock | 9.17 | 9.1786 | 9.1446 | 9.1707 | 563976.0 |
| 2010-07-30 08:35:00 | AAPL | Stock | 9.1711 | 9.1789 | 9.1582 | 9.1779 | 390992.0 |
| 2010-07-30 08:40:00 | AAPL | Stock | 9.1714 | 9.175 | 9.1439 | 9.1586 | 573272.0 |
| 2010-07-30 08:45:00 | AAPL | Stock | 9.1589 | 9.1604 | 9.145 | 9.1546 | 450436.0 |
| 2010-07-30 08:50:00 | AAPL | Stock | 9.155 | 9.1571 | 9.1471 | 9.1486 | 176400.0 |
| 2010-07-30 08:55:00 | AAPL | Stock | 9.1479 | 9.1546 | 9.1446 | 9.1514 | 334488.0 |
| 2010-07-30 09:00:00 | AAPL | Stock | 9.1514 | 9.1518 | 9.1464 | 9.1464 | 120960.0 |
| 2010-07-30 09:05:00 | AAPL | Stock | 9.1464 | 9.1621 | 9.1464 | 9.16 | 321328.0 |
| 2010-07-30 09:10:00 | AAPL | Stock | 9.1586 | 9.1586 | 9.1457 | 9.1471 | 103600.0 |
| 2010-07-30 09:15:00 | AAPL | Stock | 9.1454 | 9.1454 | 9.1321 | 9.1429 | 319060.0 |
| 2010-07-30 09:20:00 | AAPL | Stock | 9.1404 | 9.1464 | 9.1393 | 9.1429 | 185724.0 |
| 2010-07-30 09:25:00 | AAPL | Stock | 9.1429 | 9.1468 | 9.1389 | 9.1468 | 100912.0 |
| 2010-07-30 09:30:00 | AAPL | Stock | 9.1421 | 9.1643 | 9.1268 | 9.1563 | 16958564.0 |
| 2010-07-30 09:35:00 | AAPL | Stock | 9.1561 | 9.1571 | 9.1111 | 9.1161 | 13956040.0 |
| 2010-07-30 09:40:00 | AAPL | Stock | 9.1135 | 9.145 | 9.1036 | 9.1307 | 16574880.0 |
| 2010-07-30 09:45:00 | AAPL | Stock | 9.1311 | 9.1596 | 9.1204 | 9.1262 | 12601568.0 |
| 2010-07-30 09:50:00 | AAPL | Stock | 9.1282 | 9.1357 | 9.1196 | 9.1332 | 5845532.0 |
| 2010-07-30 09:55:00 | AAPL | Stock | 9.1301 | 9.1511 | 9.1232 | 9.1318 | 13003340.0 |
| 2010-07-30 10:00:00 | AAPL | Stock | 9.1354 | 9.1875 | 9.1304 | 9.1796 | 10575516.0 |
| 2010-07-30 10:05:00 | AAPL | Stock | 9.1807 | 9.2061 | 9.1768 | 9.1771 | 11015284.0 |
| 2010-07-30 10:10:00 | AAPL | Stock | 9.1775 | 9.1911 | 9.1671 | 9.1821 | 9145248.0 |
| 2010-07-30 10:15:00 | AAPL | Stock | 9.1821 | 9.1946 | 9.1589 | 9.1621 | 6895028.0 |
| 2010-07-30 10:20:00 | AAPL | Stock | 9.1614 | 9.1786 | 9.1575 | 9.1679 | 4785956.0 |
| 2010-07-30 10:25:00 | AAPL | Stock | 9.1689 | 9.1857 | 9.1682 | 9.1843 | 4734548.0 |
| 2010-07-30 10:30:00 | AAPL | Stock | 9.1821 | 9.2243 | 9.1807 | 9.2071 | 13865768.0 |
| 2010-07-30 10:35:00 | AAPL | Stock | 9.2089 | 9.2232 | 9.1989 | 9.2189 | 7131460.0 |
| 2010-07-30 10:40:00 | AAPL | Stock | 9.2186 | 9.2582 | 9.215 | 9.2425 | 13540268.0 |
| 2010-07-30 10:45:00 | AAPL | Stock | 9.2443 | 9.2536 | 9.2289 | 9.2448 | 8137780.0 |
| 2010-07-30 10:50:00 | AAPL | Stock | 9.2439 | 9.2486 | 9.2161 | 9.2181 | 6167588.0 |
| 2010-07-30 10:55:00 | AAPL | Stock | 9.2189 | 9.2343 | 9.2143 | 9.2286 | 4233068.0 |
| 2010-07-30 11:00:00 | AAPL | Stock | 9.2271 | 9.2425 | 9.2093 | 9.235 | 5842732.0 |
| 2010-07-30 11:05:00 | AAPL | Stock | 9.2367 | 9.2379 | 9.225 | 9.2299 | 1799280.0 |
| 2010-07-30 11:10:00 | AAPL | Stock | 9.2293 | 9.2293 | 9.2175 | 9.2268 | 3015852.0 |
| 2010-07-30 11:15:00 | AAPL | Stock | 9.2271 | 9.2304 | 9.2146 | 9.2175 | 2056488.0 |
> showing 50 of 320,036 rows — these rows as CSV