PREVIEW / stock_30min / 2025-03-28
file: by_date/stock_30min/2025/2025-03-28.parquet size: 2.1 MB rows: 100,445 symbols: 480
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-28 04:00:00 | AAPL | Stock | 222.0 | 222.7 | 222.0 | 222.26 | 16628.0 |
| 2025-03-28 04:30:00 | AAPL | Stock | 222.26 | 222.38 | 222.02 | 222.25 | 4809.0 |
| 2025-03-28 05:00:00 | AAPL | Stock | 222.12 | 222.18 | 222.07 | 222.11 | 1056.0 |
| 2025-03-28 05:30:00 | AAPL | Stock | 222.14 | 222.29 | 222.0 | 222.03 | 7652.0 |
| 2025-03-28 06:00:00 | AAPL | Stock | 222.1 | 222.49 | 222.1 | 222.43 | 3802.0 |
| 2025-03-28 06:30:00 | AAPL | Stock | 222.28 | 222.6 | 222.28 | 222.39 | 9626.0 |
| 2025-03-28 07:00:00 | AAPL | Stock | 222.39 | 222.45 | 222.04 | 222.2 | 7722.0 |
| 2025-03-28 07:30:00 | AAPL | Stock | 222.13 | 222.23 | 221.99 | 222.2 | 7960.0 |
| 2025-03-28 08:00:00 | AAPL | Stock | 222.05 | 223.64 | 221.96 | 222.15 | 29399.0 |
| 2025-03-28 08:30:00 | AAPL | Stock | 222.04 | 222.15 | 221.58 | 221.92 | 41095.0 |
| 2025-03-28 09:00:00 | AAPL | Stock | 221.82 | 222.3999 | 221.19 | 221.66 | 99611.0 |
| 2025-03-28 09:30:00 | AAPL | Stock | 221.73 | 223.81 | 220.99 | 223.38 | 3803770.0 |
| 2025-03-28 10:00:00 | AAPL | Stock | 223.35 | 223.73 | 219.69 | 219.91 | 2743705.0 |
| 2025-03-28 10:30:00 | AAPL | Stock | 219.89 | 220.65 | 219.62 | 220.6 | 1967612.0 |
| 2025-03-28 11:00:00 | AAPL | Stock | 220.595 | 220.6 | 219.17 | 219.98 | 1624918.0 |
| 2025-03-28 11:30:00 | AAPL | Stock | 219.91 | 220.22 | 219.288 | 219.53 | 1123668.0 |
| 2025-03-28 12:00:00 | AAPL | Stock | 219.51 | 219.83 | 218.35 | 218.69 | 1158299.0 |
| 2025-03-28 12:30:00 | AAPL | Stock | 218.67 | 219.12 | 218.55 | 218.6 | 842723.0 |
| 2025-03-28 13:00:00 | AAPL | Stock | 218.59 | 219.1 | 218.21 | 218.5 | 1109065.0 |
| 2025-03-28 13:30:00 | AAPL | Stock | 218.5 | 218.83 | 218.18 | 218.76 | 801425.0 |
| 2025-03-28 14:00:00 | AAPL | Stock | 218.74 | 219.1665 | 218.48 | 219.05 | 852383.0 |
| 2025-03-28 14:30:00 | AAPL | Stock | 219.04 | 219.16 | 218.4031 | 218.51 | 925173.0 |
| 2025-03-28 15:00:00 | AAPL | Stock | 218.49 | 218.6727 | 218.1104 | 218.5 | 1273634.0 |
| 2025-03-28 15:30:00 | AAPL | Stock | 218.5 | 219.04 | 217.68 | 217.85 | 4118232.0 |
| 2025-03-28 16:00:00 | AAPL | Stock | 217.84 | 218.19 | 217.45 | 217.58 | 7033693.0 |
| 2025-03-28 16:30:00 | AAPL | Stock | 217.6 | 223.85 | 217.4 | 217.42 | 115305.0 |
| 2025-03-28 17:00:00 | AAPL | Stock | 217.42 | 217.58 | 217.41 | 217.47 | 9591.0 |
| 2025-03-28 17:30:00 | AAPL | Stock | 217.32 | 217.59 | 217.32 | 217.59 | 4821.0 |
| 2025-03-28 18:00:00 | AAPL | Stock | 217.5 | 217.5189 | 217.4 | 217.44 | 10648.0 |
| 2025-03-28 18:30:00 | AAPL | Stock | 217.5 | 217.5365 | 217.44 | 217.4508 | 5871.0 |
| 2025-03-28 19:00:00 | AAPL | Stock | 217.45 | 217.5 | 217.4025 | 217.5 | 1700.0 |
| 2025-03-28 19:30:00 | AAPL | Stock | 217.4 | 217.54 | 217.22 | 217.22 | 10954.0 |
| 2025-03-28 04:00:00 | MSFT | Stock | 388.7 | 388.7 | 388.39 | 388.39 | 470.0 |
| 2025-03-28 04:30:00 | MSFT | Stock | 388.48 | 388.79 | 388.48 | 388.62 | 407.0 |
| 2025-03-28 05:00:00 | MSFT | Stock | 388.73 | 388.73 | 388.73 | 388.73 | 110.0 |
| 2025-03-28 05:30:00 | MSFT | Stock | 388.89 | 388.89 | 388.5 | 388.5 | 350.0 |
| 2025-03-28 06:00:00 | MSFT | Stock | 389.06 | 389.08 | 389.06 | 389.08 | 251.0 |
| 2025-03-28 06:30:00 | MSFT | Stock | 389.28 | 389.3 | 389.19 | 389.19 | 300.0 |
| 2025-03-28 07:00:00 | MSFT | Stock | 389.18 | 389.19 | 388.73 | 388.74 | 1380.0 |
| 2025-03-28 07:30:00 | MSFT | Stock | 388.7 | 388.7 | 388.55 | 388.55 | 505.0 |
| 2025-03-28 08:00:00 | MSFT | Stock | 389.18 | 389.25 | 388.48 | 388.7 | 3160.0 |
| 2025-03-28 08:30:00 | MSFT | Stock | 388.55 | 388.55 | 387.3808 | 387.8 | 16710.0 |
| 2025-03-28 09:00:00 | MSFT | Stock | 387.7 | 389.29 | 387.1 | 388.28 | 27153.0 |
| 2025-03-28 09:30:00 | MSFT | Stock | 388.18 | 389.13 | 386.07 | 387.675 | 1050092.0 |
| 2025-03-28 10:00:00 | MSFT | Stock | 387.62 | 388.29 | 384.17 | 384.325 | 779123.0 |
| 2025-03-28 10:30:00 | MSFT | Stock | 384.33 | 384.8 | 382.09 | 382.64 | 658382.0 |
| 2025-03-28 11:00:00 | MSFT | Stock | 382.7 | 383.07 | 381.47 | 382.62 | 630471.0 |
| 2025-03-28 11:30:00 | MSFT | Stock | 382.58 | 383.045 | 381.51 | 381.59 | 431530.0 |
| 2025-03-28 12:00:00 | MSFT | Stock | 381.55 | 382.07 | 380.55 | 380.6648 | 421838.0 |
| 2025-03-28 12:30:00 | MSFT | Stock | 380.615 | 381.1135 | 379.35 | 379.435 | 658029.0 |
> showing 50 of 100,445 rows — these rows as CSV