PREVIEW / stock_30min / 2024-01-23
file: by_date/stock_30min/2024/2024-01-23.parquet size: 2.0 MB rows: 97,705 symbols: 1,196
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 |
|---|---|---|---|---|---|---|---|
| 2024-01-23 04:00:00 | AAPL | Stock | 193.6 | 193.6 | 193.23 | 193.28 | 7027.0 |
| 2024-01-23 04:30:00 | AAPL | Stock | 193.27 | 193.39 | 193.27 | 193.33 | 3405.0 |
| 2024-01-23 05:00:00 | AAPL | Stock | 193.33 | 193.49 | 193.01 | 193.43 | 6211.0 |
| 2024-01-23 05:30:00 | AAPL | Stock | 193.35 | 193.35 | 193.3 | 193.3 | 1010.0 |
| 2024-01-23 06:00:00 | AAPL | Stock | 193.3 | 193.48 | 193.05 | 193.13 | 11723.0 |
| 2024-01-23 06:30:00 | AAPL | Stock | 193.13 | 193.7 | 193.13 | 193.7 | 75731.0 |
| 2024-01-23 07:00:00 | AAPL | Stock | 193.69 | 194.0 | 193.62 | 193.75 | 14068.0 |
| 2024-01-23 07:30:00 | AAPL | Stock | 193.79 | 194.5 | 193.79 | 194.5 | 39616.0 |
| 2024-01-23 08:00:00 | AAPL | Stock | 193.67 | 194.87 | 193.3 | 194.6 | 68563.0 |
| 2024-01-23 08:30:00 | AAPL | Stock | 194.5985 | 194.72 | 194.37 | 194.37 | 53107.0 |
| 2024-01-23 09:00:00 | AAPL | Stock | 194.39 | 195.04 | 194.01 | 195.01 | 161090.0 |
| 2024-01-23 09:30:00 | AAPL | Stock | 195.01 | 195.75 | 194.66 | 194.8 | 5217710.0 |
| 2024-01-23 10:00:00 | AAPL | Stock | 194.8 | 194.85 | 193.8299 | 194.195 | 3036875.0 |
| 2024-01-23 10:30:00 | AAPL | Stock | 194.2 | 194.57 | 194.0 | 194.3 | 2356593.0 |
| 2024-01-23 11:00:00 | AAPL | Stock | 194.295 | 194.53 | 194.18 | 194.32 | 1923986.0 |
| 2024-01-23 11:30:00 | AAPL | Stock | 194.32 | 194.72 | 194.2001 | 194.64 | 1725329.0 |
| 2024-01-23 12:00:00 | AAPL | Stock | 194.63 | 194.78 | 194.5 | 194.665 | 1302884.0 |
| 2024-01-23 12:30:00 | AAPL | Stock | 194.67 | 195.21 | 194.495 | 195.14 | 1673821.0 |
| 2024-01-23 13:00:00 | AAPL | Stock | 195.15 | 195.24 | 194.87 | 195.055 | 1435648.0 |
| 2024-01-23 13:30:00 | AAPL | Stock | 195.05 | 195.15 | 194.75 | 194.8028 | 1902125.0 |
| 2024-01-23 14:00:00 | AAPL | Stock | 194.81 | 194.89 | 194.57 | 194.734 | 1199111.0 |
| 2024-01-23 14:30:00 | AAPL | Stock | 194.735 | 195.03 | 194.57 | 194.9401 | 1819809.0 |
| 2024-01-23 15:00:00 | AAPL | Stock | 194.945 | 195.19 | 194.803 | 194.835 | 1561992.0 |
| 2024-01-23 15:30:00 | AAPL | Stock | 194.835 | 195.25 | 194.6599 | 195.15 | 4408866.0 |
| 2024-01-23 16:00:00 | AAPL | Stock | 195.14 | 195.18 | 194.95 | 195.14 | 3538468.0 |
| 2024-01-23 16:30:00 | AAPL | Stock | 195.14 | 195.18 | 194.88 | 194.95 | 72339.0 |
| 2024-01-23 17:00:00 | AAPL | Stock | 194.92 | 194.94 | 194.89 | 194.9001 | 4238.0 |
| 2024-01-23 17:30:00 | AAPL | Stock | 194.91 | 194.91 | 194.81 | 194.86 | 5925.0 |
| 2024-01-23 18:00:00 | AAPL | Stock | 194.9 | 195.08 | 194.9 | 195.0799 | 8253.0 |
| 2024-01-23 18:30:00 | AAPL | Stock | 195.05 | 195.11 | 195.02 | 195.11 | 7395.0 |
| 2024-01-23 19:00:00 | AAPL | Stock | 195.14 | 195.14 | 195.0 | 195.0 | 15348.0 |
| 2024-01-23 19:30:00 | AAPL | Stock | 194.9801 | 195.15 | 194.97 | 195.15 | 15325.0 |
| 2024-01-23 04:00:00 | MSFT | Stock | 396.88 | 397.99 | 396.88 | 397.65 | 5462.0 |
| 2024-01-23 04:30:00 | MSFT | Stock | 397.76 | 397.76 | 396.21 | 396.51 | 3515.0 |
| 2024-01-23 05:00:00 | MSFT | Stock | 396.8 | 396.87 | 396.28 | 396.28 | 1544.0 |
| 2024-01-23 05:30:00 | MSFT | Stock | 396.25 | 396.27 | 396.25 | 396.27 | 1097.0 |
| 2024-01-23 06:00:00 | MSFT | Stock | 396.51 | 396.8 | 396.5 | 396.5 | 1271.0 |
| 2024-01-23 06:30:00 | MSFT | Stock | 397.0 | 397.08 | 396.98 | 397.08 | 1464.0 |
| 2024-01-23 07:00:00 | MSFT | Stock | 397.13 | 397.16 | 396.57 | 396.57 | 1917.0 |
| 2024-01-23 07:30:00 | MSFT | Stock | 396.6 | 396.99 | 396.49 | 396.95 | 6188.0 |
| 2024-01-23 08:00:00 | MSFT | Stock | 397.03 | 397.7 | 396.51 | 397.27 | 25861.0 |
| 2024-01-23 08:30:00 | MSFT | Stock | 397.4 | 397.79 | 396.91 | 397.0998 | 13115.0 |
| 2024-01-23 09:00:00 | MSFT | Stock | 397.03 | 397.1 | 395.42 | 395.79 | 18612.0 |
| 2024-01-23 09:30:00 | MSFT | Stock | 395.69 | 395.97 | 393.93 | 395.7494 | 1470827.0 |
| 2024-01-23 10:00:00 | MSFT | Stock | 395.73 | 395.83 | 394.93 | 395.46 | 731646.0 |
| 2024-01-23 10:30:00 | MSFT | Stock | 395.49 | 395.9275 | 395.11 | 395.4326 | 663978.0 |
| 2024-01-23 11:00:00 | MSFT | Stock | 395.47 | 395.85 | 394.7401 | 395.0461 | 530153.0 |
| 2024-01-23 11:30:00 | MSFT | Stock | 395.05 | 395.8 | 394.9 | 395.73 | 467641.0 |
| 2024-01-23 12:00:00 | MSFT | Stock | 395.72 | 395.8 | 395.37 | 395.67 | 366414.0 |
| 2024-01-23 12:30:00 | MSFT | Stock | 395.65 | 397.18 | 395.55 | 397.126 | 434800.0 |
> showing 50 of 97,705 rows — these rows as CSV