PREVIEW / etf_30min / 2025-12-16
file: by_date/etf_30min/2025/2025-12-16.parquet size: 1.1 MB rows: 45,105
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-12-16 04:00:00 | SPY | ETF | 677.48 | 679.08 | 677.48 | 678.83 | 40760.0 |
| 2025-12-16 04:30:00 | SPY | ETF | 678.9 | 679.06 | 677.73 | 678.04 | 20062.0 |
| 2025-12-16 05:00:00 | SPY | ETF | 677.91 | 679.18 | 677.86 | 679.17 | 12069.0 |
| 2025-12-16 05:30:00 | SPY | ETF | 679.12 | 679.88 | 678.9 | 679.49 | 17229.0 |
| 2025-12-16 06:00:00 | SPY | ETF | 679.42 | 679.43 | 679.23 | 679.34 | 5361.0 |
| 2025-12-16 06:30:00 | SPY | ETF | 679.47 | 680.34 | 679.37 | 680.28 | 6628.0 |
| 2025-12-16 07:00:00 | SPY | ETF | 680.33 | 680.84 | 680.14 | 680.56 | 21690.0 |
| 2025-12-16 07:30:00 | SPY | ETF | 680.6 | 680.91 | 680.38 | 680.48 | 60457.0 |
| 2025-12-16 08:00:00 | SPY | ETF | 680.39 | 680.8867 | 676.38 | 680.18 | 293390.0 |
| 2025-12-16 08:30:00 | SPY | ETF | 680.35 | 682.22 | 679.46 | 679.77 | 800785.0 |
| 2025-12-16 09:00:00 | SPY | ETF | 679.79 | 680.45 | 679.07 | 679.22 | 383536.0 |
| 2025-12-16 09:30:00 | SPY | ETF | 679.22 | 681.02 | 677.68 | 680.79 | 9427496.0 |
| 2025-12-16 10:00:00 | SPY | ETF | 680.82 | 681.08 | 676.44 | 677.69 | 7111351.0 |
| 2025-12-16 10:30:00 | SPY | ETF | 677.71 | 679.415 | 677.02 | 679.0 | 5156576.0 |
| 2025-12-16 11:00:00 | SPY | ETF | 678.99 | 679.3218 | 676.81 | 677.135 | 3809335.0 |
| 2025-12-16 11:30:00 | SPY | ETF | 677.14 | 678.49 | 676.61 | 678.28 | 3218248.0 |
| 2025-12-16 12:00:00 | SPY | ETF | 678.3 | 678.94 | 677.02 | 677.38 | 2987597.0 |
| 2025-12-16 12:30:00 | SPY | ETF | 677.3748 | 678.28 | 675.42 | 675.6 | 3680829.0 |
| 2025-12-16 13:00:00 | SPY | ETF | 675.61 | 676.2 | 674.98 | 675.59 | 4677405.0 |
| 2025-12-16 13:30:00 | SPY | ETF | 675.59 | 678.61 | 675.56 | 677.86 | 4327338.0 |
| 2025-12-16 14:00:00 | SPY | ETF | 677.85 | 677.9 | 675.86 | 677.05 | 5201710.0 |
| 2025-12-16 14:30:00 | SPY | ETF | 677.04 | 678.58 | 676.93 | 677.94 | 3763848.0 |
| 2025-12-16 15:00:00 | SPY | ETF | 677.94 | 679.26 | 677.63 | 679.2 | 4856147.0 |
| 2025-12-16 15:30:00 | SPY | ETF | 679.195 | 680.56 | 678.82 | 678.86 | 14049853.0 |
| 2025-12-16 16:00:00 | SPY | ETF | 678.86 | 679.1114 | 677.83 | 678.25 | 2678647.0 |
| 2025-12-16 16:30:00 | SPY | ETF | 678.25 | 679.1003 | 678.05 | 678.05 | 124127.0 |
| 2025-12-16 17:00:00 | SPY | ETF | 678.25 | 678.87 | 678.1 | 678.41 | 37804.0 |
| 2025-12-16 17:30:00 | SPY | ETF | 678.38 | 678.72 | 678.21 | 678.72 | 6799.0 |
| 2025-12-16 18:00:00 | SPY | ETF | 678.42 | 678.76 | 677.6501 | 678.33 | 52206.0 |
| 2025-12-16 18:30:00 | SPY | ETF | 678.37 | 678.83 | 677.8 | 677.92 | 38881.0 |
| 2025-12-16 19:00:00 | SPY | ETF | 677.8 | 677.88 | 676.88 | 677.63 | 25148.0 |
| 2025-12-16 19:30:00 | SPY | ETF | 677.67 | 678.1 | 677.32 | 677.69 | 47040.0 |
| 2025-12-16 04:00:00 | QQQ | ETF | 606.12 | 608.78 | 605.8 | 607.69 | 81496.0 |
| 2025-12-16 04:30:00 | QQQ | ETF | 607.69 | 608.0 | 606.63 | 607.0 | 122942.0 |
| 2025-12-16 05:00:00 | QQQ | ETF | 606.98 | 608.3 | 606.65 | 608.22 | 36093.0 |
| 2025-12-16 05:30:00 | QQQ | ETF | 608.26 | 609.14 | 607.93 | 608.49 | 51402.0 |
| 2025-12-16 06:00:00 | QQQ | ETF | 608.55 | 608.68 | 608.25 | 608.49 | 92510.0 |
| 2025-12-16 06:30:00 | QQQ | ETF | 608.55 | 609.64 | 608.27 | 609.6 | 36575.0 |
| 2025-12-16 07:00:00 | QQQ | ETF | 609.65 | 610.28 | 609.37 | 610.03 | 89734.0 |
| 2025-12-16 07:30:00 | QQQ | ETF | 610.02 | 610.36 | 609.68 | 609.77 | 77819.0 |
| 2025-12-16 08:00:00 | QQQ | ETF | 609.74 | 610.997 | 604.5 | 609.83 | 394729.0 |
| 2025-12-16 08:30:00 | QQQ | ETF | 609.71 | 611.9 | 608.41 | 608.77 | 674549.0 |
| 2025-12-16 09:00:00 | QQQ | ETF | 608.62 | 609.64 | 608.07 | 608.26 | 357371.0 |
| 2025-12-16 09:30:00 | QQQ | ETF | 608.26 | 612.25 | 607.585 | 612.11 | 5668334.0 |
| 2025-12-16 10:00:00 | QQQ | ETF | 612.21 | 612.49 | 606.97 | 608.5 | 4358547.0 |
| 2025-12-16 10:30:00 | QQQ | ETF | 608.49 | 610.84 | 607.37 | 610.45 | 2824875.0 |
| 2025-12-16 11:00:00 | QQQ | ETF | 610.44 | 610.945 | 607.85 | 608.3 | 2726962.0 |
| 2025-12-16 11:30:00 | QQQ | ETF | 608.3 | 610.85 | 607.88 | 610.76 | 2244006.0 |
| 2025-12-16 12:00:00 | QQQ | ETF | 610.76 | 611.2 | 608.91 | 609.28 | 2407975.0 |
| 2025-12-16 12:30:00 | QQQ | ETF | 609.2501 | 610.4 | 607.37 | 607.569 | 2228927.0 |
> showing 50 of 45,105 rows — these rows as CSV