PREVIEW / etf_30min / 2025-08-21
file: by_date/etf_30min/2025/2025-08-21.parquet size: 983 KB rows: 40,616
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-08-21 04:00:00 | SPY | ETF | 638.01 | 638.36 | 637.64 | 638.1 | 5868.0 |
| 2025-08-21 04:30:00 | SPY | ETF | 638.1 | 638.13 | 637.06 | 637.07 | 7164.0 |
| 2025-08-21 05:00:00 | SPY | ETF | 637.1 | 637.42 | 636.94 | 637.42 | 4347.0 |
| 2025-08-21 05:30:00 | SPY | ETF | 637.43 | 637.52 | 637.14 | 637.14 | 1910.0 |
| 2025-08-21 06:00:00 | SPY | ETF | 637.03 | 637.12 | 636.26 | 636.86 | 11911.0 |
| 2025-08-21 06:30:00 | SPY | ETF | 636.97 | 637.19 | 636.69 | 637.03 | 14047.0 |
| 2025-08-21 07:00:00 | SPY | ETF | 637.08 | 637.79 | 636.91 | 637.03 | 70151.0 |
| 2025-08-21 07:30:00 | SPY | ETF | 637.01 | 637.13 | 636.26 | 636.55 | 55782.0 |
| 2025-08-21 08:00:00 | SPY | ETF | 637.05 | 638.63 | 635.42 | 635.93 | 333700.0 |
| 2025-08-21 08:30:00 | SPY | ETF | 635.61 | 636.4 | 635.26 | 635.47 | 192399.0 |
| 2025-08-21 09:00:00 | SPY | ETF | 635.45 | 636.27 | 635.19 | 636.27 | 179835.0 |
| 2025-08-21 09:30:00 | SPY | ETF | 636.28 | 636.51 | 634.31 | 635.13 | 5763230.0 |
| 2025-08-21 10:00:00 | SPY | ETF | 635.12 | 637.97 | 634.6 | 637.89 | 3075391.0 |
| 2025-08-21 10:30:00 | SPY | ETF | 637.89 | 637.9 | 636.1 | 637.15 | 1839070.0 |
| 2025-08-21 11:00:00 | SPY | ETF | 637.16 | 637.4399 | 635.3 | 636.69 | 2329567.0 |
| 2025-08-21 11:30:00 | SPY | ETF | 636.7 | 637.59 | 635.43 | 635.58 | 1895067.0 |
| 2025-08-21 12:00:00 | SPY | ETF | 635.58 | 635.89 | 634.96 | 635.25 | 2163209.0 |
| 2025-08-21 12:30:00 | SPY | ETF | 635.25 | 636.0 | 634.67 | 634.87 | 1547097.0 |
| 2025-08-21 13:00:00 | SPY | ETF | 634.87 | 635.467 | 633.81 | 634.435 | 2015625.0 |
| 2025-08-21 13:30:00 | SPY | ETF | 634.43 | 636.2 | 634.3399 | 635.9199 | 2114447.0 |
| 2025-08-21 14:00:00 | SPY | ETF | 635.91 | 636.19 | 635.435 | 635.5 | 1492946.0 |
| 2025-08-21 14:30:00 | SPY | ETF | 635.51 | 636.27 | 635.09 | 636.12 | 1969235.0 |
| 2025-08-21 15:00:00 | SPY | ETF | 636.11 | 636.52 | 635.89 | 635.94 | 1942706.0 |
| 2025-08-21 15:30:00 | SPY | ETF | 635.95 | 635.98 | 635.08 | 635.58 | 5494132.0 |
| 2025-08-21 16:00:00 | SPY | ETF | 635.58 | 635.89 | 635.37 | 635.73 | 3478832.0 |
| 2025-08-21 16:30:00 | SPY | ETF | 635.7491 | 635.95 | 635.68 | 635.8 | 126016.0 |
| 2025-08-21 17:00:00 | SPY | ETF | 635.8 | 635.94 | 635.55 | 635.77 | 55670.0 |
| 2025-08-21 17:30:00 | SPY | ETF | 635.9 | 635.91 | 635.79 | 635.87 | 16113.0 |
| 2025-08-21 18:00:00 | SPY | ETF | 635.89 | 636.44 | 635.89 | 636.09 | 52459.0 |
| 2025-08-21 18:30:00 | SPY | ETF | 636.12 | 636.47 | 636.09 | 636.4696 | 23280.0 |
| 2025-08-21 19:00:00 | SPY | ETF | 636.31 | 636.49 | 636.22 | 636.47 | 11762.0 |
| 2025-08-21 19:30:00 | SPY | ETF | 636.42 | 636.57 | 636.18 | 636.57 | 22627.0 |
| 2025-08-21 04:00:00 | QQQ | ETF | 566.35 | 566.75 | 565.74 | 566.41 | 28131.0 |
| 2025-08-21 04:30:00 | QQQ | ETF | 566.52 | 566.54 | 565.28 | 565.28 | 21480.0 |
| 2025-08-21 05:00:00 | QQQ | ETF | 565.32 | 565.85 | 565.17 | 565.77 | 12322.0 |
| 2025-08-21 05:30:00 | QQQ | ETF | 565.78 | 566.0 | 565.42 | 565.42 | 8800.0 |
| 2025-08-21 06:00:00 | QQQ | ETF | 565.43 | 565.53 | 564.72 | 565.37 | 21948.0 |
| 2025-08-21 06:30:00 | QQQ | ETF | 565.4 | 565.73 | 565.19 | 565.63 | 21756.0 |
| 2025-08-21 07:00:00 | QQQ | ETF | 565.59 | 566.11 | 565.23 | 565.4 | 63298.0 |
| 2025-08-21 07:30:00 | QQQ | ETF | 565.37 | 565.46 | 564.49 | 564.84 | 40390.0 |
| 2025-08-21 08:00:00 | QQQ | ETF | 565.37 | 566.9 | 563.46 | 563.79 | 289702.0 |
| 2025-08-21 08:30:00 | QQQ | ETF | 563.74 | 564.55 | 563.28 | 563.45 | 186246.0 |
| 2025-08-21 09:00:00 | QQQ | ETF | 563.44 | 564.35 | 563.11 | 564.32 | 115603.0 |
| 2025-08-21 09:30:00 | QQQ | ETF | 564.35 | 565.08 | 562.32 | 562.59 | 5492033.0 |
| 2025-08-21 10:00:00 | QQQ | ETF | 562.57 | 566.49 | 561.85 | 566.41 | 3920283.0 |
| 2025-08-21 10:30:00 | QQQ | ETF | 566.42 | 566.42 | 564.11 | 565.2 | 2593698.0 |
| 2025-08-21 11:00:00 | QQQ | ETF | 565.23 | 565.63 | 563.01 | 564.28 | 2530579.0 |
| 2025-08-21 11:30:00 | QQQ | ETF | 564.28 | 565.22 | 562.718 | 563.03 | 2063471.0 |
| 2025-08-21 12:00:00 | QQQ | ETF | 563.02 | 563.25 | 562.26 | 562.5 | 1782683.0 |
| 2025-08-21 12:30:00 | QQQ | ETF | 562.5 | 563.21 | 561.73 | 561.98 | 1736605.0 |
> showing 50 of 40,616 rows — these rows as CSV