PREVIEW / etf_1hour / 2004-02-26
file: by_date/etf_1hour/2004/2004-02-26.parquet size: 24 KB rows: 659
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 |
|---|---|---|---|---|---|---|---|
| 2004-02-26 08:00:00 | SPY | ETF | 114.9 | 114.98 | 114.64 | 114.68 | 129600.0 |
| 2004-02-26 09:00:00 | SPY | ETF | 114.69 | 114.79 | 114.42 | 114.56 | 2708100.0 |
| 2004-02-26 10:00:00 | SPY | ETF | 114.55 | 114.69 | 114.34 | 114.65 | 4792100.0 |
| 2004-02-26 11:00:00 | SPY | ETF | 114.62 | 115.02 | 114.62 | 114.91 | 4680700.0 |
| 2004-02-26 12:00:00 | SPY | ETF | 114.93 | 115.29 | 114.86 | 115.21 | 3760900.0 |
| 2004-02-26 13:00:00 | SPY | ETF | 115.23 | 115.23 | 115.0 | 115.12 | 1960200.0 |
| 2004-02-26 14:00:00 | SPY | ETF | 115.13 | 115.19 | 114.88 | 115.04 | 3155600.0 |
| 2004-02-26 15:00:00 | SPY | ETF | 115.04 | 115.26 | 114.95 | 115.04 | 3066000.0 |
| 2004-02-26 16:00:00 | SPY | ETF | 115.02 | 115.11 | 114.9 | 114.98 | 1452800.0 |
| 2004-02-26 17:00:00 | SPY | ETF | 114.96 | 114.99 | 114.96 | 114.97 | 1200.0 |
| 2004-02-26 18:00:00 | SPY | ETF | 114.96 | 114.96 | 114.94 | 114.94 | 1600.0 |
| 2004-02-26 19:00:00 | SPY | ETF | 114.97 | 114.99 | 114.97 | 114.99 | 200.0 |
| 2004-02-26 08:00:00 | QQQ | ETF | 36.61 | 36.62 | 36.49 | 36.51 | 159000.0 |
| 2004-02-26 09:00:00 | QQQ | ETF | 36.51 | 36.54 | 36.34 | 36.44 | 9259700.0 |
| 2004-02-26 10:00:00 | QQQ | ETF | 36.441 | 36.53 | 36.305 | 36.497 | 12843700.0 |
| 2004-02-26 11:00:00 | QQQ | ETF | 36.49 | 36.71 | 36.49 | 36.65 | 12384200.0 |
| 2004-02-26 12:00:00 | QQQ | ETF | 36.65 | 36.84 | 36.6112 | 36.78 | 10260800.0 |
| 2004-02-26 13:00:00 | QQQ | ETF | 36.782 | 36.79 | 36.66 | 36.73 | 6389200.0 |
| 2004-02-26 14:00:00 | QQQ | ETF | 36.74 | 36.79 | 36.57 | 36.64 | 6831900.0 |
| 2004-02-26 15:00:00 | QQQ | ETF | 36.645 | 36.765 | 36.6 | 36.7 | 8301200.0 |
| 2004-02-26 16:00:00 | QQQ | ETF | 36.73 | 36.73 | 36.65 | 36.69 | 2739000.0 |
| 2004-02-26 17:00:00 | QQQ | ETF | 36.69 | 36.73 | 36.671 | 36.72 | 182000.0 |
| 2004-02-26 18:00:00 | QQQ | ETF | 36.72 | 36.73 | 36.697 | 36.71 | 104000.0 |
| 2004-02-26 19:00:00 | QQQ | ETF | 36.7 | 36.73 | 36.7 | 36.7 | 30700.0 |
| 2004-02-26 09:00:00 | IWM | ETF | 57.59 | 57.725 | 57.4 | 57.55 | 1108800.0 |
| 2004-02-26 10:00:00 | IWM | ETF | 57.55 | 57.795 | 57.429 | 57.755 | 1091400.0 |
| 2004-02-26 11:00:00 | IWM | ETF | 57.795 | 58.105 | 57.79 | 57.99 | 1775400.0 |
| 2004-02-26 12:00:00 | IWM | ETF | 57.995 | 58.19 | 57.975 | 58.165 | 1019400.0 |
| 2004-02-26 13:00:00 | IWM | ETF | 58.165 | 58.165 | 57.975 | 58.05 | 353000.0 |
| 2004-02-26 14:00:00 | IWM | ETF | 58.06 | 58.145 | 57.91 | 58.02 | 918600.0 |
| 2004-02-26 15:00:00 | IWM | ETF | 58.015 | 58.18 | 57.975 | 58.085 | 1366600.0 |
| 2004-02-26 16:00:00 | IWM | ETF | 58.075 | 58.205 | 58.025 | 58.205 | 362600.0 |
| 2004-02-26 17:00:00 | IWM | ETF | 58.069 | 58.09 | 58.069 | 58.089 | 5000.0 |
| 2004-02-26 08:00:00 | DIA | ETF | 106.17 | 106.19 | 105.9 | 105.93 | 33500.0 |
| 2004-02-26 09:00:00 | DIA | ETF | 105.95 | 105.99 | 105.62 | 105.733 | 672900.0 |
| 2004-02-26 10:00:00 | DIA | ETF | 105.73 | 105.758 | 105.52 | 105.67 | 566100.0 |
| 2004-02-26 11:00:00 | DIA | ETF | 105.65 | 105.948 | 105.65 | 105.85 | 863300.0 |
| 2004-02-26 12:00:00 | DIA | ETF | 105.89 | 106.25 | 105.82 | 106.08 | 948200.0 |
| 2004-02-26 13:00:00 | DIA | ETF | 106.08 | 106.12 | 105.95 | 106.0 | 471600.0 |
| 2004-02-26 14:00:00 | DIA | ETF | 106.04 | 106.11 | 105.87 | 105.96 | 446600.0 |
| 2004-02-26 15:00:00 | DIA | ETF | 105.937 | 106.18 | 105.93 | 105.99 | 344700.0 |
| 2004-02-26 16:00:00 | DIA | ETF | 105.99 | 106.0 | 105.88 | 105.9 | 241200.0 |
| 2004-02-26 09:00:00 | TLT | ETF | 87.95 | 87.95 | 87.82 | 87.92 | 25100.0 |
| 2004-02-26 10:00:00 | TLT | ETF | 87.92 | 87.96 | 87.8 | 87.9 | 71100.0 |
| 2004-02-26 11:00:00 | TLT | ETF | 87.9 | 87.91 | 87.79 | 87.91 | 76000.0 |
| 2004-02-26 12:00:00 | TLT | ETF | 87.84 | 87.84 | 87.61 | 87.7 | 64000.0 |
| 2004-02-26 13:00:00 | TLT | ETF | 87.75 | 87.75 | 87.54 | 87.6 | 58900.0 |
| 2004-02-26 14:00:00 | TLT | ETF | 87.6 | 87.8 | 87.6 | 87.76 | 38200.0 |
| 2004-02-26 15:00:00 | TLT | ETF | 87.79 | 87.94 | 87.78 | 87.85 | 65300.0 |
| 2004-02-26 16:00:00 | TLT | ETF | 87.9 | 87.9 | 87.9 | 87.9 | 500.0 |
> showing 50 of 659 rows — these rows as CSV