PREVIEW / etf_30min / 2025-07-11
file: by_date/etf_30min/2025/2025-07-11.parquet size: 983 KB rows: 40,272
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 |
|---|---|---|---|---|---|---|---|
| 2025-07-11 04:00:00 | SPY | ETF | 622.74 | 624.7 | 622.21 | 622.69 | 55259.0 |
| 2025-07-11 04:30:00 | SPY | ETF | 622.62 | 622.98 | 622.34 | 622.77 | 14946.0 |
| 2025-07-11 05:00:00 | SPY | ETF | 622.73 | 622.99 | 622.31 | 622.31 | 20554.0 |
| 2025-07-11 05:30:00 | SPY | ETF | 622.44 | 622.7 | 621.66 | 621.74 | 17463.0 |
| 2025-07-11 06:00:00 | SPY | ETF | 621.65 | 622.27 | 621.4 | 621.9 | 36199.0 |
| 2025-07-11 06:30:00 | SPY | ETF | 621.97 | 622.06 | 621.5 | 621.77 | 52280.0 |
| 2025-07-11 07:00:00 | SPY | ETF | 621.76 | 622.67 | 621.71 | 622.64 | 146294.0 |
| 2025-07-11 07:30:00 | SPY | ETF | 622.67 | 623.25 | 622.61 | 622.81 | 123448.0 |
| 2025-07-11 08:00:00 | SPY | ETF | 621.9 | 624.71 | 621.49 | 622.31 | 222669.0 |
| 2025-07-11 08:30:00 | SPY | ETF | 622.34 | 622.81 | 621.6638 | 622.62 | 116731.0 |
| 2025-07-11 09:00:00 | SPY | ETF | 622.6196 | 622.82 | 622.2 | 622.74 | 285783.0 |
| 2025-07-11 09:30:00 | SPY | ETF | 622.74 | 623.52 | 621.53 | 623.23 | 5385204.0 |
| 2025-07-11 10:00:00 | SPY | ETF | 623.24 | 624.26 | 622.98 | 624.005 | 2863599.0 |
| 2025-07-11 10:30:00 | SPY | ETF | 624.0 | 624.37 | 623.26 | 623.86 | 2613380.0 |
| 2025-07-11 11:00:00 | SPY | ETF | 623.86 | 623.9 | 622.71 | 623.39 | 3185560.0 |
| 2025-07-11 11:30:00 | SPY | ETF | 623.4 | 624.64 | 623.35 | 623.775 | 3104769.0 |
| 2025-07-11 12:00:00 | SPY | ETF | 623.78 | 624.09 | 623.15 | 623.945 | 2318271.0 |
| 2025-07-11 12:30:00 | SPY | ETF | 623.95 | 624.425 | 623.56 | 624.3458 | 1859314.0 |
| 2025-07-11 13:00:00 | SPY | ETF | 624.35 | 624.58 | 624.12 | 624.45 | 2009801.0 |
| 2025-07-11 13:30:00 | SPY | ETF | 624.45 | 624.58 | 623.75 | 624.5 | 2423987.0 |
| 2025-07-11 14:00:00 | SPY | ETF | 624.49 | 624.7 | 624.1 | 624.265 | 2327218.0 |
| 2025-07-11 14:30:00 | SPY | ETF | 624.265 | 624.86 | 624.17 | 624.36 | 2690499.0 |
| 2025-07-11 15:00:00 | SPY | ETF | 624.35 | 624.72 | 623.13 | 624.445 | 5202953.0 |
| 2025-07-11 15:30:00 | SPY | ETF | 624.45 | 624.58 | 623.47 | 623.61 | 7832059.0 |
| 2025-07-11 16:00:00 | SPY | ETF | 623.6 | 623.65 | 623.0 | 623.1399 | 1656579.0 |
| 2025-07-11 16:30:00 | SPY | ETF | 623.13 | 623.41 | 623.01 | 623.03 | 205912.0 |
| 2025-07-11 17:00:00 | SPY | ETF | 623.18 | 623.18 | 623.0 | 623.04 | 39596.0 |
| 2025-07-11 17:30:00 | SPY | ETF | 623.09 | 623.24 | 623.09 | 623.14 | 10717.0 |
| 2025-07-11 18:00:00 | SPY | ETF | 623.1146 | 623.3 | 623.1 | 623.15 | 8397.0 |
| 2025-07-11 18:30:00 | SPY | ETF | 623.18 | 623.2 | 623.1001 | 623.2 | 15202.0 |
| 2025-07-11 19:00:00 | SPY | ETF | 623.125 | 623.17 | 623.1 | 623.1099 | 2487.0 |
| 2025-07-11 19:30:00 | SPY | ETF | 623.16 | 623.19 | 622.95 | 623.04 | 14060.0 |
| 2025-07-11 04:00:00 | QQQ | ETF | 553.0 | 554.17 | 552.24 | 552.7 | 49558.0 |
| 2025-07-11 04:30:00 | QQQ | ETF | 552.68 | 553.12 | 552.46 | 553.02 | 22489.0 |
| 2025-07-11 05:00:00 | QQQ | ETF | 553.03 | 553.2 | 552.58 | 552.59 | 34093.0 |
| 2025-07-11 05:30:00 | QQQ | ETF | 552.55 | 553.1 | 551.99 | 552.12 | 41886.0 |
| 2025-07-11 06:00:00 | QQQ | ETF | 552.07 | 552.76 | 551.86 | 552.4 | 33529.0 |
| 2025-07-11 06:30:00 | QQQ | ETF | 552.46 | 552.54 | 552.0 | 552.3 | 29294.0 |
| 2025-07-11 07:00:00 | QQQ | ETF | 552.3 | 553.1 | 552.21 | 553.05 | 52953.0 |
| 2025-07-11 07:30:00 | QQQ | ETF | 553.08 | 553.5 | 552.88 | 553.14 | 60138.0 |
| 2025-07-11 08:00:00 | QQQ | ETF | 552.35 | 554.68 | 551.92 | 552.72 | 174471.0 |
| 2025-07-11 08:30:00 | QQQ | ETF | 552.72 | 553.25 | 552.55 | 553.06 | 62411.0 |
| 2025-07-11 09:00:00 | QQQ | ETF | 552.99 | 553.4 | 552.67 | 553.33 | 159279.0 |
| 2025-07-11 09:30:00 | QQQ | ETF | 553.3 | 554.52 | 552.05 | 554.43 | 4011483.0 |
| 2025-07-11 10:00:00 | QQQ | ETF | 554.43 | 555.39 | 553.95 | 555.09 | 2324241.0 |
| 2025-07-11 10:30:00 | QQQ | ETF | 555.08 | 555.48 | 554.1 | 554.55 | 2130348.0 |
| 2025-07-11 11:00:00 | QQQ | ETF | 554.55 | 554.68 | 553.11 | 554.095 | 1956358.0 |
| 2025-07-11 11:30:00 | QQQ | ETF | 554.09 | 555.51 | 554.05 | 554.71 | 1871768.0 |
| 2025-07-11 12:00:00 | QQQ | ETF | 554.72 | 555.17 | 554.3 | 555.1001 | 1520799.0 |
| 2025-07-11 12:30:00 | QQQ | ETF | 555.11 | 555.48 | 554.56 | 555.35 | 1253450.0 |
> showing 50 of 40,272 rows — these rows as CSV