PREVIEW / etf_1hour / 2002-12-26
file: by_date/etf_1hour/2002/2002-12-26.parquet size: 16 KB rows: 376
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 |
|---|---|---|---|---|---|---|---|
| 2002-12-26 08:00:00 | SPY | ETF | 89.5 | 90.0 | 89.5 | 89.93 | 19100.0 |
| 2002-12-26 09:00:00 | SPY | ETF | 89.91 | 90.18 | 89.64 | 90.03 | 1671500.0 |
| 2002-12-26 10:00:00 | SPY | ETF | 90.06 | 90.61 | 90.05 | 90.45 | 2970800.0 |
| 2002-12-26 11:00:00 | SPY | ETF | 90.46 | 90.54 | 90.11 | 90.14 | 1204800.0 |
| 2002-12-26 12:00:00 | SPY | ETF | 90.13 | 90.34 | 90.1 | 90.19 | 1013900.0 |
| 2002-12-26 13:00:00 | SPY | ETF | 90.19 | 90.32 | 90.0 | 90.06 | 1105500.0 |
| 2002-12-26 14:00:00 | SPY | ETF | 90.0 | 90.13 | 89.23 | 89.4 | 2516600.0 |
| 2002-12-26 15:00:00 | SPY | ETF | 89.42 | 89.56 | 88.84 | 89.04 | 3451600.0 |
| 2002-12-26 16:00:00 | SPY | ETF | 89.03 | 89.4 | 88.97 | 89.3 | 1279900.0 |
| 2002-12-26 17:00:00 | SPY | ETF | 89.32 | 89.33 | 89.3 | 89.3 | 6100.0 |
| 2002-12-26 18:00:00 | SPY | ETF | 89.26 | 89.26 | 89.26 | 89.26 | 3000.0 |
| 2002-12-26 19:00:00 | SPY | ETF | 89.35 | 89.35 | 89.26 | 89.29 | 800.0 |
| 2002-12-26 08:00:00 | QQQ | ETF | 25.5 | 25.67 | 25.48 | 25.63 | 82000.0 |
| 2002-12-26 09:00:00 | QQQ | ETF | 25.64 | 25.81 | 25.5 | 25.74 | 5013600.0 |
| 2002-12-26 10:00:00 | QQQ | ETF | 25.74 | 25.91 | 25.73 | 25.86 | 6664500.0 |
| 2002-12-26 11:00:00 | QQQ | ETF | 25.83 | 25.86 | 25.69 | 25.71 | 2859200.0 |
| 2002-12-26 12:00:00 | QQQ | ETF | 25.71 | 25.8 | 25.7 | 25.72 | 1444000.0 |
| 2002-12-26 13:00:00 | QQQ | ETF | 25.72 | 25.76 | 25.58 | 25.6 | 1605800.0 |
| 2002-12-26 14:00:00 | QQQ | ETF | 25.6 | 25.65 | 25.26 | 25.36 | 6038600.0 |
| 2002-12-26 15:00:00 | QQQ | ETF | 25.36 | 25.42 | 25.17 | 25.26 | 5958900.0 |
| 2002-12-26 16:00:00 | QQQ | ETF | 25.23 | 25.34 | 25.23 | 25.29 | 522600.0 |
| 2002-12-26 17:00:00 | QQQ | ETF | 25.29 | 25.3 | 25.28 | 25.3 | 52400.0 |
| 2002-12-26 18:00:00 | QQQ | ETF | 25.28 | 25.31 | 25.27 | 25.31 | 7600.0 |
| 2002-12-26 19:00:00 | QQQ | ETF | 25.31 | 25.31 | 25.31 | 25.31 | 2600.0 |
| 2002-12-26 09:00:00 | IWM | ETF | 38.75 | 38.875 | 38.71 | 38.82 | 112800.0 |
| 2002-12-26 10:00:00 | IWM | ETF | 38.82 | 39.07 | 38.82 | 39.035 | 154000.0 |
| 2002-12-26 11:00:00 | IWM | ETF | 39.0 | 39.04 | 38.9 | 38.9 | 56000.0 |
| 2002-12-26 12:00:00 | IWM | ETF | 38.925 | 38.955 | 38.875 | 38.895 | 204800.0 |
| 2002-12-26 13:00:00 | IWM | ETF | 38.9 | 38.945 | 38.82 | 38.845 | 146000.0 |
| 2002-12-26 14:00:00 | IWM | ETF | 38.825 | 38.865 | 38.705 | 38.72 | 88600.0 |
| 2002-12-26 15:00:00 | IWM | ETF | 38.745 | 38.845 | 38.525 | 38.645 | 162200.0 |
| 2002-12-26 16:00:00 | IWM | ETF | 38.655 | 38.7 | 38.655 | 38.7 | 10000.0 |
| 2002-12-26 08:00:00 | DIA | ETF | 84.75 | 85.2 | 84.7 | 85.2 | 2600.0 |
| 2002-12-26 09:00:00 | DIA | ETF | 84.9 | 85.2 | 84.81 | 85.11 | 308000.0 |
| 2002-12-26 10:00:00 | DIA | ETF | 85.19 | 85.7 | 85.11 | 85.56 | 485400.0 |
| 2002-12-26 11:00:00 | DIA | ETF | 85.57 | 85.69 | 85.3 | 85.35 | 206700.0 |
| 2002-12-26 12:00:00 | DIA | ETF | 85.33 | 85.53 | 85.3 | 85.35 | 181700.0 |
| 2002-12-26 13:00:00 | DIA | ETF | 85.33 | 85.48 | 85.2 | 85.24 | 117900.0 |
| 2002-12-26 14:00:00 | DIA | ETF | 85.26 | 85.3 | 84.5 | 84.65 | 511600.0 |
| 2002-12-26 15:00:00 | DIA | ETF | 84.65 | 84.78 | 84.1 | 84.27 | 585100.0 |
| 2002-12-26 16:00:00 | DIA | ETF | 84.26 | 84.59 | 84.25 | 84.52 | 90600.0 |
| 2002-12-26 17:00:00 | DIA | ETF | 84.52 | 84.52 | 84.48 | 84.52 | 1600.0 |
| 2002-12-26 19:00:00 | DIA | ETF | 84.7 | 84.7 | 84.7 | 84.7 | 100.0 |
| 2002-12-26 09:00:00 | TLT | ETF | 87.9 | 87.9 | 87.85 | 87.85 | 1600.0 |
| 2002-12-26 10:00:00 | TLT | ETF | 87.8 | 87.82 | 87.8 | 87.82 | 1100.0 |
| 2002-12-26 11:00:00 | TLT | ETF | 87.78 | 87.78 | 87.73 | 87.73 | 600.0 |
| 2002-12-26 12:00:00 | TLT | ETF | 87.75 | 87.86 | 87.75 | 87.86 | 1300.0 |
| 2002-12-26 13:00:00 | TLT | ETF | 87.93 | 87.94 | 87.88 | 87.9 | 700.0 |
| 2002-12-26 14:00:00 | TLT | ETF | 87.96 | 87.96 | 87.96 | 87.96 | 100.0 |
| 2002-12-26 15:00:00 | TLT | ETF | 87.97 | 88.0 | 87.95 | 88.0 | 6400.0 |
> showing 50 of 376 rows — these rows as CSV