PREVIEW / etf_30min / 2025-11-14
file: by_date/etf_30min/2025/2025-11-14.parquet size: 1.1 MB rows: 45,443
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-14 04:00:00 | SPY | ETF | 670.67 | 671.56 | 670.0 | 670.66 | 84239.0 |
| 2025-11-14 04:30:00 | SPY | ETF | 670.41 | 670.6 | 669.68 | 669.99 | 36595.0 |
| 2025-11-14 05:00:00 | SPY | ETF | 669.93 | 670.91 | 669.77 | 670.61 | 30660.0 |
| 2025-11-14 05:30:00 | SPY | ETF | 670.64 | 670.97 | 669.74 | 670.1 | 41612.0 |
| 2025-11-14 06:00:00 | SPY | ETF | 670.02 | 670.02 | 667.59 | 668.0 | 87439.0 |
| 2025-11-14 06:30:00 | SPY | ETF | 667.95 | 668.1 | 666.0 | 667.67 | 196562.0 |
| 2025-11-14 07:00:00 | SPY | ETF | 667.68 | 667.7 | 665.76 | 666.59 | 334002.0 |
| 2025-11-14 07:30:00 | SPY | ETF | 666.65 | 666.7 | 664.72 | 665.79 | 303055.0 |
| 2025-11-14 08:00:00 | SPY | ETF | 667.56 | 672.61 | 664.26 | 664.94 | 564581.0 |
| 2025-11-14 08:30:00 | SPY | ETF | 664.96 | 665.7794 | 663.97 | 665.42 | 472125.0 |
| 2025-11-14 09:00:00 | SPY | ETF | 665.5 | 666.26 | 665.01 | 665.42 | 437430.0 |
| 2025-11-14 09:30:00 | SPY | ETF | 665.4 | 668.845 | 663.265 | 668.69 | 13054646.0 |
| 2025-11-14 10:00:00 | SPY | ETF | 668.68 | 669.96 | 666.92 | 669.79 | 7052029.0 |
| 2025-11-14 10:30:00 | SPY | ETF | 669.78 | 672.82 | 669.16 | 672.24 | 6713364.0 |
| 2025-11-14 11:00:00 | SPY | ETF | 672.25 | 674.87 | 670.89 | 674.395 | 4874114.0 |
| 2025-11-14 11:30:00 | SPY | ETF | 674.4 | 675.02 | 672.76 | 674.74 | 3785453.0 |
| 2025-11-14 12:00:00 | SPY | ETF | 674.715 | 675.64 | 674.205 | 675.05 | 3023394.0 |
| 2025-11-14 12:30:00 | SPY | ETF | 675.055 | 675.66 | 673.13 | 674.045 | 4268578.0 |
| 2025-11-14 13:00:00 | SPY | ETF | 674.05 | 674.36 | 672.14 | 673.13 | 4543163.0 |
| 2025-11-14 13:30:00 | SPY | ETF | 673.11 | 673.78 | 671.49 | 673.25 | 4522449.0 |
| 2025-11-14 14:00:00 | SPY | ETF | 673.25 | 674.44 | 672.27 | 674.0199 | 3928172.0 |
| 2025-11-14 14:30:00 | SPY | ETF | 674.02 | 674.9 | 673.62 | 674.65 | 3200612.0 |
| 2025-11-14 15:00:00 | SPY | ETF | 674.64 | 675.12 | 672.21 | 672.645 | 4493747.0 |
| 2025-11-14 15:30:00 | SPY | ETF | 672.64 | 673.11 | 671.17 | 671.95 | 8596378.0 |
| 2025-11-14 16:00:00 | SPY | ETF | 671.95 | 673.05 | 671.24 | 672.77 | 2488608.0 |
| 2025-11-14 16:30:00 | SPY | ETF | 672.8108 | 672.84 | 672.46 | 672.68 | 163979.0 |
| 2025-11-14 17:00:00 | SPY | ETF | 672.64 | 672.98 | 672.6 | 672.78 | 48050.0 |
| 2025-11-14 17:30:00 | SPY | ETF | 672.78 | 672.82 | 672.65 | 672.78 | 27611.0 |
| 2025-11-14 18:00:00 | SPY | ETF | 672.7807 | 672.99 | 672.74 | 672.97 | 49824.0 |
| 2025-11-14 18:30:00 | SPY | ETF | 672.95 | 672.99 | 672.81 | 672.85 | 32450.0 |
| 2025-11-14 19:00:00 | SPY | ETF | 672.92 | 673.05 | 672.88 | 673.05 | 9432.0 |
| 2025-11-14 19:30:00 | SPY | ETF | 673.0 | 673.34 | 672.95 | 673.34 | 41100.0 |
| 2025-11-14 04:00:00 | QQQ | ETF | 606.0 | 607.13 | 605.57 | 605.64 | 116632.0 |
| 2025-11-14 04:30:00 | QQQ | ETF | 605.62 | 605.74 | 604.54 | 604.83 | 158893.0 |
| 2025-11-14 05:00:00 | QQQ | ETF | 604.71 | 605.87 | 604.51 | 605.59 | 79951.0 |
| 2025-11-14 05:30:00 | QQQ | ETF | 605.74 | 606.04 | 604.55 | 604.9 | 65897.0 |
| 2025-11-14 06:00:00 | QQQ | ETF | 604.8 | 604.8 | 601.84 | 602.45 | 286454.0 |
| 2025-11-14 06:30:00 | QQQ | ETF | 602.42 | 602.61 | 600.85 | 602.24 | 318692.0 |
| 2025-11-14 07:00:00 | QQQ | ETF | 602.14 | 602.2 | 599.78 | 600.7 | 479872.0 |
| 2025-11-14 07:30:00 | QQQ | ETF | 600.63 | 600.68 | 598.21 | 599.61 | 673237.0 |
| 2025-11-14 08:00:00 | QQQ | ETF | 601.83 | 608.93 | 598.22 | 599.1993 | 914348.0 |
| 2025-11-14 08:30:00 | QQQ | ETF | 599.14 | 599.92 | 597.96 | 599.39 | 516989.0 |
| 2025-11-14 09:00:00 | QQQ | ETF | 599.45 | 600.48 | 598.97 | 599.48 | 457225.0 |
| 2025-11-14 09:30:00 | QQQ | ETF | 599.55 | 605.55 | 597.17 | 605.16 | 12064403.0 |
| 2025-11-14 10:00:00 | QQQ | ETF | 605.14 | 606.93 | 602.93 | 606.48 | 6550799.0 |
| 2025-11-14 10:30:00 | QQQ | ETF | 606.52 | 610.57 | 605.72 | 609.73 | 5846654.0 |
| 2025-11-14 11:00:00 | QQQ | ETF | 609.73 | 612.74 | 607.43 | 612.08 | 3853195.0 |
| 2025-11-14 11:30:00 | QQQ | ETF | 612.12 | 612.71 | 610.55 | 612.27 | 3220339.0 |
| 2025-11-14 12:00:00 | QQQ | ETF | 612.23 | 613.35 | 611.63 | 612.62 | 2879868.0 |
| 2025-11-14 12:30:00 | QQQ | ETF | 612.63 | 613.13 | 610.14 | 611.175 | 2903425.0 |
> showing 50 of 45,443 rows — these rows as CSV