PREVIEW / stock_30min / 2025-05-22
file: by_date/stock_30min/2025/2025-05-22.parquet size: 2.2 MB rows: 103,224 symbols: 408
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-22 04:00:00 | AAPL | Stock | 202.02 | 202.55 | 202.02 | 202.38 | 12185.0 |
| 2025-05-22 04:30:00 | AAPL | Stock | 202.39 | 202.4 | 202.15 | 202.36 | 3627.0 |
| 2025-05-22 05:00:00 | AAPL | Stock | 202.3 | 202.46 | 202.3 | 202.38 | 1671.0 |
| 2025-05-22 05:30:00 | AAPL | Stock | 202.38 | 202.72 | 202.37 | 202.5 | 9879.0 |
| 2025-05-22 06:00:00 | AAPL | Stock | 202.45 | 202.55 | 202.32 | 202.38 | 6420.0 |
| 2025-05-22 06:30:00 | AAPL | Stock | 202.3 | 202.32 | 202.04 | 202.04 | 7506.0 |
| 2025-05-22 07:00:00 | AAPL | Stock | 202.04 | 202.49 | 201.69 | 201.73 | 11651.0 |
| 2025-05-22 07:30:00 | AAPL | Stock | 201.78 | 201.9 | 201.01 | 201.01 | 23544.0 |
| 2025-05-22 08:00:00 | AAPL | Stock | 202.28 | 202.52 | 200.58 | 200.6 | 119194.0 |
| 2025-05-22 08:30:00 | AAPL | Stock | 200.56 | 201.6 | 200.55 | 201.6 | 71827.0 |
| 2025-05-22 09:00:00 | AAPL | Stock | 201.66 | 201.8 | 200.58 | 200.79 | 89776.0 |
| 2025-05-22 09:30:00 | AAPL | Stock | 200.71 | 201.4422 | 199.7 | 201.2 | 6059591.0 |
| 2025-05-22 10:00:00 | AAPL | Stock | 201.21 | 201.64 | 200.2593 | 200.36 | 2994502.0 |
| 2025-05-22 10:30:00 | AAPL | Stock | 200.37 | 201.19 | 200.35 | 200.865 | 2259566.0 |
| 2025-05-22 11:00:00 | AAPL | Stock | 200.85 | 201.37 | 200.65 | 200.95 | 1661278.0 |
| 2025-05-22 11:30:00 | AAPL | Stock | 200.95 | 202.29 | 200.85 | 201.75 | 2032134.0 |
| 2025-05-22 12:00:00 | AAPL | Stock | 201.75 | 202.4099 | 201.6 | 201.95 | 1358038.0 |
| 2025-05-22 12:30:00 | AAPL | Stock | 201.945 | 202.0699 | 201.61 | 201.6328 | 1102514.0 |
| 2025-05-22 13:00:00 | AAPL | Stock | 201.64 | 201.95 | 201.16 | 201.89 | 1295659.0 |
| 2025-05-22 13:30:00 | AAPL | Stock | 201.88 | 202.18 | 201.67 | 201.89 | 1333838.0 |
| 2025-05-22 14:00:00 | AAPL | Stock | 201.885 | 202.22 | 201.675 | 201.97 | 1423431.0 |
| 2025-05-22 14:30:00 | AAPL | Stock | 201.96 | 202.255 | 201.64 | 202.13 | 1529753.0 |
| 2025-05-22 15:00:00 | AAPL | Stock | 202.12 | 202.75 | 202.1 | 202.61 | 1889240.0 |
| 2025-05-22 15:30:00 | AAPL | Stock | 202.62 | 202.65 | 201.0 | 201.37 | 4426100.0 |
| 2025-05-22 16:00:00 | AAPL | Stock | 201.36 | 201.45 | 201.08 | 201.44 | 4369590.0 |
| 2025-05-22 16:30:00 | AAPL | Stock | 201.439 | 201.9133 | 201.36 | 201.65 | 44425.0 |
| 2025-05-22 17:00:00 | AAPL | Stock | 201.84 | 201.8983 | 201.6674 | 201.8983 | 9837.0 |
| 2025-05-22 17:30:00 | AAPL | Stock | 201.88 | 201.88 | 201.45 | 201.64 | 11068.0 |
| 2025-05-22 18:00:00 | AAPL | Stock | 201.86 | 201.9325 | 201.51 | 201.51 | 8752.0 |
| 2025-05-22 18:30:00 | AAPL | Stock | 201.49 | 201.8387 | 201.01 | 201.2 | 13103.0 |
| 2025-05-22 19:00:00 | AAPL | Stock | 201.24 | 201.4576 | 201.1 | 201.4 | 15979.0 |
| 2025-05-22 19:30:00 | AAPL | Stock | 201.399 | 201.5 | 201.12 | 201.5 | 16121.0 |
| 2025-05-22 04:00:00 | MSFT | Stock | 452.85 | 452.85 | 452.47 | 452.47 | 200.0 |
| 2025-05-22 04:30:00 | MSFT | Stock | 452.6 | 452.6 | 452.6 | 452.6 | 100.0 |
| 2025-05-22 05:00:00 | MSFT | Stock | 452.66 | 452.66 | 452.66 | 452.66 | 100.0 |
| 2025-05-22 05:30:00 | MSFT | Stock | 452.6 | 452.6 | 452.3 | 452.3 | 1106.0 |
| 2025-05-22 06:00:00 | MSFT | Stock | 452.37 | 453.0 | 452.37 | 452.99 | 1258.0 |
| 2025-05-22 06:30:00 | MSFT | Stock | 452.99 | 452.99 | 452.99 | 452.99 | 135.0 |
| 2025-05-22 07:00:00 | MSFT | Stock | 453.18 | 453.22 | 452.88 | 452.88 | 1259.0 |
| 2025-05-22 07:30:00 | MSFT | Stock | 452.66 | 452.95 | 451.44 | 451.44 | 5011.0 |
| 2025-05-22 08:00:00 | MSFT | Stock | 452.57 | 453.5305 | 450.11 | 450.44 | 13407.0 |
| 2025-05-22 08:30:00 | MSFT | Stock | 450.3 | 453.4291 | 450.3 | 453.4291 | 5999.0 |
| 2025-05-22 09:00:00 | MSFT | Stock | 453.4 | 455.23 | 452.53 | 455.23 | 23223.0 |
| 2025-05-22 09:30:00 | MSFT | Stock | 455.23 | 459.5 | 454.16 | 459.38 | 1788214.0 |
| 2025-05-22 10:00:00 | MSFT | Stock | 459.3 | 460.25 | 457.73 | 457.81 | 1134749.0 |
| 2025-05-22 10:30:00 | MSFT | Stock | 457.8 | 458.5 | 456.27 | 457.25 | 678503.0 |
| 2025-05-22 11:00:00 | MSFT | Stock | 457.23 | 457.61 | 455.07 | 455.09 | 459809.0 |
| 2025-05-22 11:30:00 | MSFT | Stock | 455.05 | 456.25 | 454.87 | 456.16 | 433517.0 |
| 2025-05-22 12:00:00 | MSFT | Stock | 456.17 | 456.875 | 455.88 | 456.3004 | 380616.0 |
| 2025-05-22 12:30:00 | MSFT | Stock | 456.3 | 456.35 | 454.52 | 454.52 | 294528.0 |
> showing 50 of 103,224 rows — these rows as CSV