PREVIEW / stock_30min / 2023-12-08
file: by_date/stock_30min/2023/2023-12-08.parquet size: 2.0 MB rows: 98,654 symbols: 1,262
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-08 04:00:00 | AAPL | Stock | 194.0 | 194.15 | 194.0 | 194.13 | 1786.0 |
| 2023-12-08 04:30:00 | AAPL | Stock | 194.13 | 194.17 | 194.13 | 194.13 | 700.0 |
| 2023-12-08 05:00:00 | AAPL | Stock | 194.13 | 194.25 | 194.13 | 194.22 | 1540.0 |
| 2023-12-08 05:30:00 | AAPL | Stock | 194.22 | 194.3 | 194.21 | 194.23 | 4355.0 |
| 2023-12-08 06:00:00 | AAPL | Stock | 194.22 | 194.33 | 194.17 | 194.27 | 8644.0 |
| 2023-12-08 06:30:00 | AAPL | Stock | 194.19 | 194.27 | 194.0 | 194.0 | 3486.0 |
| 2023-12-08 07:00:00 | AAPL | Stock | 193.9 | 193.94 | 193.78 | 193.9 | 11168.0 |
| 2023-12-08 07:30:00 | AAPL | Stock | 193.88 | 194.05 | 193.88 | 194.05 | 3350.0 |
| 2023-12-08 08:00:00 | AAPL | Stock | 193.85 | 194.13 | 193.75 | 193.9 | 97465.0 |
| 2023-12-08 08:30:00 | AAPL | Stock | 193.98 | 194.39 | 193.44 | 194.1 | 189757.0 |
| 2023-12-08 09:00:00 | AAPL | Stock | 194.11 | 194.34 | 193.65 | 194.12 | 145172.0 |
| 2023-12-08 09:30:00 | AAPL | Stock | 194.08 | 194.55 | 193.67 | 193.82 | 4794182.0 |
| 2023-12-08 10:00:00 | AAPL | Stock | 193.82 | 195.0 | 193.82 | 194.6499 | 3708907.0 |
| 2023-12-08 10:30:00 | AAPL | Stock | 194.65 | 195.0 | 194.18 | 194.9799 | 2351979.0 |
| 2023-12-08 11:00:00 | AAPL | Stock | 194.975 | 195.0 | 194.4 | 194.76 | 1976357.0 |
| 2023-12-08 11:30:00 | AAPL | Stock | 194.76 | 194.8 | 194.271 | 194.4501 | 1422281.0 |
| 2023-12-08 12:00:00 | AAPL | Stock | 194.455 | 195.19 | 194.335 | 195.1 | 3126271.0 |
| 2023-12-08 12:30:00 | AAPL | Stock | 195.0993 | 195.3 | 194.92 | 195.1701 | 1814701.0 |
| 2023-12-08 13:00:00 | AAPL | Stock | 195.18 | 195.36 | 195.02 | 195.24 | 1615504.0 |
| 2023-12-08 13:30:00 | AAPL | Stock | 195.24 | 195.6353 | 195.155 | 195.6137 | 1813671.0 |
| 2023-12-08 14:00:00 | AAPL | Stock | 195.62 | 195.72 | 195.45 | 195.715 | 1404018.0 |
| 2023-12-08 14:30:00 | AAPL | Stock | 195.715 | 195.98 | 195.5 | 195.8299 | 2531252.0 |
| 2023-12-08 15:00:00 | AAPL | Stock | 195.835 | 195.865 | 195.41 | 195.74 | 2218802.0 |
| 2023-12-08 15:30:00 | AAPL | Stock | 195.735 | 195.99 | 195.62 | 195.72 | 4185297.0 |
| 2023-12-08 16:00:00 | AAPL | Stock | 195.72 | 195.77 | 195.61 | 195.73 | 9061856.0 |
| 2023-12-08 16:30:00 | AAPL | Stock | 195.74 | 195.74 | 195.65 | 195.69 | 36256.0 |
| 2023-12-08 17:00:00 | AAPL | Stock | 195.71 | 195.74 | 195.1825 | 195.71 | 112383.0 |
| 2023-12-08 17:30:00 | AAPL | Stock | 195.6901 | 195.72 | 195.66 | 195.71 | 6604.0 |
| 2023-12-08 18:00:00 | AAPL | Stock | 195.72 | 195.73 | 195.7 | 195.71 | 4809.0 |
| 2023-12-08 18:30:00 | AAPL | Stock | 195.6701 | 195.72 | 195.66 | 195.71 | 11373.0 |
| 2023-12-08 19:00:00 | AAPL | Stock | 195.7 | 195.72 | 195.68 | 195.72 | 2204.0 |
| 2023-12-08 19:30:00 | AAPL | Stock | 195.72 | 195.79 | 195.71 | 195.79 | 4864.0 |
| 2023-12-08 04:00:00 | MSFT | Stock | 369.86 | 369.86 | 369.85 | 369.85 | 500.0 |
| 2023-12-08 05:00:00 | MSFT | Stock | 370.14 | 370.14 | 369.0 | 369.0 | 2602.0 |
| 2023-12-08 05:30:00 | MSFT | Stock | 369.0 | 369.0 | 368.91 | 369.0 | 1319.0 |
| 2023-12-08 06:00:00 | MSFT | Stock | 369.25 | 369.25 | 368.55 | 368.55 | 1304.0 |
| 2023-12-08 07:00:00 | MSFT | Stock | 368.89 | 369.63 | 368.89 | 369.63 | 3401.0 |
| 2023-12-08 07:30:00 | MSFT | Stock | 369.76 | 370.2 | 369.76 | 369.8 | 2351.0 |
| 2023-12-08 08:00:00 | MSFT | Stock | 369.2 | 370.51 | 368.89 | 369.7 | 20396.0 |
| 2023-12-08 08:30:00 | MSFT | Stock | 369.5 | 370.04 | 368.0 | 369.5 | 40217.0 |
| 2023-12-08 09:00:00 | MSFT | Stock | 369.87 | 370.0 | 368.6 | 368.92 | 19609.0 |
| 2023-12-08 09:30:00 | MSFT | Stock | 368.94 | 370.92 | 368.23 | 370.45 | 1859067.0 |
| 2023-12-08 10:00:00 | MSFT | Stock | 370.48 | 373.2 | 370.4286 | 372.7299 | 1398475.0 |
| 2023-12-08 10:30:00 | MSFT | Stock | 372.85 | 373.33 | 370.77 | 373.1476 | 1012597.0 |
| 2023-12-08 11:00:00 | MSFT | Stock | 373.16 | 373.38 | 371.86 | 372.581 | 726108.0 |
| 2023-12-08 11:30:00 | MSFT | Stock | 372.6216 | 372.83 | 371.01 | 372.1424 | 830486.0 |
| 2023-12-08 12:00:00 | MSFT | Stock | 372.13 | 372.94 | 371.315 | 372.6338 | 534871.0 |
| 2023-12-08 12:30:00 | MSFT | Stock | 372.64 | 373.04 | 372.295 | 372.86 | 381070.0 |
| 2023-12-08 13:00:00 | MSFT | Stock | 372.92 | 373.29 | 372.65 | 372.939 | 449842.0 |
| 2023-12-08 13:30:00 | MSFT | Stock | 372.98 | 373.28 | 372.63 | 373.24 | 480234.0 |
> showing 50 of 98,654 rows — these rows as CSV