PREVIEW / stock_5min / 2005-01-14
file: by_date/stock_5min/2005/2005-01-14.parquet size: 2.5 MB rows: 183,845 symbols: 1,915
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 |
|---|---|---|---|---|---|---|---|
| 2005-01-14 08:00:00 | AAPL | Stock | 1.2545 | 1.258 | 1.2502 | 1.2536 | 927864.0 |
| 2005-01-14 08:05:00 | AAPL | Stock | 1.2518 | 1.2518 | 1.2461 | 1.25 | 1207248.0 |
| 2005-01-14 08:10:00 | AAPL | Stock | 1.2516 | 1.2552 | 1.2516 | 1.2545 | 1813616.0 |
| 2005-01-14 08:15:00 | AAPL | Stock | 1.2527 | 1.2545 | 1.2518 | 1.2539 | 333200.0 |
| 2005-01-14 08:20:00 | AAPL | Stock | 1.2539 | 1.2545 | 1.2502 | 1.2518 | 286160.0 |
| 2005-01-14 08:25:00 | AAPL | Stock | 1.2518 | 1.253 | 1.2498 | 1.25 | 561120.0 |
| 2005-01-14 08:30:00 | AAPL | Stock | 1.25 | 1.2536 | 1.25 | 1.2518 | 504560.0 |
| 2005-01-14 08:35:00 | AAPL | Stock | 1.253 | 1.2536 | 1.2509 | 1.2525 | 138880.0 |
| 2005-01-14 08:40:00 | AAPL | Stock | 1.2527 | 1.2534 | 1.2527 | 1.2532 | 100800.0 |
| 2005-01-14 08:45:00 | AAPL | Stock | 1.2521 | 1.2539 | 1.2521 | 1.2539 | 336560.0 |
| 2005-01-14 08:50:00 | AAPL | Stock | 1.2539 | 1.2557 | 1.2536 | 1.2557 | 654192.0 |
| 2005-01-14 08:55:00 | AAPL | Stock | 1.2554 | 1.2605 | 1.2554 | 1.2591 | 974176.0 |
| 2005-01-14 09:00:00 | AAPL | Stock | 1.2591 | 1.2604 | 1.2584 | 1.2589 | 940408.0 |
| 2005-01-14 09:05:00 | AAPL | Stock | 1.2596 | 1.2598 | 1.257 | 1.257 | 634144.0 |
| 2005-01-14 09:10:00 | AAPL | Stock | 1.2564 | 1.2564 | 1.2545 | 1.2564 | 365680.0 |
| 2005-01-14 09:15:00 | AAPL | Stock | 1.2566 | 1.2589 | 1.2545 | 1.2554 | 1038800.0 |
| 2005-01-14 09:20:00 | AAPL | Stock | 1.2554 | 1.2554 | 1.252 | 1.2523 | 660800.0 |
| 2005-01-14 09:25:00 | AAPL | Stock | 1.2536 | 1.2554 | 1.2507 | 1.2541 | 2775024.0 |
| 2005-01-14 09:30:00 | AAPL | Stock | 1.2536 | 1.2598 | 1.2438 | 1.2488 | 70329000.0 |
| 2005-01-14 09:35:00 | AAPL | Stock | 1.2489 | 1.2539 | 1.2377 | 1.2446 | 61653200.0 |
| 2005-01-14 09:40:00 | AAPL | Stock | 1.2448 | 1.2464 | 1.2357 | 1.2375 | 47695704.0 |
| 2005-01-14 09:45:00 | AAPL | Stock | 1.237 | 1.2491 | 1.2355 | 1.2484 | 36510656.0 |
| 2005-01-14 09:50:00 | AAPL | Stock | 1.2486 | 1.2518 | 1.2446 | 1.2461 | 33114592.0 |
| 2005-01-14 09:55:00 | AAPL | Stock | 1.2461 | 1.2477 | 1.2409 | 1.2434 | 22874656.0 |
| 2005-01-14 10:00:00 | AAPL | Stock | 1.2436 | 1.2473 | 1.2393 | 1.2443 | 20238624.0 |
| 2005-01-14 10:05:00 | AAPL | Stock | 1.2443 | 1.2446 | 1.2423 | 1.2438 | 11813088.0 |
| 2005-01-14 10:10:00 | AAPL | Stock | 1.2438 | 1.2534 | 1.243 | 1.2518 | 38514168.0 |
| 2005-01-14 10:15:00 | AAPL | Stock | 1.2516 | 1.2545 | 1.2484 | 1.2496 | 27129480.0 |
| 2005-01-14 10:20:00 | AAPL | Stock | 1.2496 | 1.2518 | 1.2484 | 1.2507 | 11543392.0 |
| 2005-01-14 10:25:00 | AAPL | Stock | 1.2507 | 1.2571 | 1.2489 | 1.2571 | 20450920.0 |
| 2005-01-14 10:30:00 | AAPL | Stock | 1.257 | 1.2621 | 1.2566 | 1.2621 | 45648400.0 |
| 2005-01-14 10:35:00 | AAPL | Stock | 1.2621 | 1.2652 | 1.2604 | 1.2629 | 33937008.0 |
| 2005-01-14 10:40:00 | AAPL | Stock | 1.2629 | 1.272 | 1.2629 | 1.2686 | 50966272.0 |
| 2005-01-14 10:45:00 | AAPL | Stock | 1.2682 | 1.2777 | 1.268 | 1.2763 | 58292024.0 |
| 2005-01-14 10:50:00 | AAPL | Stock | 1.2763 | 1.2777 | 1.2723 | 1.2755 | 38049592.0 |
| 2005-01-14 10:55:00 | AAPL | Stock | 1.2754 | 1.277 | 1.2613 | 1.27 | 25071648.0 |
| 2005-01-14 11:00:00 | AAPL | Stock | 1.27 | 1.2773 | 1.27 | 1.2766 | 23646336.0 |
| 2005-01-14 11:05:00 | AAPL | Stock | 1.2766 | 1.2807 | 1.2745 | 1.2761 | 37289392.0 |
| 2005-01-14 11:10:00 | AAPL | Stock | 1.2763 | 1.2764 | 1.2705 | 1.2739 | 15799728.0 |
| 2005-01-14 11:15:00 | AAPL | Stock | 1.2734 | 1.2743 | 1.2679 | 1.2684 | 16348640.0 |
| 2005-01-14 11:20:00 | AAPL | Stock | 1.2686 | 1.2739 | 1.2684 | 1.2725 | 12240536.0 |
| 2005-01-14 11:25:00 | AAPL | Stock | 1.2725 | 1.2732 | 1.2688 | 1.2718 | 21109032.0 |
| 2005-01-14 11:30:00 | AAPL | Stock | 1.2714 | 1.2736 | 1.2704 | 1.2734 | 12237848.0 |
| 2005-01-14 11:35:00 | AAPL | Stock | 1.2736 | 1.275 | 1.2714 | 1.2734 | 14883232.0 |
| 2005-01-14 11:40:00 | AAPL | Stock | 1.273 | 1.2734 | 1.2645 | 1.2661 | 24626616.0 |
| 2005-01-14 11:45:00 | AAPL | Stock | 1.2661 | 1.2705 | 1.2659 | 1.2698 | 15588888.0 |
| 2005-01-14 11:50:00 | AAPL | Stock | 1.2698 | 1.2702 | 1.2664 | 1.2679 | 9995104.0 |
| 2005-01-14 11:55:00 | AAPL | Stock | 1.2679 | 1.2802 | 1.2675 | 1.2688 | 10880856.0 |
| 2005-01-14 12:00:00 | AAPL | Stock | 1.2684 | 1.2688 | 1.2632 | 1.2641 | 19416712.0 |
| 2005-01-14 12:05:00 | AAPL | Stock | 1.2641 | 1.2652 | 1.2588 | 1.2621 | 22611568.0 |
> showing 50 of 183,845 rows — these rows as CSV