PREVIEW / stock_5min / 2010-09-29
file: by_date/stock_5min/2010/2010-09-29.parquet size: 4.7 MB rows: 320,621 symbols: 3,477
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 |
|---|---|---|---|---|---|---|---|
| 2010-09-29 05:15:00 | AAPL | Stock | 10.2682 | 10.2682 | 10.2682 | 10.2682 | 11200.0 |
| 2010-09-29 05:40:00 | AAPL | Stock | 10.2643 | 10.2643 | 10.2643 | 10.2643 | 2800.0 |
| 2010-09-29 05:45:00 | AAPL | Stock | 10.2607 | 10.2607 | 10.2607 | 10.2607 | 2800.0 |
| 2010-09-29 06:00:00 | AAPL | Stock | 10.2607 | 10.2607 | 10.2607 | 10.2607 | 5600.0 |
| 2010-09-29 06:25:00 | AAPL | Stock | 10.2607 | 10.2607 | 10.2607 | 10.2607 | 2800.0 |
| 2010-09-29 06:40:00 | AAPL | Stock | 10.2643 | 10.2643 | 10.2643 | 10.2643 | 2800.0 |
| 2010-09-29 06:45:00 | AAPL | Stock | 10.2643 | 10.2643 | 10.2643 | 10.2643 | 11200.0 |
| 2010-09-29 07:15:00 | AAPL | Stock | 10.3 | 10.3 | 10.3 | 10.3 | 2800.0 |
| 2010-09-29 07:25:00 | AAPL | Stock | 10.2661 | 10.2679 | 10.265 | 10.265 | 16800.0 |
| 2010-09-29 07:35:00 | AAPL | Stock | 10.2661 | 10.2661 | 10.2661 | 10.2661 | 4200.0 |
| 2010-09-29 07:45:00 | AAPL | Stock | 10.2654 | 10.2654 | 10.2589 | 10.2625 | 23800.0 |
| 2010-09-29 07:55:00 | AAPL | Stock | 10.2607 | 10.2654 | 10.2607 | 10.2654 | 16800.0 |
| 2010-09-29 08:00:00 | AAPL | Stock | 10.2607 | 10.2907 | 10.2607 | 10.2886 | 377916.0 |
| 2010-09-29 08:05:00 | AAPL | Stock | 10.2886 | 10.2896 | 10.2836 | 10.2886 | 557480.0 |
| 2010-09-29 08:10:00 | AAPL | Stock | 10.2886 | 10.2993 | 10.2857 | 10.2964 | 540568.0 |
| 2010-09-29 08:15:00 | AAPL | Stock | 10.2957 | 10.3039 | 10.2957 | 10.3014 | 301000.0 |
| 2010-09-29 08:20:00 | AAPL | Stock | 10.3 | 10.3082 | 10.2996 | 10.3036 | 408632.0 |
| 2010-09-29 08:25:00 | AAPL | Stock | 10.3036 | 10.3136 | 10.2918 | 10.2996 | 298676.0 |
| 2010-09-29 08:30:00 | AAPL | Stock | 10.2929 | 10.3325 | 10.2929 | 10.3171 | 1050448.0 |
| 2010-09-29 08:35:00 | AAPL | Stock | 10.3196 | 10.3214 | 10.3039 | 10.305 | 366016.0 |
| 2010-09-29 08:40:00 | AAPL | Stock | 10.3054 | 10.3086 | 10.3014 | 10.3025 | 273672.0 |
| 2010-09-29 08:45:00 | AAPL | Stock | 10.3004 | 10.3029 | 10.2907 | 10.2946 | 430892.0 |
| 2010-09-29 08:50:00 | AAPL | Stock | 10.2932 | 10.2982 | 10.2886 | 10.2932 | 252560.0 |
| 2010-09-29 08:55:00 | AAPL | Stock | 10.29 | 10.29 | 10.2746 | 10.2811 | 802424.0 |
| 2010-09-29 09:00:00 | AAPL | Stock | 10.2804 | 10.2811 | 10.2768 | 10.2804 | 234948.0 |
| 2010-09-29 09:05:00 | AAPL | Stock | 10.2768 | 10.2857 | 10.2768 | 10.2821 | 134652.0 |
| 2010-09-29 09:10:00 | AAPL | Stock | 10.2811 | 10.285 | 10.2804 | 10.2825 | 92400.0 |
| 2010-09-29 09:15:00 | AAPL | Stock | 10.2804 | 10.2804 | 10.2539 | 10.2661 | 515704.0 |
| 2010-09-29 09:20:00 | AAPL | Stock | 10.2639 | 10.2714 | 10.2639 | 10.2661 | 196000.0 |
| 2010-09-29 09:25:00 | AAPL | Stock | 10.2661 | 10.2729 | 10.2575 | 10.2657 | 318640.0 |
| 2010-09-29 09:30:00 | AAPL | Stock | 10.2661 | 10.3157 | 10.2371 | 10.2929 | 20419756.0 |
| 2010-09-29 09:35:00 | AAPL | Stock | 10.2929 | 10.3417 | 10.2857 | 10.3361 | 15794492.0 |
| 2010-09-29 09:40:00 | AAPL | Stock | 10.3349 | 10.3504 | 10.3239 | 10.3357 | 13056400.0 |
| 2010-09-29 09:45:00 | AAPL | Stock | 10.3354 | 10.3461 | 10.3082 | 10.3089 | 11917248.0 |
| 2010-09-29 09:50:00 | AAPL | Stock | 10.3094 | 10.3136 | 10.2769 | 10.2832 | 11980248.0 |
| 2010-09-29 09:55:00 | AAPL | Stock | 10.2831 | 10.3089 | 10.2768 | 10.3029 | 8310624.0 |
| 2010-09-29 10:00:00 | AAPL | Stock | 10.2975 | 10.3386 | 10.2954 | 10.3161 | 11039336.0 |
| 2010-09-29 10:05:00 | AAPL | Stock | 10.3166 | 10.3346 | 10.3139 | 10.3271 | 6988128.0 |
| 2010-09-29 10:10:00 | AAPL | Stock | 10.3261 | 10.3275 | 10.3093 | 10.3221 | 5558700.0 |
| 2010-09-29 10:15:00 | AAPL | Stock | 10.3214 | 10.3261 | 10.2879 | 10.2932 | 7366436.0 |
| 2010-09-29 10:20:00 | AAPL | Stock | 10.2911 | 10.2942 | 10.2598 | 10.2914 | 10244248.0 |
| 2010-09-29 10:25:00 | AAPL | Stock | 10.2914 | 10.2946 | 10.2661 | 10.2946 | 6218856.0 |
| 2010-09-29 10:30:00 | AAPL | Stock | 10.2936 | 10.3054 | 10.2821 | 10.3026 | 6511428.0 |
| 2010-09-29 10:35:00 | AAPL | Stock | 10.3043 | 10.3043 | 10.2775 | 10.3 | 5512500.0 |
| 2010-09-29 10:40:00 | AAPL | Stock | 10.3011 | 10.3036 | 10.2775 | 10.2854 | 4783520.0 |
| 2010-09-29 10:45:00 | AAPL | Stock | 10.2839 | 10.3036 | 10.2782 | 10.2986 | 3783836.0 |
| 2010-09-29 10:50:00 | AAPL | Stock | 10.2989 | 10.3054 | 10.2918 | 10.2979 | 6718628.0 |
| 2010-09-29 10:55:00 | AAPL | Stock | 10.2968 | 10.3021 | 10.2843 | 10.2956 | 6546232.0 |
| 2010-09-29 11:00:00 | AAPL | Stock | 10.2946 | 10.3143 | 10.29 | 10.3111 | 5134696.0 |
| 2010-09-29 11:05:00 | AAPL | Stock | 10.3099 | 10.3139 | 10.2964 | 10.2964 | 2479540.0 |
> showing 50 of 320,621 rows — these rows as CSV