PREVIEW / etf_30min / 2025-11-24
file: by_date/etf_30min/2025/2025-11-24.parquet size: 1.1 MB rows: 45,690
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-11-24 04:00:00 | SPY | ETF | 662.5 | 663.75 | 659.54 | 659.56 | 65916.0 |
| 2025-11-24 04:30:00 | SPY | ETF | 659.46 | 661.18 | 659.46 | 660.74 | 41279.0 |
| 2025-11-24 05:00:00 | SPY | ETF | 660.64 | 661.08 | 659.97 | 660.08 | 58908.0 |
| 2025-11-24 05:30:00 | SPY | ETF | 660.09 | 660.73 | 659.5 | 660.27 | 44425.0 |
| 2025-11-24 06:00:00 | SPY | ETF | 660.35 | 660.5 | 659.6 | 660.11 | 61017.0 |
| 2025-11-24 06:30:00 | SPY | ETF | 660.25 | 661.49 | 660.08 | 661.42 | 96982.0 |
| 2025-11-24 07:00:00 | SPY | ETF | 661.4 | 662.3 | 660.88 | 662.12 | 90008.0 |
| 2025-11-24 07:30:00 | SPY | ETF | 662.17 | 662.85 | 661.82 | 662.62 | 100910.0 |
| 2025-11-24 08:00:00 | SPY | ETF | 661.12 | 663.72 | 659.61 | 663.35 | 300045.0 |
| 2025-11-24 08:30:00 | SPY | ETF | 663.36 | 663.59 | 659.03 | 662.24 | 248803.0 |
| 2025-11-24 09:00:00 | SPY | ETF | 662.21 | 663.88 | 662.16 | 662.66 | 360159.0 |
| 2025-11-24 09:30:00 | SPY | ETF | 662.69 | 665.53 | 661.59 | 664.04 | 8118670.0 |
| 2025-11-24 10:00:00 | SPY | ETF | 664.04 | 665.78 | 663.93 | 665.51 | 5771103.0 |
| 2025-11-24 10:30:00 | SPY | ETF | 665.49 | 667.2 | 664.95 | 666.53 | 4015443.0 |
| 2025-11-24 11:00:00 | SPY | ETF | 666.54 | 668.39 | 666.53 | 667.97 | 3704551.0 |
| 2025-11-24 11:30:00 | SPY | ETF | 667.96 | 668.4897 | 667.2 | 667.465 | 2452497.0 |
| 2025-11-24 12:00:00 | SPY | ETF | 667.47 | 668.3599 | 666.9 | 668.1856 | 2214347.0 |
| 2025-11-24 12:30:00 | SPY | ETF | 668.18 | 669.38 | 667.94 | 669.08 | 2527574.0 |
| 2025-11-24 13:00:00 | SPY | ETF | 669.07 | 669.75 | 669.07 | 669.19 | 2193025.0 |
| 2025-11-24 13:30:00 | SPY | ETF | 669.18 | 669.51 | 668.78 | 669.235 | 1717191.0 |
| 2025-11-24 14:00:00 | SPY | ETF | 669.24 | 669.81 | 668.69 | 668.8999 | 2421214.0 |
| 2025-11-24 14:30:00 | SPY | ETF | 668.9 | 669.0 | 667.87 | 668.3 | 3816300.0 |
| 2025-11-24 15:00:00 | SPY | ETF | 668.3 | 669.49 | 668.19 | 668.94 | 3370905.0 |
| 2025-11-24 15:30:00 | SPY | ETF | 668.93 | 670.06 | 668.61 | 668.8 | 12138092.0 |
| 2025-11-24 16:00:00 | SPY | ETF | 668.8 | 669.48 | 668.56 | 669.29 | 4975739.0 |
| 2025-11-24 16:30:00 | SPY | ETF | 669.33 | 669.6101 | 669.21 | 669.39 | 97409.0 |
| 2025-11-24 17:00:00 | SPY | ETF | 669.4 | 669.45 | 669.23 | 669.43 | 61953.0 |
| 2025-11-24 17:30:00 | SPY | ETF | 669.48 | 669.48 | 668.99 | 669.48 | 196350.0 |
| 2025-11-24 18:00:00 | SPY | ETF | 669.31 | 669.63 | 669.08 | 669.16 | 160650.0 |
| 2025-11-24 18:30:00 | SPY | ETF | 669.14 | 669.56 | 669.05 | 669.08 | 17433.0 |
| 2025-11-24 19:00:00 | SPY | ETF | 669.07 | 669.07 | 668.5 | 668.57 | 31487.0 |
| 2025-11-24 19:30:00 | SPY | ETF | 668.6 | 669.2671 | 668.57 | 669.1911 | 41090.0 |
| 2025-11-24 04:00:00 | QQQ | ETF | 596.0 | 596.23 | 591.53 | 591.61 | 186908.0 |
| 2025-11-24 04:30:00 | QQQ | ETF | 591.56 | 593.41 | 591.49 | 592.88 | 141291.0 |
| 2025-11-24 05:00:00 | QQQ | ETF | 592.73 | 593.22 | 591.93 | 592.27 | 98519.0 |
| 2025-11-24 05:30:00 | QQQ | ETF | 592.23 | 592.96 | 591.41 | 592.35 | 83849.0 |
| 2025-11-24 06:00:00 | QQQ | ETF | 592.43 | 592.9 | 591.78 | 592.55 | 71210.0 |
| 2025-11-24 06:30:00 | QQQ | ETF | 592.7 | 593.78 | 592.19 | 593.61 | 202856.0 |
| 2025-11-24 07:00:00 | QQQ | ETF | 593.55 | 594.44 | 592.84 | 594.27 | 150102.0 |
| 2025-11-24 07:30:00 | QQQ | ETF | 594.33 | 595.08 | 593.85 | 594.91 | 300527.0 |
| 2025-11-24 08:00:00 | QQQ | ETF | 594.82 | 596.29 | 591.789 | 595.96 | 493382.0 |
| 2025-11-24 08:30:00 | QQQ | ETF | 595.97 | 596.23 | 594.51 | 594.69 | 352460.0 |
| 2025-11-24 09:00:00 | QQQ | ETF | 594.66 | 596.49 | 594.61 | 595.24 | 403351.0 |
| 2025-11-24 09:30:00 | QQQ | ETF | 595.28 | 600.06 | 595.16 | 599.19 | 7949135.0 |
| 2025-11-24 10:00:00 | QQQ | ETF | 599.19 | 601.26 | 598.69 | 600.52 | 5137927.0 |
| 2025-11-24 10:30:00 | QQQ | ETF | 600.495 | 602.3798 | 599.82 | 601.47 | 3461536.0 |
| 2025-11-24 11:00:00 | QQQ | ETF | 601.484 | 603.9593 | 601.475 | 603.55 | 3413937.0 |
| 2025-11-24 11:30:00 | QQQ | ETF | 603.52 | 604.15 | 602.8 | 603.1 | 2340914.0 |
| 2025-11-24 12:00:00 | QQQ | ETF | 603.1 | 604.21 | 602.68 | 604.02 | 1908825.0 |
| 2025-11-24 12:30:00 | QQQ | ETF | 604.01 | 605.37 | 603.96 | 604.9 | 2459895.0 |
> showing 50 of 45,690 rows — these rows as CSV