PREVIEW / stock_5min / 2010-03-26
file: by_date/stock_5min/2010/2010-03-26.parquet size: 4.7 MB rows: 322,869 symbols: 3,458
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-03-26 04:25:00 | AAPL | Stock | 8.1679 | 8.1679 | 8.1679 | 8.1679 | 15148.0 |
| 2010-03-26 04:45:00 | AAPL | Stock | 8.1679 | 8.1679 | 8.1679 | 8.1679 | 5600.0 |
| 2010-03-26 04:55:00 | AAPL | Stock | 8.1679 | 8.1679 | 8.1679 | 8.1679 | 5600.0 |
| 2010-03-26 05:00:00 | AAPL | Stock | 8.1875 | 8.1875 | 8.1875 | 8.1875 | 14000.0 |
| 2010-03-26 05:10:00 | AAPL | Stock | 8.1946 | 8.1964 | 8.1946 | 8.1964 | 36652.0 |
| 2010-03-26 05:25:00 | AAPL | Stock | 8.1829 | 8.1964 | 8.1829 | 8.1964 | 11200.0 |
| 2010-03-26 05:30:00 | AAPL | Stock | 8.1946 | 8.2007 | 8.1946 | 8.2007 | 5600.0 |
| 2010-03-26 05:40:00 | AAPL | Stock | 8.1982 | 8.1982 | 8.1921 | 8.1921 | 33600.0 |
| 2010-03-26 05:45:00 | AAPL | Stock | 8.1861 | 8.1861 | 8.1861 | 8.1861 | 2800.0 |
| 2010-03-26 06:00:00 | AAPL | Stock | 8.1861 | 8.1861 | 8.1861 | 8.1861 | 5600.0 |
| 2010-03-26 06:20:00 | AAPL | Stock | 8.1961 | 8.1964 | 8.1961 | 8.1964 | 11200.0 |
| 2010-03-26 06:25:00 | AAPL | Stock | 8.2064 | 8.2079 | 8.2064 | 8.2068 | 30800.0 |
| 2010-03-26 06:35:00 | AAPL | Stock | 8.1968 | 8.1968 | 8.1968 | 8.1968 | 11676.0 |
| 2010-03-26 06:40:00 | AAPL | Stock | 8.1968 | 8.1968 | 8.1964 | 8.1964 | 42504.0 |
| 2010-03-26 06:55:00 | AAPL | Stock | 8.185 | 8.185 | 8.185 | 8.185 | 11200.0 |
| 2010-03-26 07:00:00 | AAPL | Stock | 8.1704 | 8.1704 | 8.1704 | 8.1704 | 14000.0 |
| 2010-03-26 07:05:00 | AAPL | Stock | 8.1736 | 8.1964 | 8.1718 | 8.1789 | 169680.0 |
| 2010-03-26 07:10:00 | AAPL | Stock | 8.1961 | 8.1964 | 8.1957 | 8.1964 | 31640.0 |
| 2010-03-26 07:15:00 | AAPL | Stock | 8.1861 | 8.1929 | 8.1857 | 8.1929 | 58800.0 |
| 2010-03-26 07:20:00 | AAPL | Stock | 8.1929 | 8.1929 | 8.1857 | 8.1857 | 42280.0 |
| 2010-03-26 07:30:00 | AAPL | Stock | 8.1786 | 8.1825 | 8.1786 | 8.1793 | 47320.0 |
| 2010-03-26 07:35:00 | AAPL | Stock | 8.1804 | 8.1818 | 8.1768 | 8.1768 | 87920.0 |
| 2010-03-26 07:40:00 | AAPL | Stock | 8.1804 | 8.1807 | 8.1804 | 8.1807 | 11200.0 |
| 2010-03-26 07:45:00 | AAPL | Stock | 8.1857 | 8.2089 | 8.1857 | 8.2089 | 409276.0 |
| 2010-03-26 07:50:00 | AAPL | Stock | 8.2061 | 8.2111 | 8.2036 | 8.2089 | 216468.0 |
| 2010-03-26 07:55:00 | AAPL | Stock | 8.2121 | 8.2139 | 8.2054 | 8.2107 | 196476.0 |
| 2010-03-26 08:00:00 | AAPL | Stock | 8.2107 | 8.2132 | 8.1896 | 8.1932 | 602168.0 |
| 2010-03-26 08:05:00 | AAPL | Stock | 8.1946 | 8.1961 | 8.1861 | 8.1943 | 452984.0 |
| 2010-03-26 08:10:00 | AAPL | Stock | 8.1939 | 8.2071 | 8.1929 | 8.1961 | 401604.0 |
| 2010-03-26 08:15:00 | AAPL | Stock | 8.1925 | 8.1982 | 8.1857 | 8.1857 | 227892.0 |
| 2010-03-26 08:20:00 | AAPL | Stock | 8.1857 | 8.1921 | 8.1857 | 8.1914 | 64400.0 |
| 2010-03-26 08:25:00 | AAPL | Stock | 8.19 | 8.195 | 8.1896 | 8.1929 | 172816.0 |
| 2010-03-26 08:30:00 | AAPL | Stock | 8.1896 | 8.2007 | 8.1843 | 8.2007 | 500920.0 |
| 2010-03-26 08:35:00 | AAPL | Stock | 8.1971 | 8.1982 | 8.1786 | 8.1854 | 532700.0 |
| 2010-03-26 08:40:00 | AAPL | Stock | 8.1857 | 8.1925 | 8.1821 | 8.1839 | 440412.0 |
| 2010-03-26 08:45:00 | AAPL | Stock | 8.1854 | 8.1875 | 8.1821 | 8.1854 | 121240.0 |
| 2010-03-26 08:50:00 | AAPL | Stock | 8.1857 | 8.1857 | 8.1786 | 8.1793 | 333900.0 |
| 2010-03-26 08:55:00 | AAPL | Stock | 8.1796 | 8.1854 | 8.1746 | 8.1843 | 720468.0 |
| 2010-03-26 09:00:00 | AAPL | Stock | 8.1839 | 8.1907 | 8.1789 | 8.1857 | 499436.0 |
| 2010-03-26 09:05:00 | AAPL | Stock | 8.1857 | 8.1929 | 8.1829 | 8.1839 | 259700.0 |
| 2010-03-26 09:10:00 | AAPL | Stock | 8.1839 | 8.1854 | 8.1804 | 8.1825 | 130396.0 |
| 2010-03-26 09:15:00 | AAPL | Stock | 8.1839 | 8.1854 | 8.1786 | 8.1832 | 313936.0 |
| 2010-03-26 09:20:00 | AAPL | Stock | 8.18 | 8.1807 | 8.1707 | 8.1786 | 681968.0 |
| 2010-03-26 09:25:00 | AAPL | Stock | 8.1818 | 8.1861 | 8.1746 | 8.1771 | 506212.0 |
| 2010-03-26 09:30:00 | AAPL | Stock | 8.1771 | 8.2054 | 8.1679 | 8.1871 | 18348092.0 |
| 2010-03-26 09:35:00 | AAPL | Stock | 8.1889 | 8.1957 | 8.18 | 8.1811 | 8628200.0 |
| 2010-03-26 09:40:00 | AAPL | Stock | 8.1821 | 8.1864 | 8.1625 | 8.1786 | 12597732.0 |
| 2010-03-26 09:45:00 | AAPL | Stock | 8.1789 | 8.2182 | 8.1725 | 8.2096 | 20702836.0 |
| 2010-03-26 09:50:00 | AAPL | Stock | 8.2096 | 8.2321 | 8.2068 | 8.2297 | 17230360.0 |
| 2010-03-26 09:55:00 | AAPL | Stock | 8.2314 | 8.2471 | 8.2196 | 8.2318 | 19958372.0 |
> showing 50 of 322,869 rows — these rows as CSV