PREVIEW / etf_30min / 2025-12-30
file: by_date/etf_30min/2025/2025-12-30.parquet size: 1.1 MB rows: 45,269
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-30 04:00:00 | SPY | ETF | 687.93 | 688.11 | 687.83 | 688.1 | 28236.0 |
| 2025-12-30 04:30:00 | SPY | ETF | 688.11 | 688.13 | 687.77 | 687.92 | 5270.0 |
| 2025-12-30 05:00:00 | SPY | ETF | 688.03 | 688.03 | 687.8 | 687.94 | 2138.0 |
| 2025-12-30 05:30:00 | SPY | ETF | 687.92 | 687.95 | 687.62 | 687.66 | 4800.0 |
| 2025-12-30 06:00:00 | SPY | ETF | 687.66 | 687.68 | 687.24 | 687.28 | 3488.0 |
| 2025-12-30 06:30:00 | SPY | ETF | 687.32 | 687.92 | 687.3 | 687.85 | 7658.0 |
| 2025-12-30 07:00:00 | SPY | ETF | 687.8 | 688.13 | 687.76 | 687.84 | 42436.0 |
| 2025-12-30 07:30:00 | SPY | ETF | 687.85 | 687.95 | 687.5 | 687.7 | 37032.0 |
| 2025-12-30 08:00:00 | SPY | ETF | 687.69 | 688.16 | 686.92 | 687.8 | 214691.0 |
| 2025-12-30 08:30:00 | SPY | ETF | 687.8 | 687.8 | 687.33 | 687.75 | 102756.0 |
| 2025-12-30 09:00:00 | SPY | ETF | 687.76 | 687.82 | 687.39 | 687.42 | 83438.0 |
| 2025-12-30 09:30:00 | SPY | ETF | 687.45 | 688.53 | 686.88 | 688.09 | 4295571.0 |
| 2025-12-30 10:00:00 | SPY | ETF | 688.08 | 688.17 | 686.75 | 686.94 | 3150382.0 |
| 2025-12-30 10:30:00 | SPY | ETF | 686.94 | 687.73 | 686.58 | 687.6104 | 2482749.0 |
| 2025-12-30 11:00:00 | SPY | ETF | 687.6 | 688.555 | 687.51 | 688.2472 | 2643013.0 |
| 2025-12-30 11:30:00 | SPY | ETF | 688.24 | 688.27 | 687.2 | 687.23 | 2146884.0 |
| 2025-12-30 12:00:00 | SPY | ETF | 687.22 | 687.43 | 686.87 | 687.38 | 1881190.0 |
| 2025-12-30 12:30:00 | SPY | ETF | 687.38 | 687.71 | 687.195 | 687.635 | 1499554.0 |
| 2025-12-30 13:00:00 | SPY | ETF | 687.635 | 687.79 | 687.22 | 687.7692 | 1267263.0 |
| 2025-12-30 13:30:00 | SPY | ETF | 687.76 | 687.93 | 687.47 | 687.765 | 1212498.0 |
| 2025-12-30 14:00:00 | SPY | ETF | 687.76 | 687.87 | 687.42 | 687.81 | 2121728.0 |
| 2025-12-30 14:30:00 | SPY | ETF | 687.81 | 687.94 | 687.4 | 687.56 | 2046337.0 |
| 2025-12-30 15:00:00 | SPY | ETF | 687.56 | 687.73 | 687.04 | 687.51 | 2365975.0 |
| 2025-12-30 15:30:00 | SPY | ETF | 687.51 | 687.815 | 686.7 | 686.94 | 7277026.0 |
| 2025-12-30 16:00:00 | SPY | ETF | 686.95 | 687.14 | 686.77 | 686.97 | 1632329.0 |
| 2025-12-30 16:30:00 | SPY | ETF | 686.99 | 687.08 | 686.93 | 686.97 | 224291.0 |
| 2025-12-30 17:00:00 | SPY | ETF | 687.01 | 687.01 | 686.96 | 686.98 | 15367.0 |
| 2025-12-30 17:30:00 | SPY | ETF | 686.93 | 687.03 | 686.92 | 686.94 | 10860.0 |
| 2025-12-30 18:00:00 | SPY | ETF | 687.0 | 687.21 | 686.65 | 686.752 | 32168.0 |
| 2025-12-30 18:30:00 | SPY | ETF | 686.72 | 686.79 | 686.45 | 686.67 | 11260.0 |
| 2025-12-30 19:00:00 | SPY | ETF | 686.65 | 686.66 | 686.28 | 686.52 | 14878.0 |
| 2025-12-30 19:30:00 | SPY | ETF | 686.5 | 686.5 | 685.73 | 685.85 | 44230.0 |
| 2025-12-30 04:00:00 | QQQ | ETF | 620.87 | 621.22 | 620.73 | 621.22 | 24608.0 |
| 2025-12-30 04:30:00 | QQQ | ETF | 621.19 | 621.25 | 620.77 | 620.95 | 22129.0 |
| 2025-12-30 05:00:00 | QQQ | ETF | 620.97 | 621.12 | 620.86 | 621.01 | 6405.0 |
| 2025-12-30 05:30:00 | QQQ | ETF | 620.99 | 621.03 | 620.56 | 620.7 | 10035.0 |
| 2025-12-30 06:00:00 | QQQ | ETF | 620.62 | 620.7 | 620.12 | 620.21 | 14945.0 |
| 2025-12-30 06:30:00 | QQQ | ETF | 620.29 | 620.9 | 620.19 | 620.87 | 12228.0 |
| 2025-12-30 07:00:00 | QQQ | ETF | 620.82 | 621.08 | 620.64 | 620.75 | 22441.0 |
| 2025-12-30 07:30:00 | QQQ | ETF | 620.78 | 620.89 | 620.34 | 620.69 | 14821.0 |
| 2025-12-30 08:00:00 | QQQ | ETF | 620.64 | 621.24 | 619.67 | 620.82 | 93578.0 |
| 2025-12-30 08:30:00 | QQQ | ETF | 620.8001 | 620.84 | 619.82 | 620.34 | 151813.0 |
| 2025-12-30 09:00:00 | QQQ | ETF | 620.34 | 620.54 | 619.75 | 619.83 | 96118.0 |
| 2025-12-30 09:30:00 | QQQ | ETF | 619.84 | 621.75 | 619.38 | 621.32 | 3607559.0 |
| 2025-12-30 10:00:00 | QQQ | ETF | 621.3 | 621.42 | 619.59 | 619.945 | 2411680.0 |
| 2025-12-30 10:30:00 | QQQ | ETF | 619.94 | 621.24 | 619.58 | 621.02 | 2013415.0 |
| 2025-12-30 11:00:00 | QQQ | ETF | 621.03 | 622.18 | 620.9101 | 621.71 | 2108767.0 |
| 2025-12-30 11:30:00 | QQQ | ETF | 621.71 | 621.77 | 620.4 | 620.47 | 1560978.0 |
| 2025-12-30 12:00:00 | QQQ | ETF | 620.46 | 620.59 | 620.01 | 620.54 | 1317758.0 |
| 2025-12-30 12:30:00 | QQQ | ETF | 620.54 | 620.92 | 620.3 | 620.7 | 1198114.0 |
> showing 50 of 45,269 rows — these rows as CSV