PREVIEW / etf_30min / 2025-11-17
file: by_date/etf_30min/2025/2025-11-17.parquet size: 1.1 MB rows: 45,458
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-17 04:00:00 | SPY | ETF | 676.14 | 676.24 | 675.11 | 675.48 | 62265.0 |
| 2025-11-17 04:30:00 | SPY | ETF | 675.56 | 675.64 | 674.56 | 675.01 | 69289.0 |
| 2025-11-17 05:00:00 | SPY | ETF | 674.89 | 674.95 | 673.76 | 673.76 | 45907.0 |
| 2025-11-17 05:30:00 | SPY | ETF | 673.73 | 674.1 | 672.73 | 673.01 | 28070.0 |
| 2025-11-17 06:00:00 | SPY | ETF | 673.13 | 673.69 | 672.66 | 673.57 | 31863.0 |
| 2025-11-17 06:30:00 | SPY | ETF | 673.5 | 674.16 | 673.2 | 673.44 | 41965.0 |
| 2025-11-17 07:00:00 | SPY | ETF | 673.38 | 673.44 | 672.24 | 672.55 | 100190.0 |
| 2025-11-17 07:30:00 | SPY | ETF | 672.54 | 672.7 | 671.84 | 672.14 | 128633.0 |
| 2025-11-17 08:00:00 | SPY | ETF | 673.4491 | 676.26 | 670.79 | 671.4 | 307436.0 |
| 2025-11-17 08:30:00 | SPY | ETF | 671.41 | 671.42 | 669.71 | 670.98 | 278595.0 |
| 2025-11-17 09:00:00 | SPY | ETF | 671.0 | 671.0 | 669.48 | 669.62 | 314356.0 |
| 2025-11-17 09:30:00 | SPY | ETF | 669.7 | 673.71 | 668.92 | 672.76 | 7221453.0 |
| 2025-11-17 10:00:00 | SPY | ETF | 672.76 | 673.15 | 670.47 | 672.06 | 4456005.0 |
| 2025-11-17 10:30:00 | SPY | ETF | 672.04 | 672.37 | 670.14 | 670.705 | 4253769.0 |
| 2025-11-17 11:00:00 | SPY | ETF | 670.71 | 670.98 | 667.77 | 670.475 | 5656849.0 |
| 2025-11-17 11:30:00 | SPY | ETF | 670.48 | 672.98 | 670.372 | 672.95 | 3665323.0 |
| 2025-11-17 12:00:00 | SPY | ETF | 672.94 | 673.0 | 671.705 | 672.3101 | 2094838.0 |
| 2025-11-17 12:30:00 | SPY | ETF | 672.33 | 672.59 | 669.15 | 669.22 | 3111516.0 |
| 2025-11-17 13:00:00 | SPY | ETF | 669.24 | 669.48 | 668.22 | 668.71 | 3149405.0 |
| 2025-11-17 13:30:00 | SPY | ETF | 668.7 | 669.91 | 666.5 | 666.56 | 3741175.0 |
| 2025-11-17 14:00:00 | SPY | ETF | 666.57 | 666.9 | 664.97 | 665.8395 | 5490525.0 |
| 2025-11-17 14:30:00 | SPY | ETF | 665.83 | 666.1415 | 662.73 | 662.79 | 6029508.0 |
| 2025-11-17 15:00:00 | SPY | ETF | 662.77 | 664.05 | 662.17 | 663.76 | 7355053.0 |
| 2025-11-17 15:30:00 | SPY | ETF | 663.77 | 665.78 | 663.095 | 665.69 | 12813567.0 |
| 2025-11-17 16:00:00 | SPY | ETF | 665.68 | 666.38 | 665.5674 | 666.0103 | 3298553.0 |
| 2025-11-17 16:30:00 | SPY | ETF | 665.98 | 666.1 | 665.51 | 666.03 | 267468.0 |
| 2025-11-17 17:00:00 | SPY | ETF | 665.98 | 665.99 | 665.88 | 665.93 | 27023.0 |
| 2025-11-17 17:30:00 | SPY | ETF | 665.93 | 665.95 | 665.57 | 665.89 | 202924.0 |
| 2025-11-17 18:00:00 | SPY | ETF | 665.8 | 666.84 | 665.6 | 666.41 | 129174.0 |
| 2025-11-17 18:30:00 | SPY | ETF | 666.3 | 666.75 | 666.18 | 666.42 | 17572.0 |
| 2025-11-17 19:00:00 | SPY | ETF | 666.36 | 666.67 | 665.39 | 665.39 | 100778.0 |
| 2025-11-17 19:30:00 | SPY | ETF | 665.44 | 665.92 | 664.83 | 665.3 | 85425.0 |
| 2025-11-17 04:00:00 | QQQ | ETF | 613.62 | 615.07 | 613.62 | 613.9 | 89038.0 |
| 2025-11-17 04:30:00 | QQQ | ETF | 613.83 | 614.15 | 612.78 | 613.29 | 72163.0 |
| 2025-11-17 05:00:00 | QQQ | ETF | 613.27 | 613.44 | 611.72 | 611.85 | 52163.0 |
| 2025-11-17 05:30:00 | QQQ | ETF | 611.92 | 612.36 | 610.57 | 611.2 | 63027.0 |
| 2025-11-17 06:00:00 | QQQ | ETF | 611.16 | 611.85 | 610.52 | 611.45 | 70180.0 |
| 2025-11-17 06:30:00 | QQQ | ETF | 611.39 | 612.27 | 611.07 | 611.28 | 51448.0 |
| 2025-11-17 07:00:00 | QQQ | ETF | 611.33 | 611.33 | 609.8 | 610.0 | 163652.0 |
| 2025-11-17 07:30:00 | QQQ | ETF | 609.93 | 610.25 | 609.07 | 609.55 | 198406.0 |
| 2025-11-17 08:00:00 | QQQ | ETF | 610.05 | 615.07 | 607.72 | 608.7 | 438320.0 |
| 2025-11-17 08:30:00 | QQQ | ETF | 608.59 | 608.59 | 606.6 | 608.25 | 264634.0 |
| 2025-11-17 09:00:00 | QQQ | ETF | 608.2 | 608.2 | 606.1 | 606.27 | 313486.0 |
| 2025-11-17 09:30:00 | QQQ | ETF | 606.3 | 612.48 | 605.24 | 611.17 | 6536260.0 |
| 2025-11-17 10:00:00 | QQQ | ETF | 611.16 | 611.58 | 607.68 | 609.68 | 4620430.0 |
| 2025-11-17 10:30:00 | QQQ | ETF | 609.65 | 610.11 | 607.76 | 608.32 | 3611991.0 |
| 2025-11-17 11:00:00 | QQQ | ETF | 608.3 | 608.68 | 605.04 | 608.046 | 3849221.0 |
| 2025-11-17 11:30:00 | QQQ | ETF | 608.06 | 611.18 | 607.93 | 611.08 | 3094941.0 |
| 2025-11-17 12:00:00 | QQQ | ETF | 611.07 | 611.14 | 609.31 | 609.95 | 2300227.0 |
| 2025-11-17 12:30:00 | QQQ | ETF | 609.96 | 610.31 | 606.2899 | 606.37 | 2494021.0 |
> showing 50 of 45,458 rows — these rows as CSV