PREVIEW / stock_30min / 2023-12-06
file: by_date/stock_30min/2023/2023-12-06.parquet size: 2.1 MB rows: 100,731 symbols: 1,263
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-06 04:00:00 | AAPL | Stock | 193.78 | 193.93 | 193.62 | 193.7 | 11840.0 |
| 2023-12-06 04:30:00 | AAPL | Stock | 193.66 | 193.72 | 193.54 | 193.55 | 17306.0 |
| 2023-12-06 05:00:00 | AAPL | Stock | 193.55 | 193.78 | 193.55 | 193.77 | 2883.0 |
| 2023-12-06 05:30:00 | AAPL | Stock | 193.68 | 193.71 | 193.66 | 193.66 | 1136.0 |
| 2023-12-06 06:00:00 | AAPL | Stock | 193.64 | 193.69 | 193.41 | 193.41 | 3163.0 |
| 2023-12-06 06:30:00 | AAPL | Stock | 193.4 | 193.54 | 193.3 | 193.45 | 8116.0 |
| 2023-12-06 07:00:00 | AAPL | Stock | 193.45 | 193.55 | 193.25 | 193.36 | 19480.0 |
| 2023-12-06 07:30:00 | AAPL | Stock | 193.38 | 193.53 | 193.34 | 193.53 | 8871.0 |
| 2023-12-06 08:00:00 | AAPL | Stock | 193.5 | 193.89 | 193.25 | 193.65 | 85359.0 |
| 2023-12-06 08:30:00 | AAPL | Stock | 193.7 | 194.05 | 193.7 | 194.04 | 99601.0 |
| 2023-12-06 09:00:00 | AAPL | Stock | 194.04 | 194.47 | 193.8 | 194.47 | 231312.0 |
| 2023-12-06 09:30:00 | AAPL | Stock | 194.45 | 194.76 | 192.96 | 193.15 | 5317802.0 |
| 2023-12-06 10:00:00 | AAPL | Stock | 193.14 | 193.165 | 192.205 | 192.42 | 3635867.0 |
| 2023-12-06 10:30:00 | AAPL | Stock | 192.42 | 192.91 | 192.3601 | 192.6529 | 1810035.0 |
| 2023-12-06 11:00:00 | AAPL | Stock | 192.67 | 193.34 | 192.605 | 193.095 | 1703472.0 |
| 2023-12-06 11:30:00 | AAPL | Stock | 193.1 | 193.13 | 192.47 | 193.04 | 1680437.0 |
| 2023-12-06 12:00:00 | AAPL | Stock | 193.03 | 193.0979 | 192.73 | 192.83 | 999516.0 |
| 2023-12-06 12:30:00 | AAPL | Stock | 192.84 | 192.98 | 192.65 | 192.7 | 967774.0 |
| 2023-12-06 13:00:00 | AAPL | Stock | 192.69 | 192.9537 | 192.37 | 192.9059 | 1144715.0 |
| 2023-12-06 13:30:00 | AAPL | Stock | 192.91 | 193.235 | 192.74 | 193.1494 | 1149379.0 |
| 2023-12-06 14:00:00 | AAPL | Stock | 193.1501 | 193.21 | 192.75 | 192.78 | 1083351.0 |
| 2023-12-06 14:30:00 | AAPL | Stock | 192.78 | 193.05 | 192.78 | 192.91 | 994639.0 |
| 2023-12-06 15:00:00 | AAPL | Stock | 192.9135 | 192.94 | 192.34 | 192.426 | 1556403.0 |
| 2023-12-06 15:30:00 | AAPL | Stock | 192.43 | 192.56 | 192.11 | 192.33 | 4299624.0 |
| 2023-12-06 16:00:00 | AAPL | Stock | 192.33 | 192.45 | 192.21 | 192.21 | 6452427.0 |
| 2023-12-06 16:30:00 | AAPL | Stock | 192.26 | 192.32 | 192.21 | 192.26 | 61729.0 |
| 2023-12-06 17:00:00 | AAPL | Stock | 192.3 | 192.38 | 192.23 | 192.23 | 25693.0 |
| 2023-12-06 17:30:00 | AAPL | Stock | 192.26 | 192.32 | 192.22 | 192.23 | 12967.0 |
| 2023-12-06 18:00:00 | AAPL | Stock | 192.23 | 192.3 | 192.22 | 192.3 | 4075.0 |
| 2023-12-06 18:30:00 | AAPL | Stock | 192.28 | 192.31 | 192.2197 | 192.22 | 5501.0 |
| 2023-12-06 19:00:00 | AAPL | Stock | 192.22 | 192.22 | 192.12 | 192.1201 | 3502.0 |
| 2023-12-06 19:30:00 | AAPL | Stock | 192.18 | 192.26 | 192.11 | 192.2 | 10603.0 |
| 2023-12-06 04:00:00 | MSFT | Stock | 373.59 | 373.85 | 373.46 | 373.69 | 2221.0 |
| 2023-12-06 04:30:00 | MSFT | Stock | 373.5 | 373.5 | 373.0 | 373.29 | 1524.0 |
| 2023-12-06 05:00:00 | MSFT | Stock | 372.97 | 372.98 | 372.97 | 372.98 | 300.0 |
| 2023-12-06 05:30:00 | MSFT | Stock | 373.2 | 373.3 | 373.2 | 373.29 | 1235.0 |
| 2023-12-06 06:00:00 | MSFT | Stock | 373.29 | 373.3 | 372.8 | 372.8 | 710.0 |
| 2023-12-06 06:30:00 | MSFT | Stock | 372.7 | 372.7 | 372.63 | 372.63 | 600.0 |
| 2023-12-06 07:00:00 | MSFT | Stock | 372.77 | 372.81 | 372.53 | 372.53 | 8776.0 |
| 2023-12-06 07:30:00 | MSFT | Stock | 372.51 | 372.89 | 372.51 | 372.89 | 997.0 |
| 2023-12-06 08:00:00 | MSFT | Stock | 372.92 | 374.01 | 372.57 | 373.2 | 49988.0 |
| 2023-12-06 08:30:00 | MSFT | Stock | 373.3 | 374.5 | 373.3 | 374.4 | 19466.0 |
| 2023-12-06 09:00:00 | MSFT | Stock | 374.39 | 375.0 | 372.99 | 373.4 | 53835.0 |
| 2023-12-06 09:30:00 | MSFT | Stock | 373.49 | 374.18 | 371.49 | 371.8 | 1938928.0 |
| 2023-12-06 10:00:00 | MSFT | Stock | 371.73 | 371.9268 | 368.67 | 370.05 | 1696689.0 |
| 2023-12-06 10:30:00 | MSFT | Stock | 370.08 | 371.47 | 370.03 | 371.44 | 1064919.0 |
| 2023-12-06 11:00:00 | MSFT | Stock | 371.4413 | 371.55 | 369.56 | 369.695 | 798741.0 |
| 2023-12-06 11:30:00 | MSFT | Stock | 369.71 | 369.9 | 368.7901 | 369.73 | 828605.0 |
| 2023-12-06 12:00:00 | MSFT | Stock | 369.73 | 369.88 | 369.01 | 369.15 | 553469.0 |
| 2023-12-06 12:30:00 | MSFT | Stock | 369.15 | 369.57 | 368.6895 | 368.75 | 496795.0 |
> showing 50 of 100,731 rows — these rows as CSV