PREVIEW / etf_30min / 2025-08-20
file: by_date/etf_30min/2025/2025-08-20.parquet size: 1009 KB rows: 41,155
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-20 04:00:00 | SPY | ETF | 637.22 | 638.67 | 637.22 | 638.0 | 42168.0 |
| 2025-08-20 04:30:00 | SPY | ETF | 637.9 | 638.78 | 637.9 | 638.46 | 10161.0 |
| 2025-08-20 05:00:00 | SPY | ETF | 638.56 | 639.0 | 638.41 | 638.87 | 7024.0 |
| 2025-08-20 05:30:00 | SPY | ETF | 638.94 | 639.14 | 638.9 | 639.02 | 15223.0 |
| 2025-08-20 06:00:00 | SPY | ETF | 638.95 | 639.39 | 638.92 | 639.19 | 3527.0 |
| 2025-08-20 06:30:00 | SPY | ETF | 639.26 | 639.27 | 638.87 | 639.13 | 2590.0 |
| 2025-08-20 07:00:00 | SPY | ETF | 639.12 | 639.53 | 638.83 | 638.85 | 58467.0 |
| 2025-08-20 07:30:00 | SPY | ETF | 638.9 | 639.11 | 638.5 | 639.01 | 52974.0 |
| 2025-08-20 08:00:00 | SPY | ETF | 639.42 | 639.5 | 637.49 | 639.11 | 120824.0 |
| 2025-08-20 08:30:00 | SPY | ETF | 639.1 | 639.58 | 638.82 | 639.23 | 151880.0 |
| 2025-08-20 09:00:00 | SPY | ETF | 639.25 | 639.44 | 638.96 | 639.41 | 130714.0 |
| 2025-08-20 09:30:00 | SPY | ETF | 639.4 | 639.66 | 634.96 | 635.39 | 10759449.0 |
| 2025-08-20 10:00:00 | SPY | ETF | 635.38 | 636.29 | 633.67 | 633.92 | 7626048.0 |
| 2025-08-20 10:30:00 | SPY | ETF | 633.94 | 634.42 | 632.95 | 633.38 | 4209278.0 |
| 2025-08-20 11:00:00 | SPY | ETF | 633.38 | 636.43 | 633.18 | 636.375 | 4599541.0 |
| 2025-08-20 11:30:00 | SPY | ETF | 636.35 | 636.9 | 634.72 | 635.15 | 3309408.0 |
| 2025-08-20 12:00:00 | SPY | ETF | 635.14 | 637.4758 | 635.075 | 637.4207 | 3198443.0 |
| 2025-08-20 12:30:00 | SPY | ETF | 637.425 | 637.45 | 635.93 | 636.315 | 2326758.0 |
| 2025-08-20 13:00:00 | SPY | ETF | 636.31 | 637.21 | 636.13 | 636.56 | 1669994.0 |
| 2025-08-20 13:30:00 | SPY | ETF | 636.56 | 637.96 | 636.51 | 637.198 | 1797705.0 |
| 2025-08-20 14:00:00 | SPY | ETF | 637.18 | 637.33 | 635.21 | 635.83 | 3706577.0 |
| 2025-08-20 14:30:00 | SPY | ETF | 635.8316 | 637.38 | 635.75 | 636.69 | 2822136.0 |
| 2025-08-20 15:00:00 | SPY | ETF | 636.69 | 638.8698 | 636.69 | 638.33 | 3865430.0 |
| 2025-08-20 15:30:00 | SPY | ETF | 638.315 | 639.06 | 637.805 | 638.07 | 7749624.0 |
| 2025-08-20 16:00:00 | SPY | ETF | 638.05 | 638.18 | 636.4788 | 637.83 | 2665453.0 |
| 2025-08-20 16:30:00 | SPY | ETF | 637.85 | 638.14 | 637.83 | 638.08 | 92812.0 |
| 2025-08-20 17:00:00 | SPY | ETF | 638.0 | 638.05 | 637.9 | 638.05 | 50200.0 |
| 2025-08-20 17:30:00 | SPY | ETF | 638.06 | 638.13 | 637.96 | 637.96 | 23763.0 |
| 2025-08-20 18:00:00 | SPY | ETF | 638.07 | 638.35 | 637.6 | 638.0 | 101741.0 |
| 2025-08-20 18:30:00 | SPY | ETF | 638.0 | 638.0 | 637.68 | 637.8196 | 7807.0 |
| 2025-08-20 19:00:00 | SPY | ETF | 637.75 | 637.9 | 637.56 | 637.66 | 12667.0 |
| 2025-08-20 19:30:00 | SPY | ETF | 637.64 | 637.8 | 637.49 | 637.8 | 22326.0 |
| 2025-08-20 04:00:00 | QQQ | ETF | 567.72 | 567.9 | 567.05 | 567.22 | 41668.0 |
| 2025-08-20 04:30:00 | QQQ | ETF | 567.16 | 568.19 | 567.07 | 568.0 | 43197.0 |
| 2025-08-20 05:00:00 | QQQ | ETF | 568.06 | 568.53 | 567.87 | 568.31 | 30255.0 |
| 2025-08-20 05:30:00 | QQQ | ETF | 568.32 | 568.63 | 568.28 | 568.45 | 16991.0 |
| 2025-08-20 06:00:00 | QQQ | ETF | 568.39 | 568.69 | 568.33 | 568.45 | 10926.0 |
| 2025-08-20 06:30:00 | QQQ | ETF | 568.38 | 568.38 | 567.82 | 568.35 | 29680.0 |
| 2025-08-20 07:00:00 | QQQ | ETF | 568.3 | 568.91 | 567.99 | 568.06 | 80502.0 |
| 2025-08-20 07:30:00 | QQQ | ETF | 568.07 | 568.16 | 567.37 | 567.99 | 55445.0 |
| 2025-08-20 08:00:00 | QQQ | ETF | 568.56 | 568.869 | 566.1 | 567.92 | 132833.0 |
| 2025-08-20 08:30:00 | QQQ | ETF | 567.99 | 568.57 | 567.63 | 568.32 | 181362.0 |
| 2025-08-20 09:00:00 | QQQ | ETF | 568.31 | 568.42 | 567.8 | 568.33 | 168486.0 |
| 2025-08-20 09:30:00 | QQQ | ETF | 568.32 | 568.45 | 561.52 | 562.18 | 9256995.0 |
| 2025-08-20 10:00:00 | QQQ | ETF | 562.18 | 563.17 | 559.51 | 560.281 | 7308980.0 |
| 2025-08-20 10:30:00 | QQQ | ETF | 560.31 | 560.61 | 558.84 | 559.368 | 4350142.0 |
| 2025-08-20 11:00:00 | QQQ | ETF | 559.37 | 563.5 | 559.1 | 563.44 | 4746236.0 |
| 2025-08-20 11:30:00 | QQQ | ETF | 563.435 | 564.42 | 561.67 | 562.13 | 4168894.0 |
| 2025-08-20 12:00:00 | QQQ | ETF | 562.13 | 565.33 | 562.06 | 565.2 | 2867406.0 |
| 2025-08-20 12:30:00 | QQQ | ETF | 565.2 | 565.228 | 563.29 | 563.64 | 2417738.0 |
> showing 50 of 41,155 rows — these rows as CSV