PREVIEW / stock_5min / 2009-12-23
file: by_date/stock_5min/2009/2009-12-23.parquet size: 4.5 MB rows: 310,360 symbols: 3,450
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 |
|---|---|---|---|---|---|---|---|
| 2009-12-23 04:45:00 | AAPL | Stock | 7.1525 | 7.1525 | 7.1525 | 7.1525 | 5600.0 |
| 2009-12-23 07:05:00 | AAPL | Stock | 7.1857 | 7.1857 | 7.1857 | 7.1857 | 63980.0 |
| 2009-12-23 07:10:00 | AAPL | Stock | 7.1864 | 7.1864 | 7.1857 | 7.1857 | 77308.0 |
| 2009-12-23 07:20:00 | AAPL | Stock | 7.1857 | 7.1857 | 7.1857 | 7.1857 | 9800.0 |
| 2009-12-23 07:25:00 | AAPL | Stock | 7.1857 | 7.1929 | 7.1857 | 7.1929 | 23800.0 |
| 2009-12-23 07:35:00 | AAPL | Stock | 7.1857 | 7.1861 | 7.1857 | 7.1861 | 5600.0 |
| 2009-12-23 07:40:00 | AAPL | Stock | 7.1857 | 7.1857 | 7.1857 | 7.1857 | 4312.0 |
| 2009-12-23 07:45:00 | AAPL | Stock | 7.1875 | 7.1889 | 7.1875 | 7.1889 | 5600.0 |
| 2009-12-23 07:50:00 | AAPL | Stock | 7.1875 | 7.1875 | 7.1875 | 7.1875 | 11200.0 |
| 2009-12-23 08:00:00 | AAPL | Stock | 7.1825 | 7.1907 | 7.1725 | 7.1821 | 222740.0 |
| 2009-12-23 08:05:00 | AAPL | Stock | 7.1821 | 7.1907 | 7.1821 | 7.1907 | 100800.0 |
| 2009-12-23 08:10:00 | AAPL | Stock | 7.1864 | 7.1907 | 7.1864 | 7.1864 | 78960.0 |
| 2009-12-23 08:15:00 | AAPL | Stock | 7.1864 | 7.1875 | 7.1857 | 7.1875 | 28280.0 |
| 2009-12-23 08:20:00 | AAPL | Stock | 7.1861 | 7.1882 | 7.1857 | 7.1857 | 52024.0 |
| 2009-12-23 08:25:00 | AAPL | Stock | 7.1857 | 7.1875 | 7.1786 | 7.1786 | 89600.0 |
| 2009-12-23 08:30:00 | AAPL | Stock | 7.1786 | 7.1893 | 7.1746 | 7.1893 | 213500.0 |
| 2009-12-23 08:35:00 | AAPL | Stock | 7.1893 | 7.1911 | 7.1857 | 7.1857 | 224784.0 |
| 2009-12-23 08:40:00 | AAPL | Stock | 7.1875 | 7.1886 | 7.1868 | 7.1886 | 35952.0 |
| 2009-12-23 08:45:00 | AAPL | Stock | 7.1868 | 7.1904 | 7.185 | 7.1904 | 284760.0 |
| 2009-12-23 08:50:00 | AAPL | Stock | 7.1893 | 7.1904 | 7.1875 | 7.1875 | 41580.0 |
| 2009-12-23 08:55:00 | AAPL | Stock | 7.1879 | 7.1893 | 7.1875 | 7.1893 | 69300.0 |
| 2009-12-23 09:00:00 | AAPL | Stock | 7.1896 | 7.19 | 7.1875 | 7.1875 | 58800.0 |
| 2009-12-23 09:05:00 | AAPL | Stock | 7.1875 | 7.19 | 7.1875 | 7.19 | 168700.0 |
| 2009-12-23 09:10:00 | AAPL | Stock | 7.1893 | 7.1911 | 7.1893 | 7.1904 | 129780.0 |
| 2009-12-23 09:15:00 | AAPL | Stock | 7.1911 | 7.1929 | 7.1882 | 7.1929 | 143444.0 |
| 2009-12-23 09:20:00 | AAPL | Stock | 7.1936 | 7.1936 | 7.1875 | 7.1896 | 72352.0 |
| 2009-12-23 09:25:00 | AAPL | Stock | 7.1861 | 7.1875 | 7.1843 | 7.1864 | 110852.0 |
| 2009-12-23 09:30:00 | AAPL | Stock | 7.1857 | 7.2096 | 7.1811 | 7.2096 | 16325288.0 |
| 2009-12-23 09:35:00 | AAPL | Stock | 7.21 | 7.2143 | 7.1964 | 7.2096 | 11122216.0 |
| 2009-12-23 09:40:00 | AAPL | Stock | 7.2096 | 7.21 | 7.1911 | 7.2004 | 9560684.0 |
| 2009-12-23 09:45:00 | AAPL | Stock | 7.2004 | 7.2093 | 7.1979 | 7.2086 | 4533368.0 |
| 2009-12-23 09:50:00 | AAPL | Stock | 7.2079 | 7.2143 | 7.2021 | 7.2132 | 7927164.0 |
| 2009-12-23 09:55:00 | AAPL | Stock | 7.2136 | 7.2143 | 7.1979 | 7.1992 | 10777368.0 |
| 2009-12-23 10:00:00 | AAPL | Stock | 7.1971 | 7.1992 | 7.1718 | 7.1823 | 19216008.0 |
| 2009-12-23 10:05:00 | AAPL | Stock | 7.1821 | 7.1911 | 7.1786 | 7.1793 | 5948040.0 |
| 2009-12-23 10:10:00 | AAPL | Stock | 7.1811 | 7.2004 | 7.1793 | 7.2 | 5352704.0 |
| 2009-12-23 10:15:00 | AAPL | Stock | 7.2003 | 7.2104 | 7.1982 | 7.2032 | 6040804.0 |
| 2009-12-23 10:20:00 | AAPL | Stock | 7.2036 | 7.2068 | 7.1814 | 7.1839 | 4640860.0 |
| 2009-12-23 10:25:00 | AAPL | Stock | 7.1839 | 7.1946 | 7.1814 | 7.1904 | 5155668.0 |
| 2009-12-23 10:30:00 | AAPL | Stock | 7.1904 | 7.1964 | 7.1868 | 7.192 | 3066980.0 |
| 2009-12-23 10:35:00 | AAPL | Stock | 7.1925 | 7.2039 | 7.1907 | 7.2025 | 3951052.0 |
| 2009-12-23 10:40:00 | AAPL | Stock | 7.2021 | 7.2093 | 7.2018 | 7.2068 | 5060860.0 |
| 2009-12-23 10:45:00 | AAPL | Stock | 7.2057 | 7.2139 | 7.2043 | 7.2129 | 6530468.0 |
| 2009-12-23 10:50:00 | AAPL | Stock | 7.2129 | 7.2143 | 7.2077 | 7.2079 | 12605040.0 |
| 2009-12-23 10:55:00 | AAPL | Stock | 7.2075 | 7.2146 | 7.2 | 7.2001 | 6255368.0 |
| 2009-12-23 11:00:00 | AAPL | Stock | 7.2002 | 7.2036 | 7.1936 | 7.1936 | 5984692.0 |
| 2009-12-23 11:05:00 | AAPL | Stock | 7.1936 | 7.2054 | 7.1861 | 7.1989 | 7482944.0 |
| 2009-12-23 11:10:00 | AAPL | Stock | 7.1986 | 7.1996 | 7.19 | 7.1904 | 3972976.0 |
| 2009-12-23 11:15:00 | AAPL | Stock | 7.1907 | 7.2061 | 7.1904 | 7.2004 | 4745104.0 |
| 2009-12-23 11:20:00 | AAPL | Stock | 7.2018 | 7.2021 | 7.1896 | 7.1954 | 4582060.0 |
> showing 50 of 310,360 rows — these rows as CSV