PREVIEW / etf_daily / 2006-10-18
file: by_date/etf_daily/2006/2006-10-18.parquet size: 19 KB rows: 376
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 |
|---|---|---|---|---|---|---|---|
| 2006-10-18 | SPY | ETF | 137.04 | 137.37 | 136.1 | 136.59 | 86848600.0 |
| 2006-10-18 | QQQ | ETF | 42.22 | 42.31 | 41.65 | 41.8 | 121161120.0 |
| 2006-10-18 | IWM | ETF | 76.52 | 76.8 | 75.6 | 75.98 | 44694800.0 |
| 2006-10-18 | DIA | ETF | 120.17 | 120.49 | 119.5 | 119.9 | 8739600.0 |
| 2006-10-18 | GLD | ETF | 58.82 | 59.03 | 58.26 | 58.59 | 3679000.0 |
| 2006-10-18 | TLT | ETF | 87.69 | 87.88 | 87.55 | 87.8 | 499600.0 |
| 2006-10-18 | AAA | ETF | 54.14 | 54.19 | 53.9501 | 54.15 | 4100.0 |
| 2006-10-18 | ADRE | ETF | 33.95 | 34.337 | 33.86 | 33.96 | 173130.0 |
| 2006-10-18 | AGG | ETF | 99.42 | 99.55 | 99.36 | 99.52 | 304700.0 |
| 2006-10-18 | AIQ | ETF | 41.45 | 41.75 | 40.5 | 40.6 | 26480.0 |
| 2006-10-18 | AIS | ETF | 1.19 | 1.2299 | 1.14 | 1.18 | 166500.0 |
| 2006-10-18 | ARB | ETF | 39.28 | 39.42 | 38.69 | 38.93 | 158200.0 |
| 2006-10-18 | BAB | ETF | 83.38 | 83.79 | 83.13 | 83.55 | 222000.0 |
| 2006-10-18 | BBC | ETF | 9.0 | 10.62 | 8.95 | 10.44 | 1134900.0 |
| 2006-10-18 | BBH | ETF | 62.3367 | 63.76 | 62.3367 | 62.9867 | 479400.0 |
| 2006-10-18 | BITS | ETF | 41.96 | 44.8 | 38.8 | 39.24 | 203855.0 |
| 2006-10-18 | BNE | ETF | 15.57 | 15.79 | 15.36 | 15.6 | 165900.0 |
| 2006-10-18 | BRF | ETF | 14.22 | 14.33 | 14.21 | 14.28 | 9900.0 |
| 2006-10-18 | BTF | ETF | 100.6 | 100.6 | 100.25 | 100.35 | 700.0 |
| 2006-10-18 | CBON | ETF | 33.0 | 33.0 | 30.42 | 30.96 | 312941.0 |
| 2006-10-18 | CDL | ETF | 9.7 | 9.84 | 9.68 | 9.7 | 173200.0 |
| 2006-10-18 | CEF | ETF | 8.37 | 8.45 | 8.34 | 8.39 | 185300.0 |
| 2006-10-18 | CEW | ETF | 25.4 | 25.42 | 25.4 | 25.42 | 400.0 |
| 2006-10-18 | CGO | ETF | 15.68 | 15.8 | 15.56 | 15.66 | 27800.0 |
| 2006-10-18 | CHB | ETF | 7.83 | 8.0 | 7.73 | 7.77 | 1267200.0 |
| 2006-10-18 | CHI | ETF | 19.22 | 19.33 | 19.21 | 19.23 | 151100.0 |
| 2006-10-18 | CHIC | ETF | 28.5 | 28.79 | 27.89 | 28.21 | 230492.0 |
| 2006-10-18 | CHY | ETF | 16.89 | 16.97 | 16.84 | 16.86 | 118400.0 |
| 2006-10-18 | CIZ | ETF | 22.6 | 22.65 | 22.6 | 22.65 | 1200.0 |
| 2006-10-18 | CN | ETF | 35.97 | 36.03 | 35.76 | 35.94 | 42400.0 |
| 2006-10-18 | CNXT | ETF | 2.05 | 2.08 | 1.99 | 2.01 | 14644195.0 |
| 2006-10-18 | COMB | ETF | 10.41 | 10.4535 | 10.4 | 10.42 | 15200.0 |
| 2006-10-18 | CPST | ETF | 1.69 | 1.73 | 1.55 | 1.56 | 1524700.0 |
| 2006-10-18 | CSA | ETF | 21.65 | 21.74 | 21.6 | 21.74 | 16500.0 |
| 2006-10-18 | CSB | ETF | 29.69 | 29.718 | 29.5 | 29.55 | 4900.0 |
| 2006-10-18 | CSQ | ETF | 14.93 | 14.94 | 14.85 | 14.93 | 518900.0 |
| 2006-10-18 | CTEC | ETF | 62.05 | 62.99999999999999 | 62.0 | 62.75 | 18501.2 |
| 2006-10-18 | CVY | ETF | 25.85 | 25.88 | 25.7 | 25.75 | 20800.0 |
| 2006-10-18 | CYB | ETF | 7.5 | 7.5 | 7.35 | 7.38 | 69000.0 |
| 2006-10-18 | DBC | ETF | 24.35 | 24.48 | 23.8 | 23.99 | 345300.0 |
| 2006-10-18 | DBV | ETF | 25.65 | 25.67 | 25.56 | 25.63 | 30000.0 |
| 2006-10-18 | DDM | ETF | 6.9842 | 6.9842 | 6.8775 | 6.9208 | 1030800.0 |
| 2006-10-18 | DES | ETF | 18.62 | 18.7 | 18.56 | 18.5867 | 33900.0 |
| 2006-10-18 | DEW | ETF | 56.88 | 56.88 | 56.64 | 56.64 | 3800.0 |
| 2006-10-18 | DFE | ETF | 57.2 | 57.2 | 57.12 | 57.18 | 3200.0 |
| 2006-10-18 | DFJ | ETF | 49.3 | 49.54 | 49.19 | 49.44 | 19600.0 |
| 2006-10-18 | DGT | ETF | 73.2 | 73.27 | 72.7 | 72.83 | 32300.0 |
| 2006-10-18 | DHS | ETF | 55.95 | 55.95 | 55.65 | 55.85 | 11900.0 |
| 2006-10-18 | DIM | ETF | 57.6 | 57.7 | 57.44 | 57.54 | 8300.0 |
| 2006-10-18 | DIV | ETF | 12.81 | 12.91 | 12.81 | 12.91 | 40500.0 |
> showing 50 of 376 rows — these rows as CSV