PREVIEW / etf_30min / 2026-04-09
file: by_date/etf_30min/2026/2026-04-09.parquet size: 1.1 MB rows: 46,557
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-09 04:00:00 | SPY | ETF | 673.97 | 675.27 | 672.88 | 672.9 | 148317.0 |
| 2026-04-09 04:30:00 | SPY | ETF | 673.05 | 673.7 | 672.93 | 673.2 | 22408.0 |
| 2026-04-09 05:00:00 | SPY | ETF | 673.18 | 673.8 | 672.87 | 673.645 | 15457.0 |
| 2026-04-09 05:30:00 | SPY | ETF | 673.68 | 673.81 | 673.45 | 673.77 | 7041.0 |
| 2026-04-09 06:00:00 | SPY | ETF | 673.75 | 673.96 | 673.47 | 673.81 | 27744.0 |
| 2026-04-09 06:30:00 | SPY | ETF | 673.8 | 674.0 | 673.34 | 673.41 | 41070.0 |
| 2026-04-09 07:00:00 | SPY | ETF | 673.41 | 673.536 | 673.01 | 673.057 | 115435.0 |
| 2026-04-09 07:30:00 | SPY | ETF | 673.12 | 674.46 | 673.12 | 674.247 | 174479.0 |
| 2026-04-09 08:00:00 | SPY | ETF | 674.213 | 674.45 | 674.0 | 674.12 | 74147.0 |
| 2026-04-09 08:30:00 | SPY | ETF | 674.076 | 674.88 | 673.64 | 674.27 | 356746.0 |
| 2026-04-09 09:00:00 | SPY | ETF | 674.27 | 674.78 | 673.99 | 674.7 | 261206.0 |
| 2026-04-09 09:30:00 | SPY | ETF | 674.71 | 675.79 | 674.43 | 675.12 | 4093700.0 |
| 2026-04-09 10:00:00 | SPY | ETF | 675.115 | 675.69 | 673.93 | 674.14 | 3047723.0 |
| 2026-04-09 10:30:00 | SPY | ETF | 674.14 | 675.5 | 673.77 | 675.24 | 3253994.0 |
| 2026-04-09 11:00:00 | SPY | ETF | 675.25 | 676.55 | 674.61 | 676.0 | 3573670.0 |
| 2026-04-09 11:30:00 | SPY | ETF | 675.99 | 678.9 | 675.73 | 678.81 | 4743029.0 |
| 2026-04-09 12:00:00 | SPY | ETF | 678.805 | 680.75 | 678.69 | 679.97 | 3834243.0 |
| 2026-04-09 12:30:00 | SPY | ETF | 679.98 | 680.1 | 678.97 | 679.85 | 2240767.0 |
| 2026-04-09 13:00:00 | SPY | ETF | 679.85 | 681.016 | 679.71 | 680.52 | 2320854.0 |
| 2026-04-09 13:30:00 | SPY | ETF | 680.51 | 681.16 | 679.66 | 680.41 | 2015350.0 |
| 2026-04-09 14:00:00 | SPY | ETF | 680.425 | 680.61 | 678.58 | 678.98 | 3069647.0 |
| 2026-04-09 14:30:00 | SPY | ETF | 678.965 | 679.42 | 678.44 | 679.23 | 2194662.0 |
| 2026-04-09 15:00:00 | SPY | ETF | 679.24 | 680.24 | 678.95 | 680.01 | 2049068.0 |
| 2026-04-09 15:30:00 | SPY | ETF | 680.01 | 680.67 | 679.78 | 680.08 | 4915514.0 |
| 2026-04-09 16:00:00 | SPY | ETF | 680.07 | 680.22 | 679.27 | 679.59 | 3076058.0 |
| 2026-04-09 16:30:00 | SPY | ETF | 679.6 | 679.91 | 679.43 | 679.47 | 232294.0 |
| 2026-04-09 17:00:00 | SPY | ETF | 679.55 | 679.8 | 678.199 | 678.81 | 250046.0 |
| 2026-04-09 17:30:00 | SPY | ETF | 679.02 | 679.42 | 678.87 | 679.41 | 38764.0 |
| 2026-04-09 18:00:00 | SPY | ETF | 679.41 | 679.81 | 679.29 | 679.7 | 62319.0 |
| 2026-04-09 18:30:00 | SPY | ETF | 679.7 | 679.76 | 678.9 | 678.921 | 85975.0 |
| 2026-04-09 19:00:00 | SPY | ETF | 679.01 | 679.12 | 678.7 | 679.01 | 35634.0 |
| 2026-04-09 19:30:00 | SPY | ETF | 679.01 | 679.42 | 678.93 | 679.121 | 28842.0 |
| 2026-04-09 20:00:00 | SPY | ETF | 679.179 | 679.28 | 679.15 | 679.28 | 1370.0 |
| 2026-04-09 04:00:00 | QQQ | ETF | 603.3 | 605.39 | 602.9 | 603.09 | 307537.0 |
| 2026-04-09 04:30:00 | QQQ | ETF | 603.06 | 604.1 | 603.06 | 603.4 | 45123.0 |
| 2026-04-09 05:00:00 | QQQ | ETF | 603.43 | 604.26 | 603.18 | 604.23 | 30653.0 |
| 2026-04-09 05:30:00 | QQQ | ETF | 604.2 | 604.44 | 603.9 | 604.36 | 25693.0 |
| 2026-04-09 06:00:00 | QQQ | ETF | 604.44 | 604.67 | 604.09 | 604.55 | 57698.0 |
| 2026-04-09 06:30:00 | QQQ | ETF | 604.54 | 604.6 | 603.8 | 603.93 | 46684.0 |
| 2026-04-09 07:00:00 | QQQ | ETF | 603.97 | 604.0 | 603.48 | 603.64 | 79734.0 |
| 2026-04-09 07:30:00 | QQQ | ETF | 603.64 | 604.91 | 603.63 | 604.83 | 130832.0 |
| 2026-04-09 08:00:00 | QQQ | ETF | 604.83 | 605.23 | 604.64 | 604.71 | 146577.0 |
| 2026-04-09 08:30:00 | QQQ | ETF | 604.76 | 605.5 | 604.41 | 604.73 | 170527.0 |
| 2026-04-09 09:00:00 | QQQ | ETF | 604.6 | 605.75 | 604.6 | 605.68 | 167444.0 |
| 2026-04-09 09:30:00 | QQQ | ETF | 605.72 | 606.67 | 604.12 | 604.61 | 3745600.0 |
| 2026-04-09 10:00:00 | QQQ | ETF | 604.58 | 605.33 | 603.09 | 603.34 | 2744640.0 |
| 2026-04-09 10:30:00 | QQQ | ETF | 603.34 | 605.25 | 603.03 | 604.92 | 1981500.0 |
| 2026-04-09 11:00:00 | QQQ | ETF | 604.98 | 606.51 | 604.379 | 605.49 | 2024169.0 |
| 2026-04-09 11:30:00 | QQQ | ETF | 605.49 | 608.76 | 605.151 | 608.555 | 3031515.0 |
| 2026-04-09 12:00:00 | QQQ | ETF | 608.54 | 610.36 | 608.43 | 609.252 | 2784226.0 |
> showing 50 of 46,557 rows — these rows as CSV