PREVIEW / stock_30min / 2023-12-28
file: by_date/stock_30min/2023/2023-12-28.parquet size: 2.1 MB rows: 102,443 symbols: 1,236
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-28 04:00:00 | AAPL | Stock | 193.5 | 194.0 | 193.5 | 193.71 | 3714.0 |
| 2023-12-28 04:30:00 | AAPL | Stock | 193.79 | 193.79 | 193.6 | 193.6 | 2716.0 |
| 2023-12-28 05:00:00 | AAPL | Stock | 193.6 | 193.75 | 193.6 | 193.7 | 1358.0 |
| 2023-12-28 05:30:00 | AAPL | Stock | 193.78 | 193.83 | 193.7 | 193.8 | 3452.0 |
| 2023-12-28 06:00:00 | AAPL | Stock | 193.83 | 193.85 | 193.82 | 193.82 | 1789.0 |
| 2023-12-28 06:30:00 | AAPL | Stock | 193.82 | 193.83 | 193.73 | 193.73 | 1054.0 |
| 2023-12-28 07:00:00 | AAPL | Stock | 193.75 | 193.75 | 193.56 | 193.69 | 11446.0 |
| 2023-12-28 07:30:00 | AAPL | Stock | 193.65 | 193.7 | 193.64 | 193.64 | 3028.0 |
| 2023-12-28 08:00:00 | AAPL | Stock | 193.69 | 193.76 | 193.5142 | 193.68 | 45217.0 |
| 2023-12-28 08:30:00 | AAPL | Stock | 193.68 | 193.71 | 193.6 | 193.65 | 25851.0 |
| 2023-12-28 09:00:00 | AAPL | Stock | 193.63 | 194.09 | 193.4 | 194.08 | 72854.0 |
| 2023-12-28 09:30:00 | AAPL | Stock | 194.09 | 194.66 | 193.98 | 194.095 | 4336780.0 |
| 2023-12-28 10:00:00 | AAPL | Stock | 194.095 | 194.27 | 193.73 | 194.2491 | 1996501.0 |
| 2023-12-28 10:30:00 | AAPL | Stock | 194.25 | 194.48 | 194.1 | 194.21 | 1898775.0 |
| 2023-12-28 11:00:00 | AAPL | Stock | 194.2112 | 194.22 | 193.89 | 194.05 | 1532235.0 |
| 2023-12-28 11:30:00 | AAPL | Stock | 194.055 | 194.22 | 193.99 | 194.13 | 981244.0 |
| 2023-12-28 12:00:00 | AAPL | Stock | 194.125 | 194.43 | 194.075 | 194.16 | 1088659.0 |
| 2023-12-28 12:30:00 | AAPL | Stock | 194.165 | 194.19 | 193.89 | 193.98 | 994315.0 |
| 2023-12-28 13:00:00 | AAPL | Stock | 193.975 | 193.98 | 193.58 | 193.7 | 1548460.0 |
| 2023-12-28 13:30:00 | AAPL | Stock | 193.7 | 193.98 | 193.67 | 193.8706 | 1017457.0 |
| 2023-12-28 14:00:00 | AAPL | Stock | 193.875 | 194.07 | 193.865 | 194.015 | 982256.0 |
| 2023-12-28 14:30:00 | AAPL | Stock | 194.015 | 194.09 | 193.89 | 193.9741 | 899719.0 |
| 2023-12-28 15:00:00 | AAPL | Stock | 193.97 | 193.97 | 193.55 | 193.675 | 1606727.0 |
| 2023-12-28 15:30:00 | AAPL | Stock | 193.67 | 193.8597 | 193.17 | 193.58 | 4312559.0 |
| 2023-12-28 16:00:00 | AAPL | Stock | 193.58 | 193.92 | 193.58 | 193.77 | 4159378.0 |
| 2023-12-28 16:30:00 | AAPL | Stock | 193.72 | 193.83 | 193.69 | 193.75 | 47749.0 |
| 2023-12-28 17:00:00 | AAPL | Stock | 193.73 | 193.77 | 193.58 | 193.74 | 41378.0 |
| 2023-12-28 17:30:00 | AAPL | Stock | 193.65 | 193.74 | 193.61 | 193.68 | 10719.0 |
| 2023-12-28 18:00:00 | AAPL | Stock | 193.67 | 193.67 | 193.61 | 193.61 | 10082.0 |
| 2023-12-28 18:30:00 | AAPL | Stock | 193.65 | 193.65 | 193.58 | 193.6 | 17048.0 |
| 2023-12-28 19:00:00 | AAPL | Stock | 193.6 | 193.73 | 193.6 | 193.68 | 1784.0 |
| 2023-12-28 19:30:00 | AAPL | Stock | 193.69 | 193.7991 | 193.6801 | 193.78 | 5172.0 |
| 2023-12-28 04:00:00 | MSFT | Stock | 374.5 | 374.9 | 374.5 | 374.9 | 1284.0 |
| 2023-12-28 04:30:00 | MSFT | Stock | 374.8 | 375.0 | 374.8 | 374.94 | 1868.0 |
| 2023-12-28 05:00:00 | MSFT | Stock | 374.89 | 374.89 | 374.89 | 374.89 | 233.0 |
| 2023-12-28 05:30:00 | MSFT | Stock | 374.88 | 374.88 | 374.81 | 374.81 | 200.0 |
| 2023-12-28 06:00:00 | MSFT | Stock | 374.83 | 374.83 | 374.83 | 374.83 | 439.0 |
| 2023-12-28 07:00:00 | MSFT | Stock | 374.85 | 375.0 | 374.85 | 375.0 | 1333.0 |
| 2023-12-28 07:30:00 | MSFT | Stock | 375.1 | 375.37 | 375.1 | 375.35 | 3178.0 |
| 2023-12-28 08:00:00 | MSFT | Stock | 374.8 | 375.39 | 374.23 | 375.2 | 20609.0 |
| 2023-12-28 08:30:00 | MSFT | Stock | 375.3 | 375.4 | 374.07 | 374.92 | 26292.0 |
| 2023-12-28 09:00:00 | MSFT | Stock | 375.0 | 375.49 | 374.92 | 375.27 | 19716.0 |
| 2023-12-28 09:30:00 | MSFT | Stock | 375.32 | 376.458 | 374.76 | 374.895 | 1376319.0 |
| 2023-12-28 10:00:00 | MSFT | Stock | 374.92 | 375.01 | 374.16 | 374.82 | 744003.0 |
| 2023-12-28 10:30:00 | MSFT | Stock | 374.8204 | 375.3695 | 374.73 | 375.24 | 517484.0 |
| 2023-12-28 11:00:00 | MSFT | Stock | 375.21 | 375.28 | 374.53 | 374.93 | 396622.0 |
| 2023-12-28 11:30:00 | MSFT | Stock | 374.96 | 375.44 | 374.82 | 375.09 | 366911.0 |
| 2023-12-28 12:00:00 | MSFT | Stock | 375.1 | 375.536 | 375.05 | 375.39 | 338035.0 |
| 2023-12-28 12:30:00 | MSFT | Stock | 375.38 | 376.05 | 375.37 | 375.95 | 384885.0 |
| 2023-12-28 13:00:00 | MSFT | Stock | 375.95 | 375.98 | 375.315 | 375.8069 | 325834.0 |
> showing 50 of 102,443 rows — these rows as CSV