PREVIEW / stock_30min / 2023-12-12
file: by_date/stock_30min/2023/2023-12-12.parquet size: 2.1 MB rows: 99,640 symbols: 1,285
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-12 04:00:00 | AAPL | Stock | 193.34 | 193.38 | 193.18 | 193.24 | 3121.0 |
| 2023-12-12 04:30:00 | AAPL | Stock | 193.18 | 193.2 | 192.75 | 192.8 | 8631.0 |
| 2023-12-12 05:00:00 | AAPL | Stock | 192.8 | 192.84 | 192.56 | 192.56 | 10313.0 |
| 2023-12-12 05:30:00 | AAPL | Stock | 192.56 | 192.62 | 192.29 | 192.54 | 19728.0 |
| 2023-12-12 06:00:00 | AAPL | Stock | 192.54 | 192.85 | 192.54 | 192.77 | 2883.0 |
| 2023-12-12 06:30:00 | AAPL | Stock | 192.73 | 192.73 | 192.64 | 192.64 | 1169.0 |
| 2023-12-12 07:00:00 | AAPL | Stock | 192.74 | 192.9 | 192.65 | 192.86 | 12608.0 |
| 2023-12-12 07:30:00 | AAPL | Stock | 192.89 | 193.24 | 192.85 | 193.12 | 19312.0 |
| 2023-12-12 08:00:00 | AAPL | Stock | 192.73 | 193.25 | 192.5543 | 193.25 | 71218.0 |
| 2023-12-12 08:30:00 | AAPL | Stock | 192.99 | 193.55 | 192.23 | 192.5 | 172767.0 |
| 2023-12-12 09:00:00 | AAPL | Stock | 192.55 | 193.2 | 192.41 | 192.92 | 150097.0 |
| 2023-12-12 09:30:00 | AAPL | Stock | 192.92 | 193.39 | 191.721 | 192.415 | 5350534.0 |
| 2023-12-12 10:00:00 | AAPL | Stock | 192.4186 | 193.15 | 192.26 | 192.835 | 2981838.0 |
| 2023-12-12 10:30:00 | AAPL | Stock | 192.84 | 193.42 | 192.755 | 193.21 | 2791503.0 |
| 2023-12-12 11:00:00 | AAPL | Stock | 193.215 | 193.62 | 193.13 | 193.24 | 2112857.0 |
| 2023-12-12 11:30:00 | AAPL | Stock | 193.25 | 193.45 | 193.19 | 193.435 | 1366593.0 |
| 2023-12-12 12:00:00 | AAPL | Stock | 193.435 | 193.4999 | 193.07 | 193.4658 | 1155358.0 |
| 2023-12-12 12:30:00 | AAPL | Stock | 193.48 | 193.51 | 193.26 | 193.43 | 1106931.0 |
| 2023-12-12 13:00:00 | AAPL | Stock | 193.43 | 193.81 | 193.37 | 193.66 | 2139379.0 |
| 2023-12-12 13:30:00 | AAPL | Stock | 193.67 | 194.1465 | 193.63 | 194.0611 | 1801918.0 |
| 2023-12-12 14:00:00 | AAPL | Stock | 194.065 | 194.33 | 193.99 | 194.22 | 1764144.0 |
| 2023-12-12 14:30:00 | AAPL | Stock | 194.22 | 194.34 | 194.145 | 194.2428 | 1481518.0 |
| 2023-12-12 15:00:00 | AAPL | Stock | 194.25 | 194.56 | 194.23 | 194.385 | 2016351.0 |
| 2023-12-12 15:30:00 | AAPL | Stock | 194.38 | 194.72 | 194.21 | 194.67 | 4081127.0 |
| 2023-12-12 16:00:00 | AAPL | Stock | 194.71 | 194.8 | 194.56 | 194.74 | 8154711.0 |
| 2023-12-12 16:30:00 | AAPL | Stock | 194.74 | 194.75 | 194.71 | 194.7201 | 39636.0 |
| 2023-12-12 17:00:00 | AAPL | Stock | 194.75 | 194.75 | 194.69 | 194.69 | 6250.0 |
| 2023-12-12 17:30:00 | AAPL | Stock | 194.69 | 194.71 | 194.65 | 194.66 | 5532.0 |
| 2023-12-12 18:00:00 | AAPL | Stock | 194.67 | 194.79 | 194.67 | 194.7359 | 8032.0 |
| 2023-12-12 18:30:00 | AAPL | Stock | 194.73 | 194.79 | 194.73 | 194.7401 | 9007.0 |
| 2023-12-12 19:00:00 | AAPL | Stock | 194.78 | 194.83 | 194.78 | 194.83 | 3136.0 |
| 2023-12-12 19:30:00 | AAPL | Stock | 194.82 | 194.82 | 194.6601 | 194.7699 | 11145.0 |
| 2023-12-12 04:00:00 | MSFT | Stock | 372.65 | 372.65 | 372.4 | 372.4 | 668.0 |
| 2023-12-12 05:00:00 | MSFT | Stock | 372.35 | 372.35 | 371.9 | 371.9 | 875.0 |
| 2023-12-12 05:30:00 | MSFT | Stock | 372.01 | 372.01 | 371.97 | 371.97 | 633.0 |
| 2023-12-12 06:00:00 | MSFT | Stock | 372.16 | 372.27 | 372.16 | 372.27 | 336.0 |
| 2023-12-12 06:30:00 | MSFT | Stock | 372.1 | 372.1 | 372.1 | 372.1 | 250.0 |
| 2023-12-12 07:00:00 | MSFT | Stock | 371.99 | 372.0 | 371.68 | 371.7 | 2611.0 |
| 2023-12-12 07:30:00 | MSFT | Stock | 371.7 | 372.0 | 371.6 | 372.0 | 3416.0 |
| 2023-12-12 08:00:00 | MSFT | Stock | 371.98 | 372.45 | 371.4 | 372.4 | 13275.0 |
| 2023-12-12 08:30:00 | MSFT | Stock | 372.4 | 372.65 | 370.8 | 370.85 | 35704.0 |
| 2023-12-12 09:00:00 | MSFT | Stock | 370.86 | 371.3 | 369.61 | 370.84 | 19420.0 |
| 2023-12-12 09:30:00 | MSFT | Stock | 370.79 | 372.42 | 370.55 | 371.69 | 2520649.0 |
| 2023-12-12 10:00:00 | MSFT | Stock | 371.72 | 372.165 | 370.99 | 371.04 | 1145021.0 |
| 2023-12-12 10:30:00 | MSFT | Stock | 371.05 | 372.08 | 370.46 | 371.94 | 995099.0 |
| 2023-12-12 11:00:00 | MSFT | Stock | 371.9496 | 372.6 | 371.665 | 372.42 | 839130.0 |
| 2023-12-12 11:30:00 | MSFT | Stock | 372.42 | 373.16 | 371.88 | 371.99 | 684366.0 |
| 2023-12-12 12:00:00 | MSFT | Stock | 372.02 | 372.22 | 371.24 | 372.12 | 532643.0 |
| 2023-12-12 12:30:00 | MSFT | Stock | 372.12 | 372.4099 | 371.74 | 372.3 | 512977.0 |
| 2023-12-12 13:00:00 | MSFT | Stock | 372.3 | 372.543 | 372.1 | 372.32 | 604800.0 |
> showing 50 of 99,640 rows — these rows as CSV