PREVIEW / etf_30min / 2025-12-19
file: by_date/etf_30min/2025/2025-12-19.parquet size: 1.1 MB rows: 44,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-12-19 04:00:00 | SPY | ETF | 676.49 | 677.12 | 676.39 | 677.1 | 25240.0 |
| 2025-12-19 04:30:00 | SPY | ETF | 677.09 | 677.27 | 676.87 | 677.1 | 10114.0 |
| 2025-12-19 05:00:00 | SPY | ETF | 677.12 | 677.18 | 676.45 | 677.02 | 7201.0 |
| 2025-12-19 05:30:00 | SPY | ETF | 676.99 | 677.08 | 676.46 | 676.6 | 13709.0 |
| 2025-12-19 06:00:00 | SPY | ETF | 676.47 | 676.58 | 675.69 | 676.46 | 9059.0 |
| 2025-12-19 06:30:00 | SPY | ETF | 676.53 | 676.64 | 675.99 | 676.12 | 22265.0 |
| 2025-12-19 07:00:00 | SPY | ETF | 676.13 | 676.5 | 675.55 | 676.06 | 81904.0 |
| 2025-12-19 07:30:00 | SPY | ETF | 676.1 | 676.2 | 674.83 | 674.96 | 73590.0 |
| 2025-12-19 08:00:00 | SPY | ETF | 676.83 | 677.2347 | 674.16 | 675.43 | 105258.0 |
| 2025-12-19 08:30:00 | SPY | ETF | 675.4 | 675.99 | 675.07 | 675.51 | 169942.0 |
| 2025-12-19 09:00:00 | SPY | ETF | 675.54 | 676.78 | 675.07 | 676.71 | 362742.0 |
| 2025-12-19 09:30:00 | SPY | ETF | 676.6 | 679.91 | 676.47 | 679.82 | 10651506.0 |
| 2025-12-19 10:00:00 | SPY | ETF | 679.81 | 680.52 | 678.45 | 679.19 | 6920711.0 |
| 2025-12-19 10:30:00 | SPY | ETF | 679.19 | 680.115 | 678.66 | 678.98 | 6089263.0 |
| 2025-12-19 11:00:00 | SPY | ETF | 678.97 | 680.275 | 678.56 | 680.17 | 4242518.0 |
| 2025-12-19 11:30:00 | SPY | ETF | 680.19 | 680.53 | 679.34 | 679.695 | 3703738.0 |
| 2025-12-19 12:00:00 | SPY | ETF | 679.7 | 680.835 | 679.63 | 680.68 | 3356961.0 |
| 2025-12-19 12:30:00 | SPY | ETF | 680.69 | 681.058 | 680.31 | 680.655 | 2949646.0 |
| 2025-12-19 13:00:00 | SPY | ETF | 680.655 | 681.09 | 680.47 | 680.75 | 2276785.0 |
| 2025-12-19 13:30:00 | SPY | ETF | 680.77 | 680.86 | 680.17 | 680.225 | 2046040.0 |
| 2025-12-19 14:00:00 | SPY | ETF | 680.22 | 680.8 | 680.22 | 680.64 | 2581270.0 |
| 2025-12-19 14:30:00 | SPY | ETF | 680.64 | 681.0 | 680.52 | 680.59 | 3168999.0 |
| 2025-12-19 15:00:00 | SPY | ETF | 680.59 | 680.83 | 680.34 | 680.485 | 3877654.0 |
| 2025-12-19 15:30:00 | SPY | ETF | 680.49 | 680.72 | 679.61 | 680.59 | 16383311.0 |
| 2025-12-19 16:00:00 | SPY | ETF | 680.59 | 680.84 | 680.37 | 680.75 | 4876525.0 |
| 2025-12-19 16:30:00 | SPY | ETF | 680.75 | 681.19 | 680.59 | 681.03 | 285438.0 |
| 2025-12-19 17:00:00 | SPY | ETF | 681.02 | 681.14 | 680.96 | 681.02 | 143462.0 |
| 2025-12-19 17:30:00 | SPY | ETF | 681.06 | 681.14 | 681.02 | 681.1399 | 11718.0 |
| 2025-12-19 18:00:00 | SPY | ETF | 681.14 | 681.4 | 681.0999 | 681.25 | 62070.0 |
| 2025-12-19 18:30:00 | SPY | ETF | 681.28 | 681.3 | 681.15 | 681.29 | 40216.0 |
| 2025-12-19 19:00:00 | SPY | ETF | 681.27 | 681.39 | 681.2312 | 681.39 | 8689.0 |
| 2025-12-19 19:30:00 | SPY | ETF | 681.37 | 681.5 | 681.32 | 681.4505 | 16380.0 |
| 2025-12-19 04:00:00 | QQQ | ETF | 612.23 | 612.77 | 611.04 | 612.7 | 56359.0 |
| 2025-12-19 04:30:00 | QQQ | ETF | 612.67 | 612.8 | 612.3 | 612.56 | 35293.0 |
| 2025-12-19 05:00:00 | QQQ | ETF | 612.53 | 612.57 | 611.91 | 612.36 | 28553.0 |
| 2025-12-19 05:30:00 | QQQ | ETF | 612.3 | 612.52 | 611.96 | 612.05 | 28475.0 |
| 2025-12-19 06:00:00 | QQQ | ETF | 612.01 | 612.04 | 611.0 | 611.89 | 56750.0 |
| 2025-12-19 06:30:00 | QQQ | ETF | 611.91 | 612.12 | 611.36 | 611.52 | 27207.0 |
| 2025-12-19 07:00:00 | QQQ | ETF | 611.58 | 611.93 | 610.93 | 611.38 | 56901.0 |
| 2025-12-19 07:30:00 | QQQ | ETF | 611.37 | 611.53 | 610.06 | 610.07 | 74958.0 |
| 2025-12-19 08:00:00 | QQQ | ETF | 611.68 | 612.76 | 609.85 | 610.85 | 202627.0 |
| 2025-12-19 08:30:00 | QQQ | ETF | 610.83 | 611.5 | 610.4 | 611.0799 | 225991.0 |
| 2025-12-19 09:00:00 | QQQ | ETF | 611.1 | 612.47 | 610.51 | 612.06 | 475661.0 |
| 2025-12-19 09:30:00 | QQQ | ETF | 611.96 | 616.96 | 611.87 | 616.6501 | 8802231.0 |
| 2025-12-19 10:00:00 | QQQ | ETF | 616.65 | 617.62 | 614.38 | 615.4 | 4000413.0 |
| 2025-12-19 10:30:00 | QQQ | ETF | 615.4 | 616.49 | 614.48 | 614.815 | 2558291.0 |
| 2025-12-19 11:00:00 | QQQ | ETF | 614.8 | 616.65 | 614.24 | 616.2 | 2111868.0 |
| 2025-12-19 11:30:00 | QQQ | ETF | 616.21 | 616.74 | 615.09 | 615.34 | 1951920.0 |
| 2025-12-19 12:00:00 | QQQ | ETF | 615.36 | 617.09 | 615.28 | 616.96 | 2135351.0 |
| 2025-12-19 12:30:00 | QQQ | ETF | 616.97 | 617.5 | 616.56 | 617.04 | 1788828.0 |
> showing 50 of 44,443 rows — these rows as CSV