PREVIEW / stock_30min / 2025-05-16
file: by_date/stock_30min/2025/2025-05-16.parquet size: 2.2 MB rows: 105,257 symbols: 414
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-16 04:00:00 | AAPL | Stock | 211.75 | 212.0 | 211.73 | 211.81 | 8271.0 |
| 2025-05-16 04:30:00 | AAPL | Stock | 211.79 | 212.05 | 211.77 | 211.9 | 13207.0 |
| 2025-05-16 05:00:00 | AAPL | Stock | 212.0 | 212.0 | 211.75 | 211.93 | 4264.0 |
| 2025-05-16 05:30:00 | AAPL | Stock | 211.85 | 211.9 | 211.72 | 211.87 | 4656.0 |
| 2025-05-16 06:00:00 | AAPL | Stock | 211.76 | 211.76 | 211.0 | 211.68 | 15574.0 |
| 2025-05-16 06:30:00 | AAPL | Stock | 211.78 | 211.78 | 211.69 | 211.7 | 1184.0 |
| 2025-05-16 07:00:00 | AAPL | Stock | 211.7 | 211.97 | 211.52 | 211.78 | 9457.0 |
| 2025-05-16 07:30:00 | AAPL | Stock | 211.8 | 211.8 | 211.66 | 211.79 | 2675.0 |
| 2025-05-16 08:00:00 | AAPL | Stock | 211.75 | 212.0496 | 211.13 | 211.8787 | 66956.0 |
| 2025-05-16 08:30:00 | AAPL | Stock | 211.88 | 211.926 | 211.55 | 211.88 | 59176.0 |
| 2025-05-16 09:00:00 | AAPL | Stock | 211.88 | 212.8 | 211.2 | 212.42 | 469606.0 |
| 2025-05-16 09:30:00 | AAPL | Stock | 212.36 | 212.57 | 211.01 | 211.75 | 6410503.0 |
| 2025-05-16 10:00:00 | AAPL | Stock | 211.72 | 211.93 | 210.56 | 210.6 | 2273170.0 |
| 2025-05-16 10:30:00 | AAPL | Stock | 210.59 | 210.66 | 209.77 | 210.2301 | 2048844.0 |
| 2025-05-16 11:00:00 | AAPL | Stock | 210.24 | 210.49 | 209.905 | 210.08 | 1328279.0 |
| 2025-05-16 11:30:00 | AAPL | Stock | 210.09 | 210.92 | 210.09 | 210.67 | 1520075.0 |
| 2025-05-16 12:00:00 | AAPL | Stock | 210.67 | 211.1499 | 210.45 | 210.955 | 1132702.0 |
| 2025-05-16 12:30:00 | AAPL | Stock | 210.96 | 211.17 | 210.7 | 210.911 | 854014.0 |
| 2025-05-16 13:00:00 | AAPL | Stock | 210.91 | 211.42 | 210.76 | 211.11 | 1036865.0 |
| 2025-05-16 13:30:00 | AAPL | Stock | 211.11 | 211.2961 | 210.73 | 210.975 | 810932.0 |
| 2025-05-16 14:00:00 | AAPL | Stock | 210.9764 | 211.74 | 210.925 | 211.62 | 1128421.0 |
| 2025-05-16 14:30:00 | AAPL | Stock | 211.63 | 211.8998 | 211.43 | 211.525 | 1161474.0 |
| 2025-05-16 15:00:00 | AAPL | Stock | 211.52 | 211.93 | 211.4725 | 211.71 | 1258321.0 |
| 2025-05-16 15:30:00 | AAPL | Stock | 211.71 | 211.73 | 211.11 | 211.19 | 2596777.0 |
| 2025-05-16 16:00:00 | AAPL | Stock | 211.26 | 211.41 | 210.86 | 211.03 | 9188622.0 |
| 2025-05-16 16:30:00 | AAPL | Stock | 211.1 | 211.1316 | 209.92 | 210.3993 | 38011.0 |
| 2025-05-16 17:00:00 | AAPL | Stock | 210.29 | 211.26 | 210.08 | 210.18 | 25634.0 |
| 2025-05-16 17:30:00 | AAPL | Stock | 210.18 | 210.18 | 209.33 | 209.4 | 31147.0 |
| 2025-05-16 18:00:00 | AAPL | Stock | 209.48 | 209.69 | 209.05 | 209.05 | 27345.0 |
| 2025-05-16 18:30:00 | AAPL | Stock | 209.0978 | 209.0978 | 207.8 | 207.94 | 64531.0 |
| 2025-05-16 19:00:00 | AAPL | Stock | 207.97 | 208.9373 | 207.89 | 208.21 | 33488.0 |
| 2025-05-16 19:30:00 | AAPL | Stock | 208.22 | 208.35 | 207.8 | 207.93 | 42398.0 |
| 2025-05-16 04:00:00 | MSFT | Stock | 452.41 | 453.28 | 446.31 | 452.66 | 3915.0 |
| 2025-05-16 04:30:00 | MSFT | Stock | 452.56 | 452.86 | 452.56 | 452.86 | 532.0 |
| 2025-05-16 05:30:00 | MSFT | Stock | 452.61 | 453.39 | 452.5 | 453.39 | 6798.0 |
| 2025-05-16 06:00:00 | MSFT | Stock | 452.93 | 453.13 | 452.7 | 453.13 | 974.0 |
| 2025-05-16 06:30:00 | MSFT | Stock | 453.1 | 453.1 | 453.1 | 453.1 | 100.0 |
| 2025-05-16 07:00:00 | MSFT | Stock | 452.98 | 453.13 | 452.63 | 453.0 | 4449.0 |
| 2025-05-16 07:30:00 | MSFT | Stock | 453.01 | 453.01 | 452.88 | 452.96 | 784.0 |
| 2025-05-16 08:00:00 | MSFT | Stock | 453.0 | 453.64 | 451.7 | 453.16 | 11652.0 |
| 2025-05-16 08:30:00 | MSFT | Stock | 453.2 | 453.2 | 451.5 | 451.61 | 11792.0 |
| 2025-05-16 09:00:00 | MSFT | Stock | 451.2528 | 454.0 | 450.25 | 452.15 | 123465.0 |
| 2025-05-16 09:30:00 | MSFT | Stock | 452.05 | 453.0 | 449.35 | 450.065 | 3221846.0 |
| 2025-05-16 10:00:00 | MSFT | Stock | 450.02 | 451.455 | 449.17 | 449.62 | 937729.0 |
| 2025-05-16 10:30:00 | MSFT | Stock | 449.58 | 450.39 | 448.96 | 449.97 | 658902.0 |
| 2025-05-16 11:00:00 | MSFT | Stock | 449.96 | 450.2 | 448.73 | 449.73 | 456832.0 |
| 2025-05-16 11:30:00 | MSFT | Stock | 449.75 | 450.08 | 449.37 | 449.81 | 384788.0 |
| 2025-05-16 12:00:00 | MSFT | Stock | 449.82 | 450.8 | 449.71 | 450.75 | 727876.0 |
| 2025-05-16 12:30:00 | MSFT | Stock | 450.715 | 450.88 | 449.97 | 450.185 | 439771.0 |
| 2025-05-16 13:00:00 | MSFT | Stock | 450.14 | 450.62 | 449.8 | 450.5375 | 376776.0 |
> showing 50 of 105,257 rows — these rows as CSV