PREVIEW / etf_daily / 2007-12-24
file: by_date/etf_daily/2007/2007-12-24.parquet size: 25 KB rows: 550
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 |
|---|---|---|---|---|---|---|---|
| 2007-12-24 | SPY | ETF | 148.82 | 149.48 | 148.48 | 149.23 | 45601400.0 |
| 2007-12-24 | QQQ | ETF | 52.01 | 52.4 | 51.9501 | 52.24 | 34499893.0 |
| 2007-12-24 | IWM | ETF | 78.71 | 79.33 | 78.59 | 79.17 | 29867000.0 |
| 2007-12-24 | DIA | ETF | 134.79 | 135.48 | 134.74 | 135.31 | 3655600.0 |
| 2007-12-24 | GLD | ETF | 80.21 | 80.63 | 80.14 | 80.14 | 2863500.0 |
| 2007-12-24 | TLT | ETF | 91.22 | 91.47 | 91.08 | 91.24 | 550300.0 |
| 2007-12-24 | ADRE | ETF | 55.5 | 56.29 | 55.5 | 56.2 | 211472.0 |
| 2007-12-24 | AGG | ETF | 100.75 | 100.84 | 100.62 | 100.77 | 190700.0 |
| 2007-12-24 | AIA | ETF | 49.27 | 49.27 | 48.98 | 48.99 | 1900.0 |
| 2007-12-24 | AIQ | ETF | 49.35 | 50.7 | 48.3 | 48.55 | 19540.0 |
| 2007-12-24 | AIS | ETF | 1.0 | 1.0 | 0.96 | 0.99 | 149400.0 |
| 2007-12-24 | AIVI | ETF | 72.15 | 72.15 | 70.01 | 70.13 | 47800.0 |
| 2007-12-24 | ARB | ETF | 41.85 | 43.09 | 41.85 | 42.0 | 100946.0 |
| 2007-12-24 | BBH | ETF | 54.43 | 55.13 | 54.4167 | 55.12 | 271800.0 |
| 2007-12-24 | BIL | ETF | 91.88 | 91.88 | 91.8 | 91.86 | 2900.0 |
| 2007-12-24 | BITS | ETF | 24.44 | 24.84 | 24.0 | 24.84 | 4983.0 |
| 2007-12-24 | BIV | ETF | 76.42 | 76.57 | 76.29 | 76.38 | 14700.0 |
| 2007-12-24 | BKF | ETF | 60.85 | 60.85 | 60.01 | 60.28 | 27000.0 |
| 2007-12-24 | BLV | ETF | 75.2 | 75.3 | 75.19 | 75.23 | 4000.0 |
| 2007-12-24 | BMVP | ETF | 17.5167 | 17.68 | 17.5167 | 17.68 | 20508.0 |
| 2007-12-24 | BND | ETF | 76.34 | 76.36 | 76.19 | 76.27 | 91000.0 |
| 2007-12-24 | BNE | ETF | 18.29 | 18.59 | 18.29 | 18.55 | 41000.0 |
| 2007-12-24 | BRF | ETF | 14.66 | 14.66 | 14.64 | 14.66 | 5300.0 |
| 2007-12-24 | BSV | ETF | 76.5 | 76.75 | 76.5 | 76.65 | 26300.0 |
| 2007-12-24 | BTF | ETF | 110.19999999999999 | 110.5 | 110.05 | 110.5 | 2260.0 |
| 2007-12-24 | BWX | ETF | 26.31 | 26.33 | 26.25 | 26.325 | 53200.0 |
| 2007-12-24 | CBON | ETF | 18.16 | 18.3999 | 17.98 | 18.03 | 58819.0 |
| 2007-12-24 | CDL | ETF | 2.1 | 2.24 | 2.1 | 2.18 | 816952.0 |
| 2007-12-24 | CEF | ETF | 10.64 | 10.73 | 10.38 | 10.6 | 319300.0 |
| 2007-12-24 | CGO | ETF | 18.9 | 19.81 | 18.9 | 19.57 | 7600.0 |
| 2007-12-24 | CGW | ETF | 25.86 | 26.06 | 25.75 | 25.95 | 57104.0 |
| 2007-12-24 | CHB | ETF | 9.55 | 10.19 | 9.36 | 10.02 | 895074.0 |
| 2007-12-24 | CHI | ETF | 14.4 | 15.17 | 14.4 | 15.13 | 222296.0 |
| 2007-12-24 | CHIC | ETF | 15.63 | 15.96 | 15.5 | 15.95 | 196267.0 |
| 2007-12-24 | CHW | ETF | 12.19 | 12.75 | 12.19 | 12.73 | 165100.0 |
| 2007-12-24 | CHY | ETF | 12.99 | 13.25 | 12.95 | 13.22 | 244400.0 |
| 2007-12-24 | CMF | ETF | 51.92 | 51.92 | 51.905 | 51.905 | 2600.0 |
| 2007-12-24 | CN | ETF | 60.78 | 60.78 | 59.85 | 60.53 | 138834.0 |
| 2007-12-24 | CNXT | ETF | 0.89 | 0.93 | 0.883 | 0.93 | 2411312.0 |
| 2007-12-24 | COW | ETF | 47.6 | 47.6001 | 47.35 | 47.35 | 1600.0 |
| 2007-12-24 | CPST | ETF | 1.58 | 1.6 | 1.54 | 1.55 | 1318348.0 |
| 2007-12-24 | CSA | ETF | 16.02 | 16.21 | 15.98 | 16.21 | 11000.0 |
| 2007-12-24 | CSD | ETF | 27.39 | 27.44 | 27.32 | 27.38 | 8400.0 |
| 2007-12-24 | CSQ | ETF | 14.16 | 14.33 | 14.12 | 14.31 | 392383.0 |
| 2007-12-24 | CUT | ETF | 24.4 | 24.45 | 24.22 | 24.3 | 10400.0 |
| 2007-12-24 | CVY | ETF | 23.89 | 24.06 | 23.77 | 24.06 | 64500.0 |
| 2007-12-24 | CWI | ETF | 27.0667 | 27.6267 | 27.0667 | 27.5667 | 35400.0 |
| 2007-12-24 | CZA | ETF | 26.18 | 26.18 | 26.17 | 26.17 | 2100.0 |
| 2007-12-24 | DBA | ETF | 33.19 | 33.26 | 32.82 | 33.26 | 796800.0 |
| 2007-12-24 | DBB | ETF | 22.19 | 22.57 | 22.08 | 22.36 | 24500.0 |
> showing 50 of 550 rows — these rows as CSV