PREVIEW / stock_30min / 2025-03-14
file: by_date/stock_30min/2025/2025-03-14.parquet size: 2.1 MB rows: 101,835 symbols: 486
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-03-14 04:00:00 | AAPL | Stock | 210.72 | 211.05 | 210.71 | 210.94 | 5682.0 |
| 2025-03-14 04:30:00 | AAPL | Stock | 210.91 | 210.93 | 210.62 | 210.81 | 6234.0 |
| 2025-03-14 05:00:00 | AAPL | Stock | 210.78 | 210.9 | 210.65 | 210.76 | 7936.0 |
| 2025-03-14 05:30:00 | AAPL | Stock | 210.75 | 210.75 | 210.25 | 210.49 | 11259.0 |
| 2025-03-14 06:00:00 | AAPL | Stock | 210.62 | 210.69 | 210.38 | 210.57 | 4866.0 |
| 2025-03-14 06:30:00 | AAPL | Stock | 210.46 | 210.87 | 210.36 | 210.82 | 14603.0 |
| 2025-03-14 07:00:00 | AAPL | Stock | 210.82 | 211.08 | 210.52 | 211.02 | 24631.0 |
| 2025-03-14 07:30:00 | AAPL | Stock | 211.02 | 211.05 | 210.9 | 210.94 | 18322.0 |
| 2025-03-14 08:00:00 | AAPL | Stock | 210.83 | 211.85 | 210.34 | 210.98 | 195374.0 |
| 2025-03-14 08:30:00 | AAPL | Stock | 210.97 | 211.4 | 210.65 | 211.3025 | 89979.0 |
| 2025-03-14 09:00:00 | AAPL | Stock | 211.3949 | 211.53 | 210.6 | 211.28 | 182209.0 |
| 2025-03-14 09:30:00 | AAPL | Stock | 211.25 | 213.43 | 210.97 | 212.49 | 5819350.0 |
| 2025-03-14 10:00:00 | AAPL | Stock | 212.44 | 212.44 | 209.58 | 210.3781 | 4364627.0 |
| 2025-03-14 10:30:00 | AAPL | Stock | 210.38 | 211.89 | 209.98 | 211.74 | 3175059.0 |
| 2025-03-14 11:00:00 | AAPL | Stock | 211.7625 | 212.38 | 211.2 | 211.93 | 2166652.0 |
| 2025-03-14 11:30:00 | AAPL | Stock | 211.93 | 213.95 | 211.91 | 213.28 | 2874392.0 |
| 2025-03-14 12:00:00 | AAPL | Stock | 213.28 | 213.29 | 212.2307 | 212.2307 | 1657849.0 |
| 2025-03-14 12:30:00 | AAPL | Stock | 212.235 | 213.23 | 212.0723 | 212.88 | 1268390.0 |
| 2025-03-14 13:00:00 | AAPL | Stock | 212.87 | 213.5 | 212.26 | 212.315 | 1472933.0 |
| 2025-03-14 13:30:00 | AAPL | Stock | 212.3026 | 212.625 | 211.96 | 212.4 | 1538054.0 |
| 2025-03-14 14:00:00 | AAPL | Stock | 212.385 | 212.6899 | 210.76 | 211.245 | 2776952.0 |
| 2025-03-14 14:30:00 | AAPL | Stock | 211.25 | 212.7 | 211.25 | 212.61 | 1627184.0 |
| 2025-03-14 15:00:00 | AAPL | Stock | 212.61 | 213.411 | 212.485 | 212.9053 | 1816782.0 |
| 2025-03-14 15:30:00 | AAPL | Stock | 212.891 | 213.9 | 212.71 | 213.38 | 4917350.0 |
| 2025-03-14 16:00:00 | AAPL | Stock | 213.32 | 213.49 | 213.13 | 213.16 | 8032317.0 |
| 2025-03-14 16:30:00 | AAPL | Stock | 213.1894 | 213.49 | 213.18 | 213.2699 | 70061.0 |
| 2025-03-14 17:00:00 | AAPL | Stock | 213.24 | 213.49 | 213.22 | 213.22 | 5935.0 |
| 2025-03-14 17:30:00 | AAPL | Stock | 213.2632 | 213.2988 | 213.18 | 213.18 | 7655.0 |
| 2025-03-14 18:00:00 | AAPL | Stock | 213.28 | 213.28 | 213.19 | 213.2385 | 3213.0 |
| 2025-03-14 18:30:00 | AAPL | Stock | 213.18 | 213.3 | 213.1205 | 213.261 | 10037.0 |
| 2025-03-14 19:00:00 | AAPL | Stock | 213.28 | 213.3 | 213.17 | 213.2899 | 5318.0 |
| 2025-03-14 19:30:00 | AAPL | Stock | 213.2011 | 213.3481 | 213.2002 | 213.29 | 16846.0 |
| 2025-03-14 04:00:00 | MSFT | Stock | 380.98 | 381.53 | 380.97 | 381.53 | 1528.0 |
| 2025-03-14 04:30:00 | MSFT | Stock | 381.4 | 381.7 | 381.4 | 381.49 | 1662.0 |
| 2025-03-14 05:00:00 | MSFT | Stock | 381.54 | 381.94 | 381.52 | 381.8 | 780.0 |
| 2025-03-14 05:30:00 | MSFT | Stock | 381.6 | 381.77 | 381.59 | 381.71 | 2065.0 |
| 2025-03-14 06:00:00 | MSFT | Stock | 381.62 | 381.62 | 381.02 | 381.02 | 2077.0 |
| 2025-03-14 06:30:00 | MSFT | Stock | 380.5 | 381.51 | 380.38 | 381.51 | 3084.0 |
| 2025-03-14 07:00:00 | MSFT | Stock | 381.5 | 381.87 | 381.49 | 381.7 | 4510.0 |
| 2025-03-14 07:30:00 | MSFT | Stock | 381.69 | 382.0 | 381.69 | 381.76 | 4429.0 |
| 2025-03-14 08:00:00 | MSFT | Stock | 381.89 | 382.98 | 380.93 | 382.91 | 37258.0 |
| 2025-03-14 08:30:00 | MSFT | Stock | 382.98 | 383.1995 | 382.406 | 382.41 | 17003.0 |
| 2025-03-14 09:00:00 | MSFT | Stock | 382.44 | 382.7671 | 379.39 | 379.62 | 60788.0 |
| 2025-03-14 09:30:00 | MSFT | Stock | 379.775 | 384.42 | 379.51 | 383.25 | 1538023.0 |
| 2025-03-14 10:00:00 | MSFT | Stock | 383.1 | 383.2889 | 380.64 | 381.535 | 738329.0 |
| 2025-03-14 10:30:00 | MSFT | Stock | 381.535 | 385.45 | 381.4 | 385.39 | 748842.0 |
| 2025-03-14 11:00:00 | MSFT | Stock | 385.44 | 385.94 | 384.5501 | 385.235 | 618020.0 |
| 2025-03-14 11:30:00 | MSFT | Stock | 385.28 | 387.4 | 385.07 | 386.995 | 827288.0 |
| 2025-03-14 12:00:00 | MSFT | Stock | 387.04 | 387.25 | 386.125 | 386.185 | 424284.0 |
| 2025-03-14 12:30:00 | MSFT | Stock | 386.095 | 387.8492 | 385.9035 | 387.71 | 402898.0 |
> showing 50 of 101,835 rows — these rows as CSV