PREVIEW / etf_1hour / 2003-02-24
file: by_date/etf_1hour/2003/2003-02-24.parquet size: 16 KB rows: 373
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-02-24 08:00:00 | SPY | ETF | 85.13 | 85.13 | 84.9 | 85.0 | 20800.0 |
| 2003-02-24 09:00:00 | SPY | ETF | 85.01 | 85.02 | 84.42 | 84.55 | 3169900.0 |
| 2003-02-24 10:00:00 | SPY | ETF | 84.48 | 84.64 | 84.19 | 84.46 | 4946300.0 |
| 2003-02-24 11:00:00 | SPY | ETF | 84.45 | 84.54 | 84.06 | 84.1 | 2320300.0 |
| 2003-02-24 12:00:00 | SPY | ETF | 84.1 | 84.14 | 83.65 | 83.88 | 3771100.0 |
| 2003-02-24 13:00:00 | SPY | ETF | 83.86 | 84.09 | 83.76 | 83.86 | 2183600.0 |
| 2003-02-24 14:00:00 | SPY | ETF | 83.87 | 84.05 | 83.59 | 83.93 | 3546200.0 |
| 2003-02-24 15:00:00 | SPY | ETF | 83.97 | 84.18 | 83.61 | 83.68 | 6416200.0 |
| 2003-02-24 16:00:00 | SPY | ETF | 83.68 | 83.8 | 83.6 | 83.8 | 1218000.0 |
| 2003-02-24 17:00:00 | SPY | ETF | 83.71 | 83.75 | 83.65 | 83.73 | 15100.0 |
| 2003-02-24 18:00:00 | SPY | ETF | 83.73 | 83.74 | 83.53 | 83.53 | 21300.0 |
| 2003-02-24 19:00:00 | SPY | ETF | 83.55 | 83.55 | 83.46 | 83.47 | 44200.0 |
| 2003-02-24 08:00:00 | QQQ | ETF | 25.18 | 25.18 | 25.14 | 25.17 | 12500.0 |
| 2003-02-24 09:00:00 | QQQ | ETF | 25.15 | 25.2 | 25.01 | 25.05 | 9307100.0 |
| 2003-02-24 10:00:00 | QQQ | ETF | 25.03 | 25.21 | 24.98 | 25.18 | 8687000.0 |
| 2003-02-24 11:00:00 | QQQ | ETF | 25.19 | 25.19 | 25.0 | 25.07 | 6100100.0 |
| 2003-02-24 12:00:00 | QQQ | ETF | 25.06 | 25.08 | 24.8 | 24.88 | 7939900.0 |
| 2003-02-24 13:00:00 | QQQ | ETF | 24.88 | 24.94 | 24.81 | 24.9 | 3272700.0 |
| 2003-02-24 14:00:00 | QQQ | ETF | 24.9 | 24.91 | 24.74 | 24.81 | 5908800.0 |
| 2003-02-24 15:00:00 | QQQ | ETF | 24.81 | 24.94 | 24.71 | 24.74 | 8712600.0 |
| 2003-02-24 16:00:00 | QQQ | ETF | 24.74 | 24.79 | 24.69 | 24.7 | 2445200.0 |
| 2003-02-24 17:00:00 | QQQ | ETF | 24.72 | 24.74 | 24.7 | 24.7 | 36200.0 |
| 2003-02-24 18:00:00 | QQQ | ETF | 24.71 | 24.73 | 24.68 | 24.68 | 51000.0 |
| 2003-02-24 19:00:00 | QQQ | ETF | 24.7 | 24.7 | 24.64 | 24.65 | 17200.0 |
| 2003-02-24 09:00:00 | IWM | ETF | 36.095 | 36.095 | 35.83 | 35.83 | 225200.0 |
| 2003-02-24 10:00:00 | IWM | ETF | 35.875 | 36.01 | 35.735 | 35.975 | 299000.0 |
| 2003-02-24 11:00:00 | IWM | ETF | 35.98 | 36.005 | 35.825 | 35.875 | 369000.0 |
| 2003-02-24 12:00:00 | IWM | ETF | 35.86 | 35.885 | 35.755 | 35.86 | 430200.0 |
| 2003-02-24 13:00:00 | IWM | ETF | 35.86 | 35.915 | 35.83 | 35.85 | 180400.0 |
| 2003-02-24 14:00:00 | IWM | ETF | 35.82 | 35.865 | 35.78 | 35.82 | 94800.0 |
| 2003-02-24 15:00:00 | IWM | ETF | 35.845 | 35.9 | 35.6 | 35.615 | 761200.0 |
| 2003-02-24 16:00:00 | IWM | ETF | 35.65 | 35.675 | 35.605 | 35.605 | 3800.0 |
| 2003-02-24 17:00:00 | IWM | ETF | 35.695 | 35.695 | 35.695 | 35.695 | 83400.0 |
| 2003-02-24 08:00:00 | DIA | ETF | 79.98 | 79.98 | 79.91 | 79.91 | 5700.0 |
| 2003-02-24 09:00:00 | DIA | ETF | 79.94 | 79.95 | 79.4 | 79.45 | 808700.0 |
| 2003-02-24 10:00:00 | DIA | ETF | 79.47 | 79.59 | 79.18 | 79.46 | 1269900.0 |
| 2003-02-24 11:00:00 | DIA | ETF | 79.42 | 79.46 | 79.03 | 79.15 | 723700.0 |
| 2003-02-24 12:00:00 | DIA | ETF | 79.12 | 79.16 | 78.66 | 78.84 | 1108500.0 |
| 2003-02-24 13:00:00 | DIA | ETF | 78.82 | 79.01 | 78.76 | 78.82 | 363400.0 |
| 2003-02-24 14:00:00 | DIA | ETF | 78.82 | 79.0 | 78.6 | 78.85 | 556600.0 |
| 2003-02-24 15:00:00 | DIA | ETF | 78.91 | 79.2 | 78.62 | 78.7 | 1342200.0 |
| 2003-02-24 16:00:00 | DIA | ETF | 78.7 | 78.78 | 78.61 | 78.75 | 66900.0 |
| 2003-02-24 17:00:00 | DIA | ETF | 78.74 | 78.77 | 78.7 | 78.75 | 6800.0 |
| 2003-02-24 18:00:00 | DIA | ETF | 78.75 | 78.76 | 78.5 | 78.65 | 10300.0 |
| 2003-02-24 19:00:00 | DIA | ETF | 78.5 | 78.5 | 78.5 | 78.5 | 300.0 |
| 2003-02-24 09:00:00 | TLT | ETF | 88.88 | 88.88 | 88.7 | 88.73 | 14400.0 |
| 2003-02-24 10:00:00 | TLT | ETF | 88.73 | 88.81 | 88.63 | 88.71 | 99400.0 |
| 2003-02-24 11:00:00 | TLT | ETF | 88.72 | 88.9 | 88.72 | 88.8 | 15000.0 |
| 2003-02-24 12:00:00 | TLT | ETF | 88.84 | 88.86 | 88.74 | 88.74 | 9400.0 |
| 2003-02-24 13:00:00 | TLT | ETF | 88.8 | 88.8 | 88.62 | 88.68 | 2200.0 |
> showing 50 of 373 rows — these rows as CSV