PREVIEW / stock_5min / 2007-03-13
file: by_date/stock_5min/2007/2007-03-13.parquet size: 3.6 MB rows: 256,831 symbols: 2,552
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-03-13 07:15:00 | AAPL | Stock | 3.2046 | 3.2125 | 3.2046 | 3.2089 | 19600.0 |
| 2007-03-13 07:45:00 | AAPL | Stock | 3.2011 | 3.2011 | 3.2 | 3.2 | 19600.0 |
| 2007-03-13 07:50:00 | AAPL | Stock | 3.2 | 3.2 | 3.2 | 3.2 | 5600.0 |
| 2007-03-13 07:55:00 | AAPL | Stock | 3.2 | 3.2018 | 3.2 | 3.2018 | 30800.0 |
| 2007-03-13 08:00:00 | AAPL | Stock | 3.1982 | 3.2064 | 3.1946 | 3.2064 | 310380.0 |
| 2007-03-13 08:05:00 | AAPL | Stock | 3.2068 | 3.2068 | 3.1989 | 3.2036 | 239372.0 |
| 2007-03-13 08:10:00 | AAPL | Stock | 3.2021 | 3.2025 | 3.1968 | 3.2025 | 112000.0 |
| 2007-03-13 08:15:00 | AAPL | Stock | 3.2025 | 3.2025 | 3.1968 | 3.1971 | 201600.0 |
| 2007-03-13 08:20:00 | AAPL | Stock | 3.1971 | 3.1986 | 3.1968 | 3.1986 | 68460.0 |
| 2007-03-13 08:30:00 | AAPL | Stock | 3.1989 | 3.1993 | 3.1971 | 3.1993 | 102200.0 |
| 2007-03-13 08:35:00 | AAPL | Stock | 3.1993 | 3.2 | 3.1986 | 3.1986 | 15988.0 |
| 2007-03-13 08:40:00 | AAPL | Stock | 3.1968 | 3.1982 | 3.1939 | 3.1964 | 234388.0 |
| 2007-03-13 08:45:00 | AAPL | Stock | 3.1964 | 3.2 | 3.1961 | 3.2 | 96600.0 |
| 2007-03-13 08:50:00 | AAPL | Stock | 3.2 | 3.2 | 3.1964 | 3.1971 | 52892.0 |
| 2007-03-13 08:55:00 | AAPL | Stock | 3.1975 | 3.2018 | 3.1964 | 3.1964 | 141820.0 |
| 2007-03-13 09:00:00 | AAPL | Stock | 3.1964 | 3.1964 | 3.1929 | 3.1929 | 192808.0 |
| 2007-03-13 09:05:00 | AAPL | Stock | 3.1943 | 3.1982 | 3.1932 | 3.1946 | 206500.0 |
| 2007-03-13 09:10:00 | AAPL | Stock | 3.1946 | 3.1982 | 3.1946 | 3.1964 | 169428.0 |
| 2007-03-13 09:15:00 | AAPL | Stock | 3.1975 | 3.1975 | 3.1964 | 3.1964 | 58828.0 |
| 2007-03-13 09:20:00 | AAPL | Stock | 3.1943 | 3.1964 | 3.1929 | 3.1929 | 81648.0 |
| 2007-03-13 09:25:00 | AAPL | Stock | 3.1961 | 3.1964 | 3.1929 | 3.1929 | 436884.0 |
| 2007-03-13 09:30:00 | AAPL | Stock | 3.1932 | 3.2086 | 3.1925 | 3.2039 | 19066096.0 |
| 2007-03-13 09:35:00 | AAPL | Stock | 3.2036 | 3.2043 | 3.1907 | 3.1955 | 15310540.0 |
| 2007-03-13 09:40:00 | AAPL | Stock | 3.1961 | 3.1986 | 3.1904 | 3.1943 | 17386740.0 |
| 2007-03-13 09:45:00 | AAPL | Stock | 3.1939 | 3.1989 | 3.1893 | 3.1961 | 15563464.0 |
| 2007-03-13 09:50:00 | AAPL | Stock | 3.1964 | 3.2054 | 3.1943 | 3.2025 | 13315932.0 |
| 2007-03-13 09:55:00 | AAPL | Stock | 3.2025 | 3.2064 | 3.1993 | 3.2057 | 10718764.0 |
| 2007-03-13 10:00:00 | AAPL | Stock | 3.2057 | 3.2096 | 3.2029 | 3.2082 | 14542780.0 |
| 2007-03-13 10:05:00 | AAPL | Stock | 3.2086 | 3.2086 | 3.2014 | 3.2064 | 12459216.0 |
| 2007-03-13 10:10:00 | AAPL | Stock | 3.2064 | 3.2182 | 3.2064 | 3.2168 | 27505968.0 |
| 2007-03-13 10:15:00 | AAPL | Stock | 3.2171 | 3.225 | 3.21 | 3.2236 | 21890820.0 |
| 2007-03-13 10:20:00 | AAPL | Stock | 3.2236 | 3.2282 | 3.2207 | 3.2239 | 16560292.0 |
| 2007-03-13 10:25:00 | AAPL | Stock | 3.2232 | 3.2286 | 3.2196 | 3.2286 | 11766188.0 |
| 2007-03-13 10:30:00 | AAPL | Stock | 3.2289 | 3.2311 | 3.2254 | 3.2282 | 19182016.0 |
| 2007-03-13 10:35:00 | AAPL | Stock | 3.2279 | 3.2321 | 3.2275 | 3.23 | 13280288.0 |
| 2007-03-13 10:40:00 | AAPL | Stock | 3.23 | 3.2357 | 3.2296 | 3.2304 | 14525364.0 |
| 2007-03-13 10:45:00 | AAPL | Stock | 3.2311 | 3.2311 | 3.225 | 3.2268 | 11248888.0 |
| 2007-03-13 10:50:00 | AAPL | Stock | 3.2271 | 3.2293 | 3.2236 | 3.2239 | 10440220.0 |
| 2007-03-13 10:55:00 | AAPL | Stock | 3.2243 | 3.2268 | 3.2218 | 3.2239 | 7320124.0 |
| 2007-03-13 11:00:00 | AAPL | Stock | 3.2239 | 3.2257 | 3.2218 | 3.2232 | 5612516.0 |
| 2007-03-13 11:05:00 | AAPL | Stock | 3.2232 | 3.2239 | 3.2189 | 3.2225 | 6360396.0 |
| 2007-03-13 11:10:00 | AAPL | Stock | 3.2229 | 3.2282 | 3.2225 | 3.2243 | 6773788.0 |
| 2007-03-13 11:15:00 | AAPL | Stock | 3.2246 | 3.2254 | 3.2182 | 3.2182 | 5928356.0 |
| 2007-03-13 11:20:00 | AAPL | Stock | 3.2182 | 3.2204 | 3.215 | 3.2164 | 11078424.0 |
| 2007-03-13 11:25:00 | AAPL | Stock | 3.2164 | 3.2164 | 3.2096 | 3.2111 | 13349812.0 |
| 2007-03-13 11:30:00 | AAPL | Stock | 3.2107 | 3.2139 | 3.2104 | 3.2121 | 5599496.0 |
| 2007-03-13 11:35:00 | AAPL | Stock | 3.2121 | 3.2129 | 3.2093 | 3.2125 | 4542440.0 |
| 2007-03-13 11:40:00 | AAPL | Stock | 3.2125 | 3.2161 | 3.2104 | 3.2139 | 5718748.0 |
| 2007-03-13 11:45:00 | AAPL | Stock | 3.2136 | 3.2143 | 3.2054 | 3.2054 | 12267976.0 |
| 2007-03-13 11:50:00 | AAPL | Stock | 3.2057 | 3.2075 | 3.2029 | 3.2064 | 8430240.0 |
> showing 50 of 256,831 rows — these rows as CSV