PREVIEW / stock_5min / 2007-09-25
file: by_date/stock_5min/2007/2007-09-25.parquet size: 4.1 MB rows: 302,154 symbols: 3,123
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-09-25 06:35:00 | AAPL | Stock | 5.2625 | 5.2625 | 5.25 | 5.25 | 84000.0 |
| 2007-09-25 06:50:00 | AAPL | Stock | 5.2504 | 5.2625 | 5.2504 | 5.2504 | 8400.0 |
| 2007-09-25 07:00:00 | AAPL | Stock | 5.2504 | 5.2504 | 5.2286 | 5.2357 | 353640.0 |
| 2007-09-25 07:05:00 | AAPL | Stock | 5.2293 | 5.2293 | 5.2293 | 5.2293 | 14700.0 |
| 2007-09-25 07:10:00 | AAPL | Stock | 5.2496 | 5.2496 | 5.2361 | 5.2361 | 14028.0 |
| 2007-09-25 07:20:00 | AAPL | Stock | 5.2429 | 5.2461 | 5.2429 | 5.2461 | 25200.0 |
| 2007-09-25 07:25:00 | AAPL | Stock | 5.2379 | 5.2386 | 5.2371 | 5.2371 | 20300.0 |
| 2007-09-25 07:30:00 | AAPL | Stock | 5.2386 | 5.2479 | 5.2386 | 5.2479 | 25200.0 |
| 2007-09-25 07:35:00 | AAPL | Stock | 5.2429 | 5.2457 | 5.2429 | 5.2457 | 28000.0 |
| 2007-09-25 07:40:00 | AAPL | Stock | 5.2361 | 5.2471 | 5.2361 | 5.2471 | 14000.0 |
| 2007-09-25 07:45:00 | AAPL | Stock | 5.2464 | 5.2464 | 5.2457 | 5.2457 | 8400.0 |
| 2007-09-25 07:50:00 | AAPL | Stock | 5.2471 | 5.2482 | 5.2471 | 5.2479 | 16800.0 |
| 2007-09-25 07:55:00 | AAPL | Stock | 5.2479 | 5.2479 | 5.2479 | 5.2479 | 2800.0 |
| 2007-09-25 08:00:00 | AAPL | Stock | 5.2464 | 5.2586 | 5.2429 | 5.2482 | 955556.0 |
| 2007-09-25 08:05:00 | AAPL | Stock | 5.2482 | 5.25 | 5.2418 | 5.2418 | 428260.0 |
| 2007-09-25 08:10:00 | AAPL | Stock | 5.2411 | 5.25 | 5.2379 | 5.25 | 385952.0 |
| 2007-09-25 08:15:00 | AAPL | Stock | 5.25 | 5.2561 | 5.25 | 5.2543 | 508060.0 |
| 2007-09-25 08:20:00 | AAPL | Stock | 5.255 | 5.2557 | 5.2511 | 5.2511 | 283388.0 |
| 2007-09-25 08:25:00 | AAPL | Stock | 5.2525 | 5.2532 | 5.2464 | 5.25 | 348740.0 |
| 2007-09-25 08:30:00 | AAPL | Stock | 5.2504 | 5.2546 | 5.2504 | 5.2546 | 226100.0 |
| 2007-09-25 08:35:00 | AAPL | Stock | 5.2554 | 5.2668 | 5.2536 | 5.2607 | 664384.0 |
| 2007-09-25 08:40:00 | AAPL | Stock | 5.2625 | 5.2636 | 5.2554 | 5.2571 | 122416.0 |
| 2007-09-25 08:45:00 | AAPL | Stock | 5.2575 | 5.2589 | 5.2575 | 5.2589 | 49140.0 |
| 2007-09-25 08:50:00 | AAPL | Stock | 5.2593 | 5.2625 | 5.2593 | 5.2607 | 300020.0 |
| 2007-09-25 08:55:00 | AAPL | Stock | 5.2596 | 5.2618 | 5.2554 | 5.2557 | 572376.0 |
| 2007-09-25 09:00:00 | AAPL | Stock | 5.2557 | 5.2557 | 5.2457 | 5.2457 | 1208312.0 |
| 2007-09-25 09:05:00 | AAPL | Stock | 5.2471 | 5.2496 | 5.2414 | 5.2493 | 821464.0 |
| 2007-09-25 09:10:00 | AAPL | Stock | 5.2493 | 5.25 | 5.2464 | 5.2493 | 573048.0 |
| 2007-09-25 09:15:00 | AAPL | Stock | 5.2493 | 5.2493 | 5.245 | 5.245 | 72352.0 |
| 2007-09-25 09:20:00 | AAPL | Stock | 5.2464 | 5.2464 | 5.2371 | 5.2436 | 215600.0 |
| 2007-09-25 09:25:00 | AAPL | Stock | 5.2446 | 5.2489 | 5.2411 | 5.245 | 638092.0 |
| 2007-09-25 09:30:00 | AAPL | Stock | 5.2461 | 5.2746 | 5.2436 | 5.2554 | 29383732.0 |
| 2007-09-25 09:35:00 | AAPL | Stock | 5.2561 | 5.2714 | 5.245 | 5.2611 | 19890276.0 |
| 2007-09-25 09:40:00 | AAPL | Stock | 5.2618 | 5.2703 | 5.2468 | 5.2554 | 15739444.0 |
| 2007-09-25 09:45:00 | AAPL | Stock | 5.2571 | 5.2929 | 5.2546 | 5.2886 | 25724860.0 |
| 2007-09-25 09:50:00 | AAPL | Stock | 5.2889 | 5.3007 | 5.2839 | 5.2896 | 21288372.0 |
| 2007-09-25 09:55:00 | AAPL | Stock | 5.29 | 5.2946 | 5.2807 | 5.2946 | 14127400.0 |
| 2007-09-25 10:00:00 | AAPL | Stock | 5.2946 | 5.33 | 5.2811 | 5.3243 | 35293300.0 |
| 2007-09-25 10:05:00 | AAPL | Stock | 5.3246 | 5.3571 | 5.3193 | 5.3539 | 40388376.0 |
| 2007-09-25 10:10:00 | AAPL | Stock | 5.3536 | 5.365 | 5.3407 | 5.3546 | 42074816.0 |
| 2007-09-25 10:15:00 | AAPL | Stock | 5.3546 | 5.3571 | 5.3346 | 5.3439 | 19851776.0 |
| 2007-09-25 10:20:00 | AAPL | Stock | 5.3436 | 5.3464 | 5.3282 | 5.3318 | 17204488.0 |
| 2007-09-25 10:25:00 | AAPL | Stock | 5.3318 | 5.3461 | 5.3257 | 5.3332 | 14466508.0 |
| 2007-09-25 10:30:00 | AAPL | Stock | 5.3325 | 5.35 | 5.3293 | 5.3493 | 11823000.0 |
| 2007-09-25 10:35:00 | AAPL | Stock | 5.3489 | 5.3561 | 5.3457 | 5.3507 | 16069648.0 |
| 2007-09-25 10:40:00 | AAPL | Stock | 5.3511 | 5.3532 | 5.3404 | 5.3471 | 9435888.0 |
| 2007-09-25 10:45:00 | AAPL | Stock | 5.3475 | 5.3486 | 5.3371 | 5.3371 | 10204124.0 |
| 2007-09-25 10:50:00 | AAPL | Stock | 5.3392 | 5.3393 | 5.3304 | 5.3357 | 8295448.0 |
| 2007-09-25 10:55:00 | AAPL | Stock | 5.3357 | 5.3443 | 5.3293 | 5.3372 | 9674000.0 |
| 2007-09-25 11:00:00 | AAPL | Stock | 5.3375 | 5.3475 | 5.3371 | 5.3427 | 8852368.0 |
> showing 50 of 302,154 rows — these rows as CSV