PREVIEW / etf_1hour / 2002-09-19
file: by_date/etf_1hour/2002/2002-09-19.parquet size: 15 KB rows: 347
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-09-19 09:00:00 | SPY | ETF | 85.99 | 86.34 | 85.7 | 86.26 | 4524800.0 |
| 2002-09-19 10:00:00 | SPY | ETF | 86.24 | 86.74 | 85.82 | 86.14 | 6987200.0 |
| 2002-09-19 11:00:00 | SPY | ETF | 86.2 | 86.4 | 85.86 | 86.06 | 3735600.0 |
| 2002-09-19 12:00:00 | SPY | ETF | 86.11 | 86.8 | 86.02 | 86.41 | 7067400.0 |
| 2002-09-19 13:00:00 | SPY | ETF | 86.43 | 86.45 | 85.82 | 85.91 | 3470900.0 |
| 2002-09-19 14:00:00 | SPY | ETF | 85.9 | 86.2 | 85.41 | 85.43 | 6325700.0 |
| 2002-09-19 15:00:00 | SPY | ETF | 85.45 | 85.68 | 84.78 | 84.85 | 11589600.0 |
| 2002-09-19 16:00:00 | SPY | ETF | 84.85 | 84.95 | 84.7 | 84.7 | 1625500.0 |
| 2002-09-19 09:00:00 | QQQ | ETF | 21.7 | 21.92 | 21.7 | 21.89 | 9059300.0 |
| 2002-09-19 10:00:00 | QQQ | ETF | 21.88 | 22.08 | 21.8 | 21.99 | 16254900.0 |
| 2002-09-19 11:00:00 | QQQ | ETF | 22.0 | 22.13 | 21.81 | 21.86 | 7952400.0 |
| 2002-09-19 12:00:00 | QQQ | ETF | 21.86 | 22.09 | 21.82 | 21.97 | 9120400.0 |
| 2002-09-19 13:00:00 | QQQ | ETF | 21.98 | 21.99 | 21.74 | 21.79 | 7601100.0 |
| 2002-09-19 14:00:00 | QQQ | ETF | 21.79 | 21.93 | 21.61 | 21.67 | 11906300.0 |
| 2002-09-19 15:00:00 | QQQ | ETF | 21.67 | 21.79 | 21.55 | 21.6 | 15857000.0 |
| 2002-09-19 16:00:00 | QQQ | ETF | 21.57 | 21.62 | 21.55 | 21.58 | 1442900.0 |
| 2002-09-19 09:00:00 | IWM | ETF | 36.75 | 37.14 | 36.75 | 37.0 | 141400.0 |
| 2002-09-19 10:00:00 | IWM | ETF | 37.12 | 37.245 | 37.05 | 37.11 | 95600.0 |
| 2002-09-19 11:00:00 | IWM | ETF | 37.18 | 37.285 | 37.1 | 37.1 | 176400.0 |
| 2002-09-19 12:00:00 | IWM | ETF | 37.095 | 37.225 | 37.05 | 37.075 | 95000.0 |
| 2002-09-19 13:00:00 | IWM | ETF | 37.065 | 37.07 | 36.67 | 36.7 | 165600.0 |
| 2002-09-19 14:00:00 | IWM | ETF | 36.7 | 36.76 | 36.4 | 36.505 | 386600.0 |
| 2002-09-19 15:00:00 | IWM | ETF | 36.42 | 36.57 | 36.3 | 36.305 | 337200.0 |
| 2002-09-19 16:00:00 | IWM | ETF | 36.325 | 36.395 | 36.325 | 36.395 | 1200.0 |
| 2002-09-19 09:00:00 | DIA | ETF | 80.5 | 80.8 | 80.29 | 80.75 | 1151300.0 |
| 2002-09-19 10:00:00 | DIA | ETF | 80.7 | 81.2 | 80.5 | 80.76 | 1719100.0 |
| 2002-09-19 11:00:00 | DIA | ETF | 80.82 | 80.98 | 80.54 | 80.75 | 1081200.0 |
| 2002-09-19 12:00:00 | DIA | ETF | 80.76 | 81.49 | 80.73 | 81.16 | 1362300.0 |
| 2002-09-19 13:00:00 | DIA | ETF | 81.17 | 81.18 | 80.6 | 80.66 | 647000.0 |
| 2002-09-19 14:00:00 | DIA | ETF | 80.65 | 80.97 | 80.27 | 80.3 | 2565100.0 |
| 2002-09-19 15:00:00 | DIA | ETF | 80.3 | 80.49 | 79.51 | 79.67 | 3304300.0 |
| 2002-09-19 16:00:00 | DIA | ETF | 79.62 | 79.69 | 79.5 | 79.64 | 340100.0 |
| 2002-09-19 09:00:00 | TLT | ETF | 89.7 | 89.72 | 89.45 | 89.5 | 52400.0 |
| 2002-09-19 10:00:00 | TLT | ETF | 89.44 | 89.68 | 89.35 | 89.66 | 26300.0 |
| 2002-09-19 11:00:00 | TLT | ETF | 89.64 | 89.75 | 89.47 | 89.68 | 6700.0 |
| 2002-09-19 12:00:00 | TLT | ETF | 89.55 | 89.6 | 89.26 | 89.26 | 1900.0 |
| 2002-09-19 13:00:00 | TLT | ETF | 89.48 | 89.65 | 89.48 | 89.62 | 3100.0 |
| 2002-09-19 14:00:00 | TLT | ETF | 89.6 | 89.7 | 89.39 | 89.62 | 7500.0 |
| 2002-09-19 15:00:00 | TLT | ETF | 89.67 | 89.77 | 89.57 | 89.72 | 12000.0 |
> showing 39 of 347 rows — these rows as CSV