PREVIEW / stock_5min / 2009-01-08
file: by_date/stock_5min/2009/2009-01-08.parquet size: 4.3 MB rows: 304,488 symbols: 3,295
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-08 07:20:00 | AAPL | Stock | 3.2161 | 3.2161 | 3.2161 | 3.2161 | 4760.0 |
| 2009-01-08 07:25:00 | AAPL | Stock | 3.2161 | 3.2161 | 3.2161 | 3.2161 | 7000.0 |
| 2009-01-08 07:35:00 | AAPL | Stock | 3.2286 | 3.2286 | 3.2286 | 3.2286 | 2800.0 |
| 2009-01-08 07:45:00 | AAPL | Stock | 3.2164 | 3.2164 | 3.2164 | 3.2164 | 9800.0 |
| 2009-01-08 07:50:00 | AAPL | Stock | 3.2161 | 3.2161 | 3.2161 | 3.2161 | 12292.0 |
| 2009-01-08 07:55:00 | AAPL | Stock | 3.2282 | 3.2282 | 3.2282 | 3.2282 | 2800.0 |
| 2009-01-08 08:00:00 | AAPL | Stock | 3.2304 | 3.2304 | 3.2143 | 3.2214 | 304500.0 |
| 2009-01-08 08:05:00 | AAPL | Stock | 3.2161 | 3.2296 | 3.2161 | 3.2161 | 104832.0 |
| 2009-01-08 08:10:00 | AAPL | Stock | 3.2161 | 3.2214 | 3.2161 | 3.2214 | 32032.0 |
| 2009-01-08 08:15:00 | AAPL | Stock | 3.2214 | 3.2214 | 3.22 | 3.22 | 65100.0 |
| 2009-01-08 08:20:00 | AAPL | Stock | 3.2186 | 3.2196 | 3.2161 | 3.2179 | 165284.0 |
| 2009-01-08 08:25:00 | AAPL | Stock | 3.2175 | 3.2204 | 3.2157 | 3.2157 | 227724.0 |
| 2009-01-08 08:30:00 | AAPL | Stock | 3.2168 | 3.2207 | 3.2161 | 3.2175 | 165900.0 |
| 2009-01-08 08:35:00 | AAPL | Stock | 3.2211 | 3.2211 | 3.2179 | 3.2179 | 80080.0 |
| 2009-01-08 08:40:00 | AAPL | Stock | 3.2196 | 3.2204 | 3.2196 | 3.2204 | 14000.0 |
| 2009-01-08 08:45:00 | AAPL | Stock | 3.2196 | 3.2318 | 3.2196 | 3.2293 | 185192.0 |
| 2009-01-08 08:50:00 | AAPL | Stock | 3.2304 | 3.2304 | 3.2232 | 3.2293 | 121632.0 |
| 2009-01-08 08:55:00 | AAPL | Stock | 3.2239 | 3.2268 | 3.2236 | 3.2261 | 51100.0 |
| 2009-01-08 09:00:00 | AAPL | Stock | 3.2236 | 3.225 | 3.2236 | 3.225 | 21644.0 |
| 2009-01-08 09:05:00 | AAPL | Stock | 3.23 | 3.23 | 3.2239 | 3.2257 | 64400.0 |
| 2009-01-08 09:10:00 | AAPL | Stock | 3.2246 | 3.225 | 3.2246 | 3.225 | 50400.0 |
| 2009-01-08 09:15:00 | AAPL | Stock | 3.2296 | 3.2321 | 3.2296 | 3.2304 | 52024.0 |
| 2009-01-08 09:20:00 | AAPL | Stock | 3.23 | 3.2304 | 3.2264 | 3.2264 | 13356.0 |
| 2009-01-08 09:25:00 | AAPL | Stock | 3.2329 | 3.2396 | 3.2293 | 3.2321 | 92260.0 |
| 2009-01-08 09:30:00 | AAPL | Stock | 3.2321 | 3.2757 | 3.2286 | 3.2591 | 14392700.0 |
| 2009-01-08 09:35:00 | AAPL | Stock | 3.2593 | 3.2657 | 3.2471 | 3.2493 | 14578788.0 |
| 2009-01-08 09:40:00 | AAPL | Stock | 3.2493 | 3.2661 | 3.2471 | 3.2646 | 13800052.0 |
| 2009-01-08 09:45:00 | AAPL | Stock | 3.2639 | 3.2646 | 3.25 | 3.2546 | 11686444.0 |
| 2009-01-08 09:50:00 | AAPL | Stock | 3.2546 | 3.265 | 3.2429 | 3.2568 | 12066684.0 |
| 2009-01-08 09:55:00 | AAPL | Stock | 3.2567 | 3.26 | 3.2421 | 3.2439 | 14227192.0 |
| 2009-01-08 10:00:00 | AAPL | Stock | 3.2439 | 3.2529 | 3.2396 | 3.2446 | 10684940.0 |
| 2009-01-08 10:05:00 | AAPL | Stock | 3.2446 | 3.2493 | 3.2329 | 3.2386 | 10817380.0 |
| 2009-01-08 10:10:00 | AAPL | Stock | 3.2382 | 3.2443 | 3.2268 | 3.2321 | 9123744.0 |
| 2009-01-08 10:15:00 | AAPL | Stock | 3.2311 | 3.2343 | 3.2157 | 3.2189 | 9441236.0 |
| 2009-01-08 10:20:00 | AAPL | Stock | 3.2186 | 3.2296 | 3.2168 | 3.2239 | 8810564.0 |
| 2009-01-08 10:25:00 | AAPL | Stock | 3.2236 | 3.235 | 3.2193 | 3.2321 | 7152320.0 |
| 2009-01-08 10:30:00 | AAPL | Stock | 3.2318 | 3.2357 | 3.2232 | 3.2307 | 6960184.0 |
| 2009-01-08 10:35:00 | AAPL | Stock | 3.2307 | 3.2371 | 3.2286 | 3.2329 | 8049972.0 |
| 2009-01-08 10:40:00 | AAPL | Stock | 3.2329 | 3.2482 | 3.2325 | 3.2432 | 12161436.0 |
| 2009-01-08 10:45:00 | AAPL | Stock | 3.2439 | 3.2482 | 3.2418 | 3.2475 | 8941464.0 |
| 2009-01-08 10:50:00 | AAPL | Stock | 3.2479 | 3.26 | 3.2436 | 3.2518 | 9818172.0 |
| 2009-01-08 10:55:00 | AAPL | Stock | 3.2521 | 3.2571 | 3.2457 | 3.2564 | 6438796.0 |
| 2009-01-08 11:00:00 | AAPL | Stock | 3.2571 | 3.2675 | 3.2539 | 3.2671 | 6997172.0 |
| 2009-01-08 11:05:00 | AAPL | Stock | 3.2671 | 3.2679 | 3.255 | 3.2604 | 7584444.0 |
| 2009-01-08 11:10:00 | AAPL | Stock | 3.2593 | 3.2639 | 3.2536 | 3.2571 | 6353032.0 |
| 2009-01-08 11:15:00 | AAPL | Stock | 3.2575 | 3.2625 | 3.2557 | 3.26 | 4592672.0 |
| 2009-01-08 11:20:00 | AAPL | Stock | 3.2596 | 3.2643 | 3.2582 | 3.2607 | 4346860.0 |
| 2009-01-08 11:25:00 | AAPL | Stock | 3.2611 | 3.2625 | 3.2454 | 3.2457 | 7673960.0 |
| 2009-01-08 11:30:00 | AAPL | Stock | 3.2461 | 3.2464 | 3.2379 | 3.2436 | 9036748.0 |
| 2009-01-08 11:35:00 | AAPL | Stock | 3.2432 | 3.2464 | 3.2379 | 3.2439 | 5313728.0 |
> showing 50 of 304,488 rows — these rows as CSV