PREVIEW / stock_30min / 2021-11-01
file: by_date/stock_30min/2021/2021-11-01.parquet size: 2.3 MB rows: 115,250 symbols: 2,695
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 |
|---|---|---|---|---|---|---|---|
| 2021-11-01 04:00:00 | AAPL | Stock | 149.95 | 150.15 | 149.56 | 149.79 | 24982.0 |
| 2021-11-01 04:30:00 | AAPL | Stock | 149.8 | 149.8 | 149.58 | 149.6 | 19631.0 |
| 2021-11-01 05:00:00 | AAPL | Stock | 149.6 | 149.74 | 149.56 | 149.65 | 19626.0 |
| 2021-11-01 05:30:00 | AAPL | Stock | 149.63 | 149.7 | 149.58 | 149.6 | 7234.0 |
| 2021-11-01 06:00:00 | AAPL | Stock | 149.6 | 149.6 | 149.51 | 149.51 | 12642.0 |
| 2021-11-01 06:30:00 | AAPL | Stock | 149.54 | 149.68 | 149.54 | 149.68 | 22721.0 |
| 2021-11-01 07:00:00 | AAPL | Stock | 149.69 | 149.85 | 149.62 | 149.73 | 114169.0 |
| 2021-11-01 07:30:00 | AAPL | Stock | 149.73 | 149.76 | 149.5 | 149.66 | 66723.0 |
| 2021-11-01 08:00:00 | AAPL | Stock | 149.72 | 149.85 | 149.51 | 149.62 | 201170.0 |
| 2021-11-01 08:30:00 | AAPL | Stock | 149.59 | 149.59 | 149.41 | 149.45 | 121501.0 |
| 2021-11-01 09:00:00 | AAPL | Stock | 149.45 | 149.5 | 148.77 | 148.92 | 365232.0 |
| 2021-11-01 09:30:00 | AAPL | Stock | 148.985 | 149.7 | 148.08 | 148.235 | 10233780.0 |
| 2021-11-01 10:00:00 | AAPL | Stock | 148.24 | 148.8666 | 147.8 | 148.782 | 5966425.0 |
| 2021-11-01 10:30:00 | AAPL | Stock | 148.781 | 148.855 | 148.295 | 148.36 | 3712292.0 |
| 2021-11-01 11:00:00 | AAPL | Stock | 148.35 | 148.96 | 148.25 | 148.84 | 2582682.0 |
| 2021-11-01 11:30:00 | AAPL | Stock | 148.83 | 149.04 | 148.63 | 148.89 | 2496491.0 |
| 2021-11-01 12:00:00 | AAPL | Stock | 148.9 | 149.025 | 148.66 | 148.785 | 2339340.0 |
| 2021-11-01 12:30:00 | AAPL | Stock | 148.79 | 149.02 | 148.662 | 148.935 | 3114076.0 |
| 2021-11-01 13:00:00 | AAPL | Stock | 148.94 | 149.02 | 148.78 | 148.81 | 1956763.0 |
| 2021-11-01 13:30:00 | AAPL | Stock | 148.8 | 148.82 | 148.51 | 148.57 | 2291381.0 |
| 2021-11-01 14:00:00 | AAPL | Stock | 148.56 | 148.7 | 148.37 | 148.375 | 2288238.0 |
| 2021-11-01 14:30:00 | AAPL | Stock | 148.37 | 148.54 | 148.27 | 148.345 | 1965327.0 |
| 2021-11-01 15:00:00 | AAPL | Stock | 148.34 | 148.97 | 148.317 | 148.782 | 2842553.0 |
| 2021-11-01 15:30:00 | AAPL | Stock | 148.785 | 149.01 | 148.52 | 148.97 | 5706943.0 |
| 2021-11-01 16:00:00 | AAPL | Stock | 148.96 | 148.96 | 148.65 | 148.74 | 8248651.0 |
| 2021-11-01 16:30:00 | AAPL | Stock | 148.73 | 148.96 | 148.62 | 148.66 | 57960.0 |
| 2021-11-01 17:00:00 | AAPL | Stock | 148.66 | 148.73 | 148.65 | 148.66 | 32298.0 |
| 2021-11-01 17:30:00 | AAPL | Stock | 148.68 | 148.71 | 148.64 | 148.67 | 24334.0 |
| 2021-11-01 18:00:00 | AAPL | Stock | 148.68 | 148.69 | 148.5 | 148.63 | 32340.0 |
| 2021-11-01 18:30:00 | AAPL | Stock | 148.63 | 148.72 | 148.61 | 148.67 | 22306.0 |
| 2021-11-01 19:00:00 | AAPL | Stock | 148.67 | 148.67 | 148.48 | 148.55 | 31378.0 |
| 2021-11-01 19:30:00 | AAPL | Stock | 148.55 | 148.55 | 148.27 | 148.44 | 62324.0 |
| 2021-11-01 04:00:00 | MSFT | Stock | 331.6 | 332.93 | 331.6 | 332.9 | 2467.0 |
| 2021-11-01 04:30:00 | MSFT | Stock | 332.9 | 333.05 | 332.9 | 332.96 | 4527.0 |
| 2021-11-01 05:00:00 | MSFT | Stock | 332.94 | 333.42 | 332.94 | 333.2 | 3843.0 |
| 2021-11-01 05:30:00 | MSFT | Stock | 332.99 | 333.38 | 332.99 | 333.35 | 3478.0 |
| 2021-11-01 06:00:00 | MSFT | Stock | 333.3 | 333.45 | 332.88 | 332.88 | 12046.0 |
| 2021-11-01 06:30:00 | MSFT | Stock | 332.82 | 332.9 | 332.76 | 332.9 | 2837.0 |
| 2021-11-01 07:00:00 | MSFT | Stock | 332.9 | 333.0 | 332.07 | 332.47 | 22628.0 |
| 2021-11-01 07:30:00 | MSFT | Stock | 332.4 | 332.47 | 332.02 | 332.47 | 8859.0 |
| 2021-11-01 08:00:00 | MSFT | Stock | 332.8 | 333.0446 | 332.02 | 332.38 | 30193.0 |
| 2021-11-01 08:30:00 | MSFT | Stock | 332.3 | 332.41 | 331.8 | 332.19 | 19779.0 |
| 2021-11-01 09:00:00 | MSFT | Stock | 332.18 | 332.18 | 331.1 | 331.35 | 84867.0 |
| 2021-11-01 09:30:00 | MSFT | Stock | 331.355 | 331.49 | 327.18 | 327.61 | 3393180.0 |
| 2021-11-01 10:00:00 | MSFT | Stock | 327.62 | 327.98 | 326.86 | 327.355 | 1734589.0 |
| 2021-11-01 10:30:00 | MSFT | Stock | 327.33 | 327.56 | 326.37 | 326.525 | 1645970.0 |
| 2021-11-01 11:00:00 | MSFT | Stock | 326.52 | 327.9 | 326.515 | 327.64 | 1111135.0 |
| 2021-11-01 11:30:00 | MSFT | Stock | 327.655 | 328.25 | 327.405 | 328.19 | 957451.0 |
| 2021-11-01 12:00:00 | MSFT | Stock | 328.22 | 328.63 | 327.84 | 328.56 | 819086.0 |
| 2021-11-01 12:30:00 | MSFT | Stock | 328.56 | 328.68 | 327.65 | 327.71 | 938621.0 |
> showing 50 of 115,250 rows — these rows as CSV