PREVIEW / stock_30min / 2006-11-30
file: by_date/stock_30min/2006/2006-11-30.parquet size: 978 KB rows: 52,460 symbols: 2,457
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 |
|---|---|---|---|---|---|---|---|
| 2006-11-30 06:30:00 | AAPL | Stock | 3.2914 | 3.2914 | 3.2914 | 3.2914 | 2800.0 |
| 2006-11-30 07:00:00 | AAPL | Stock | 3.3014 | 3.3014 | 3.29 | 3.29 | 16800.0 |
| 2006-11-30 07:30:00 | AAPL | Stock | 3.3014 | 3.3271 | 3.2996 | 3.3161 | 1330280.0 |
| 2006-11-30 08:00:00 | AAPL | Stock | 3.3168 | 3.3214 | 3.3043 | 3.3082 | 4477340.0 |
| 2006-11-30 08:30:00 | AAPL | Stock | 3.3082 | 3.3086 | 3.2871 | 3.2946 | 2920036.0 |
| 2006-11-30 09:00:00 | AAPL | Stock | 3.2946 | 3.3054 | 3.2907 | 3.2918 | 5114788.0 |
| 2006-11-30 09:30:00 | AAPL | Stock | 3.2934 | 3.31 | 3.275 | 3.2939 | 164723972.0 |
| 2006-11-30 10:00:00 | AAPL | Stock | 3.2939 | 3.2982 | 3.2521 | 3.2632 | 119568036.0 |
| 2006-11-30 10:30:00 | AAPL | Stock | 3.2621 | 3.2943 | 3.2604 | 3.2825 | 77730800.0 |
| 2006-11-30 11:00:00 | AAPL | Stock | 3.2821 | 3.2871 | 3.2682 | 3.2807 | 45182872.0 |
| 2006-11-30 11:30:00 | AAPL | Stock | 3.2811 | 3.2907 | 3.2732 | 3.2793 | 45988040.0 |
| 2006-11-30 12:00:00 | AAPL | Stock | 3.2795 | 3.2964 | 3.275 | 3.2961 | 44772672.0 |
| 2006-11-30 12:30:00 | AAPL | Stock | 3.2957 | 3.3086 | 3.2893 | 3.2964 | 77296268.0 |
| 2006-11-30 13:00:00 | AAPL | Stock | 3.2964 | 3.3071 | 3.2896 | 3.3054 | 54459608.0 |
| 2006-11-30 13:30:00 | AAPL | Stock | 3.3054 | 3.3064 | 3.2857 | 3.2875 | 38985464.0 |
| 2006-11-30 14:00:00 | AAPL | Stock | 3.2868 | 3.2957 | 3.2846 | 3.2936 | 31729712.0 |
| 2006-11-30 14:30:00 | AAPL | Stock | 3.2932 | 3.3007 | 3.29 | 3.2975 | 34602820.0 |
| 2006-11-30 15:00:00 | AAPL | Stock | 3.2975 | 3.2989 | 3.29 | 3.2975 | 33231380.0 |
| 2006-11-30 15:30:00 | AAPL | Stock | 3.2971 | 3.2979 | 3.2671 | 3.2739 | 69818784.0 |
| 2006-11-30 16:00:00 | AAPL | Stock | 3.2743 | 3.2761 | 3.2704 | 3.2732 | 2790508.0 |
| 2006-11-30 16:30:00 | AAPL | Stock | 3.2732 | 3.2743 | 3.2714 | 3.2743 | 589820.0 |
| 2006-11-30 17:00:00 | AAPL | Stock | 3.2729 | 3.2746 | 3.2729 | 3.2746 | 188020.0 |
| 2006-11-30 17:30:00 | AAPL | Stock | 3.2736 | 3.2757 | 3.2736 | 3.2757 | 64680.0 |
| 2006-11-30 18:00:00 | AAPL | Stock | 3.2775 | 3.2779 | 3.275 | 3.2775 | 79576.0 |
| 2006-11-30 18:30:00 | AAPL | Stock | 3.2775 | 3.2786 | 3.2768 | 3.2786 | 116144.0 |
| 2006-11-30 19:00:00 | AAPL | Stock | 3.2775 | 3.2775 | 3.275 | 3.275 | 88256.0 |
| 2006-11-30 19:30:00 | AAPL | Stock | 3.275 | 3.2782 | 3.2732 | 3.2779 | 292936.0 |
| 2006-11-30 07:00:00 | MSFT | Stock | 29.61 | 29.61 | 29.61 | 29.61 | 100.0 |
| 2006-11-30 08:00:00 | MSFT | Stock | 29.61 | 29.67 | 29.6 | 29.62 | 10500.0 |
| 2006-11-30 08:30:00 | MSFT | Stock | 29.63 | 29.63 | 29.52 | 29.53 | 45807.0 |
| 2006-11-30 09:00:00 | MSFT | Stock | 29.53 | 29.56 | 29.41 | 29.43 | 938272.0 |
| 2006-11-30 09:30:00 | MSFT | Stock | 29.42 | 29.57 | 29.41 | 29.53 | 6116630.0 |
| 2006-11-30 10:00:00 | MSFT | Stock | 29.52 | 29.53 | 29.43 | 29.5 | 4102974.0 |
| 2006-11-30 10:30:00 | MSFT | Stock | 29.5 | 29.57 | 29.45 | 29.5 | 3942355.0 |
| 2006-11-30 11:00:00 | MSFT | Stock | 29.51 | 29.53 | 29.44 | 29.46 | 2890091.0 |
| 2006-11-30 11:30:00 | MSFT | Stock | 29.46 | 29.5 | 29.38 | 29.43 | 2684222.0 |
| 2006-11-30 12:00:00 | MSFT | Stock | 29.43 | 29.45 | 29.38 | 29.44 | 2631859.0 |
| 2006-11-30 12:30:00 | MSFT | Stock | 29.44 | 29.46 | 29.4 | 29.4 | 1456995.0 |
| 2006-11-30 13:00:00 | MSFT | Stock | 29.4 | 29.5 | 29.37 | 29.5 | 2596436.0 |
| 2006-11-30 13:30:00 | MSFT | Stock | 29.49 | 29.51 | 29.39 | 29.4 | 2440451.0 |
| 2006-11-30 14:00:00 | MSFT | Stock | 29.39 | 29.44 | 29.39 | 29.43 | 1781644.0 |
| 2006-11-30 14:30:00 | MSFT | Stock | 29.43 | 29.5 | 29.42 | 29.47 | 2505783.0 |
| 2006-11-30 15:00:00 | MSFT | Stock | 29.46 | 29.51 | 29.45 | 29.5 | 1553173.0 |
| 2006-11-30 15:30:00 | MSFT | Stock | 29.51 | 29.51 | 29.34 | 29.35 | 8634676.0 |
| 2006-11-30 16:00:00 | MSFT | Stock | 29.36 | 29.38 | 29.32 | 29.36 | 480178.0 |
| 2006-11-30 16:30:00 | MSFT | Stock | 29.36 | 29.36 | 29.33 | 29.33 | 151576.0 |
| 2006-11-30 17:00:00 | MSFT | Stock | 29.33 | 29.35 | 29.33 | 29.35 | 750.0 |
| 2006-11-30 17:30:00 | MSFT | Stock | 29.33 | 29.35 | 29.33 | 29.33 | 3300.0 |
| 2006-11-30 18:00:00 | MSFT | Stock | 29.34 | 29.34 | 29.33 | 29.34 | 2300.0 |
| 2006-11-30 18:30:00 | MSFT | Stock | 29.34 | 29.35 | 29.34 | 29.35 | 1265.0 |
> showing 50 of 52,460 rows — these rows as CSV