PREVIEW / etf_daily / 2005-08-11
file: by_date/etf_daily/2005/2005-08-11.parquet size: 15 KB rows: 277
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-08-11 | SPY | ETF | 123.27 | 124.03 | 123.01 | 123.82 | 58570200.0 |
| 2005-08-11 | QQQ | ETF | 39.13 | 39.541 | 39.1 | 39.432 | 93638060.0 |
| 2005-08-11 | IWM | ETF | 65.57 | 66.4 | 65.55 | 66.32 | 22973700.0 |
| 2005-08-11 | DIA | ETF | 106.13 | 107.0 | 106.04 | 106.87 | 5800000.0 |
| 2005-08-11 | GLD | ETF | 43.9 | 44.62 | 43.86 | 44.45 | 2186100.0 |
| 2005-08-11 | TLT | ETF | 92.03 | 92.45 | 91.7 | 92.37 | 881600.0 |
| 2005-08-11 | AAA | ETF | 57.12 | 57.3 | 56.97 | 57.3 | 5800.0 |
| 2005-08-11 | ADRE | ETF | 103.2 | 103.2 | 101.04 | 101.49 | 12424.0 |
| 2005-08-11 | AFK | ETF | 25.65 | 25.7 | 25.62 | 25.62 | 3200.0 |
| 2005-08-11 | AGG | ETF | 101.31 | 101.57 | 101.25 | 101.54 | 126800.0 |
| 2005-08-11 | AIQ | ETF | 45.5 | 46.6 | 45.5 | 46.5 | 21400.0 |
| 2005-08-11 | AIS | ETF | 0.95 | 0.96 | 0.91 | 0.96 | 70700.0 |
| 2005-08-11 | ARB | ETF | 41.43 | 42.03 | 41.43 | 41.98 | 313600.0 |
| 2005-08-11 | BAB | ETF | 53.35 | 53.43 | 52.59 | 52.83 | 35600.0 |
| 2005-08-11 | BBH | ETF | 62.8767 | 63.9 | 62.8567 | 63.8033 | 1609500.0 |
| 2005-08-11 | BCM | ETF | 59.68 | 60.33 | 59.55 | 59.75 | 50400.0 |
| 2005-08-11 | BIS | ETF | 688.0 | 688.0 | 688.0 | 688.0 | 23.75 |
| 2005-08-11 | BITS | ETF | 12.88 | 14.48 | 12.88 | 13.84 | 2845.0 |
| 2005-08-11 | BKF | ETF | 32.69 | 32.69 | 30.95 | 31.2 | 96300.0 |
| 2005-08-11 | BNE | ETF | 13.76 | 13.9 | 13.7 | 13.78 | 220700.0 |
| 2005-08-11 | BRF | ETF | 15.35 | 15.59 | 15.35 | 15.58 | 17600.0 |
| 2005-08-11 | BTF | ETF | 85.6 | 85.99999999999999 | 85.5 | 85.99999999999999 | 2140.0 |
| 2005-08-11 | CBON | ETF | 33.22 | 33.44 | 32.73 | 33.0 | 2072.0 |
| 2005-08-11 | CDC | ETF | 3.9 | 4.3 | 3.8 | 3.8 | 21900.0 |
| 2005-08-11 | CDL | ETF | 13.31 | 13.85 | 13.25 | 13.66 | 428200.0 |
| 2005-08-11 | CEF | ETF | 5.31 | 5.4 | 5.31 | 5.39 | 488000.0 |
| 2005-08-11 | CEW | ETF | 26.69 | 26.69 | 26.69 | 26.69 | 200.0 |
| 2005-08-11 | CHB | ETF | 12.06 | 12.1 | 11.96 | 12.06 | 664500.0 |
| 2005-08-11 | CHI | ETF | 20.65 | 20.65 | 20.45 | 20.45 | 69800.0 |
| 2005-08-11 | CHIC | ETF | 14.71 | 14.72 | 14.3 | 14.47 | 157962.0 |
| 2005-08-11 | CHIR | ETF | 36.3399 | 36.9099 | 36.33 | 36.7599 | 531413.0 |
| 2005-08-11 | CHY | ETF | 16.6 | 16.6 | 16.5 | 16.55 | 84500.0 |
| 2005-08-11 | CIL | ETF | 25.85 | 25.85 | 25.81 | 25.81 | 1900.0 |
| 2005-08-11 | CN | ETF | 35.0 | 35.0 | 34.36 | 34.57 | 36400.0 |
| 2005-08-11 | CNXT | ETF | 1.72 | 1.77 | 1.7 | 1.76 | 3747653.0 |
| 2005-08-11 | CPST | ETF | 3.05 | 3.24 | 3.05 | 3.1 | 1769521.0 |
| 2005-08-11 | CSB | ETF | 31.56 | 31.9 | 31.55 | 31.8 | 8700.0 |
| 2005-08-11 | CSQ | ETF | 14.17 | 14.32 | 14.17 | 14.27 | 316700.0 |
| 2005-08-11 | CTEC | ETF | 54.85 | 55.75 | 54.199999999999996 | 54.699999999999996 | 6201.6 |
| 2005-08-11 | CURE | ETF | 0.2938 | 0.3063 | 0.2875 | 0.3013 | 2119800.0 |
| 2005-08-11 | CYA | ETF | 80.0 | 81.8 | 75.2 | 78.0 | 835.0 |
| 2005-08-11 | CYB | ETF | 3.7 | 3.7 | 3.598 | 3.65 | 2700.0 |
| 2005-08-11 | DGT | ETF | 65.65 | 65.65 | 65.16 | 65.41 | 1300.0 |
| 2005-08-11 | DIG | ETF | 13.225 | 13.225 | 13.225 | 13.225 | 3200.0 |
| 2005-08-11 | DIV | ETF | 13.5 | 13.62 | 13.43 | 13.56 | 21000.0 |
| 2005-08-11 | DRIV | ETF | 37.21 | 38.12 | 37.06 | 37.72 | 899892.0 |
| 2005-08-11 | DUSA | ETF | 10.9 | 11.0 | 10.79 | 10.99 | 145389.0 |
| 2005-08-11 | DVY | ETF | 63.24 | 63.56 | 63.06 | 63.43 | 387400.0 |
| 2005-08-11 | EDEN | ETF | 0.84 | 0.85 | 0.822 | 0.84 | 36699.0 |
| 2005-08-11 | EDV | ETF | 25.69 | 25.79 | 25.67 | 25.7 | 8100.0 |
> showing 50 of 277 rows — these rows as CSV