PREVIEW / etf_30min / 2026-05-20
file: by_date/etf_30min/2026/2026-05-20.parquet size: 1.1 MB rows: 45,918
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-20 04:00:00 | SPY | ETF | 734.3 | 735.8 | 732.5 | 735.8 | 48260.0 |
| 2026-05-20 04:30:00 | SPY | ETF | 735.82 | 736.5 | 735.72 | 736.0 | 27582.0 |
| 2026-05-20 05:00:00 | SPY | ETF | 735.95 | 736.0 | 735.46 | 735.77 | 13953.0 |
| 2026-05-20 05:30:00 | SPY | ETF | 735.85 | 736.7 | 735.83 | 736.32 | 24462.0 |
| 2026-05-20 06:00:00 | SPY | ETF | 736.43 | 736.95 | 736.42 | 736.75 | 13975.0 |
| 2026-05-20 06:30:00 | SPY | ETF | 736.77 | 737.32 | 736.12 | 736.12 | 36590.0 |
| 2026-05-20 07:00:00 | SPY | ETF | 736.21 | 736.6888 | 736.0865 | 736.6848 | 122696.0 |
| 2026-05-20 07:30:00 | SPY | ETF | 736.72 | 736.95 | 735.78 | 736.0 | 131555.0 |
| 2026-05-20 08:00:00 | SPY | ETF | 735.9416 | 737.52 | 735.941 | 737.36 | 76140.0 |
| 2026-05-20 08:30:00 | SPY | ETF | 737.4 | 737.72 | 736.4278 | 736.45 | 188526.0 |
| 2026-05-20 09:00:00 | SPY | ETF | 736.39 | 736.55 | 735.55 | 735.72 | 187510.0 |
| 2026-05-20 09:30:00 | SPY | ETF | 735.7 | 737.23 | 734.27 | 736.13 | 3923559.0 |
| 2026-05-20 10:00:00 | SPY | ETF | 736.14 | 738.54 | 733.89 | 737.89 | 3917137.0 |
| 2026-05-20 10:30:00 | SPY | ETF | 737.9 | 739.48 | 737.44 | 739.2 | 2805341.0 |
| 2026-05-20 11:00:00 | SPY | ETF | 739.19 | 741.87 | 738.59 | 739.295 | 3748187.0 |
| 2026-05-20 11:30:00 | SPY | ETF | 739.295 | 740.92 | 739.23 | 740.24 | 1757038.0 |
| 2026-05-20 12:00:00 | SPY | ETF | 740.26 | 740.53 | 738.55 | 738.93 | 1382364.0 |
| 2026-05-20 12:30:00 | SPY | ETF | 738.95 | 740.01 | 738.5112 | 739.365 | 1538551.0 |
| 2026-05-20 13:00:00 | SPY | ETF | 739.4 | 740.35 | 738.74 | 740.155 | 1482545.0 |
| 2026-05-20 13:30:00 | SPY | ETF | 740.16 | 740.72 | 739.61 | 739.85 | 1166797.0 |
| 2026-05-20 14:00:00 | SPY | ETF | 739.86 | 740.49 | 739.3 | 740.08 | 1730409.0 |
| 2026-05-20 14:30:00 | SPY | ETF | 740.13 | 740.85 | 739.68 | 740.165 | 1446065.0 |
| 2026-05-20 15:00:00 | SPY | ETF | 740.165 | 740.96 | 740.02 | 740.82 | 1815018.0 |
| 2026-05-20 15:30:00 | SPY | ETF | 740.83 | 741.61 | 740.55 | 741.3 | 5672099.0 |
| 2026-05-20 16:00:00 | SPY | ETF | 741.3 | 741.43 | 739.0395 | 741.38 | 2082317.0 |
| 2026-05-20 16:30:00 | SPY | ETF | 741.37 | 741.43 | 739.3486 | 739.55 | 198190.0 |
| 2026-05-20 17:00:00 | SPY | ETF | 739.67 | 740.19 | 738.9 | 739.865 | 121792.0 |
| 2026-05-20 17:30:00 | SPY | ETF | 739.9 | 739.97 | 739.5 | 739.9 | 85540.0 |
| 2026-05-20 18:00:00 | SPY | ETF | 739.57 | 739.57 | 737.08 | 737.84 | 282362.0 |
| 2026-05-20 18:30:00 | SPY | ETF | 737.9 | 738.14 | 737.79 | 738.14 | 34872.0 |
| 2026-05-20 19:00:00 | SPY | ETF | 738.0918 | 738.79 | 737.81 | 738.0584 | 22921.0 |
| 2026-05-20 19:30:00 | SPY | ETF | 738.0551 | 738.42 | 737.97 | 738.305 | 9184.0 |
| 2026-05-20 04:00:00 | QQQ | ETF | 704.21 | 705.84 | 700.49 | 705.705 | 170777.0 |
| 2026-05-20 04:30:00 | QQQ | ETF | 705.83 | 706.87 | 705.78 | 705.95 | 108254.0 |
| 2026-05-20 05:00:00 | QQQ | ETF | 705.96 | 705.99 | 705.2 | 705.5 | 22817.0 |
| 2026-05-20 05:30:00 | QQQ | ETF | 705.76 | 707.17 | 705.68 | 706.52 | 47656.0 |
| 2026-05-20 06:00:00 | QQQ | ETF | 706.59 | 707.28 | 706.44 | 706.62 | 36614.0 |
| 2026-05-20 06:30:00 | QQQ | ETF | 706.67 | 707.29 | 706.1 | 706.14 | 36026.0 |
| 2026-05-20 07:00:00 | QQQ | ETF | 706.185 | 706.66 | 705.84 | 706.47 | 60078.0 |
| 2026-05-20 07:30:00 | QQQ | ETF | 706.49 | 706.62 | 705.15 | 705.5016 | 77486.0 |
| 2026-05-20 08:00:00 | QQQ | ETF | 705.5 | 707.35 | 701.004 | 707.07 | 184893.0 |
| 2026-05-20 08:30:00 | QQQ | ETF | 707.13 | 707.5796 | 706.06 | 706.07 | 154055.0 |
| 2026-05-20 09:00:00 | QQQ | ETF | 706.03 | 706.42 | 704.95 | 705.3 | 224075.0 |
| 2026-05-20 09:30:00 | QQQ | ETF | 705.29 | 708.23 | 704.11 | 706.0 | 3974367.0 |
| 2026-05-20 10:00:00 | QQQ | ETF | 705.99 | 709.19 | 703.79 | 708.61 | 3577174.0 |
| 2026-05-20 10:30:00 | QQQ | ETF | 708.6 | 710.31 | 707.77 | 709.905 | 1927495.0 |
| 2026-05-20 11:00:00 | QQQ | ETF | 709.84 | 713.13 | 709.165 | 710.63 | 2114725.0 |
| 2026-05-20 11:30:00 | QQQ | ETF | 710.6299 | 712.22 | 710.43 | 711.5702 | 1661424.0 |
| 2026-05-20 12:00:00 | QQQ | ETF | 711.61 | 711.7 | 708.61 | 709.27 | 1414875.0 |
| 2026-05-20 12:30:00 | QQQ | ETF | 709.32 | 710.73 | 708.95 | 709.87 | 1491703.0 |
> showing 50 of 45,918 rows — these rows as CSV