PREVIEW / etf_30min / 2026-04-20
file: by_date/etf_30min/2026/2026-04-20.parquet size: 1.1 MB rows: 46,468
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-04-20 04:00:00 | SPY | ETF | 706.56 | 707.19 | 705.04 | 706.22 | 143516.0 |
| 2026-04-20 04:30:00 | SPY | ETF | 706.2 | 706.98 | 706.0 | 706.98 | 28806.0 |
| 2026-04-20 05:00:00 | SPY | ETF | 706.89 | 707.39 | 706.62 | 706.84 | 17171.0 |
| 2026-04-20 05:30:00 | SPY | ETF | 706.99 | 707.12 | 706.73 | 706.87 | 41390.0 |
| 2026-04-20 06:00:00 | SPY | ETF | 706.88 | 707.68 | 706.83 | 707.08 | 61260.0 |
| 2026-04-20 06:30:00 | SPY | ETF | 707.13 | 707.15 | 706.61 | 706.66 | 58966.0 |
| 2026-04-20 07:00:00 | SPY | ETF | 706.65 | 706.74 | 706.16 | 706.33 | 214616.0 |
| 2026-04-20 07:30:00 | SPY | ETF | 706.26 | 707.05 | 706.21 | 706.92 | 204315.0 |
| 2026-04-20 08:00:00 | SPY | ETF | 706.9182 | 707.34 | 706.66 | 707.0 | 105626.0 |
| 2026-04-20 08:30:00 | SPY | ETF | 707.09 | 708.05 | 706.9706 | 707.65 | 146321.0 |
| 2026-04-20 09:00:00 | SPY | ETF | 707.61 | 708.76 | 707.51 | 708.71 | 305435.0 |
| 2026-04-20 09:30:00 | SPY | ETF | 708.79 | 709.91 | 708.23 | 709.67 | 3896605.0 |
| 2026-04-20 10:00:00 | SPY | ETF | 709.67 | 709.72 | 708.67 | 708.95 | 2202716.0 |
| 2026-04-20 10:30:00 | SPY | ETF | 708.93 | 709.0 | 706.48 | 707.14 | 3659149.0 |
| 2026-04-20 11:00:00 | SPY | ETF | 707.155 | 708.52 | 706.14 | 708.27 | 2696506.0 |
| 2026-04-20 11:30:00 | SPY | ETF | 708.26 | 708.26 | 707.11 | 707.5992 | 1349385.0 |
| 2026-04-20 12:00:00 | SPY | ETF | 707.6 | 707.8 | 707.02 | 707.65 | 931693.0 |
| 2026-04-20 12:30:00 | SPY | ETF | 707.66 | 708.1 | 707.37 | 707.6399 | 959228.0 |
| 2026-04-20 13:00:00 | SPY | ETF | 707.64 | 708.39 | 707.26 | 707.98 | 962056.0 |
| 2026-04-20 13:30:00 | SPY | ETF | 707.9882 | 708.26 | 707.61 | 707.74 | 1010948.0 |
| 2026-04-20 14:00:00 | SPY | ETF | 707.74 | 708.61 | 707.481 | 708.32 | 1511932.0 |
| 2026-04-20 14:30:00 | SPY | ETF | 708.32 | 708.61 | 707.86 | 708.265 | 1486330.0 |
| 2026-04-20 15:00:00 | SPY | ETF | 708.27 | 708.58 | 707.96 | 708.02 | 1777308.0 |
| 2026-04-20 15:30:00 | SPY | ETF | 708.02 | 708.8 | 707.6 | 708.69 | 5002215.0 |
| 2026-04-20 16:00:00 | SPY | ETF | 708.71 | 708.91 | 708.46 | 708.69 | 1849722.0 |
| 2026-04-20 16:30:00 | SPY | ETF | 708.69 | 709.97 | 708.46 | 709.16 | 331208.0 |
| 2026-04-20 17:00:00 | SPY | ETF | 709.13 | 709.3494 | 708.72 | 709.13 | 107930.0 |
| 2026-04-20 17:30:00 | SPY | ETF | 709.14 | 709.26 | 709.03 | 709.17 | 31357.0 |
| 2026-04-20 18:00:00 | SPY | ETF | 709.18 | 710.0 | 709.05 | 709.64 | 94345.0 |
| 2026-04-20 18:30:00 | SPY | ETF | 709.52 | 709.81 | 709.5 | 709.76 | 11122.0 |
| 2026-04-20 19:00:00 | SPY | ETF | 709.71 | 709.77 | 709.5219 | 709.5299 | 9020.0 |
| 2026-04-20 19:30:00 | SPY | ETF | 709.55 | 709.62 | 709.4026 | 709.49 | 29762.0 |
| 2026-04-20 04:00:00 | QQQ | ETF | 644.38 | 646.14 | 643.58 | 645.09 | 162789.0 |
| 2026-04-20 04:30:00 | QQQ | ETF | 645.05 | 645.66 | 644.73 | 645.6 | 37150.0 |
| 2026-04-20 05:00:00 | QQQ | ETF | 645.55 | 646.1 | 645.405 | 645.57 | 18484.0 |
| 2026-04-20 05:30:00 | QQQ | ETF | 645.74 | 645.92 | 645.53 | 645.59 | 27215.0 |
| 2026-04-20 06:00:00 | QQQ | ETF | 645.59 | 646.45 | 645.47 | 645.915 | 32367.0 |
| 2026-04-20 06:30:00 | QQQ | ETF | 645.95 | 645.98 | 645.52 | 645.63 | 31603.0 |
| 2026-04-20 07:00:00 | QQQ | ETF | 645.71 | 645.88 | 645.23 | 645.45 | 142551.0 |
| 2026-04-20 07:30:00 | QQQ | ETF | 645.39 | 646.24 | 645.28 | 645.92 | 74726.0 |
| 2026-04-20 08:00:00 | QQQ | ETF | 645.97 | 649.336 | 645.7301 | 646.0774 | 118800.0 |
| 2026-04-20 08:30:00 | QQQ | ETF | 646.18 | 647.46 | 645.96 | 646.91 | 206150.0 |
| 2026-04-20 09:00:00 | QQQ | ETF | 646.87 | 648.11 | 646.64 | 647.98 | 304215.0 |
| 2026-04-20 09:30:00 | QQQ | ETF | 648.04 | 648.76 | 646.08 | 647.655 | 3266317.0 |
| 2026-04-20 10:00:00 | QQQ | ETF | 647.67 | 647.82 | 646.1 | 646.405 | 1833506.0 |
| 2026-04-20 10:30:00 | QQQ | ETF | 646.39 | 646.6594 | 643.58 | 644.15 | 3141745.0 |
| 2026-04-20 11:00:00 | QQQ | ETF | 644.16 | 645.9 | 642.52 | 645.65 | 3270440.0 |
| 2026-04-20 11:30:00 | QQQ | ETF | 645.67 | 645.67 | 644.08 | 644.67 | 1452014.0 |
| 2026-04-20 12:00:00 | QQQ | ETF | 644.67 | 645.39 | 644.23 | 645.08 | 1046710.0 |
| 2026-04-20 12:30:00 | QQQ | ETF | 645.11 | 645.66 | 644.87 | 645.17 | 710055.0 |
> showing 50 of 46,468 rows — these rows as CSV