PREVIEW / stock_5min / 2012-02-02
file: by_date/stock_5min/2012/2012-02-02.parquet size: 4.9 MB rows: 332,463 symbols: 3,525
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 |
|---|---|---|---|---|---|---|---|
| 2012-02-02 05:05:00 | AAPL | Stock | 16.3286 | 16.3286 | 16.3286 | 16.3286 | 2800.0 |
| 2012-02-02 05:15:00 | AAPL | Stock | 16.3214 | 16.3218 | 16.3214 | 16.3218 | 19600.0 |
| 2012-02-02 05:20:00 | AAPL | Stock | 16.3214 | 16.3214 | 16.3214 | 16.3214 | 2800.0 |
| 2012-02-02 05:30:00 | AAPL | Stock | 16.3571 | 16.3571 | 16.3346 | 16.3346 | 45528.0 |
| 2012-02-02 05:35:00 | AAPL | Stock | 16.3286 | 16.3286 | 16.3214 | 16.3214 | 33600.0 |
| 2012-02-02 05:40:00 | AAPL | Stock | 16.3214 | 16.3214 | 16.3214 | 16.3214 | 2800.0 |
| 2012-02-02 06:45:00 | AAPL | Stock | 16.3036 | 16.3036 | 16.3036 | 16.3036 | 2800.0 |
| 2012-02-02 07:00:00 | AAPL | Stock | 16.3196 | 16.3196 | 16.3036 | 16.3036 | 5600.0 |
| 2012-02-02 07:05:00 | AAPL | Stock | 16.3036 | 16.3036 | 16.3036 | 16.3036 | 14000.0 |
| 2012-02-02 07:15:00 | AAPL | Stock | 16.2868 | 16.2868 | 16.2868 | 16.2868 | 2800.0 |
| 2012-02-02 08:00:00 | AAPL | Stock | 16.2925 | 16.3161 | 16.29 | 16.29 | 113316.0 |
| 2012-02-02 08:05:00 | AAPL | Stock | 16.2875 | 16.2875 | 16.2861 | 16.2861 | 8400.0 |
| 2012-02-02 08:10:00 | AAPL | Stock | 16.2875 | 16.2875 | 16.2857 | 16.2861 | 28000.0 |
| 2012-02-02 08:15:00 | AAPL | Stock | 16.2864 | 16.2893 | 16.2864 | 16.2889 | 16772.0 |
| 2012-02-02 08:20:00 | AAPL | Stock | 16.2893 | 16.2896 | 16.2821 | 16.2839 | 119056.0 |
| 2012-02-02 08:25:00 | AAPL | Stock | 16.2821 | 16.2893 | 16.2821 | 16.2875 | 54320.0 |
| 2012-02-02 08:35:00 | AAPL | Stock | 16.3036 | 16.3107 | 16.3 | 16.3107 | 48860.0 |
| 2012-02-02 08:40:00 | AAPL | Stock | 16.3104 | 16.3104 | 16.3 | 16.3 | 38920.0 |
| 2012-02-02 08:45:00 | AAPL | Stock | 16.3068 | 16.3089 | 16.2925 | 16.2925 | 60928.0 |
| 2012-02-02 08:50:00 | AAPL | Stock | 16.2925 | 16.2989 | 16.2925 | 16.2932 | 49504.0 |
| 2012-02-02 08:55:00 | AAPL | Stock | 16.2946 | 16.2989 | 16.2936 | 16.2946 | 34720.0 |
| 2012-02-02 09:00:00 | AAPL | Stock | 16.2964 | 16.2986 | 16.2961 | 16.2986 | 13160.0 |
| 2012-02-02 09:05:00 | AAPL | Stock | 16.2964 | 16.2989 | 16.2964 | 16.2989 | 17444.0 |
| 2012-02-02 09:10:00 | AAPL | Stock | 16.2946 | 16.2986 | 16.2932 | 16.2986 | 45360.0 |
| 2012-02-02 09:15:00 | AAPL | Stock | 16.3032 | 16.3032 | 16.2946 | 16.2946 | 22400.0 |
| 2012-02-02 09:20:00 | AAPL | Stock | 16.2896 | 16.3036 | 16.2896 | 16.3036 | 106400.0 |
| 2012-02-02 09:25:00 | AAPL | Stock | 16.3036 | 16.3039 | 16.2693 | 16.2825 | 291956.0 |
| 2012-02-02 09:30:00 | AAPL | Stock | 16.2821 | 16.3275 | 16.2611 | 16.3052 | 8263276.0 |
| 2012-02-02 09:35:00 | AAPL | Stock | 16.3083 | 16.31 | 16.2661 | 16.2811 | 5293484.0 |
| 2012-02-02 09:40:00 | AAPL | Stock | 16.2779 | 16.288 | 16.2707 | 16.2789 | 3463124.0 |
| 2012-02-02 09:45:00 | AAPL | Stock | 16.2768 | 16.2846 | 16.2575 | 16.2657 | 4055184.0 |
| 2012-02-02 09:50:00 | AAPL | Stock | 16.2662 | 16.2679 | 16.255 | 16.2584 | 3357872.0 |
| 2012-02-02 09:55:00 | AAPL | Stock | 16.2575 | 16.2689 | 16.2561 | 16.2593 | 2968196.0 |
| 2012-02-02 10:00:00 | AAPL | Stock | 16.2618 | 16.2836 | 16.2593 | 16.2796 | 3698436.0 |
| 2012-02-02 10:05:00 | AAPL | Stock | 16.2809 | 16.2946 | 16.2696 | 16.2946 | 3617880.0 |
| 2012-02-02 10:10:00 | AAPL | Stock | 16.2946 | 16.295 | 16.2704 | 16.2721 | 2823436.0 |
| 2012-02-02 10:15:00 | AAPL | Stock | 16.2745 | 16.2818 | 16.2625 | 16.2629 | 2487996.0 |
| 2012-02-02 10:20:00 | AAPL | Stock | 16.2646 | 16.2657 | 16.2357 | 16.2568 | 6819344.0 |
| 2012-02-02 10:25:00 | AAPL | Stock | 16.2578 | 16.2696 | 16.255 | 16.2643 | 2447060.0 |
| 2012-02-02 10:30:00 | AAPL | Stock | 16.2656 | 16.2725 | 16.2571 | 16.2611 | 1358504.0 |
| 2012-02-02 10:35:00 | AAPL | Stock | 16.2618 | 16.275 | 16.2604 | 16.2659 | 1754928.0 |
| 2012-02-02 10:40:00 | AAPL | Stock | 16.2675 | 16.2768 | 16.26 | 16.2664 | 2254196.0 |
| 2012-02-02 10:45:00 | AAPL | Stock | 16.2686 | 16.2779 | 16.2596 | 16.2718 | 2533384.0 |
| 2012-02-02 10:50:00 | AAPL | Stock | 16.2743 | 16.2764 | 16.2618 | 16.2707 | 1715056.0 |
| 2012-02-02 10:55:00 | AAPL | Stock | 16.2732 | 16.2768 | 16.2604 | 16.2639 | 1774780.0 |
| 2012-02-02 11:00:00 | AAPL | Stock | 16.267 | 16.2746 | 16.2621 | 16.2689 | 1173032.0 |
| 2012-02-02 11:05:00 | AAPL | Stock | 16.2693 | 16.2718 | 16.2629 | 16.2696 | 1313676.0 |
| 2012-02-02 11:10:00 | AAPL | Stock | 16.2682 | 16.2711 | 16.2571 | 16.2629 | 1498420.0 |
| 2012-02-02 11:15:00 | AAPL | Stock | 16.2613 | 16.2629 | 16.2464 | 16.25 | 2749348.0 |
| 2012-02-02 11:20:00 | AAPL | Stock | 16.2504 | 16.2618 | 16.2489 | 16.26 | 1500492.0 |
> showing 50 of 332,463 rows — these rows as CSV