PREVIEW / stock_5min / 2008-04-30
file: by_date/stock_5min/2008/2008-04-30.parquet size: 4.4 MB rows: 311,450 symbols: 3,289
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 |
|---|---|---|---|---|---|---|---|
| 2008-04-30 04:15:00 | AAPL | Stock | 6.2318 | 6.2318 | 6.2318 | 6.2318 | 2800.0 |
| 2008-04-30 06:55:00 | AAPL | Stock | 6.2336 | 6.2336 | 6.2336 | 6.2336 | 2800.0 |
| 2008-04-30 07:35:00 | AAPL | Stock | 6.2668 | 6.2668 | 6.2657 | 6.2657 | 5600.0 |
| 2008-04-30 07:40:00 | AAPL | Stock | 6.2536 | 6.2536 | 6.25 | 6.25 | 85400.0 |
| 2008-04-30 07:45:00 | AAPL | Stock | 6.25 | 6.25 | 6.25 | 6.25 | 78400.0 |
| 2008-04-30 08:00:00 | AAPL | Stock | 6.2529 | 6.2679 | 6.2446 | 6.2589 | 502936.0 |
| 2008-04-30 08:05:00 | AAPL | Stock | 6.2639 | 6.2768 | 6.2639 | 6.2768 | 663096.0 |
| 2008-04-30 08:10:00 | AAPL | Stock | 6.275 | 6.2821 | 6.2739 | 6.2793 | 469196.0 |
| 2008-04-30 08:15:00 | AAPL | Stock | 6.2782 | 6.2875 | 6.2739 | 6.2821 | 778624.0 |
| 2008-04-30 08:20:00 | AAPL | Stock | 6.2843 | 6.2889 | 6.2768 | 6.2771 | 367976.0 |
| 2008-04-30 08:25:00 | AAPL | Stock | 6.2796 | 6.2857 | 6.2771 | 6.2821 | 228480.0 |
| 2008-04-30 08:30:00 | AAPL | Stock | 6.2843 | 6.3036 | 6.2825 | 6.295 | 1355872.0 |
| 2008-04-30 08:35:00 | AAPL | Stock | 6.2946 | 6.295 | 6.2543 | 6.2839 | 610288.0 |
| 2008-04-30 08:40:00 | AAPL | Stock | 6.2839 | 6.2932 | 6.2804 | 6.2932 | 612276.0 |
| 2008-04-30 08:45:00 | AAPL | Stock | 6.2946 | 6.2982 | 6.2857 | 6.2982 | 846524.0 |
| 2008-04-30 08:50:00 | AAPL | Stock | 6.3 | 6.3071 | 6.3 | 6.3043 | 439012.0 |
| 2008-04-30 08:55:00 | AAPL | Stock | 6.3043 | 6.3054 | 6.2979 | 6.3011 | 148400.0 |
| 2008-04-30 09:00:00 | AAPL | Stock | 6.3018 | 6.3054 | 6.3014 | 6.3039 | 233100.0 |
| 2008-04-30 09:05:00 | AAPL | Stock | 6.3054 | 6.3068 | 6.3032 | 6.3036 | 436548.0 |
| 2008-04-30 09:10:00 | AAPL | Stock | 6.3054 | 6.3107 | 6.3054 | 6.3104 | 273476.0 |
| 2008-04-30 09:15:00 | AAPL | Stock | 6.3089 | 6.31 | 6.2911 | 6.2954 | 631652.0 |
| 2008-04-30 09:20:00 | AAPL | Stock | 6.2954 | 6.2979 | 6.2907 | 6.2979 | 392000.0 |
| 2008-04-30 09:25:00 | AAPL | Stock | 6.2982 | 6.305 | 6.2929 | 6.2932 | 501368.0 |
| 2008-04-30 09:30:00 | AAPL | Stock | 6.2932 | 6.3175 | 6.2786 | 6.3171 | 33020764.0 |
| 2008-04-30 09:35:00 | AAPL | Stock | 6.3171 | 6.3382 | 6.3046 | 6.3243 | 30574124.0 |
| 2008-04-30 09:40:00 | AAPL | Stock | 6.3254 | 6.3561 | 6.3207 | 6.3546 | 25252752.0 |
| 2008-04-30 09:45:00 | AAPL | Stock | 6.3546 | 6.3704 | 6.3543 | 6.3696 | 29029588.0 |
| 2008-04-30 09:50:00 | AAPL | Stock | 6.3696 | 6.3782 | 6.3589 | 6.3596 | 27890268.0 |
| 2008-04-30 09:55:00 | AAPL | Stock | 6.3593 | 6.3679 | 6.34 | 6.3582 | 32997860.0 |
| 2008-04-30 10:00:00 | AAPL | Stock | 6.3582 | 6.3589 | 6.3404 | 6.3471 | 16630936.0 |
| 2008-04-30 10:05:00 | AAPL | Stock | 6.3471 | 6.355 | 6.3275 | 6.3446 | 15057420.0 |
| 2008-04-30 10:10:00 | AAPL | Stock | 6.3443 | 6.3482 | 6.334 | 6.3482 | 11551428.0 |
| 2008-04-30 10:15:00 | AAPL | Stock | 6.3475 | 6.355 | 6.33 | 6.3346 | 13635608.0 |
| 2008-04-30 10:20:00 | AAPL | Stock | 6.3346 | 6.3432 | 6.3307 | 6.3382 | 9084432.0 |
| 2008-04-30 10:25:00 | AAPL | Stock | 6.3375 | 6.3654 | 6.3375 | 6.3411 | 8673476.0 |
| 2008-04-30 10:30:00 | AAPL | Stock | 6.3407 | 6.3589 | 6.3375 | 6.3564 | 12388012.0 |
| 2008-04-30 10:35:00 | AAPL | Stock | 6.3557 | 6.3625 | 6.3507 | 6.3612 | 11491564.0 |
| 2008-04-30 10:40:00 | AAPL | Stock | 6.3621 | 6.37 | 6.3582 | 6.3682 | 11080272.0 |
| 2008-04-30 10:45:00 | AAPL | Stock | 6.3686 | 6.3686 | 6.3529 | 6.3607 | 10148824.0 |
| 2008-04-30 10:50:00 | AAPL | Stock | 6.3607 | 6.3757 | 6.36 | 6.3718 | 11450488.0 |
| 2008-04-30 10:55:00 | AAPL | Stock | 6.3718 | 6.3732 | 6.3614 | 6.3663 | 7586292.0 |
| 2008-04-30 11:00:00 | AAPL | Stock | 6.3664 | 6.3814 | 6.3655 | 6.3768 | 11196304.0 |
| 2008-04-30 11:05:00 | AAPL | Stock | 6.3768 | 6.3875 | 6.3736 | 6.3843 | 10818500.0 |
| 2008-04-30 11:10:00 | AAPL | Stock | 6.3832 | 6.3867 | 6.3779 | 6.3793 | 8354948.0 |
| 2008-04-30 11:15:00 | AAPL | Stock | 6.3782 | 6.3843 | 6.3764 | 6.3764 | 7120176.0 |
| 2008-04-30 11:20:00 | AAPL | Stock | 6.3764 | 6.3814 | 6.3682 | 6.37 | 8828540.0 |
| 2008-04-30 11:25:00 | AAPL | Stock | 6.3696 | 6.3839 | 6.3671 | 6.3807 | 9759120.0 |
| 2008-04-30 11:30:00 | AAPL | Stock | 6.3807 | 6.3839 | 6.3725 | 6.3757 | 6072640.0 |
| 2008-04-30 11:35:00 | AAPL | Stock | 6.3757 | 6.3761 | 6.3704 | 6.3718 | 6625920.0 |
| 2008-04-30 11:40:00 | AAPL | Stock | 6.3721 | 6.3729 | 6.3514 | 6.3539 | 11230380.0 |
> showing 50 of 311,450 rows — these rows as CSV