PREVIEW / stock_30min / 2025-03-25
file: by_date/stock_30min/2025/2025-03-25.parquet size: 2.1 MB rows: 101,551 symbols: 482
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-25 04:00:00 | AAPL | Stock | 220.5 | 220.86 | 220.27 | 220.48 | 6442.0 |
| 2025-03-25 04:30:00 | AAPL | Stock | 220.32 | 220.42 | 220.1 | 220.21 | 4046.0 |
| 2025-03-25 05:00:00 | AAPL | Stock | 220.21 | 220.22 | 220.05 | 220.15 | 20272.0 |
| 2025-03-25 05:30:00 | AAPL | Stock | 220.12 | 220.47 | 220.12 | 220.39 | 2993.0 |
| 2025-03-25 06:00:00 | AAPL | Stock | 220.46 | 220.63 | 220.28 | 220.42 | 6334.0 |
| 2025-03-25 06:30:00 | AAPL | Stock | 220.5 | 220.99 | 220.5 | 220.74 | 6684.0 |
| 2025-03-25 07:00:00 | AAPL | Stock | 220.75 | 220.83 | 220.6 | 220.75 | 16334.0 |
| 2025-03-25 07:30:00 | AAPL | Stock | 220.78 | 220.89 | 220.72 | 220.84 | 7623.0 |
| 2025-03-25 08:00:00 | AAPL | Stock | 220.75 | 221.23 | 220.1204 | 221.2 | 51285.0 |
| 2025-03-25 08:30:00 | AAPL | Stock | 221.24 | 221.61 | 221.2 | 221.3 | 37137.0 |
| 2025-03-25 09:00:00 | AAPL | Stock | 221.3034 | 221.44 | 220.51 | 220.6 | 78231.0 |
| 2025-03-25 09:30:00 | AAPL | Stock | 220.77 | 222.73 | 220.08 | 222.66 | 3570585.0 |
| 2025-03-25 10:00:00 | AAPL | Stock | 222.66 | 223.39 | 222.0675 | 223.37 | 2534010.0 |
| 2025-03-25 10:30:00 | AAPL | Stock | 223.38 | 223.75 | 222.3 | 223.678 | 1954394.0 |
| 2025-03-25 11:00:00 | AAPL | Stock | 223.685 | 223.9 | 222.95 | 223.53 | 1115797.0 |
| 2025-03-25 11:30:00 | AAPL | Stock | 223.54 | 223.7 | 223.12 | 223.5369 | 890933.0 |
| 2025-03-25 12:00:00 | AAPL | Stock | 223.54 | 223.55 | 223.01 | 223.11 | 738670.0 |
| 2025-03-25 12:30:00 | AAPL | Stock | 223.1 | 223.31 | 222.85 | 223.1 | 825687.0 |
| 2025-03-25 13:00:00 | AAPL | Stock | 223.11 | 223.635 | 222.8 | 222.81 | 940205.0 |
| 2025-03-25 13:30:00 | AAPL | Stock | 222.8499 | 223.09 | 222.6 | 222.985 | 842153.0 |
| 2025-03-25 14:00:00 | AAPL | Stock | 222.97 | 223.949 | 222.95 | 223.49 | 1173285.0 |
| 2025-03-25 14:30:00 | AAPL | Stock | 223.5 | 223.71 | 222.8 | 222.8029 | 1200842.0 |
| 2025-03-25 15:00:00 | AAPL | Stock | 222.8 | 223.61 | 222.785 | 223.39 | 1292438.0 |
| 2025-03-25 15:30:00 | AAPL | Stock | 223.39 | 224.1 | 223.29 | 223.73 | 2646363.0 |
| 2025-03-25 16:00:00 | AAPL | Stock | 223.75 | 223.85 | 223.4706 | 223.74 | 6525056.0 |
| 2025-03-25 16:30:00 | AAPL | Stock | 223.73 | 223.88 | 223.5596 | 223.74 | 13493.0 |
| 2025-03-25 17:00:00 | AAPL | Stock | 223.75 | 223.88 | 223.75 | 223.87 | 47975.0 |
| 2025-03-25 17:30:00 | AAPL | Stock | 223.8008 | 223.98 | 223.8008 | 223.9005 | 3550.0 |
| 2025-03-25 18:00:00 | AAPL | Stock | 223.9741 | 224.1 | 223.8 | 224.0 | 14637.0 |
| 2025-03-25 18:30:00 | AAPL | Stock | 224.0975 | 224.24 | 223.94 | 224.0116 | 6975.0 |
| 2025-03-25 19:00:00 | AAPL | Stock | 224.0899 | 224.1 | 224.0 | 224.06 | 2100.0 |
| 2025-03-25 19:30:00 | AAPL | Stock | 224.05 | 224.33 | 224.05 | 224.18 | 4733.0 |
| 2025-03-25 04:00:00 | MSFT | Stock | 392.91 | 392.91 | 392.21 | 392.76 | 2160.0 |
| 2025-03-25 04:30:00 | MSFT | Stock | 392.24 | 392.91 | 392.22 | 392.57 | 3187.0 |
| 2025-03-25 05:00:00 | MSFT | Stock | 392.47 | 392.8 | 392.4 | 392.8 | 723.0 |
| 2025-03-25 05:30:00 | MSFT | Stock | 392.84 | 393.2 | 392.84 | 393.2 | 1136.0 |
| 2025-03-25 06:00:00 | MSFT | Stock | 393.01 | 393.35 | 393.0 | 393.35 | 512.0 |
| 2025-03-25 06:30:00 | MSFT | Stock | 393.43 | 393.54 | 393.43 | 393.49 | 650.0 |
| 2025-03-25 07:00:00 | MSFT | Stock | 393.47 | 393.77 | 393.43 | 393.77 | 4543.0 |
| 2025-03-25 07:30:00 | MSFT | Stock | 393.73 | 394.41 | 393.73 | 394.2 | 4203.0 |
| 2025-03-25 08:00:00 | MSFT | Stock | 393.64 | 394.51 | 392.99 | 394.5 | 14503.0 |
| 2025-03-25 08:30:00 | MSFT | Stock | 394.53 | 394.8 | 394.01 | 394.05 | 10020.0 |
| 2025-03-25 09:00:00 | MSFT | Stock | 394.0201 | 394.53 | 393.29 | 393.54 | 15404.0 |
| 2025-03-25 09:30:00 | MSFT | Stock | 393.7 | 395.37 | 392.64 | 394.65 | 1287373.0 |
| 2025-03-25 10:00:00 | MSFT | Stock | 394.55 | 395.8 | 393.7001 | 394.9935 | 1000067.0 |
| 2025-03-25 10:30:00 | MSFT | Stock | 394.93 | 395.7301 | 394.143 | 395.56 | 515789.0 |
| 2025-03-25 11:00:00 | MSFT | Stock | 395.56 | 396.36 | 395.19 | 395.42 | 473779.0 |
| 2025-03-25 11:30:00 | MSFT | Stock | 395.435 | 395.46 | 394.06 | 394.355 | 355817.0 |
| 2025-03-25 12:00:00 | MSFT | Stock | 394.37 | 394.8799 | 394.1001 | 394.405 | 350725.0 |
| 2025-03-25 12:30:00 | MSFT | Stock | 394.38 | 394.465 | 393.895 | 394.38 | 350864.0 |
> showing 50 of 101,551 rows — these rows as CSV