PREVIEW / etf_30min / 2024-10-02
file: by_date/etf_30min/2024/2024-10-02.parquet size: 873 KB rows: 34,385
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-10-02 04:00:00 | SPY | ETF | 567.59 | 568.21 | 567.59 | 568.2 | 17513.0 |
| 2024-10-02 04:30:00 | SPY | ETF | 568.23 | 568.35 | 567.81 | 567.95 | 16333.0 |
| 2024-10-02 05:00:00 | SPY | ETF | 567.68 | 567.68 | 567.0 | 567.25 | 11023.0 |
| 2024-10-02 05:30:00 | SPY | ETF | 567.39 | 567.44 | 566.64 | 567.0 | 7484.0 |
| 2024-10-02 06:00:00 | SPY | ETF | 566.91 | 567.3 | 566.37 | 567.22 | 15764.0 |
| 2024-10-02 06:30:00 | SPY | ETF | 567.37 | 568.13 | 567.37 | 567.84 | 12257.0 |
| 2024-10-02 07:00:00 | SPY | ETF | 567.89 | 567.92 | 567.04 | 567.8 | 26467.0 |
| 2024-10-02 07:30:00 | SPY | ETF | 567.87 | 568.06 | 567.07 | 567.15 | 55922.0 |
| 2024-10-02 08:00:00 | SPY | ETF | 567.11 | 568.7 | 566.99 | 567.0 | 149567.0 |
| 2024-10-02 08:30:00 | SPY | ETF | 567.0 | 568.42 | 566.98 | 567.94 | 116882.0 |
| 2024-10-02 09:00:00 | SPY | ETF | 567.96 | 568.08 | 567.3 | 567.68 | 98204.0 |
| 2024-10-02 09:30:00 | SPY | ETF | 567.71 | 567.76 | 565.27 | 567.08 | 4065277.0 |
| 2024-10-02 10:00:00 | SPY | ETF | 567.07 | 568.88 | 566.89 | 568.36 | 2324511.0 |
| 2024-10-02 10:30:00 | SPY | ETF | 568.33 | 569.71 | 567.98 | 568.3 | 1827072.0 |
| 2024-10-02 11:00:00 | SPY | ETF | 568.31 | 569.83 | 568.11 | 569.52 | 1411065.0 |
| 2024-10-02 11:30:00 | SPY | ETF | 569.54 | 569.9 | 569.165 | 569.51 | 1254404.0 |
| 2024-10-02 12:00:00 | SPY | ETF | 569.52 | 569.79 | 568.82 | 569.49 | 1028046.0 |
| 2024-10-02 12:30:00 | SPY | ETF | 569.48 | 569.48 | 567.84 | 567.8609 | 1124396.0 |
| 2024-10-02 13:00:00 | SPY | ETF | 567.865 | 568.7 | 567.7 | 568.43 | 1292676.0 |
| 2024-10-02 13:30:00 | SPY | ETF | 568.35 | 569.15 | 567.57 | 569.06 | 1091366.0 |
| 2024-10-02 14:00:00 | SPY | ETF | 569.06 | 569.37 | 567.74 | 568.4694 | 1266607.0 |
| 2024-10-02 14:30:00 | SPY | ETF | 568.47 | 569.06 | 568.21 | 568.89 | 1191344.0 |
| 2024-10-02 15:00:00 | SPY | ETF | 568.89 | 569.34 | 568.7604 | 569.21 | 1199784.0 |
| 2024-10-02 15:30:00 | SPY | ETF | 569.22 | 569.46 | 568.7 | 568.85 | 3914049.0 |
| 2024-10-02 16:00:00 | SPY | ETF | 568.82 | 569.55 | 568.64 | 569.52 | 1675750.0 |
| 2024-10-02 16:30:00 | SPY | ETF | 569.53 | 570.1 | 569.51 | 569.77 | 181148.0 |
| 2024-10-02 17:00:00 | SPY | ETF | 569.84 | 569.93 | 569.67 | 569.7 | 16046.0 |
| 2024-10-02 17:30:00 | SPY | ETF | 569.72 | 569.72 | 569.6 | 569.623 | 3274.0 |
| 2024-10-02 18:00:00 | SPY | ETF | 569.68 | 570.0 | 569.52 | 569.77 | 64256.0 |
| 2024-10-02 18:30:00 | SPY | ETF | 569.77 | 569.77 | 569.63 | 569.63 | 2465.0 |
| 2024-10-02 19:00:00 | SPY | ETF | 569.63 | 569.7498 | 569.37 | 569.54 | 10828.0 |
| 2024-10-02 19:30:00 | SPY | ETF | 569.5394 | 569.8 | 569.5394 | 569.75 | 21377.0 |
| 2024-10-02 04:00:00 | QQQ | ETF | 480.42 | 480.9 | 480.2 | 480.64 | 21678.0 |
| 2024-10-02 04:30:00 | QQQ | ETF | 480.66 | 480.9 | 480.32 | 480.37 | 28111.0 |
| 2024-10-02 05:00:00 | QQQ | ETF | 480.46 | 480.46 | 479.54 | 479.96 | 32085.0 |
| 2024-10-02 05:30:00 | QQQ | ETF | 479.99 | 480.15 | 479.31 | 479.51 | 10989.0 |
| 2024-10-02 06:00:00 | QQQ | ETF | 479.57 | 479.92 | 478.82 | 479.92 | 10745.0 |
| 2024-10-02 06:30:00 | QQQ | ETF | 479.99 | 481.05 | 479.99 | 480.8 | 33225.0 |
| 2024-10-02 07:00:00 | QQQ | ETF | 480.69 | 480.95 | 479.95 | 480.88 | 47533.0 |
| 2024-10-02 07:30:00 | QQQ | ETF | 480.85 | 481.15 | 480.09 | 480.14 | 50691.0 |
| 2024-10-02 08:00:00 | QQQ | ETF | 480.14 | 481.27 | 479.0 | 480.12 | 157605.0 |
| 2024-10-02 08:30:00 | QQQ | ETF | 480.17 | 481.99 | 480.12 | 481.33 | 111866.0 |
| 2024-10-02 09:00:00 | QQQ | ETF | 481.31 | 481.38 | 479.9 | 480.34 | 215206.0 |
| 2024-10-02 09:30:00 | QQQ | ETF | 480.36 | 480.92 | 477.72 | 479.68 | 3182846.0 |
| 2024-10-02 10:00:00 | QQQ | ETF | 479.75 | 482.06 | 479.4605 | 481.88 | 1801566.0 |
| 2024-10-02 10:30:00 | QQQ | ETF | 481.86 | 483.1 | 481.3 | 481.66 | 1577175.0 |
| 2024-10-02 11:00:00 | QQQ | ETF | 481.67 | 483.88 | 481.54 | 483.07 | 1480499.0 |
| 2024-10-02 11:30:00 | QQQ | ETF | 483.15 | 483.48 | 482.47 | 483.17 | 979876.0 |
| 2024-10-02 12:00:00 | QQQ | ETF | 483.19 | 483.77 | 482.61 | 483.38 | 954932.0 |
| 2024-10-02 12:30:00 | QQQ | ETF | 483.39 | 483.39 | 481.23 | 481.279 | 766755.0 |
> showing 50 of 34,385 rows — these rows as CSV