PREVIEW / stock_30min / 2025-08-07
file: by_date/stock_30min/2025/2025-08-07.parquet size: 2.2 MB rows: 108,195 symbols: 353
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-08-07 04:00:00 | AAPL | Stock | 218.97 | 219.7 | 218.36 | 219.7 | 57279.0 |
| 2025-08-07 04:30:00 | AAPL | Stock | 219.57 | 219.71 | 219.06 | 219.7 | 32862.0 |
| 2025-08-07 05:00:00 | AAPL | Stock | 219.69 | 220.04 | 219.2 | 220.04 | 47297.0 |
| 2025-08-07 05:30:00 | AAPL | Stock | 220.08 | 220.32 | 219.9 | 220.14 | 28948.0 |
| 2025-08-07 06:00:00 | AAPL | Stock | 220.0 | 220.31 | 219.85 | 219.85 | 29814.0 |
| 2025-08-07 06:30:00 | AAPL | Stock | 219.84 | 219.98 | 219.14 | 219.87 | 65729.0 |
| 2025-08-07 07:00:00 | AAPL | Stock | 219.9 | 220.08 | 218.91 | 219.07 | 111147.0 |
| 2025-08-07 07:30:00 | AAPL | Stock | 219.1 | 219.69 | 218.75 | 219.5 | 109428.0 |
| 2025-08-07 08:00:00 | AAPL | Stock | 219.63 | 220.31 | 217.93 | 219.55 | 481305.0 |
| 2025-08-07 08:30:00 | AAPL | Stock | 219.5 | 219.59 | 218.75 | 218.86 | 187493.0 |
| 2025-08-07 09:00:00 | AAPL | Stock | 218.86 | 219.4 | 218.57 | 218.8669 | 318140.0 |
| 2025-08-07 09:30:00 | AAPL | Stock | 218.89 | 220.33 | 216.58 | 219.555 | 16533639.0 |
| 2025-08-07 10:00:00 | AAPL | Stock | 219.59 | 219.99 | 217.56 | 218.27 | 6485536.0 |
| 2025-08-07 10:30:00 | AAPL | Stock | 218.2863 | 219.1455 | 217.65 | 219.1455 | 4350438.0 |
| 2025-08-07 11:00:00 | AAPL | Stock | 219.145 | 220.13 | 218.97 | 219.629 | 5235768.0 |
| 2025-08-07 11:30:00 | AAPL | Stock | 219.62 | 220.1998 | 219.42 | 219.605 | 3453223.0 |
| 2025-08-07 12:00:00 | AAPL | Stock | 219.6 | 220.34 | 219.55 | 219.915 | 3809527.0 |
| 2025-08-07 12:30:00 | AAPL | Stock | 219.92 | 220.21 | 218.8 | 219.205 | 3327351.0 |
| 2025-08-07 13:00:00 | AAPL | Stock | 219.22 | 219.61 | 218.7026 | 218.71 | 2244640.0 |
| 2025-08-07 13:30:00 | AAPL | Stock | 218.71 | 219.52 | 218.71 | 219.27 | 2017232.0 |
| 2025-08-07 14:00:00 | AAPL | Stock | 219.28 | 219.73 | 219.0354 | 219.5 | 1738995.0 |
| 2025-08-07 14:30:00 | AAPL | Stock | 219.49 | 220.85 | 219.2435 | 220.43 | 3775936.0 |
| 2025-08-07 15:00:00 | AAPL | Stock | 220.45 | 220.5798 | 219.3 | 219.3001 | 3164376.0 |
| 2025-08-07 15:30:00 | AAPL | Stock | 219.3045 | 220.21 | 219.24 | 220.13 | 5561196.0 |
| 2025-08-07 16:00:00 | AAPL | Stock | 220.16 | 220.89 | 220.03 | 220.23 | 6023168.0 |
| 2025-08-07 16:30:00 | AAPL | Stock | 220.2 | 220.28 | 220.03 | 220.11 | 47296.0 |
| 2025-08-07 17:00:00 | AAPL | Stock | 220.08 | 220.1391 | 220.0 | 220.05 | 31957.0 |
| 2025-08-07 17:30:00 | AAPL | Stock | 220.03 | 220.2 | 220.01 | 220.05 | 14795.0 |
| 2025-08-07 18:00:00 | AAPL | Stock | 220.18 | 220.77 | 220.13 | 220.75 | 35522.0 |
| 2025-08-07 18:30:00 | AAPL | Stock | 220.7992 | 221.79 | 220.75 | 221.71 | 84215.0 |
| 2025-08-07 19:00:00 | AAPL | Stock | 221.72 | 221.86 | 221.3 | 221.36 | 50528.0 |
| 2025-08-07 19:30:00 | AAPL | Stock | 221.35 | 221.5874 | 221.05 | 221.2895 | 55606.0 |
| 2025-08-07 04:00:00 | MSFT | Stock | 526.65 | 527.98 | 526.43 | 527.98 | 2455.0 |
| 2025-08-07 04:30:00 | MSFT | Stock | 527.69 | 527.69 | 527.34 | 527.69 | 2988.0 |
| 2025-08-07 05:00:00 | MSFT | Stock | 527.15 | 527.71 | 527.15 | 527.71 | 862.0 |
| 2025-08-07 05:30:00 | MSFT | Stock | 528.0 | 528.5 | 528.0 | 528.5 | 3440.0 |
| 2025-08-07 06:00:00 | MSFT | Stock | 528.51 | 529.0 | 528.29 | 528.5 | 6176.0 |
| 2025-08-07 06:30:00 | MSFT | Stock | 528.68 | 529.49 | 528.68 | 529.48 | 897.0 |
| 2025-08-07 07:00:00 | MSFT | Stock | 529.81 | 530.01 | 528.25 | 528.25 | 18580.0 |
| 2025-08-07 07:30:00 | MSFT | Stock | 528.04 | 528.2 | 527.52 | 528.2 | 2230.0 |
| 2025-08-07 08:00:00 | MSFT | Stock | 529.0 | 529.67 | 525.58 | 527.93 | 36069.0 |
| 2025-08-07 08:30:00 | MSFT | Stock | 527.87 | 528.33 | 527.7 | 528.03 | 12410.0 |
| 2025-08-07 09:00:00 | MSFT | Stock | 528.1 | 528.88 | 526.2 | 526.82 | 20708.0 |
| 2025-08-07 09:30:00 | MSFT | Stock | 526.8 | 528.09 | 523.52 | 525.35 | 1455532.0 |
| 2025-08-07 10:00:00 | MSFT | Stock | 525.35 | 526.2 | 523.45 | 524.58 | 799967.0 |
| 2025-08-07 10:30:00 | MSFT | Stock | 524.55 | 526.4229 | 524.24 | 525.375 | 514335.0 |
| 2025-08-07 11:00:00 | MSFT | Stock | 525.42 | 525.6798 | 524.195 | 524.53 | 397789.0 |
| 2025-08-07 11:30:00 | MSFT | Stock | 524.49 | 524.8708 | 522.2501 | 522.26 | 537062.0 |
| 2025-08-07 12:00:00 | MSFT | Stock | 522.2594 | 522.92 | 521.15 | 522.295 | 429198.0 |
| 2025-08-07 12:30:00 | MSFT | Stock | 522.28 | 522.54 | 520.57 | 521.93 | 411377.0 |
> showing 50 of 108,195 rows — these rows as CSV