PREVIEW / etf_30min / 2025-11-25
file: by_date/etf_30min/2025/2025-11-25.parquet size: 1.1 MB rows: 45,328
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-25 04:00:00 | SPY | ETF | 667.9 | 668.53 | 667.35 | 667.35 | 16414.0 |
| 2025-11-25 04:30:00 | SPY | ETF | 667.32 | 667.94 | 667.2 | 667.77 | 15456.0 |
| 2025-11-25 05:00:00 | SPY | ETF | 667.69 | 668.06 | 667.51 | 667.82 | 8254.0 |
| 2025-11-25 05:30:00 | SPY | ETF | 667.61 | 668.49 | 667.42 | 668.29 | 16654.0 |
| 2025-11-25 06:00:00 | SPY | ETF | 668.28 | 668.41 | 667.92 | 667.95 | 22835.0 |
| 2025-11-25 06:30:00 | SPY | ETF | 667.94 | 668.15 | 667.67 | 668.09 | 23798.0 |
| 2025-11-25 07:00:00 | SPY | ETF | 668.13 | 669.16 | 668.08 | 668.99 | 85625.0 |
| 2025-11-25 07:30:00 | SPY | ETF | 668.97 | 670.24 | 668.24 | 668.71 | 329555.0 |
| 2025-11-25 08:00:00 | SPY | ETF | 667.8648 | 670.1704 | 667.24 | 669.58 | 200820.0 |
| 2025-11-25 08:30:00 | SPY | ETF | 669.61 | 670.0 | 668.47 | 668.78 | 216275.0 |
| 2025-11-25 09:00:00 | SPY | ETF | 668.8 | 668.96 | 668.11 | 668.68 | 265216.0 |
| 2025-11-25 09:30:00 | SPY | ETF | 668.63 | 669.98 | 664.48 | 668.87 | 10077627.0 |
| 2025-11-25 10:00:00 | SPY | ETF | 668.86 | 668.9 | 665.92 | 668.58 | 6541591.0 |
| 2025-11-25 10:30:00 | SPY | ETF | 668.54 | 671.07 | 668.44 | 669.805 | 5343866.0 |
| 2025-11-25 11:00:00 | SPY | ETF | 669.8 | 671.0 | 668.86 | 670.42 | 3788046.0 |
| 2025-11-25 11:30:00 | SPY | ETF | 670.41 | 671.94 | 670.22 | 671.72 | 2991549.0 |
| 2025-11-25 12:00:00 | SPY | ETF | 671.72 | 673.88 | 671.69 | 673.32 | 4141929.0 |
| 2025-11-25 12:30:00 | SPY | ETF | 673.31 | 674.375 | 673.15 | 673.3099 | 3208589.0 |
| 2025-11-25 13:00:00 | SPY | ETF | 673.31 | 674.035 | 673.22 | 674.025 | 2815345.0 |
| 2025-11-25 13:30:00 | SPY | ETF | 674.03 | 674.4 | 673.57 | 673.87 | 2273475.0 |
| 2025-11-25 14:00:00 | SPY | ETF | 673.87 | 673.995 | 672.7 | 673.32 | 3321356.0 |
| 2025-11-25 14:30:00 | SPY | ETF | 673.32 | 674.11 | 672.44 | 673.94 | 3346758.0 |
| 2025-11-25 15:00:00 | SPY | ETF | 673.94 | 674.79 | 673.92 | 674.5 | 4270747.0 |
| 2025-11-25 15:30:00 | SPY | ETF | 674.51 | 676.21 | 674.455 | 675.01 | 9496495.0 |
| 2025-11-25 16:00:00 | SPY | ETF | 675.0 | 675.38 | 674.84 | 674.96 | 1948083.0 |
| 2025-11-25 16:30:00 | SPY | ETF | 674.97 | 675.1 | 674.86 | 675.01 | 190409.0 |
| 2025-11-25 17:00:00 | SPY | ETF | 675.0 | 675.19 | 674.96 | 675.16 | 23809.0 |
| 2025-11-25 17:30:00 | SPY | ETF | 675.17 | 675.26 | 674.99 | 675.17 | 18445.0 |
| 2025-11-25 18:00:00 | SPY | ETF | 675.11 | 675.47 | 674.93 | 675.18 | 31543.0 |
| 2025-11-25 18:30:00 | SPY | ETF | 675.25 | 675.39 | 674.83 | 675.32 | 49800.0 |
| 2025-11-25 19:00:00 | SPY | ETF | 675.27 | 676.18 | 675.0075 | 675.73 | 49751.0 |
| 2025-11-25 19:30:00 | SPY | ETF | 675.75 | 676.0 | 675.61 | 675.929 | 15378.0 |
| 2025-11-25 04:00:00 | QQQ | ETF | 604.5 | 604.5 | 602.79 | 602.81 | 88555.0 |
| 2025-11-25 04:30:00 | QQQ | ETF | 602.89 | 603.84 | 602.65 | 603.47 | 82627.0 |
| 2025-11-25 05:00:00 | QQQ | ETF | 603.58 | 603.93 | 603.17 | 603.62 | 49133.0 |
| 2025-11-25 05:30:00 | QQQ | ETF | 603.57 | 604.33 | 603.0 | 604.2 | 56464.0 |
| 2025-11-25 06:00:00 | QQQ | ETF | 604.23 | 604.49 | 603.67 | 603.73 | 49080.0 |
| 2025-11-25 06:30:00 | QQQ | ETF | 603.72 | 603.92 | 603.19 | 603.88 | 49063.0 |
| 2025-11-25 07:00:00 | QQQ | ETF | 603.89 | 605.37 | 603.74 | 605.36 | 133102.0 |
| 2025-11-25 07:30:00 | QQQ | ETF | 605.28 | 606.37 | 604.12 | 604.8 | 250892.0 |
| 2025-11-25 08:00:00 | QQQ | ETF | 604.81 | 606.2 | 602.71 | 605.43 | 403692.0 |
| 2025-11-25 08:30:00 | QQQ | ETF | 605.39 | 605.9 | 603.9008 | 604.13 | 402463.0 |
| 2025-11-25 09:00:00 | QQQ | ETF | 604.16 | 604.55 | 603.12 | 603.55 | 365760.0 |
| 2025-11-25 09:30:00 | QQQ | ETF | 603.51 | 604.07 | 597.32 | 602.52 | 9660230.0 |
| 2025-11-25 10:00:00 | QQQ | ETF | 602.58 | 602.69 | 598.6 | 601.6606 | 5855105.0 |
| 2025-11-25 10:30:00 | QQQ | ETF | 601.66 | 603.9 | 601.2101 | 602.56 | 3852776.0 |
| 2025-11-25 11:00:00 | QQQ | ETF | 602.54 | 604.11 | 601.5 | 603.42 | 2677189.0 |
| 2025-11-25 11:30:00 | QQQ | ETF | 603.41 | 604.85 | 603.1 | 604.52 | 2201721.0 |
| 2025-11-25 12:00:00 | QQQ | ETF | 604.51 | 607.37 | 604.4 | 606.74 | 3178400.0 |
| 2025-11-25 12:30:00 | QQQ | ETF | 606.74 | 608.42 | 606.38 | 606.61 | 2965075.0 |
> showing 50 of 45,328 rows — these rows as CSV