PREVIEW / etf_30min / 2025-12-23
file: by_date/etf_30min/2025/2025-12-23.parquet size: 1.1 MB rows: 44,978
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-23 04:00:00 | SPY | ETF | 684.85 | 685.3 | 684.84 | 685.3 | 19499.0 |
| 2025-12-23 04:30:00 | SPY | ETF | 685.3 | 685.55 | 685.3 | 685.46 | 32195.0 |
| 2025-12-23 05:00:00 | SPY | ETF | 685.49 | 685.57 | 685.1 | 685.22 | 10377.0 |
| 2025-12-23 05:30:00 | SPY | ETF | 685.27 | 685.28 | 685.05 | 685.21 | 5461.0 |
| 2025-12-23 06:00:00 | SPY | ETF | 685.2 | 685.26 | 684.91 | 685.07 | 7787.0 |
| 2025-12-23 06:30:00 | SPY | ETF | 685.04 | 685.17 | 684.9 | 684.98 | 21889.0 |
| 2025-12-23 07:00:00 | SPY | ETF | 684.93 | 685.08 | 684.49 | 684.54 | 12638.0 |
| 2025-12-23 07:30:00 | SPY | ETF | 684.5 | 684.77 | 684.37 | 684.77 | 14593.0 |
| 2025-12-23 08:00:00 | SPY | ETF | 684.98 | 685.56 | 684.17 | 684.61 | 107862.0 |
| 2025-12-23 08:30:00 | SPY | ETF | 684.67 | 684.79 | 683.32 | 683.57 | 341868.0 |
| 2025-12-23 09:00:00 | SPY | ETF | 683.55 | 683.92 | 683.37 | 683.92 | 161189.0 |
| 2025-12-23 09:30:00 | SPY | ETF | 683.93 | 686.25 | 683.87 | 685.41 | 5647912.0 |
| 2025-12-23 10:00:00 | SPY | ETF | 685.4101 | 685.565 | 684.36 | 685.24 | 4420261.0 |
| 2025-12-23 10:30:00 | SPY | ETF | 685.24 | 686.485 | 685.2303 | 686.32 | 3558913.0 |
| 2025-12-23 11:00:00 | SPY | ETF | 686.33 | 686.74 | 686.255 | 686.492 | 3292255.0 |
| 2025-12-23 11:30:00 | SPY | ETF | 686.495 | 687.0088 | 686.36 | 686.89 | 2420362.0 |
| 2025-12-23 12:00:00 | SPY | ETF | 686.9 | 687.22 | 686.66 | 687.07 | 2587026.0 |
| 2025-12-23 12:30:00 | SPY | ETF | 687.06 | 687.1997 | 686.79 | 686.985 | 2348997.0 |
| 2025-12-23 13:00:00 | SPY | ETF | 686.99 | 687.7299 | 686.92 | 687.545 | 2847681.0 |
| 2025-12-23 13:30:00 | SPY | ETF | 687.55 | 687.7 | 687.51 | 687.53 | 2090707.0 |
| 2025-12-23 14:00:00 | SPY | ETF | 687.53 | 687.92 | 687.495 | 687.875 | 2793914.0 |
| 2025-12-23 14:30:00 | SPY | ETF | 687.87 | 687.93 | 687.71 | 687.835 | 2194510.0 |
| 2025-12-23 15:00:00 | SPY | ETF | 687.835 | 688.03 | 687.775 | 687.85 | 3667251.0 |
| 2025-12-23 15:30:00 | SPY | ETF | 687.84 | 688.2 | 687.64 | 687.91 | 8166067.0 |
| 2025-12-23 16:00:00 | SPY | ETF | 687.92 | 688.05 | 687.65 | 687.7296 | 2832528.0 |
| 2025-12-23 16:30:00 | SPY | ETF | 687.71 | 687.78 | 687.57 | 687.7 | 96494.0 |
| 2025-12-23 17:00:00 | SPY | ETF | 687.659 | 687.7 | 687.6164 | 687.64 | 26927.0 |
| 2025-12-23 17:30:00 | SPY | ETF | 687.64 | 687.96 | 687.5413 | 687.68 | 169749.0 |
| 2025-12-23 18:00:00 | SPY | ETF | 687.68 | 687.75 | 687.5 | 687.52 | 34279.0 |
| 2025-12-23 18:30:00 | SPY | ETF | 687.51 | 687.65 | 687.44 | 687.63 | 42708.0 |
| 2025-12-23 19:00:00 | SPY | ETF | 687.6411 | 687.8 | 687.6411 | 687.6886 | 8496.0 |
| 2025-12-23 19:30:00 | SPY | ETF | 687.6492 | 687.74 | 687.59 | 687.6757 | 9691.0 |
| 2025-12-23 04:00:00 | QQQ | ETF | 619.35 | 619.96 | 619.27 | 619.93 | 43739.0 |
| 2025-12-23 04:30:00 | QQQ | ETF | 619.92 | 620.18 | 619.92 | 619.93 | 21548.0 |
| 2025-12-23 05:00:00 | QQQ | ETF | 619.99 | 620.1 | 619.51 | 619.65 | 40747.0 |
| 2025-12-23 05:30:00 | QQQ | ETF | 619.68 | 619.76 | 619.5 | 619.76 | 48320.0 |
| 2025-12-23 06:00:00 | QQQ | ETF | 619.68 | 619.72 | 619.19 | 619.46 | 44975.0 |
| 2025-12-23 06:30:00 | QQQ | ETF | 619.42 | 619.61 | 619.28 | 619.28 | 24302.0 |
| 2025-12-23 07:00:00 | QQQ | ETF | 619.33 | 619.52 | 618.68 | 618.7 | 39531.0 |
| 2025-12-23 07:30:00 | QQQ | ETF | 618.66 | 619.18 | 618.59 | 619.18 | 21858.0 |
| 2025-12-23 08:00:00 | QQQ | ETF | 619.21 | 620.17 | 618.45 | 618.84 | 136880.0 |
| 2025-12-23 08:30:00 | QQQ | ETF | 618.81 | 619.0 | 617.35 | 617.64 | 328533.0 |
| 2025-12-23 09:00:00 | QQQ | ETF | 617.63 | 618.25 | 617.39 | 618.2 | 261123.0 |
| 2025-12-23 09:30:00 | QQQ | ETF | 618.2 | 620.715 | 618.05 | 619.3101 | 5726368.0 |
| 2025-12-23 10:00:00 | QQQ | ETF | 619.33 | 619.37 | 617.78 | 618.8988 | 2957847.0 |
| 2025-12-23 10:30:00 | QQQ | ETF | 618.89 | 620.48 | 618.87 | 620.23 | 2534844.0 |
| 2025-12-23 11:00:00 | QQQ | ETF | 620.25 | 620.75 | 620.14 | 620.52 | 1985040.0 |
| 2025-12-23 11:30:00 | QQQ | ETF | 620.52 | 621.31 | 620.24 | 621.23 | 2104141.0 |
| 2025-12-23 12:00:00 | QQQ | ETF | 621.24 | 621.33 | 620.95 | 621.07 | 1614024.0 |
| 2025-12-23 12:30:00 | QQQ | ETF | 621.07 | 621.22 | 620.69 | 620.7876 | 1383168.0 |
> showing 50 of 44,978 rows — these rows as CSV