PREVIEW / stock_5min / 2007-04-13
file: by_date/stock_5min/2007/2007-04-13.parquet size: 3.5 MB rows: 251,463 symbols: 2,577
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-13 06:55:00 | AAPL | Stock | 3.2318 | 3.2421 | 3.2318 | 3.2421 | 30800.0 |
| 2007-04-13 07:00:00 | AAPL | Stock | 3.2296 | 3.2296 | 3.2293 | 3.2293 | 14000.0 |
| 2007-04-13 07:05:00 | AAPL | Stock | 3.2296 | 3.2296 | 3.2296 | 3.2296 | 2800.0 |
| 2007-04-13 07:20:00 | AAPL | Stock | 3.2314 | 3.2314 | 3.2314 | 3.2314 | 2800.0 |
| 2007-04-13 07:25:00 | AAPL | Stock | 3.2357 | 3.2357 | 3.2357 | 3.2357 | 2800.0 |
| 2007-04-13 07:30:00 | AAPL | Stock | 3.2393 | 3.2393 | 3.2393 | 3.2393 | 51100.0 |
| 2007-04-13 07:35:00 | AAPL | Stock | 3.2411 | 3.2411 | 3.2357 | 3.2411 | 84000.0 |
| 2007-04-13 07:40:00 | AAPL | Stock | 3.2393 | 3.2411 | 3.2375 | 3.2393 | 551600.0 |
| 2007-04-13 07:45:00 | AAPL | Stock | 3.2393 | 3.2411 | 3.2379 | 3.2393 | 261100.0 |
| 2007-04-13 07:50:00 | AAPL | Stock | 3.2393 | 3.2393 | 3.2393 | 3.2393 | 14000.0 |
| 2007-04-13 07:55:00 | AAPL | Stock | 3.2389 | 3.2393 | 3.2375 | 3.2375 | 56000.0 |
| 2007-04-13 08:00:00 | AAPL | Stock | 3.2393 | 3.2393 | 3.2293 | 3.2393 | 964936.0 |
| 2007-04-13 08:05:00 | AAPL | Stock | 3.2389 | 3.2396 | 3.2357 | 3.2357 | 538356.0 |
| 2007-04-13 08:10:00 | AAPL | Stock | 3.2357 | 3.2382 | 3.2357 | 3.2364 | 526400.0 |
| 2007-04-13 08:15:00 | AAPL | Stock | 3.2368 | 3.2375 | 3.2357 | 3.2361 | 529676.0 |
| 2007-04-13 08:20:00 | AAPL | Stock | 3.2357 | 3.2368 | 3.225 | 3.2282 | 1001840.0 |
| 2007-04-13 08:25:00 | AAPL | Stock | 3.2275 | 3.2375 | 3.2268 | 3.2368 | 1221696.0 |
| 2007-04-13 08:30:00 | AAPL | Stock | 3.2357 | 3.2429 | 3.2343 | 3.2411 | 1473500.0 |
| 2007-04-13 08:35:00 | AAPL | Stock | 3.24 | 3.2421 | 3.2393 | 3.2421 | 1013740.0 |
| 2007-04-13 08:40:00 | AAPL | Stock | 3.2421 | 3.2443 | 3.2375 | 3.2418 | 3921960.0 |
| 2007-04-13 08:45:00 | AAPL | Stock | 3.2421 | 3.2532 | 3.2418 | 3.2479 | 2223368.0 |
| 2007-04-13 08:50:00 | AAPL | Stock | 3.2482 | 3.2482 | 3.2446 | 3.2461 | 623336.0 |
| 2007-04-13 08:55:00 | AAPL | Stock | 3.2457 | 3.2461 | 3.2411 | 3.2446 | 603876.0 |
| 2007-04-13 09:00:00 | AAPL | Stock | 3.2454 | 3.2643 | 3.2414 | 3.2643 | 2046212.0 |
| 2007-04-13 09:05:00 | AAPL | Stock | 3.2625 | 3.2625 | 3.2532 | 3.2571 | 939792.0 |
| 2007-04-13 09:10:00 | AAPL | Stock | 3.2571 | 3.2575 | 3.2554 | 3.2554 | 340872.0 |
| 2007-04-13 09:15:00 | AAPL | Stock | 3.2536 | 3.2586 | 3.2529 | 3.2554 | 376040.0 |
| 2007-04-13 09:20:00 | AAPL | Stock | 3.2557 | 3.2564 | 3.2482 | 3.2496 | 562716.0 |
| 2007-04-13 09:25:00 | AAPL | Stock | 3.2493 | 3.25 | 3.2436 | 3.2464 | 1320900.0 |
| 2007-04-13 09:30:00 | AAPL | Stock | 3.2464 | 3.2471 | 3.2321 | 3.245 | 46794776.0 |
| 2007-04-13 09:35:00 | AAPL | Stock | 3.2454 | 3.2511 | 3.2414 | 3.2425 | 20762532.0 |
| 2007-04-13 09:40:00 | AAPL | Stock | 3.2425 | 3.2643 | 3.2421 | 3.26 | 27193348.0 |
| 2007-04-13 09:45:00 | AAPL | Stock | 3.2596 | 3.2604 | 3.2554 | 3.2564 | 16791600.0 |
| 2007-04-13 09:50:00 | AAPL | Stock | 3.2564 | 3.2604 | 3.2521 | 3.2561 | 12736976.0 |
| 2007-04-13 09:55:00 | AAPL | Stock | 3.2564 | 3.2564 | 3.2457 | 3.2482 | 16074212.0 |
| 2007-04-13 10:00:00 | AAPL | Stock | 3.2482 | 3.2482 | 3.2393 | 3.2421 | 15498868.0 |
| 2007-04-13 10:05:00 | AAPL | Stock | 3.2421 | 3.2571 | 3.2339 | 3.2375 | 13914264.0 |
| 2007-04-13 10:10:00 | AAPL | Stock | 3.2371 | 3.2432 | 3.2357 | 3.2375 | 12274164.0 |
| 2007-04-13 10:15:00 | AAPL | Stock | 3.2375 | 3.2479 | 3.2371 | 3.2471 | 10143644.0 |
| 2007-04-13 10:20:00 | AAPL | Stock | 3.2471 | 3.2514 | 3.2457 | 3.2511 | 24406368.0 |
| 2007-04-13 10:25:00 | AAPL | Stock | 3.2511 | 3.2518 | 3.2468 | 3.2496 | 11519004.0 |
| 2007-04-13 10:30:00 | AAPL | Stock | 3.2496 | 3.25 | 3.2468 | 3.2493 | 7872396.0 |
| 2007-04-13 10:35:00 | AAPL | Stock | 3.2493 | 3.2554 | 3.2493 | 3.2529 | 13659380.0 |
| 2007-04-13 10:40:00 | AAPL | Stock | 3.2532 | 3.2564 | 3.2514 | 3.2529 | 9316328.0 |
| 2007-04-13 10:45:00 | AAPL | Stock | 3.2536 | 3.2539 | 3.2482 | 3.2496 | 7131572.0 |
| 2007-04-13 10:50:00 | AAPL | Stock | 3.2496 | 3.2525 | 3.2464 | 3.2468 | 7957236.0 |
| 2007-04-13 10:55:00 | AAPL | Stock | 3.2471 | 3.25 | 3.2443 | 3.2464 | 7248892.0 |
| 2007-04-13 11:00:00 | AAPL | Stock | 3.247 | 3.2482 | 3.2421 | 3.2436 | 8241212.0 |
| 2007-04-13 11:05:00 | AAPL | Stock | 3.2439 | 3.2446 | 3.2393 | 3.2446 | 9538704.0 |
| 2007-04-13 11:10:00 | AAPL | Stock | 3.2443 | 3.2464 | 3.2429 | 3.2464 | 5751928.0 |
> showing 50 of 251,463 rows — these rows as CSV