PREVIEW / stock_5min / 2010-06-07
file: by_date/stock_5min/2010/2010-06-07.parquet size: 4.8 MB rows: 331,137 symbols: 3,472
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 |
|---|---|---|---|---|---|---|---|
| 2010-06-07 05:30:00 | AAPL | Stock | 9.1754 | 9.1754 | 9.1754 | 9.1754 | 2800.0 |
| 2010-06-07 06:10:00 | AAPL | Stock | 9.1964 | 9.1964 | 9.1964 | 9.1964 | 2800.0 |
| 2010-06-07 06:20:00 | AAPL | Stock | 9.2193 | 9.2193 | 9.2193 | 9.2193 | 4284.0 |
| 2010-06-07 06:25:00 | AAPL | Stock | 9.2071 | 9.2071 | 9.2071 | 9.2071 | 24864.0 |
| 2010-06-07 06:40:00 | AAPL | Stock | 9.2143 | 9.2143 | 9.2143 | 9.2143 | 8400.0 |
| 2010-06-07 07:00:00 | AAPL | Stock | 9.2143 | 9.2143 | 9.1964 | 9.2143 | 140980.0 |
| 2010-06-07 07:05:00 | AAPL | Stock | 9.2286 | 9.2286 | 9.2275 | 9.2286 | 32956.0 |
| 2010-06-07 07:10:00 | AAPL | Stock | 9.2407 | 9.2461 | 9.2375 | 9.2446 | 76832.0 |
| 2010-06-07 07:15:00 | AAPL | Stock | 9.2271 | 9.2429 | 9.2271 | 9.2421 | 45920.0 |
| 2010-06-07 07:20:00 | AAPL | Stock | 9.2436 | 9.2468 | 9.2393 | 9.2432 | 59500.0 |
| 2010-06-07 07:25:00 | AAPL | Stock | 9.2425 | 9.2425 | 9.2368 | 9.2368 | 19600.0 |
| 2010-06-07 07:30:00 | AAPL | Stock | 9.2411 | 9.2418 | 9.2357 | 9.2407 | 58016.0 |
| 2010-06-07 07:35:00 | AAPL | Stock | 9.2393 | 9.2414 | 9.2214 | 9.2221 | 117936.0 |
| 2010-06-07 07:40:00 | AAPL | Stock | 9.2318 | 9.2318 | 9.2143 | 9.2143 | 41720.0 |
| 2010-06-07 07:45:00 | AAPL | Stock | 9.2111 | 9.2246 | 9.2111 | 9.2143 | 60172.0 |
| 2010-06-07 07:50:00 | AAPL | Stock | 9.2214 | 9.2282 | 9.2214 | 9.2282 | 25200.0 |
| 2010-06-07 07:55:00 | AAPL | Stock | 9.2146 | 9.2146 | 9.2143 | 9.2143 | 58548.0 |
| 2010-06-07 08:00:00 | AAPL | Stock | 9.2161 | 9.2232 | 9.1975 | 9.1975 | 637588.0 |
| 2010-06-07 08:05:00 | AAPL | Stock | 9.2025 | 9.2229 | 9.1964 | 9.2125 | 524272.0 |
| 2010-06-07 08:10:00 | AAPL | Stock | 9.2125 | 9.2189 | 9.2125 | 9.2179 | 188972.0 |
| 2010-06-07 08:15:00 | AAPL | Stock | 9.2196 | 9.2229 | 9.2179 | 9.2179 | 280504.0 |
| 2010-06-07 08:20:00 | AAPL | Stock | 9.2196 | 9.2386 | 9.2196 | 9.2386 | 571340.0 |
| 2010-06-07 08:25:00 | AAPL | Stock | 9.2371 | 9.2461 | 9.2325 | 9.2461 | 476812.0 |
| 2010-06-07 08:30:00 | AAPL | Stock | 9.2414 | 9.2496 | 9.2414 | 9.2482 | 273056.0 |
| 2010-06-07 08:35:00 | AAPL | Stock | 9.2464 | 9.2571 | 9.2464 | 9.2536 | 402976.0 |
| 2010-06-07 08:40:00 | AAPL | Stock | 9.2554 | 9.2554 | 9.2339 | 9.2396 | 532896.0 |
| 2010-06-07 08:45:00 | AAPL | Stock | 9.2393 | 9.2436 | 9.2286 | 9.2436 | 245840.0 |
| 2010-06-07 08:50:00 | AAPL | Stock | 9.2432 | 9.2461 | 9.2236 | 9.2239 | 363272.0 |
| 2010-06-07 08:55:00 | AAPL | Stock | 9.2286 | 9.2354 | 9.2254 | 9.2261 | 173124.0 |
| 2010-06-07 09:00:00 | AAPL | Stock | 9.2293 | 9.2314 | 9.2225 | 9.2268 | 317100.0 |
| 2010-06-07 09:05:00 | AAPL | Stock | 9.2268 | 9.2371 | 9.2246 | 9.2371 | 208320.0 |
| 2010-06-07 09:10:00 | AAPL | Stock | 9.2368 | 9.2382 | 9.2329 | 9.2357 | 168336.0 |
| 2010-06-07 09:15:00 | AAPL | Stock | 9.2375 | 9.2436 | 9.2225 | 9.2225 | 346500.0 |
| 2010-06-07 09:20:00 | AAPL | Stock | 9.2236 | 9.2243 | 9.215 | 9.2168 | 427532.0 |
| 2010-06-07 09:25:00 | AAPL | Stock | 9.2164 | 9.2325 | 9.2089 | 9.2271 | 655564.0 |
| 2010-06-07 09:30:00 | AAPL | Stock | 9.2246 | 9.2554 | 9.2175 | 9.2242 | 21200480.0 |
| 2010-06-07 09:35:00 | AAPL | Stock | 9.2257 | 9.2279 | 9.1993 | 9.2079 | 18687788.0 |
| 2010-06-07 09:40:00 | AAPL | Stock | 9.2075 | 9.2096 | 9.1732 | 9.175 | 16632084.0 |
| 2010-06-07 09:45:00 | AAPL | Stock | 9.175 | 9.2168 | 9.1521 | 9.2136 | 16117724.0 |
| 2010-06-07 09:50:00 | AAPL | Stock | 9.2136 | 9.2357 | 9.1986 | 9.235 | 13660220.0 |
| 2010-06-07 09:55:00 | AAPL | Stock | 9.2357 | 9.2475 | 9.2224 | 9.235 | 10087756.0 |
| 2010-06-07 10:00:00 | AAPL | Stock | 9.235 | 9.2371 | 9.205 | 9.2204 | 9514204.0 |
| 2010-06-07 10:05:00 | AAPL | Stock | 9.22 | 9.2232 | 9.2075 | 9.2125 | 7828464.0 |
| 2010-06-07 10:10:00 | AAPL | Stock | 9.2129 | 9.2232 | 9.1964 | 9.1975 | 10280564.0 |
| 2010-06-07 10:15:00 | AAPL | Stock | 9.1975 | 9.2036 | 9.1804 | 9.1807 | 8324848.0 |
| 2010-06-07 10:20:00 | AAPL | Stock | 9.1804 | 9.1829 | 9.1564 | 9.1782 | 10837372.0 |
| 2010-06-07 10:25:00 | AAPL | Stock | 9.1764 | 9.1875 | 9.1554 | 9.1643 | 6190576.0 |
| 2010-06-07 10:30:00 | AAPL | Stock | 9.1643 | 9.1693 | 9.1261 | 9.135 | 11844868.0 |
| 2010-06-07 10:35:00 | AAPL | Stock | 9.1359 | 9.1454 | 9.0864 | 9.0939 | 18437944.0 |
| 2010-06-07 10:40:00 | AAPL | Stock | 9.095 | 9.1279 | 9.095 | 9.1111 | 8488060.0 |
> showing 50 of 331,137 rows — these rows as CSV