PREVIEW / stock_30min / 2025-10-30
file: by_date/stock_30min/2025/2025-10-30.parquet size: 2.3 MB rows: 110,507 symbols: 223
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-10-30 04:00:00 | AAPL | Stock | 271.05 | 272.39 | 270.0 | 271.5 | 21209.0 |
| 2025-10-30 04:30:00 | AAPL | Stock | 271.2 | 271.74 | 271.18 | 271.63 | 9654.0 |
| 2025-10-30 05:00:00 | AAPL | Stock | 271.69 | 271.81 | 271.23 | 271.38 | 6301.0 |
| 2025-10-30 05:30:00 | AAPL | Stock | 271.23 | 271.45 | 271.2 | 271.45 | 3431.0 |
| 2025-10-30 06:00:00 | AAPL | Stock | 271.39 | 271.56 | 271.17 | 271.17 | 7493.0 |
| 2025-10-30 06:30:00 | AAPL | Stock | 271.31 | 271.89 | 271.2 | 271.86 | 17118.0 |
| 2025-10-30 07:00:00 | AAPL | Stock | 271.75 | 271.9 | 271.3 | 271.71 | 32619.0 |
| 2025-10-30 07:30:00 | AAPL | Stock | 271.8 | 272.44 | 271.72 | 272.15 | 31005.0 |
| 2025-10-30 08:00:00 | AAPL | Stock | 271.52 | 273.0 | 270.3 | 271.54 | 274440.0 |
| 2025-10-30 08:30:00 | AAPL | Stock | 271.26 | 271.54 | 270.83 | 271.0325 | 98788.0 |
| 2025-10-30 09:00:00 | AAPL | Stock | 271.19 | 272.4 | 271.03 | 271.99 | 318261.0 |
| 2025-10-30 09:30:00 | AAPL | Stock | 271.99 | 274.14 | 270.61 | 271.06 | 5248240.0 |
| 2025-10-30 10:00:00 | AAPL | Stock | 271.1094 | 271.3799 | 268.99 | 269.09 | 2505433.0 |
| 2025-10-30 10:30:00 | AAPL | Stock | 269.09 | 269.75 | 268.48 | 268.9 | 1781434.0 |
| 2025-10-30 11:00:00 | AAPL | Stock | 268.9 | 271.17 | 268.89 | 270.79 | 2316183.0 |
| 2025-10-30 11:30:00 | AAPL | Stock | 270.78 | 271.748 | 270.2631 | 271.175 | 1732522.0 |
| 2025-10-30 12:00:00 | AAPL | Stock | 271.17 | 272.39 | 271.17 | 272.015 | 2269388.0 |
| 2025-10-30 12:30:00 | AAPL | Stock | 272.0 | 272.0678 | 271.25 | 271.3 | 1328310.0 |
| 2025-10-30 13:00:00 | AAPL | Stock | 271.31 | 271.99 | 271.04 | 271.95 | 1078509.0 |
| 2025-10-30 13:30:00 | AAPL | Stock | 271.95 | 272.07 | 271.28 | 272.0 | 1460253.0 |
| 2025-10-30 14:00:00 | AAPL | Stock | 272.0 | 272.3 | 271.47 | 271.76 | 2091196.0 |
| 2025-10-30 14:30:00 | AAPL | Stock | 271.76 | 272.008 | 271.18 | 271.37 | 1728218.0 |
| 2025-10-30 15:00:00 | AAPL | Stock | 271.35 | 271.63 | 270.995 | 271.34 | 2408091.0 |
| 2025-10-30 15:30:00 | AAPL | Stock | 271.34 | 271.86 | 271.05 | 271.38 | 5673552.0 |
| 2025-10-30 16:00:00 | AAPL | Stock | 271.43 | 273.7 | 271.17 | 272.8808 | 7405899.0 |
| 2025-10-30 16:30:00 | AAPL | Stock | 272.81 | 284.48 | 261.79 | 282.21 | 7675387.0 |
| 2025-10-30 17:00:00 | AAPL | Stock | 282.7369 | 285.0 | 281.36 | 282.19 | 1157360.0 |
| 2025-10-30 17:30:00 | AAPL | Stock | 282.41 | 282.4263 | 278.24 | 278.79 | 806457.0 |
| 2025-10-30 18:00:00 | AAPL | Stock | 278.83 | 281.0 | 278.5 | 278.88 | 370191.0 |
| 2025-10-30 18:30:00 | AAPL | Stock | 278.94 | 279.5 | 277.6 | 277.65 | 249315.0 |
| 2025-10-30 19:00:00 | AAPL | Stock | 277.6078 | 278.4 | 271.4 | 277.81 | 150593.0 |
| 2025-10-30 19:30:00 | AAPL | Stock | 277.8002 | 278.48 | 277.08 | 277.75 | 190091.0 |
| 2025-10-30 04:00:00 | MSFT | Stock | 524.3 | 528.39 | 522.5 | 528.0 | 54607.0 |
| 2025-10-30 04:30:00 | MSFT | Stock | 527.0 | 527.5 | 525.5 | 525.59 | 13621.0 |
| 2025-10-30 05:00:00 | MSFT | Stock | 525.98 | 526.98 | 523.99 | 524.42 | 15844.0 |
| 2025-10-30 05:30:00 | MSFT | Stock | 524.69 | 525.74 | 524.0 | 524.97 | 31287.0 |
| 2025-10-30 06:00:00 | MSFT | Stock | 524.88 | 530.26 | 524.5 | 527.91 | 43463.0 |
| 2025-10-30 06:30:00 | MSFT | Stock | 527.98 | 529.81 | 527.05 | 527.79 | 41978.0 |
| 2025-10-30 07:00:00 | MSFT | Stock | 527.7 | 531.79 | 526.72 | 531.5 | 73037.0 |
| 2025-10-30 07:30:00 | MSFT | Stock | 531.5 | 532.41 | 530.25 | 531.24 | 69704.0 |
| 2025-10-30 08:00:00 | MSFT | Stock | 531.0 | 532.4726 | 520.2 | 529.56 | 277400.0 |
| 2025-10-30 08:30:00 | MSFT | Stock | 529.51 | 530.59 | 527.8 | 528.15 | 155498.0 |
| 2025-10-30 09:00:00 | MSFT | Stock | 528.11 | 541.55 | 525.0 | 530.0 | 261707.0 |
| 2025-10-30 09:30:00 | MSFT | Stock | 530.24 | 534.97 | 527.87 | 527.88 | 5373193.0 |
| 2025-10-30 10:00:00 | MSFT | Stock | 528.005 | 531.59 | 524.11 | 528.39 | 2359281.0 |
| 2025-10-30 10:30:00 | MSFT | Stock | 528.5 | 530.99 | 528.01 | 528.14 | 1754943.0 |
| 2025-10-30 11:00:00 | MSFT | Stock | 528.22 | 528.3599 | 524.12 | 525.27 | 1597089.0 |
| 2025-10-30 11:30:00 | MSFT | Stock | 525.345 | 525.59 | 522.16 | 522.81 | 1479179.0 |
| 2025-10-30 12:00:00 | MSFT | Stock | 522.8 | 527.78 | 522.68 | 526.655 | 1675582.0 |
| 2025-10-30 12:30:00 | MSFT | Stock | 526.65 | 526.685 | 524.57 | 526.17 | 696687.0 |
> showing 50 of 110,507 rows — these rows as CSV