PREVIEW / etf_30min / 2025-12-12
file: by_date/etf_30min/2025/2025-12-12.parquet size: 1.1 MB rows: 45,085
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-12 04:00:00 | SPY | ETF | 688.65 | 689.65 | 688.36 | 688.36 | 115528.0 |
| 2025-12-12 04:30:00 | SPY | ETF | 688.38 | 688.39 | 687.82 | 688.36 | 119552.0 |
| 2025-12-12 05:00:00 | SPY | ETF | 688.3 | 688.83 | 688.17 | 688.21 | 13366.0 |
| 2025-12-12 05:30:00 | SPY | ETF | 688.21 | 688.5 | 687.81 | 688.41 | 13473.0 |
| 2025-12-12 06:00:00 | SPY | ETF | 688.39 | 688.67 | 688.14 | 688.29 | 35553.0 |
| 2025-12-12 06:30:00 | SPY | ETF | 688.32 | 688.47 | 687.6 | 687.83 | 19382.0 |
| 2025-12-12 07:00:00 | SPY | ETF | 687.9 | 688.7 | 687.55 | 688.38 | 151392.0 |
| 2025-12-12 07:30:00 | SPY | ETF | 688.29 | 688.75 | 687.95 | 688.28 | 119658.0 |
| 2025-12-12 08:00:00 | SPY | ETF | 687.63 | 689.86 | 687.63 | 688.79 | 154643.0 |
| 2025-12-12 08:30:00 | SPY | ETF | 688.82 | 689.4 | 688.5709 | 689.39 | 186922.0 |
| 2025-12-12 09:00:00 | SPY | ETF | 689.3936 | 689.45 | 688.15 | 688.18 | 291959.0 |
| 2025-12-12 09:30:00 | SPY | ETF | 688.17 | 688.88 | 687.17 | 687.49 | 6301562.0 |
| 2025-12-12 10:00:00 | SPY | ETF | 687.46 | 687.54 | 683.63 | 683.75 | 8238601.0 |
| 2025-12-12 10:30:00 | SPY | ETF | 683.75 | 685.61 | 681.31 | 681.72 | 9220355.0 |
| 2025-12-12 11:00:00 | SPY | ETF | 681.72 | 682.46 | 679.7 | 681.27 | 10237548.0 |
| 2025-12-12 11:30:00 | SPY | ETF | 681.27 | 681.29 | 679.1744 | 680.5994 | 5403393.0 |
| 2025-12-12 12:00:00 | SPY | ETF | 680.59 | 683.02 | 680.33 | 681.46 | 4360356.0 |
| 2025-12-12 12:30:00 | SPY | ETF | 681.44 | 683.24 | 680.945 | 682.67 | 2993403.0 |
| 2025-12-12 13:00:00 | SPY | ETF | 682.68 | 684.34 | 682.38 | 683.88 | 4051454.0 |
| 2025-12-12 13:30:00 | SPY | ETF | 683.88 | 683.9 | 682.47 | 682.55 | 2650298.0 |
| 2025-12-12 14:00:00 | SPY | ETF | 682.56 | 682.67 | 681.21 | 681.475 | 4522280.0 |
| 2025-12-12 14:30:00 | SPY | ETF | 681.49 | 682.27 | 681.46 | 681.9699 | 3241195.0 |
| 2025-12-12 15:00:00 | SPY | ETF | 681.96 | 682.515 | 681.1 | 681.36 | 4643097.0 |
| 2025-12-12 15:30:00 | SPY | ETF | 681.3698 | 681.87 | 680.07 | 681.72 | 12988226.0 |
| 2025-12-12 16:00:00 | SPY | ETF | 681.73 | 682.28 | 681.61 | 681.96 | 3753823.0 |
| 2025-12-12 16:30:00 | SPY | ETF | 681.97 | 682.17 | 681.9 | 681.97 | 405862.0 |
| 2025-12-12 17:00:00 | SPY | ETF | 681.9514 | 682.0401 | 681.93 | 682.0 | 40312.0 |
| 2025-12-12 17:30:00 | SPY | ETF | 682.0 | 682.2 | 682.0 | 682.0 | 11239.0 |
| 2025-12-12 18:00:00 | SPY | ETF | 682.0 | 682.13 | 681.88 | 681.88 | 27750.0 |
| 2025-12-12 18:30:00 | SPY | ETF | 681.8705 | 681.95 | 681.76 | 681.95 | 17212.0 |
| 2025-12-12 19:00:00 | SPY | ETF | 681.92 | 681.95 | 681.76 | 681.76 | 9214.0 |
| 2025-12-12 19:30:00 | SPY | ETF | 681.76 | 681.89 | 681.76 | 681.8874 | 13330.0 |
| 2025-12-12 04:00:00 | QQQ | ETF | 624.0 | 624.7 | 618.29 | 622.85 | 73653.0 |
| 2025-12-12 04:30:00 | QQQ | ETF | 622.86 | 622.93 | 622.13 | 622.75 | 64572.0 |
| 2025-12-12 05:00:00 | QQQ | ETF | 622.7 | 623.57 | 622.57 | 622.74 | 23457.0 |
| 2025-12-12 05:30:00 | QQQ | ETF | 622.66 | 622.81 | 622.23 | 622.64 | 22881.0 |
| 2025-12-12 06:00:00 | QQQ | ETF | 622.65 | 622.72 | 622.2 | 622.35 | 18141.0 |
| 2025-12-12 06:30:00 | QQQ | ETF | 622.47 | 622.61 | 621.45 | 621.87 | 65807.0 |
| 2025-12-12 07:00:00 | QQQ | ETF | 621.93 | 622.66 | 621.61 | 622.54 | 106678.0 |
| 2025-12-12 07:30:00 | QQQ | ETF | 622.45 | 622.97 | 621.88 | 622.28 | 138290.0 |
| 2025-12-12 08:00:00 | QQQ | ETF | 621.83 | 626.049 | 621.56 | 622.75 | 247010.0 |
| 2025-12-12 08:30:00 | QQQ | ETF | 622.8 | 623.68 | 622.5 | 623.68 | 255255.0 |
| 2025-12-12 09:00:00 | QQQ | ETF | 623.66 | 623.81 | 622.02 | 622.08 | 265076.0 |
| 2025-12-12 09:30:00 | QQQ | ETF | 622.08 | 623.54 | 620.64 | 622.01 | 8348919.0 |
| 2025-12-12 10:00:00 | QQQ | ETF | 621.995 | 622.06 | 616.155 | 616.27 | 6880655.0 |
| 2025-12-12 10:30:00 | QQQ | ETF | 616.26 | 618.25 | 613.72 | 614.33 | 6348938.0 |
| 2025-12-12 11:00:00 | QQQ | ETF | 614.3 | 615.22 | 611.74 | 613.94 | 7005789.0 |
| 2025-12-12 11:30:00 | QQQ | ETF | 613.9306 | 613.96 | 611.36 | 612.76 | 4992495.0 |
| 2025-12-12 12:00:00 | QQQ | ETF | 612.74 | 615.78 | 612.44 | 613.89 | 4380930.0 |
| 2025-12-12 12:30:00 | QQQ | ETF | 613.89 | 616.02 | 613.18 | 615.22 | 2808603.0 |
> showing 50 of 45,085 rows — these rows as CSV