PREVIEW / stock_30min / 2024-10-04
file: by_date/stock_30min/2024/2024-10-04.parquet size: 2.1 MB rows: 99,324 symbols: 750
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-10-04 04:00:00 | AAPL | Stock | 226.08 | 226.5 | 225.79 | 225.93 | 16818.0 |
| 2024-10-04 04:30:00 | AAPL | Stock | 225.9 | 225.99 | 225.85 | 225.86 | 2023.0 |
| 2024-10-04 05:00:00 | AAPL | Stock | 225.83 | 225.83 | 225.67 | 225.67 | 437.0 |
| 2024-10-04 05:30:00 | AAPL | Stock | 225.65 | 225.87 | 225.65 | 225.87 | 3265.0 |
| 2024-10-04 06:00:00 | AAPL | Stock | 225.95 | 226.24 | 225.95 | 226.13 | 5008.0 |
| 2024-10-04 06:30:00 | AAPL | Stock | 226.22 | 226.22 | 225.96 | 226.18 | 3165.0 |
| 2024-10-04 07:00:00 | AAPL | Stock | 226.01 | 226.45 | 225.99 | 226.43 | 9815.0 |
| 2024-10-04 07:30:00 | AAPL | Stock | 226.43 | 226.6 | 226.43 | 226.5 | 9718.0 |
| 2024-10-04 08:00:00 | AAPL | Stock | 226.0 | 226.64 | 225.106 | 226.63 | 58128.0 |
| 2024-10-04 08:30:00 | AAPL | Stock | 226.63 | 227.9 | 226.63 | 227.85 | 105605.0 |
| 2024-10-04 09:00:00 | AAPL | Stock | 227.9 | 227.97 | 227.12 | 227.89 | 120509.0 |
| 2024-10-04 09:30:00 | AAPL | Stock | 227.9 | 228.0 | 225.06 | 225.1899 | 3790419.0 |
| 2024-10-04 10:00:00 | AAPL | Stock | 225.18 | 225.63 | 224.37 | 224.5105 | 2316614.0 |
| 2024-10-04 10:30:00 | AAPL | Stock | 224.49 | 225.54 | 224.13 | 225.1088 | 1725903.0 |
| 2024-10-04 11:00:00 | AAPL | Stock | 225.1 | 225.335 | 224.31 | 224.56 | 1143012.0 |
| 2024-10-04 11:30:00 | AAPL | Stock | 224.56 | 225.53 | 224.321 | 225.53 | 986087.0 |
| 2024-10-04 12:00:00 | AAPL | Stock | 225.54 | 225.57 | 224.695 | 224.95 | 894556.0 |
| 2024-10-04 12:30:00 | AAPL | Stock | 224.9571 | 225.5 | 224.8676 | 225.14 | 816448.0 |
| 2024-10-04 13:00:00 | AAPL | Stock | 225.15 | 225.41 | 225.025 | 225.1001 | 581357.0 |
| 2024-10-04 13:30:00 | AAPL | Stock | 225.12 | 225.35 | 224.54 | 224.88 | 913375.0 |
| 2024-10-04 14:00:00 | AAPL | Stock | 224.89 | 225.19 | 224.63 | 225.09 | 846313.0 |
| 2024-10-04 14:30:00 | AAPL | Stock | 225.09 | 225.54 | 225.04 | 225.53 | 995331.0 |
| 2024-10-04 15:00:00 | AAPL | Stock | 225.53 | 226.19 | 225.29 | 226.0901 | 1284732.0 |
| 2024-10-04 15:30:00 | AAPL | Stock | 226.095 | 226.98 | 225.93 | 226.8 | 3659866.0 |
| 2024-10-04 16:00:00 | AAPL | Stock | 226.74 | 226.8 | 226.67 | 226.69 | 5510099.0 |
| 2024-10-04 16:30:00 | AAPL | Stock | 226.67 | 226.8 | 226.58 | 226.59 | 60661.0 |
| 2024-10-04 17:00:00 | AAPL | Stock | 226.6 | 226.7 | 226.52 | 226.7 | 14296.0 |
| 2024-10-04 17:30:00 | AAPL | Stock | 226.7 | 226.8 | 226.655 | 226.77 | 7827.0 |
| 2024-10-04 18:00:00 | AAPL | Stock | 226.74 | 226.74 | 226.53 | 226.53 | 7851.0 |
| 2024-10-04 18:30:00 | AAPL | Stock | 226.5495 | 226.71 | 226.5 | 226.56 | 9857.0 |
| 2024-10-04 19:00:00 | AAPL | Stock | 226.59 | 226.6135 | 226.49 | 226.49 | 2981.0 |
| 2024-10-04 19:30:00 | AAPL | Stock | 226.565 | 226.57 | 226.37 | 226.3745 | 11710.0 |
| 2024-10-04 04:00:00 | MSFT | Stock | 418.06 | 418.11 | 417.33 | 417.33 | 868.0 |
| 2024-10-04 04:30:00 | MSFT | Stock | 417.26 | 417.26 | 417.08 | 417.08 | 312.0 |
| 2024-10-04 05:00:00 | MSFT | Stock | 417.13 | 417.13 | 417.13 | 417.13 | 125.0 |
| 2024-10-04 05:30:00 | MSFT | Stock | 417.21 | 417.44 | 417.21 | 417.44 | 871.0 |
| 2024-10-04 06:00:00 | MSFT | Stock | 418.49 | 418.49 | 418.19 | 418.35 | 841.0 |
| 2024-10-04 06:30:00 | MSFT | Stock | 418.31 | 418.5 | 418.31 | 418.5 | 551.0 |
| 2024-10-04 07:00:00 | MSFT | Stock | 418.2 | 418.4 | 417.86 | 418.08 | 4095.0 |
| 2024-10-04 07:30:00 | MSFT | Stock | 418.08 | 418.08 | 417.7 | 417.9 | 2064.0 |
| 2024-10-04 08:00:00 | MSFT | Stock | 418.2011 | 418.293 | 416.82 | 417.8 | 23486.0 |
| 2024-10-04 08:30:00 | MSFT | Stock | 418.0 | 420.5 | 418.0 | 420.1601 | 49716.0 |
| 2024-10-04 09:00:00 | MSFT | Stock | 420.144 | 420.35 | 417.38 | 417.75 | 58717.0 |
| 2024-10-04 09:30:00 | MSFT | Stock | 417.88 | 419.75 | 416.05 | 416.22 | 1317643.0 |
| 2024-10-04 10:00:00 | MSFT | Stock | 416.195 | 417.23 | 415.11 | 415.4263 | 715670.0 |
| 2024-10-04 10:30:00 | MSFT | Stock | 415.38 | 417.67 | 414.97 | 417.486 | 537375.0 |
| 2024-10-04 11:00:00 | MSFT | Stock | 417.49 | 418.17 | 416.04 | 416.1485 | 364083.0 |
| 2024-10-04 11:30:00 | MSFT | Stock | 416.226 | 417.84 | 415.8208 | 417.81 | 302898.0 |
| 2024-10-04 12:00:00 | MSFT | Stock | 417.85 | 418.0 | 416.76 | 417.74 | 267092.0 |
| 2024-10-04 12:30:00 | MSFT | Stock | 417.71 | 418.99 | 417.5503 | 418.42 | 360162.0 |
> showing 50 of 99,324 rows — these rows as CSV