PREVIEW / stock_5min / 2007-11-26
file: by_date/stock_5min/2007/2007-11-26.parquet size: 4.3 MB rows: 315,509 symbols: 3,213
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 |
|---|---|---|---|---|---|---|---|
| 2007-11-26 04:15:00 | AAPL | Stock | 6.1993 | 6.1993 | 6.1993 | 6.1993 | 2800.0 |
| 2007-11-26 05:05:00 | AAPL | Stock | 6.21 | 6.21 | 6.21 | 6.21 | 2800.0 |
| 2007-11-26 06:25:00 | AAPL | Stock | 6.2189 | 6.2304 | 6.2189 | 6.2304 | 11200.0 |
| 2007-11-26 06:30:00 | AAPL | Stock | 6.2218 | 6.2218 | 6.2218 | 6.2218 | 2800.0 |
| 2007-11-26 06:35:00 | AAPL | Stock | 6.2218 | 6.2218 | 6.2211 | 6.2211 | 5600.0 |
| 2007-11-26 06:45:00 | AAPL | Stock | 6.22 | 6.22 | 6.22 | 6.22 | 2800.0 |
| 2007-11-26 06:50:00 | AAPL | Stock | 6.2143 | 6.2143 | 6.2143 | 6.2143 | 2800.0 |
| 2007-11-26 07:00:00 | AAPL | Stock | 6.2143 | 6.2143 | 6.2143 | 6.2143 | 8400.0 |
| 2007-11-26 07:05:00 | AAPL | Stock | 6.2018 | 6.2086 | 6.2018 | 6.2086 | 30800.0 |
| 2007-11-26 07:10:00 | AAPL | Stock | 6.1964 | 6.1964 | 6.1875 | 6.1875 | 30800.0 |
| 2007-11-26 07:15:00 | AAPL | Stock | 6.1821 | 6.1946 | 6.1821 | 6.1946 | 11200.0 |
| 2007-11-26 07:20:00 | AAPL | Stock | 6.1964 | 6.1964 | 6.1964 | 6.1964 | 2800.0 |
| 2007-11-26 07:25:00 | AAPL | Stock | 6.1925 | 6.1929 | 6.1925 | 6.1929 | 14000.0 |
| 2007-11-26 07:30:00 | AAPL | Stock | 6.1929 | 6.2043 | 6.1904 | 6.2 | 369600.0 |
| 2007-11-26 07:35:00 | AAPL | Stock | 6.2039 | 6.2043 | 6.1964 | 6.1964 | 202244.0 |
| 2007-11-26 07:40:00 | AAPL | Stock | 6.2018 | 6.2089 | 6.1821 | 6.1932 | 672084.0 |
| 2007-11-26 07:45:00 | AAPL | Stock | 6.1804 | 6.1807 | 6.1786 | 6.1786 | 115080.0 |
| 2007-11-26 07:50:00 | AAPL | Stock | 6.1871 | 6.1889 | 6.185 | 6.1889 | 84000.0 |
| 2007-11-26 07:55:00 | AAPL | Stock | 6.1886 | 6.1889 | 6.1886 | 6.1889 | 5600.0 |
| 2007-11-26 08:00:00 | AAPL | Stock | 6.1893 | 6.2036 | 6.1807 | 6.2 | 1775032.0 |
| 2007-11-26 08:05:00 | AAPL | Stock | 6.2 | 6.2054 | 6.1939 | 6.2 | 470820.0 |
| 2007-11-26 08:10:00 | AAPL | Stock | 6.2004 | 6.2179 | 6.2004 | 6.2175 | 946344.0 |
| 2007-11-26 08:15:00 | AAPL | Stock | 6.2196 | 6.2232 | 6.2161 | 6.2189 | 951328.0 |
| 2007-11-26 08:20:00 | AAPL | Stock | 6.2179 | 6.2182 | 6.2089 | 6.2111 | 544936.0 |
| 2007-11-26 08:25:00 | AAPL | Stock | 6.2111 | 6.2125 | 6.2004 | 6.2004 | 342328.0 |
| 2007-11-26 08:30:00 | AAPL | Stock | 6.2004 | 6.2043 | 6.1968 | 6.1996 | 406476.0 |
| 2007-11-26 08:35:00 | AAPL | Stock | 6.2 | 6.2 | 6.1821 | 6.1821 | 762412.0 |
| 2007-11-26 08:40:00 | AAPL | Stock | 6.1854 | 6.1875 | 6.1739 | 6.1739 | 904568.0 |
| 2007-11-26 08:45:00 | AAPL | Stock | 6.1739 | 6.1818 | 6.1696 | 6.1754 | 1194900.0 |
| 2007-11-26 08:50:00 | AAPL | Stock | 6.1775 | 6.1775 | 6.1607 | 6.1714 | 1008952.0 |
| 2007-11-26 08:55:00 | AAPL | Stock | 6.1693 | 6.1946 | 6.1693 | 6.1893 | 749364.0 |
| 2007-11-26 09:00:00 | AAPL | Stock | 6.1918 | 6.1929 | 6.1832 | 6.1857 | 533596.0 |
| 2007-11-26 09:05:00 | AAPL | Stock | 6.1864 | 6.1904 | 6.18 | 6.1896 | 390124.0 |
| 2007-11-26 09:10:00 | AAPL | Stock | 6.1889 | 6.1893 | 6.1786 | 6.1864 | 264292.0 |
| 2007-11-26 09:15:00 | AAPL | Stock | 6.1875 | 6.1929 | 6.1861 | 6.1861 | 216216.0 |
| 2007-11-26 09:20:00 | AAPL | Stock | 6.19 | 6.1904 | 6.1821 | 6.1861 | 265216.0 |
| 2007-11-26 09:25:00 | AAPL | Stock | 6.1843 | 6.2096 | 6.1264 | 6.1996 | 1307544.0 |
| 2007-11-26 09:30:00 | AAPL | Stock | 6.1996 | 6.2232 | 6.1761 | 6.1761 | 41302772.0 |
| 2007-11-26 09:35:00 | AAPL | Stock | 6.1761 | 6.2382 | 6.175 | 6.2375 | 39586568.0 |
| 2007-11-26 09:40:00 | AAPL | Stock | 6.2371 | 6.27 | 6.2268 | 6.2682 | 36123668.0 |
| 2007-11-26 09:45:00 | AAPL | Stock | 6.2682 | 6.2761 | 6.2457 | 6.2575 | 27578516.0 |
| 2007-11-26 09:50:00 | AAPL | Stock | 6.2575 | 6.2618 | 6.21 | 6.2532 | 18369120.0 |
| 2007-11-26 09:55:00 | AAPL | Stock | 6.2521 | 6.3036 | 6.2514 | 6.3036 | 34404916.0 |
| 2007-11-26 10:00:00 | AAPL | Stock | 6.3036 | 6.31 | 6.2857 | 6.2939 | 22545488.0 |
| 2007-11-26 10:05:00 | AAPL | Stock | 6.2946 | 6.3071 | 6.2821 | 6.2857 | 21264572.0 |
| 2007-11-26 10:10:00 | AAPL | Stock | 6.2857 | 6.3039 | 6.2768 | 6.2843 | 15215060.0 |
| 2007-11-26 10:15:00 | AAPL | Stock | 6.285 | 6.2886 | 6.2664 | 6.2668 | 17431428.0 |
| 2007-11-26 10:20:00 | AAPL | Stock | 6.2675 | 6.2857 | 6.2539 | 6.2661 | 16635584.0 |
| 2007-11-26 10:25:00 | AAPL | Stock | 6.2661 | 6.2857 | 6.255 | 6.2686 | 16397976.0 |
| 2007-11-26 10:30:00 | AAPL | Stock | 6.2688 | 6.29 | 6.2618 | 6.2714 | 15509004.0 |
> showing 50 of 315,509 rows — these rows as CSV