PREVIEW / stock_30min / 2025-04-22
file: by_date/stock_30min/2025/2025-04-22.parquet size: 2.2 MB rows: 104,615 symbols: 423
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-22 04:00:00 | AAPL | Stock | 193.79 | 195.4 | 193.79 | 195.07 | 10365.0 |
| 2025-04-22 04:30:00 | AAPL | Stock | 195.21 | 195.61 | 195.2 | 195.35 | 7631.0 |
| 2025-04-22 05:00:00 | AAPL | Stock | 195.39 | 195.53 | 195.16 | 195.53 | 5659.0 |
| 2025-04-22 05:30:00 | AAPL | Stock | 195.36 | 195.36 | 195.0 | 195.31 | 2676.0 |
| 2025-04-22 06:00:00 | AAPL | Stock | 195.25 | 195.27 | 194.94 | 194.95 | 2718.0 |
| 2025-04-22 06:30:00 | AAPL | Stock | 194.95 | 195.2 | 194.9 | 195.2 | 3666.0 |
| 2025-04-22 07:00:00 | AAPL | Stock | 194.99 | 195.2 | 194.6 | 194.88 | 25902.0 |
| 2025-04-22 07:30:00 | AAPL | Stock | 195.0 | 195.13 | 194.48 | 194.5 | 31379.0 |
| 2025-04-22 08:00:00 | AAPL | Stock | 194.61 | 195.5 | 193.58 | 194.69 | 107799.0 |
| 2025-04-22 08:30:00 | AAPL | Stock | 194.69 | 195.2 | 194.5 | 195.19 | 60578.0 |
| 2025-04-22 09:00:00 | AAPL | Stock | 195.15 | 196.289 | 194.73 | 196.0 | 106685.0 |
| 2025-04-22 09:30:00 | AAPL | Stock | 196.0 | 197.87 | 195.97 | 197.82 | 3573821.0 |
| 2025-04-22 10:00:00 | AAPL | Stock | 197.83 | 198.94 | 197.62 | 198.11 | 2280179.0 |
| 2025-04-22 10:30:00 | AAPL | Stock | 198.12 | 199.39 | 197.67 | 199.3001 | 2080865.0 |
| 2025-04-22 11:00:00 | AAPL | Stock | 199.31 | 199.55 | 198.77 | 198.83 | 1856174.0 |
| 2025-04-22 11:30:00 | AAPL | Stock | 198.825 | 199.38 | 197.86 | 199.33 | 1659052.0 |
| 2025-04-22 12:00:00 | AAPL | Stock | 199.34 | 201.55 | 199.02 | 201.38 | 3732234.0 |
| 2025-04-22 12:30:00 | AAPL | Stock | 201.4 | 201.59 | 200.2704 | 200.5901 | 2097178.0 |
| 2025-04-22 13:00:00 | AAPL | Stock | 200.605 | 201.01 | 198.3203 | 198.54 | 2317079.0 |
| 2025-04-22 13:30:00 | AAPL | Stock | 198.53 | 199.26 | 198.11 | 198.2512 | 1515774.0 |
| 2025-04-22 14:00:00 | AAPL | Stock | 198.25 | 200.01 | 198.1024 | 199.89 | 1328478.0 |
| 2025-04-22 14:30:00 | AAPL | Stock | 199.88 | 200.5 | 199.8 | 200.15 | 1413333.0 |
| 2025-04-22 15:00:00 | AAPL | Stock | 200.14 | 200.42 | 198.56 | 198.6202 | 1588548.0 |
| 2025-04-22 15:30:00 | AAPL | Stock | 198.63 | 199.89 | 198.0 | 199.56 | 4173687.0 |
| 2025-04-22 16:00:00 | AAPL | Stock | 199.54 | 199.88 | 199.5 | 199.6 | 7234581.0 |
| 2025-04-22 16:30:00 | AAPL | Stock | 199.74 | 199.9 | 199.61 | 199.83 | 81402.0 |
| 2025-04-22 17:00:00 | AAPL | Stock | 199.8 | 203.4897 | 199.74 | 203.1184 | 353839.0 |
| 2025-04-22 17:30:00 | AAPL | Stock | 203.16 | 205.0 | 203.08 | 204.95 | 209574.0 |
| 2025-04-22 18:00:00 | AAPL | Stock | 204.91 | 205.75 | 203.52 | 204.7482 | 126547.0 |
| 2025-04-22 18:30:00 | AAPL | Stock | 204.75 | 205.5 | 204.55 | 205.27 | 85160.0 |
| 2025-04-22 19:00:00 | AAPL | Stock | 205.4 | 205.75 | 204.75 | 205.3 | 70559.0 |
| 2025-04-22 19:30:00 | AAPL | Stock | 205.0 | 205.28 | 204.7301 | 205.0 | 50566.0 |
| 2025-04-22 04:00:00 | MSFT | Stock | 362.46 | 363.27 | 362.4 | 363.23 | 2920.0 |
| 2025-04-22 04:30:00 | MSFT | Stock | 363.21 | 363.87 | 363.21 | 363.72 | 1812.0 |
| 2025-04-22 05:00:00 | MSFT | Stock | 363.54 | 363.54 | 362.98 | 362.98 | 2636.0 |
| 2025-04-22 05:30:00 | MSFT | Stock | 362.68 | 362.68 | 361.93 | 362.0 | 1792.0 |
| 2025-04-22 06:00:00 | MSFT | Stock | 362.28 | 362.28 | 361.97 | 362.1 | 4221.0 |
| 2025-04-22 06:30:00 | MSFT | Stock | 362.34 | 362.34 | 362.34 | 362.34 | 100.0 |
| 2025-04-22 07:00:00 | MSFT | Stock | 362.07 | 362.3 | 361.41 | 361.75 | 3160.0 |
| 2025-04-22 07:30:00 | MSFT | Stock | 361.73 | 361.8 | 361.0 | 361.0 | 7985.0 |
| 2025-04-22 08:00:00 | MSFT | Stock | 362.2 | 363.7 | 360.52 | 361.27 | 19481.0 |
| 2025-04-22 08:30:00 | MSFT | Stock | 361.2685 | 362.85 | 359.12 | 362.3 | 5235.0 |
| 2025-04-22 09:00:00 | MSFT | Stock | 362.22 | 363.75 | 361.6496 | 363.48 | 21888.0 |
| 2025-04-22 09:30:00 | MSFT | Stock | 363.27 | 363.5 | 359.8602 | 361.195 | 1390595.0 |
| 2025-04-22 10:00:00 | MSFT | Stock | 361.165 | 363.33 | 361.01 | 362.86 | 883799.0 |
| 2025-04-22 10:30:00 | MSFT | Stock | 362.935 | 365.09 | 362.24 | 364.65 | 729355.0 |
| 2025-04-22 11:00:00 | MSFT | Stock | 364.65 | 365.12 | 364.15 | 364.205 | 517366.0 |
| 2025-04-22 11:30:00 | MSFT | Stock | 364.2 | 366.16 | 363.702 | 365.86 | 596284.0 |
| 2025-04-22 12:00:00 | MSFT | Stock | 365.91 | 367.77 | 365.885 | 367.435 | 463819.0 |
| 2025-04-22 12:30:00 | MSFT | Stock | 367.3949 | 367.72 | 366.41 | 366.745 | 403668.0 |
> showing 50 of 104,615 rows — these rows as CSV