PREVIEW / etf_30min / 2005-09-02
file: by_date/etf_30min/2005/2005-09-02.parquet size: 45 KB rows: 1,604
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 |
|---|---|---|---|---|---|---|---|
| 2005-09-02 07:30:00 | SPY | ETF | 122.6 | 122.6 | 122.6 | 122.6 | 5000.0 |
| 2005-09-02 08:00:00 | SPY | ETF | 122.57 | 122.69 | 122.5 | 122.55 | 1597000.0 |
| 2005-09-02 08:30:00 | SPY | ETF | 122.48 | 122.91 | 122.39 | 122.86 | 2143700.0 |
| 2005-09-02 09:00:00 | SPY | ETF | 122.86 | 122.89 | 122.79 | 122.88 | 592400.0 |
| 2005-09-02 09:30:00 | SPY | ETF | 122.85 | 122.88 | 122.45 | 122.58 | 5206900.0 |
| 2005-09-02 10:00:00 | SPY | ETF | 122.58 | 122.73 | 122.37 | 122.45 | 3982300.0 |
| 2005-09-02 10:30:00 | SPY | ETF | 122.41 | 122.5 | 122.2 | 122.41 | 7374400.0 |
| 2005-09-02 11:00:00 | SPY | ETF | 122.37 | 122.53 | 122.25 | 122.33 | 1492000.0 |
| 2005-09-02 11:30:00 | SPY | ETF | 122.33 | 122.34 | 122.12 | 122.17 | 2731600.0 |
| 2005-09-02 12:00:00 | SPY | ETF | 122.18 | 122.48 | 122.13 | 122.39 | 2435700.0 |
| 2005-09-02 12:30:00 | SPY | ETF | 122.39 | 122.59 | 122.36 | 122.5 | 5764000.0 |
| 2005-09-02 13:00:00 | SPY | ETF | 122.5 | 122.64 | 122.4 | 122.56 | 1466200.0 |
| 2005-09-02 13:30:00 | SPY | ETF | 122.54 | 122.68 | 122.48 | 122.63 | 1116200.0 |
| 2005-09-02 14:00:00 | SPY | ETF | 122.64 | 122.66 | 122.51 | 122.55 | 921900.0 |
| 2005-09-02 14:30:00 | SPY | ETF | 122.56 | 122.57 | 122.34 | 122.39 | 1253600.0 |
| 2005-09-02 15:00:00 | SPY | ETF | 122.39 | 122.46 | 122.31 | 122.352 | 1278400.0 |
| 2005-09-02 15:30:00 | SPY | ETF | 122.35 | 122.39 | 122.1 | 122.13 | 6082000.0 |
| 2005-09-02 16:00:00 | SPY | ETF | 122.14 | 122.75 | 122.04 | 122.33 | 664600.0 |
| 2005-09-02 16:30:00 | SPY | ETF | 122.33 | 122.35 | 122.16 | 122.3 | 476100.0 |
| 2005-09-02 17:00:00 | SPY | ETF | 122.28 | 122.3 | 122.28 | 122.3 | 1400.0 |
| 2005-09-02 17:30:00 | SPY | ETF | 122.21 | 122.21 | 122.17 | 122.2 | 3200.0 |
| 2005-09-02 18:00:00 | SPY | ETF | 122.2 | 122.22 | 122.16 | 122.17 | 1200.0 |
| 2005-09-02 18:30:00 | SPY | ETF | 122.17 | 122.17 | 122.17 | 122.17 | 1100.0 |
| 2005-09-02 19:00:00 | SPY | ETF | 122.15 | 122.15 | 122.15 | 122.15 | 1200.0 |
| 2005-09-02 19:30:00 | SPY | ETF | 122.22 | 122.25 | 122.22 | 122.25 | 1000.0 |
| 2005-09-02 09:30:00 | QQQ | ETF | 38.99 | 39.03 | 38.88 | 38.91 | 6735200.0 |
| 2005-09-02 10:00:00 | QQQ | ETF | 38.91 | 38.98 | 38.87 | 38.89 | 5617500.0 |
| 2005-09-02 10:30:00 | QQQ | ETF | 38.89 | 38.89 | 38.78 | 38.82 | 7227600.0 |
| 2005-09-02 11:00:00 | QQQ | ETF | 38.82 | 38.94 | 38.79 | 38.81 | 3723900.0 |
| 2005-09-02 11:30:00 | QQQ | ETF | 38.82 | 38.83 | 38.74 | 38.79 | 3773500.0 |
| 2005-09-02 12:00:00 | QQQ | ETF | 38.78 | 38.87 | 38.78 | 38.84 | 4470700.0 |
| 2005-09-02 12:30:00 | QQQ | ETF | 38.84 | 38.89 | 38.83 | 38.86 | 2802000.0 |
| 2005-09-02 13:00:00 | QQQ | ETF | 38.86 | 38.92 | 38.82 | 38.87 | 2766400.0 |
| 2005-09-02 13:30:00 | QQQ | ETF | 38.86 | 38.93 | 38.84 | 38.9 | 1459300.0 |
| 2005-09-02 14:00:00 | QQQ | ETF | 38.9 | 38.92 | 38.86 | 38.88 | 1282700.0 |
| 2005-09-02 14:30:00 | QQQ | ETF | 38.88 | 38.89 | 38.83 | 38.85 | 1593100.0 |
| 2005-09-02 15:00:00 | QQQ | ETF | 38.85 | 38.88 | 38.81 | 38.83 | 1798300.0 |
| 2005-09-02 15:30:00 | QQQ | ETF | 38.83 | 38.84 | 38.74 | 38.77 | 6184000.0 |
| 2005-09-02 08:00:00 | IWM | ETF | 66.61 | 66.61 | 66.51 | 66.51 | 160000.0 |
| 2005-09-02 08:30:00 | IWM | ETF | 66.51 | 66.7 | 66.28 | 66.69 | 654700.0 |
| 2005-09-02 09:00:00 | IWM | ETF | 66.69 | 66.78 | 66.61 | 66.78 | 125200.0 |
| 2005-09-02 09:30:00 | IWM | ETF | 66.76 | 66.8 | 66.26 | 66.34 | 3962600.0 |
| 2005-09-02 10:00:00 | IWM | ETF | 66.34 | 66.48 | 66.3 | 66.33 | 1843300.0 |
| 2005-09-02 10:30:00 | IWM | ETF | 66.33 | 66.34 | 66.05 | 66.09 | 4084600.0 |
| 2005-09-02 11:00:00 | IWM | ETF | 66.11 | 66.24 | 66.11 | 66.15 | 987100.0 |
| 2005-09-02 11:30:00 | IWM | ETF | 66.15 | 66.16 | 66.0 | 66.12 | 902400.0 |
| 2005-09-02 12:00:00 | IWM | ETF | 66.13 | 66.38 | 66.12 | 66.34 | 1276700.0 |
| 2005-09-02 12:30:00 | IWM | ETF | 66.34 | 66.4 | 66.29 | 66.32 | 1599200.0 |
| 2005-09-02 13:00:00 | IWM | ETF | 66.32 | 66.4 | 66.3 | 66.35 | 492500.0 |
| 2005-09-02 13:30:00 | IWM | ETF | 66.34 | 66.38 | 66.25 | 66.35 | 513200.0 |
> showing 50 of 1,604 rows — these rows as CSV