PREVIEW / etf_30min / 2025-04-21
file: by_date/etf_30min/2025/2025-04-21.parquet size: 996 KB rows: 41,404
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-04-21 04:00:00 | SPY | ETF | 522.78 | 522.78 | 520.71 | 521.1 | 15550.0 |
| 2025-04-21 04:30:00 | SPY | ETF | 521.5 | 521.5 | 520.92 | 521.25 | 18325.0 |
| 2025-04-21 05:00:00 | SPY | ETF | 521.36 | 521.36 | 520.5 | 521.05 | 16364.0 |
| 2025-04-21 05:30:00 | SPY | ETF | 520.88 | 521.0 | 520.55 | 520.92 | 5383.0 |
| 2025-04-21 06:00:00 | SPY | ETF | 521.18 | 521.44 | 520.82 | 520.86 | 20710.0 |
| 2025-04-21 06:30:00 | SPY | ETF | 520.75 | 521.72 | 520.75 | 521.65 | 17729.0 |
| 2025-04-21 07:00:00 | SPY | ETF | 521.65 | 522.41 | 519.39 | 520.25 | 162919.0 |
| 2025-04-21 07:30:00 | SPY | ETF | 520.18 | 520.19 | 519.26 | 520.0 | 148729.0 |
| 2025-04-21 08:00:00 | SPY | ETF | 522.31 | 523.05 | 519.3789 | 521.0 | 255142.0 |
| 2025-04-21 08:30:00 | SPY | ETF | 520.95 | 521.51 | 520.7 | 520.99 | 107955.0 |
| 2025-04-21 09:00:00 | SPY | ETF | 520.84 | 521.17 | 520.4 | 521.17 | 133287.0 |
| 2025-04-21 09:30:00 | SPY | ETF | 521.16 | 521.7 | 517.52 | 517.56 | 3920163.0 |
| 2025-04-21 10:00:00 | SPY | ETF | 517.51 | 517.51 | 515.19 | 515.63 | 3342329.0 |
| 2025-04-21 10:30:00 | SPY | ETF | 515.64 | 516.86 | 514.389 | 514.6 | 3314609.0 |
| 2025-04-21 11:00:00 | SPY | ETF | 514.58 | 515.06 | 512.79 | 513.11 | 2590237.0 |
| 2025-04-21 11:30:00 | SPY | ETF | 513.11 | 513.36 | 510.8 | 511.0699 | 3307051.0 |
| 2025-04-21 12:00:00 | SPY | ETF | 511.05 | 512.23 | 511.01 | 511.66 | 2529496.0 |
| 2025-04-21 12:30:00 | SPY | ETF | 511.66 | 513.25 | 511.12 | 511.24 | 2814939.0 |
| 2025-04-21 13:00:00 | SPY | ETF | 511.2562 | 511.7399 | 509.5409 | 509.9612 | 3441454.0 |
| 2025-04-21 13:30:00 | SPY | ETF | 509.95 | 510.51 | 508.74 | 508.94 | 1905925.0 |
| 2025-04-21 14:00:00 | SPY | ETF | 508.95 | 509.9799 | 508.46 | 509.91 | 2684723.0 |
| 2025-04-21 14:30:00 | SPY | ETF | 509.9 | 510.66 | 508.69 | 508.7701 | 2691593.0 |
| 2025-04-21 15:00:00 | SPY | ETF | 508.77 | 511.17 | 508.73 | 510.365 | 3563076.0 |
| 2025-04-21 15:30:00 | SPY | ETF | 510.36 | 514.87 | 510.36 | 513.98 | 9426411.0 |
| 2025-04-21 16:00:00 | SPY | ETF | 513.99 | 514.17 | 510.05 | 513.49 | 3999688.0 |
| 2025-04-21 16:30:00 | SPY | ETF | 513.42 | 514.24 | 513.4 | 513.84 | 253427.0 |
| 2025-04-21 17:00:00 | SPY | ETF | 513.83 | 514.15 | 513.83 | 513.92 | 21202.0 |
| 2025-04-21 17:30:00 | SPY | ETF | 513.85 | 514.15 | 513.85 | 513.88 | 34961.0 |
| 2025-04-21 18:00:00 | SPY | ETF | 514.02 | 514.21 | 512.77 | 512.92 | 167007.0 |
| 2025-04-21 18:30:00 | SPY | ETF | 513.0 | 514.21 | 513.0 | 513.63 | 43613.0 |
| 2025-04-21 19:00:00 | SPY | ETF | 513.7 | 514.19 | 513.6 | 513.9996 | 13524.0 |
| 2025-04-21 19:30:00 | SPY | ETF | 514.0 | 516.099 | 513.9 | 516.05 | 83697.0 |
| 2025-04-21 04:00:00 | QQQ | ETF | 438.92 | 440.0 | 438.68 | 439.43 | 67496.0 |
| 2025-04-21 04:30:00 | QQQ | ETF | 439.37 | 439.76 | 438.97 | 439.4 | 15292.0 |
| 2025-04-21 05:00:00 | QQQ | ETF | 439.28 | 439.48 | 438.38 | 439.11 | 26664.0 |
| 2025-04-21 05:30:00 | QQQ | ETF | 438.9 | 439.31 | 438.58 | 439.29 | 14738.0 |
| 2025-04-21 06:00:00 | QQQ | ETF | 439.26 | 439.59 | 438.63 | 438.78 | 18038.0 |
| 2025-04-21 06:30:00 | QQQ | ETF | 438.75 | 439.64 | 438.67 | 439.64 | 11696.0 |
| 2025-04-21 07:00:00 | QQQ | ETF | 439.7 | 440.3 | 437.18 | 437.8 | 95283.0 |
| 2025-04-21 07:30:00 | QQQ | ETF | 437.94 | 437.96 | 437.03 | 437.66 | 67657.0 |
| 2025-04-21 08:00:00 | QQQ | ETF | 440.0 | 443.767 | 437.05 | 438.1 | 115558.0 |
| 2025-04-21 08:30:00 | QQQ | ETF | 438.07 | 438.63 | 437.81 | 438.07 | 71905.0 |
| 2025-04-21 09:00:00 | QQQ | ETF | 438.0 | 438.23 | 437.31 | 438.15 | 118243.0 |
| 2025-04-21 09:30:00 | QQQ | ETF | 438.23 | 439.08 | 434.97 | 434.9899 | 2906134.0 |
| 2025-04-21 10:00:00 | QQQ | ETF | 434.96 | 435.035 | 432.65 | 433.32 | 2360545.0 |
| 2025-04-21 10:30:00 | QQQ | ETF | 433.29 | 434.83 | 432.8 | 433.4885 | 1995631.0 |
| 2025-04-21 11:00:00 | QQQ | ETF | 433.5 | 433.9004 | 431.67 | 431.93 | 1711904.0 |
| 2025-04-21 11:30:00 | QQQ | ETF | 431.95 | 432.21 | 430.0 | 430.22 | 1734362.0 |
| 2025-04-21 12:00:00 | QQQ | ETF | 430.2453 | 431.3899 | 430.2453 | 430.6803 | 1339265.0 |
| 2025-04-21 12:30:00 | QQQ | ETF | 430.64 | 432.14 | 430.04 | 430.16 | 1450655.0 |
> showing 50 of 41,404 rows — these rows as CSV