PREVIEW / etf_30min / 2024-02-26
file: by_date/etf_30min/2024/2024-02-26.parquet size: 814 KB rows: 31,995
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-26 04:00:00 | SPY | ETF | 507.32 | 507.44 | 507.06 | 507.44 | 8633.0 |
| 2024-02-26 04:30:00 | SPY | ETF | 507.46 | 507.7 | 507.45 | 507.68 | 5345.0 |
| 2024-02-26 05:00:00 | SPY | ETF | 507.65 | 507.89 | 507.64 | 507.89 | 2266.0 |
| 2024-02-26 05:30:00 | SPY | ETF | 507.87 | 508.02 | 507.8 | 507.86 | 30074.0 |
| 2024-02-26 06:00:00 | SPY | ETF | 507.83 | 508.1 | 507.8 | 508.1 | 2399.0 |
| 2024-02-26 06:30:00 | SPY | ETF | 508.08 | 508.08 | 507.83 | 507.87 | 3797.0 |
| 2024-02-26 07:00:00 | SPY | ETF | 507.91 | 507.96 | 507.63 | 507.78 | 38834.0 |
| 2024-02-26 07:30:00 | SPY | ETF | 507.71 | 507.83 | 507.56 | 507.62 | 56427.0 |
| 2024-02-26 08:00:00 | SPY | ETF | 507.69 | 508.11 | 507.03 | 508.08 | 82377.0 |
| 2024-02-26 08:30:00 | SPY | ETF | 508.07 | 508.64 | 508.07 | 508.42 | 116384.0 |
| 2024-02-26 09:00:00 | SPY | ETF | 508.42 | 508.42 | 507.91 | 508.31 | 159553.0 |
| 2024-02-26 09:30:00 | SPY | ETF | 508.3 | 508.75 | 507.73 | 508.215 | 3251349.0 |
| 2024-02-26 10:00:00 | SPY | ETF | 508.22 | 508.52 | 507.79 | 507.95 | 2373779.0 |
| 2024-02-26 10:30:00 | SPY | ETF | 507.96 | 508.3 | 507.42 | 507.5 | 2424125.0 |
| 2024-02-26 11:00:00 | SPY | ETF | 507.505 | 507.72 | 507.015 | 507.3899 | 2080933.0 |
| 2024-02-26 11:30:00 | SPY | ETF | 507.39 | 507.89 | 507.2301 | 507.72 | 1864594.0 |
| 2024-02-26 12:00:00 | SPY | ETF | 507.73 | 507.89 | 507.285 | 507.79 | 1526567.0 |
| 2024-02-26 12:30:00 | SPY | ETF | 507.79 | 507.9 | 507.15 | 507.3061 | 1399532.0 |
| 2024-02-26 13:00:00 | SPY | ETF | 507.3099 | 507.595 | 506.45 | 506.62 | 2368032.0 |
| 2024-02-26 13:30:00 | SPY | ETF | 506.63 | 506.9 | 506.02 | 506.885 | 3093145.0 |
| 2024-02-26 14:00:00 | SPY | ETF | 506.8727 | 507.29 | 506.515 | 507.165 | 2463502.0 |
| 2024-02-26 14:30:00 | SPY | ETF | 507.16 | 507.4 | 506.7 | 506.76 | 2077175.0 |
| 2024-02-26 15:00:00 | SPY | ETF | 506.765 | 507.315 | 506.67 | 506.88 | 2730501.0 |
| 2024-02-26 15:30:00 | SPY | ETF | 506.88 | 506.97 | 505.86 | 505.99 | 7452305.0 |
| 2024-02-26 16:00:00 | SPY | ETF | 505.97 | 506.02 | 505.75 | 505.85 | 1906048.0 |
| 2024-02-26 16:30:00 | SPY | ETF | 505.88 | 505.93 | 505.62 | 505.72 | 198028.0 |
| 2024-02-26 17:00:00 | SPY | ETF | 505.72 | 505.97 | 505.65 | 505.75 | 165489.0 |
| 2024-02-26 17:30:00 | SPY | ETF | 505.72 | 505.75 | 505.67 | 505.75 | 3588.0 |
| 2024-02-26 18:00:00 | SPY | ETF | 505.69 | 505.86 | 505.61 | 505.86 | 22722.0 |
| 2024-02-26 18:30:00 | SPY | ETF | 505.82 | 506.07 | 505.82 | 505.911 | 31327.0 |
| 2024-02-26 19:00:00 | SPY | ETF | 505.91 | 505.91 | 505.26 | 505.6496 | 17395.0 |
| 2024-02-26 19:30:00 | SPY | ETF | 505.75 | 505.85 | 505.67 | 505.7396 | 9827.0 |
| 2024-02-26 04:00:00 | QQQ | ETF | 436.38 | 436.44 | 435.9 | 436.42 | 17651.0 |
| 2024-02-26 04:30:00 | QQQ | ETF | 436.48 | 436.99 | 436.46 | 436.99 | 21987.0 |
| 2024-02-26 05:00:00 | QQQ | ETF | 436.95 | 437.1 | 436.77 | 437.1 | 6025.0 |
| 2024-02-26 05:30:00 | QQQ | ETF | 437.1 | 437.17 | 436.89 | 436.98 | 8194.0 |
| 2024-02-26 06:00:00 | QQQ | ETF | 436.87 | 437.23 | 436.83 | 437.21 | 10827.0 |
| 2024-02-26 06:30:00 | QQQ | ETF | 437.24 | 437.24 | 436.77 | 436.87 | 12434.0 |
| 2024-02-26 07:00:00 | QQQ | ETF | 436.9 | 436.97 | 436.56 | 436.881 | 53258.0 |
| 2024-02-26 07:30:00 | QQQ | ETF | 436.81 | 436.9 | 436.6 | 436.66 | 12224.0 |
| 2024-02-26 08:00:00 | QQQ | ETF | 436.7905 | 437.45 | 435.64 | 437.34 | 101726.0 |
| 2024-02-26 08:30:00 | QQQ | ETF | 437.3 | 437.83 | 437.3 | 437.56 | 67768.0 |
| 2024-02-26 09:00:00 | QQQ | ETF | 437.55 | 437.55 | 437.09 | 437.5 | 128363.0 |
| 2024-02-26 09:30:00 | QQQ | ETF | 437.6 | 438.4 | 436.355 | 436.8101 | 3882612.0 |
| 2024-02-26 10:00:00 | QQQ | ETF | 436.81 | 438.155 | 436.42 | 437.66 | 2324109.0 |
| 2024-02-26 10:30:00 | QQQ | ETF | 437.67 | 438.14 | 437.34 | 437.5801 | 1744434.0 |
| 2024-02-26 11:00:00 | QQQ | ETF | 437.61 | 437.9 | 436.97 | 437.58 | 1486907.0 |
| 2024-02-26 11:30:00 | QQQ | ETF | 437.59 | 438.58 | 437.52 | 438.27 | 1560787.0 |
| 2024-02-26 12:00:00 | QQQ | ETF | 438.295 | 438.55 | 437.645 | 438.3781 | 1363893.0 |
| 2024-02-26 12:30:00 | QQQ | ETF | 438.385 | 438.6 | 437.59 | 437.82 | 1281631.0 |
> showing 50 of 31,995 rows — these rows as CSV