PREVIEW / etf_30min / 2025-11-05
file: by_date/etf_30min/2025/2025-11-05.parquet size: 1.1 MB rows: 44,568
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-05 04:00:00 | SPY | ETF | 674.37 | 675.27 | 673.87 | 674.61 | 31331.0 |
| 2025-11-05 04:30:00 | SPY | ETF | 674.59 | 674.68 | 673.98 | 674.54 | 23016.0 |
| 2025-11-05 05:00:00 | SPY | ETF | 674.28 | 675.03 | 674.06 | 674.17 | 18720.0 |
| 2025-11-05 05:30:00 | SPY | ETF | 674.0 | 674.21 | 672.56 | 672.6 | 24514.0 |
| 2025-11-05 06:00:00 | SPY | ETF | 672.55 | 673.75 | 672.42 | 673.44 | 35532.0 |
| 2025-11-05 06:30:00 | SPY | ETF | 673.44 | 674.11 | 673.17 | 673.82 | 22601.0 |
| 2025-11-05 07:00:00 | SPY | ETF | 673.9 | 674.51 | 673.47 | 674.29 | 38195.0 |
| 2025-11-05 07:30:00 | SPY | ETF | 674.13 | 674.86 | 674.1 | 674.8 | 164202.0 |
| 2025-11-05 08:00:00 | SPY | ETF | 674.74 | 675.35 | 672.52 | 675.3219 | 287812.0 |
| 2025-11-05 08:30:00 | SPY | ETF | 675.23 | 675.91 | 674.91 | 675.72 | 297410.0 |
| 2025-11-05 09:00:00 | SPY | ETF | 675.71 | 675.72 | 674.93 | 675.01 | 216061.0 |
| 2025-11-05 09:30:00 | SPY | ETF | 674.98 | 677.6 | 674.17 | 677.28 | 6868191.0 |
| 2025-11-05 10:00:00 | SPY | ETF | 677.1 | 678.09 | 675.4 | 677.44 | 6165722.0 |
| 2025-11-05 10:30:00 | SPY | ETF | 677.435 | 678.2782 | 676.95 | 677.87 | 3202846.0 |
| 2025-11-05 11:00:00 | SPY | ETF | 677.88 | 678.3985 | 676.76 | 678.29 | 3205653.0 |
| 2025-11-05 11:30:00 | SPY | ETF | 678.27 | 679.75 | 678.085 | 679.38 | 3547531.0 |
| 2025-11-05 12:00:00 | SPY | ETF | 679.37 | 680.1 | 679.03 | 680.0459 | 2387393.0 |
| 2025-11-05 12:30:00 | SPY | ETF | 680.05 | 680.8599 | 679.94 | 680.22 | 2786554.0 |
| 2025-11-05 13:00:00 | SPY | ETF | 680.21 | 680.7085 | 680.0199 | 680.41 | 1870809.0 |
| 2025-11-05 13:30:00 | SPY | ETF | 680.4 | 680.86 | 680.23 | 680.658 | 1671922.0 |
| 2025-11-05 14:00:00 | SPY | ETF | 680.64 | 680.64 | 679.74 | 680.21 | 2558751.0 |
| 2025-11-05 14:30:00 | SPY | ETF | 680.21 | 680.52 | 680.1 | 680.23 | 1791388.0 |
| 2025-11-05 15:00:00 | SPY | ETF | 680.23 | 680.52 | 679.67 | 679.76 | 2810661.0 |
| 2025-11-05 15:30:00 | SPY | ETF | 679.76 | 679.865 | 677.4 | 677.51 | 11461416.0 |
| 2025-11-05 16:00:00 | SPY | ETF | 677.5 | 678.18 | 677.11 | 677.74 | 3252978.0 |
| 2025-11-05 16:30:00 | SPY | ETF | 677.74 | 678.07 | 677.74 | 677.83 | 146496.0 |
| 2025-11-05 17:00:00 | SPY | ETF | 677.9055 | 678.04 | 677.755 | 677.8632 | 62647.0 |
| 2025-11-05 17:30:00 | SPY | ETF | 677.8612 | 678.07 | 677.71 | 678.06 | 35395.0 |
| 2025-11-05 18:00:00 | SPY | ETF | 678.06 | 678.1 | 677.27 | 677.71 | 339032.0 |
| 2025-11-05 18:30:00 | SPY | ETF | 677.74 | 678.59 | 677.64 | 678.58 | 95489.0 |
| 2025-11-05 19:00:00 | SPY | ETF | 678.58 | 678.58 | 676.24 | 676.57 | 88734.0 |
| 2025-11-05 19:30:00 | SPY | ETF | 676.73 | 677.44 | 676.73 | 677.2799 | 43676.0 |
| 2025-11-05 04:00:00 | QQQ | ETF | 615.84 | 618.73 | 615.84 | 617.89 | 121459.0 |
| 2025-11-05 04:30:00 | QQQ | ETF | 617.84 | 618.14 | 617.05 | 617.89 | 101681.0 |
| 2025-11-05 05:00:00 | QQQ | ETF | 617.96 | 618.41 | 617.32 | 617.41 | 103873.0 |
| 2025-11-05 05:30:00 | QQQ | ETF | 617.34 | 617.41 | 615.38 | 615.47 | 126015.0 |
| 2025-11-05 06:00:00 | QQQ | ETF | 615.4 | 616.75 | 615.25 | 616.28 | 88132.0 |
| 2025-11-05 06:30:00 | QQQ | ETF | 616.22 | 617.14 | 615.94 | 617.07 | 80570.0 |
| 2025-11-05 07:00:00 | QQQ | ETF | 617.05 | 618.03 | 616.53 | 617.65 | 142001.0 |
| 2025-11-05 07:30:00 | QQQ | ETF | 617.62 | 618.4 | 617.56 | 618.23 | 207091.0 |
| 2025-11-05 08:00:00 | QQQ | ETF | 616.47 | 619.05 | 615.43 | 619.0 | 524943.0 |
| 2025-11-05 08:30:00 | QQQ | ETF | 618.96 | 619.83 | 618.48 | 619.62 | 576399.0 |
| 2025-11-05 09:00:00 | QQQ | ETF | 619.62 | 619.66 | 618.2 | 618.51 | 483621.0 |
| 2025-11-05 09:30:00 | QQQ | ETF | 618.5 | 622.13 | 617.21 | 621.98 | 5973458.0 |
| 2025-11-05 10:00:00 | QQQ | ETF | 621.94 | 622.74 | 620.34 | 622.04 | 4770613.0 |
| 2025-11-05 10:30:00 | QQQ | ETF | 622.04 | 623.19 | 621.7 | 622.81 | 2795993.0 |
| 2025-11-05 11:00:00 | QQQ | ETF | 622.82 | 623.46 | 621.33 | 623.35 | 2700779.0 |
| 2025-11-05 11:30:00 | QQQ | ETF | 623.35 | 624.43 | 623.0 | 624.1 | 2051972.0 |
| 2025-11-05 12:00:00 | QQQ | ETF | 624.09 | 624.64 | 623.29 | 624.45 | 1454764.0 |
| 2025-11-05 12:30:00 | QQQ | ETF | 624.45 | 625.41 | 624.36 | 625.02 | 1481939.0 |
> showing 50 of 44,568 rows — these rows as CSV