PREVIEW / stock_5min / 2008-12-05
file: by_date/stock_5min/2008/2008-12-05.parquet size: 4.3 MB rows: 308,870 symbols: 3,319
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-12-05 04:25:00 | AAPL | Stock | 3.2786 | 3.2786 | 3.2786 | 3.2786 | 2800.0 |
| 2008-12-05 04:35:00 | AAPL | Stock | 3.2714 | 3.2714 | 3.2714 | 3.2714 | 2800.0 |
| 2008-12-05 05:50:00 | AAPL | Stock | 3.2786 | 3.2786 | 3.2786 | 3.2786 | 2800.0 |
| 2008-12-05 07:25:00 | AAPL | Stock | 3.2429 | 3.2429 | 3.2429 | 3.2429 | 2800.0 |
| 2008-12-05 07:35:00 | AAPL | Stock | 3.2143 | 3.2143 | 3.2143 | 3.2143 | 14000.0 |
| 2008-12-05 07:50:00 | AAPL | Stock | 3.2321 | 3.2321 | 3.2321 | 3.2321 | 2800.0 |
| 2008-12-05 07:55:00 | AAPL | Stock | 3.2411 | 3.2411 | 3.2411 | 3.2411 | 2800.0 |
| 2008-12-05 08:00:00 | AAPL | Stock | 3.2321 | 3.2411 | 3.2232 | 3.2304 | 188580.0 |
| 2008-12-05 08:05:00 | AAPL | Stock | 3.2293 | 3.2321 | 3.2286 | 3.2314 | 152908.0 |
| 2008-12-05 08:10:00 | AAPL | Stock | 3.2286 | 3.2286 | 3.2214 | 3.225 | 45780.0 |
| 2008-12-05 08:15:00 | AAPL | Stock | 3.225 | 3.2286 | 3.2179 | 3.2225 | 317520.0 |
| 2008-12-05 08:20:00 | AAPL | Stock | 3.2232 | 3.2282 | 3.2214 | 3.2282 | 150080.0 |
| 2008-12-05 08:25:00 | AAPL | Stock | 3.2293 | 3.2404 | 3.2293 | 3.2404 | 249844.0 |
| 2008-12-05 08:30:00 | AAPL | Stock | 3.2404 | 3.2404 | 3.1961 | 3.2311 | 2987628.0 |
| 2008-12-05 08:35:00 | AAPL | Stock | 3.2286 | 3.2286 | 3.2079 | 3.2196 | 756756.0 |
| 2008-12-05 08:40:00 | AAPL | Stock | 3.2146 | 3.2179 | 3.2075 | 3.2075 | 382480.0 |
| 2008-12-05 08:45:00 | AAPL | Stock | 3.2107 | 3.2189 | 3.2107 | 3.2182 | 354200.0 |
| 2008-12-05 08:50:00 | AAPL | Stock | 3.2182 | 3.2293 | 3.2179 | 3.2279 | 291900.0 |
| 2008-12-05 08:55:00 | AAPL | Stock | 3.2286 | 3.2289 | 3.2207 | 3.2218 | 128800.0 |
| 2008-12-05 09:00:00 | AAPL | Stock | 3.2232 | 3.2275 | 3.2196 | 3.2225 | 192668.0 |
| 2008-12-05 09:05:00 | AAPL | Stock | 3.2229 | 3.2229 | 3.2171 | 3.22 | 151396.0 |
| 2008-12-05 09:10:00 | AAPL | Stock | 3.22 | 3.2261 | 3.2168 | 3.2179 | 224700.0 |
| 2008-12-05 09:15:00 | AAPL | Stock | 3.2168 | 3.2207 | 3.215 | 3.2207 | 140420.0 |
| 2008-12-05 09:20:00 | AAPL | Stock | 3.2214 | 3.2311 | 3.2214 | 3.2304 | 186564.0 |
| 2008-12-05 09:25:00 | AAPL | Stock | 3.2314 | 3.2371 | 3.2221 | 3.2282 | 566216.0 |
| 2008-12-05 09:30:00 | AAPL | Stock | 3.2268 | 3.2729 | 3.2221 | 3.2371 | 21166040.0 |
| 2008-12-05 09:35:00 | AAPL | Stock | 3.2368 | 3.2543 | 3.1936 | 3.2179 | 24885868.0 |
| 2008-12-05 09:40:00 | AAPL | Stock | 3.2179 | 3.23 | 3.1986 | 3.1989 | 20522264.0 |
| 2008-12-05 09:45:00 | AAPL | Stock | 3.1986 | 3.2089 | 3.1807 | 3.1814 | 16454144.0 |
| 2008-12-05 09:50:00 | AAPL | Stock | 3.1814 | 3.2121 | 3.1789 | 3.2007 | 17463516.0 |
| 2008-12-05 09:55:00 | AAPL | Stock | 3.2011 | 3.2068 | 3.1864 | 3.1911 | 13670916.0 |
| 2008-12-05 10:00:00 | AAPL | Stock | 3.1914 | 3.2061 | 3.1868 | 3.2007 | 11575116.0 |
| 2008-12-05 10:05:00 | AAPL | Stock | 3.2004 | 3.2107 | 3.1971 | 3.2071 | 12423236.0 |
| 2008-12-05 10:10:00 | AAPL | Stock | 3.2071 | 3.2079 | 3.1939 | 3.1986 | 11871972.0 |
| 2008-12-05 10:15:00 | AAPL | Stock | 3.1979 | 3.2043 | 3.1821 | 3.1896 | 14153916.0 |
| 2008-12-05 10:20:00 | AAPL | Stock | 3.1893 | 3.1896 | 3.1764 | 3.1846 | 17481352.0 |
| 2008-12-05 10:25:00 | AAPL | Stock | 3.1879 | 3.2057 | 3.1829 | 3.1996 | 12558168.0 |
| 2008-12-05 10:30:00 | AAPL | Stock | 3.1996 | 3.2093 | 3.195 | 3.1996 | 11368000.0 |
| 2008-12-05 10:35:00 | AAPL | Stock | 3.1996 | 3.2032 | 3.1875 | 3.1882 | 9359448.0 |
| 2008-12-05 10:40:00 | AAPL | Stock | 3.1884 | 3.1918 | 3.1736 | 3.185 | 12352816.0 |
| 2008-12-05 10:45:00 | AAPL | Stock | 3.185 | 3.2071 | 3.1843 | 3.2065 | 11640440.0 |
| 2008-12-05 10:50:00 | AAPL | Stock | 3.206 | 3.2214 | 3.2 | 3.2146 | 13937840.0 |
| 2008-12-05 10:55:00 | AAPL | Stock | 3.2161 | 3.2286 | 3.2093 | 3.2096 | 12326076.0 |
| 2008-12-05 11:00:00 | AAPL | Stock | 3.2099 | 3.2164 | 3.1979 | 3.2043 | 10629220.0 |
| 2008-12-05 11:05:00 | AAPL | Stock | 3.205 | 3.2189 | 3.2007 | 3.2171 | 9908024.0 |
| 2008-12-05 11:10:00 | AAPL | Stock | 3.2164 | 3.2275 | 3.2125 | 3.2182 | 8568420.0 |
| 2008-12-05 11:15:00 | AAPL | Stock | 3.2189 | 3.2257 | 3.2075 | 3.2168 | 6736744.0 |
| 2008-12-05 11:20:00 | AAPL | Stock | 3.2171 | 3.2196 | 3.2064 | 3.2071 | 4329052.0 |
| 2008-12-05 11:25:00 | AAPL | Stock | 3.2061 | 3.2096 | 3.1986 | 3.2025 | 5929056.0 |
| 2008-12-05 11:30:00 | AAPL | Stock | 3.2029 | 3.2129 | 3.1964 | 3.2086 | 8429820.0 |
> showing 50 of 308,870 rows — these rows as CSV