PREVIEW / etf_30min / 2025-02-28
file: by_date/etf_30min/2025/2025-02-28.parquet size: 958 KB rows: 40,122
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-02-28 04:00:00 | SPY | ETF | 586.1 | 587.2 | 586.1 | 587.2 | 16954.0 |
| 2025-02-28 04:30:00 | SPY | ETF | 587.2 | 587.23 | 586.71 | 586.9 | 15586.0 |
| 2025-02-28 05:00:00 | SPY | ETF | 587.0 | 587.16 | 586.79 | 586.82 | 7094.0 |
| 2025-02-28 05:30:00 | SPY | ETF | 586.94 | 587.47 | 586.93 | 587.06 | 11968.0 |
| 2025-02-28 06:00:00 | SPY | ETF | 587.15 | 587.42 | 587.15 | 587.4 | 6987.0 |
| 2025-02-28 06:30:00 | SPY | ETF | 587.26 | 587.6 | 587.0 | 587.23 | 52321.0 |
| 2025-02-28 07:00:00 | SPY | ETF | 587.21 | 587.25 | 586.11 | 586.7 | 187654.0 |
| 2025-02-28 07:30:00 | SPY | ETF | 586.6 | 586.75 | 586.01 | 586.69 | 113685.0 |
| 2025-02-28 08:00:00 | SPY | ETF | 586.81 | 587.22 | 584.81 | 586.0 | 264301.0 |
| 2025-02-28 08:30:00 | SPY | ETF | 585.8899 | 587.52 | 585.8899 | 586.24 | 237776.0 |
| 2025-02-28 09:00:00 | SPY | ETF | 586.34 | 586.73 | 585.43 | 585.56 | 290160.0 |
| 2025-02-28 09:30:00 | SPY | ETF | 585.56 | 586.33 | 583.27 | 586.03 | 6420186.0 |
| 2025-02-28 10:00:00 | SPY | ETF | 586.01 | 588.38 | 585.225 | 588.36 | 3399551.0 |
| 2025-02-28 10:30:00 | SPY | ETF | 588.36 | 588.8998 | 587.09 | 588.86 | 2270295.0 |
| 2025-02-28 11:00:00 | SPY | ETF | 588.87 | 589.03 | 586.01 | 586.06 | 1932094.0 |
| 2025-02-28 11:30:00 | SPY | ETF | 586.07 | 588.34 | 585.83 | 587.34 | 1430719.0 |
| 2025-02-28 12:00:00 | SPY | ETF | 587.3647 | 588.3 | 586.48 | 587.025 | 1229865.0 |
| 2025-02-28 12:30:00 | SPY | ETF | 587.075 | 587.18 | 583.6 | 583.6866 | 3081324.0 |
| 2025-02-28 13:00:00 | SPY | ETF | 583.69 | 584.79 | 582.44 | 584.72 | 5208970.0 |
| 2025-02-28 13:30:00 | SPY | ETF | 584.69 | 586.52 | 583.58 | 583.6025 | 2616767.0 |
| 2025-02-28 14:00:00 | SPY | ETF | 583.6 | 585.83 | 583.531 | 585.67 | 2322201.0 |
| 2025-02-28 14:30:00 | SPY | ETF | 585.6699 | 588.25 | 585.25 | 588.1 | 3056753.0 |
| 2025-02-28 15:00:00 | SPY | ETF | 588.09 | 589.68 | 587.7 | 589.615 | 3790723.0 |
| 2025-02-28 15:30:00 | SPY | ETF | 589.63 | 594.72 | 587.93 | 594.07 | 12526690.0 |
| 2025-02-28 16:00:00 | SPY | ETF | 594.05 | 594.2 | 593.05 | 593.46 | 7953365.0 |
| 2025-02-28 16:30:00 | SPY | ETF | 593.42 | 594.18 | 593.32 | 593.45 | 180139.0 |
| 2025-02-28 17:00:00 | SPY | ETF | 593.4499 | 594.18 | 593.34 | 593.75 | 102237.0 |
| 2025-02-28 17:30:00 | SPY | ETF | 593.742 | 593.77 | 593.52 | 593.73 | 39537.0 |
| 2025-02-28 18:00:00 | SPY | ETF | 593.76 | 593.86 | 593.75 | 593.84 | 62824.0 |
| 2025-02-28 18:30:00 | SPY | ETF | 593.81 | 593.92 | 593.78 | 593.8799 | 51083.0 |
| 2025-02-28 19:00:00 | SPY | ETF | 593.87 | 594.12 | 593.51 | 594.12 | 139618.0 |
| 2025-02-28 19:30:00 | SPY | ETF | 594.1299 | 594.3 | 593.99 | 594.3 | 80462.0 |
| 2025-02-28 04:00:00 | QQQ | ETF | 500.72 | 502.36 | 500.72 | 502.3 | 52974.0 |
| 2025-02-28 04:30:00 | QQQ | ETF | 502.3 | 502.3 | 501.68 | 501.74 | 27709.0 |
| 2025-02-28 05:00:00 | QQQ | ETF | 501.94 | 502.0 | 501.48 | 501.48 | 31116.0 |
| 2025-02-28 05:30:00 | QQQ | ETF | 501.55 | 502.2 | 501.55 | 501.77 | 20610.0 |
| 2025-02-28 06:00:00 | QQQ | ETF | 501.78 | 502.09 | 501.78 | 502.09 | 7796.0 |
| 2025-02-28 06:30:00 | QQQ | ETF | 501.95 | 502.18 | 501.61 | 501.85 | 30527.0 |
| 2025-02-28 07:00:00 | QQQ | ETF | 501.81 | 501.81 | 500.27 | 501.11 | 106085.0 |
| 2025-02-28 07:30:00 | QQQ | ETF | 500.94 | 500.96 | 499.86 | 500.81 | 173850.0 |
| 2025-02-28 08:00:00 | QQQ | ETF | 501.64 | 502.3796 | 499.35 | 499.9398 | 364767.0 |
| 2025-02-28 08:30:00 | QQQ | ETF | 499.93 | 502.2 | 499.93 | 500.32 | 462614.0 |
| 2025-02-28 09:00:00 | QQQ | ETF | 500.46 | 501.0 | 499.58 | 500.0 | 287811.0 |
| 2025-02-28 09:30:00 | QQQ | ETF | 500.13 | 501.39 | 496.93 | 500.16 | 5337778.0 |
| 2025-02-28 10:00:00 | QQQ | ETF | 500.14 | 504.23 | 499.24 | 504.1601 | 3411655.0 |
| 2025-02-28 10:30:00 | QQQ | ETF | 504.19 | 504.67 | 502.18 | 504.27 | 1857231.0 |
| 2025-02-28 11:00:00 | QQQ | ETF | 504.25 | 504.64 | 501.18 | 501.27 | 1976277.0 |
| 2025-02-28 11:30:00 | QQQ | ETF | 501.27 | 503.8699 | 500.94 | 502.685 | 1106058.0 |
| 2025-02-28 12:00:00 | QQQ | ETF | 502.69 | 503.9499 | 501.855 | 502.72 | 977896.0 |
| 2025-02-28 12:30:00 | QQQ | ETF | 502.82 | 502.82 | 498.811 | 498.875 | 2048935.0 |
> showing 50 of 40,122 rows — these rows as CSV