PREVIEW / stock_30min / 2025-04-24
file: by_date/stock_30min/2025/2025-04-24.parquet size: 2.1 MB rows: 103,173 symbols: 429
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 |
|---|---|---|---|---|---|---|---|
| 2025-04-24 04:00:00 | AAPL | Stock | 203.87 | 203.87 | 201.9 | 201.9 | 10577.0 |
| 2025-04-24 04:30:00 | AAPL | Stock | 201.87 | 202.02 | 201.68 | 201.95 | 9533.0 |
| 2025-04-24 05:00:00 | AAPL | Stock | 201.98 | 202.27 | 201.78 | 202.17 | 7095.0 |
| 2025-04-24 05:30:00 | AAPL | Stock | 202.27 | 202.6 | 202.07 | 202.38 | 4959.0 |
| 2025-04-24 06:00:00 | AAPL | Stock | 202.6 | 202.69 | 202.3 | 202.53 | 14575.0 |
| 2025-04-24 06:30:00 | AAPL | Stock | 202.55 | 204.37 | 202.55 | 204.04 | 40386.0 |
| 2025-04-24 07:00:00 | AAPL | Stock | 204.11 | 204.14 | 203.56 | 203.66 | 30404.0 |
| 2025-04-24 07:30:00 | AAPL | Stock | 203.65 | 204.43 | 203.25 | 203.67 | 23748.0 |
| 2025-04-24 08:00:00 | AAPL | Stock | 203.99 | 204.48 | 202.54 | 203.888 | 86829.0 |
| 2025-04-24 08:30:00 | AAPL | Stock | 204.09 | 204.71 | 203.89 | 204.23 | 49537.0 |
| 2025-04-24 09:00:00 | AAPL | Stock | 204.45 | 205.19 | 203.8 | 205.0 | 98694.0 |
| 2025-04-24 09:30:00 | AAPL | Stock | 204.94 | 205.64 | 202.94 | 205.59 | 3833457.0 |
| 2025-04-24 10:00:00 | AAPL | Stock | 205.57 | 206.35 | 205.36 | 206.32 | 2175793.0 |
| 2025-04-24 10:30:00 | AAPL | Stock | 206.29 | 206.66 | 205.2201 | 205.955 | 1880728.0 |
| 2025-04-24 11:00:00 | AAPL | Stock | 205.96 | 206.48 | 205.48 | 205.925 | 1376355.0 |
| 2025-04-24 11:30:00 | AAPL | Stock | 205.885 | 206.715 | 205.5801 | 206.095 | 1442728.0 |
| 2025-04-24 12:00:00 | AAPL | Stock | 206.11 | 206.77 | 205.65 | 206.3 | 1052158.0 |
| 2025-04-24 12:30:00 | AAPL | Stock | 206.3 | 206.71 | 205.82 | 206.54 | 809733.0 |
| 2025-04-24 13:00:00 | AAPL | Stock | 206.54 | 207.03 | 206.09 | 206.905 | 1087383.0 |
| 2025-04-24 13:30:00 | AAPL | Stock | 206.92 | 207.48 | 206.55 | 207.45 | 978463.0 |
| 2025-04-24 14:00:00 | AAPL | Stock | 207.44 | 207.79 | 207.0575 | 207.289 | 1024869.0 |
| 2025-04-24 14:30:00 | AAPL | Stock | 207.3 | 208.1 | 207.29 | 207.86 | 1164169.0 |
| 2025-04-24 15:00:00 | AAPL | Stock | 207.85 | 207.9 | 207.03 | 207.1 | 1191738.0 |
| 2025-04-24 15:30:00 | AAPL | Stock | 207.11 | 208.8299 | 207.08 | 208.2 | 3897498.0 |
| 2025-04-24 16:00:00 | AAPL | Stock | 208.21 | 208.91 | 208.21 | 208.44 | 12337039.0 |
| 2025-04-24 16:30:00 | AAPL | Stock | 208.4 | 208.7 | 208.25 | 208.689 | 44665.0 |
| 2025-04-24 17:00:00 | AAPL | Stock | 208.64 | 208.77 | 208.54 | 208.72 | 33650.0 |
| 2025-04-24 17:30:00 | AAPL | Stock | 208.72 | 208.7392 | 208.5401 | 208.5401 | 14451.0 |
| 2025-04-24 18:00:00 | AAPL | Stock | 208.56 | 208.56 | 207.56 | 208.01 | 32805.0 |
| 2025-04-24 18:30:00 | AAPL | Stock | 208.15 | 208.1953 | 207.8 | 208.02 | 13251.0 |
| 2025-04-24 19:00:00 | AAPL | Stock | 207.96 | 208.5 | 207.96 | 208.3 | 10121.0 |
| 2025-04-24 19:30:00 | AAPL | Stock | 208.4 | 208.4998 | 207.42 | 207.9991 | 26257.0 |
| 2025-04-24 04:00:00 | MSFT | Stock | 373.69 | 373.69 | 372.84 | 372.84 | 1535.0 |
| 2025-04-24 04:30:00 | MSFT | Stock | 373.02 | 373.02 | 372.1 | 372.58 | 2148.0 |
| 2025-04-24 05:00:00 | MSFT | Stock | 372.67 | 373.0 | 372.4 | 373.0 | 1576.0 |
| 2025-04-24 05:30:00 | MSFT | Stock | 373.18 | 374.24 | 373.18 | 373.86 | 839.0 |
| 2025-04-24 06:00:00 | MSFT | Stock | 373.81 | 374.05 | 373.46 | 373.52 | 754.0 |
| 2025-04-24 06:30:00 | MSFT | Stock | 374.5 | 376.09 | 374.4 | 375.79 | 4701.0 |
| 2025-04-24 07:00:00 | MSFT | Stock | 375.37 | 375.39 | 374.0 | 374.15 | 1901.0 |
| 2025-04-24 07:30:00 | MSFT | Stock | 373.65 | 374.97 | 373.65 | 374.41 | 2277.0 |
| 2025-04-24 08:00:00 | MSFT | Stock | 375.37 | 375.715 | 373.21 | 374.71 | 12229.0 |
| 2025-04-24 08:30:00 | MSFT | Stock | 374.45 | 376.02 | 374.348 | 375.35 | 5856.0 |
| 2025-04-24 09:00:00 | MSFT | Stock | 375.6 | 376.71 | 375.0 | 376.21 | 6084.0 |
| 2025-04-24 09:30:00 | MSFT | Stock | 375.41 | 381.52 | 375.19 | 381.48 | 1183235.0 |
| 2025-04-24 10:00:00 | MSFT | Stock | 381.39 | 383.09 | 380.96 | 382.965 | 726284.0 |
| 2025-04-24 10:30:00 | MSFT | Stock | 382.95 | 384.46 | 382.63 | 383.165 | 657478.0 |
| 2025-04-24 11:00:00 | MSFT | Stock | 383.18 | 384.37 | 382.56 | 383.585 | 474110.0 |
| 2025-04-24 11:30:00 | MSFT | Stock | 383.65 | 384.51 | 382.9155 | 383.33 | 370823.0 |
| 2025-04-24 12:00:00 | MSFT | Stock | 383.325 | 385.11 | 382.7381 | 384.58 | 535144.0 |
| 2025-04-24 12:30:00 | MSFT | Stock | 384.51 | 385.16 | 383.71 | 384.73 | 407147.0 |
> showing 50 of 103,173 rows — these rows as CSV