PREVIEW / etf_30min / 2025-12-26
file: by_date/etf_30min/2025/2025-12-26.parquet size: 998 KB rows: 42,092
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-26 04:00:00 | SPY | ETF | 690.05 | 690.39 | 689.99 | 690.19 | 10410.0 |
| 2025-12-26 04:30:00 | SPY | ETF | 690.11 | 690.36 | 690.1 | 690.3 | 3888.0 |
| 2025-12-26 05:00:00 | SPY | ETF | 690.35 | 690.54 | 690.3 | 690.4 | 9002.0 |
| 2025-12-26 05:30:00 | SPY | ETF | 690.34 | 690.48 | 690.25 | 690.34 | 2908.0 |
| 2025-12-26 06:00:00 | SPY | ETF | 690.37 | 690.41 | 690.18 | 690.18 | 2419.0 |
| 2025-12-26 06:30:00 | SPY | ETF | 690.18 | 690.2 | 689.89 | 690.1 | 11466.0 |
| 2025-12-26 07:00:00 | SPY | ETF | 690.12 | 690.37 | 690.0 | 690.3 | 9810.0 |
| 2025-12-26 07:30:00 | SPY | ETF | 690.29 | 690.5 | 690.26 | 690.41 | 17751.0 |
| 2025-12-26 08:00:00 | SPY | ETF | 690.125 | 690.56 | 689.83 | 690.46 | 102999.0 |
| 2025-12-26 08:30:00 | SPY | ETF | 690.39 | 690.8242 | 690.39 | 690.55 | 146102.0 |
| 2025-12-26 09:00:00 | SPY | ETF | 690.58 | 690.77 | 690.43 | 690.66 | 114006.0 |
| 2025-12-26 09:30:00 | SPY | ETF | 690.64 | 691.66 | 690.27 | 690.77 | 5254777.0 |
| 2025-12-26 10:00:00 | SPY | ETF | 690.77 | 690.82 | 689.65 | 690.735 | 3735215.0 |
| 2025-12-26 10:30:00 | SPY | ETF | 690.73 | 691.0001 | 690.4 | 690.825 | 2015373.0 |
| 2025-12-26 11:00:00 | SPY | ETF | 690.825 | 690.96 | 689.77 | 690.2641 | 2313056.0 |
| 2025-12-26 11:30:00 | SPY | ETF | 690.27 | 690.33 | 689.77 | 689.99 | 1604306.0 |
| 2025-12-26 12:00:00 | SPY | ETF | 689.98 | 690.15 | 689.39 | 690.14 | 1852437.0 |
| 2025-12-26 12:30:00 | SPY | ETF | 690.13 | 690.2 | 689.51 | 689.79 | 1718860.0 |
| 2025-12-26 13:00:00 | SPY | ETF | 689.79 | 690.05 | 689.27 | 689.6971 | 1501649.0 |
| 2025-12-26 13:30:00 | SPY | ETF | 689.69 | 690.29 | 689.65 | 690.21 | 1479427.0 |
| 2025-12-26 14:00:00 | SPY | ETF | 690.205 | 690.46 | 689.975 | 690.0418 | 1551015.0 |
| 2025-12-26 14:30:00 | SPY | ETF | 690.04 | 690.32 | 690.0375 | 690.155 | 1438608.0 |
| 2025-12-26 15:00:00 | SPY | ETF | 690.15 | 690.34 | 690.04 | 690.2 | 1846605.0 |
| 2025-12-26 15:30:00 | SPY | ETF | 690.2 | 690.5 | 690.005 | 690.25 | 6298610.0 |
| 2025-12-26 16:00:00 | SPY | ETF | 690.25 | 690.37 | 689.98 | 690.0537 | 1233844.0 |
| 2025-12-26 16:30:00 | SPY | ETF | 690.05 | 690.07 | 689.93 | 689.99 | 182956.0 |
| 2025-12-26 17:00:00 | SPY | ETF | 690.0 | 690.02 | 689.9678 | 690.0 | 10256.0 |
| 2025-12-26 17:30:00 | SPY | ETF | 690.0001 | 690.0999 | 689.97 | 690.01 | 6553.0 |
| 2025-12-26 18:00:00 | SPY | ETF | 690.012 | 690.08 | 690.01 | 690.0599 | 2368.0 |
| 2025-12-26 18:30:00 | SPY | ETF | 690.06 | 690.2 | 690.05 | 690.09 | 7191.0 |
| 2025-12-26 19:00:00 | SPY | ETF | 690.1 | 690.1 | 690.0 | 690.0128 | 2317.0 |
| 2025-12-26 19:30:00 | SPY | ETF | 690.0 | 690.08 | 689.9 | 689.91 | 9805.0 |
| 2025-12-26 04:00:00 | QQQ | ETF | 623.93 | 623.99 | 623.2 | 623.75 | 15737.0 |
| 2025-12-26 04:30:00 | QQQ | ETF | 623.75 | 624.17 | 623.75 | 624.12 | 5696.0 |
| 2025-12-26 05:00:00 | QQQ | ETF | 624.16 | 624.55 | 624.14 | 624.25 | 14008.0 |
| 2025-12-26 05:30:00 | QQQ | ETF | 624.28 | 624.47 | 624.21 | 624.25 | 5265.0 |
| 2025-12-26 06:00:00 | QQQ | ETF | 624.35 | 624.42 | 624.22 | 624.23 | 4606.0 |
| 2025-12-26 06:30:00 | QQQ | ETF | 624.2 | 624.25 | 623.91 | 624.09 | 10868.0 |
| 2025-12-26 07:00:00 | QQQ | ETF | 624.13 | 624.35 | 623.97 | 624.31 | 16040.0 |
| 2025-12-26 07:30:00 | QQQ | ETF | 624.28 | 624.6 | 624.25 | 624.49 | 14568.0 |
| 2025-12-26 08:00:00 | QQQ | ETF | 624.17 | 624.73 | 623.38 | 624.56 | 93206.0 |
| 2025-12-26 08:30:00 | QQQ | ETF | 624.56 | 625.22 | 624.46 | 624.58 | 144176.0 |
| 2025-12-26 09:00:00 | QQQ | ETF | 624.6 | 624.92 | 624.4812 | 624.65 | 164127.0 |
| 2025-12-26 09:30:00 | QQQ | ETF | 624.67 | 625.515 | 623.86 | 624.235 | 3631859.0 |
| 2025-12-26 10:00:00 | QQQ | ETF | 624.22 | 624.4 | 623.14 | 624.34 | 2570312.0 |
| 2025-12-26 10:30:00 | QQQ | ETF | 624.33 | 624.87 | 624.11 | 624.7113 | 1744454.0 |
| 2025-12-26 11:00:00 | QQQ | ETF | 624.71 | 624.99 | 623.7 | 624.3 | 1694047.0 |
| 2025-12-26 11:30:00 | QQQ | ETF | 624.31 | 624.495 | 624.08 | 624.11 | 913798.0 |
| 2025-12-26 12:00:00 | QQQ | ETF | 624.1 | 624.25 | 623.5 | 624.24 | 1205421.0 |
| 2025-12-26 12:30:00 | QQQ | ETF | 624.24 | 624.2802 | 623.75 | 624.045 | 924553.0 |
> showing 50 of 42,092 rows — these rows as CSV