PREVIEW / etf_daily / 2005-01-10
file: by_date/etf_daily/2005/2005-01-10.parquet size: 14 KB rows: 253
schema
date DATE symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| date | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2005-01-10 | SPY | ETF | 118.34 | 119.46 | 118.34 | 119.0 | 56563300.0 |
| 2005-01-10 | QQQ | ETF | 38.45 | 38.87 | 38.389 | 38.53 | 88824600.0 |
| 2005-01-10 | IWM | ETF | 61.0 | 62.1 | 60.95 | 61.55 | 23449000.0 |
| 2005-01-10 | DIA | ETF | 105.84 | 106.63 | 105.77 | 106.2 | 6028100.0 |
| 2005-01-10 | GLD | ETF | 41.99 | 42.07 | 41.89 | 41.95 | 1025800.0 |
| 2005-01-10 | TLT | ETF | 88.64 | 88.72 | 88.47 | 88.68 | 379400.0 |
| 2005-01-10 | AAA | ETF | 59.08 | 59.57 | 59.08 | 59.37 | 3300.0 |
| 2005-01-10 | ADRE | ETF | 81.98 | 81.98 | 79.175 | 79.175 | 6132.0 |
| 2005-01-10 | AFK | ETF | 26.5 | 26.5 | 26.42 | 26.48 | 3700.0 |
| 2005-01-10 | AGG | ETF | 102.32 | 102.32 | 102.1 | 102.25 | 69500.0 |
| 2005-01-10 | AIQ | ETF | 58.25 | 61.5 | 57.5 | 61.35 | 85540.0 |
| 2005-01-10 | ARB | ETF | 37.1 | 37.32 | 36.82 | 36.92 | 284900.0 |
| 2005-01-10 | BAB | ETF | 47.34 | 47.34 | 46.64 | 47.01 | 62200.0 |
| 2005-01-10 | BBH | ETF | 50.25 | 51.0933 | 50.18 | 50.4 | 1960800.0 |
| 2005-01-10 | BCM | ETF | 57.79 | 58.37 | 57.65 | 58.3 | 20000.0 |
| 2005-01-10 | BIS | ETF | 969.6 | 969.6 | 960.0 | 960.0 | 14.4 |
| 2005-01-10 | BITS | ETF | 9.32 | 9.92 | 9.24 | 9.668 | 23860.0 |
| 2005-01-10 | BKF | ETF | 36.2 | 36.44 | 36.06 | 36.14 | 21700.0 |
| 2005-01-10 | BNE | ETF | 15.0 | 15.39 | 15.0 | 15.19 | 165200.0 |
| 2005-01-10 | BRF | ETF | 15.77 | 15.77 | 15.66 | 15.66 | 9300.0 |
| 2005-01-10 | BTF | ETF | 90.19999999999999 | 90.5 | 89.8 | 90.0 | 1380.0 |
| 2005-01-10 | CBON | ETF | 28.28 | 29.64 | 28.2 | 28.93 | 35846.0 |
| 2005-01-10 | CDC | ETF | 11.35 | 11.35 | 10.95 | 11.0 | 14000.0 |
| 2005-01-10 | CDL | ETF | 14.92 | 14.92 | 14.64 | 14.65 | 626600.0 |
| 2005-01-10 | CEF | ETF | 5.1 | 5.25 | 5.1 | 5.25 | 621700.0 |
| 2005-01-10 | CEW | ETF | 27.32 | 27.32 | 27.32 | 27.32 | 200.0 |
| 2005-01-10 | CGW | ETF | 30.3 | 30.3 | 30.1 | 30.1 | 400.0 |
| 2005-01-10 | CHB | ETF | 11.46 | 11.8 | 11.4 | 11.61 | 381500.0 |
| 2005-01-10 | CHIC | ETF | 10.15 | 10.15 | 9.85 | 9.86 | 804406.0 |
| 2005-01-10 | CHIR | ETF | 35.5401 | 35.7201 | 35.0199 | 35.2899 | 2041426.0 |
| 2005-01-10 | CID | ETF | 9.49 | 9.52 | 9.49 | 9.52 | 300.0 |
| 2005-01-10 | CIZ | ETF | 20.65 | 20.65 | 20.65 | 20.65 | 200.0 |
| 2005-01-10 | CN | ETF | 28.4 | 28.68 | 28.33 | 28.61 | 339400.0 |
| 2005-01-10 | CNXT | ETF | 1.74 | 1.75 | 1.66 | 1.67 | 5026853.0 |
| 2005-01-10 | CPI | ETF | 18.2 | 18.2 | 18.2 | 18.2 | 200.0 |
| 2005-01-10 | CSB | ETF | 36.3 | 36.3 | 36.15 | 36.18 | 2800.0 |
| 2005-01-10 | CTEC | ETF | 40.65 | 42.35 | 40.599999999999994 | 42.35 | 6153.6 |
| 2005-01-10 | CURE | ETF | 0.7338 | 0.78 | 0.7137 | 0.755 | 2834296.0 |
| 2005-01-10 | CYA | ETF | 230.0 | 235.0 | 225.6 | 227.0 | 1030.0 |
| 2005-01-10 | CYB | ETF | 4.34 | 4.41 | 4.34 | 4.41 | 6300.0 |
| 2005-01-10 | CZA | ETF | 10.55 | 10.55 | 10.46 | 10.46 | 2300.0 |
| 2005-01-10 | DGT | ETF | 63.36 | 63.7 | 63.36 | 63.41 | 3100.0 |
| 2005-01-10 | DIG | ETF | 11.8875 | 11.8875 | 11.8875 | 11.8875 | 160.0 |
| 2005-01-10 | DIV | ETF | 14.3 | 14.35 | 14.17 | 14.25 | 21800.0 |
| 2005-01-10 | DJP | ETF | 26.74 | 26.74 | 26.7 | 26.7 | 6200.0 |
| 2005-01-10 | DRIV | ETF | 33.48 | 34.6 | 33.04 | 34.1 | 1938200.0 |
| 2005-01-10 | DSI | ETF | 5.965 | 5.965 | 5.935 | 5.935 | 1600.0 |
| 2005-01-10 | DTH | ETF | 25.25 | 25.25 | 25.18 | 25.18 | 1400.0 |
| 2005-01-10 | DUSA | ETF | 14.39 | 14.56 | 14.25 | 14.34 | 61340.0 |
| 2005-01-10 | DVY | ETF | 59.9 | 60.01 | 59.56 | 59.78 | 496400.0 |
> showing 50 of 253 rows — these rows as CSV