PREVIEW / stock_30min / 2023-12-26
file: by_date/stock_30min/2023/2023-12-26.parquet size: 2.1 MB rows: 100,960 symbols: 1,219
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 |
|---|---|---|---|---|---|---|---|
| 2023-12-26 04:00:00 | AAPL | Stock | 193.8 | 194.12 | 193.76 | 193.89 | 2881.0 |
| 2023-12-26 04:30:00 | AAPL | Stock | 194.0 | 194.0 | 193.81 | 193.81 | 4236.0 |
| 2023-12-26 05:00:00 | AAPL | Stock | 193.83 | 193.92 | 193.83 | 193.83 | 682.0 |
| 2023-12-26 05:30:00 | AAPL | Stock | 193.85 | 193.85 | 193.84 | 193.84 | 302.0 |
| 2023-12-26 06:00:00 | AAPL | Stock | 193.89 | 193.89 | 193.83 | 193.83 | 311.0 |
| 2023-12-26 06:30:00 | AAPL | Stock | 193.89 | 193.89 | 193.85 | 193.87 | 633.0 |
| 2023-12-26 07:00:00 | AAPL | Stock | 193.85 | 193.88 | 193.7 | 193.72 | 7100.0 |
| 2023-12-26 07:30:00 | AAPL | Stock | 193.74 | 193.88 | 193.74 | 193.87 | 3878.0 |
| 2023-12-26 08:00:00 | AAPL | Stock | 193.85 | 194.02 | 193.116 | 193.7294 | 49992.0 |
| 2023-12-26 08:30:00 | AAPL | Stock | 193.7291 | 193.73 | 193.26 | 193.5294 | 36324.0 |
| 2023-12-26 09:00:00 | AAPL | Stock | 193.53 | 193.7 | 193.51 | 193.62 | 55333.0 |
| 2023-12-26 09:30:00 | AAPL | Stock | 193.61 | 193.89 | 192.98 | 193.25 | 3606919.0 |
| 2023-12-26 10:00:00 | AAPL | Stock | 193.255 | 193.28 | 192.89 | 193.07 | 1743134.0 |
| 2023-12-26 10:30:00 | AAPL | Stock | 193.075 | 193.44 | 193.01 | 193.225 | 1536139.0 |
| 2023-12-26 11:00:00 | AAPL | Stock | 193.228 | 193.23 | 192.89 | 192.965 | 1103550.0 |
| 2023-12-26 11:30:00 | AAPL | Stock | 192.965 | 193.3 | 192.96 | 193.225 | 1048252.0 |
| 2023-12-26 12:00:00 | AAPL | Stock | 193.22 | 193.24 | 193.055 | 193.095 | 1003252.0 |
| 2023-12-26 12:30:00 | AAPL | Stock | 193.095 | 193.33 | 193.03 | 193.18 | 1144946.0 |
| 2023-12-26 13:00:00 | AAPL | Stock | 193.18 | 193.36 | 193.11 | 193.14 | 840833.0 |
| 2023-12-26 13:30:00 | AAPL | Stock | 193.145 | 193.16 | 192.83 | 192.8898 | 1108196.0 |
| 2023-12-26 14:00:00 | AAPL | Stock | 192.89 | 193.14 | 192.87 | 193.08 | 966055.0 |
| 2023-12-26 14:30:00 | AAPL | Stock | 193.09 | 193.095 | 192.96 | 193.045 | 946861.0 |
| 2023-12-26 15:00:00 | AAPL | Stock | 193.05 | 193.46 | 193.02 | 193.4121 | 1475933.0 |
| 2023-12-26 15:30:00 | AAPL | Stock | 193.42 | 193.49 | 192.92 | 193.04 | 3129246.0 |
| 2023-12-26 16:00:00 | AAPL | Stock | 193.07 | 193.11 | 192.8898 | 192.89 | 3784361.0 |
| 2023-12-26 16:30:00 | AAPL | Stock | 192.89 | 193.05 | 192.86 | 192.9 | 27310.0 |
| 2023-12-26 17:00:00 | AAPL | Stock | 192.9 | 192.9 | 192.87 | 192.9 | 4314.0 |
| 2023-12-26 17:30:00 | AAPL | Stock | 192.89 | 193.05 | 192.87 | 192.9099 | 8796.0 |
| 2023-12-26 18:00:00 | AAPL | Stock | 192.92 | 193.0 | 192.92 | 192.94 | 12430.0 |
| 2023-12-26 18:30:00 | AAPL | Stock | 192.94 | 192.95 | 192.89 | 192.9056 | 8961.0 |
| 2023-12-26 19:00:00 | AAPL | Stock | 192.93 | 192.95 | 192.87 | 192.87 | 3076.0 |
| 2023-12-26 19:30:00 | AAPL | Stock | 192.92 | 192.94 | 192.86 | 192.9 | 3757.0 |
| 2023-12-26 04:30:00 | MSFT | Stock | 375.7 | 376.0 | 375.7 | 376.0 | 2011.0 |
| 2023-12-26 05:00:00 | MSFT | Stock | 375.9 | 375.9 | 375.9 | 375.9 | 100.0 |
| 2023-12-26 05:30:00 | MSFT | Stock | 375.69 | 375.97 | 375.69 | 375.97 | 1032.0 |
| 2023-12-26 06:00:00 | MSFT | Stock | 375.98 | 375.98 | 375.98 | 375.98 | 144.0 |
| 2023-12-26 06:30:00 | MSFT | Stock | 375.8 | 375.8 | 375.6 | 375.71 | 1074.0 |
| 2023-12-26 07:00:00 | MSFT | Stock | 375.5 | 375.5 | 375.07 | 375.25 | 4703.0 |
| 2023-12-26 07:30:00 | MSFT | Stock | 375.3 | 375.7 | 375.3 | 375.7 | 4728.0 |
| 2023-12-26 08:00:00 | MSFT | Stock | 375.55 | 376.0 | 374.72 | 375.5 | 19097.0 |
| 2023-12-26 08:30:00 | MSFT | Stock | 375.5 | 375.72 | 375.313 | 375.313 | 6356.0 |
| 2023-12-26 09:00:00 | MSFT | Stock | 375.35 | 375.6599 | 375.0 | 375.01 | 10579.0 |
| 2023-12-26 09:30:00 | MSFT | Stock | 375.0 | 376.94 | 374.57 | 375.42 | 1330706.0 |
| 2023-12-26 10:00:00 | MSFT | Stock | 375.4 | 375.53 | 374.96 | 375.13 | 625344.0 |
| 2023-12-26 10:30:00 | MSFT | Stock | 375.17 | 375.5255 | 374.62 | 374.8721 | 583047.0 |
| 2023-12-26 11:00:00 | MSFT | Stock | 374.87 | 374.87 | 373.98 | 374.46 | 472632.0 |
| 2023-12-26 11:30:00 | MSFT | Stock | 374.45 | 374.65 | 374.07 | 374.18 | 304221.0 |
| 2023-12-26 12:00:00 | MSFT | Stock | 374.18 | 374.2666 | 373.96 | 374.03 | 362511.0 |
| 2023-12-26 12:30:00 | MSFT | Stock | 374.0401 | 374.24 | 373.92 | 373.955 | 308199.0 |
| 2023-12-26 13:00:00 | MSFT | Stock | 373.9399 | 374.1 | 373.75 | 373.965 | 361120.0 |
> showing 50 of 100,960 rows — these rows as CSV