PREVIEW / stock_30min / 2025-03-13
file: by_date/stock_30min/2025/2025-03-13.parquet size: 2.1 MB rows: 101,367 symbols: 485
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-13 04:00:00 | AAPL | Stock | 216.0 | 216.0 | 215.25 | 215.68 | 15619.0 |
| 2025-03-13 04:30:00 | AAPL | Stock | 215.67 | 215.95 | 215.51 | 215.93 | 6733.0 |
| 2025-03-13 05:00:00 | AAPL | Stock | 215.93 | 216.9 | 215.93 | 216.6 | 12090.0 |
| 2025-03-13 05:30:00 | AAPL | Stock | 216.58 | 216.98 | 216.47 | 216.98 | 10673.0 |
| 2025-03-13 06:00:00 | AAPL | Stock | 216.94 | 216.98 | 216.65 | 216.97 | 8972.0 |
| 2025-03-13 06:30:00 | AAPL | Stock | 216.78 | 216.8 | 216.3 | 216.3 | 6320.0 |
| 2025-03-13 07:00:00 | AAPL | Stock | 216.39 | 216.45 | 215.65 | 215.71 | 20836.0 |
| 2025-03-13 07:30:00 | AAPL | Stock | 215.76 | 216.45 | 215.65 | 216.07 | 18651.0 |
| 2025-03-13 08:00:00 | AAPL | Stock | 215.84 | 216.8 | 215.0 | 215.8231 | 82457.0 |
| 2025-03-13 08:30:00 | AAPL | Stock | 216.19 | 216.75 | 215.8357 | 216.0 | 42901.0 |
| 2025-03-13 09:00:00 | AAPL | Stock | 215.98 | 216.29 | 215.06 | 215.8 | 138323.0 |
| 2025-03-13 09:30:00 | AAPL | Stock | 215.94 | 216.8394 | 214.37 | 215.265 | 5285847.0 |
| 2025-03-13 10:00:00 | AAPL | Stock | 215.275 | 215.935 | 214.22 | 214.29 | 3061858.0 |
| 2025-03-13 10:30:00 | AAPL | Stock | 214.3 | 214.82 | 213.65 | 214.225 | 2779412.0 |
| 2025-03-13 11:00:00 | AAPL | Stock | 214.24 | 214.8 | 213.63 | 214.0402 | 1726512.0 |
| 2025-03-13 11:30:00 | AAPL | Stock | 214.045 | 214.35 | 212.0 | 212.0757 | 3290597.0 |
| 2025-03-13 12:00:00 | AAPL | Stock | 212.08 | 212.33 | 211.55 | 211.94 | 3180583.0 |
| 2025-03-13 12:30:00 | AAPL | Stock | 211.9338 | 212.93 | 211.13 | 211.49 | 2521276.0 |
| 2025-03-13 13:00:00 | AAPL | Stock | 211.49 | 211.7 | 210.69 | 211.155 | 2000651.0 |
| 2025-03-13 13:30:00 | AAPL | Stock | 211.14 | 211.36 | 210.5 | 211.115 | 1836119.0 |
| 2025-03-13 14:00:00 | AAPL | Stock | 211.1 | 212.47 | 211.04 | 212.28 | 1922278.0 |
| 2025-03-13 14:30:00 | AAPL | Stock | 212.286 | 212.4699 | 211.39 | 211.92 | 1789297.0 |
| 2025-03-13 15:00:00 | AAPL | Stock | 211.91 | 212.29 | 210.36 | 210.63 | 2468951.0 |
| 2025-03-13 15:30:00 | AAPL | Stock | 210.67 | 210.71 | 208.42 | 209.71 | 7400971.0 |
| 2025-03-13 16:00:00 | AAPL | Stock | 209.71 | 211.5036 | 209.61 | 209.96 | 6493191.0 |
| 2025-03-13 16:30:00 | AAPL | Stock | 209.96 | 209.98 | 209.68 | 209.8491 | 142008.0 |
| 2025-03-13 17:00:00 | AAPL | Stock | 209.849 | 209.85 | 209.7014 | 209.74 | 16193.0 |
| 2025-03-13 17:30:00 | AAPL | Stock | 209.75 | 209.9 | 209.7 | 209.9 | 19397.0 |
| 2025-03-13 18:00:00 | AAPL | Stock | 209.94 | 210.46 | 209.94 | 210.38 | 35332.0 |
| 2025-03-13 18:30:00 | AAPL | Stock | 210.38 | 210.88 | 210.31 | 210.56 | 27212.0 |
| 2025-03-13 19:00:00 | AAPL | Stock | 210.5 | 210.6388 | 209.68 | 210.2201 | 13290.0 |
| 2025-03-13 19:30:00 | AAPL | Stock | 210.3 | 210.4474 | 210.02 | 210.2 | 13948.0 |
| 2025-03-13 04:00:00 | MSFT | Stock | 380.78 | 380.78 | 379.1 | 379.88 | 4927.0 |
| 2025-03-13 04:30:00 | MSFT | Stock | 379.83 | 380.3 | 379.83 | 380.3 | 2728.0 |
| 2025-03-13 05:00:00 | MSFT | Stock | 380.59 | 381.95 | 380.41 | 381.37 | 6847.0 |
| 2025-03-13 05:30:00 | MSFT | Stock | 381.33 | 382.0 | 381.33 | 382.0 | 3128.0 |
| 2025-03-13 06:00:00 | MSFT | Stock | 382.28 | 385.5 | 382.28 | 385.36 | 25618.0 |
| 2025-03-13 06:30:00 | MSFT | Stock | 385.14 | 385.14 | 383.79 | 384.33 | 6719.0 |
| 2025-03-13 07:00:00 | MSFT | Stock | 384.05 | 384.72 | 382.95 | 382.96 | 10679.0 |
| 2025-03-13 07:30:00 | MSFT | Stock | 383.3 | 383.41 | 381.35 | 381.35 | 12586.0 |
| 2025-03-13 08:00:00 | MSFT | Stock | 384.17 | 384.33 | 379.01 | 381.65 | 36944.0 |
| 2025-03-13 08:30:00 | MSFT | Stock | 381.65 | 382.97 | 381.65 | 382.17 | 15345.0 |
| 2025-03-13 09:00:00 | MSFT | Stock | 382.88 | 384.39 | 382.8 | 383.21 | 16581.0 |
| 2025-03-13 09:30:00 | MSFT | Stock | 383.25 | 385.32 | 380.08 | 380.48 | 1709476.0 |
| 2025-03-13 10:00:00 | MSFT | Stock | 380.52 | 384.1 | 380.1 | 382.475 | 873835.0 |
| 2025-03-13 10:30:00 | MSFT | Stock | 382.51 | 383.07 | 380.97 | 382.06 | 591434.0 |
| 2025-03-13 11:00:00 | MSFT | Stock | 382.06 | 382.84 | 379.65 | 379.815 | 791600.0 |
| 2025-03-13 11:30:00 | MSFT | Stock | 379.775 | 380.53 | 378.85 | 379.3375 | 624165.0 |
| 2025-03-13 12:00:00 | MSFT | Stock | 379.37 | 380.32 | 378.68 | 379.2869 | 815015.0 |
| 2025-03-13 12:30:00 | MSFT | Stock | 379.275 | 380.72 | 378.18 | 379.62 | 680062.0 |
> showing 50 of 101,367 rows — these rows as CSV