PREVIEW / etf_1hour / 2002-07-25
file: by_date/etf_1hour/2002/2002-07-25.parquet size: 15 KB rows: 333
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-07-25 09:00:00 | SPY | ETF | 84.27 | 84.34 | 83.12 | 84.03 | 7372000.0 |
| 2002-07-25 10:00:00 | SPY | ETF | 84.1 | 85.85 | 83.9 | 84.28 | 17277300.0 |
| 2002-07-25 11:00:00 | SPY | ETF | 84.26 | 85.6 | 84.12 | 85.15 | 6550400.0 |
| 2002-07-25 12:00:00 | SPY | ETF | 85.08 | 85.29 | 83.5 | 84.14 | 12093500.0 |
| 2002-07-25 13:00:00 | SPY | ETF | 84.07 | 84.74 | 83.3 | 83.46 | 6263400.0 |
| 2002-07-25 14:00:00 | SPY | ETF | 83.45 | 83.64 | 81.6 | 83.04 | 16360600.0 |
| 2002-07-25 15:00:00 | SPY | ETF | 83.01 | 85.05 | 82.35 | 84.2 | 15157600.0 |
| 2002-07-25 16:00:00 | SPY | ETF | 84.22 | 84.3 | 83.9 | 84.0 | 2118000.0 |
| 2002-07-25 09:00:00 | QQQ | ETF | 23.25 | 23.28 | 22.98 | 23.22 | 17850100.0 |
| 2002-07-25 10:00:00 | QQQ | ETF | 23.22 | 23.4 | 22.65 | 22.7 | 29452600.0 |
| 2002-07-25 11:00:00 | QQQ | ETF | 22.72 | 22.94 | 22.52 | 22.66 | 20517600.0 |
| 2002-07-25 12:00:00 | QQQ | ETF | 22.65 | 22.7 | 22.13 | 22.4 | 20807500.0 |
| 2002-07-25 13:00:00 | QQQ | ETF | 22.42 | 22.65 | 22.13 | 22.25 | 11457500.0 |
| 2002-07-25 14:00:00 | QQQ | ETF | 22.24 | 22.32 | 21.8 | 22.08 | 21672200.0 |
| 2002-07-25 15:00:00 | QQQ | ETF | 22.06 | 22.76 | 21.9 | 22.23 | 25112700.0 |
| 2002-07-25 16:00:00 | QQQ | ETF | 22.22 | 22.28 | 22.2 | 22.25 | 804200.0 |
| 2002-07-25 09:00:00 | IWM | ETF | 37.0 | 37.875 | 37.0 | 37.875 | 362200.0 |
| 2002-07-25 10:00:00 | IWM | ETF | 37.77 | 38.6 | 37.5 | 37.95 | 1287400.0 |
| 2002-07-25 11:00:00 | IWM | ETF | 37.92 | 38.265 | 37.75 | 38.145 | 895000.0 |
| 2002-07-25 12:00:00 | IWM | ETF | 38.14 | 38.175 | 37.56 | 37.785 | 975600.0 |
| 2002-07-25 13:00:00 | IWM | ETF | 37.725 | 37.85 | 37.425 | 37.45 | 213400.0 |
| 2002-07-25 14:00:00 | IWM | ETF | 37.45 | 37.49 | 36.75 | 37.15 | 646000.0 |
| 2002-07-25 15:00:00 | IWM | ETF | 37.235 | 37.95 | 37.045 | 37.8 | 1392400.0 |
| 2002-07-25 16:00:00 | IWM | ETF | 37.75 | 37.875 | 37.7 | 37.7 | 226800.0 |
| 2002-07-25 09:00:00 | DIA | ETF | 81.75 | 81.76 | 80.8 | 81.6 | 1595400.0 |
| 2002-07-25 10:00:00 | DIA | ETF | 81.6 | 83.02 | 81.25 | 81.61 | 4023300.0 |
| 2002-07-25 11:00:00 | DIA | ETF | 81.59 | 83.2 | 81.5 | 82.85 | 2135600.0 |
| 2002-07-25 12:00:00 | DIA | ETF | 82.86 | 83.02 | 81.33 | 81.9 | 2943900.0 |
| 2002-07-25 13:00:00 | DIA | ETF | 81.85 | 82.53 | 80.9 | 81.08 | 1584800.0 |
| 2002-07-25 14:00:00 | DIA | ETF | 81.08 | 81.3 | 79.25 | 80.5 | 4409700.0 |
| 2002-07-25 15:00:00 | DIA | ETF | 80.6 | 82.7 | 79.8 | 81.88 | 3610900.0 |
| 2002-07-25 16:00:00 | DIA | ETF | 81.9 | 81.95 | 81.7 | 81.78 | 122700.0 |
> showing 32 of 333 rows — these rows as CSV