PREVIEW / stock_5min / 2013-01-17
file: by_date/stock_5min/2013/2013-01-17.parquet size: 4.8 MB rows: 321,968 symbols: 3,473
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 |
|---|---|---|---|---|---|---|---|
| 2013-01-17 04:00:00 | AAPL | Stock | 18.0643 | 18.1111 | 18.0643 | 18.1111 | 28000.0 |
| 2013-01-17 04:05:00 | AAPL | Stock | 18.1589 | 18.1754 | 18.1589 | 18.1739 | 22400.0 |
| 2013-01-17 04:10:00 | AAPL | Stock | 18.1721 | 18.2136 | 18.1721 | 18.2104 | 22876.0 |
| 2013-01-17 04:15:00 | AAPL | Stock | 18.2125 | 18.2143 | 18.2125 | 18.2143 | 9128.0 |
| 2013-01-17 04:20:00 | AAPL | Stock | 18.1804 | 18.1804 | 18.1786 | 18.1786 | 11760.0 |
| 2013-01-17 04:35:00 | AAPL | Stock | 18.1893 | 18.1893 | 18.1889 | 18.1893 | 22400.0 |
| 2013-01-17 04:40:00 | AAPL | Stock | 18.1786 | 18.1786 | 18.1786 | 18.1786 | 2800.0 |
| 2013-01-17 04:45:00 | AAPL | Stock | 18.1843 | 18.1893 | 18.1843 | 18.1893 | 19320.0 |
| 2013-01-17 04:50:00 | AAPL | Stock | 18.2132 | 18.2143 | 18.2132 | 18.2143 | 8400.0 |
| 2013-01-17 04:55:00 | AAPL | Stock | 18.2 | 18.2071 | 18.2 | 18.2036 | 11200.0 |
| 2013-01-17 05:00:00 | AAPL | Stock | 18.1964 | 18.2054 | 18.1964 | 18.205 | 27608.0 |
| 2013-01-17 05:05:00 | AAPL | Stock | 18.2018 | 18.2018 | 18.2018 | 18.2018 | 2800.0 |
| 2013-01-17 05:10:00 | AAPL | Stock | 18.2018 | 18.2018 | 18.1839 | 18.1839 | 42000.0 |
| 2013-01-17 05:15:00 | AAPL | Stock | 18.1911 | 18.1911 | 18.1907 | 18.1907 | 30800.0 |
| 2013-01-17 05:20:00 | AAPL | Stock | 18.1907 | 18.1907 | 18.1839 | 18.1839 | 9408.0 |
| 2013-01-17 05:25:00 | AAPL | Stock | 18.1893 | 18.1911 | 18.1893 | 18.1911 | 23128.0 |
| 2013-01-17 05:30:00 | AAPL | Stock | 18.1911 | 18.1911 | 18.1911 | 18.1911 | 2800.0 |
| 2013-01-17 05:35:00 | AAPL | Stock | 18.1911 | 18.1911 | 18.1764 | 18.1786 | 28000.0 |
| 2013-01-17 05:40:00 | AAPL | Stock | 18.1786 | 18.1911 | 18.1786 | 18.1911 | 27720.0 |
| 2013-01-17 05:45:00 | AAPL | Stock | 18.1893 | 18.1893 | 18.1893 | 18.1893 | 5600.0 |
| 2013-01-17 05:50:00 | AAPL | Stock | 18.1761 | 18.1761 | 18.1643 | 18.1643 | 13664.0 |
| 2013-01-17 05:55:00 | AAPL | Stock | 18.1675 | 18.1675 | 18.1432 | 18.1614 | 18704.0 |
| 2013-01-17 06:05:00 | AAPL | Stock | 18.1696 | 18.175 | 18.1696 | 18.175 | 5600.0 |
| 2013-01-17 06:10:00 | AAPL | Stock | 18.1607 | 18.1607 | 18.1607 | 18.1607 | 5600.0 |
| 2013-01-17 06:15:00 | AAPL | Stock | 18.1732 | 18.1732 | 18.1732 | 18.1732 | 2800.0 |
| 2013-01-17 06:25:00 | AAPL | Stock | 18.1732 | 18.1943 | 18.1668 | 18.1671 | 33600.0 |
| 2013-01-17 06:35:00 | AAPL | Stock | 18.1671 | 18.1671 | 18.1643 | 18.1643 | 30800.0 |
| 2013-01-17 06:45:00 | AAPL | Stock | 18.1696 | 18.17 | 18.1696 | 18.1696 | 16856.0 |
| 2013-01-17 06:50:00 | AAPL | Stock | 18.1679 | 18.1786 | 18.1654 | 18.1786 | 19544.0 |
| 2013-01-17 06:55:00 | AAPL | Stock | 18.1964 | 18.1964 | 18.1964 | 18.1964 | 11200.0 |
| 2013-01-17 07:00:00 | AAPL | Stock | 18.1786 | 18.2464 | 18.1786 | 18.2321 | 104496.0 |
| 2013-01-17 07:05:00 | AAPL | Stock | 18.2321 | 18.2321 | 18.2107 | 18.2107 | 49700.0 |
| 2013-01-17 07:10:00 | AAPL | Stock | 18.2264 | 18.2286 | 18.2143 | 18.2143 | 23352.0 |
| 2013-01-17 07:15:00 | AAPL | Stock | 18.2007 | 18.2007 | 18.1964 | 18.1964 | 33320.0 |
| 2013-01-17 07:20:00 | AAPL | Stock | 18.1964 | 18.2139 | 18.1786 | 18.1893 | 63504.0 |
| 2013-01-17 07:25:00 | AAPL | Stock | 18.1861 | 18.1893 | 18.1782 | 18.1786 | 66360.0 |
| 2013-01-17 07:30:00 | AAPL | Stock | 18.1786 | 18.1861 | 18.1786 | 18.1786 | 43372.0 |
| 2013-01-17 07:35:00 | AAPL | Stock | 18.1775 | 18.1861 | 18.1775 | 18.1786 | 24920.0 |
| 2013-01-17 07:40:00 | AAPL | Stock | 18.1682 | 18.1782 | 18.1679 | 18.1782 | 31080.0 |
| 2013-01-17 07:45:00 | AAPL | Stock | 18.1786 | 18.1875 | 18.1786 | 18.1843 | 72380.0 |
| 2013-01-17 07:50:00 | AAPL | Stock | 18.1868 | 18.2036 | 18.1857 | 18.1936 | 49000.0 |
| 2013-01-17 07:55:00 | AAPL | Stock | 18.2032 | 18.2143 | 18.2032 | 18.2107 | 324016.0 |
| 2013-01-17 08:00:00 | AAPL | Stock | 18.2036 | 18.2496 | 18.17 | 18.2321 | 1076460.0 |
| 2013-01-17 08:05:00 | AAPL | Stock | 18.2414 | 18.2425 | 18.2021 | 18.2221 | 395948.0 |
| 2013-01-17 08:10:00 | AAPL | Stock | 18.2214 | 18.2214 | 18.1729 | 18.1729 | 571144.0 |
| 2013-01-17 08:15:00 | AAPL | Stock | 18.1714 | 18.1782 | 18.1339 | 18.1393 | 429324.0 |
| 2013-01-17 08:20:00 | AAPL | Stock | 18.1325 | 18.1532 | 18.0907 | 18.1482 | 574476.0 |
| 2013-01-17 08:25:00 | AAPL | Stock | 18.1446 | 18.1639 | 18.1321 | 18.1571 | 438368.0 |
| 2013-01-17 08:30:00 | AAPL | Stock | 18.1604 | 18.1964 | 18.1536 | 18.1539 | 242844.0 |
| 2013-01-17 08:35:00 | AAPL | Stock | 18.1607 | 18.1714 | 18.1511 | 18.1511 | 181832.0 |
> showing 50 of 321,968 rows — these rows as CSV