PREVIEW / stock_30min / 2025-05-13
file: by_date/stock_30min/2025/2025-05-13.parquet size: 2.3 MB rows: 107,217 symbols: 418
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-05-13 04:00:00 | AAPL | Stock | 210.0 | 210.0 | 209.0 | 209.6 | 23167.0 |
| 2025-05-13 04:30:00 | AAPL | Stock | 209.6 | 209.83 | 209.2 | 209.43 | 7389.0 |
| 2025-05-13 05:00:00 | AAPL | Stock | 209.3 | 209.58 | 209.22 | 209.58 | 5481.0 |
| 2025-05-13 05:30:00 | AAPL | Stock | 209.46 | 209.57 | 209.42 | 209.57 | 3856.0 |
| 2025-05-13 06:00:00 | AAPL | Stock | 209.6 | 209.66 | 209.25 | 209.41 | 7010.0 |
| 2025-05-13 06:30:00 | AAPL | Stock | 209.45 | 209.69 | 209.33 | 209.65 | 15602.0 |
| 2025-05-13 07:00:00 | AAPL | Stock | 209.68 | 210.27 | 209.68 | 210.05 | 24863.0 |
| 2025-05-13 07:30:00 | AAPL | Stock | 210.05 | 210.38 | 209.99 | 210.38 | 18613.0 |
| 2025-05-13 08:00:00 | AAPL | Stock | 209.7 | 211.37 | 208.98 | 210.97 | 146736.0 |
| 2025-05-13 08:30:00 | AAPL | Stock | 210.85 | 211.75 | 210.35 | 210.76 | 156909.0 |
| 2025-05-13 09:00:00 | AAPL | Stock | 210.7608 | 210.99 | 210.11 | 210.41 | 123211.0 |
| 2025-05-13 09:30:00 | AAPL | Stock | 210.37 | 211.61 | 209.0 | 209.93 | 5225115.0 |
| 2025-05-13 10:00:00 | AAPL | Stock | 209.93 | 211.67 | 209.78 | 211.45 | 3245411.0 |
| 2025-05-13 10:30:00 | AAPL | Stock | 211.445 | 211.88 | 211.07 | 211.5 | 2076481.0 |
| 2025-05-13 11:00:00 | AAPL | Stock | 211.51 | 211.61 | 211.22 | 211.385 | 1459126.0 |
| 2025-05-13 11:30:00 | AAPL | Stock | 211.3975 | 211.61 | 210.48 | 210.89 | 2029584.0 |
| 2025-05-13 12:00:00 | AAPL | Stock | 210.9 | 211.305 | 210.65 | 211.29 | 1087435.0 |
| 2025-05-13 12:30:00 | AAPL | Stock | 211.28 | 211.64 | 210.9 | 211.48 | 1233955.0 |
| 2025-05-13 13:00:00 | AAPL | Stock | 211.5 | 211.95 | 211.35 | 211.71 | 1295834.0 |
| 2025-05-13 13:30:00 | AAPL | Stock | 211.71 | 212.97 | 211.7099 | 212.5 | 2170922.0 |
| 2025-05-13 14:00:00 | AAPL | Stock | 212.5001 | 212.7498 | 212.2303 | 212.46 | 1072498.0 |
| 2025-05-13 14:30:00 | AAPL | Stock | 212.4752 | 212.63 | 212.03 | 212.5457 | 1456301.0 |
| 2025-05-13 15:00:00 | AAPL | Stock | 212.535 | 213.4 | 212.45 | 213.21 | 2237845.0 |
| 2025-05-13 15:30:00 | AAPL | Stock | 213.19 | 213.4 | 212.6 | 212.845 | 3459514.0 |
| 2025-05-13 16:00:00 | AAPL | Stock | 212.8599 | 212.93 | 212.3 | 212.371 | 9200398.0 |
| 2025-05-13 16:30:00 | AAPL | Stock | 212.3997 | 212.4 | 211.9152 | 211.9152 | 69237.0 |
| 2025-05-13 17:00:00 | AAPL | Stock | 211.93 | 212.93 | 211.8 | 211.8991 | 33304.0 |
| 2025-05-13 17:30:00 | AAPL | Stock | 211.9 | 211.9 | 211.67 | 211.71 | 126322.0 |
| 2025-05-13 18:00:00 | AAPL | Stock | 211.78 | 211.8 | 211.76 | 211.77 | 33637.0 |
| 2025-05-13 18:30:00 | AAPL | Stock | 211.7618 | 211.8 | 211.69 | 211.75 | 10149.0 |
| 2025-05-13 19:00:00 | AAPL | Stock | 211.74 | 212.12 | 211.71 | 212.02 | 44354.0 |
| 2025-05-13 19:30:00 | AAPL | Stock | 212.02 | 212.2494 | 211.9 | 212.15 | 35477.0 |
| 2025-05-13 04:00:00 | MSFT | Stock | 446.37 | 446.84 | 446.11 | 446.65 | 1742.0 |
| 2025-05-13 04:30:00 | MSFT | Stock | 446.71 | 447.0 | 446.35 | 446.87 | 1642.0 |
| 2025-05-13 05:00:00 | MSFT | Stock | 446.75 | 447.13 | 446.7 | 447.13 | 1500.0 |
| 2025-05-13 05:30:00 | MSFT | Stock | 447.09 | 447.1 | 447.02 | 447.02 | 1800.0 |
| 2025-05-13 06:00:00 | MSFT | Stock | 447.14 | 447.23 | 447.0 | 447.01 | 1852.0 |
| 2025-05-13 06:30:00 | MSFT | Stock | 446.8 | 447.44 | 446.8 | 447.25 | 871.0 |
| 2025-05-13 07:00:00 | MSFT | Stock | 447.09 | 447.75 | 447.09 | 447.75 | 3208.0 |
| 2025-05-13 07:30:00 | MSFT | Stock | 447.55 | 447.9 | 447.5 | 447.6 | 4482.0 |
| 2025-05-13 08:00:00 | MSFT | Stock | 447.63 | 448.35 | 446.5 | 448.12 | 11034.0 |
| 2025-05-13 08:30:00 | MSFT | Stock | 449.26 | 450.0 | 448.0484 | 448.2 | 25900.0 |
| 2025-05-13 09:00:00 | MSFT | Stock | 448.27 | 448.7 | 447.5 | 447.64 | 19451.0 |
| 2025-05-13 09:30:00 | MSFT | Stock | 447.85 | 449.8499 | 445.36 | 449.655 | 1565409.0 |
| 2025-05-13 10:00:00 | MSFT | Stock | 449.58 | 450.6733 | 448.6918 | 448.7643 | 1294692.0 |
| 2025-05-13 10:30:00 | MSFT | Stock | 448.78 | 449.095 | 446.82 | 448.23 | 1149967.0 |
| 2025-05-13 11:00:00 | MSFT | Stock | 448.24 | 448.37 | 446.63 | 448.115 | 977323.0 |
| 2025-05-13 11:30:00 | MSFT | Stock | 448.08 | 448.7776 | 447.34 | 447.75 | 566560.0 |
| 2025-05-13 12:00:00 | MSFT | Stock | 447.72 | 448.2 | 447.25 | 447.81 | 402214.0 |
| 2025-05-13 12:30:00 | MSFT | Stock | 447.77 | 449.0 | 447.55 | 448.72 | 378720.0 |
> showing 50 of 107,217 rows — these rows as CSV