PREVIEW / stock_30min / 2025-04-17
file: by_date/stock_30min/2025/2025-04-17.parquet size: 2.1 MB rows: 100,074 symbols: 434
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-17 04:00:00 | AAPL | Stock | 196.5 | 197.0 | 196.4 | 196.69 | 19936.0 |
| 2025-04-17 04:30:00 | AAPL | Stock | 196.68 | 197.15 | 196.36 | 196.37 | 15127.0 |
| 2025-04-17 05:00:00 | AAPL | Stock | 196.3 | 196.61 | 196.11 | 196.39 | 12853.0 |
| 2025-04-17 05:30:00 | AAPL | Stock | 196.44 | 196.49 | 196.08 | 196.48 | 5463.0 |
| 2025-04-17 06:00:00 | AAPL | Stock | 196.47 | 196.58 | 196.27 | 196.46 | 6278.0 |
| 2025-04-17 06:30:00 | AAPL | Stock | 196.47 | 196.47 | 195.86 | 195.95 | 15770.0 |
| 2025-04-17 07:00:00 | AAPL | Stock | 195.94 | 196.04 | 195.2 | 195.96 | 27229.0 |
| 2025-04-17 07:30:00 | AAPL | Stock | 195.99 | 196.2 | 195.82 | 195.98 | 8754.0 |
| 2025-04-17 08:00:00 | AAPL | Stock | 195.76 | 198.0 | 195.2 | 196.78 | 125089.0 |
| 2025-04-17 08:30:00 | AAPL | Stock | 196.78 | 197.4916 | 196.6 | 197.28 | 49253.0 |
| 2025-04-17 09:00:00 | AAPL | Stock | 197.43 | 197.43 | 195.8 | 197.0 | 218543.0 |
| 2025-04-17 09:30:00 | AAPL | Stock | 197.02 | 197.2 | 194.64 | 196.08 | 6326289.0 |
| 2025-04-17 10:00:00 | AAPL | Stock | 196.1 | 196.51 | 195.43 | 195.65 | 2202600.0 |
| 2025-04-17 10:30:00 | AAPL | Stock | 195.64 | 197.095 | 194.42 | 195.7826 | 3023197.0 |
| 2025-04-17 11:00:00 | AAPL | Stock | 195.79 | 197.08 | 195.43 | 196.04 | 2214102.0 |
| 2025-04-17 11:30:00 | AAPL | Stock | 196.03 | 197.0 | 195.9887 | 196.11 | 1305183.0 |
| 2025-04-17 12:00:00 | AAPL | Stock | 196.12 | 198.05 | 196.08 | 197.805 | 2078912.0 |
| 2025-04-17 12:30:00 | AAPL | Stock | 197.826 | 198.57 | 197.18 | 198.17 | 1696453.0 |
| 2025-04-17 13:00:00 | AAPL | Stock | 198.16 | 198.39 | 196.68 | 196.71 | 1505158.0 |
| 2025-04-17 13:30:00 | AAPL | Stock | 196.71 | 198.27 | 196.67 | 197.81 | 1267416.0 |
| 2025-04-17 14:00:00 | AAPL | Stock | 197.82 | 198.8335 | 197.68 | 198.285 | 1468492.0 |
| 2025-04-17 14:30:00 | AAPL | Stock | 198.29 | 198.66 | 197.3763 | 197.395 | 1721427.0 |
| 2025-04-17 15:00:00 | AAPL | Stock | 197.4 | 197.77 | 196.87 | 197.25 | 1774288.0 |
| 2025-04-17 15:30:00 | AAPL | Stock | 197.25 | 197.7 | 195.81 | 196.87 | 3283333.0 |
| 2025-04-17 16:00:00 | AAPL | Stock | 196.98 | 197.6 | 196.93 | 197.05 | 7322484.0 |
| 2025-04-17 16:30:00 | AAPL | Stock | 197.08 | 198.0 | 196.98 | 197.32 | 560923.0 |
| 2025-04-17 17:00:00 | AAPL | Stock | 197.59 | 197.6 | 196.98 | 196.98 | 42261.0 |
| 2025-04-17 17:30:00 | AAPL | Stock | 197.38 | 197.4 | 197.07 | 197.38 | 6262.0 |
| 2025-04-17 18:00:00 | AAPL | Stock | 197.5291 | 197.5291 | 197.29 | 197.33 | 3148.0 |
| 2025-04-17 18:30:00 | AAPL | Stock | 197.31 | 197.34 | 197.0 | 197.1 | 5662.0 |
| 2025-04-17 19:00:00 | AAPL | Stock | 197.199 | 197.1997 | 197.0102 | 197.1 | 8758.0 |
| 2025-04-17 19:30:00 | AAPL | Stock | 197.15 | 197.4 | 197.1 | 197.25 | 11000.0 |
| 2025-04-17 04:00:00 | MSFT | Stock | 375.29 | 375.62 | 374.31 | 374.84 | 6593.0 |
| 2025-04-17 04:30:00 | MSFT | Stock | 375.36 | 375.36 | 372.7 | 373.0 | 4067.0 |
| 2025-04-17 05:00:00 | MSFT | Stock | 373.0 | 374.93 | 373.0 | 374.25 | 8753.0 |
| 2025-04-17 05:30:00 | MSFT | Stock | 374.4 | 375.0 | 374.13 | 374.58 | 4506.0 |
| 2025-04-17 06:00:00 | MSFT | Stock | 374.21 | 374.6 | 373.35 | 374.6 | 3071.0 |
| 2025-04-17 06:30:00 | MSFT | Stock | 374.43 | 374.48 | 373.0 | 373.1 | 10379.0 |
| 2025-04-17 07:00:00 | MSFT | Stock | 373.47 | 373.5 | 372.04 | 373.0 | 14129.0 |
| 2025-04-17 07:30:00 | MSFT | Stock | 373.25 | 373.25 | 372.36 | 372.69 | 1464.0 |
| 2025-04-17 08:00:00 | MSFT | Stock | 372.5 | 375.1 | 371.61 | 372.4751 | 36517.0 |
| 2025-04-17 08:30:00 | MSFT | Stock | 372.895 | 374.03 | 372.39 | 372.63 | 8287.0 |
| 2025-04-17 09:00:00 | MSFT | Stock | 372.68 | 374.79 | 370.5 | 373.8 | 39429.0 |
| 2025-04-17 09:30:00 | MSFT | Stock | 373.8 | 374.3215 | 370.76 | 372.37 | 2679060.0 |
| 2025-04-17 10:00:00 | MSFT | Stock | 372.37 | 372.51 | 369.59 | 370.315 | 767729.0 |
| 2025-04-17 10:30:00 | MSFT | Stock | 370.34 | 370.64 | 368.625 | 369.7544 | 403660.0 |
| 2025-04-17 11:00:00 | MSFT | Stock | 369.71 | 372.5 | 369.09 | 370.395 | 533444.0 |
| 2025-04-17 11:30:00 | MSFT | Stock | 370.45 | 371.99 | 370.34 | 370.85 | 386495.0 |
| 2025-04-17 12:00:00 | MSFT | Stock | 370.89 | 372.53 | 370.445 | 371.82 | 514466.0 |
| 2025-04-17 12:30:00 | MSFT | Stock | 371.875 | 372.2 | 369.78 | 371.485 | 431285.0 |
> showing 50 of 100,074 rows — these rows as CSV