PREVIEW / etf_1hour / 2002-08-05
file: by_date/etf_1hour/2002/2002-08-05.parquet size: 15 KB rows: 342
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-08-05 09:00:00 | SPY | ETF | 86.49 | 86.93 | 85.97 | 86.13 | 5016900.0 |
| 2002-08-05 10:00:00 | SPY | ETF | 86.13 | 86.52 | 85.56 | 85.56 | 6451000.0 |
| 2002-08-05 11:00:00 | SPY | ETF | 85.54 | 85.78 | 85.0 | 85.26 | 4491500.0 |
| 2002-08-05 12:00:00 | SPY | ETF | 85.28 | 85.58 | 84.53 | 84.6 | 3717400.0 |
| 2002-08-05 13:00:00 | SPY | ETF | 84.61 | 85.33 | 84.56 | 84.8 | 4837600.0 |
| 2002-08-05 14:00:00 | SPY | ETF | 84.82 | 84.96 | 84.21 | 84.39 | 8441800.0 |
| 2002-08-05 15:00:00 | SPY | ETF | 84.32 | 84.55 | 83.6 | 83.73 | 8415600.0 |
| 2002-08-05 16:00:00 | SPY | ETF | 83.7 | 83.85 | 83.55 | 83.77 | 1658200.0 |
| 2002-08-05 09:00:00 | QQQ | ETF | 22.11 | 22.32 | 22.07 | 22.13 | 12964300.0 |
| 2002-08-05 10:00:00 | QQQ | ETF | 22.13 | 22.28 | 21.78 | 21.78 | 18916300.0 |
| 2002-08-05 11:00:00 | QQQ | ETF | 21.8 | 21.82 | 21.56 | 21.7 | 14158300.0 |
| 2002-08-05 12:00:00 | QQQ | ETF | 21.69 | 21.8 | 21.51 | 21.55 | 6858400.0 |
| 2002-08-05 13:00:00 | QQQ | ETF | 21.55 | 21.73 | 21.52 | 21.59 | 5953800.0 |
| 2002-08-05 14:00:00 | QQQ | ETF | 21.59 | 21.62 | 21.35 | 21.44 | 8830100.0 |
| 2002-08-05 15:00:00 | QQQ | ETF | 21.42 | 21.51 | 21.3 | 21.33 | 12170800.0 |
| 2002-08-05 16:00:00 | QQQ | ETF | 21.34 | 21.46 | 21.31 | 21.44 | 1098800.0 |
| 2002-08-05 09:00:00 | IWM | ETF | 37.485 | 37.61 | 37.425 | 37.53 | 334200.0 |
| 2002-08-05 10:00:00 | IWM | ETF | 37.48 | 37.645 | 37.25 | 37.325 | 400000.0 |
| 2002-08-05 11:00:00 | IWM | ETF | 37.325 | 37.325 | 37.05 | 37.1 | 144200.0 |
| 2002-08-05 12:00:00 | IWM | ETF | 37.245 | 37.245 | 36.83 | 36.85 | 99200.0 |
| 2002-08-05 13:00:00 | IWM | ETF | 36.85 | 37.14 | 36.85 | 37.025 | 171200.0 |
| 2002-08-05 14:00:00 | IWM | ETF | 37.015 | 37.02 | 36.84 | 36.86 | 51200.0 |
| 2002-08-05 15:00:00 | IWM | ETF | 36.925 | 36.925 | 36.485 | 36.485 | 191200.0 |
| 2002-08-05 16:00:00 | IWM | ETF | 36.485 | 36.485 | 36.485 | 36.485 | 200.0 |
| 2002-08-05 09:00:00 | DIA | ETF | 82.9 | 83.25 | 82.44 | 82.58 | 1189000.0 |
| 2002-08-05 10:00:00 | DIA | ETF | 82.5 | 83.06 | 82.11 | 82.18 | 1498700.0 |
| 2002-08-05 11:00:00 | DIA | ETF | 82.16 | 82.35 | 81.65 | 81.95 | 1261300.0 |
| 2002-08-05 12:00:00 | DIA | ETF | 81.93 | 82.13 | 81.14 | 81.17 | 848900.0 |
| 2002-08-05 13:00:00 | DIA | ETF | 81.19 | 81.88 | 81.15 | 81.47 | 769000.0 |
| 2002-08-05 14:00:00 | DIA | ETF | 81.49 | 81.64 | 81.0 | 81.16 | 1240700.0 |
| 2002-08-05 15:00:00 | DIA | ETF | 81.15 | 81.42 | 80.3 | 80.36 | 1500600.0 |
| 2002-08-05 16:00:00 | DIA | ETF | 80.4 | 80.5 | 80.34 | 80.47 | 195100.0 |
| 2002-08-05 09:00:00 | TLT | ETF | 84.04 | 84.16 | 84.0 | 84.08 | 3500.0 |
| 2002-08-05 10:00:00 | TLT | ETF | 83.88 | 84.08 | 83.85 | 84.08 | 4900.0 |
| 2002-08-05 11:00:00 | TLT | ETF | 84.16 | 84.22 | 84.06 | 84.19 | 3000.0 |
| 2002-08-05 12:00:00 | TLT | ETF | 84.15 | 84.32 | 84.14 | 84.28 | 8100.0 |
| 2002-08-05 13:00:00 | TLT | ETF | 84.2 | 84.29 | 84.0 | 84.29 | 6100.0 |
| 2002-08-05 14:00:00 | TLT | ETF | 84.26 | 84.44 | 84.16 | 84.23 | 15900.0 |
| 2002-08-05 15:00:00 | TLT | ETF | 84.2 | 84.36 | 84.16 | 84.22 | 19600.0 |
> showing 39 of 342 rows — these rows as CSV