PREVIEW / etf_daily / 2006-12-18
file: by_date/etf_daily/2006/2006-12-18.parquet size: 19 KB rows: 388
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-12-18 | SPY | ETF | 142.54 | 142.88 | 141.75 | 141.95 | 48954600.0 |
| 2006-12-18 | QQQ | ETF | 44.58 | 44.75 | 43.8 | 43.99 | 121600589.0 |
| 2006-12-18 | IWM | ETF | 79.06 | 79.21 | 77.63 | 77.91 | 47013800.0 |
| 2006-12-18 | DIA | ETF | 124.31 | 124.63 | 124.03 | 124.22 | 6767800.0 |
| 2006-12-18 | GLD | ETF | 60.85 | 61.11 | 60.65 | 61.04 | 3880800.0 |
| 2006-12-18 | TLT | ETF | 89.72 | 89.84 | 89.59 | 89.76 | 441400.0 |
| 2006-12-18 | AAA | ETF | 60.78 | 60.85 | 60.64 | 60.7 | 1000.0 |
| 2006-12-18 | ADRE | ETF | 38.22 | 38.24 | 37.62 | 37.68 | 83301.0 |
| 2006-12-18 | AGG | ETF | 100.37 | 100.39 | 100.26 | 100.37 | 236000.0 |
| 2006-12-18 | AIQ | ETF | 31.85 | 32.95 | 31.8 | 32.4 | 83640.0 |
| 2006-12-18 | AIS | ETF | 1.13 | 1.28 | 1.13 | 1.18 | 1688700.0 |
| 2006-12-18 | ARB | ETF | 44.28 | 44.58 | 43.77 | 43.94 | 129300.0 |
| 2006-12-18 | BAB | ETF | 102.08 | 102.79 | 101.7 | 101.83 | 44200.0 |
| 2006-12-18 | BBC | ETF | 4.49 | 4.56 | 4.35 | 4.4 | 284200.0 |
| 2006-12-18 | BBH | ETF | 62.05 | 62.35 | 61.45 | 61.8 | 894900.0 |
| 2006-12-18 | BITS | ETF | 33.76 | 34.2 | 33.68 | 33.92 | 19365.0 |
| 2006-12-18 | BNE | ETF | 15.61 | 15.8 | 15.42 | 15.63 | 97500.0 |
| 2006-12-18 | BRF | ETF | 14.28 | 14.3 | 14.26 | 14.28 | 39800.0 |
| 2006-12-18 | BTF | ETF | 113.3 | 114.64999999999999 | 112.3 | 112.35 | 1380.0 |
| 2006-12-18 | CBON | ETF | 30.25 | 30.5 | 29.7 | 29.87 | 64587.0 |
| 2006-12-18 | CDL | ETF | 9.86 | 9.93 | 9.56 | 9.57 | 451500.0 |
| 2006-12-18 | CEF | ETF | 9.16 | 9.17 | 9.02 | 9.07 | 725500.0 |
| 2006-12-18 | CEW | ETF | 25.7 | 25.7 | 25.7 | 25.7 | 300.0 |
| 2006-12-18 | CGO | ETF | 16.85 | 16.92 | 16.59 | 16.7 | 11400.0 |
| 2006-12-18 | CHB | ETF | 9.5 | 9.87 | 9.49 | 9.71 | 1329200.0 |
| 2006-12-18 | CHI | ETF | 20.15 | 20.25 | 20.14 | 20.2 | 76300.0 |
| 2006-12-18 | CHIC | ETF | 32.07 | 32.12 | 31.65 | 31.97 | 354273.0 |
| 2006-12-18 | CHY | ETF | 17.02 | 17.2 | 17.0101 | 17.13 | 119200.0 |
| 2006-12-18 | CIL | ETF | 25.37 | 25.38 | 25.15 | 25.15 | 8700.0 |
| 2006-12-18 | CN | ETF | 49.0 | 49.14 | 47.9 | 48.1 | 79900.0 |
| 2006-12-18 | CNXT | ETF | 2.13 | 2.16 | 2.11 | 2.13 | 5719752.0 |
| 2006-12-18 | CPI | ETF | 23.31 | 23.31 | 23.3 | 23.3 | 200.0 |
| 2006-12-18 | CPST | ETF | 1.3 | 1.32 | 1.26 | 1.27 | 940588.0 |
| 2006-12-18 | CSA | ETF | 20.7 | 20.8 | 19.93 | 20.34 | 61300.0 |
| 2006-12-18 | CSB | ETF | 33.22 | 33.59 | 33.22 | 33.39 | 19500.0 |
| 2006-12-18 | CSD | ETF | 25.18 | 25.2 | 24.88 | 24.88 | 15100.0 |
| 2006-12-18 | CSM | ETF | 1.3275 | 1.3375 | 1.32 | 1.32 | 120800.0 |
| 2006-12-18 | CSQ | ETF | 15.76 | 15.85 | 15.55 | 15.63 | 410600.0 |
| 2006-12-18 | CTEC | ETF | 94.0 | 94.49949999999998 | 91.6 | 91.6 | 9283.4 |
| 2006-12-18 | CVY | ETF | 27.07 | 27.07 | 26.8 | 26.85 | 102100.0 |
| 2006-12-18 | DBC | ETF | 24.63 | 24.66 | 24.25 | 24.47 | 250200.0 |
| 2006-12-18 | DBV | ETF | 25.65 | 26.13 | 25.62 | 25.62 | 927300.0 |
| 2006-12-18 | DDM | ETF | 7.4625 | 7.4933 | 7.4283 | 7.4458 | 921600.0 |
| 2006-12-18 | DEF | ETF | 25.1 | 25.15 | 25.09 | 25.09 | 4800.0 |
| 2006-12-18 | DES | ETF | 19.38 | 19.38 | 19.0567 | 19.0833 | 48000.0 |
| 2006-12-18 | DEW | ETF | 61.78 | 61.81 | 61.44 | 61.44 | 8400.0 |
| 2006-12-18 | DFE | ETF | 64.8 | 64.8 | 64.36 | 64.52 | 12100.0 |
| 2006-12-18 | DFJ | ETF | 51.0 | 51.0 | 50.63 | 50.71 | 29400.0 |
| 2006-12-18 | DGT | ETF | 76.12 | 76.49 | 75.9 | 75.9 | 12900.0 |
| 2006-12-18 | DHS | ETF | 58.2 | 58.29 | 58.07 | 58.08 | 11300.0 |
> showing 50 of 388 rows — these rows as CSV