PREVIEW / stock_5min / 2010-07-09
file: by_date/stock_5min/2010/2010-07-09.parquet size: 4.5 MB rows: 312,581 symbols: 3,456
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-09 05:15:00 | AAPL | Stock | 9.2321 | 9.2321 | 9.2321 | 9.2321 | 2800.0 |
| 2010-07-09 07:00:00 | AAPL | Stock | 9.2282 | 9.2286 | 9.2282 | 9.2282 | 44492.0 |
| 2010-07-09 07:05:00 | AAPL | Stock | 9.2282 | 9.2282 | 9.2282 | 9.2282 | 5600.0 |
| 2010-07-09 07:15:00 | AAPL | Stock | 9.2321 | 9.25 | 9.2321 | 9.2321 | 16632.0 |
| 2010-07-09 07:25:00 | AAPL | Stock | 9.2357 | 9.2357 | 9.2357 | 9.2357 | 5600.0 |
| 2010-07-09 07:30:00 | AAPL | Stock | 9.2321 | 9.2357 | 9.2321 | 9.2357 | 9828.0 |
| 2010-07-09 07:35:00 | AAPL | Stock | 9.2336 | 9.2336 | 9.2336 | 9.2336 | 5600.0 |
| 2010-07-09 07:45:00 | AAPL | Stock | 9.2336 | 9.2336 | 9.2318 | 9.2318 | 16800.0 |
| 2010-07-09 07:50:00 | AAPL | Stock | 9.2318 | 9.2318 | 9.2061 | 9.2061 | 34468.0 |
| 2010-07-09 07:55:00 | AAPL | Stock | 9.2054 | 9.2054 | 9.1786 | 9.1875 | 106400.0 |
| 2010-07-09 08:00:00 | AAPL | Stock | 9.2032 | 9.2032 | 9.1536 | 9.1761 | 361844.0 |
| 2010-07-09 08:05:00 | AAPL | Stock | 9.1721 | 9.2332 | 9.1518 | 9.1643 | 306068.0 |
| 2010-07-09 08:10:00 | AAPL | Stock | 9.1646 | 9.1696 | 9.115 | 9.115 | 284340.0 |
| 2010-07-09 08:15:00 | AAPL | Stock | 9.1296 | 9.1429 | 9.1296 | 9.1421 | 214956.0 |
| 2010-07-09 08:20:00 | AAPL | Stock | 9.1386 | 9.1568 | 9.1361 | 9.15 | 276640.0 |
| 2010-07-09 08:25:00 | AAPL | Stock | 9.1543 | 9.1568 | 9.1364 | 9.1375 | 152600.0 |
| 2010-07-09 08:30:00 | AAPL | Stock | 9.1357 | 9.1386 | 9.1161 | 9.1161 | 173460.0 |
| 2010-07-09 08:35:00 | AAPL | Stock | 9.1175 | 9.1289 | 9.1164 | 9.1282 | 111300.0 |
| 2010-07-09 08:40:00 | AAPL | Stock | 9.1257 | 9.1421 | 9.1257 | 9.1421 | 86716.0 |
| 2010-07-09 08:45:00 | AAPL | Stock | 9.1421 | 9.1507 | 9.1393 | 9.1393 | 159600.0 |
| 2010-07-09 08:50:00 | AAPL | Stock | 9.1379 | 9.1504 | 9.1379 | 9.1504 | 53200.0 |
| 2010-07-09 08:55:00 | AAPL | Stock | 9.1475 | 9.1536 | 9.1468 | 9.1536 | 73080.0 |
| 2010-07-09 09:00:00 | AAPL | Stock | 9.1539 | 9.1643 | 9.1539 | 9.1639 | 89600.0 |
| 2010-07-09 09:05:00 | AAPL | Stock | 9.1611 | 9.1632 | 9.1518 | 9.1525 | 173516.0 |
| 2010-07-09 09:10:00 | AAPL | Stock | 9.155 | 9.1657 | 9.1518 | 9.1518 | 191408.0 |
| 2010-07-09 09:15:00 | AAPL | Stock | 9.1518 | 9.1564 | 9.1443 | 9.1443 | 74200.0 |
| 2010-07-09 09:20:00 | AAPL | Stock | 9.1446 | 9.145 | 9.1404 | 9.1404 | 112000.0 |
| 2010-07-09 09:25:00 | AAPL | Stock | 9.1471 | 9.1821 | 9.1471 | 9.1736 | 386820.0 |
| 2010-07-09 09:30:00 | AAPL | Stock | 9.1743 | 9.1786 | 9.1129 | 9.1607 | 17581368.0 |
| 2010-07-09 09:35:00 | AAPL | Stock | 9.1589 | 9.2021 | 9.1511 | 9.1789 | 13113688.0 |
| 2010-07-09 09:40:00 | AAPL | Stock | 9.18 | 9.2232 | 9.1671 | 9.2143 | 11655448.0 |
| 2010-07-09 09:45:00 | AAPL | Stock | 9.215 | 9.2282 | 9.1846 | 9.1918 | 10722852.0 |
| 2010-07-09 09:50:00 | AAPL | Stock | 9.1898 | 9.1964 | 9.1561 | 9.1564 | 9102212.0 |
| 2010-07-09 09:55:00 | AAPL | Stock | 9.1579 | 9.1896 | 9.1561 | 9.1814 | 7584304.0 |
| 2010-07-09 10:00:00 | AAPL | Stock | 9.1804 | 9.2264 | 9.1793 | 9.2193 | 11236540.0 |
| 2010-07-09 10:05:00 | AAPL | Stock | 9.2218 | 9.2286 | 9.1832 | 9.1879 | 11484732.0 |
| 2010-07-09 10:10:00 | AAPL | Stock | 9.1879 | 9.2018 | 9.1789 | 9.185 | 6124524.0 |
| 2010-07-09 10:15:00 | AAPL | Stock | 9.1839 | 9.2007 | 9.1721 | 9.1968 | 6360144.0 |
| 2010-07-09 10:20:00 | AAPL | Stock | 9.1968 | 9.2143 | 9.1829 | 9.2139 | 7174524.0 |
| 2010-07-09 10:25:00 | AAPL | Stock | 9.2118 | 9.2171 | 9.1918 | 9.1969 | 4807572.0 |
| 2010-07-09 10:30:00 | AAPL | Stock | 9.1964 | 9.1979 | 9.1825 | 9.1853 | 3898272.0 |
| 2010-07-09 10:35:00 | AAPL | Stock | 9.185 | 9.1961 | 9.1686 | 9.1789 | 8337364.0 |
| 2010-07-09 10:40:00 | AAPL | Stock | 9.1789 | 9.1925 | 9.1704 | 9.1768 | 5140856.0 |
| 2010-07-09 10:45:00 | AAPL | Stock | 9.1768 | 9.1839 | 9.1607 | 9.1614 | 5108152.0 |
| 2010-07-09 10:50:00 | AAPL | Stock | 9.1614 | 9.1793 | 9.1611 | 9.1782 | 4496408.0 |
| 2010-07-09 10:55:00 | AAPL | Stock | 9.1782 | 9.1786 | 9.1643 | 9.1686 | 3206868.0 |
| 2010-07-09 11:00:00 | AAPL | Stock | 9.1686 | 9.1814 | 9.1611 | 9.1811 | 4297272.0 |
| 2010-07-09 11:05:00 | AAPL | Stock | 9.1807 | 9.1857 | 9.165 | 9.165 | 3753204.0 |
| 2010-07-09 11:10:00 | AAPL | Stock | 9.1646 | 9.1696 | 9.1593 | 9.1646 | 3365460.0 |
| 2010-07-09 11:15:00 | AAPL | Stock | 9.1668 | 9.1807 | 9.1614 | 9.1766 | 3464832.0 |
> showing 50 of 312,581 rows — these rows as CSV