PREVIEW / etf_30min / 2025-11-06
file: by_date/etf_30min/2025/2025-11-06.parquet size: 1.1 MB rows: 45,352
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-06 04:00:00 | SPY | ETF | 676.9 | 677.86 | 676.5 | 677.76 | 32866.0 |
| 2025-11-06 04:30:00 | SPY | ETF | 677.81 | 678.03 | 677.46 | 677.62 | 13121.0 |
| 2025-11-06 05:00:00 | SPY | ETF | 677.71 | 678.41 | 677.54 | 678.38 | 32781.0 |
| 2025-11-06 05:30:00 | SPY | ETF | 678.26 | 678.56 | 678.05 | 678.16 | 25766.0 |
| 2025-11-06 06:00:00 | SPY | ETF | 678.09 | 678.49 | 678.02 | 678.3 | 10975.0 |
| 2025-11-06 06:30:00 | SPY | ETF | 678.45 | 678.59 | 677.98 | 678.08 | 24436.0 |
| 2025-11-06 07:00:00 | SPY | ETF | 678.06 | 679.0 | 678.06 | 678.62 | 66226.0 |
| 2025-11-06 07:30:00 | SPY | ETF | 678.64 | 679.01 | 678.59 | 678.85 | 56544.0 |
| 2025-11-06 08:00:00 | SPY | ETF | 678.82 | 679.37 | 675.74 | 679.35 | 258876.0 |
| 2025-11-06 08:30:00 | SPY | ETF | 679.3402 | 679.57 | 678.34 | 678.399 | 131547.0 |
| 2025-11-06 09:00:00 | SPY | ETF | 678.45 | 678.6 | 676.3 | 676.46 | 388949.0 |
| 2025-11-06 09:30:00 | SPY | ETF | 676.47 | 677.38 | 674.09 | 674.1404 | 6328170.0 |
| 2025-11-06 10:00:00 | SPY | ETF | 674.13 | 675.37 | 672.52 | 674.5399 | 7341098.0 |
| 2025-11-06 10:30:00 | SPY | ETF | 674.54 | 674.67 | 670.76 | 670.95 | 7022327.0 |
| 2025-11-06 11:00:00 | SPY | ETF | 670.93 | 672.02 | 670.22 | 671.41 | 4325619.0 |
| 2025-11-06 11:30:00 | SPY | ETF | 671.41 | 671.41 | 669.01 | 669.24 | 3817971.0 |
| 2025-11-06 12:00:00 | SPY | ETF | 669.24 | 671.13 | 668.72 | 669.585 | 3795926.0 |
| 2025-11-06 12:30:00 | SPY | ETF | 669.58 | 671.58 | 669.28 | 671.13 | 3239315.0 |
| 2025-11-06 13:00:00 | SPY | ETF | 671.1 | 671.44 | 669.13 | 670.96 | 3528287.0 |
| 2025-11-06 13:30:00 | SPY | ETF | 670.94 | 672.21 | 670.91 | 671.5 | 2459540.0 |
| 2025-11-06 14:00:00 | SPY | ETF | 671.51 | 673.525 | 671.28 | 673.4 | 3354184.0 |
| 2025-11-06 14:30:00 | SPY | ETF | 673.39 | 673.7 | 672.03 | 672.99 | 3878749.0 |
| 2025-11-06 15:00:00 | SPY | ETF | 672.98 | 673.35 | 672.24 | 672.32 | 3177592.0 |
| 2025-11-06 15:30:00 | SPY | ETF | 672.31 | 672.72 | 669.53 | 670.27 | 11771854.0 |
| 2025-11-06 16:00:00 | SPY | ETF | 670.25 | 672.18 | 670.11 | 671.15 | 3192276.0 |
| 2025-11-06 16:30:00 | SPY | ETF | 671.14 | 671.95 | 670.31 | 671.8 | 252111.0 |
| 2025-11-06 17:00:00 | SPY | ETF | 671.68 | 672.03 | 671.6 | 671.8 | 104651.0 |
| 2025-11-06 17:30:00 | SPY | ETF | 671.74 | 671.78 | 671.54 | 671.55 | 45260.0 |
| 2025-11-06 18:00:00 | SPY | ETF | 671.55 | 671.74 | 670.92 | 671.629 | 142143.0 |
| 2025-11-06 18:30:00 | SPY | ETF | 671.65 | 672.1846 | 671.3906 | 671.81 | 29895.0 |
| 2025-11-06 19:00:00 | SPY | ETF | 671.77 | 672.32 | 671.1 | 671.8 | 97910.0 |
| 2025-11-06 19:30:00 | SPY | ETF | 671.9 | 672.41 | 671.8754 | 671.92 | 58792.0 |
| 2025-11-06 04:00:00 | QQQ | ETF | 621.75 | 623.42 | 621.74 | 623.32 | 78420.0 |
| 2025-11-06 04:30:00 | QQQ | ETF | 623.31 | 623.59 | 622.82 | 623.12 | 104722.0 |
| 2025-11-06 05:00:00 | QQQ | ETF | 623.15 | 624.19 | 623.09 | 624.15 | 74885.0 |
| 2025-11-06 05:30:00 | QQQ | ETF | 624.11 | 624.34 | 623.5 | 623.74 | 127010.0 |
| 2025-11-06 06:00:00 | QQQ | ETF | 623.73 | 624.21 | 623.5 | 624.14 | 85375.0 |
| 2025-11-06 06:30:00 | QQQ | ETF | 624.16 | 624.28 | 623.62 | 623.62 | 84787.0 |
| 2025-11-06 07:00:00 | QQQ | ETF | 623.61 | 624.6 | 623.61 | 624.2 | 177257.0 |
| 2025-11-06 07:30:00 | QQQ | ETF | 624.21 | 624.67 | 624.21 | 624.37 | 109996.0 |
| 2025-11-06 08:00:00 | QQQ | ETF | 623.85 | 625.19 | 620.76 | 625.17 | 288299.0 |
| 2025-11-06 08:30:00 | QQQ | ETF | 625.16 | 625.37 | 623.94 | 624.06 | 186939.0 |
| 2025-11-06 09:00:00 | QQQ | ETF | 624.08 | 624.23 | 621.6 | 621.79 | 540232.0 |
| 2025-11-06 09:30:00 | QQQ | ETF | 621.79 | 622.04 | 617.81 | 617.905 | 6768908.0 |
| 2025-11-06 10:00:00 | QQQ | ETF | 617.89 | 618.68 | 615.3 | 617.72 | 6964303.0 |
| 2025-11-06 10:30:00 | QQQ | ETF | 617.73 | 617.92 | 612.53 | 612.83 | 6078247.0 |
| 2025-11-06 11:00:00 | QQQ | ETF | 612.81 | 614.46 | 612.21 | 613.57 | 3763537.0 |
| 2025-11-06 11:30:00 | QQQ | ETF | 613.54 | 613.55 | 610.37 | 610.84 | 4837544.0 |
| 2025-11-06 12:00:00 | QQQ | ETF | 610.84 | 612.97 | 610.3 | 611.45 | 3503767.0 |
| 2025-11-06 12:30:00 | QQQ | ETF | 611.42 | 614.15 | 611.08 | 613.69 | 3249398.0 |
> showing 50 of 45,352 rows — these rows as CSV