PREVIEW / stock_30min / 2021-08-13
file: by_date/stock_30min/2021/2021-08-13.parquet size: 2.2 MB rows: 108,404 symbols: 2,802
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-08-13 04:00:00 | AAPL | Stock | 148.99 | 149.25 | 148.88 | 149.24 | 20947.0 |
| 2021-08-13 04:30:00 | AAPL | Stock | 149.2 | 149.23 | 149.2 | 149.21 | 2769.0 |
| 2021-08-13 05:00:00 | AAPL | Stock | 149.17 | 149.17 | 149.09 | 149.17 | 2065.0 |
| 2021-08-13 05:30:00 | AAPL | Stock | 149.13 | 149.13 | 149.13 | 149.13 | 370.0 |
| 2021-08-13 06:00:00 | AAPL | Stock | 149.13 | 149.13 | 149.09 | 149.11 | 2677.0 |
| 2021-08-13 06:30:00 | AAPL | Stock | 149.11 | 149.22 | 149.0 | 149.05 | 15103.0 |
| 2021-08-13 07:00:00 | AAPL | Stock | 149.1 | 149.24 | 148.89 | 149.15 | 147516.0 |
| 2021-08-13 07:30:00 | AAPL | Stock | 149.16 | 149.16 | 148.67 | 148.67 | 52460.0 |
| 2021-08-13 08:00:00 | AAPL | Stock | 149.0501 | 149.22 | 148.518 | 148.93 | 128575.0 |
| 2021-08-13 08:30:00 | AAPL | Stock | 148.86 | 149.02 | 148.86 | 148.97 | 51406.0 |
| 2021-08-13 09:00:00 | AAPL | Stock | 148.98 | 149.18 | 148.9 | 149.0 | 145561.0 |
| 2021-08-13 09:30:00 | AAPL | Stock | 148.97 | 149.39 | 148.32 | 149.13 | 10623863.0 |
| 2021-08-13 10:00:00 | AAPL | Stock | 149.13 | 149.4444 | 148.7 | 149.1 | 5627462.0 |
| 2021-08-13 10:30:00 | AAPL | Stock | 149.1 | 149.23 | 148.79 | 148.9 | 3314626.0 |
| 2021-08-13 11:00:00 | AAPL | Stock | 148.9 | 149.085 | 148.45 | 148.62 | 3176912.0 |
| 2021-08-13 11:30:00 | AAPL | Stock | 148.611 | 148.6299 | 148.3201 | 148.365 | 2174446.0 |
| 2021-08-13 12:00:00 | AAPL | Stock | 148.3601 | 148.64 | 148.35 | 148.495 | 2017690.0 |
| 2021-08-13 12:30:00 | AAPL | Stock | 148.5 | 148.84 | 148.27 | 148.81 | 1896727.0 |
| 2021-08-13 13:00:00 | AAPL | Stock | 148.81 | 149.05 | 148.71 | 148.9513 | 1982419.0 |
| 2021-08-13 13:30:00 | AAPL | Stock | 148.9501 | 149.095 | 148.78 | 148.915 | 1881752.0 |
| 2021-08-13 14:00:00 | AAPL | Stock | 148.91 | 149.07 | 148.89 | 149.0168 | 1419940.0 |
| 2021-08-13 14:30:00 | AAPL | Stock | 149.0174 | 149.12 | 148.745 | 149.0916 | 2304758.0 |
| 2021-08-13 15:00:00 | AAPL | Stock | 149.095 | 149.1 | 148.88 | 148.96 | 1895008.0 |
| 2021-08-13 15:30:00 | AAPL | Stock | 148.96 | 149.12 | 148.9137 | 149.1 | 4681447.0 |
| 2021-08-13 16:00:00 | AAPL | Stock | 149.1 | 149.1399 | 148.98 | 149.01 | 3286527.0 |
| 2021-08-13 16:30:00 | AAPL | Stock | 149.0 | 149.04 | 148.99 | 148.99 | 34600.0 |
| 2021-08-13 17:00:00 | AAPL | Stock | 148.99 | 149.01 | 148.99 | 148.99 | 29533.0 |
| 2021-08-13 17:30:00 | AAPL | Stock | 149.0 | 149.0 | 148.97 | 148.98 | 12818.0 |
| 2021-08-13 18:00:00 | AAPL | Stock | 148.97 | 148.98 | 148.84 | 148.87 | 6569.0 |
| 2021-08-13 18:30:00 | AAPL | Stock | 148.86 | 148.87 | 148.8 | 148.86 | 11237.0 |
| 2021-08-13 19:00:00 | AAPL | Stock | 148.88 | 148.94 | 148.88 | 148.88 | 15826.0 |
| 2021-08-13 19:30:00 | AAPL | Stock | 148.86 | 148.93 | 148.85 | 148.92 | 16970.0 |
| 2021-08-13 04:30:00 | MSFT | Stock | 289.79 | 289.82 | 289.79 | 289.82 | 1941.0 |
| 2021-08-13 05:00:00 | MSFT | Stock | 289.82 | 289.82 | 289.7 | 289.71 | 1949.0 |
| 2021-08-13 06:00:00 | MSFT | Stock | 289.63 | 289.63 | 289.56 | 289.56 | 1174.0 |
| 2021-08-13 07:00:00 | MSFT | Stock | 289.42 | 289.55 | 289.4 | 289.4 | 1894.0 |
| 2021-08-13 07:30:00 | MSFT | Stock | 289.33 | 289.33 | 288.65 | 288.82 | 2435.0 |
| 2021-08-13 08:00:00 | MSFT | Stock | 288.81 | 289.61 | 288.81 | 288.97 | 5420.0 |
| 2021-08-13 08:30:00 | MSFT | Stock | 289.05 | 289.25 | 288.97 | 289.25 | 2561.0 |
| 2021-08-13 09:00:00 | MSFT | Stock | 289.39 | 289.6899 | 289.34 | 289.5 | 11181.0 |
| 2021-08-13 09:30:00 | MSFT | Stock | 289.51 | 290.94 | 289.3 | 290.615 | 1678161.0 |
| 2021-08-13 10:00:00 | MSFT | Stock | 290.63 | 292.18 | 290.2 | 291.48 | 1325167.0 |
| 2021-08-13 10:30:00 | MSFT | Stock | 291.475 | 291.8599 | 291.19 | 291.6832 | 746037.0 |
| 2021-08-13 11:00:00 | MSFT | Stock | 291.69 | 291.96 | 291.303 | 291.6 | 595574.0 |
| 2021-08-13 11:30:00 | MSFT | Stock | 291.62 | 291.64 | 290.87 | 291.01 | 552722.0 |
| 2021-08-13 12:00:00 | MSFT | Stock | 291.0 | 291.5 | 290.96 | 291.37 | 401677.0 |
| 2021-08-13 12:30:00 | MSFT | Stock | 291.37 | 291.6599 | 291.03 | 291.6 | 383121.0 |
| 2021-08-13 13:00:00 | MSFT | Stock | 291.595 | 291.71 | 291.55 | 291.64 | 288030.0 |
| 2021-08-13 13:30:00 | MSFT | Stock | 291.63 | 291.92 | 291.52 | 291.8283 | 404042.0 |
| 2021-08-13 14:00:00 | MSFT | Stock | 291.82 | 291.9499 | 291.7 | 291.885 | 375847.0 |
> showing 50 of 108,404 rows — these rows as CSV