PREVIEW / etf_30min / 2025-06-03
file: by_date/etf_30min/2025/2025-06-03.parquet size: 958 KB rows: 39,732
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-06-03 04:00:00 | SPY | ETF | 590.2 | 590.8 | 589.01 | 589.34 | 48547.0 |
| 2025-06-03 04:30:00 | SPY | ETF | 589.49 | 590.07 | 589.49 | 590.05 | 11514.0 |
| 2025-06-03 05:00:00 | SPY | ETF | 590.07 | 590.29 | 589.9 | 590.03 | 7879.0 |
| 2025-06-03 05:30:00 | SPY | ETF | 589.96 | 590.51 | 589.96 | 590.25 | 5929.0 |
| 2025-06-03 06:00:00 | SPY | ETF | 590.29 | 590.45 | 590.0 | 590.44 | 5936.0 |
| 2025-06-03 06:30:00 | SPY | ETF | 590.52 | 591.09 | 590.33 | 591.04 | 59456.0 |
| 2025-06-03 07:00:00 | SPY | ETF | 591.1 | 591.5 | 590.92 | 591.47 | 75470.0 |
| 2025-06-03 07:30:00 | SPY | ETF | 591.53 | 592.02 | 591.38 | 591.81 | 36972.0 |
| 2025-06-03 08:00:00 | SPY | ETF | 591.13 | 592.38 | 589.34 | 592.32 | 208146.0 |
| 2025-06-03 08:30:00 | SPY | ETF | 592.34 | 592.34 | 591.52 | 592.01 | 120885.0 |
| 2025-06-03 09:00:00 | SPY | ETF | 592.07 | 592.46 | 591.84 | 592.32 | 138670.0 |
| 2025-06-03 09:30:00 | SPY | ETF | 592.34 | 593.27 | 592.05 | 592.395 | 4282194.0 |
| 2025-06-03 10:00:00 | SPY | ETF | 592.47 | 593.9 | 591.85 | 593.895 | 3587044.0 |
| 2025-06-03 10:30:00 | SPY | ETF | 593.89 | 594.41 | 593.17 | 594.37 | 2845037.0 |
| 2025-06-03 11:00:00 | SPY | ETF | 594.37 | 595.16 | 594.36 | 594.97 | 3006949.0 |
| 2025-06-03 11:30:00 | SPY | ETF | 594.96 | 595.7 | 594.83 | 595.64 | 2662338.0 |
| 2025-06-03 12:00:00 | SPY | ETF | 595.64 | 596.2501 | 595.24 | 596.075 | 2458492.0 |
| 2025-06-03 12:30:00 | SPY | ETF | 596.08 | 596.67 | 596.02 | 596.5 | 2180272.0 |
| 2025-06-03 13:00:00 | SPY | ETF | 596.5 | 597.08 | 596.255 | 596.75 | 2127953.0 |
| 2025-06-03 13:30:00 | SPY | ETF | 596.77 | 596.97 | 596.06 | 596.11 | 2494149.0 |
| 2025-06-03 14:00:00 | SPY | ETF | 596.12 | 596.195 | 594.8001 | 596.15 | 4610020.0 |
| 2025-06-03 14:30:00 | SPY | ETF | 596.17 | 596.47 | 595.905 | 596.33 | 2349505.0 |
| 2025-06-03 15:00:00 | SPY | ETF | 596.34 | 596.51 | 595.78 | 596.26 | 3629932.0 |
| 2025-06-03 15:30:00 | SPY | ETF | 596.255 | 596.5 | 595.23 | 596.11 | 7763958.0 |
| 2025-06-03 16:00:00 | SPY | ETF | 596.11 | 596.14 | 595.51 | 595.64 | 2349958.0 |
| 2025-06-03 16:30:00 | SPY | ETF | 595.59 | 596.25 | 595.59 | 595.94 | 65700.0 |
| 2025-06-03 17:00:00 | SPY | ETF | 596.0 | 596.05 | 595.82 | 595.83 | 33187.0 |
| 2025-06-03 17:30:00 | SPY | ETF | 595.83 | 596.09 | 595.83 | 596.08 | 5848.0 |
| 2025-06-03 18:00:00 | SPY | ETF | 595.96 | 596.47 | 595.94 | 596.4402 | 44969.0 |
| 2025-06-03 18:30:00 | SPY | ETF | 596.43 | 596.6001 | 596.4103 | 596.5 | 24825.0 |
| 2025-06-03 19:00:00 | SPY | ETF | 596.37 | 596.56 | 596.05 | 596.54 | 25239.0 |
| 2025-06-03 19:30:00 | SPY | ETF | 596.54 | 596.5705 | 596.06 | 596.3017 | 29256.0 |
| 2025-06-03 04:00:00 | QQQ | ETF | 521.01 | 521.15 | 520.1 | 520.43 | 33308.0 |
| 2025-06-03 04:30:00 | QQQ | ETF | 520.58 | 521.25 | 520.58 | 521.12 | 8594.0 |
| 2025-06-03 05:00:00 | QQQ | ETF | 521.19 | 521.41 | 520.88 | 521.35 | 12034.0 |
| 2025-06-03 05:30:00 | QQQ | ETF | 521.19 | 521.63 | 521.04 | 521.27 | 11478.0 |
| 2025-06-03 06:00:00 | QQQ | ETF | 521.34 | 521.53 | 520.97 | 521.41 | 11073.0 |
| 2025-06-03 06:30:00 | QQQ | ETF | 521.48 | 522.35 | 521.45 | 522.34 | 62061.0 |
| 2025-06-03 07:00:00 | QQQ | ETF | 522.41 | 522.8 | 522.09 | 522.8 | 33203.0 |
| 2025-06-03 07:30:00 | QQQ | ETF | 522.77 | 523.31 | 522.61 | 523.161 | 52716.0 |
| 2025-06-03 08:00:00 | QQQ | ETF | 522.29 | 523.5 | 520.2 | 523.43 | 156253.0 |
| 2025-06-03 08:30:00 | QQQ | ETF | 523.45 | 523.45 | 522.58 | 523.32 | 99869.0 |
| 2025-06-03 09:00:00 | QQQ | ETF | 523.35 | 523.795 | 523.07 | 523.56 | 120007.0 |
| 2025-06-03 09:30:00 | QQQ | ETF | 523.58 | 525.039 | 522.69 | 524.79 | 3861667.0 |
| 2025-06-03 10:00:00 | QQQ | ETF | 524.75 | 525.81 | 523.86 | 525.415 | 2833793.0 |
| 2025-06-03 10:30:00 | QQQ | ETF | 525.41 | 526.39 | 524.52 | 526.355 | 2177234.0 |
| 2025-06-03 11:00:00 | QQQ | ETF | 526.35 | 526.97 | 526.16 | 526.6 | 2044312.0 |
| 2025-06-03 11:30:00 | QQQ | ETF | 526.62 | 527.0 | 526.22 | 526.9101 | 1804122.0 |
| 2025-06-03 12:00:00 | QQQ | ETF | 526.92 | 527.63 | 526.71 | 527.52 | 1911650.0 |
| 2025-06-03 12:30:00 | QQQ | ETF | 527.52 | 528.45 | 527.46 | 528.225 | 1714818.0 |
> showing 50 of 39,732 rows — these rows as CSV