PREVIEW / etf_30min / 2026-07-21
file: by_date/etf_30min/2026/2026-07-21.parquet size: 1.0 MB rows: 46,536
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 |
|---|---|---|---|---|---|---|---|
| 2026-07-21 04:00:00 | SPY | ETF | 745.07 | 746.41 | 744.7 | 746.01 | 56673.0 |
| 2026-07-21 04:30:00 | SPY | ETF | 745.99 | 746.24 | 745.88 | 746.02 | 9511.0 |
| 2026-07-21 05:00:00 | SPY | ETF | 746.1 | 746.45 | 746.0 | 746.0 | 7473.0 |
| 2026-07-21 05:30:00 | SPY | ETF | 746.01 | 746.37 | 745.82 | 745.87 | 13069.0 |
| 2026-07-21 06:00:00 | SPY | ETF | 746.0 | 746.45 | 745.76 | 746.11 | 66003.0 |
| 2026-07-21 06:30:00 | SPY | ETF | 746.12 | 746.68 | 745.72 | 746.05 | 74146.0 |
| 2026-07-21 07:00:00 | SPY | ETF | 745.89 | 746.05 | 745.0 | 745.18 | 76177.0 |
| 2026-07-21 07:30:00 | SPY | ETF | 745.2 | 745.76 | 745.11 | 745.181 | 44587.0 |
| 2026-07-21 08:00:00 | SPY | ETF | 745.25 | 745.85 | 744.79 | 744.8399 | 97500.0 |
| 2026-07-21 08:30:00 | SPY | ETF | 744.84 | 745.44 | 744.27 | 745.23 | 153852.0 |
| 2026-07-21 09:00:00 | SPY | ETF | 745.28 | 746.29 | 744.9 | 746.29 | 140973.0 |
| 2026-07-21 09:30:00 | SPY | ETF | 746.29 | 746.69 | 744.18 | 745.37 | 3278562.0 |
| 2026-07-21 10:00:00 | SPY | ETF | 745.38 | 746.99 | 744.79 | 746.87 | 1478664.0 |
| 2026-07-21 10:30:00 | SPY | ETF | 746.85 | 747.26 | 745.77 | 746.74 | 1512890.0 |
| 2026-07-21 11:00:00 | SPY | ETF | 746.77 | 748.01 | 745.83 | 748.0 | 1448847.0 |
| 2026-07-21 11:30:00 | SPY | ETF | 747.98 | 748.0 | 747.41 | 747.52 | 1195503.0 |
| 2026-07-21 12:00:00 | SPY | ETF | 747.52 | 748.75 | 747.49 | 748.66 | 1196038.0 |
| 2026-07-21 12:30:00 | SPY | ETF | 748.64 | 749.04 | 748.4 | 748.69 | 856765.0 |
| 2026-07-21 13:00:00 | SPY | ETF | 748.6884 | 748.855 | 748.24 | 748.36 | 1193013.0 |
| 2026-07-21 13:30:00 | SPY | ETF | 748.36 | 748.93 | 748.215 | 748.59 | 1033240.0 |
| 2026-07-21 14:00:00 | SPY | ETF | 748.59 | 748.77 | 748.065 | 748.21 | 1223785.0 |
| 2026-07-21 14:30:00 | SPY | ETF | 748.22 | 748.64 | 747.94 | 748.37 | 1104410.0 |
| 2026-07-21 15:00:00 | SPY | ETF | 748.38 | 748.47 | 748.09 | 748.26 | 1256753.0 |
| 2026-07-21 15:30:00 | SPY | ETF | 748.25 | 748.7 | 748.09 | 748.315 | 4210131.0 |
| 2026-07-21 16:00:00 | SPY | ETF | 748.295 | 748.41 | 747.82 | 747.86 | 3515963.0 |
| 2026-07-21 16:30:00 | SPY | ETF | 747.87 | 748.28 | 747.84 | 748.04 | 188663.0 |
| 2026-07-21 17:00:00 | SPY | ETF | 748.01 | 748.25 | 747.94 | 748.1 | 53746.0 |
| 2026-07-21 17:30:00 | SPY | ETF | 748.06 | 748.3 | 748.0 | 748.08 | 14441.0 |
| 2026-07-21 18:00:00 | SPY | ETF | 748.19 | 748.221 | 747.83 | 747.85 | 61098.0 |
| 2026-07-21 18:30:00 | SPY | ETF | 747.8655 | 747.94 | 747.57 | 747.8 | 15522.0 |
| 2026-07-21 19:00:00 | SPY | ETF | 747.72 | 748.11 | 747.7186 | 747.995 | 9164.0 |
| 2026-07-21 19:30:00 | SPY | ETF | 748.0094 | 748.12 | 747.7 | 748.06 | 15148.0 |
| 2026-07-21 04:00:00 | QQQ | ETF | 704.07 | 705.29 | 701.63 | 705.29 | 315575.0 |
| 2026-07-21 04:30:00 | QQQ | ETF | 705.25 | 705.46 | 704.89 | 705.2834 | 78937.0 |
| 2026-07-21 05:00:00 | QQQ | ETF | 705.23 | 705.93 | 705.18 | 705.26 | 48326.0 |
| 2026-07-21 05:30:00 | QQQ | ETF | 705.27 | 705.66 | 704.88 | 705.01 | 41446.0 |
| 2026-07-21 06:00:00 | QQQ | ETF | 705.01 | 706.0 | 705.0 | 705.45 | 62277.0 |
| 2026-07-21 06:30:00 | QQQ | ETF | 705.48 | 706.11 | 705.05 | 705.21 | 92396.0 |
| 2026-07-21 07:00:00 | QQQ | ETF | 705.25 | 705.67 | 704.13 | 704.341 | 132904.0 |
| 2026-07-21 07:30:00 | QQQ | ETF | 704.33 | 705.63 | 704.33 | 704.84 | 84860.0 |
| 2026-07-21 08:00:00 | QQQ | ETF | 704.95 | 705.9 | 695.538 | 704.51 | 117951.0 |
| 2026-07-21 08:30:00 | QQQ | ETF | 704.45 | 705.7 | 703.92 | 705.35 | 131894.0 |
| 2026-07-21 09:00:00 | QQQ | ETF | 705.4511 | 706.59 | 704.97 | 706.54 | 211263.0 |
| 2026-07-21 09:30:00 | QQQ | ETF | 706.59 | 707.13 | 703.5 | 704.89 | 3006744.0 |
| 2026-07-21 10:00:00 | QQQ | ETF | 704.97 | 706.45 | 702.8 | 706.23 | 1747196.0 |
| 2026-07-21 10:30:00 | QQQ | ETF | 706.22 | 707.4 | 705.2 | 707.0 | 1596620.0 |
| 2026-07-21 11:00:00 | QQQ | ETF | 706.98 | 708.99 | 705.65 | 708.69 | 1506628.0 |
| 2026-07-21 11:30:00 | QQQ | ETF | 708.66 | 708.68 | 707.48 | 707.5203 | 990446.0 |
| 2026-07-21 12:00:00 | QQQ | ETF | 707.52 | 709.41 | 707.43 | 708.84 | 1086441.0 |
| 2026-07-21 12:30:00 | QQQ | ETF | 708.85 | 709.79 | 708.6 | 709.3 | 1208922.0 |
> showing 50 of 46,536 rows — these rows as CSV