PREVIEW / stock_30min / 2023-12-19
file: by_date/stock_30min/2023/2023-12-19.parquet size: 2.1 MB rows: 102,880 symbols: 1,268
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-19 04:00:00 | AAPL | Stock | 195.76 | 195.97 | 195.76 | 195.97 | 358.0 |
| 2023-12-19 04:30:00 | AAPL | Stock | 196.0 | 196.0 | 195.91 | 195.91 | 1200.0 |
| 2023-12-19 05:00:00 | AAPL | Stock | 195.9 | 195.94 | 195.88 | 195.88 | 612.0 |
| 2023-12-19 05:30:00 | AAPL | Stock | 195.8 | 195.85 | 195.8 | 195.85 | 213.0 |
| 2023-12-19 06:00:00 | AAPL | Stock | 195.83 | 195.9 | 195.75 | 195.9 | 7597.0 |
| 2023-12-19 06:30:00 | AAPL | Stock | 195.99 | 196.19 | 195.98 | 196.17 | 6595.0 |
| 2023-12-19 07:00:00 | AAPL | Stock | 196.07 | 196.38 | 195.99 | 196.01 | 14516.0 |
| 2023-12-19 07:30:00 | AAPL | Stock | 196.0 | 196.52 | 195.98 | 196.5 | 33960.0 |
| 2023-12-19 08:00:00 | AAPL | Stock | 195.89 | 197.0 | 195.51 | 196.75 | 690541.0 |
| 2023-12-19 08:30:00 | AAPL | Stock | 196.75 | 196.8 | 196.5 | 196.65 | 73842.0 |
| 2023-12-19 09:00:00 | AAPL | Stock | 196.55 | 196.6 | 195.95 | 196.13 | 104467.0 |
| 2023-12-19 09:30:00 | AAPL | Stock | 196.15 | 196.655 | 195.89 | 196.5782 | 4433479.0 |
| 2023-12-19 10:00:00 | AAPL | Stock | 196.58 | 196.603 | 196.05 | 196.54 | 2218603.0 |
| 2023-12-19 10:30:00 | AAPL | Stock | 196.55 | 196.84 | 196.2775 | 196.725 | 2263383.0 |
| 2023-12-19 11:00:00 | AAPL | Stock | 196.725 | 196.95 | 196.5 | 196.6 | 1820218.0 |
| 2023-12-19 11:30:00 | AAPL | Stock | 196.595 | 196.74 | 196.21 | 196.285 | 1471562.0 |
| 2023-12-19 12:00:00 | AAPL | Stock | 196.285 | 196.35 | 195.97 | 196.23 | 1423246.0 |
| 2023-12-19 12:30:00 | AAPL | Stock | 196.23 | 196.33 | 196.115 | 196.25 | 869565.0 |
| 2023-12-19 13:00:00 | AAPL | Stock | 196.245 | 196.31 | 195.97 | 196.245 | 1106590.0 |
| 2023-12-19 13:30:00 | AAPL | Stock | 196.25 | 196.29 | 196.01 | 196.085 | 795304.0 |
| 2023-12-19 14:00:00 | AAPL | Stock | 196.09 | 196.1701 | 195.99 | 196.07 | 1061574.0 |
| 2023-12-19 14:30:00 | AAPL | Stock | 196.08 | 196.12 | 196.01 | 196.095 | 853601.0 |
| 2023-12-19 15:00:00 | AAPL | Stock | 196.1 | 196.47 | 195.98 | 196.45 | 1399599.0 |
| 2023-12-19 15:30:00 | AAPL | Stock | 196.45 | 196.95 | 196.325 | 196.92 | 3344454.0 |
| 2023-12-19 16:00:00 | AAPL | Stock | 196.92 | 197.0 | 196.8 | 196.85 | 8885254.0 |
| 2023-12-19 16:30:00 | AAPL | Stock | 196.85 | 196.94 | 196.78 | 196.83 | 42668.0 |
| 2023-12-19 17:00:00 | AAPL | Stock | 196.82 | 196.83 | 196.76 | 196.79 | 21457.0 |
| 2023-12-19 17:30:00 | AAPL | Stock | 196.82 | 196.84 | 196.79 | 196.84 | 15870.0 |
| 2023-12-19 18:00:00 | AAPL | Stock | 196.82 | 196.8406 | 196.76 | 196.82 | 5007.0 |
| 2023-12-19 18:30:00 | AAPL | Stock | 196.82 | 196.84 | 196.76 | 196.8 | 7426.0 |
| 2023-12-19 19:00:00 | AAPL | Stock | 196.76 | 196.85 | 196.76 | 196.85 | 15818.0 |
| 2023-12-19 19:30:00 | AAPL | Stock | 196.84 | 196.88 | 196.8 | 196.88 | 16470.0 |
| 2023-12-19 04:00:00 | MSFT | Stock | 372.51 | 372.77 | 372.33 | 372.77 | 1570.0 |
| 2023-12-19 05:30:00 | MSFT | Stock | 372.94 | 372.94 | 372.94 | 372.94 | 100.0 |
| 2023-12-19 06:00:00 | MSFT | Stock | 372.87 | 373.2 | 372.85 | 373.2 | 1208.0 |
| 2023-12-19 06:30:00 | MSFT | Stock | 373.29 | 373.29 | 373.0 | 373.0 | 940.0 |
| 2023-12-19 07:00:00 | MSFT | Stock | 373.18 | 373.83 | 373.08 | 373.64 | 3616.0 |
| 2023-12-19 07:30:00 | MSFT | Stock | 373.5 | 373.86 | 373.5 | 373.85 | 7034.0 |
| 2023-12-19 08:00:00 | MSFT | Stock | 373.01 | 374.1979 | 372.15 | 374.0 | 39849.0 |
| 2023-12-19 08:30:00 | MSFT | Stock | 373.95 | 373.95 | 373.2484 | 373.2484 | 12756.0 |
| 2023-12-19 09:00:00 | MSFT | Stock | 373.25 | 373.25 | 371.3 | 371.47 | 80531.0 |
| 2023-12-19 09:30:00 | MSFT | Stock | 371.5 | 372.94 | 370.65 | 370.935 | 2465111.0 |
| 2023-12-19 10:00:00 | MSFT | Stock | 370.915 | 371.67 | 369.84 | 371.29 | 1213145.0 |
| 2023-12-19 10:30:00 | MSFT | Stock | 371.36 | 372.33 | 371.235 | 371.66 | 826912.0 |
| 2023-12-19 11:00:00 | MSFT | Stock | 371.66 | 372.64 | 371.36 | 372.33 | 595233.0 |
| 2023-12-19 11:30:00 | MSFT | Stock | 372.33 | 372.72 | 371.745 | 371.93 | 486613.0 |
| 2023-12-19 12:00:00 | MSFT | Stock | 371.96 | 371.96 | 371.2904 | 371.62 | 386230.0 |
| 2023-12-19 12:30:00 | MSFT | Stock | 371.62 | 372.3495 | 371.54 | 372.03 | 320255.0 |
| 2023-12-19 13:00:00 | MSFT | Stock | 372.0209 | 372.18 | 371.47 | 372.155 | 383404.0 |
| 2023-12-19 13:30:00 | MSFT | Stock | 372.15 | 372.6313 | 371.73 | 371.9537 | 576986.0 |
> showing 50 of 102,880 rows — these rows as CSV