PREVIEW / stock_5min / 2008-11-19
file: by_date/stock_5min/2008/2008-11-19.parquet size: 4.3 MB rows: 311,683 symbols: 3,320
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 |
|---|---|---|---|---|---|---|---|
| 2008-11-19 07:10:00 | AAPL | Stock | 3.2093 | 3.2093 | 3.2093 | 3.2093 | 2800.0 |
| 2008-11-19 07:15:00 | AAPL | Stock | 3.2093 | 3.2107 | 3.2093 | 3.2107 | 27720.0 |
| 2008-11-19 07:35:00 | AAPL | Stock | 3.2079 | 3.2079 | 3.2079 | 3.2079 | 2800.0 |
| 2008-11-19 07:50:00 | AAPL | Stock | 3.2036 | 3.2061 | 3.2018 | 3.2036 | 150864.0 |
| 2008-11-19 08:00:00 | AAPL | Stock | 3.1918 | 3.1918 | 3.175 | 3.1854 | 190176.0 |
| 2008-11-19 08:05:00 | AAPL | Stock | 3.1821 | 3.1911 | 3.1821 | 3.1911 | 132720.0 |
| 2008-11-19 08:10:00 | AAPL | Stock | 3.1911 | 3.1911 | 3.1864 | 3.1864 | 33600.0 |
| 2008-11-19 08:15:00 | AAPL | Stock | 3.1875 | 3.1875 | 3.1804 | 3.1804 | 30800.0 |
| 2008-11-19 08:20:00 | AAPL | Stock | 3.1811 | 3.1821 | 3.1789 | 3.1821 | 67200.0 |
| 2008-11-19 08:25:00 | AAPL | Stock | 3.1821 | 3.1875 | 3.1786 | 3.1793 | 71400.0 |
| 2008-11-19 08:30:00 | AAPL | Stock | 3.1832 | 3.1925 | 3.1832 | 3.1918 | 98476.0 |
| 2008-11-19 08:35:00 | AAPL | Stock | 3.1861 | 3.1875 | 3.1786 | 3.1832 | 289604.0 |
| 2008-11-19 08:40:00 | AAPL | Stock | 3.1832 | 3.1832 | 3.1811 | 3.1811 | 47600.0 |
| 2008-11-19 08:45:00 | AAPL | Stock | 3.1861 | 3.1864 | 3.1832 | 3.1839 | 250740.0 |
| 2008-11-19 08:50:00 | AAPL | Stock | 3.1839 | 3.1839 | 3.1725 | 3.1761 | 421064.0 |
| 2008-11-19 08:55:00 | AAPL | Stock | 3.1743 | 3.1746 | 3.1596 | 3.1618 | 297780.0 |
| 2008-11-19 09:00:00 | AAPL | Stock | 3.1629 | 3.1739 | 3.1629 | 3.1739 | 141092.0 |
| 2008-11-19 09:05:00 | AAPL | Stock | 3.1732 | 3.175 | 3.1661 | 3.1679 | 428652.0 |
| 2008-11-19 09:10:00 | AAPL | Stock | 3.1679 | 3.1889 | 3.1679 | 3.1879 | 371840.0 |
| 2008-11-19 09:15:00 | AAPL | Stock | 3.1889 | 3.1943 | 3.1836 | 3.1864 | 280084.0 |
| 2008-11-19 09:20:00 | AAPL | Stock | 3.1893 | 3.1943 | 3.1857 | 3.1911 | 228928.0 |
| 2008-11-19 09:25:00 | AAPL | Stock | 3.1911 | 3.2036 | 3.1911 | 3.1986 | 492016.0 |
| 2008-11-19 09:30:00 | AAPL | Stock | 3.1979 | 3.2211 | 3.1875 | 3.1943 | 20006056.0 |
| 2008-11-19 09:35:00 | AAPL | Stock | 3.1939 | 3.245 | 3.1939 | 3.2289 | 25028808.0 |
| 2008-11-19 09:40:00 | AAPL | Stock | 3.2286 | 3.2307 | 3.2043 | 3.2136 | 21251412.0 |
| 2008-11-19 09:45:00 | AAPL | Stock | 3.2143 | 3.2404 | 3.2086 | 3.2368 | 22364384.0 |
| 2008-11-19 09:50:00 | AAPL | Stock | 3.2368 | 3.2489 | 3.2107 | 3.2171 | 24620260.0 |
| 2008-11-19 09:55:00 | AAPL | Stock | 3.2168 | 3.2239 | 3.1989 | 3.2239 | 21202720.0 |
| 2008-11-19 10:00:00 | AAPL | Stock | 3.2239 | 3.2411 | 3.2179 | 3.2396 | 19488196.0 |
| 2008-11-19 10:05:00 | AAPL | Stock | 3.2396 | 3.2596 | 3.2264 | 3.2532 | 26697944.0 |
| 2008-11-19 10:10:00 | AAPL | Stock | 3.2525 | 3.2661 | 3.2457 | 3.2625 | 22695512.0 |
| 2008-11-19 10:15:00 | AAPL | Stock | 3.2627 | 3.2707 | 3.245 | 3.2468 | 20195028.0 |
| 2008-11-19 10:20:00 | AAPL | Stock | 3.2461 | 3.2564 | 3.2393 | 3.2543 | 19874260.0 |
| 2008-11-19 10:25:00 | AAPL | Stock | 3.2543 | 3.2596 | 3.2411 | 3.2482 | 16065196.0 |
| 2008-11-19 10:30:00 | AAPL | Stock | 3.2482 | 3.2511 | 3.235 | 3.2396 | 13763736.0 |
| 2008-11-19 10:35:00 | AAPL | Stock | 3.2404 | 3.2421 | 3.2318 | 3.2375 | 11290944.0 |
| 2008-11-19 10:40:00 | AAPL | Stock | 3.2375 | 3.2418 | 3.2296 | 3.2304 | 13310248.0 |
| 2008-11-19 10:45:00 | AAPL | Stock | 3.2304 | 3.2314 | 3.2029 | 3.2089 | 20281828.0 |
| 2008-11-19 10:50:00 | AAPL | Stock | 3.2086 | 3.2139 | 3.2036 | 3.2036 | 18575200.0 |
| 2008-11-19 10:55:00 | AAPL | Stock | 3.2039 | 3.2096 | 3.1968 | 3.2071 | 13657476.0 |
| 2008-11-19 11:00:00 | AAPL | Stock | 3.2068 | 3.2211 | 3.2043 | 3.2139 | 15609104.0 |
| 2008-11-19 11:05:00 | AAPL | Stock | 3.2143 | 3.2293 | 3.2143 | 3.2286 | 13305488.0 |
| 2008-11-19 11:10:00 | AAPL | Stock | 3.2286 | 3.2289 | 3.2143 | 3.2161 | 10354960.0 |
| 2008-11-19 11:15:00 | AAPL | Stock | 3.2168 | 3.2175 | 3.2011 | 3.2129 | 14823228.0 |
| 2008-11-19 11:20:00 | AAPL | Stock | 3.2125 | 3.2146 | 3.2018 | 3.2054 | 8281028.0 |
| 2008-11-19 11:25:00 | AAPL | Stock | 3.2061 | 3.2068 | 3.1864 | 3.1936 | 12883808.0 |
| 2008-11-19 11:30:00 | AAPL | Stock | 3.1936 | 3.2011 | 3.1786 | 3.1804 | 13110580.0 |
| 2008-11-19 11:35:00 | AAPL | Stock | 3.1804 | 3.1821 | 3.1632 | 3.1689 | 16229500.0 |
| 2008-11-19 11:40:00 | AAPL | Stock | 3.1693 | 3.1764 | 3.1625 | 3.1714 | 12221496.0 |
| 2008-11-19 11:45:00 | AAPL | Stock | 3.1714 | 3.175 | 3.1596 | 3.1707 | 10714592.0 |
> showing 50 of 311,683 rows — these rows as CSV