PREVIEW / etf_daily / 2005-11-10
file: by_date/etf_daily/2005/2005-11-10.parquet size: 15 KB rows: 284
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-11-10 | SPY | ETF | 122.34 | 123.52 | 121.75 | 123.34 | 79048100.0 |
| 2005-11-10 | QQQ | ETF | 40.18 | 40.69 | 39.92 | 40.6 | 120763063.0 |
| 2005-11-10 | IWM | ETF | 65.64 | 66.25 | 64.74 | 66.05 | 34586100.0 |
| 2005-11-10 | DIA | ETF | 105.59 | 106.68 | 105.33 | 106.58 | 7604300.0 |
| 2005-11-10 | GLD | ETF | 46.78 | 46.82 | 46.36 | 46.48 | 810900.0 |
| 2005-11-10 | TLT | ETF | 88.72 | 89.48 | 88.63 | 89.44 | 1695200.0 |
| 2005-11-10 | AAA | ETF | 56.43 | 56.57 | 56.25 | 56.57 | 9800.0 |
| 2005-11-10 | ADRE | ETF | 107.75 | 107.75 | 105.6255 | 106.79 | 85024.0 |
| 2005-11-10 | AFK | ETF | 25.39 | 25.42 | 25.39 | 25.42 | 10600.0 |
| 2005-11-10 | AGG | ETF | 99.74 | 100.02 | 99.54 | 99.99 | 177700.0 |
| 2005-11-10 | AIQ | ETF | 28.75 | 29.8 | 27.5 | 29.0 | 46080.0 |
| 2005-11-10 | AIS | ETF | 1.28 | 1.29 | 1.2 | 1.24 | 124700.0 |
| 2005-11-10 | AOM | ETF | 3.44 | 3.45 | 3.44 | 3.45 | 7600.0 |
| 2005-11-10 | ARB | ETF | 37.91 | 38.07 | 37.28 | 38.0 | 222100.0 |
| 2005-11-10 | BAB | ETF | 54.81 | 55.75 | 54.65 | 55.47 | 31900.0 |
| 2005-11-10 | BBC | ETF | 6.3 | 6.55 | 6.25 | 6.47 | 38800.0 |
| 2005-11-10 | BBH | ETF | 67.3833 | 68.49 | 66.87 | 68.4333 | 1223400.0 |
| 2005-11-10 | BCM | ETF | 62.04 | 62.16 | 61.55 | 61.66 | 38500.0 |
| 2005-11-10 | BITS | ETF | 14.16 | 14.16 | 13.4 | 13.56 | 22304.0 |
| 2005-11-10 | BKF | ETF | 20.95 | 21.55 | 20.8 | 21.1 | 59500.0 |
| 2005-11-10 | BNE | ETF | 15.02 | 15.42 | 14.96 | 15.35 | 107300.0 |
| 2005-11-10 | BRF | ETF | 15.15 | 15.31 | 15.15 | 15.23 | 5300.0 |
| 2005-11-10 | BTF | ETF | 86.8 | 87.65 | 82.35 | 87.2 | 4860.0 |
| 2005-11-10 | CBON | ETF | 32.89 | 33.02 | 32.78 | 33.0 | 3757.0 |
| 2005-11-10 | CDL | ETF | 13.65 | 13.83 | 13.47 | 13.78 | 279600.0 |
| 2005-11-10 | CEF | ETF | 5.8 | 5.8 | 5.7 | 5.74 | 210500.0 |
| 2005-11-10 | CGO | ETF | 15.0 | 15.01 | 15.0 | 15.0 | 36900.0 |
| 2005-11-10 | CHB | ETF | 14.5 | 14.98 | 14.13 | 14.94 | 503700.0 |
| 2005-11-10 | CHI | ETF | 20.2 | 20.36 | 20.2 | 20.26 | 77600.0 |
| 2005-11-10 | CHIC | ETF | 16.89 | 17.36 | 16.62 | 17.27 | 430511.0 |
| 2005-11-10 | CHIR | ETF | 44.0499 | 44.19 | 44.0499 | 44.16 | 2168689.0 |
| 2005-11-10 | CHY | ETF | 16.09 | 16.14 | 16.0 | 16.09 | 85400.0 |
| 2005-11-10 | CN | ETF | 32.87 | 33.1899 | 32.84 | 33.12 | 15000.0 |
| 2005-11-10 | CNXT | ETF | 2.295 | 2.3 | 2.2 | 2.26 | 6376223.0 |
| 2005-11-10 | COMB | ETF | 8.4 | 8.74 | 8.4 | 8.74 | 27100.0 |
| 2005-11-10 | CPI | ETF | 24.35 | 25.1 | 24.35 | 25.1 | 4600.0 |
| 2005-11-10 | CPST | ETF | 2.57 | 2.67 | 2.34 | 2.47 | 4654841.0 |
| 2005-11-10 | CSA | ETF | 17.1 | 17.14 | 17.0 | 17.09 | 26100.0 |
| 2005-11-10 | CSB | ETF | 28.59 | 28.93 | 28.59 | 28.86 | 8500.0 |
| 2005-11-10 | CSM | ETF | 2.435 | 2.435 | 2.435 | 2.435 | 4000.0 |
| 2005-11-10 | CSQ | ETF | 13.21 | 13.26 | 13.11 | 13.18 | 427000.0 |
| 2005-11-10 | CTEC | ETF | 40.4 | 42.4 | 40.3 | 41.449999999999996 | 26430.4 |
| 2005-11-10 | CURE | ETF | 0.075 | 0.0775 | 0.07 | 0.0725 | 828232.0 |
| 2005-11-10 | CYB | ETF | 3.36 | 3.44 | 3.36 | 3.44 | 4400.0 |
| 2005-11-10 | DGT | ETF | 64.15 | 64.46 | 64.15 | 64.46 | 1900.0 |
| 2005-11-10 | DIV | ETF | 12.0 | 12.05 | 11.99 | 12.03 | 11600.0 |
| 2005-11-10 | DRIV | ETF | 26.19 | 26.4 | 25.58 | 25.98 | 1183165.0 |
| 2005-11-10 | DSI | ETF | 5.855 | 5.925 | 5.84 | 5.925 | 5800.0 |
| 2005-11-10 | DUSA | ETF | 10.11 | 10.16 | 9.76 | 9.88 | 92994.0 |
| 2005-11-10 | DVY | ETF | 61.35 | 61.85 | 60.88 | 61.79 | 670200.0 |
> showing 50 of 284 rows — these rows as CSV