PREVIEW / etf_30min / 2026-05-18
file: by_date/etf_30min/2026/2026-05-18.parquet size: 1.1 MB rows: 47,042
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-05-18 04:00:00 | SPY | ETF | 735.0 | 737.38 | 733.72 | 737.2929 | 75565.0 |
| 2026-05-18 04:30:00 | SPY | ETF | 737.47 | 737.63 | 736.65 | 737.6 | 35702.0 |
| 2026-05-18 05:00:00 | SPY | ETF | 737.7 | 737.76 | 736.56 | 736.89 | 17061.0 |
| 2026-05-18 05:30:00 | SPY | ETF | 736.85 | 737.22 | 736.7 | 737.02 | 17366.0 |
| 2026-05-18 06:00:00 | SPY | ETF | 737.12 | 737.13 | 735.81 | 736.19 | 15689.0 |
| 2026-05-18 06:30:00 | SPY | ETF | 736.11 | 736.48 | 735.41 | 735.99 | 23241.0 |
| 2026-05-18 07:00:00 | SPY | ETF | 735.95 | 736.35 | 734.84 | 735.89 | 56570.0 |
| 2026-05-18 07:30:00 | SPY | ETF | 735.77 | 740.0 | 735.77 | 737.44 | 293723.0 |
| 2026-05-18 08:00:00 | SPY | ETF | 737.49 | 738.3 | 737.41 | 738.1 | 125825.0 |
| 2026-05-18 08:30:00 | SPY | ETF | 738.08 | 741.51 | 737.79 | 740.99 | 382026.0 |
| 2026-05-18 09:00:00 | SPY | ETF | 740.94 | 741.2 | 739.77 | 739.77 | 238404.0 |
| 2026-05-18 09:30:00 | SPY | ETF | 739.82 | 741.415 | 737.56 | 740.57 | 3999785.0 |
| 2026-05-18 10:00:00 | SPY | ETF | 740.6 | 740.8 | 738.6 | 739.5 | 2293119.0 |
| 2026-05-18 10:30:00 | SPY | ETF | 739.49 | 739.84 | 736.37 | 738.285 | 2644006.0 |
| 2026-05-18 11:00:00 | SPY | ETF | 738.33 | 739.02 | 735.52 | 735.62 | 2314512.0 |
| 2026-05-18 11:30:00 | SPY | ETF | 735.59 | 737.365 | 735.21 | 736.28 | 1561098.0 |
| 2026-05-18 12:00:00 | SPY | ETF | 736.37 | 737.93 | 734.47 | 734.83 | 1689361.0 |
| 2026-05-18 12:30:00 | SPY | ETF | 734.82 | 737.3399 | 734.225 | 736.49 | 1795160.0 |
| 2026-05-18 13:00:00 | SPY | ETF | 736.49 | 737.42 | 735.94 | 737.36 | 1518506.0 |
| 2026-05-18 13:30:00 | SPY | ETF | 737.35 | 737.42 | 736.24 | 737.03 | 980813.0 |
| 2026-05-18 14:00:00 | SPY | ETF | 737.04 | 737.145 | 733.71 | 734.71 | 2433746.0 |
| 2026-05-18 14:30:00 | SPY | ETF | 734.735 | 735.18 | 733.39 | 733.67 | 2441912.0 |
| 2026-05-18 15:00:00 | SPY | ETF | 733.68 | 738.02 | 733.62 | 735.52 | 4625440.0 |
| 2026-05-18 15:30:00 | SPY | ETF | 735.53 | 738.75 | 735.28 | 738.56 | 4849711.0 |
| 2026-05-18 16:00:00 | SPY | ETF | 738.52 | 738.7 | 737.61 | 738.11 | 2214251.0 |
| 2026-05-18 16:30:00 | SPY | ETF | 738.17 | 738.42 | 737.9 | 738.0299 | 141852.0 |
| 2026-05-18 17:00:00 | SPY | ETF | 738.02 | 738.65 | 737.82 | 737.83 | 48094.0 |
| 2026-05-18 17:30:00 | SPY | ETF | 737.86 | 738.09 | 737.82 | 738.09 | 16742.0 |
| 2026-05-18 18:00:00 | SPY | ETF | 738.09 | 739.58 | 738.09 | 739.37 | 105041.0 |
| 2026-05-18 18:30:00 | SPY | ETF | 739.45 | 739.7 | 739.02 | 739.36 | 22526.0 |
| 2026-05-18 19:00:00 | SPY | ETF | 739.34 | 739.77 | 739.25 | 739.514 | 19907.0 |
| 2026-05-18 19:30:00 | SPY | ETF | 739.39 | 739.49 | 738.6 | 738.89 | 43414.0 |
| 2026-05-18 04:00:00 | QQQ | ETF | 704.58 | 708.88 | 703.3 | 708.64 | 211389.0 |
| 2026-05-18 04:30:00 | QQQ | ETF | 708.78 | 709.31 | 708.0 | 709.24 | 103659.0 |
| 2026-05-18 05:00:00 | QQQ | ETF | 709.4 | 709.42 | 707.88 | 708.3604 | 39451.0 |
| 2026-05-18 05:30:00 | QQQ | ETF | 708.3682 | 708.5377 | 707.55 | 707.945 | 21030.0 |
| 2026-05-18 06:00:00 | QQQ | ETF | 708.09 | 708.09 | 706.23 | 706.65 | 111249.0 |
| 2026-05-18 06:30:00 | QQQ | ETF | 706.74 | 706.85 | 705.35 | 706.19 | 93175.0 |
| 2026-05-18 07:00:00 | QQQ | ETF | 706.271 | 706.5 | 704.7 | 705.5 | 117936.0 |
| 2026-05-18 07:30:00 | QQQ | ETF | 705.589 | 710.0 | 705.58 | 707.63 | 387028.0 |
| 2026-05-18 08:00:00 | QQQ | ETF | 707.65 | 709.14 | 707.61 | 708.29 | 125106.0 |
| 2026-05-18 08:30:00 | QQQ | ETF | 708.39 | 713.5 | 705.01 | 713.32 | 769129.0 |
| 2026-05-18 09:00:00 | QQQ | ETF | 713.22 | 713.48 | 711.52 | 711.61 | 382554.0 |
| 2026-05-18 09:30:00 | QQQ | ETF | 711.54 | 712.07 | 706.67 | 709.29 | 4763543.0 |
| 2026-05-18 10:00:00 | QQQ | ETF | 709.13 | 710.62 | 706.52 | 707.1006 | 2865831.0 |
| 2026-05-18 10:30:00 | QQQ | ETF | 707.1 | 707.63 | 702.72 | 705.3 | 3766239.0 |
| 2026-05-18 11:00:00 | QQQ | ETF | 705.37 | 706.4 | 702.2961 | 702.34 | 2555247.0 |
| 2026-05-18 11:30:00 | QQQ | ETF | 702.385 | 704.93 | 701.94 | 703.28 | 1785082.0 |
| 2026-05-18 12:00:00 | QQQ | ETF | 703.31 | 705.16 | 700.0 | 700.43 | 2220956.0 |
| 2026-05-18 12:30:00 | QQQ | ETF | 700.42 | 704.455 | 699.61 | 703.47 | 2361645.0 |
> showing 50 of 47,042 rows — these rows as CSV