PREVIEW / etf_30min / 2025-09-12
file: by_date/etf_30min/2025/2025-09-12.parquet size: 1.0 MB rows: 41,689
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-09-12 04:00:00 | SPY | ETF | 657.17 | 657.28 | 656.29 | 656.79 | 23388.0 |
| 2025-09-12 04:30:00 | SPY | ETF | 656.83 | 656.94 | 656.7 | 656.94 | 7616.0 |
| 2025-09-12 05:00:00 | SPY | ETF | 656.88 | 657.0 | 656.88 | 656.97 | 2759.0 |
| 2025-09-12 05:30:00 | SPY | ETF | 657.0 | 657.14 | 656.85 | 657.02 | 19543.0 |
| 2025-09-12 06:00:00 | SPY | ETF | 657.01 | 657.09 | 656.95 | 657.09 | 4169.0 |
| 2025-09-12 06:30:00 | SPY | ETF | 657.03 | 657.27 | 657.03 | 657.27 | 6154.0 |
| 2025-09-12 07:00:00 | SPY | ETF | 657.2 | 657.43 | 657.0 | 657.43 | 10611.0 |
| 2025-09-12 07:30:00 | SPY | ETF | 657.42 | 657.6 | 657.31 | 657.581 | 12968.0 |
| 2025-09-12 08:00:00 | SPY | ETF | 657.54 | 657.97 | 656.4504 | 657.51 | 58688.0 |
| 2025-09-12 08:30:00 | SPY | ETF | 657.56 | 657.7 | 657.11 | 657.65 | 94700.0 |
| 2025-09-12 09:00:00 | SPY | ETF | 657.64 | 657.92 | 657.59 | 657.59 | 61926.0 |
| 2025-09-12 09:30:00 | SPY | ETF | 657.59 | 658.068 | 657.145 | 657.99 | 5822295.0 |
| 2025-09-12 10:00:00 | SPY | ETF | 658.01 | 658.2 | 657.32 | 657.97 | 3612129.0 |
| 2025-09-12 10:30:00 | SPY | ETF | 657.96 | 658.48 | 657.685 | 658.3804 | 2603867.0 |
| 2025-09-12 11:00:00 | SPY | ETF | 658.38 | 658.435 | 657.62 | 657.64 | 2328424.0 |
| 2025-09-12 11:30:00 | SPY | ETF | 657.64 | 657.815 | 657.21 | 657.62 | 2191285.0 |
| 2025-09-12 12:00:00 | SPY | ETF | 657.61 | 658.06 | 657.3099 | 658.05 | 1894048.0 |
| 2025-09-12 12:30:00 | SPY | ETF | 658.05 | 658.2 | 657.65 | 658.07 | 2050242.0 |
| 2025-09-12 13:00:00 | SPY | ETF | 658.075 | 658.28 | 657.795 | 658.1 | 1886632.0 |
| 2025-09-12 13:30:00 | SPY | ETF | 658.1 | 658.4609 | 657.9 | 658.3715 | 1913897.0 |
| 2025-09-12 14:00:00 | SPY | ETF | 658.375 | 658.565 | 658.23 | 658.505 | 2453915.0 |
| 2025-09-12 14:30:00 | SPY | ETF | 658.505 | 659.11 | 658.32 | 658.81 | 3640953.0 |
| 2025-09-12 15:00:00 | SPY | ETF | 658.81 | 658.945 | 658.07 | 658.17 | 4590468.0 |
| 2025-09-12 15:30:00 | SPY | ETF | 658.17 | 658.33 | 656.9 | 657.42 | 12652406.0 |
| 2025-09-12 16:00:00 | SPY | ETF | 657.4 | 657.4996 | 657.18 | 657.47 | 2172430.0 |
| 2025-09-12 16:30:00 | SPY | ETF | 657.45 | 657.6 | 657.38 | 657.41 | 102213.0 |
| 2025-09-12 17:00:00 | SPY | ETF | 657.52 | 657.64 | 657.4512 | 657.64 | 10502.0 |
| 2025-09-12 17:30:00 | SPY | ETF | 657.58 | 657.64 | 657.46 | 657.46 | 53516.0 |
| 2025-09-12 18:00:00 | SPY | ETF | 657.44 | 657.45 | 657.32 | 657.32 | 34133.0 |
| 2025-09-12 18:30:00 | SPY | ETF | 657.35 | 657.35 | 657.28 | 657.28 | 5958.0 |
| 2025-09-12 19:00:00 | SPY | ETF | 657.28 | 657.28 | 657.1901 | 657.1901 | 12269.0 |
| 2025-09-12 19:30:00 | SPY | ETF | 657.19 | 657.35 | 657.19 | 657.25 | 30785.0 |
| 2025-09-12 04:00:00 | QQQ | ETF | 584.3 | 584.53 | 583.35 | 583.87 | 43534.0 |
| 2025-09-12 04:30:00 | QQQ | ETF | 583.87 | 584.14 | 583.8 | 584.14 | 10133.0 |
| 2025-09-12 05:00:00 | QQQ | ETF | 584.13 | 584.19 | 584.02 | 584.12 | 9431.0 |
| 2025-09-12 05:30:00 | QQQ | ETF | 584.23 | 584.53 | 583.98 | 584.32 | 17309.0 |
| 2025-09-12 06:00:00 | QQQ | ETF | 584.27 | 584.44 | 584.21 | 584.44 | 12408.0 |
| 2025-09-12 06:30:00 | QQQ | ETF | 584.44 | 584.65 | 584.38 | 584.63 | 13487.0 |
| 2025-09-12 07:00:00 | QQQ | ETF | 584.61 | 584.7 | 584.35 | 584.69 | 11900.0 |
| 2025-09-12 07:30:00 | QQQ | ETF | 584.69 | 585.21 | 584.59 | 585.16 | 33085.0 |
| 2025-09-12 08:00:00 | QQQ | ETF | 585.12 | 585.17 | 583.642 | 584.93 | 158750.0 |
| 2025-09-12 08:30:00 | QQQ | ETF | 584.94 | 585.11 | 584.42 | 585.06 | 118734.0 |
| 2025-09-12 09:00:00 | QQQ | ETF | 585.05 | 585.29 | 584.98 | 585.01 | 74431.0 |
| 2025-09-12 09:30:00 | QQQ | ETF | 585.04 | 585.57 | 584.1 | 585.145 | 4454621.0 |
| 2025-09-12 10:00:00 | QQQ | ETF | 585.145 | 585.875 | 584.69 | 585.75 | 2795029.0 |
| 2025-09-12 10:30:00 | QQQ | ETF | 585.76 | 586.83 | 585.6 | 586.6 | 2590376.0 |
| 2025-09-12 11:00:00 | QQQ | ETF | 586.6 | 586.7257 | 585.95 | 586.135 | 2049465.0 |
| 2025-09-12 11:30:00 | QQQ | ETF | 586.14 | 586.44 | 585.79 | 586.23 | 1752361.0 |
| 2025-09-12 12:00:00 | QQQ | ETF | 586.2201 | 586.62 | 585.77 | 586.58 | 1642938.0 |
| 2025-09-12 12:30:00 | QQQ | ETF | 586.58 | 586.98 | 586.38 | 586.69 | 3108190.0 |
> showing 50 of 41,689 rows — these rows as CSV