PREVIEW / stock_5min / 2011-05-19
file: by_date/stock_5min/2011/2011-05-19.parquet size: 4.9 MB rows: 329,335 symbols: 3,547
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 |
|---|---|---|---|---|---|---|---|
| 2011-05-19 04:00:00 | AAPL | Stock | 12.1346 | 12.1346 | 12.1346 | 12.1346 | 2800.0 |
| 2011-05-19 04:40:00 | AAPL | Stock | 12.125 | 12.125 | 12.1214 | 12.1214 | 5600.0 |
| 2011-05-19 04:50:00 | AAPL | Stock | 12.1125 | 12.1125 | 12.1125 | 12.1125 | 6300.0 |
| 2011-05-19 05:00:00 | AAPL | Stock | 12.1125 | 12.1125 | 12.1125 | 12.1125 | 11200.0 |
| 2011-05-19 05:15:00 | AAPL | Stock | 12.1418 | 12.1518 | 12.1418 | 12.1518 | 5600.0 |
| 2011-05-19 06:10:00 | AAPL | Stock | 12.1914 | 12.1914 | 12.1914 | 12.1914 | 2800.0 |
| 2011-05-19 06:15:00 | AAPL | Stock | 12.1907 | 12.1907 | 12.1907 | 12.1907 | 2800.0 |
| 2011-05-19 06:40:00 | AAPL | Stock | 12.1904 | 12.1904 | 12.1904 | 12.1904 | 13104.0 |
| 2011-05-19 06:55:00 | AAPL | Stock | 12.1907 | 12.1907 | 12.1907 | 12.1907 | 4984.0 |
| 2011-05-19 07:10:00 | AAPL | Stock | 12.19 | 12.1904 | 12.19 | 12.19 | 37100.0 |
| 2011-05-19 07:15:00 | AAPL | Stock | 12.1921 | 12.1921 | 12.1921 | 12.1921 | 5600.0 |
| 2011-05-19 07:20:00 | AAPL | Stock | 12.1782 | 12.1782 | 12.175 | 12.175 | 23380.0 |
| 2011-05-19 07:25:00 | AAPL | Stock | 12.1871 | 12.1871 | 12.1871 | 12.1871 | 2800.0 |
| 2011-05-19 07:35:00 | AAPL | Stock | 12.1789 | 12.1789 | 12.1732 | 12.175 | 50820.0 |
| 2011-05-19 07:40:00 | AAPL | Stock | 12.18 | 12.1868 | 12.18 | 12.1868 | 11340.0 |
| 2011-05-19 07:45:00 | AAPL | Stock | 12.175 | 12.1818 | 12.175 | 12.1818 | 5600.0 |
| 2011-05-19 07:50:00 | AAPL | Stock | 12.1818 | 12.1818 | 12.1757 | 12.1757 | 8400.0 |
| 2011-05-19 07:55:00 | AAPL | Stock | 12.1757 | 12.1818 | 12.1757 | 12.1818 | 33600.0 |
| 2011-05-19 08:00:00 | AAPL | Stock | 12.1786 | 12.1914 | 12.1679 | 12.1679 | 93156.0 |
| 2011-05-19 08:05:00 | AAPL | Stock | 12.1679 | 12.1746 | 12.1607 | 12.1721 | 115136.0 |
| 2011-05-19 08:10:00 | AAPL | Stock | 12.1725 | 12.1964 | 12.1725 | 12.1786 | 222600.0 |
| 2011-05-19 08:15:00 | AAPL | Stock | 12.1821 | 12.1854 | 12.1782 | 12.1854 | 75600.0 |
| 2011-05-19 08:20:00 | AAPL | Stock | 12.1854 | 12.1854 | 12.1854 | 12.1854 | 7420.0 |
| 2011-05-19 08:25:00 | AAPL | Stock | 12.1839 | 12.1843 | 12.1821 | 12.1821 | 40432.0 |
| 2011-05-19 08:30:00 | AAPL | Stock | 12.1843 | 12.2054 | 12.1839 | 12.2036 | 422996.0 |
| 2011-05-19 08:35:00 | AAPL | Stock | 12.2011 | 12.2089 | 12.1896 | 12.2082 | 234668.0 |
| 2011-05-19 08:40:00 | AAPL | Stock | 12.2089 | 12.2096 | 12.2 | 12.2054 | 251776.0 |
| 2011-05-19 08:45:00 | AAPL | Stock | 12.2004 | 12.2089 | 12.2004 | 12.2064 | 74900.0 |
| 2011-05-19 08:50:00 | AAPL | Stock | 12.2054 | 12.2096 | 12.2 | 12.2096 | 53200.0 |
| 2011-05-19 08:55:00 | AAPL | Stock | 12.2054 | 12.2071 | 12.2036 | 12.2054 | 61096.0 |
| 2011-05-19 09:00:00 | AAPL | Stock | 12.2071 | 12.2129 | 12.2054 | 12.2129 | 142996.0 |
| 2011-05-19 09:05:00 | AAPL | Stock | 12.2107 | 12.2125 | 12.2071 | 12.2107 | 144648.0 |
| 2011-05-19 09:10:00 | AAPL | Stock | 12.2104 | 12.2179 | 12.2104 | 12.2179 | 147784.0 |
| 2011-05-19 09:15:00 | AAPL | Stock | 12.2146 | 12.2204 | 12.2071 | 12.2143 | 126672.0 |
| 2011-05-19 09:20:00 | AAPL | Stock | 12.2079 | 12.2111 | 12.1975 | 12.1979 | 191380.0 |
| 2011-05-19 09:25:00 | AAPL | Stock | 12.1993 | 12.2196 | 12.1993 | 12.2146 | 429072.0 |
| 2011-05-19 09:30:00 | AAPL | Stock | 12.2161 | 12.2211 | 12.1767 | 12.2196 | 15724184.0 |
| 2011-05-19 09:35:00 | AAPL | Stock | 12.2196 | 12.2291 | 12.1796 | 12.1976 | 11070780.0 |
| 2011-05-19 09:40:00 | AAPL | Stock | 12.1954 | 12.2021 | 12.1861 | 12.1954 | 5956160.0 |
| 2011-05-19 09:45:00 | AAPL | Stock | 12.1946 | 12.2118 | 12.1846 | 12.1961 | 5772900.0 |
| 2011-05-19 09:50:00 | AAPL | Stock | 12.1957 | 12.2036 | 12.1886 | 12.2007 | 3750404.0 |
| 2011-05-19 09:55:00 | AAPL | Stock | 12.2011 | 12.2064 | 12.1775 | 12.1807 | 7459872.0 |
| 2011-05-19 10:00:00 | AAPL | Stock | 12.1807 | 12.1936 | 12.1664 | 12.1879 | 6629084.0 |
| 2011-05-19 10:05:00 | AAPL | Stock | 12.1875 | 12.1957 | 12.1583 | 12.1625 | 5306952.0 |
| 2011-05-19 10:10:00 | AAPL | Stock | 12.1637 | 12.1668 | 12.1468 | 12.1629 | 6430620.0 |
| 2011-05-19 10:15:00 | AAPL | Stock | 12.1643 | 12.1714 | 12.1561 | 12.1664 | 2810668.0 |
| 2011-05-19 10:20:00 | AAPL | Stock | 12.1661 | 12.1814 | 12.165 | 12.1711 | 4264344.0 |
| 2011-05-19 10:25:00 | AAPL | Stock | 12.1697 | 12.1754 | 12.1586 | 12.1743 | 2456244.0 |
| 2011-05-19 10:30:00 | AAPL | Stock | 12.1736 | 12.175 | 12.1507 | 12.1571 | 3574704.0 |
| 2011-05-19 10:35:00 | AAPL | Stock | 12.1575 | 12.1736 | 12.1486 | 12.1554 | 3266984.0 |
> showing 50 of 329,335 rows — these rows as CSV