PREVIEW / stock_30min / 2025-06-26
file: by_date/stock_30min/2025/2025-06-26.parquet size: 2.2 MB rows: 105,366 symbols: 387
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-06-26 04:00:00 | AAPL | Stock | 202.0 | 202.7 | 202.0 | 202.56 | 17434.0 |
| 2025-06-26 04:30:00 | AAPL | Stock | 202.54 | 202.72 | 202.4 | 202.72 | 6495.0 |
| 2025-06-26 05:00:00 | AAPL | Stock | 202.71 | 202.71 | 202.32 | 202.32 | 5458.0 |
| 2025-06-26 05:30:00 | AAPL | Stock | 202.21 | 202.4 | 202.21 | 202.3 | 1975.0 |
| 2025-06-26 06:00:00 | AAPL | Stock | 202.38 | 202.4 | 200.39 | 201.57 | 82646.0 |
| 2025-06-26 06:30:00 | AAPL | Stock | 201.6 | 201.74 | 201.47 | 201.54 | 10955.0 |
| 2025-06-26 07:00:00 | AAPL | Stock | 201.54 | 201.64 | 201.07 | 201.3 | 32812.0 |
| 2025-06-26 07:30:00 | AAPL | Stock | 201.35 | 201.55 | 201.2 | 201.52 | 23018.0 |
| 2025-06-26 08:00:00 | AAPL | Stock | 201.58 | 202.7 | 200.87 | 201.4 | 120597.0 |
| 2025-06-26 08:30:00 | AAPL | Stock | 201.35 | 201.41 | 200.91 | 201.25 | 77520.0 |
| 2025-06-26 09:00:00 | AAPL | Stock | 201.2 | 201.8 | 201.2 | 201.31 | 76060.0 |
| 2025-06-26 09:30:00 | AAPL | Stock | 201.44 | 202.64 | 199.66 | 201.0 | 5698326.0 |
| 2025-06-26 10:00:00 | AAPL | Stock | 201.02 | 201.35 | 199.65 | 199.74 | 2918837.0 |
| 2025-06-26 10:30:00 | AAPL | Stock | 199.74 | 200.45 | 199.675 | 200.2799 | 2395215.0 |
| 2025-06-26 11:00:00 | AAPL | Stock | 200.3 | 200.51 | 199.62 | 199.69 | 2236859.0 |
| 2025-06-26 11:30:00 | AAPL | Stock | 199.69 | 200.105 | 199.46 | 200.0 | 1774033.0 |
| 2025-06-26 12:00:00 | AAPL | Stock | 199.995 | 200.79 | 199.97 | 200.1228 | 1764663.0 |
| 2025-06-26 12:30:00 | AAPL | Stock | 200.14 | 200.27 | 199.82 | 199.99 | 1578843.0 |
| 2025-06-26 13:00:00 | AAPL | Stock | 200.0 | 200.2658 | 199.635 | 200.24 | 1886987.0 |
| 2025-06-26 13:30:00 | AAPL | Stock | 200.25 | 200.71 | 199.97 | 200.63 | 1494126.0 |
| 2025-06-26 14:00:00 | AAPL | Stock | 200.64 | 201.36 | 200.43 | 200.98 | 2281568.0 |
| 2025-06-26 14:30:00 | AAPL | Stock | 200.99 | 201.145 | 200.85 | 201.0388 | 1442649.0 |
| 2025-06-26 15:00:00 | AAPL | Stock | 201.035 | 201.1787 | 200.75 | 201.175 | 1469213.0 |
| 2025-06-26 15:30:00 | AAPL | Stock | 201.1752 | 201.56 | 200.79 | 200.94 | 4645110.0 |
| 2025-06-26 16:00:00 | AAPL | Stock | 201.01 | 201.04 | 200.5 | 200.8057 | 6799918.0 |
| 2025-06-26 16:30:00 | AAPL | Stock | 200.81 | 201.0 | 200.74 | 201.0 | 30435.0 |
| 2025-06-26 17:00:00 | AAPL | Stock | 200.95 | 201.1 | 200.9392 | 201.0 | 19279.0 |
| 2025-06-26 17:30:00 | AAPL | Stock | 201.0001 | 201.2 | 201.0 | 201.1282 | 21555.0 |
| 2025-06-26 18:00:00 | AAPL | Stock | 201.15 | 201.35 | 201.04 | 201.35 | 29996.0 |
| 2025-06-26 18:30:00 | AAPL | Stock | 201.27 | 201.27 | 201.1 | 201.2 | 17155.0 |
| 2025-06-26 19:00:00 | AAPL | Stock | 201.18 | 201.2 | 201.0 | 201.11 | 23698.0 |
| 2025-06-26 19:30:00 | AAPL | Stock | 201.13 | 201.3 | 201.13 | 201.28 | 21902.0 |
| 2025-06-26 04:00:00 | MSFT | Stock | 493.48 | 494.1 | 493.37 | 494.1 | 2407.0 |
| 2025-06-26 04:30:00 | MSFT | Stock | 493.8 | 493.81 | 493.58 | 493.58 | 1604.0 |
| 2025-06-26 05:00:00 | MSFT | Stock | 493.87 | 494.18 | 493.82 | 494.0 | 1491.0 |
| 2025-06-26 05:30:00 | MSFT | Stock | 493.8 | 493.81 | 493.68 | 493.68 | 1408.0 |
| 2025-06-26 06:00:00 | MSFT | Stock | 493.79 | 494.11 | 493.79 | 493.9 | 1023.0 |
| 2025-06-26 07:00:00 | MSFT | Stock | 493.9 | 494.45 | 493.9 | 494.2 | 2525.0 |
| 2025-06-26 07:30:00 | MSFT | Stock | 494.2 | 494.2 | 494.14 | 494.2 | 500.0 |
| 2025-06-26 08:00:00 | MSFT | Stock | 493.96 | 494.5 | 491.04 | 494.2 | 19321.0 |
| 2025-06-26 08:30:00 | MSFT | Stock | 494.01 | 494.15 | 493.25 | 494.0 | 5788.0 |
| 2025-06-26 09:00:00 | MSFT | Stock | 493.76 | 494.4585 | 492.86 | 492.93 | 16948.0 |
| 2025-06-26 09:30:00 | MSFT | Stock | 492.96 | 496.025 | 492.93 | 495.97 | 1315122.0 |
| 2025-06-26 10:00:00 | MSFT | Stock | 495.97 | 496.96 | 494.5719 | 495.25 | 849122.0 |
| 2025-06-26 10:30:00 | MSFT | Stock | 495.25 | 495.91 | 493.455 | 493.52 | 579265.0 |
| 2025-06-26 11:00:00 | MSFT | Stock | 493.46 | 494.27 | 492.81 | 493.245 | 581910.0 |
| 2025-06-26 11:30:00 | MSFT | Stock | 493.225 | 494.42 | 493.04 | 494.16 | 311258.0 |
| 2025-06-26 12:00:00 | MSFT | Stock | 494.165 | 494.63 | 493.79 | 493.87 | 229558.0 |
| 2025-06-26 12:30:00 | MSFT | Stock | 493.87 | 495.61 | 493.78 | 495.57 | 465241.0 |
| 2025-06-26 13:00:00 | MSFT | Stock | 495.57 | 496.43 | 495.26 | 495.9108 | 385591.0 |
> showing 50 of 105,366 rows — these rows as CSV