PREVIEW / etf_30min / 2024-02-29
file: by_date/etf_30min/2024/2024-02-29.parquet size: 803 KB rows: 32,106
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-29 04:00:00 | SPY | ETF | 505.2 | 505.25 | 504.64 | 504.78 | 15126.0 |
| 2024-02-29 04:30:00 | SPY | ETF | 504.8 | 505.24 | 504.8 | 505.12 | 10608.0 |
| 2024-02-29 05:00:00 | SPY | ETF | 505.15 | 505.29 | 504.99 | 505.16 | 8538.0 |
| 2024-02-29 05:30:00 | SPY | ETF | 505.2 | 505.2 | 504.8 | 504.98 | 82771.0 |
| 2024-02-29 06:00:00 | SPY | ETF | 504.91 | 505.45 | 504.91 | 505.16 | 5780.0 |
| 2024-02-29 06:30:00 | SPY | ETF | 505.14 | 505.46 | 505.1 | 505.43 | 10876.0 |
| 2024-02-29 07:00:00 | SPY | ETF | 505.4 | 505.4 | 504.91 | 505.05 | 33846.0 |
| 2024-02-29 07:30:00 | SPY | ETF | 505.04 | 505.16 | 504.85 | 505.08 | 27933.0 |
| 2024-02-29 08:00:00 | SPY | ETF | 505.49 | 506.8 | 504.5 | 504.7 | 177520.0 |
| 2024-02-29 08:30:00 | SPY | ETF | 504.86 | 508.11 | 504.7 | 507.83 | 814515.0 |
| 2024-02-29 09:00:00 | SPY | ETF | 507.87 | 508.33 | 507.86 | 508.07 | 346029.0 |
| 2024-02-29 09:30:00 | SPY | ETF | 508.07 | 508.8455 | 507.99 | 508.49 | 4311374.0 |
| 2024-02-29 10:00:00 | SPY | ETF | 508.51 | 508.75 | 506.81 | 507.71 | 6695993.0 |
| 2024-02-29 10:30:00 | SPY | ETF | 507.69 | 507.84 | 507.0 | 507.454 | 2769030.0 |
| 2024-02-29 11:00:00 | SPY | ETF | 507.445 | 507.7299 | 506.94 | 507.185 | 1818537.0 |
| 2024-02-29 11:30:00 | SPY | ETF | 507.18 | 507.2 | 505.35 | 506.65 | 4030964.0 |
| 2024-02-29 12:00:00 | SPY | ETF | 506.65 | 507.12 | 506.505 | 506.58 | 1936102.0 |
| 2024-02-29 12:30:00 | SPY | ETF | 506.58 | 507.43 | 506.57 | 507.375 | 1868861.0 |
| 2024-02-29 13:00:00 | SPY | ETF | 507.36 | 507.89 | 507.3588 | 507.75 | 1911887.0 |
| 2024-02-29 13:30:00 | SPY | ETF | 507.77 | 507.9 | 507.5 | 507.8 | 1623545.0 |
| 2024-02-29 14:00:00 | SPY | ETF | 507.81 | 508.29 | 507.445 | 507.725 | 2478789.0 |
| 2024-02-29 14:30:00 | SPY | ETF | 507.71 | 507.87 | 507.164 | 507.75 | 2077287.0 |
| 2024-02-29 15:00:00 | SPY | ETF | 507.75 | 508.195 | 507.65 | 508.1301 | 2619334.0 |
| 2024-02-29 15:30:00 | SPY | ETF | 508.14 | 509.74 | 507.94 | 508.0 | 18432441.0 |
| 2024-02-29 16:00:00 | SPY | ETF | 508.0 | 508.8013 | 507.67 | 508.61 | 7087341.0 |
| 2024-02-29 16:30:00 | SPY | ETF | 508.59 | 508.62 | 508.28 | 508.4 | 238866.0 |
| 2024-02-29 17:00:00 | SPY | ETF | 508.53 | 508.53 | 508.27 | 508.2837 | 12565.0 |
| 2024-02-29 17:30:00 | SPY | ETF | 508.39 | 508.56 | 508.3 | 508.55 | 73211.0 |
| 2024-02-29 18:00:00 | SPY | ETF | 508.55 | 508.75 | 508.13 | 508.16 | 74519.0 |
| 2024-02-29 18:30:00 | SPY | ETF | 508.22 | 508.22 | 507.7801 | 508.05 | 41149.0 |
| 2024-02-29 19:00:00 | SPY | ETF | 508.09 | 508.5 | 508.09 | 508.41 | 13321.0 |
| 2024-02-29 19:30:00 | SPY | ETF | 508.39 | 508.58 | 508.27 | 508.58 | 22059.0 |
| 2024-02-29 04:00:00 | QQQ | ETF | 434.6 | 434.6 | 433.84 | 434.03 | 27070.0 |
| 2024-02-29 04:30:00 | QQQ | ETF | 434.09 | 434.4 | 434.08 | 434.35 | 12305.0 |
| 2024-02-29 05:00:00 | QQQ | ETF | 434.38 | 434.54 | 434.22 | 434.4 | 11051.0 |
| 2024-02-29 05:30:00 | QQQ | ETF | 434.41 | 434.44 | 434.21 | 434.37 | 8275.0 |
| 2024-02-29 06:00:00 | QQQ | ETF | 434.44 | 434.81 | 434.44 | 434.57 | 9273.0 |
| 2024-02-29 06:30:00 | QQQ | ETF | 434.54 | 434.84 | 434.54 | 434.8 | 4248.0 |
| 2024-02-29 07:00:00 | QQQ | ETF | 434.8 | 434.85 | 434.2 | 434.371 | 48647.0 |
| 2024-02-29 07:30:00 | QQQ | ETF | 434.35 | 434.54 | 434.11 | 434.36 | 19688.0 |
| 2024-02-29 08:00:00 | QQQ | ETF | 434.5 | 435.78 | 433.36 | 434.4186 | 129467.0 |
| 2024-02-29 08:30:00 | QQQ | ETF | 434.57 | 438.12 | 434.12 | 437.63 | 1098198.0 |
| 2024-02-29 09:00:00 | QQQ | ETF | 437.68 | 438.31 | 437.67 | 438.2 | 538514.0 |
| 2024-02-29 09:30:00 | QQQ | ETF | 438.23 | 439.27 | 437.98 | 438.78 | 4366714.0 |
| 2024-02-29 10:00:00 | QQQ | ETF | 438.78 | 439.16 | 437.02 | 437.9 | 3031074.0 |
| 2024-02-29 10:30:00 | QQQ | ETF | 437.91 | 438.38 | 437.205 | 437.585 | 1925658.0 |
| 2024-02-29 11:00:00 | QQQ | ETF | 437.59 | 437.83 | 436.69 | 436.9714 | 1542445.0 |
| 2024-02-29 11:30:00 | QQQ | ETF | 436.9794 | 437.16 | 435.02 | 437.09 | 3160886.0 |
| 2024-02-29 12:00:00 | QQQ | ETF | 437.08 | 437.53 | 436.72 | 436.79 | 1815049.0 |
| 2024-02-29 12:30:00 | QQQ | ETF | 436.78 | 438.04 | 436.7604 | 437.96 | 1663121.0 |
> showing 50 of 32,106 rows — these rows as CSV