PREVIEW / stock_30min / 2025-05-20
file: by_date/stock_30min/2025/2025-05-20.parquet size: 2.1 MB rows: 102,198 symbols: 411
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-20 04:00:00 | AAPL | Stock | 208.88 | 208.88 | 207.63 | 207.91 | 9323.0 |
| 2025-05-20 04:30:00 | AAPL | Stock | 207.81 | 208.0 | 207.81 | 207.92 | 5089.0 |
| 2025-05-20 05:00:00 | AAPL | Stock | 207.91 | 208.03 | 207.86 | 207.9 | 10152.0 |
| 2025-05-20 05:30:00 | AAPL | Stock | 207.98 | 208.0 | 207.9 | 207.98 | 2255.0 |
| 2025-05-20 06:00:00 | AAPL | Stock | 207.89 | 208.15 | 207.85 | 208.0 | 7564.0 |
| 2025-05-20 06:30:00 | AAPL | Stock | 208.05 | 208.13 | 207.94 | 208.13 | 1976.0 |
| 2025-05-20 07:00:00 | AAPL | Stock | 208.16 | 208.3 | 207.84 | 208.05 | 17742.0 |
| 2025-05-20 07:30:00 | AAPL | Stock | 208.09 | 208.2 | 207.94 | 208.15 | 9868.0 |
| 2025-05-20 08:00:00 | AAPL | Stock | 208.15 | 208.5 | 207.7 | 207.7 | 64222.0 |
| 2025-05-20 08:30:00 | AAPL | Stock | 207.714 | 207.72 | 207.22 | 207.65 | 60911.0 |
| 2025-05-20 09:00:00 | AAPL | Stock | 207.7 | 207.9646 | 207.1 | 207.84 | 65435.0 |
| 2025-05-20 09:30:00 | AAPL | Stock | 207.67 | 208.3 | 206.47 | 207.51 | 3997582.0 |
| 2025-05-20 10:00:00 | AAPL | Stock | 207.48 | 208.145 | 207.09 | 207.845 | 1818612.0 |
| 2025-05-20 10:30:00 | AAPL | Stock | 207.83 | 208.47 | 207.5359 | 207.59 | 1582435.0 |
| 2025-05-20 11:00:00 | AAPL | Stock | 207.58 | 207.79 | 207.22 | 207.6343 | 1290887.0 |
| 2025-05-20 11:30:00 | AAPL | Stock | 207.65 | 208.43 | 207.0 | 207.915 | 2047679.0 |
| 2025-05-20 12:00:00 | AAPL | Stock | 207.91 | 208.08 | 207.4 | 207.81 | 1130390.0 |
| 2025-05-20 12:30:00 | AAPL | Stock | 207.81 | 208.02 | 207.58 | 207.61 | 888716.0 |
| 2025-05-20 13:00:00 | AAPL | Stock | 207.61 | 207.74 | 207.11 | 207.38 | 1248274.0 |
| 2025-05-20 13:30:00 | AAPL | Stock | 207.37 | 207.405 | 206.685 | 206.8486 | 1302915.0 |
| 2025-05-20 14:00:00 | AAPL | Stock | 206.84 | 206.855 | 205.47 | 205.59 | 1911099.0 |
| 2025-05-20 14:30:00 | AAPL | Stock | 205.58 | 205.72 | 205.21 | 205.33 | 1875076.0 |
| 2025-05-20 15:00:00 | AAPL | Stock | 205.35 | 206.41 | 205.03 | 206.26 | 1767723.0 |
| 2025-05-20 15:30:00 | AAPL | Stock | 206.27 | 206.94 | 205.925 | 206.87 | 2801908.0 |
| 2025-05-20 16:00:00 | AAPL | Stock | 206.86 | 206.9 | 206.45 | 206.749 | 5551599.0 |
| 2025-05-20 16:30:00 | AAPL | Stock | 206.75 | 206.86 | 206.45 | 206.4617 | 18793.0 |
| 2025-05-20 17:00:00 | AAPL | Stock | 206.59 | 206.59 | 206.1 | 206.5 | 11657.0 |
| 2025-05-20 17:30:00 | AAPL | Stock | 206.5096 | 206.51 | 206.44 | 206.47 | 7507.0 |
| 2025-05-20 18:00:00 | AAPL | Stock | 206.47 | 206.55 | 206.0 | 206.15 | 10072.0 |
| 2025-05-20 18:30:00 | AAPL | Stock | 206.1003 | 206.86 | 206.1003 | 206.39 | 8925.0 |
| 2025-05-20 19:00:00 | AAPL | Stock | 206.45 | 206.6915 | 206.23 | 206.46 | 9639.0 |
| 2025-05-20 19:30:00 | AAPL | Stock | 206.56 | 206.7 | 206.08 | 206.6237 | 13482.0 |
| 2025-05-20 04:00:00 | MSFT | Stock | 456.94 | 457.0 | 456.43 | 457.0 | 3010.0 |
| 2025-05-20 04:30:00 | MSFT | Stock | 456.75 | 456.87 | 456.75 | 456.87 | 200.0 |
| 2025-05-20 05:00:00 | MSFT | Stock | 456.61 | 456.89 | 456.61 | 456.88 | 1432.0 |
| 2025-05-20 05:30:00 | MSFT | Stock | 456.79 | 456.79 | 456.67 | 456.7 | 624.0 |
| 2025-05-20 06:00:00 | MSFT | Stock | 457.17 | 457.21 | 457.16 | 457.16 | 1254.0 |
| 2025-05-20 06:30:00 | MSFT | Stock | 456.79 | 456.79 | 456.74 | 456.74 | 314.0 |
| 2025-05-20 07:00:00 | MSFT | Stock | 457.48 | 458.85 | 457.48 | 458.67 | 6354.0 |
| 2025-05-20 07:30:00 | MSFT | Stock | 458.68 | 458.68 | 457.99 | 458.49 | 4244.0 |
| 2025-05-20 08:00:00 | MSFT | Stock | 458.3 | 458.87 | 455.76 | 457.0 | 19149.0 |
| 2025-05-20 08:30:00 | MSFT | Stock | 457.4 | 457.5 | 456.9 | 457.24 | 6516.0 |
| 2025-05-20 09:00:00 | MSFT | Stock | 457.4 | 458.23 | 454.7204 | 455.33 | 38429.0 |
| 2025-05-20 09:30:00 | MSFT | Stock | 455.44 | 457.06 | 454.35 | 455.03 | 1172931.0 |
| 2025-05-20 10:00:00 | MSFT | Stock | 455.06 | 455.6335 | 454.3201 | 455.51 | 514130.0 |
| 2025-05-20 10:30:00 | MSFT | Stock | 455.44 | 456.35 | 455.085 | 455.5789 | 359772.0 |
| 2025-05-20 11:00:00 | MSFT | Stock | 455.525 | 456.73 | 455.235 | 456.24 | 392127.0 |
| 2025-05-20 11:30:00 | MSFT | Stock | 456.24 | 456.39 | 455.6 | 455.99 | 276242.0 |
| 2025-05-20 12:00:00 | MSFT | Stock | 455.985 | 456.68 | 455.7401 | 456.59 | 264937.0 |
| 2025-05-20 12:30:00 | MSFT | Stock | 456.59 | 457.28 | 456.59 | 456.81 | 362692.0 |
> showing 50 of 102,198 rows — these rows as CSV