PREVIEW / stock_30min / 2024-10-17
file: by_date/stock_30min/2024/2024-10-17.parquet size: 2.1 MB rows: 100,909 symbols: 749
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-17 04:00:00 | AAPL | Stock | 232.0 | 233.43 | 232.0 | 233.1 | 20895.0 |
| 2024-10-17 04:30:00 | AAPL | Stock | 233.06 | 233.9 | 232.8 | 232.9 | 24171.0 |
| 2024-10-17 05:00:00 | AAPL | Stock | 232.86 | 233.49 | 232.81 | 233.49 | 50412.0 |
| 2024-10-17 05:30:00 | AAPL | Stock | 233.3 | 233.78 | 232.94 | 233.65 | 38937.0 |
| 2024-10-17 06:00:00 | AAPL | Stock | 233.49 | 233.7 | 233.23 | 233.29 | 24839.0 |
| 2024-10-17 06:30:00 | AAPL | Stock | 233.4 | 233.71 | 233.18 | 233.65 | 24788.0 |
| 2024-10-17 07:00:00 | AAPL | Stock | 233.53 | 233.6 | 233.17 | 233.25 | 29106.0 |
| 2024-10-17 07:30:00 | AAPL | Stock | 233.33 | 233.79 | 233.27 | 233.47 | 29088.0 |
| 2024-10-17 08:00:00 | AAPL | Stock | 233.53 | 233.81 | 231.201 | 233.59 | 97364.0 |
| 2024-10-17 08:30:00 | AAPL | Stock | 233.59 | 233.76 | 233.3 | 233.76 | 30986.0 |
| 2024-10-17 09:00:00 | AAPL | Stock | 233.792 | 234.19 | 232.72 | 233.4395 | 191292.0 |
| 2024-10-17 09:30:00 | AAPL | Stock | 233.43 | 233.85 | 230.52 | 231.72 | 3767890.0 |
| 2024-10-17 10:00:00 | AAPL | Stock | 231.76 | 232.58 | 231.29 | 232.4139 | 1699655.0 |
| 2024-10-17 10:30:00 | AAPL | Stock | 232.41 | 232.4899 | 231.16 | 231.3599 | 1279493.0 |
| 2024-10-17 11:00:00 | AAPL | Stock | 231.36 | 232.321 | 231.23 | 232.26 | 851132.0 |
| 2024-10-17 11:30:00 | AAPL | Stock | 232.26 | 232.56 | 232.05 | 232.5462 | 926415.0 |
| 2024-10-17 12:00:00 | AAPL | Stock | 232.54 | 232.81 | 232.085 | 232.25 | 721077.0 |
| 2024-10-17 12:30:00 | AAPL | Stock | 232.24 | 232.3799 | 232.02 | 232.1761 | 506841.0 |
| 2024-10-17 13:00:00 | AAPL | Stock | 232.18 | 232.53 | 232.07 | 232.4 | 703999.0 |
| 2024-10-17 13:30:00 | AAPL | Stock | 232.4 | 232.58 | 232.3 | 232.43 | 664164.0 |
| 2024-10-17 14:00:00 | AAPL | Stock | 232.43 | 232.57 | 231.27 | 231.5865 | 994680.0 |
| 2024-10-17 14:30:00 | AAPL | Stock | 231.58 | 232.11 | 231.37 | 232.1 | 715714.0 |
| 2024-10-17 15:00:00 | AAPL | Stock | 232.1 | 232.12 | 231.69 | 231.755 | 811807.0 |
| 2024-10-17 15:30:00 | AAPL | Stock | 231.755 | 232.33 | 231.63 | 232.26 | 2090408.0 |
| 2024-10-17 16:00:00 | AAPL | Stock | 232.18 | 232.37 | 232.03 | 232.13 | 4656921.0 |
| 2024-10-17 16:30:00 | AAPL | Stock | 232.18 | 232.18 | 232.05 | 232.15 | 454876.0 |
| 2024-10-17 17:00:00 | AAPL | Stock | 232.1 | 232.11 | 232.04 | 232.05 | 807.0 |
| 2024-10-17 17:30:00 | AAPL | Stock | 232.04 | 232.1 | 232.04 | 232.1 | 1949.0 |
| 2024-10-17 18:00:00 | AAPL | Stock | 232.11 | 232.15 | 231.95 | 232.15 | 3561.0 |
| 2024-10-17 18:30:00 | AAPL | Stock | 232.2 | 232.28 | 232.15 | 232.28 | 4801.0 |
| 2024-10-17 19:00:00 | AAPL | Stock | 232.229 | 232.3 | 232.1598 | 232.3 | 1042.0 |
| 2024-10-17 19:30:00 | AAPL | Stock | 232.32 | 232.32 | 232.16 | 232.16 | 2284.0 |
| 2024-10-17 04:00:00 | MSFT | Stock | 417.99 | 418.0 | 417.11 | 417.98 | 11158.0 |
| 2024-10-17 04:30:00 | MSFT | Stock | 418.42 | 418.81 | 418.0 | 418.61 | 6098.0 |
| 2024-10-17 05:00:00 | MSFT | Stock | 418.59 | 418.8 | 418.46 | 418.78 | 1389.0 |
| 2024-10-17 05:30:00 | MSFT | Stock | 418.49 | 419.19 | 418.14 | 419.19 | 3795.0 |
| 2024-10-17 06:00:00 | MSFT | Stock | 419.19 | 419.19 | 418.9 | 418.9 | 1139.0 |
| 2024-10-17 06:30:00 | MSFT | Stock | 418.95 | 419.24 | 418.32 | 419.24 | 6368.0 |
| 2024-10-17 07:00:00 | MSFT | Stock | 418.9 | 419.0 | 418.16 | 418.29 | 8711.0 |
| 2024-10-17 07:30:00 | MSFT | Stock | 418.35 | 418.35 | 418.1 | 418.1 | 1877.0 |
| 2024-10-17 08:00:00 | MSFT | Stock | 418.26 | 418.97 | 415.44 | 418.26 | 23863.0 |
| 2024-10-17 08:30:00 | MSFT | Stock | 418.26 | 419.25 | 418.23 | 419.21 | 17392.0 |
| 2024-10-17 09:00:00 | MSFT | Stock | 419.34 | 422.99 | 419.3 | 422.5 | 77550.0 |
| 2024-10-17 09:30:00 | MSFT | Stock | 422.38 | 422.5 | 417.24 | 417.385 | 1392949.0 |
| 2024-10-17 10:00:00 | MSFT | Stock | 417.44 | 418.36 | 416.2503 | 417.8 | 504356.0 |
| 2024-10-17 10:30:00 | MSFT | Stock | 417.79 | 417.92 | 415.9 | 416.22 | 361906.0 |
| 2024-10-17 11:00:00 | MSFT | Stock | 416.28 | 417.625 | 415.59 | 417.5953 | 321819.0 |
| 2024-10-17 11:30:00 | MSFT | Stock | 417.6 | 418.6 | 416.9 | 418.56 | 277350.0 |
| 2024-10-17 12:00:00 | MSFT | Stock | 418.525 | 418.885 | 417.68 | 417.9 | 373573.0 |
| 2024-10-17 12:30:00 | MSFT | Stock | 417.86 | 418.026 | 417.26 | 417.7548 | 185376.0 |
> showing 50 of 100,909 rows — these rows as CSV