PREVIEW / stock_5min / 2007-04-16
file: by_date/stock_5min/2007/2007-04-16.parquet size: 3.6 MB rows: 259,512 symbols: 2,594
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-04-16 07:00:00 | AAPL | Stock | 3.2393 | 3.2393 | 3.2375 | 3.2375 | 26600.0 |
| 2007-04-16 07:05:00 | AAPL | Stock | 3.2389 | 3.2389 | 3.2389 | 3.2389 | 2800.0 |
| 2007-04-16 07:15:00 | AAPL | Stock | 3.2389 | 3.2389 | 3.2389 | 3.2389 | 5292.0 |
| 2007-04-16 07:25:00 | AAPL | Stock | 3.2371 | 3.2371 | 3.2371 | 3.2371 | 2800.0 |
| 2007-04-16 07:45:00 | AAPL | Stock | 3.2425 | 3.2425 | 3.2425 | 3.2425 | 3584.0 |
| 2007-04-16 07:50:00 | AAPL | Stock | 3.24 | 3.24 | 3.24 | 3.24 | 8400.0 |
| 2007-04-16 07:55:00 | AAPL | Stock | 3.24 | 3.24 | 3.2389 | 3.2389 | 19600.0 |
| 2007-04-16 08:00:00 | AAPL | Stock | 3.2418 | 3.2429 | 3.2236 | 3.2268 | 655844.0 |
| 2007-04-16 08:05:00 | AAPL | Stock | 3.2268 | 3.2325 | 3.2268 | 3.2325 | 156940.0 |
| 2007-04-16 08:10:00 | AAPL | Stock | 3.2325 | 3.2339 | 3.2325 | 3.2339 | 40600.0 |
| 2007-04-16 08:15:00 | AAPL | Stock | 3.235 | 3.235 | 3.2325 | 3.2325 | 75600.0 |
| 2007-04-16 08:20:00 | AAPL | Stock | 3.2321 | 3.2339 | 3.2321 | 3.2321 | 105000.0 |
| 2007-04-16 08:25:00 | AAPL | Stock | 3.2329 | 3.2339 | 3.2321 | 3.2321 | 59696.0 |
| 2007-04-16 08:30:00 | AAPL | Stock | 3.2321 | 3.2339 | 3.2321 | 3.2321 | 60228.0 |
| 2007-04-16 08:35:00 | AAPL | Stock | 3.2329 | 3.2357 | 3.2321 | 3.2321 | 159432.0 |
| 2007-04-16 08:40:00 | AAPL | Stock | 3.2321 | 3.2321 | 3.2268 | 3.2268 | 318444.0 |
| 2007-04-16 08:45:00 | AAPL | Stock | 3.2279 | 3.2321 | 3.225 | 3.225 | 673400.0 |
| 2007-04-16 08:50:00 | AAPL | Stock | 3.2246 | 3.225 | 3.2239 | 3.2243 | 259616.0 |
| 2007-04-16 08:55:00 | AAPL | Stock | 3.225 | 3.2268 | 3.2243 | 3.2268 | 522760.0 |
| 2007-04-16 09:00:00 | AAPL | Stock | 3.2311 | 3.2354 | 3.2268 | 3.2354 | 252196.0 |
| 2007-04-16 09:05:00 | AAPL | Stock | 3.2304 | 3.2304 | 3.2286 | 3.2286 | 364000.0 |
| 2007-04-16 09:10:00 | AAPL | Stock | 3.2311 | 3.2329 | 3.2286 | 3.2304 | 357448.0 |
| 2007-04-16 09:15:00 | AAPL | Stock | 3.2304 | 3.2304 | 3.2304 | 3.2304 | 147000.0 |
| 2007-04-16 09:20:00 | AAPL | Stock | 3.2304 | 3.2304 | 3.2275 | 3.2304 | 50400.0 |
| 2007-04-16 09:25:00 | AAPL | Stock | 3.2339 | 3.2361 | 3.2321 | 3.2354 | 228480.0 |
| 2007-04-16 09:30:00 | AAPL | Stock | 3.2346 | 3.2421 | 3.2232 | 3.2393 | 26370288.0 |
| 2007-04-16 09:35:00 | AAPL | Stock | 3.2396 | 3.2421 | 3.2282 | 3.2386 | 16558024.0 |
| 2007-04-16 09:40:00 | AAPL | Stock | 3.2389 | 3.2411 | 3.2329 | 3.2378 | 15986488.0 |
| 2007-04-16 09:45:00 | AAPL | Stock | 3.2375 | 3.2421 | 3.2357 | 3.2414 | 14425460.0 |
| 2007-04-16 09:50:00 | AAPL | Stock | 3.2414 | 3.2436 | 3.2321 | 3.2361 | 18438952.0 |
| 2007-04-16 09:55:00 | AAPL | Stock | 3.2361 | 3.2368 | 3.23 | 3.2343 | 8377796.0 |
| 2007-04-16 10:00:00 | AAPL | Stock | 3.2343 | 3.235 | 3.23 | 3.2321 | 6539792.0 |
| 2007-04-16 10:05:00 | AAPL | Stock | 3.2321 | 3.2386 | 3.2304 | 3.2354 | 11161472.0 |
| 2007-04-16 10:10:00 | AAPL | Stock | 3.2354 | 3.2393 | 3.2343 | 3.2343 | 6073564.0 |
| 2007-04-16 10:15:00 | AAPL | Stock | 3.2346 | 3.2368 | 3.2321 | 3.2329 | 5184732.0 |
| 2007-04-16 10:20:00 | AAPL | Stock | 3.2329 | 3.2354 | 3.2321 | 3.2336 | 4878692.0 |
| 2007-04-16 10:25:00 | AAPL | Stock | 3.2336 | 3.2346 | 3.2332 | 3.2343 | 4809588.0 |
| 2007-04-16 10:30:00 | AAPL | Stock | 3.2339 | 3.24 | 3.2339 | 3.2396 | 8789144.0 |
| 2007-04-16 10:35:00 | AAPL | Stock | 3.2396 | 3.2493 | 3.2393 | 3.2479 | 16937396.0 |
| 2007-04-16 10:40:00 | AAPL | Stock | 3.2475 | 3.2518 | 3.2446 | 3.2475 | 15939504.0 |
| 2007-04-16 10:45:00 | AAPL | Stock | 3.2475 | 3.2489 | 3.2443 | 3.2486 | 6997872.0 |
| 2007-04-16 10:50:00 | AAPL | Stock | 3.2486 | 3.2639 | 3.2471 | 3.2589 | 26335512.0 |
| 2007-04-16 10:55:00 | AAPL | Stock | 3.2589 | 3.26 | 3.2525 | 3.2536 | 14654052.0 |
| 2007-04-16 11:00:00 | AAPL | Stock | 3.2536 | 3.2539 | 3.2504 | 3.2518 | 5178236.0 |
| 2007-04-16 11:05:00 | AAPL | Stock | 3.2518 | 3.2546 | 3.2482 | 3.2532 | 6156612.0 |
| 2007-04-16 11:10:00 | AAPL | Stock | 3.2529 | 3.2532 | 3.2496 | 3.2518 | 5202148.0 |
| 2007-04-16 11:15:00 | AAPL | Stock | 3.2518 | 3.2539 | 3.2514 | 3.2539 | 4512508.0 |
| 2007-04-16 11:20:00 | AAPL | Stock | 3.2539 | 3.2543 | 3.2464 | 3.2475 | 6162660.0 |
| 2007-04-16 11:25:00 | AAPL | Stock | 3.2479 | 3.2496 | 3.2432 | 3.2446 | 5353236.0 |
| 2007-04-16 11:30:00 | AAPL | Stock | 3.2446 | 3.2543 | 3.2446 | 3.2532 | 9776844.0 |
> showing 50 of 259,512 rows — these rows as CSV