PREVIEW / etf_1hour / 2003-12-02
file: by_date/etf_1hour/2003/2003-12-02.parquet size: 19 KB rows: 499
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-12-02 08:00:00 | SPY | ETF | 107.43 | 107.43 | 107.28 | 107.35 | 382000.0 |
| 2003-12-02 09:00:00 | SPY | ETF | 107.35 | 107.51 | 107.3 | 107.46 | 3259100.0 |
| 2003-12-02 10:00:00 | SPY | ETF | 107.48 | 107.56 | 107.24 | 107.32 | 4921600.0 |
| 2003-12-02 11:00:00 | SPY | ETF | 107.32 | 107.66 | 107.29 | 107.63 | 3008600.0 |
| 2003-12-02 12:00:00 | SPY | ETF | 107.63 | 107.66 | 107.43 | 107.49 | 1924200.0 |
| 2003-12-02 13:00:00 | SPY | ETF | 107.47 | 107.77 | 107.47 | 107.63 | 2388600.0 |
| 2003-12-02 14:00:00 | SPY | ETF | 107.62 | 107.65 | 107.07 | 107.29 | 8526000.0 |
| 2003-12-02 15:00:00 | SPY | ETF | 107.26 | 107.41 | 107.16 | 107.27 | 3780300.0 |
| 2003-12-02 16:00:00 | SPY | ETF | 107.25 | 107.38 | 107.21 | 107.27 | 2050100.0 |
| 2003-12-02 17:00:00 | SPY | ETF | 107.31 | 107.43 | 107.27 | 107.35 | 15400.0 |
| 2003-12-02 18:00:00 | SPY | ETF | 107.26 | 107.32 | 107.26 | 107.32 | 16300.0 |
| 2003-12-02 19:00:00 | SPY | ETF | 107.35 | 107.35 | 107.35 | 107.35 | 1500.0 |
| 2003-12-02 08:00:00 | QQQ | ETF | 35.8 | 35.82 | 35.79 | 35.82 | 47000.0 |
| 2003-12-02 09:00:00 | QQQ | ETF | 35.81 | 35.9 | 35.77 | 35.851 | 4229400.0 |
| 2003-12-02 10:00:00 | QQQ | ETF | 35.851 | 35.89 | 35.73 | 35.78 | 7744800.0 |
| 2003-12-02 11:00:00 | QQQ | ETF | 35.78 | 35.97 | 35.77 | 35.96 | 6503500.0 |
| 2003-12-02 12:00:00 | QQQ | ETF | 35.96 | 35.98 | 35.84 | 35.88 | 4355800.0 |
| 2003-12-02 13:00:00 | QQQ | ETF | 35.88 | 36.05 | 35.86 | 35.98 | 9671000.0 |
| 2003-12-02 14:00:00 | QQQ | ETF | 35.98 | 35.99 | 35.62 | 35.65 | 13420200.0 |
| 2003-12-02 15:00:00 | QQQ | ETF | 35.65 | 35.76 | 35.58 | 35.6 | 10058900.0 |
| 2003-12-02 16:00:00 | QQQ | ETF | 35.61 | 35.737 | 35.59 | 35.684 | 1984300.0 |
| 2003-12-02 17:00:00 | QQQ | ETF | 35.69 | 35.72 | 35.675 | 35.69 | 102200.0 |
| 2003-12-02 18:00:00 | QQQ | ETF | 35.69 | 35.72 | 35.69 | 35.71 | 8300.0 |
| 2003-12-02 19:00:00 | QQQ | ETF | 35.71 | 35.72 | 35.71 | 35.72 | 7300.0 |
| 2003-12-02 09:00:00 | IWM | ETF | 55.295 | 55.5045 | 55.295 | 55.43 | 416800.0 |
| 2003-12-02 10:00:00 | IWM | ETF | 55.425 | 55.56 | 55.26 | 55.26 | 601800.0 |
| 2003-12-02 11:00:00 | IWM | ETF | 55.255 | 55.615 | 55.2 | 55.595 | 651000.0 |
| 2003-12-02 12:00:00 | IWM | ETF | 55.6 | 55.66 | 55.543 | 55.56 | 833600.0 |
| 2003-12-02 13:00:00 | IWM | ETF | 55.57 | 55.71 | 55.5 | 55.645 | 537000.0 |
| 2003-12-02 14:00:00 | IWM | ETF | 55.626 | 55.626 | 55.32 | 55.385 | 719600.0 |
| 2003-12-02 15:00:00 | IWM | ETF | 55.395 | 55.45 | 55.175 | 55.278 | 711000.0 |
| 2003-12-02 16:00:00 | IWM | ETF | 55.215 | 55.345 | 55.215 | 55.295 | 164800.0 |
| 2003-12-02 17:00:00 | IWM | ETF | 55.265 | 55.315 | 55.265 | 55.315 | 400.0 |
| 2003-12-02 08:00:00 | DIA | ETF | 98.93 | 98.93 | 98.84 | 98.84 | 2500.0 |
| 2003-12-02 09:00:00 | DIA | ETF | 98.88 | 98.95 | 98.75 | 98.85 | 283900.0 |
| 2003-12-02 10:00:00 | DIA | ETF | 98.84 | 98.94 | 98.64 | 98.7 | 589900.0 |
| 2003-12-02 11:00:00 | DIA | ETF | 98.71 | 98.98 | 98.7 | 98.95 | 433900.0 |
| 2003-12-02 12:00:00 | DIA | ETF | 98.95 | 98.98 | 98.79 | 98.85 | 150200.0 |
| 2003-12-02 13:00:00 | DIA | ETF | 98.85 | 99.04 | 98.85 | 98.93 | 417600.0 |
| 2003-12-02 14:00:00 | DIA | ETF | 98.91 | 98.94 | 98.51 | 98.68 | 440300.0 |
| 2003-12-02 15:00:00 | DIA | ETF | 98.7 | 98.8 | 98.6 | 98.65 | 661500.0 |
| 2003-12-02 16:00:00 | DIA | ETF | 98.65 | 98.77 | 98.6 | 98.72 | 665500.0 |
| 2003-12-02 17:00:00 | DIA | ETF | 98.7 | 98.7 | 98.7 | 98.7 | 200.0 |
| 2003-12-02 09:00:00 | TLT | ETF | 84.4 | 84.48 | 84.2 | 84.23 | 99100.0 |
| 2003-12-02 10:00:00 | TLT | ETF | 84.28 | 84.33 | 84.19 | 84.26 | 68600.0 |
| 2003-12-02 11:00:00 | TLT | ETF | 84.24 | 84.26 | 84.0 | 84.14 | 58700.0 |
| 2003-12-02 12:00:00 | TLT | ETF | 84.13 | 84.26 | 84.06 | 84.25 | 27600.0 |
| 2003-12-02 13:00:00 | TLT | ETF | 84.25 | 84.47 | 84.15 | 84.22 | 71800.0 |
| 2003-12-02 14:00:00 | TLT | ETF | 84.23 | 84.53 | 84.23 | 84.5 | 37000.0 |
| 2003-12-02 15:00:00 | TLT | ETF | 84.52 | 84.6 | 84.5 | 84.57 | 191200.0 |
> showing 50 of 499 rows — these rows as CSV