PREVIEW / etf_30min / 2025-12-22
file: by_date/etf_30min/2025/2025-12-22.parquet size: 1.1 MB rows: 46,458
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-22 04:00:00 | SPY | ETF | 681.5 | 682.95 | 681.5 | 682.88 | 11567.0 |
| 2025-12-22 04:30:00 | SPY | ETF | 682.87 | 683.02 | 682.82 | 682.93 | 12729.0 |
| 2025-12-22 05:00:00 | SPY | ETF | 682.87 | 683.01 | 682.81 | 682.97 | 10982.0 |
| 2025-12-22 05:30:00 | SPY | ETF | 682.96 | 683.02 | 682.88 | 682.93 | 6022.0 |
| 2025-12-22 06:00:00 | SPY | ETF | 682.95 | 683.16 | 682.9 | 683.14 | 12582.0 |
| 2025-12-22 06:30:00 | SPY | ETF | 683.09 | 683.11 | 682.81 | 682.93 | 14794.0 |
| 2025-12-22 07:00:00 | SPY | ETF | 682.92 | 683.18 | 682.75 | 683.18 | 95385.0 |
| 2025-12-22 07:30:00 | SPY | ETF | 683.15 | 683.31 | 682.96 | 683.269 | 49533.0 |
| 2025-12-22 08:00:00 | SPY | ETF | 682.97 | 683.71 | 682.02 | 683.6 | 159079.0 |
| 2025-12-22 08:30:00 | SPY | ETF | 683.61 | 683.71 | 683.25 | 683.67 | 130508.0 |
| 2025-12-22 09:00:00 | SPY | ETF | 683.66 | 684.1 | 683.66 | 683.92 | 286752.0 |
| 2025-12-22 09:30:00 | SPY | ETF | 683.93 | 684.53 | 682.94 | 683.97 | 7337728.0 |
| 2025-12-22 10:00:00 | SPY | ETF | 683.975 | 684.12 | 682.89 | 683.77 | 3789017.0 |
| 2025-12-22 10:30:00 | SPY | ETF | 683.77 | 683.99 | 682.68 | 683.65 | 3748414.0 |
| 2025-12-22 11:00:00 | SPY | ETF | 683.64 | 684.975 | 683.64 | 684.67 | 3572258.0 |
| 2025-12-22 11:30:00 | SPY | ETF | 684.67 | 684.95 | 684.36 | 684.95 | 2385105.0 |
| 2025-12-22 12:00:00 | SPY | ETF | 684.96 | 685.08 | 684.52 | 684.65 | 2451517.0 |
| 2025-12-22 12:30:00 | SPY | ETF | 684.645 | 685.36 | 684.56 | 685.21 | 2477842.0 |
| 2025-12-22 13:00:00 | SPY | ETF | 685.21 | 685.22 | 684.35 | 684.715 | 2773026.0 |
| 2025-12-22 13:30:00 | SPY | ETF | 684.71 | 684.91 | 684.37 | 684.505 | 1801237.0 |
| 2025-12-22 14:00:00 | SPY | ETF | 684.5 | 684.75 | 684.205 | 684.72 | 2333620.0 |
| 2025-12-22 14:30:00 | SPY | ETF | 684.73 | 685.01 | 684.665 | 684.79 | 2559449.0 |
| 2025-12-22 15:00:00 | SPY | ETF | 684.79 | 685.04 | 684.665 | 684.925 | 3561859.0 |
| 2025-12-22 15:30:00 | SPY | ETF | 684.925 | 685.1499 | 684.61 | 684.79 | 9181018.0 |
| 2025-12-22 16:00:00 | SPY | ETF | 684.795 | 685.09 | 684.72 | 684.82 | 2961079.0 |
| 2025-12-22 16:30:00 | SPY | ETF | 684.82 | 684.96 | 684.8 | 684.92 | 757521.0 |
| 2025-12-22 17:00:00 | SPY | ETF | 684.93 | 684.95 | 684.72 | 684.8708 | 84679.0 |
| 2025-12-22 17:30:00 | SPY | ETF | 684.9 | 684.9 | 684.74 | 684.8 | 33308.0 |
| 2025-12-22 18:00:00 | SPY | ETF | 684.83 | 685.08 | 684.76 | 684.94 | 51545.0 |
| 2025-12-22 18:30:00 | SPY | ETF | 685.0 | 685.14 | 684.8433 | 684.87 | 22574.0 |
| 2025-12-22 19:00:00 | SPY | ETF | 684.8901 | 685.0 | 684.8 | 684.9005 | 42772.0 |
| 2025-12-22 19:30:00 | SPY | ETF | 684.89 | 685.06 | 684.8199 | 685.0599 | 7150.0 |
| 2025-12-22 04:00:00 | QQQ | ETF | 618.87 | 619.8 | 618.87 | 619.69 | 47452.0 |
| 2025-12-22 04:30:00 | QQQ | ETF | 619.66 | 619.98 | 619.58 | 619.7 | 26311.0 |
| 2025-12-22 05:00:00 | QQQ | ETF | 619.68 | 619.89 | 619.6 | 619.75 | 31506.0 |
| 2025-12-22 05:30:00 | QQQ | ETF | 619.74 | 619.79 | 619.58 | 619.59 | 13352.0 |
| 2025-12-22 06:00:00 | QQQ | ETF | 619.57 | 619.85 | 619.53 | 619.85 | 16643.0 |
| 2025-12-22 06:30:00 | QQQ | ETF | 619.74 | 619.79 | 619.45 | 619.45 | 28942.0 |
| 2025-12-22 07:00:00 | QQQ | ETF | 619.47 | 620.18 | 619.4 | 620.14 | 48967.0 |
| 2025-12-22 07:30:00 | QQQ | ETF | 620.12 | 620.37 | 619.931 | 620.32 | 76489.0 |
| 2025-12-22 08:00:00 | QQQ | ETF | 620.33 | 620.77 | 617.512 | 620.6 | 244665.0 |
| 2025-12-22 08:30:00 | QQQ | ETF | 620.6 | 620.78 | 620.2 | 620.74 | 113359.0 |
| 2025-12-22 09:00:00 | QQQ | ETF | 620.74 | 621.45 | 619.46 | 621.36 | 347553.0 |
| 2025-12-22 09:30:00 | QQQ | ETF | 621.36 | 621.65 | 618.7525 | 620.58 | 5879693.0 |
| 2025-12-22 10:00:00 | QQQ | ETF | 620.57 | 620.74 | 618.8413 | 619.18 | 3247597.0 |
| 2025-12-22 10:30:00 | QQQ | ETF | 619.19 | 619.39 | 617.77 | 618.8579 | 2937675.0 |
| 2025-12-22 11:00:00 | QQQ | ETF | 618.86 | 619.94 | 618.81 | 619.74 | 2974245.0 |
| 2025-12-22 11:30:00 | QQQ | ETF | 619.74 | 619.81 | 619.21 | 619.81 | 1929410.0 |
| 2025-12-22 12:00:00 | QQQ | ETF | 619.82 | 619.9 | 619.34 | 619.43 | 1897852.0 |
| 2025-12-22 12:30:00 | QQQ | ETF | 619.42 | 620.08 | 619.13 | 619.955 | 1788589.0 |
> showing 50 of 46,458 rows — these rows as CSV