PREVIEW / etf_30min / 2026-01-21
file: by_date/etf_30min/2026/2026-01-21.parquet size: 1.1 MB rows: 49,125
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-21 04:00:00 | SPY | ETF | 679.73 | 679.89 | 679.17 | 679.37 | 27411.0 |
| 2026-01-21 04:30:00 | SPY | ETF | 679.29 | 679.31 | 678.07 | 678.07 | 62825.0 |
| 2026-01-21 05:00:00 | SPY | ETF | 678.06 | 679.03 | 677.94 | 678.98 | 27345.0 |
| 2026-01-21 05:30:00 | SPY | ETF | 679.03 | 679.26 | 678.57 | 678.57 | 25117.0 |
| 2026-01-21 06:00:00 | SPY | ETF | 678.5 | 678.61 | 678.28 | 678.31 | 25092.0 |
| 2026-01-21 06:30:00 | SPY | ETF | 678.39 | 678.51 | 676.29 | 676.39 | 99812.0 |
| 2026-01-21 07:00:00 | SPY | ETF | 676.38 | 677.25 | 676.05 | 676.9 | 175974.0 |
| 2026-01-21 07:30:00 | SPY | ETF | 676.84 | 677.0 | 675.88 | 676.96 | 156116.0 |
| 2026-01-21 08:00:00 | SPY | ETF | 676.51 | 680.04 | 675.8877 | 676.56 | 348482.0 |
| 2026-01-21 08:30:00 | SPY | ETF | 676.55 | 677.61 | 676.0 | 676.86 | 416917.0 |
| 2026-01-21 09:00:00 | SPY | ETF | 676.84 | 680.94 | 676.58 | 679.67 | 2379383.0 |
| 2026-01-21 09:30:00 | SPY | ETF | 679.65 | 682.675 | 678.97 | 682.49 | 12286177.0 |
| 2026-01-21 10:00:00 | SPY | ETF | 682.48 | 683.42 | 681.65 | 683.02 | 6019916.0 |
| 2026-01-21 10:30:00 | SPY | ETF | 683.02 | 685.13 | 682.94 | 684.7321 | 5116221.0 |
| 2026-01-21 11:00:00 | SPY | ETF | 684.73 | 684.84 | 683.83 | 684.25 | 4285517.0 |
| 2026-01-21 11:30:00 | SPY | ETF | 684.25 | 684.3 | 679.91 | 680.045 | 8407691.0 |
| 2026-01-21 12:00:00 | SPY | ETF | 680.05 | 680.74 | 678.13 | 679.85 | 6531008.0 |
| 2026-01-21 12:30:00 | SPY | ETF | 679.865 | 680.97 | 678.99 | 680.63 | 4497358.0 |
| 2026-01-21 13:00:00 | SPY | ETF | 680.62 | 680.77 | 678.63 | 680.57 | 4044447.0 |
| 2026-01-21 13:30:00 | SPY | ETF | 680.57 | 681.5 | 679.72 | 680.99 | 3440060.0 |
| 2026-01-21 14:00:00 | SPY | ETF | 680.99 | 685.02 | 679.87 | 684.4 | 6660964.0 |
| 2026-01-21 14:30:00 | SPY | ETF | 684.41 | 688.71 | 684.33 | 688.475 | 14187664.0 |
| 2026-01-21 15:00:00 | SPY | ETF | 688.475 | 688.735 | 685.315 | 685.355 | 8170584.0 |
| 2026-01-21 15:30:00 | SPY | ETF | 685.35 | 686.16 | 684.63 | 685.33 | 13065448.0 |
| 2026-01-21 16:00:00 | SPY | ETF | 685.32 | 686.18 | 685.2116 | 685.831 | 3240921.0 |
| 2026-01-21 16:30:00 | SPY | ETF | 685.8884 | 685.89 | 685.55 | 685.79 | 134780.0 |
| 2026-01-21 17:00:00 | SPY | ETF | 685.76 | 685.9 | 685.62 | 685.8982 | 40414.0 |
| 2026-01-21 17:30:00 | SPY | ETF | 685.9 | 686.22 | 685.77 | 686.09 | 17753.0 |
| 2026-01-21 18:00:00 | SPY | ETF | 686.16 | 687.0102 | 686.16 | 686.879 | 58125.0 |
| 2026-01-21 18:30:00 | SPY | ETF | 686.81 | 686.81 | 686.18 | 686.74 | 24626.0 |
| 2026-01-21 19:00:00 | SPY | ETF | 686.7 | 687.19 | 686.49 | 686.939 | 21700.0 |
| 2026-01-21 19:30:00 | SPY | ETF | 686.97 | 687.1205 | 686.6 | 686.9 | 18806.0 |
| 2026-01-21 04:00:00 | QQQ | ETF | 610.5 | 610.5 | 609.2 | 609.53 | 60751.0 |
| 2026-01-21 04:30:00 | QQQ | ETF | 609.48 | 609.48 | 607.9 | 607.91 | 98761.0 |
| 2026-01-21 05:00:00 | QQQ | ETF | 607.91 | 609.16 | 607.75 | 609.0 | 46728.0 |
| 2026-01-21 05:30:00 | QQQ | ETF | 609.1 | 609.3 | 608.45 | 608.48 | 25584.0 |
| 2026-01-21 06:00:00 | QQQ | ETF | 608.43 | 608.62 | 608.07 | 608.24 | 49076.0 |
| 2026-01-21 06:30:00 | QQQ | ETF | 608.23 | 608.57 | 605.76 | 605.91 | 145699.0 |
| 2026-01-21 07:00:00 | QQQ | ETF | 605.9 | 606.93 | 605.5 | 606.53 | 162201.0 |
| 2026-01-21 07:30:00 | QQQ | ETF | 606.55 | 606.97 | 605.6 | 606.88 | 92064.0 |
| 2026-01-21 08:00:00 | QQQ | ETF | 606.06 | 610.6 | 605.46 | 606.62 | 440673.0 |
| 2026-01-21 08:30:00 | QQQ | ETF | 606.6 | 607.79 | 605.77 | 606.85 | 450077.0 |
| 2026-01-21 09:00:00 | QQQ | ETF | 606.79 | 610.95 | 606.51 | 609.47 | 1577097.0 |
| 2026-01-21 09:30:00 | QQQ | ETF | 609.47 | 612.93 | 607.8636 | 612.6 | 8162602.0 |
| 2026-01-21 10:00:00 | QQQ | ETF | 612.6 | 614.08 | 611.89 | 613.9045 | 4550240.0 |
| 2026-01-21 10:30:00 | QQQ | ETF | 613.9 | 616.49 | 613.87 | 616.055 | 3971647.0 |
| 2026-01-21 11:00:00 | QQQ | ETF | 616.05 | 616.6198 | 615.39 | 615.75 | 2784356.0 |
| 2026-01-21 11:30:00 | QQQ | ETF | 615.75 | 615.8 | 610.09 | 610.302 | 6423088.0 |
| 2026-01-21 12:00:00 | QQQ | ETF | 610.31 | 611.09 | 608.22 | 609.75 | 4540645.0 |
| 2026-01-21 12:30:00 | QQQ | ETF | 609.75 | 611.0501 | 608.85 | 610.67 | 3262945.0 |
> showing 50 of 49,125 rows — these rows as CSV