PREVIEW / stock_30min / 2009-11-25
file: by_date/stock_30min/2009/2009-11-25.parquet size: 1.3 MB rows: 70,052 symbols: 3,416
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 |
|---|---|---|---|---|---|---|---|
| 2009-11-25 04:00:00 | AAPL | Stock | 7.2996 | 7.2996 | 7.2996 | 7.2996 | 2800.0 |
| 2009-11-25 04:30:00 | AAPL | Stock | 7.3546 | 7.3546 | 7.3546 | 7.3546 | 2800.0 |
| 2009-11-25 06:30:00 | AAPL | Stock | 7.3564 | 7.3564 | 7.3564 | 7.3564 | 2800.0 |
| 2009-11-25 07:00:00 | AAPL | Stock | 7.3375 | 7.3375 | 7.3214 | 7.3268 | 104860.0 |
| 2009-11-25 07:30:00 | AAPL | Stock | 7.3286 | 7.3321 | 7.325 | 7.3321 | 93156.0 |
| 2009-11-25 08:00:00 | AAPL | Stock | 7.3321 | 7.3443 | 7.325 | 7.3268 | 1252272.0 |
| 2009-11-25 08:30:00 | AAPL | Stock | 7.3321 | 7.3518 | 7.3268 | 7.3425 | 2295496.0 |
| 2009-11-25 09:00:00 | AAPL | Stock | 7.3404 | 7.3425 | 7.3279 | 7.3393 | 1521744.0 |
| 2009-11-25 09:30:00 | AAPL | Stock | 7.3393 | 7.3446 | 7.2796 | 7.3139 | 53791052.0 |
| 2009-11-25 10:00:00 | AAPL | Stock | 7.3139 | 7.3207 | 7.2861 | 7.2936 | 27608336.0 |
| 2009-11-25 10:30:00 | AAPL | Stock | 7.2943 | 7.3125 | 7.2918 | 7.3025 | 16879996.0 |
| 2009-11-25 11:00:00 | AAPL | Stock | 7.3032 | 7.32 | 7.2989 | 7.32 | 15829968.0 |
| 2009-11-25 11:30:00 | AAPL | Stock | 7.3196 | 7.3257 | 7.3043 | 7.312 | 18918396.0 |
| 2009-11-25 12:00:00 | AAPL | Stock | 7.3125 | 7.3139 | 7.2911 | 7.2979 | 14587972.0 |
| 2009-11-25 12:30:00 | AAPL | Stock | 7.2979 | 7.3011 | 7.2839 | 7.2951 | 11913440.0 |
| 2009-11-25 13:00:00 | AAPL | Stock | 7.2943 | 7.2993 | 7.2896 | 7.2929 | 8785056.0 |
| 2009-11-25 13:30:00 | AAPL | Stock | 7.2929 | 7.3043 | 7.2893 | 7.2979 | 28663656.0 |
| 2009-11-25 14:00:00 | AAPL | Stock | 7.2979 | 7.3021 | 7.2868 | 7.2996 | 9976036.0 |
| 2009-11-25 14:30:00 | AAPL | Stock | 7.2996 | 7.3054 | 7.2939 | 7.2979 | 10144400.0 |
| 2009-11-25 15:00:00 | AAPL | Stock | 7.2973 | 7.2993 | 7.2904 | 7.2954 | 8077776.0 |
| 2009-11-25 15:30:00 | AAPL | Stock | 7.2954 | 7.2964 | 7.2771 | 7.2904 | 35255304.0 |
| 2009-11-25 16:00:00 | AAPL | Stock | 7.2914 | 7.3031 | 7.2839 | 7.2882 | 5622064.0 |
| 2009-11-25 16:30:00 | AAPL | Stock | 7.2871 | 7.2886 | 7.2846 | 7.2846 | 61040.0 |
| 2009-11-25 17:00:00 | AAPL | Stock | 7.2829 | 7.2981 | 7.2829 | 7.2857 | 130760.0 |
| 2009-11-25 17:30:00 | AAPL | Stock | 7.2875 | 7.2886 | 7.2871 | 7.2871 | 19180.0 |
| 2009-11-25 18:00:00 | AAPL | Stock | 7.2886 | 7.2925 | 7.2879 | 7.2879 | 95256.0 |
| 2009-11-25 18:30:00 | AAPL | Stock | 7.2871 | 7.2875 | 7.2846 | 7.2846 | 21000.0 |
| 2009-11-25 19:00:00 | AAPL | Stock | 7.2882 | 7.2893 | 7.2882 | 7.2893 | 29400.0 |
| 2009-11-25 19:30:00 | AAPL | Stock | 7.2879 | 7.2911 | 7.2871 | 7.2911 | 31920.0 |
| 2009-11-25 06:30:00 | MSFT | Stock | 29.9 | 29.9 | 29.9 | 29.9 | 1000.0 |
| 2009-11-25 07:00:00 | MSFT | Stock | 29.9 | 29.9 | 29.86 | 29.86 | 850.0 |
| 2009-11-25 07:30:00 | MSFT | Stock | 29.88 | 29.89 | 29.85 | 29.85 | 1801.0 |
| 2009-11-25 08:00:00 | MSFT | Stock | 29.88 | 29.88 | 29.82 | 29.85 | 6950.0 |
| 2009-11-25 08:30:00 | MSFT | Stock | 29.89 | 29.95 | 29.87 | 29.89 | 49444.0 |
| 2009-11-25 09:00:00 | MSFT | Stock | 29.89 | 29.96 | 29.78 | 29.81 | 60943.0 |
| 2009-11-25 09:30:00 | MSFT | Stock | 29.81 | 29.85 | 29.62 | 29.819 | 4934546.0 |
| 2009-11-25 10:00:00 | MSFT | Stock | 29.81 | 29.86 | 29.75 | 29.75 | 2383037.0 |
| 2009-11-25 10:30:00 | MSFT | Stock | 29.76 | 29.79 | 29.7 | 29.72 | 2020792.0 |
| 2009-11-25 11:00:00 | MSFT | Stock | 29.73 | 29.77 | 29.72 | 29.74 | 1751966.0 |
| 2009-11-25 11:30:00 | MSFT | Stock | 29.74 | 29.82 | 29.7 | 29.74 | 2792470.0 |
| 2009-11-25 12:00:00 | MSFT | Stock | 29.74 | 29.75 | 29.64 | 29.65 | 1601176.0 |
| 2009-11-25 12:30:00 | MSFT | Stock | 29.657 | 29.68 | 29.58 | 29.67 | 1089339.0 |
| 2009-11-25 13:00:00 | MSFT | Stock | 29.67 | 29.74 | 29.66 | 29.73 | 1161237.0 |
| 2009-11-25 13:30:00 | MSFT | Stock | 29.73 | 29.78 | 29.71 | 29.78 | 1185822.0 |
| 2009-11-25 14:00:00 | MSFT | Stock | 29.78 | 29.78 | 29.72 | 29.73 | 1157964.0 |
| 2009-11-25 14:30:00 | MSFT | Stock | 29.74 | 29.79 | 29.7 | 29.78 | 4345311.0 |
| 2009-11-25 15:00:00 | MSFT | Stock | 29.775 | 29.79 | 29.75 | 29.775 | 1080957.0 |
| 2009-11-25 15:30:00 | MSFT | Stock | 29.78 | 29.79 | 29.7 | 29.78 | 4220167.0 |
| 2009-11-25 16:00:00 | MSFT | Stock | 29.79 | 29.822 | 29.748 | 29.793 | 1544560.0 |
| 2009-11-25 16:30:00 | MSFT | Stock | 29.78 | 29.78 | 29.78 | 29.78 | 110.0 |
> showing 50 of 70,052 rows — these rows as CSV