PREVIEW / etf_30min / 2025-11-26
file: by_date/etf_30min/2025/2025-11-26.parquet size: 1.1 MB rows: 44,974
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-26 04:00:00 | SPY | ETF | 677.1 | 677.29 | 676.45 | 676.54 | 43010.0 |
| 2025-11-26 04:30:00 | SPY | ETF | 676.64 | 677.02 | 676.54 | 676.63 | 16621.0 |
| 2025-11-26 05:00:00 | SPY | ETF | 676.67 | 677.4 | 676.67 | 677.1 | 15916.0 |
| 2025-11-26 05:30:00 | SPY | ETF | 677.0 | 677.53 | 676.8 | 677.35 | 22175.0 |
| 2025-11-26 06:00:00 | SPY | ETF | 677.45 | 677.58 | 677.19 | 677.37 | 22684.0 |
| 2025-11-26 06:30:00 | SPY | ETF | 677.31 | 677.6 | 676.81 | 676.93 | 39446.0 |
| 2025-11-26 07:00:00 | SPY | ETF | 676.87 | 677.04 | 675.86 | 676.27 | 112321.0 |
| 2025-11-26 07:30:00 | SPY | ETF | 676.25 | 676.87 | 675.85 | 676.77 | 89750.0 |
| 2025-11-26 08:00:00 | SPY | ETF | 677.05 | 678.15 | 675.89 | 677.2675 | 230979.0 |
| 2025-11-26 08:30:00 | SPY | ETF | 677.2 | 677.58 | 676.78 | 677.47 | 176362.0 |
| 2025-11-26 09:00:00 | SPY | ETF | 677.5 | 677.79 | 676.88 | 677.61 | 211746.0 |
| 2025-11-26 09:30:00 | SPY | ETF | 677.6 | 679.48 | 677.11 | 677.31 | 6992646.0 |
| 2025-11-26 10:00:00 | SPY | ETF | 677.3 | 678.55 | 676.72 | 678.13 | 4071215.0 |
| 2025-11-26 10:30:00 | SPY | ETF | 678.15 | 679.62 | 678.0606 | 679.56 | 2994673.0 |
| 2025-11-26 11:00:00 | SPY | ETF | 679.56 | 680.87 | 679.48 | 680.53 | 3211533.0 |
| 2025-11-26 11:30:00 | SPY | ETF | 680.53 | 681.69 | 680.29 | 681.3599 | 3383725.0 |
| 2025-11-26 12:00:00 | SPY | ETF | 681.355 | 681.56 | 680.43 | 680.94 | 2487783.0 |
| 2025-11-26 12:30:00 | SPY | ETF | 680.94 | 681.7 | 680.87 | 681.11 | 2183672.0 |
| 2025-11-26 13:00:00 | SPY | ETF | 681.12 | 681.56 | 679.75 | 681.11 | 3424927.0 |
| 2025-11-26 13:30:00 | SPY | ETF | 681.115 | 681.14 | 679.59 | 680.4 | 2760961.0 |
| 2025-11-26 14:00:00 | SPY | ETF | 680.4 | 681.29 | 680.13 | 681.24 | 2991218.0 |
| 2025-11-26 14:30:00 | SPY | ETF | 681.25 | 681.42 | 680.49 | 680.86 | 3199138.0 |
| 2025-11-26 15:00:00 | SPY | ETF | 680.87 | 681.59 | 680.59 | 681.2 | 3986298.0 |
| 2025-11-26 15:30:00 | SPY | ETF | 681.2 | 681.4 | 679.62 | 679.63 | 9737281.0 |
| 2025-11-26 16:00:00 | SPY | ETF | 679.65 | 680.4 | 679.62 | 680.03 | 3057619.0 |
| 2025-11-26 16:30:00 | SPY | ETF | 680.03 | 680.13 | 679.94 | 680.1 | 257472.0 |
| 2025-11-26 17:00:00 | SPY | ETF | 680.06 | 680.17 | 679.93 | 680.0 | 37362.0 |
| 2025-11-26 17:30:00 | SPY | ETF | 680.01 | 680.21 | 680.01 | 680.15 | 36022.0 |
| 2025-11-26 18:00:00 | SPY | ETF | 680.17 | 680.43 | 679.9 | 679.9168 | 28299.0 |
| 2025-11-26 18:30:00 | SPY | ETF | 679.9403 | 680.38 | 679.9403 | 680.08 | 20110.0 |
| 2025-11-26 19:00:00 | SPY | ETF | 680.05 | 680.3 | 679.98 | 680.195 | 14263.0 |
| 2025-11-26 19:30:00 | SPY | ETF | 680.22 | 680.37 | 680.01 | 680.3693 | 20606.0 |
| 2025-11-26 04:00:00 | QQQ | ETF | 611.0 | 611.97 | 610.32 | 610.62 | 84825.0 |
| 2025-11-26 04:30:00 | QQQ | ETF | 610.71 | 611.25 | 610.5 | 610.74 | 37670.0 |
| 2025-11-26 05:00:00 | QQQ | ETF | 610.74 | 611.69 | 610.74 | 611.33 | 45369.0 |
| 2025-11-26 05:30:00 | QQQ | ETF | 611.28 | 612.06 | 611.02 | 611.89 | 58153.0 |
| 2025-11-26 06:00:00 | QQQ | ETF | 611.88 | 612.34 | 611.68 | 612.01 | 61742.0 |
| 2025-11-26 06:30:00 | QQQ | ETF | 612.09 | 612.19 | 611.35 | 611.44 | 48405.0 |
| 2025-11-26 07:00:00 | QQQ | ETF | 611.44 | 611.59 | 610.02 | 610.54 | 144147.0 |
| 2025-11-26 07:30:00 | QQQ | ETF | 610.41 | 611.5 | 610.1 | 611.37 | 71870.0 |
| 2025-11-26 08:00:00 | QQQ | ETF | 610.47 | 612.82 | 610.03 | 611.95 | 372176.0 |
| 2025-11-26 08:30:00 | QQQ | ETF | 611.81 | 612.42 | 611.31 | 612.29 | 271516.0 |
| 2025-11-26 09:00:00 | QQQ | ETF | 612.28 | 612.7 | 611.42 | 612.51 | 234412.0 |
| 2025-11-26 09:30:00 | QQQ | ETF | 612.51 | 613.9 | 610.88 | 611.16 | 5178520.0 |
| 2025-11-26 10:00:00 | QQQ | ETF | 611.15 | 612.52 | 610.39 | 611.72 | 3542670.0 |
| 2025-11-26 10:30:00 | QQQ | ETF | 611.79 | 613.68 | 611.78 | 613.61 | 2205455.0 |
| 2025-11-26 11:00:00 | QQQ | ETF | 613.61 | 615.31 | 613.5 | 614.9301 | 2778618.0 |
| 2025-11-26 11:30:00 | QQQ | ETF | 614.97 | 616.19 | 614.59 | 615.68 | 2209988.0 |
| 2025-11-26 12:00:00 | QQQ | ETF | 615.69 | 615.8382 | 614.68 | 615.305 | 1927186.0 |
| 2025-11-26 12:30:00 | QQQ | ETF | 615.31 | 616.06 | 615.17 | 615.3101 | 1439743.0 |
> showing 50 of 44,974 rows — these rows as CSV