PREVIEW / etf_30min / 2026-01-02
file: by_date/etf_30min/2026/2026-01-02.parquet size: 1.1 MB rows: 46,709
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-01-02 04:00:00 | SPY | ETF | 683.9 | 686.63 | 683.9 | 686.51 | 105982.0 |
| 2026-01-02 04:30:00 | SPY | ETF | 686.56 | 686.69 | 686.36 | 686.64 | 51684.0 |
| 2026-01-02 05:00:00 | SPY | ETF | 686.66 | 686.7 | 686.22 | 686.22 | 17051.0 |
| 2026-01-02 05:30:00 | SPY | ETF | 686.21 | 686.58 | 686.01 | 686.45 | 51450.0 |
| 2026-01-02 06:00:00 | SPY | ETF | 686.48 | 686.67 | 686.11 | 686.18 | 23843.0 |
| 2026-01-02 06:30:00 | SPY | ETF | 686.16 | 686.37 | 686.07 | 686.24 | 77085.0 |
| 2026-01-02 07:00:00 | SPY | ETF | 686.18 | 686.23 | 685.69 | 685.95 | 168939.0 |
| 2026-01-02 07:30:00 | SPY | ETF | 685.99 | 686.19 | 685.82 | 686.039 | 102139.0 |
| 2026-01-02 08:00:00 | SPY | ETF | 686.16 | 686.7036 | 684.94 | 685.77 | 254372.0 |
| 2026-01-02 08:30:00 | SPY | ETF | 685.77 | 685.98 | 685.5 | 685.74 | 177161.0 |
| 2026-01-02 09:00:00 | SPY | ETF | 685.72 | 686.06 | 685.31 | 685.7 | 364207.0 |
| 2026-01-02 09:30:00 | SPY | ETF | 685.71 | 686.84 | 684.12 | 686.19 | 9121371.0 |
| 2026-01-02 10:00:00 | SPY | ETF | 686.21 | 686.87 | 681.58 | 682.45 | 9166710.0 |
| 2026-01-02 10:30:00 | SPY | ETF | 682.45 | 684.59 | 681.1 | 681.455 | 7693197.0 |
| 2026-01-02 11:00:00 | SPY | ETF | 681.46 | 682.4 | 680.42 | 681.81 | 6022953.0 |
| 2026-01-02 11:30:00 | SPY | ETF | 681.81 | 682.65 | 680.28 | 681.158 | 3788723.0 |
| 2026-01-02 12:00:00 | SPY | ETF | 681.15 | 682.5 | 680.64 | 682.45 | 2755229.0 |
| 2026-01-02 12:30:00 | SPY | ETF | 682.45 | 682.8009 | 680.98 | 681.18 | 2640201.0 |
| 2026-01-02 13:00:00 | SPY | ETF | 681.18 | 681.7886 | 680.64 | 680.98 | 2072589.0 |
| 2026-01-02 13:30:00 | SPY | ETF | 680.98 | 681.36 | 679.82 | 680.525 | 2746869.0 |
| 2026-01-02 14:00:00 | SPY | ETF | 680.525 | 683.12 | 680.35 | 682.95 | 5071243.0 |
| 2026-01-02 14:30:00 | SPY | ETF | 682.94 | 683.95 | 682.89 | 683.13 | 5013874.0 |
| 2026-01-02 15:00:00 | SPY | ETF | 683.13 | 683.7 | 682.85 | 683.24 | 4103996.0 |
| 2026-01-02 15:30:00 | SPY | ETF | 683.24 | 683.42 | 682.07 | 683.17 | 9789875.0 |
| 2026-01-02 16:00:00 | SPY | ETF | 683.17 | 683.64 | 683.05 | 683.36 | 2890223.0 |
| 2026-01-02 16:30:00 | SPY | ETF | 683.39 | 683.4 | 682.89 | 683.12 | 163392.0 |
| 2026-01-02 17:00:00 | SPY | ETF | 683.16 | 683.16 | 682.96 | 683.15 | 5747.0 |
| 2026-01-02 17:30:00 | SPY | ETF | 683.15 | 683.15 | 682.6 | 682.63 | 14865.0 |
| 2026-01-02 18:00:00 | SPY | ETF | 682.75 | 682.89 | 682.59 | 682.89 | 13180.0 |
| 2026-01-02 18:30:00 | SPY | ETF | 682.7612 | 682.899 | 682.6252 | 682.7 | 22691.0 |
| 2026-01-02 19:00:00 | SPY | ETF | 682.7556 | 682.85 | 682.6997 | 682.8 | 21834.0 |
| 2026-01-02 19:30:00 | SPY | ETF | 682.79 | 682.97 | 682.7711 | 682.9699 | 8560.0 |
| 2026-01-02 04:00:00 | QQQ | ETF | 619.0 | 621.33 | 619.0 | 621.16 | 102119.0 |
| 2026-01-02 04:30:00 | QQQ | ETF | 621.19 | 621.29 | 620.94 | 621.2 | 41290.0 |
| 2026-01-02 05:00:00 | QQQ | ETF | 621.23 | 621.3 | 620.71 | 620.8 | 26655.0 |
| 2026-01-02 05:30:00 | QQQ | ETF | 620.83 | 621.28 | 620.6 | 621.14 | 64350.0 |
| 2026-01-02 06:00:00 | QQQ | ETF | 621.14 | 621.41 | 620.78 | 620.81 | 39230.0 |
| 2026-01-02 06:30:00 | QQQ | ETF | 620.87 | 621.12 | 620.85 | 621.06 | 25868.0 |
| 2026-01-02 07:00:00 | QQQ | ETF | 621.05 | 621.05 | 619.93 | 620.32 | 93962.0 |
| 2026-01-02 07:30:00 | QQQ | ETF | 620.27 | 620.52 | 620.14 | 620.48 | 77314.0 |
| 2026-01-02 08:00:00 | QQQ | ETF | 620.85 | 621.32 | 618.31 | 620.32 | 249670.0 |
| 2026-01-02 08:30:00 | QQQ | ETF | 620.32 | 620.46 | 619.92 | 620.2398 | 124964.0 |
| 2026-01-02 09:00:00 | QQQ | ETF | 620.19 | 620.55 | 619.52 | 620.06 | 192572.0 |
| 2026-01-02 09:30:00 | QQQ | ETF | 620.09 | 622.85 | 618.9 | 621.19 | 7644008.0 |
| 2026-01-02 10:00:00 | QQQ | ETF | 621.18 | 622.27 | 614.61 | 615.41 | 7216515.0 |
| 2026-01-02 10:30:00 | QQQ | ETF | 615.41 | 618.12 | 612.31 | 612.665 | 6210885.0 |
| 2026-01-02 11:00:00 | QQQ | ETF | 612.68 | 613.453 | 610.75 | 612.76 | 6055547.0 |
| 2026-01-02 11:30:00 | QQQ | ETF | 612.73 | 613.93 | 611.0 | 611.95 | 2769015.0 |
| 2026-01-02 12:00:00 | QQQ | ETF | 611.92 | 613.425 | 611.31 | 613.0099 | 2025619.0 |
| 2026-01-02 12:30:00 | QQQ | ETF | 613.01 | 613.3372 | 611.26 | 611.56 | 1929169.0 |
> showing 50 of 46,709 rows — these rows as CSV