PREVIEW / etf_daily / 2005-10-12
file: by_date/etf_daily/2005/2005-10-12.parquet size: 15 KB rows: 281
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-10-12 | SPY | ETF | 118.39 | 119.13 | 117.41 | 117.5 | 100510400.0 |
| 2005-10-12 | QQQ | ETF | 37.76 | 38.056 | 37.43 | 37.487 | 146123799.0 |
| 2005-10-12 | IWM | ETF | 62.44 | 62.8 | 61.25 | 61.62 | 63535700.0 |
| 2005-10-12 | DIA | ETF | 102.54 | 103.12 | 101.88 | 102.03 | 16982500.0 |
| 2005-10-12 | GLD | ETF | 47.53 | 47.64 | 46.82 | 46.85 | 3930500.0 |
| 2005-10-12 | TLT | ETF | 91.44 | 91.44 | 90.65 | 90.7 | 1105700.0 |
| 2005-10-12 | AAA | ETF | 55.57 | 55.8 | 55.2701 | 55.54 | 3000.0 |
| 2005-10-12 | ADRE | ETF | 102.5 | 108.49 | 101.1 | 101.6 | 75564.0 |
| 2005-10-12 | AFK | ETF | 25.47 | 25.64 | 25.4 | 25.4 | 3200.0 |
| 2005-10-12 | AGG | ETF | 100.82 | 100.99 | 100.72 | 100.79 | 151000.0 |
| 2005-10-12 | AIQ | ETF | 39.1 | 39.5 | 37.15 | 37.95 | 20560.0 |
| 2005-10-12 | AIS | ETF | 0.97 | 0.99 | 0.91 | 0.95 | 72000.0 |
| 2005-10-12 | ARB | ETF | 37.95 | 38.6 | 37.9 | 38.25 | 235700.0 |
| 2005-10-12 | BAB | ETF | 54.41 | 54.5 | 53.6 | 53.7 | 23200.0 |
| 2005-10-12 | BBC | ETF | 7.0 | 7.0 | 6.65 | 6.8 | 34100.0 |
| 2005-10-12 | BBH | ETF | 62.0167 | 62.0367 | 60.3067 | 60.5467 | 4241400.0 |
| 2005-10-12 | BCM | ETF | 61.25 | 61.45 | 60.79 | 60.87 | 28900.0 |
| 2005-10-12 | BIS | ETF | 585.6 | 585.6 | 582.4 | 582.4 | 53.0 |
| 2005-10-12 | BITS | ETF | 10.76 | 10.76 | 10.68 | 10.684 | 475.0 |
| 2005-10-12 | BKF | ETF | 25.32 | 25.32 | 23.48 | 25.09 | 211300.0 |
| 2005-10-12 | BNE | ETF | 13.26 | 13.47 | 13.22 | 13.33 | 140100.0 |
| 2005-10-12 | BRF | ETF | 15.46 | 15.46 | 15.31 | 15.31 | 6300.0 |
| 2005-10-12 | BTF | ETF | 86.35 | 86.35 | 85.8 | 86.14999999999999 | 5040.0 |
| 2005-10-12 | CBON | ETF | 32.5 | 33.17 | 32.39 | 32.47 | 61805.0 |
| 2005-10-12 | CDC | ETF | 3.97 | 4.056 | 3.97 | 4.02 | 2200.0 |
| 2005-10-12 | CDL | ETF | 14.14 | 14.25 | 13.97 | 13.97 | 645400.0 |
| 2005-10-12 | CEF | ETF | 5.78 | 5.82 | 5.71 | 5.73 | 451000.0 |
| 2005-10-12 | CEW | ETF | 25.98 | 25.98 | 25.98 | 25.98 | 400.0 |
| 2005-10-12 | CHB | ETF | 13.1 | 13.24 | 12.75 | 12.89 | 1031800.0 |
| 2005-10-12 | CHI | ETF | 19.83 | 19.86 | 19.1 | 19.22 | 183800.0 |
| 2005-10-12 | CHIC | ETF | 15.12 | 15.2 | 14.23 | 14.44 | 538757.0 |
| 2005-10-12 | CHIR | ETF | 42.87 | 44.1801 | 42.84 | 43.0401 | 1703169.0 |
| 2005-10-12 | CHY | ETF | 16.0 | 16.06 | 15.55 | 15.63 | 120000.0 |
| 2005-10-12 | CIL | ETF | 25.93 | 26.0 | 25.93 | 26.0 | 1000.0 |
| 2005-10-12 | CN | ETF | 32.55 | 32.562 | 31.78 | 31.81 | 32500.0 |
| 2005-10-12 | CNXT | ETF | 1.8 | 1.8 | 1.74 | 1.78 | 5806412.0 |
| 2005-10-12 | CPST | ETF | 2.83 | 2.84 | 2.66 | 2.69 | 2914695.0 |
| 2005-10-12 | CSB | ETF | 29.25 | 29.26 | 29.1 | 29.19 | 23500.0 |
| 2005-10-12 | CSM | ETF | 2.4375 | 2.4375 | 2.4375 | 2.4375 | 8000.0 |
| 2005-10-12 | CSQ | ETF | 13.74 | 13.74 | 13.31 | 13.39 | 306800.0 |
| 2005-10-12 | CTEC | ETF | 47.699999999999996 | 47.75 | 43.550000000000004 | 45.849999999999994 | 21600.4 |
| 2005-10-12 | CURE | ETF | 0.0938 | 0.1037 | 0.0938 | 0.1025 | 2005344.0 |
| 2005-10-12 | CYA | ETF | 70.0 | 71.598 | 70.0 | 70.0 | 120.0 |
| 2005-10-12 | CYB | ETF | 3.26 | 3.3 | 3.25 | 3.28 | 21800.0 |
| 2005-10-12 | DGT | ETF | 63.46 | 63.46 | 63.15 | 63.3 | 21500.0 |
| 2005-10-12 | DIG | ETF | 14.8125 | 14.8125 | 14.8125 | 14.8125 | 4000.0 |
| 2005-10-12 | DIV | ETF | 12.59 | 12.59 | 12.26 | 12.32 | 27100.0 |
| 2005-10-12 | DRIV | ETF | 33.48 | 33.48 | 32.24 | 32.64 | 563799.0 |
| 2005-10-12 | DSI | ETF | 5.64 | 5.64 | 5.64 | 5.64 | 1800.0 |
| 2005-10-12 | DUSA | ETF | 10.09 | 10.11 | 9.42 | 9.69 | 126558.0 |
> showing 50 of 281 rows — these rows as CSV