PREVIEW / stock_30min / 2021-02-12
file: by_date/stock_30min/2021/2021-02-12.parquet size: 2.3 MB rows: 119,601 symbols: 2,821
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-02-12 04:00:00 | AAPL | Stock | 134.79 | 134.79 | 134.4 | 134.55 | 9257.0 |
| 2021-02-12 04:30:00 | AAPL | Stock | 134.52 | 134.64 | 134.52 | 134.58 | 2345.0 |
| 2021-02-12 05:00:00 | AAPL | Stock | 134.68 | 134.74 | 134.67 | 134.74 | 1180.0 |
| 2021-02-12 05:30:00 | AAPL | Stock | 134.73 | 134.73 | 134.7 | 134.7 | 3022.0 |
| 2021-02-12 06:00:00 | AAPL | Stock | 134.64 | 134.69 | 134.4 | 134.4 | 8472.0 |
| 2021-02-12 06:30:00 | AAPL | Stock | 134.5 | 134.59 | 134.46 | 134.59 | 5698.0 |
| 2021-02-12 07:00:00 | AAPL | Stock | 134.6 | 134.77 | 134.5 | 134.66 | 48248.0 |
| 2021-02-12 07:30:00 | AAPL | Stock | 134.67 | 134.78 | 134.571 | 134.67 | 33983.0 |
| 2021-02-12 08:00:00 | AAPL | Stock | 134.7 | 134.85 | 134.5 | 134.71 | 85651.0 |
| 2021-02-12 08:30:00 | AAPL | Stock | 134.71 | 134.72 | 134.33 | 134.42 | 94055.0 |
| 2021-02-12 09:00:00 | AAPL | Stock | 134.37 | 134.54 | 134.21 | 134.28 | 154137.0 |
| 2021-02-12 09:30:00 | AAPL | Stock | 134.28 | 134.73 | 133.795 | 133.87 | 7676941.0 |
| 2021-02-12 10:00:00 | AAPL | Stock | 133.87 | 134.12 | 133.692 | 134.0 | 5089620.0 |
| 2021-02-12 10:30:00 | AAPL | Stock | 134.0 | 134.85 | 133.78 | 134.55 | 4727103.0 |
| 2021-02-12 11:00:00 | AAPL | Stock | 134.55 | 134.765 | 134.29 | 134.53 | 3043878.0 |
| 2021-02-12 11:30:00 | AAPL | Stock | 134.525 | 134.68 | 134.3 | 134.31 | 2081425.0 |
| 2021-02-12 12:00:00 | AAPL | Stock | 134.32 | 134.5 | 134.16 | 134.17 | 1876944.0 |
| 2021-02-12 12:30:00 | AAPL | Stock | 134.169 | 134.38 | 134.07 | 134.31 | 2608624.0 |
| 2021-02-12 13:00:00 | AAPL | Stock | 134.32 | 134.385 | 134.0 | 134.19 | 2060090.0 |
| 2021-02-12 13:30:00 | AAPL | Stock | 134.18 | 134.38 | 134.17 | 134.28 | 1667932.0 |
| 2021-02-12 14:00:00 | AAPL | Stock | 134.27 | 134.33 | 134.08 | 134.28 | 2059510.0 |
| 2021-02-12 14:30:00 | AAPL | Stock | 134.27 | 134.69 | 134.25 | 134.6 | 2344070.0 |
| 2021-02-12 15:00:00 | AAPL | Stock | 134.6 | 134.8 | 134.46 | 134.78 | 2568463.0 |
| 2021-02-12 15:30:00 | AAPL | Stock | 134.78 | 135.53 | 134.78 | 135.38 | 7713531.0 |
| 2021-02-12 16:00:00 | AAPL | Stock | 135.34 | 135.49 | 134.706 | 135.23 | 4852251.0 |
| 2021-02-12 16:30:00 | AAPL | Stock | 135.23 | 135.37 | 135.17 | 135.34 | 116644.0 |
| 2021-02-12 17:00:00 | AAPL | Stock | 135.33 | 135.5 | 135.27 | 135.42 | 96018.0 |
| 2021-02-12 17:30:00 | AAPL | Stock | 135.41 | 135.48 | 135.4 | 135.46 | 50281.0 |
| 2021-02-12 18:00:00 | AAPL | Stock | 135.47 | 135.47 | 135.4 | 135.4 | 22672.0 |
| 2021-02-12 18:30:00 | AAPL | Stock | 135.37 | 135.4 | 135.3 | 135.36 | 20752.0 |
| 2021-02-12 19:00:00 | AAPL | Stock | 135.4 | 135.4 | 135.32 | 135.34 | 16992.0 |
| 2021-02-12 19:30:00 | AAPL | Stock | 135.33 | 135.46 | 135.33 | 135.43 | 42434.0 |
| 2021-02-12 04:00:00 | MSFT | Stock | 243.98 | 243.98 | 243.51 | 243.51 | 201.0 |
| 2021-02-12 05:00:00 | MSFT | Stock | 243.78 | 243.78 | 243.78 | 243.78 | 500.0 |
| 2021-02-12 06:00:00 | MSFT | Stock | 244.03 | 244.29 | 244.02 | 244.28 | 1128.0 |
| 2021-02-12 06:30:00 | MSFT | Stock | 244.05 | 244.05 | 244.0 | 244.0 | 657.0 |
| 2021-02-12 07:00:00 | MSFT | Stock | 244.04 | 244.26 | 244.04 | 244.26 | 931.0 |
| 2021-02-12 07:30:00 | MSFT | Stock | 244.3 | 244.3 | 244.1 | 244.1 | 3357.0 |
| 2021-02-12 08:00:00 | MSFT | Stock | 244.3 | 244.3 | 243.879 | 244.0 | 8207.0 |
| 2021-02-12 08:30:00 | MSFT | Stock | 243.98 | 244.05 | 243.5 | 243.51 | 7011.0 |
| 2021-02-12 09:00:00 | MSFT | Stock | 243.287 | 244.12 | 243.28 | 244.12 | 10543.0 |
| 2021-02-12 09:30:00 | MSFT | Stock | 244.12 | 244.9 | 242.89 | 243.55 | 1347797.0 |
| 2021-02-12 10:00:00 | MSFT | Stock | 243.54 | 243.86 | 242.91 | 243.0 | 972561.0 |
| 2021-02-12 10:30:00 | MSFT | Stock | 242.99 | 243.62 | 242.73 | 243.3 | 777194.0 |
| 2021-02-12 11:00:00 | MSFT | Stock | 243.33 | 244.338 | 243.27 | 244.2 | 598350.0 |
| 2021-02-12 11:30:00 | MSFT | Stock | 244.24 | 244.28 | 243.5 | 243.79 | 534349.0 |
| 2021-02-12 12:00:00 | MSFT | Stock | 243.81 | 244.06 | 243.619 | 243.81 | 390832.0 |
| 2021-02-12 12:30:00 | MSFT | Stock | 243.8 | 244.05 | 243.59 | 243.82 | 435706.0 |
| 2021-02-12 13:00:00 | MSFT | Stock | 243.82 | 244.03 | 243.24 | 244.0 | 449013.0 |
| 2021-02-12 13:30:00 | MSFT | Stock | 244.007 | 244.15 | 243.49 | 243.64 | 455275.0 |
> showing 50 of 119,601 rows — these rows as CSV