PREVIEW / stock_5min / 2010-09-07
file: by_date/stock_5min/2010/2010-09-07.parquet size: 4.6 MB rows: 319,456 symbols: 3,466
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-09-07 04:05:00 | AAPL | Stock | 9.1782 | 9.1782 | 9.1782 | 9.1782 | 2800.0 |
| 2010-09-07 04:15:00 | AAPL | Stock | 9.1518 | 9.1518 | 9.1468 | 9.1468 | 16800.0 |
| 2010-09-07 04:20:00 | AAPL | Stock | 9.1468 | 9.1468 | 9.1468 | 9.1468 | 2800.0 |
| 2010-09-07 04:25:00 | AAPL | Stock | 9.1468 | 9.1604 | 9.1343 | 9.1343 | 30800.0 |
| 2010-09-07 04:35:00 | AAPL | Stock | 9.1271 | 9.1271 | 9.1271 | 9.1271 | 2800.0 |
| 2010-09-07 04:55:00 | AAPL | Stock | 9.1286 | 9.1714 | 9.1286 | 9.1714 | 37800.0 |
| 2010-09-07 05:00:00 | AAPL | Stock | 9.1286 | 9.1286 | 9.1286 | 9.1286 | 8400.0 |
| 2010-09-07 05:50:00 | AAPL | Stock | 9.1571 | 9.1571 | 9.1571 | 9.1571 | 2800.0 |
| 2010-09-07 06:00:00 | AAPL | Stock | 9.1446 | 9.1446 | 9.1268 | 9.1268 | 14000.0 |
| 2010-09-07 06:10:00 | AAPL | Stock | 9.1336 | 9.1346 | 9.1336 | 9.1346 | 53200.0 |
| 2010-09-07 06:25:00 | AAPL | Stock | 9.1518 | 9.1639 | 9.1518 | 9.1639 | 25060.0 |
| 2010-09-07 06:30:00 | AAPL | Stock | 9.1639 | 9.1639 | 9.1518 | 9.1589 | 19600.0 |
| 2010-09-07 06:35:00 | AAPL | Stock | 9.1521 | 9.1521 | 9.1521 | 9.1521 | 2800.0 |
| 2010-09-07 06:40:00 | AAPL | Stock | 9.1639 | 9.1639 | 9.1639 | 9.1639 | 14000.0 |
| 2010-09-07 06:45:00 | AAPL | Stock | 9.1607 | 9.1607 | 9.1607 | 9.1607 | 16800.0 |
| 2010-09-07 06:55:00 | AAPL | Stock | 9.1661 | 9.1661 | 9.1661 | 9.1661 | 14420.0 |
| 2010-09-07 07:00:00 | AAPL | Stock | 9.1714 | 9.1782 | 9.1714 | 9.1782 | 29400.0 |
| 2010-09-07 07:05:00 | AAPL | Stock | 9.1661 | 9.1782 | 9.1607 | 9.1782 | 69160.0 |
| 2010-09-07 07:15:00 | AAPL | Stock | 9.1754 | 9.1754 | 9.1754 | 9.1754 | 12264.0 |
| 2010-09-07 07:20:00 | AAPL | Stock | 9.1839 | 9.1961 | 9.1839 | 9.1896 | 22064.0 |
| 2010-09-07 07:25:00 | AAPL | Stock | 9.1864 | 9.1864 | 9.1857 | 9.1857 | 141400.0 |
| 2010-09-07 07:30:00 | AAPL | Stock | 9.1839 | 9.1839 | 9.1839 | 9.1839 | 5600.0 |
| 2010-09-07 07:40:00 | AAPL | Stock | 9.1761 | 9.1857 | 9.1761 | 9.1857 | 9800.0 |
| 2010-09-07 07:45:00 | AAPL | Stock | 9.1786 | 9.1786 | 9.1786 | 9.1786 | 8400.0 |
| 2010-09-07 07:55:00 | AAPL | Stock | 9.1875 | 9.1929 | 9.1875 | 9.1929 | 15680.0 |
| 2010-09-07 08:00:00 | AAPL | Stock | 9.1918 | 9.2054 | 9.1857 | 9.2054 | 268856.0 |
| 2010-09-07 08:05:00 | AAPL | Stock | 9.2036 | 9.21 | 9.2029 | 9.2054 | 312760.0 |
| 2010-09-07 08:10:00 | AAPL | Stock | 9.2054 | 9.2071 | 9.2 | 9.2 | 149800.0 |
| 2010-09-07 08:15:00 | AAPL | Stock | 9.1982 | 9.2107 | 9.1975 | 9.2 | 59360.0 |
| 2010-09-07 08:20:00 | AAPL | Stock | 9.1989 | 9.1989 | 9.1821 | 9.1821 | 292852.0 |
| 2010-09-07 08:25:00 | AAPL | Stock | 9.185 | 9.1857 | 9.1736 | 9.1754 | 375060.0 |
| 2010-09-07 08:30:00 | AAPL | Stock | 9.1786 | 9.1793 | 9.1736 | 9.1739 | 55804.0 |
| 2010-09-07 08:35:00 | AAPL | Stock | 9.1739 | 9.1821 | 9.1721 | 9.1821 | 111776.0 |
| 2010-09-07 08:40:00 | AAPL | Stock | 9.1821 | 9.1821 | 9.1768 | 9.1818 | 76160.0 |
| 2010-09-07 08:45:00 | AAPL | Stock | 9.1786 | 9.1786 | 9.175 | 9.1786 | 97300.0 |
| 2010-09-07 08:50:00 | AAPL | Stock | 9.1793 | 9.1793 | 9.1761 | 9.1786 | 132776.0 |
| 2010-09-07 08:55:00 | AAPL | Stock | 9.1775 | 9.1814 | 9.1757 | 9.1814 | 75600.0 |
| 2010-09-07 09:00:00 | AAPL | Stock | 9.1821 | 9.1832 | 9.1796 | 9.1832 | 89600.0 |
| 2010-09-07 09:05:00 | AAPL | Stock | 9.1825 | 9.1857 | 9.1821 | 9.1821 | 47600.0 |
| 2010-09-07 09:10:00 | AAPL | Stock | 9.1832 | 9.1857 | 9.1825 | 9.1832 | 135800.0 |
| 2010-09-07 09:15:00 | AAPL | Stock | 9.1829 | 9.1861 | 9.1825 | 9.1825 | 52500.0 |
| 2010-09-07 09:20:00 | AAPL | Stock | 9.1829 | 9.1829 | 9.1829 | 9.1829 | 2800.0 |
| 2010-09-07 09:25:00 | AAPL | Stock | 9.1843 | 9.1857 | 9.1607 | 9.1675 | 531804.0 |
| 2010-09-07 09:30:00 | AAPL | Stock | 9.1657 | 9.1971 | 9.1518 | 9.1839 | 16180304.0 |
| 2010-09-07 09:35:00 | AAPL | Stock | 9.1839 | 9.2207 | 9.1796 | 9.2154 | 13832280.0 |
| 2010-09-07 09:40:00 | AAPL | Stock | 9.2161 | 9.2679 | 9.2143 | 9.2679 | 16413264.0 |
| 2010-09-07 09:45:00 | AAPL | Stock | 9.2675 | 9.2689 | 9.235 | 9.2404 | 13631548.0 |
| 2010-09-07 09:50:00 | AAPL | Stock | 9.2404 | 9.2493 | 9.2268 | 9.2346 | 7476868.0 |
| 2010-09-07 09:55:00 | AAPL | Stock | 9.235 | 9.2352 | 9.2079 | 9.2082 | 9343236.0 |
| 2010-09-07 10:00:00 | AAPL | Stock | 9.2103 | 9.2146 | 9.1879 | 9.1996 | 10309740.0 |
> showing 50 of 319,456 rows — these rows as CSV