PREVIEW / etf_30min / 2024-02-22
file: by_date/etf_30min/2024/2024-02-22.parquet size: 816 KB rows: 32,691
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 |
|---|---|---|---|---|---|---|---|
| 2024-02-22 04:00:00 | SPY | ETF | 503.12 | 503.25 | 501.2 | 502.63 | 37384.0 |
| 2024-02-22 04:30:00 | SPY | ETF | 502.76 | 503.1 | 502.75 | 503.0 | 25677.0 |
| 2024-02-22 05:00:00 | SPY | ETF | 502.95 | 503.1 | 502.82 | 502.95 | 13956.0 |
| 2024-02-22 05:30:00 | SPY | ETF | 503.0 | 503.43 | 503.0 | 503.35 | 60185.0 |
| 2024-02-22 06:00:00 | SPY | ETF | 503.34 | 504.49 | 503.27 | 504.11 | 40707.0 |
| 2024-02-22 06:30:00 | SPY | ETF | 504.1 | 504.32 | 503.9 | 503.91 | 38846.0 |
| 2024-02-22 07:00:00 | SPY | ETF | 503.88 | 503.92 | 503.52 | 503.75 | 212748.0 |
| 2024-02-22 07:30:00 | SPY | ETF | 503.71 | 503.82 | 503.58 | 503.6 | 163487.0 |
| 2024-02-22 08:00:00 | SPY | ETF | 503.6 | 504.2496 | 501.1 | 503.81 | 356999.0 |
| 2024-02-22 08:30:00 | SPY | ETF | 503.75 | 504.33 | 503.48 | 504.2 | 314263.0 |
| 2024-02-22 09:00:00 | SPY | ETF | 504.16 | 504.29 | 503.71 | 504.0 | 290340.0 |
| 2024-02-22 09:30:00 | SPY | ETF | 504.0 | 505.425 | 503.02 | 504.99 | 9384938.0 |
| 2024-02-22 10:00:00 | SPY | ETF | 505.02 | 505.38 | 504.59 | 505.34 | 4802663.0 |
| 2024-02-22 10:30:00 | SPY | ETF | 505.35 | 505.6999 | 504.51 | 504.75 | 3532614.0 |
| 2024-02-22 11:00:00 | SPY | ETF | 504.77 | 505.675 | 504.54 | 505.39 | 3114839.0 |
| 2024-02-22 11:30:00 | SPY | ETF | 505.39 | 505.89 | 505.02 | 505.245 | 2576752.0 |
| 2024-02-22 12:00:00 | SPY | ETF | 505.25 | 506.03 | 504.91 | 505.95 | 2444462.0 |
| 2024-02-22 12:30:00 | SPY | ETF | 505.95 | 506.51 | 505.61 | 506.45 | 2833112.0 |
| 2024-02-22 13:00:00 | SPY | ETF | 506.45 | 506.86 | 506.07 | 506.815 | 2723507.0 |
| 2024-02-22 13:30:00 | SPY | ETF | 506.82 | 507.2699 | 506.74 | 507.25 | 3036104.0 |
| 2024-02-22 14:00:00 | SPY | ETF | 507.24 | 508.48 | 507.175 | 508.42 | 4017845.0 |
| 2024-02-22 14:30:00 | SPY | ETF | 508.43 | 508.49 | 506.89 | 507.195 | 4693907.0 |
| 2024-02-22 15:00:00 | SPY | ETF | 507.185 | 508.02 | 507.07 | 507.7301 | 3684652.0 |
| 2024-02-22 15:30:00 | SPY | ETF | 507.73 | 508.315 | 507.33 | 507.53 | 10354654.0 |
| 2024-02-22 16:00:00 | SPY | ETF | 507.52 | 507.6 | 505.7552 | 507.11 | 2334350.0 |
| 2024-02-22 16:30:00 | SPY | ETF | 507.11 | 507.22 | 506.99 | 507.12 | 261634.0 |
| 2024-02-22 17:00:00 | SPY | ETF | 507.1201 | 507.3 | 507.1201 | 507.24 | 37938.0 |
| 2024-02-22 17:30:00 | SPY | ETF | 507.24 | 507.26 | 507.1 | 507.22 | 21955.0 |
| 2024-02-22 18:00:00 | SPY | ETF | 507.24 | 507.6 | 507.22 | 507.56 | 54316.0 |
| 2024-02-22 18:30:00 | SPY | ETF | 507.56 | 507.79 | 507.5 | 507.67 | 319221.0 |
| 2024-02-22 19:00:00 | SPY | ETF | 507.65 | 507.65 | 507.34 | 507.41 | 37098.0 |
| 2024-02-22 19:30:00 | SPY | ETF | 507.42 | 507.45 | 507.0 | 507.34 | 17703.0 |
| 2024-02-22 04:00:00 | QQQ | ETF | 433.62 | 434.45 | 431.99 | 433.86 | 169740.0 |
| 2024-02-22 04:30:00 | QQQ | ETF | 433.83 | 434.34 | 433.8 | 434.24 | 23980.0 |
| 2024-02-22 05:00:00 | QQQ | ETF | 434.25 | 434.39 | 433.89 | 434.0 | 22379.0 |
| 2024-02-22 05:30:00 | QQQ | ETF | 434.09 | 434.45 | 434.05 | 434.35 | 26278.0 |
| 2024-02-22 06:00:00 | QQQ | ETF | 434.35 | 435.18 | 434.09 | 434.86 | 33085.0 |
| 2024-02-22 06:30:00 | QQQ | ETF | 434.82 | 435.06 | 434.77 | 434.84 | 59739.0 |
| 2024-02-22 07:00:00 | QQQ | ETF | 434.84 | 434.85 | 434.16 | 434.46 | 223018.0 |
| 2024-02-22 07:30:00 | QQQ | ETF | 434.4 | 434.69 | 434.29 | 434.31 | 106012.0 |
| 2024-02-22 08:00:00 | QQQ | ETF | 434.3 | 435.0904 | 431.9 | 434.36 | 287185.0 |
| 2024-02-22 08:30:00 | QQQ | ETF | 434.28 | 434.65 | 434.0 | 434.53 | 181777.0 |
| 2024-02-22 09:00:00 | QQQ | ETF | 434.53 | 434.54 | 433.85 | 434.49 | 350076.0 |
| 2024-02-22 09:30:00 | QQQ | ETF | 434.49 | 436.285 | 433.71 | 435.11 | 7159511.0 |
| 2024-02-22 10:00:00 | QQQ | ETF | 435.12 | 435.99 | 434.5506 | 435.98 | 3619269.0 |
| 2024-02-22 10:30:00 | QQQ | ETF | 435.98 | 436.39 | 434.51 | 434.91 | 2885174.0 |
| 2024-02-22 11:00:00 | QQQ | ETF | 434.93 | 436.41 | 434.73 | 435.92 | 2052243.0 |
| 2024-02-22 11:30:00 | QQQ | ETF | 435.93 | 436.53 | 435.61 | 435.84 | 1852439.0 |
| 2024-02-22 12:00:00 | QQQ | ETF | 435.85 | 436.81 | 435.45 | 436.74 | 1867207.0 |
| 2024-02-22 12:30:00 | QQQ | ETF | 436.74 | 437.48 | 436.3401 | 437.4601 | 1516329.0 |
> showing 50 of 32,691 rows — these rows as CSV