PREVIEW / stock_5min / 2009-01-27
file: by_date/stock_5min/2009/2009-01-27.parquet size: 4.3 MB rows: 304,235 symbols: 3,300
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-01-27 04:15:00 | AAPL | Stock | 3.2143 | 3.2143 | 3.2121 | 3.2121 | 16800.0 |
| 2009-01-27 05:25:00 | AAPL | Stock | 3.2121 | 3.2121 | 3.2121 | 3.2121 | 5600.0 |
| 2009-01-27 06:55:00 | AAPL | Stock | 3.2111 | 3.2111 | 3.2111 | 3.2111 | 2800.0 |
| 2009-01-27 08:00:00 | AAPL | Stock | 3.2 | 3.2 | 3.1982 | 3.2 | 20720.0 |
| 2009-01-27 08:10:00 | AAPL | Stock | 3.2025 | 3.2025 | 3.1986 | 3.1986 | 16912.0 |
| 2009-01-27 08:15:00 | AAPL | Stock | 3.1993 | 3.2143 | 3.1982 | 3.2125 | 209580.0 |
| 2009-01-27 08:20:00 | AAPL | Stock | 3.2143 | 3.2293 | 3.2125 | 3.2293 | 246820.0 |
| 2009-01-27 08:25:00 | AAPL | Stock | 3.2293 | 3.2357 | 3.2289 | 3.2289 | 467852.0 |
| 2009-01-27 08:30:00 | AAPL | Stock | 3.2268 | 3.2318 | 3.2186 | 3.2232 | 189000.0 |
| 2009-01-27 08:35:00 | AAPL | Stock | 3.2232 | 3.23 | 3.2232 | 3.23 | 153160.0 |
| 2009-01-27 08:40:00 | AAPL | Stock | 3.23 | 3.2321 | 3.225 | 3.225 | 388640.0 |
| 2009-01-27 08:45:00 | AAPL | Stock | 3.2268 | 3.2268 | 3.2268 | 3.2268 | 28000.0 |
| 2009-01-27 08:50:00 | AAPL | Stock | 3.2261 | 3.2289 | 3.2261 | 3.2289 | 67200.0 |
| 2009-01-27 08:55:00 | AAPL | Stock | 3.2304 | 3.2321 | 3.23 | 3.2318 | 467600.0 |
| 2009-01-27 09:00:00 | AAPL | Stock | 3.2318 | 3.2329 | 3.2268 | 3.2293 | 209860.0 |
| 2009-01-27 09:05:00 | AAPL | Stock | 3.2289 | 3.2293 | 3.2279 | 3.2293 | 60760.0 |
| 2009-01-27 09:10:00 | AAPL | Stock | 3.2304 | 3.2332 | 3.2304 | 3.2332 | 56840.0 |
| 2009-01-27 09:15:00 | AAPL | Stock | 3.2321 | 3.2339 | 3.2286 | 3.2321 | 255612.0 |
| 2009-01-27 09:20:00 | AAPL | Stock | 3.2321 | 3.2321 | 3.2314 | 3.2314 | 157024.0 |
| 2009-01-27 09:25:00 | AAPL | Stock | 3.2286 | 3.2314 | 3.2229 | 3.225 | 249200.0 |
| 2009-01-27 09:30:00 | AAPL | Stock | 3.2232 | 3.2261 | 3.205 | 3.2125 | 14377776.0 |
| 2009-01-27 09:35:00 | AAPL | Stock | 3.2125 | 3.2386 | 3.2121 | 3.2332 | 16542848.0 |
| 2009-01-27 09:40:00 | AAPL | Stock | 3.2343 | 3.2371 | 3.2236 | 3.2357 | 10712940.0 |
| 2009-01-27 09:45:00 | AAPL | Stock | 3.2357 | 3.2414 | 3.2254 | 3.2332 | 12501692.0 |
| 2009-01-27 09:50:00 | AAPL | Stock | 3.2325 | 3.24 | 3.2321 | 3.2339 | 7676648.0 |
| 2009-01-27 09:55:00 | AAPL | Stock | 3.2346 | 3.2454 | 3.2143 | 3.2296 | 14609224.0 |
| 2009-01-27 10:00:00 | AAPL | Stock | 3.2293 | 3.2318 | 3.2214 | 3.2293 | 10875872.0 |
| 2009-01-27 10:05:00 | AAPL | Stock | 3.2293 | 3.2304 | 3.205 | 3.2121 | 13568772.0 |
| 2009-01-27 10:10:00 | AAPL | Stock | 3.2118 | 3.2179 | 3.2071 | 3.2161 | 9540328.0 |
| 2009-01-27 10:15:00 | AAPL | Stock | 3.2157 | 3.2179 | 3.2093 | 3.2179 | 6673436.0 |
| 2009-01-27 10:20:00 | AAPL | Stock | 3.2175 | 3.2268 | 3.2161 | 3.2218 | 8465968.0 |
| 2009-01-27 10:25:00 | AAPL | Stock | 3.2218 | 3.2261 | 3.2143 | 3.2157 | 5111876.0 |
| 2009-01-27 10:30:00 | AAPL | Stock | 3.2157 | 3.2232 | 3.2143 | 3.2196 | 6627404.0 |
| 2009-01-27 10:35:00 | AAPL | Stock | 3.2207 | 3.2246 | 3.2175 | 3.2179 | 6327272.0 |
| 2009-01-27 10:40:00 | AAPL | Stock | 3.2182 | 3.2182 | 3.2107 | 3.2143 | 7750680.0 |
| 2009-01-27 10:45:00 | AAPL | Stock | 3.2143 | 3.2168 | 3.2096 | 3.2121 | 5965288.0 |
| 2009-01-27 10:50:00 | AAPL | Stock | 3.2125 | 3.2143 | 3.2054 | 3.2064 | 6376580.0 |
| 2009-01-27 10:55:00 | AAPL | Stock | 3.2064 | 3.2175 | 3.2054 | 3.2157 | 8919820.0 |
| 2009-01-27 11:00:00 | AAPL | Stock | 3.2161 | 3.2175 | 3.2132 | 3.2139 | 4983300.0 |
| 2009-01-27 11:05:00 | AAPL | Stock | 3.2132 | 3.2211 | 3.2093 | 3.2168 | 6068720.0 |
| 2009-01-27 11:10:00 | AAPL | Stock | 3.2168 | 3.2193 | 3.2143 | 3.2175 | 4247404.0 |
| 2009-01-27 11:15:00 | AAPL | Stock | 3.2175 | 3.2304 | 3.2175 | 3.2243 | 9191980.0 |
| 2009-01-27 11:20:00 | AAPL | Stock | 3.2243 | 3.2268 | 3.2218 | 3.2243 | 4509932.0 |
| 2009-01-27 11:25:00 | AAPL | Stock | 3.225 | 3.2279 | 3.2218 | 3.2268 | 3669960.0 |
| 2009-01-27 11:30:00 | AAPL | Stock | 3.2268 | 3.2307 | 3.2179 | 3.2192 | 6872516.0 |
| 2009-01-27 11:35:00 | AAPL | Stock | 3.2189 | 3.2189 | 3.2118 | 3.2154 | 5974248.0 |
| 2009-01-27 11:40:00 | AAPL | Stock | 3.2154 | 3.2179 | 3.2107 | 3.2143 | 4425288.0 |
| 2009-01-27 11:45:00 | AAPL | Stock | 3.2139 | 3.2264 | 3.2136 | 3.2211 | 5502840.0 |
| 2009-01-27 11:50:00 | AAPL | Stock | 3.2211 | 3.2286 | 3.2207 | 3.2271 | 2858884.0 |
| 2009-01-27 11:55:00 | AAPL | Stock | 3.2275 | 3.23 | 3.2207 | 3.2239 | 5719196.0 |
> showing 50 of 304,235 rows — these rows as CSV