PREVIEW / etf_30min / 2026-01-08
file: by_date/etf_30min/2026/2026-01-08.parquet size: 1.1 MB rows: 46,472
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-08 04:00:00 | SPY | ETF | 688.68 | 688.93 | 688.35 | 688.5 | 14115.0 |
| 2026-01-08 04:30:00 | SPY | ETF | 688.44 | 688.52 | 688.0 | 688.4 | 12858.0 |
| 2026-01-08 05:00:00 | SPY | ETF | 688.37 | 688.41 | 687.92 | 688.0 | 7492.0 |
| 2026-01-08 05:30:00 | SPY | ETF | 687.97 | 688.47 | 687.97 | 688.47 | 9915.0 |
| 2026-01-08 06:00:00 | SPY | ETF | 688.43 | 688.78 | 688.43 | 688.64 | 5653.0 |
| 2026-01-08 06:30:00 | SPY | ETF | 688.56 | 688.72 | 687.83 | 688.44 | 38386.0 |
| 2026-01-08 07:00:00 | SPY | ETF | 688.32 | 688.62 | 687.95 | 688.53 | 59853.0 |
| 2026-01-08 07:30:00 | SPY | ETF | 688.51 | 688.56 | 688.1 | 688.36 | 25042.0 |
| 2026-01-08 08:00:00 | SPY | ETF | 688.01 | 689.31 | 687.0 | 689.1682 | 220985.0 |
| 2026-01-08 08:30:00 | SPY | ETF | 689.17 | 689.3746 | 688.78 | 689.1 | 100749.0 |
| 2026-01-08 09:00:00 | SPY | ETF | 689.07 | 689.27 | 688.59 | 688.8 | 182101.0 |
| 2026-01-08 09:30:00 | SPY | ETF | 688.81 | 689.3 | 687.49 | 688.28 | 8833136.0 |
| 2026-01-08 10:00:00 | SPY | ETF | 688.28 | 690.02 | 687.85 | 689.63 | 6139310.0 |
| 2026-01-08 10:30:00 | SPY | ETF | 689.65 | 689.97 | 688.51 | 689.84 | 5062179.0 |
| 2026-01-08 11:00:00 | SPY | ETF | 689.85 | 689.975 | 688.65 | 689.08 | 3820024.0 |
| 2026-01-08 11:30:00 | SPY | ETF | 689.08 | 690.085 | 688.44 | 689.9 | 3491532.0 |
| 2026-01-08 12:00:00 | SPY | ETF | 689.89 | 690.0 | 689.12 | 689.35 | 2209199.0 |
| 2026-01-08 12:30:00 | SPY | ETF | 689.34 | 690.615 | 689.3243 | 690.09 | 2445124.0 |
| 2026-01-08 13:00:00 | SPY | ETF | 690.09 | 690.19 | 688.79 | 689.5 | 3116099.0 |
| 2026-01-08 13:30:00 | SPY | ETF | 689.5 | 689.805 | 688.76 | 688.89 | 1942378.0 |
| 2026-01-08 14:00:00 | SPY | ETF | 688.89 | 689.35 | 688.28 | 688.92 | 2774216.0 |
| 2026-01-08 14:30:00 | SPY | ETF | 688.93 | 689.33 | 688.57 | 688.86 | 1972443.0 |
| 2026-01-08 15:00:00 | SPY | ETF | 688.85 | 689.65 | 688.71 | 689.575 | 2854568.0 |
| 2026-01-08 15:30:00 | SPY | ETF | 689.57 | 690.055 | 689.255 | 689.44 | 7538112.0 |
| 2026-01-08 16:00:00 | SPY | ETF | 689.45 | 690.08 | 689.45 | 690.06 | 1559242.0 |
| 2026-01-08 16:30:00 | SPY | ETF | 690.07 | 691.06 | 690.07 | 690.4 | 382314.0 |
| 2026-01-08 17:00:00 | SPY | ETF | 690.4699 | 690.6 | 690.17 | 690.53 | 67877.0 |
| 2026-01-08 17:30:00 | SPY | ETF | 690.51 | 690.81 | 690.51 | 690.6198 | 24310.0 |
| 2026-01-08 18:00:00 | SPY | ETF | 690.61 | 690.7 | 690.05 | 690.07 | 88681.0 |
| 2026-01-08 18:30:00 | SPY | ETF | 690.06 | 690.1 | 689.65 | 689.75 | 29965.0 |
| 2026-01-08 19:00:00 | SPY | ETF | 689.7488 | 690.05 | 689.6208 | 689.8799 | 14911.0 |
| 2026-01-08 19:30:00 | SPY | ETF | 689.9 | 689.99 | 689.471 | 689.4714 | 25383.0 |
| 2026-01-08 04:00:00 | QQQ | ETF | 622.83 | 623.2 | 622.42 | 622.6 | 31127.0 |
| 2026-01-08 04:30:00 | QQQ | ETF | 622.57 | 622.63 | 622.15 | 622.58 | 26847.0 |
| 2026-01-08 05:00:00 | QQQ | ETF | 622.57 | 622.57 | 621.97 | 622.12 | 21529.0 |
| 2026-01-08 05:30:00 | QQQ | ETF | 622.06 | 622.69 | 622.06 | 622.64 | 20571.0 |
| 2026-01-08 06:00:00 | QQQ | ETF | 622.73 | 622.97 | 622.47 | 622.81 | 16603.0 |
| 2026-01-08 06:30:00 | QQQ | ETF | 622.71 | 623.0 | 621.9 | 622.6 | 49467.0 |
| 2026-01-08 07:00:00 | QQQ | ETF | 622.65 | 622.8 | 622.1 | 622.74 | 49387.0 |
| 2026-01-08 07:30:00 | QQQ | ETF | 622.7 | 622.79 | 622.27 | 622.57 | 31659.0 |
| 2026-01-08 08:00:00 | QQQ | ETF | 622.23 | 623.58 | 620.29 | 623.48 | 237491.0 |
| 2026-01-08 08:30:00 | QQQ | ETF | 623.45 | 623.7787 | 623.0 | 623.35 | 154060.0 |
| 2026-01-08 09:00:00 | QQQ | ETF | 623.29 | 623.62 | 622.75 | 622.96 | 185912.0 |
| 2026-01-08 09:30:00 | QQQ | ETF | 623.03 | 623.42 | 618.468 | 618.62 | 8237060.0 |
| 2026-01-08 10:00:00 | QQQ | ETF | 618.6 | 621.25 | 617.8 | 620.87 | 4589459.0 |
| 2026-01-08 10:30:00 | QQQ | ETF | 620.86 | 621.07 | 618.798 | 620.54 | 4212100.0 |
| 2026-01-08 11:00:00 | QQQ | ETF | 620.55 | 620.59 | 618.86 | 619.1 | 2649007.0 |
| 2026-01-08 11:30:00 | QQQ | ETF | 619.08 | 620.385 | 618.12 | 620.19 | 2548916.0 |
| 2026-01-08 12:00:00 | QQQ | ETF | 620.19 | 620.42 | 619.13 | 619.37 | 1931688.0 |
| 2026-01-08 12:30:00 | QQQ | ETF | 619.36 | 620.99 | 619.3299 | 620.4211 | 1858501.0 |
> showing 50 of 46,472 rows — these rows as CSV