PREVIEW / etf_30min / 2003-10-02
file: by_date/etf_30min/2003/2003-10-02.parquet size: 24 KB rows: 733
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 |
|---|---|---|---|---|---|---|---|
| 2003-10-02 08:00:00 | SPY | ETF | 102.03 | 102.12 | 102.03 | 102.12 | 18000.0 |
| 2003-10-02 08:30:00 | SPY | ETF | 102.1 | 102.23 | 102.03 | 102.03 | 64400.0 |
| 2003-10-02 09:00:00 | SPY | ETF | 102.04 | 102.05 | 101.94 | 101.94 | 180300.0 |
| 2003-10-02 09:30:00 | SPY | ETF | 101.93 | 102.13 | 101.63 | 102.12 | 5484500.0 |
| 2003-10-02 10:00:00 | SPY | ETF | 102.09 | 102.48 | 101.97 | 102.17 | 8320500.0 |
| 2003-10-02 10:30:00 | SPY | ETF | 102.2 | 102.28 | 101.97 | 102.15 | 2848000.0 |
| 2003-10-02 11:00:00 | SPY | ETF | 102.11 | 102.27 | 102.0 | 102.27 | 1645500.0 |
| 2003-10-02 11:30:00 | SPY | ETF | 102.27 | 102.36 | 101.83 | 101.85 | 2966800.0 |
| 2003-10-02 12:00:00 | SPY | ETF | 101.85 | 101.98 | 101.76 | 101.87 | 1631800.0 |
| 2003-10-02 12:30:00 | SPY | ETF | 101.87 | 102.1 | 101.75 | 102.04 | 1214600.0 |
| 2003-10-02 13:00:00 | SPY | ETF | 102.03 | 102.18 | 102.02 | 102.04 | 788000.0 |
| 2003-10-02 13:30:00 | SPY | ETF | 102.02 | 102.18 | 101.92 | 102.14 | 1195300.0 |
| 2003-10-02 14:00:00 | SPY | ETF | 102.14 | 102.33 | 102.04 | 102.33 | 1144200.0 |
| 2003-10-02 14:30:00 | SPY | ETF | 102.32 | 102.353 | 102.08 | 102.2 | 1735500.0 |
| 2003-10-02 15:00:00 | SPY | ETF | 102.2 | 102.51 | 102.17 | 102.36 | 3126000.0 |
| 2003-10-02 15:30:00 | SPY | ETF | 102.38 | 102.4 | 102.2 | 102.34 | 3639000.0 |
| 2003-10-02 16:00:00 | SPY | ETF | 102.34 | 102.56 | 102.291 | 102.43 | 1643900.0 |
| 2003-10-02 16:30:00 | SPY | ETF | 102.46 | 102.49 | 102.46 | 102.49 | 12500.0 |
| 2003-10-02 17:00:00 | SPY | ETF | 102.44 | 102.5 | 102.43 | 102.43 | 41800.0 |
| 2003-10-02 17:30:00 | SPY | ETF | 102.5 | 102.5 | 102.43 | 102.46 | 3700.0 |
| 2003-10-02 18:00:00 | SPY | ETF | 102.49 | 102.49 | 102.46 | 102.46 | 2100.0 |
| 2003-10-02 18:30:00 | SPY | ETF | 102.44 | 102.44 | 102.44 | 102.44 | 200.0 |
| 2003-10-02 19:30:00 | SPY | ETF | 102.43 | 102.43 | 102.43 | 102.43 | 600.0 |
| 2003-10-02 08:00:00 | QQQ | ETF | 33.25 | 33.27 | 33.22 | 33.23 | 53300.0 |
| 2003-10-02 08:30:00 | QQQ | ETF | 33.21 | 33.29 | 33.15 | 33.16 | 168500.0 |
| 2003-10-02 09:00:00 | QQQ | ETF | 33.15 | 33.15 | 33.09 | 33.1 | 99900.0 |
| 2003-10-02 09:30:00 | QQQ | ETF | 33.1 | 33.28 | 32.97 | 33.28 | 13100000.0 |
| 2003-10-02 10:00:00 | QQQ | ETF | 33.27 | 33.43 | 33.18 | 33.22 | 11773800.0 |
| 2003-10-02 10:30:00 | QQQ | ETF | 33.22 | 33.29 | 33.12 | 33.194 | 7517700.0 |
| 2003-10-02 11:00:00 | QQQ | ETF | 33.193 | 33.26 | 33.13 | 33.25 | 3243000.0 |
| 2003-10-02 11:30:00 | QQQ | ETF | 33.25 | 33.28 | 33.03 | 33.05 | 4579000.0 |
| 2003-10-02 12:00:00 | QQQ | ETF | 33.04 | 33.06 | 32.93 | 33.025 | 5338900.0 |
| 2003-10-02 12:30:00 | QQQ | ETF | 33.03 | 33.15 | 32.97 | 33.1 | 2921900.0 |
| 2003-10-02 13:00:00 | QQQ | ETF | 33.1 | 33.18 | 33.08 | 33.11 | 1561700.0 |
| 2003-10-02 13:30:00 | QQQ | ETF | 33.096 | 33.16 | 33.02 | 33.132 | 2480500.0 |
| 2003-10-02 14:00:00 | QQQ | ETF | 33.14 | 33.24 | 33.07 | 33.23 | 2232200.0 |
| 2003-10-02 14:30:00 | QQQ | ETF | 33.22 | 33.25 | 33.12 | 33.181 | 3947200.0 |
| 2003-10-02 15:00:00 | QQQ | ETF | 33.18 | 33.33 | 33.18 | 33.259 | 4473300.0 |
| 2003-10-02 15:30:00 | QQQ | ETF | 33.25 | 33.27 | 33.15 | 33.21 | 7204700.0 |
| 2003-10-02 16:00:00 | QQQ | ETF | 33.22 | 33.27 | 33.2 | 33.21 | 2281100.0 |
| 2003-10-02 16:30:00 | QQQ | ETF | 33.23 | 33.25 | 33.2 | 33.22 | 269400.0 |
| 2003-10-02 17:00:00 | QQQ | ETF | 33.22 | 33.25 | 33.2 | 33.25 | 61200.0 |
| 2003-10-02 17:30:00 | QQQ | ETF | 33.24 | 33.25 | 33.21 | 33.24 | 13300.0 |
| 2003-10-02 18:00:00 | QQQ | ETF | 33.22 | 33.24 | 33.22 | 33.23 | 11600.0 |
| 2003-10-02 18:30:00 | QQQ | ETF | 33.23 | 33.23 | 33.23 | 33.23 | 800.0 |
| 2003-10-02 19:00:00 | QQQ | ETF | 33.23 | 33.24 | 33.2 | 33.2 | 5600.0 |
| 2003-10-02 19:30:00 | QQQ | ETF | 33.2 | 33.2 | 33.2 | 33.2 | 500.0 |
| 2003-10-02 09:30:00 | IWM | ETF | 49.85 | 50.1 | 49.755 | 50.1 | 1296400.0 |
| 2003-10-02 10:00:00 | IWM | ETF | 50.095 | 50.35 | 50.03 | 50.085 | 788800.0 |
| 2003-10-02 10:30:00 | IWM | ETF | 50.085 | 50.105 | 49.9 | 50.015 | 404800.0 |
> showing 50 of 733 rows — these rows as CSV