PREVIEW / etf_1hour / 2002-07-19
file: by_date/etf_1hour/2002/2002-07-19.parquet size: 14 KB rows: 322
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-19 09:00:00 | SPY | ETF | 86.76 | 87.2 | 86.35 | 86.83 | 6419800.0 |
| 2002-07-19 10:00:00 | SPY | ETF | 86.85 | 87.55 | 86.65 | 86.85 | 8484200.0 |
| 2002-07-19 11:00:00 | SPY | ETF | 86.85 | 87.03 | 86.05 | 86.14 | 7660200.0 |
| 2002-07-19 12:00:00 | SPY | ETF | 86.14 | 86.72 | 86.0 | 86.07 | 5009800.0 |
| 2002-07-19 13:00:00 | SPY | ETF | 86.1 | 86.8 | 85.84 | 86.2 | 6406900.0 |
| 2002-07-19 14:00:00 | SPY | ETF | 86.2 | 86.44 | 85.58 | 86.1 | 7269000.0 |
| 2002-07-19 15:00:00 | SPY | ETF | 86.14 | 86.15 | 84.3 | 84.8 | 16390000.0 |
| 2002-07-19 16:00:00 | SPY | ETF | 84.83 | 85.3 | 84.64 | 84.71 | 2133000.0 |
| 2002-07-19 09:00:00 | QQQ | ETF | 24.33 | 24.5 | 24.02 | 24.4 | 23093800.0 |
| 2002-07-19 10:00:00 | QQQ | ETF | 24.41 | 24.71 | 24.31 | 24.5 | 24230500.0 |
| 2002-07-19 11:00:00 | QQQ | ETF | 24.5 | 24.64 | 24.19 | 24.26 | 15117400.0 |
| 2002-07-19 12:00:00 | QQQ | ETF | 24.25 | 24.45 | 24.22 | 24.3 | 9639900.0 |
| 2002-07-19 13:00:00 | QQQ | ETF | 24.29 | 24.5 | 24.15 | 24.28 | 10565200.0 |
| 2002-07-19 14:00:00 | QQQ | ETF | 24.28 | 24.4 | 24.16 | 24.34 | 10628800.0 |
| 2002-07-19 15:00:00 | QQQ | ETF | 24.34 | 24.35 | 23.8 | 24.0 | 23430700.0 |
| 2002-07-19 16:00:00 | QQQ | ETF | 23.95 | 24.05 | 23.88 | 23.99 | 2617300.0 |
| 2002-07-19 09:00:00 | IWM | ETF | 39.025 | 39.325 | 38.925 | 39.19 | 228600.0 |
| 2002-07-19 10:00:00 | IWM | ETF | 39.11 | 39.335 | 39.025 | 39.055 | 784000.0 |
| 2002-07-19 11:00:00 | IWM | ETF | 39.045 | 39.05 | 38.555 | 38.67 | 331200.0 |
| 2002-07-19 12:00:00 | IWM | ETF | 38.6 | 38.825 | 38.59 | 38.74 | 262000.0 |
| 2002-07-19 13:00:00 | IWM | ETF | 38.69 | 39.0 | 38.6 | 38.87 | 325800.0 |
| 2002-07-19 14:00:00 | IWM | ETF | 38.86 | 38.955 | 38.75 | 38.8 | 348800.0 |
| 2002-07-19 15:00:00 | IWM | ETF | 38.8 | 38.855 | 38.325 | 38.545 | 485400.0 |
| 2002-07-19 16:00:00 | IWM | ETF | 38.555 | 38.7 | 38.46 | 38.625 | 60200.0 |
| 2002-07-19 09:00:00 | DIA | ETF | 82.59 | 82.88 | 81.95 | 82.45 | 1938400.0 |
| 2002-07-19 10:00:00 | DIA | ETF | 82.5 | 83.1 | 82.14 | 82.19 | 1379500.0 |
| 2002-07-19 11:00:00 | DIA | ETF | 82.18 | 82.25 | 81.25 | 81.36 | 2589300.0 |
| 2002-07-19 12:00:00 | DIA | ETF | 81.41 | 82.0 | 81.25 | 81.4 | 1328200.0 |
| 2002-07-19 13:00:00 | DIA | ETF | 81.34 | 82.05 | 80.97 | 81.49 | 1750500.0 |
| 2002-07-19 14:00:00 | DIA | ETF | 81.54 | 81.7 | 80.79 | 81.31 | 1988400.0 |
| 2002-07-19 15:00:00 | DIA | ETF | 81.32 | 81.4 | 79.6 | 80.11 | 4102600.0 |
| 2002-07-19 16:00:00 | DIA | ETF | 80.15 | 80.35 | 79.91 | 80.0 | 150500.0 |
> showing 32 of 322 rows — these rows as CSV