PREVIEW / etf_30min / 2025-12-05
file: by_date/etf_30min/2025/2025-12-05.parquet size: 1.1 MB rows: 43,783
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-05 04:00:00 | SPY | ETF | 685.3 | 686.06 | 685.3 | 686.03 | 16291.0 |
| 2025-12-05 04:30:00 | SPY | ETF | 686.04 | 686.04 | 685.62 | 685.81 | 8730.0 |
| 2025-12-05 05:00:00 | SPY | ETF | 685.79 | 686.05 | 685.7 | 685.84 | 5930.0 |
| 2025-12-05 05:30:00 | SPY | ETF | 685.87 | 685.95 | 685.68 | 685.68 | 3387.0 |
| 2025-12-05 06:00:00 | SPY | ETF | 685.57 | 686.05 | 685.53 | 686.01 | 6070.0 |
| 2025-12-05 06:30:00 | SPY | ETF | 686.01 | 686.1 | 685.9 | 686.0 | 13181.0 |
| 2025-12-05 07:00:00 | SPY | ETF | 685.95 | 686.15 | 685.57 | 685.9 | 23939.0 |
| 2025-12-05 07:30:00 | SPY | ETF | 685.88 | 686.01 | 685.66 | 685.88 | 31612.0 |
| 2025-12-05 08:00:00 | SPY | ETF | 685.75 | 686.48 | 685.45 | 685.62 | 135295.0 |
| 2025-12-05 08:30:00 | SPY | ETF | 685.58 | 685.6 | 683.66 | 684.35 | 260986.0 |
| 2025-12-05 09:00:00 | SPY | ETF | 684.35 | 685.46 | 684.32 | 685.46 | 237911.0 |
| 2025-12-05 09:30:00 | SPY | ETF | 685.45 | 687.03 | 685.32 | 686.895 | 6221310.0 |
| 2025-12-05 10:00:00 | SPY | ETF | 686.92 | 688.3 | 686.725 | 687.885 | 4912809.0 |
| 2025-12-05 10:30:00 | SPY | ETF | 687.88 | 688.39 | 686.26 | 686.67 | 4128601.0 |
| 2025-12-05 11:00:00 | SPY | ETF | 686.67 | 687.12 | 685.7 | 685.9562 | 3737824.0 |
| 2025-12-05 11:30:00 | SPY | ETF | 685.95 | 686.64 | 685.02 | 686.02 | 3452845.0 |
| 2025-12-05 12:00:00 | SPY | ETF | 686.02 | 686.26 | 685.24 | 685.39 | 2171136.0 |
| 2025-12-05 12:30:00 | SPY | ETF | 685.41 | 686.43 | 684.58 | 686.25 | 2761152.0 |
| 2025-12-05 13:00:00 | SPY | ETF | 686.245 | 686.705 | 685.52 | 686.55 | 2300369.0 |
| 2025-12-05 13:30:00 | SPY | ETF | 686.56 | 686.97 | 686.08 | 686.19 | 1946759.0 |
| 2025-12-05 14:00:00 | SPY | ETF | 686.19 | 686.4 | 685.6399 | 685.93 | 1912798.0 |
| 2025-12-05 14:30:00 | SPY | ETF | 685.94 | 686.38 | 685.57 | 686.25 | 1848780.0 |
| 2025-12-05 15:00:00 | SPY | ETF | 686.26 | 686.3 | 685.58 | 686.005 | 2537337.0 |
| 2025-12-05 15:30:00 | SPY | ETF | 686.0 | 686.03 | 684.6 | 685.65 | 8588604.0 |
| 2025-12-05 16:00:00 | SPY | ETF | 685.65 | 686.1 | 685.61 | 685.9699 | 4536831.0 |
| 2025-12-05 16:30:00 | SPY | ETF | 685.97 | 686.1 | 685.9 | 685.92 | 224343.0 |
| 2025-12-05 17:00:00 | SPY | ETF | 685.9499 | 686.04 | 685.75 | 685.83 | 52597.0 |
| 2025-12-05 17:30:00 | SPY | ETF | 685.83 | 686.05 | 685.67 | 685.85 | 41420.0 |
| 2025-12-05 18:00:00 | SPY | ETF | 685.8988 | 686.03 | 685.71 | 685.8199 | 18885.0 |
| 2025-12-05 18:30:00 | SPY | ETF | 685.8001 | 685.89 | 685.75 | 685.85 | 2952.0 |
| 2025-12-05 19:00:00 | SPY | ETF | 685.8 | 685.9 | 685.8 | 685.9 | 5539.0 |
| 2025-12-05 19:30:00 | SPY | ETF | 685.87 | 685.99 | 685.83 | 685.97 | 15800.0 |
| 2025-12-05 04:00:00 | QQQ | ETF | 625.3 | 625.74 | 625.16 | 625.56 | 72833.0 |
| 2025-12-05 04:30:00 | QQQ | ETF | 625.59 | 625.59 | 625.06 | 625.35 | 20901.0 |
| 2025-12-05 05:00:00 | QQQ | ETF | 625.34 | 625.71 | 625.21 | 625.51 | 30011.0 |
| 2025-12-05 05:30:00 | QQQ | ETF | 625.51 | 625.65 | 625.23 | 625.3 | 14976.0 |
| 2025-12-05 06:00:00 | QQQ | ETF | 625.24 | 625.51 | 625.02 | 625.47 | 22407.0 |
| 2025-12-05 06:30:00 | QQQ | ETF | 625.47 | 625.5 | 625.26 | 625.34 | 10890.0 |
| 2025-12-05 07:00:00 | QQQ | ETF | 625.34 | 625.67 | 624.65 | 625.12 | 53450.0 |
| 2025-12-05 07:30:00 | QQQ | ETF | 625.14 | 625.25 | 624.75 | 624.97 | 39176.0 |
| 2025-12-05 08:00:00 | QQQ | ETF | 625.23 | 626.1 | 622.473 | 624.57 | 186761.0 |
| 2025-12-05 08:30:00 | QQQ | ETF | 624.54 | 624.59 | 621.98 | 622.81 | 462080.0 |
| 2025-12-05 09:00:00 | QQQ | ETF | 622.8 | 624.47 | 622.78 | 624.37 | 234195.0 |
| 2025-12-05 09:30:00 | QQQ | ETF | 624.38 | 627.37 | 624.24 | 627.0799 | 7171235.0 |
| 2025-12-05 10:00:00 | QQQ | ETF | 627.08 | 628.92 | 626.51 | 628.18 | 4519230.0 |
| 2025-12-05 10:30:00 | QQQ | ETF | 628.18 | 628.765 | 625.29 | 625.94 | 4581305.0 |
| 2025-12-05 11:00:00 | QQQ | ETF | 625.93 | 626.53 | 624.5 | 624.8399 | 4078850.0 |
| 2025-12-05 11:30:00 | QQQ | ETF | 624.84 | 626.36 | 623.71 | 625.59 | 3315772.0 |
| 2025-12-05 12:00:00 | QQQ | ETF | 625.58 | 625.8 | 624.62 | 624.76 | 2153827.0 |
| 2025-12-05 12:30:00 | QQQ | ETF | 624.77 | 625.86 | 624.02 | 625.61 | 2286163.0 |
> showing 50 of 43,783 rows — these rows as CSV