PREVIEW / etf_30min / 2025-05-30
file: by_date/etf_30min/2025/2025-05-30.parquet size: 913 KB rows: 37,938
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-05-30 04:00:00 | SPY | ETF | 589.13 | 589.8 | 589.13 | 589.29 | 12818.0 |
| 2025-05-30 04:30:00 | SPY | ETF | 589.22 | 589.49 | 588.86 | 589.05 | 3917.0 |
| 2025-05-30 05:00:00 | SPY | ETF | 588.98 | 589.62 | 588.98 | 589.6 | 8114.0 |
| 2025-05-30 05:30:00 | SPY | ETF | 589.6 | 589.69 | 589.01 | 589.01 | 8633.0 |
| 2025-05-30 06:00:00 | SPY | ETF | 588.79 | 589.41 | 588.67 | 589.41 | 9042.0 |
| 2025-05-30 06:30:00 | SPY | ETF | 589.5 | 589.55 | 589.18 | 589.28 | 2802.0 |
| 2025-05-30 07:00:00 | SPY | ETF | 589.44 | 590.1 | 589.35 | 589.69 | 51751.0 |
| 2025-05-30 07:30:00 | SPY | ETF | 589.72 | 589.78 | 589.28 | 589.34 | 53205.0 |
| 2025-05-30 08:00:00 | SPY | ETF | 589.62 | 590.12 | 585.582 | 586.95 | 1108222.0 |
| 2025-05-30 08:30:00 | SPY | ETF | 587.0 | 589.13 | 587.0 | 587.73 | 380345.0 |
| 2025-05-30 09:00:00 | SPY | ETF | 587.79 | 588.95 | 587.47 | 588.91 | 283757.0 |
| 2025-05-30 09:30:00 | SPY | ETF | 588.91 | 589.11 | 586.4 | 587.09 | 4764342.0 |
| 2025-05-30 10:00:00 | SPY | ETF | 587.01 | 589.86 | 587.01 | 589.6 | 3680389.0 |
| 2025-05-30 10:30:00 | SPY | ETF | 589.59 | 589.92 | 588.44 | 588.69 | 2313103.0 |
| 2025-05-30 11:00:00 | SPY | ETF | 588.71 | 589.37 | 588.04 | 589.1254 | 1688251.0 |
| 2025-05-30 11:30:00 | SPY | ETF | 589.13 | 589.37 | 587.34 | 587.98 | 2240244.0 |
| 2025-05-30 12:00:00 | SPY | ETF | 588.01 | 588.65 | 584.68 | 585.085 | 4475305.0 |
| 2025-05-30 12:30:00 | SPY | ETF | 585.07 | 585.5 | 583.235 | 584.405 | 6358875.0 |
| 2025-05-30 13:00:00 | SPY | ETF | 584.385 | 586.06 | 583.99 | 585.895 | 2789846.0 |
| 2025-05-30 13:30:00 | SPY | ETF | 585.89 | 586.69 | 585.54 | 585.86 | 2411452.0 |
| 2025-05-30 14:00:00 | SPY | ETF | 585.86 | 588.72 | 585.82 | 588.26 | 4592830.0 |
| 2025-05-30 14:30:00 | SPY | ETF | 588.27 | 588.8698 | 587.76 | 588.68 | 2160614.0 |
| 2025-05-30 15:00:00 | SPY | ETF | 588.67 | 590.95 | 588.58 | 590.64 | 3759787.0 |
| 2025-05-30 15:30:00 | SPY | ETF | 590.65 | 591.1299 | 589.22 | 589.47 | 15125467.0 |
| 2025-05-30 16:00:00 | SPY | ETF | 589.47 | 590.44 | 588.53 | 589.3 | 4094839.0 |
| 2025-05-30 16:30:00 | SPY | ETF | 589.2 | 589.39 | 588.95 | 589.28 | 162062.0 |
| 2025-05-30 17:00:00 | SPY | ETF | 589.3 | 589.3 | 588.85 | 589.1 | 36663.0 |
| 2025-05-30 17:30:00 | SPY | ETF | 589.0 | 589.4609 | 588.81 | 589.4609 | 21685.0 |
| 2025-05-30 18:00:00 | SPY | ETF | 589.49 | 589.5 | 588.629 | 588.629 | 74531.0 |
| 2025-05-30 18:30:00 | SPY | ETF | 588.63 | 588.63 | 588.11 | 588.22 | 29225.0 |
| 2025-05-30 19:00:00 | SPY | ETF | 588.25 | 588.39 | 587.24 | 588.24 | 34037.0 |
| 2025-05-30 19:30:00 | SPY | ETF | 588.23 | 588.4999 | 588.15 | 588.4009 | 17302.0 |
| 2025-05-30 04:00:00 | QQQ | ETF | 518.96 | 519.75 | 518.94 | 519.22 | 24301.0 |
| 2025-05-30 04:30:00 | QQQ | ETF | 519.2 | 519.44 | 518.74 | 518.92 | 13459.0 |
| 2025-05-30 05:00:00 | QQQ | ETF | 518.88 | 519.65 | 518.88 | 519.48 | 28159.0 |
| 2025-05-30 05:30:00 | QQQ | ETF | 519.45 | 519.72 | 518.96 | 518.96 | 22789.0 |
| 2025-05-30 06:00:00 | QQQ | ETF | 518.89 | 519.42 | 518.75 | 519.34 | 18906.0 |
| 2025-05-30 06:30:00 | QQQ | ETF | 519.32 | 519.62 | 519.2 | 519.31 | 22159.0 |
| 2025-05-30 07:00:00 | QQQ | ETF | 519.49 | 520.4 | 519.37 | 519.82 | 38600.0 |
| 2025-05-30 07:30:00 | QQQ | ETF | 519.78 | 519.95 | 519.57 | 519.64 | 48927.0 |
| 2025-05-30 08:00:00 | QQQ | ETF | 519.51 | 520.38 | 515.7 | 517.4 | 670627.0 |
| 2025-05-30 08:30:00 | QQQ | ETF | 517.35 | 519.16 | 517.32 | 518.33 | 489371.0 |
| 2025-05-30 09:00:00 | QQQ | ETF | 518.3604 | 519.53 | 517.89 | 519.43 | 288871.0 |
| 2025-05-30 09:30:00 | QQQ | ETF | 519.44 | 519.66 | 515.89 | 516.47 | 4110907.0 |
| 2025-05-30 10:00:00 | QQQ | ETF | 516.46 | 519.68 | 516.4 | 519.5 | 3444557.0 |
| 2025-05-30 10:30:00 | QQQ | ETF | 519.49 | 519.86 | 518.56 | 518.79 | 2593711.0 |
| 2025-05-30 11:00:00 | QQQ | ETF | 518.8 | 519.34 | 517.91 | 519.09 | 2124734.0 |
| 2025-05-30 11:30:00 | QQQ | ETF | 519.09 | 519.35 | 517.16 | 518.005 | 2552483.0 |
| 2025-05-30 12:00:00 | QQQ | ETF | 518.02 | 518.33 | 514.07 | 514.44 | 2925493.0 |
| 2025-05-30 12:30:00 | QQQ | ETF | 514.43 | 514.51 | 511.93 | 512.85 | 5111982.0 |
> showing 50 of 37,938 rows — these rows as CSV