PREVIEW / etf_30min / 2026-08-20
file: by_date/etf_30min/2026/2026-08-20.parquet size: 1.1 MB rows: 47,371
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-08-20 04:00:00 | SPY | ETF | 769.05 | 770.63 | 768.33 | 768.36 | 30629.0 |
| 2026-08-20 04:30:00 | SPY | ETF | 768.3 | 768.57 | 767.7 | 768.07 | 37329.0 |
| 2026-08-20 05:00:00 | SPY | ETF | 767.98 | 768.7815 | 767.98 | 768.65 | 5134.0 |
| 2026-08-20 05:30:00 | SPY | ETF | 768.58 | 768.805 | 768.29 | 768.52 | 3665.0 |
| 2026-08-20 06:00:00 | SPY | ETF | 768.32 | 769.02 | 768.32 | 768.86 | 17230.0 |
| 2026-08-20 06:30:00 | SPY | ETF | 768.81 | 769.17 | 768.6 | 769.17 | 15066.0 |
| 2026-08-20 07:00:00 | SPY | ETF | 769.16 | 769.42 | 767.56 | 767.595 | 89217.0 |
| 2026-08-20 07:30:00 | SPY | ETF | 767.6 | 768.0 | 766.45 | 766.46 | 123702.0 |
| 2026-08-20 08:00:00 | SPY | ETF | 766.5948 | 768.484 | 764.6208 | 764.84 | 218408.0 |
| 2026-08-20 08:30:00 | SPY | ETF | 764.93 | 769.94 | 764.15 | 765.799 | 175931.0 |
| 2026-08-20 09:00:00 | SPY | ETF | 765.78 | 766.2538 | 765.42 | 765.94 | 134709.0 |
| 2026-08-20 09:30:00 | SPY | ETF | 765.95 | 767.75 | 765.86 | 766.55 | 3530415.0 |
| 2026-08-20 10:00:00 | SPY | ETF | 766.5 | 766.95 | 765.36 | 766.22 | 2305694.0 |
| 2026-08-20 10:30:00 | SPY | ETF | 766.205 | 767.48 | 765.93 | 767.15 | 1646466.0 |
| 2026-08-20 11:00:00 | SPY | ETF | 767.17 | 768.15 | 765.97 | 766.75 | 2630609.0 |
| 2026-08-20 11:30:00 | SPY | ETF | 766.74 | 766.87 | 765.23 | 765.84 | 1731140.0 |
| 2026-08-20 12:00:00 | SPY | ETF | 765.84 | 766.09 | 765.45 | 765.745 | 1084568.0 |
| 2026-08-20 12:30:00 | SPY | ETF | 765.74 | 766.64 | 765.36 | 766.42 | 1265612.0 |
| 2026-08-20 13:00:00 | SPY | ETF | 766.39 | 766.43 | 764.71 | 764.78 | 1553120.0 |
| 2026-08-20 13:30:00 | SPY | ETF | 764.78 | 765.01 | 764.23 | 764.54 | 1453541.0 |
| 2026-08-20 14:00:00 | SPY | ETF | 764.55 | 764.55 | 763.15 | 763.56 | 2182567.0 |
| 2026-08-20 14:30:00 | SPY | ETF | 763.565 | 763.85 | 763.21 | 763.24 | 1837460.0 |
| 2026-08-20 15:00:00 | SPY | ETF | 763.25 | 763.8 | 763.17 | 763.49 | 2373181.0 |
| 2026-08-20 15:30:00 | SPY | ETF | 763.48 | 763.65 | 762.04 | 762.65 | 8163495.0 |
| 2026-08-20 16:00:00 | SPY | ETF | 762.64 | 762.9 | 761.99 | 762.45 | 2125542.0 |
| 2026-08-20 16:30:00 | SPY | ETF | 762.43 | 763.01 | 762.43 | 762.97 | 171077.0 |
| 2026-08-20 17:00:00 | SPY | ETF | 762.99 | 763.07 | 762.88 | 763.04 | 24585.0 |
| 2026-08-20 17:30:00 | SPY | ETF | 763.04 | 763.23 | 763.03 | 763.14 | 28537.0 |
| 2026-08-20 18:00:00 | SPY | ETF | 763.16 | 763.27 | 762.59 | 762.75 | 42871.0 |
| 2026-08-20 18:30:00 | SPY | ETF | 762.75 | 763.13 | 762.64 | 763.13 | 11522.0 |
| 2026-08-20 19:00:00 | SPY | ETF | 763.12 | 763.12 | 762.94 | 763.01 | 8097.0 |
| 2026-08-20 19:30:00 | SPY | ETF | 763.0 | 763.0497 | 762.7 | 762.88 | 14867.0 |
| 2026-08-20 04:00:00 | QQQ | ETF | 718.44 | 720.15 | 715.635 | 715.74 | 152645.0 |
| 2026-08-20 04:30:00 | QQQ | ETF | 715.63 | 716.29 | 714.6 | 714.99 | 88562.0 |
| 2026-08-20 05:00:00 | QQQ | ETF | 714.98 | 716.7 | 714.98 | 716.57 | 25595.0 |
| 2026-08-20 05:30:00 | QQQ | ETF | 716.35 | 716.81 | 716.0 | 716.51 | 11297.0 |
| 2026-08-20 06:00:00 | QQQ | ETF | 716.35 | 717.14 | 716.0 | 716.51 | 41416.0 |
| 2026-08-20 06:30:00 | QQQ | ETF | 716.5291 | 717.23 | 716.085 | 717.23 | 35093.0 |
| 2026-08-20 07:00:00 | QQQ | ETF | 717.27 | 717.61 | 713.8 | 713.8786 | 196364.0 |
| 2026-08-20 07:30:00 | QQQ | ETF | 713.86 | 714.5 | 712.05 | 712.3 | 198863.0 |
| 2026-08-20 08:00:00 | QQQ | ETF | 712.3 | 712.68 | 709.99 | 710.32 | 363126.0 |
| 2026-08-20 08:30:00 | QQQ | ETF | 710.28 | 714.9 | 709.435 | 711.97 | 675129.0 |
| 2026-08-20 09:00:00 | QQQ | ETF | 711.92 | 712.55 | 711.45 | 712.1 | 163983.0 |
| 2026-08-20 09:30:00 | QQQ | ETF | 712.09 | 714.94 | 711.07 | 712.19 | 3317372.0 |
| 2026-08-20 10:00:00 | QQQ | ETF | 712.1595 | 713.6 | 711.049 | 712.09 | 2515897.0 |
| 2026-08-20 10:30:00 | QQQ | ETF | 712.06 | 714.08 | 711.59 | 713.1095 | 1450284.0 |
| 2026-08-20 11:00:00 | QQQ | ETF | 713.09 | 714.66 | 710.89 | 711.9536 | 2328122.0 |
| 2026-08-20 11:30:00 | QQQ | ETF | 711.93 | 712.08 | 710.1338 | 711.565 | 1467512.0 |
| 2026-08-20 12:00:00 | QQQ | ETF | 711.59 | 712.2 | 710.9237 | 711.84 | 806622.0 |
| 2026-08-20 12:30:00 | QQQ | ETF | 711.85 | 713.0 | 711.13 | 712.7848 | 907111.0 |
> showing 50 of 47,371 rows — these rows as CSV