PREVIEW / stock_30min / 2025-03-26
file: by_date/stock_30min/2025/2025-03-26.parquet size: 2.1 MB rows: 101,253 symbols: 472
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-26 04:00:00 | AAPL | Stock | 223.94 | 224.4 | 223.53 | 223.86 | 9991.0 |
| 2025-03-26 04:30:00 | AAPL | Stock | 223.87 | 223.97 | 223.83 | 223.84 | 580.0 |
| 2025-03-26 05:00:00 | AAPL | Stock | 223.85 | 224.05 | 223.84 | 223.84 | 2606.0 |
| 2025-03-26 05:30:00 | AAPL | Stock | 223.81 | 223.94 | 223.7 | 223.7 | 1515.0 |
| 2025-03-26 06:00:00 | AAPL | Stock | 223.7 | 223.86 | 223.7 | 223.86 | 2065.0 |
| 2025-03-26 06:30:00 | AAPL | Stock | 223.87 | 224.26 | 223.87 | 224.26 | 2183.0 |
| 2025-03-26 07:00:00 | AAPL | Stock | 224.24 | 224.29 | 224.1 | 224.29 | 4002.0 |
| 2025-03-26 07:30:00 | AAPL | Stock | 224.29 | 224.42 | 224.21 | 224.27 | 6152.0 |
| 2025-03-26 08:00:00 | AAPL | Stock | 224.2 | 224.4291 | 223.85 | 224.26 | 39540.0 |
| 2025-03-26 08:30:00 | AAPL | Stock | 224.32 | 224.55 | 224.06 | 224.53 | 17302.0 |
| 2025-03-26 09:00:00 | AAPL | Stock | 224.5 | 224.5 | 223.37 | 223.45 | 77308.0 |
| 2025-03-26 09:30:00 | AAPL | Stock | 223.51 | 225.02 | 223.31 | 224.3 | 3747727.0 |
| 2025-03-26 10:00:00 | AAPL | Stock | 224.315 | 224.3658 | 222.84 | 224.0745 | 2214174.0 |
| 2025-03-26 10:30:00 | AAPL | Stock | 224.085 | 224.1 | 223.11 | 223.65 | 1511892.0 |
| 2025-03-26 11:00:00 | AAPL | Stock | 223.645 | 224.3156 | 223.5 | 223.72 | 965960.0 |
| 2025-03-26 11:30:00 | AAPL | Stock | 223.7201 | 223.9 | 222.12 | 222.695 | 1317118.0 |
| 2025-03-26 12:00:00 | AAPL | Stock | 222.69 | 223.75 | 222.51 | 223.675 | 1047091.0 |
| 2025-03-26 12:30:00 | AAPL | Stock | 223.675 | 223.79 | 222.67 | 222.8054 | 892345.0 |
| 2025-03-26 13:00:00 | AAPL | Stock | 222.8 | 222.91 | 221.63 | 222.08 | 1251459.0 |
| 2025-03-26 13:30:00 | AAPL | Stock | 222.06 | 222.22 | 221.4001 | 221.6697 | 907781.0 |
| 2025-03-26 14:00:00 | AAPL | Stock | 221.68 | 222.09 | 221.62 | 221.835 | 732676.0 |
| 2025-03-26 14:30:00 | AAPL | Stock | 221.82 | 221.89 | 221.3 | 221.575 | 784883.0 |
| 2025-03-26 15:00:00 | AAPL | Stock | 221.57 | 221.68 | 220.6 | 220.6 | 1420062.0 |
| 2025-03-26 15:30:00 | AAPL | Stock | 220.615 | 221.89 | 220.47 | 221.39 | 2967672.0 |
| 2025-03-26 16:00:00 | AAPL | Stock | 221.53 | 221.53 | 221.0358 | 221.3515 | 6200875.0 |
| 2025-03-26 16:30:00 | AAPL | Stock | 221.3 | 221.53 | 221.26 | 221.31 | 32865.0 |
| 2025-03-26 17:00:00 | AAPL | Stock | 221.3217 | 221.49 | 221.32 | 221.3927 | 5060.0 |
| 2025-03-26 17:30:00 | AAPL | Stock | 221.38 | 221.5 | 221.0902 | 221.0902 | 4265.0 |
| 2025-03-26 18:00:00 | AAPL | Stock | 221.14 | 221.296 | 220.6 | 220.88 | 14566.0 |
| 2025-03-26 18:30:00 | AAPL | Stock | 220.88 | 221.14 | 220.65 | 220.6957 | 8460.0 |
| 2025-03-26 19:00:00 | AAPL | Stock | 220.65 | 221.08 | 220.65 | 220.96 | 14657.0 |
| 2025-03-26 19:30:00 | AAPL | Stock | 220.7562 | 221.53 | 220.7562 | 221.53 | 14355.0 |
| 2025-03-26 04:00:00 | MSFT | Stock | 394.8 | 394.8 | 394.36 | 394.71 | 1137.0 |
| 2025-03-26 04:30:00 | MSFT | Stock | 395.2 | 395.2 | 395.15 | 395.15 | 509.0 |
| 2025-03-26 05:00:00 | MSFT | Stock | 395.19 | 395.19 | 395.01 | 395.01 | 200.0 |
| 2025-03-26 05:30:00 | MSFT | Stock | 394.83 | 395.22 | 394.83 | 394.88 | 1295.0 |
| 2025-03-26 06:00:00 | MSFT | Stock | 394.65 | 394.65 | 394.46 | 394.49 | 1603.0 |
| 2025-03-26 06:30:00 | MSFT | Stock | 394.71 | 394.78 | 394.6 | 394.78 | 994.0 |
| 2025-03-26 07:00:00 | MSFT | Stock | 394.88 | 394.88 | 394.77 | 394.78 | 2243.0 |
| 2025-03-26 07:30:00 | MSFT | Stock | 394.83 | 395.23 | 394.6 | 394.6 | 2471.0 |
| 2025-03-26 08:00:00 | MSFT | Stock | 394.64 | 395.2398 | 394.5438 | 394.7239 | 5967.0 |
| 2025-03-26 08:30:00 | MSFT | Stock | 394.88 | 395.43 | 394.71 | 395.3023 | 2760.0 |
| 2025-03-26 09:00:00 | MSFT | Stock | 395.46 | 395.7741 | 394.76 | 394.76 | 4165.0 |
| 2025-03-26 09:30:00 | MSFT | Stock | 395.0 | 395.31 | 392.19 | 392.41 | 1179306.0 |
| 2025-03-26 10:00:00 | MSFT | Stock | 392.385 | 393.62 | 392.18 | 392.98 | 690942.0 |
| 2025-03-26 10:30:00 | MSFT | Stock | 392.94 | 394.55 | 392.57 | 394.54 | 468441.0 |
| 2025-03-26 11:00:00 | MSFT | Stock | 394.51 | 394.61 | 393.61 | 393.825 | 323618.0 |
| 2025-03-26 11:30:00 | MSFT | Stock | 393.81 | 394.185 | 392.23 | 392.62 | 370371.0 |
| 2025-03-26 12:00:00 | MSFT | Stock | 392.64 | 392.84 | 392.13 | 392.81 | 358093.0 |
| 2025-03-26 12:30:00 | MSFT | Stock | 392.78 | 393.124 | 391.62 | 391.86 | 372594.0 |
> showing 50 of 101,253 rows — these rows as CSV