PREVIEW / etf_30min / 2026-01-05
file: by_date/etf_30min/2026/2026-01-05.parquet size: 1.2 MB rows: 48,959
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-05 04:00:00 | SPY | ETF | 684.25 | 685.17 | 684.25 | 684.39 | 113816.0 |
| 2026-01-05 04:30:00 | SPY | ETF | 684.38 | 684.86 | 684.35 | 684.58 | 10673.0 |
| 2026-01-05 05:00:00 | SPY | ETF | 684.68 | 685.3 | 684.61 | 685.13 | 17847.0 |
| 2026-01-05 05:30:00 | SPY | ETF | 685.04 | 685.27 | 684.91 | 685.27 | 17418.0 |
| 2026-01-05 06:00:00 | SPY | ETF | 685.24 | 685.37 | 685.0 | 685.12 | 45956.0 |
| 2026-01-05 06:30:00 | SPY | ETF | 685.07 | 685.5 | 685.05 | 685.44 | 69987.0 |
| 2026-01-05 07:00:00 | SPY | ETF | 685.37 | 685.69 | 685.12 | 685.17 | 208818.0 |
| 2026-01-05 07:30:00 | SPY | ETF | 685.19 | 685.48 | 684.96 | 685.25 | 59583.0 |
| 2026-01-05 08:00:00 | SPY | ETF | 685.3 | 685.62 | 683.81 | 684.56 | 211487.0 |
| 2026-01-05 08:30:00 | SPY | ETF | 684.55 | 685.71 | 684.55 | 685.42 | 150930.0 |
| 2026-01-05 09:00:00 | SPY | ETF | 685.42 | 686.6404 | 685.4 | 686.52 | 287429.0 |
| 2026-01-05 09:30:00 | SPY | ETF | 686.54 | 687.88 | 686.375 | 687.06 | 9512615.0 |
| 2026-01-05 10:00:00 | SPY | ETF | 687.08 | 688.61 | 686.63 | 688.5256 | 5154775.0 |
| 2026-01-05 10:30:00 | SPY | ETF | 688.52 | 688.82 | 687.96 | 688.32 | 3874425.0 |
| 2026-01-05 11:00:00 | SPY | ETF | 688.32 | 688.87 | 687.96 | 688.64 | 3229981.0 |
| 2026-01-05 11:30:00 | SPY | ETF | 688.63 | 689.43 | 688.425 | 688.91 | 4480238.0 |
| 2026-01-05 12:00:00 | SPY | ETF | 688.91 | 689.13 | 688.21 | 688.35 | 2533036.0 |
| 2026-01-05 12:30:00 | SPY | ETF | 688.3599 | 688.79 | 688.203 | 688.58 | 2148857.0 |
| 2026-01-05 13:00:00 | SPY | ETF | 688.57 | 688.75 | 687.65 | 688.38 | 2773517.0 |
| 2026-01-05 13:30:00 | SPY | ETF | 688.36 | 688.775 | 688.3 | 688.54 | 1976299.0 |
| 2026-01-05 14:00:00 | SPY | ETF | 688.54 | 688.715 | 688.13 | 688.185 | 2145785.0 |
| 2026-01-05 14:30:00 | SPY | ETF | 688.19 | 688.3 | 687.29 | 687.6198 | 3284092.0 |
| 2026-01-05 15:00:00 | SPY | ETF | 687.615 | 688.24 | 687.51 | 687.966 | 3139089.0 |
| 2026-01-05 15:30:00 | SPY | ETF | 687.965 | 688.12 | 687.16 | 687.73 | 10547147.0 |
| 2026-01-05 16:00:00 | SPY | ETF | 687.73 | 687.9764 | 687.38 | 687.7 | 2155259.0 |
| 2026-01-05 16:30:00 | SPY | ETF | 687.74 | 687.78 | 687.49 | 687.52 | 94811.0 |
| 2026-01-05 17:00:00 | SPY | ETF | 687.54 | 687.86 | 687.469 | 687.62 | 22062.0 |
| 2026-01-05 17:30:00 | SPY | ETF | 687.62 | 688.1 | 687.55 | 687.81 | 26040.0 |
| 2026-01-05 18:00:00 | SPY | ETF | 687.83 | 687.9458 | 687.61 | 687.76 | 38321.0 |
| 2026-01-05 18:30:00 | SPY | ETF | 687.61 | 687.61 | 687.34 | 687.41 | 20395.0 |
| 2026-01-05 19:00:00 | SPY | ETF | 687.43 | 687.56 | 687.25 | 687.5 | 17125.0 |
| 2026-01-05 19:30:00 | SPY | ETF | 687.48 | 687.5 | 687.2 | 687.38 | 66398.0 |
| 2026-01-05 04:00:00 | QQQ | ETF | 616.01 | 616.66 | 615.83 | 615.94 | 47717.0 |
| 2026-01-05 04:30:00 | QQQ | ETF | 615.87 | 616.5 | 615.82 | 616.21 | 26954.0 |
| 2026-01-05 05:00:00 | QQQ | ETF | 616.25 | 617.19 | 616.19 | 616.96 | 34204.0 |
| 2026-01-05 05:30:00 | QQQ | ETF | 616.9 | 617.28 | 616.73 | 617.19 | 26979.0 |
| 2026-01-05 06:00:00 | QQQ | ETF | 617.2 | 617.51 | 616.99 | 617.07 | 35535.0 |
| 2026-01-05 06:30:00 | QQQ | ETF | 617.11 | 617.76 | 617.11 | 617.52 | 42133.0 |
| 2026-01-05 07:00:00 | QQQ | ETF | 617.54 | 617.97 | 617.3 | 617.34 | 79669.0 |
| 2026-01-05 07:30:00 | QQQ | ETF | 617.34 | 617.59 | 616.989 | 617.25 | 67104.0 |
| 2026-01-05 08:00:00 | QQQ | ETF | 617.3 | 617.8695 | 612.661 | 616.8 | 356551.0 |
| 2026-01-05 08:30:00 | QQQ | ETF | 616.83 | 618.07 | 616.83 | 617.71 | 236819.0 |
| 2026-01-05 09:00:00 | QQQ | ETF | 617.73 | 619.4 | 617.69 | 619.39 | 537412.0 |
| 2026-01-05 09:30:00 | QQQ | ETF | 619.3 | 619.98 | 616.72 | 618.06 | 8649010.0 |
| 2026-01-05 10:00:00 | QQQ | ETF | 618.1 | 620.23 | 617.41 | 619.9801 | 3741745.0 |
| 2026-01-05 10:30:00 | QQQ | ETF | 620.0 | 620.39 | 619.12 | 619.78 | 2456251.0 |
| 2026-01-05 11:00:00 | QQQ | ETF | 619.78 | 620.54 | 619.4601 | 620.24 | 2465105.0 |
| 2026-01-05 11:30:00 | QQQ | ETF | 620.23 | 620.81 | 619.61 | 619.65 | 2433676.0 |
| 2026-01-05 12:00:00 | QQQ | ETF | 619.66 | 619.99 | 618.619 | 618.92 | 2106360.0 |
| 2026-01-05 12:30:00 | QQQ | ETF | 618.95 | 619.11 | 618.425 | 618.9 | 1672628.0 |
> showing 50 of 48,959 rows — these rows as CSV