PREVIEW / etf_daily / 2007-04-12
file: by_date/etf_daily/2007/2007-04-12.parquet size: 21 KB rows: 448
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-04-12 | SPY | ETF | 143.74 | 144.92 | 143.34 | 144.66 | 115534400.0 |
| 2007-04-12 | QQQ | ETF | 44.135 | 44.62 | 43.95 | 44.56 | 114841402.0 |
| 2007-04-12 | IWM | ETF | 80.09 | 80.92 | 79.67 | 80.84 | 45075400.0 |
| 2007-04-12 | DIA | ETF | 124.75 | 125.54 | 124.26 | 125.41 | 5984200.0 |
| 2007-04-12 | GLD | ETF | 67.06 | 67.25 | 66.48 | 66.99 | 6021900.0 |
| 2007-04-12 | TLT | ETF | 87.5 | 87.57 | 87.28 | 87.39 | 495100.0 |
| 2007-04-12 | AAA | ETF | 66.92 | 67.2 | 66.865 | 67.2 | 14000.0 |
| 2007-04-12 | ADRE | ETF | 40.83 | 41.37 | 40.56 | 41.37 | 174335.0 |
| 2007-04-12 | AGG | ETF | 99.65 | 99.83 | 99.63 | 99.75 | 274100.0 |
| 2007-04-12 | AIQ | ETF | 46.25 | 46.5 | 45.85 | 46.2 | 19360.0 |
| 2007-04-12 | AIS | ETF | 1.5 | 1.5 | 1.44 | 1.45 | 289600.0 |
| 2007-04-12 | ARB | ETF | 47.35 | 48.49 | 46.85 | 48.49 | 116300.0 |
| 2007-04-12 | BAB | ETF | 101.07 | 102.2 | 100.93 | 102.09 | 45100.0 |
| 2007-04-12 | BBH | ETF | 59.1667 | 59.98 | 58.92 | 59.98 | 909900.0 |
| 2007-04-12 | BITS | ETF | 30.4 | 30.76 | 30.36 | 30.6 | 11770.0 |
| 2007-04-12 | BIV | ETF | 75.05 | 75.06 | 74.91 | 74.94 | 6600.0 |
| 2007-04-12 | BLV | ETF | 74.92 | 74.93 | 74.84 | 74.93 | 1900.0 |
| 2007-04-12 | BND | ETF | 75.06 | 75.08 | 74.96 | 75.03 | 78100.0 |
| 2007-04-12 | BNE | ETF | 16.28 | 16.7 | 16.18 | 16.59 | 147500.0 |
| 2007-04-12 | BRF | ETF | 14.52 | 14.52 | 14.48 | 14.48 | 23800.0 |
| 2007-04-12 | BSV | ETF | 75.1 | 75.12 | 75.08 | 75.12 | 41800.0 |
| 2007-04-12 | BTF | ETF | 109.1 | 109.60000000000001 | 109.04999999999998 | 109.60000000000001 | 2880.0 |
| 2007-04-12 | CBON | ETF | 29.41 | 29.61 | 29.15 | 29.46 | 64723.0 |
| 2007-04-12 | CDL | ETF | 9.65 | 9.65 | 9.52 | 9.65 | 290500.0 |
| 2007-04-12 | CEF | ETF | 9.8 | 9.8 | 9.71 | 9.78 | 198600.0 |
| 2007-04-12 | CGO | ETF | 17.32 | 17.39 | 17.29 | 17.39 | 25100.0 |
| 2007-04-12 | CHB | ETF | 9.3 | 10.07 | 9.0 | 10.06 | 3350100.0 |
| 2007-04-12 | CHI | ETF | 20.33 | 20.38 | 20.23 | 20.27 | 63000.0 |
| 2007-04-12 | CHIC | ETF | 29.46 | 30.25 | 29.32 | 29.92 | 535703.0 |
| 2007-04-12 | CHY | ETF | 16.82 | 16.9 | 16.79 | 16.84 | 73300.0 |
| 2007-04-12 | CIL | ETF | 25.77 | 25.77 | 25.77 | 25.77 | 200.0 |
| 2007-04-12 | CN | ETF | 53.0 | 54.5 | 52.71 | 54.24 | 115400.0 |
| 2007-04-12 | CNXT | ETF | 1.44 | 1.46 | 1.42 | 1.45 | 9010941.0 |
| 2007-04-12 | CPI | ETF | 21.59 | 21.59 | 21.32 | 21.32 | 400.0 |
| 2007-04-12 | CPST | ETF | 1.25 | 1.28 | 1.19 | 1.21 | 5445188.0 |
| 2007-04-12 | CSA | ETF | 21.29 | 21.36 | 20.95 | 21.0 | 29600.0 |
| 2007-04-12 | CSB | ETF | 33.07 | 33.4 | 32.99 | 33.28 | 6000.0 |
| 2007-04-12 | CSD | ETF | 27.87 | 28.11 | 27.87 | 28.03 | 15800.0 |
| 2007-04-12 | CSM | ETF | 1.365 | 1.365 | 1.365 | 1.365 | 79600.0 |
| 2007-04-12 | CSQ | ETF | 15.1 | 15.1999 | 15.08 | 15.19 | 346400.0 |
| 2007-04-12 | CTEC | ETF | 86.05 | 86.99999999999999 | 84.89999999999999 | 86.75 | 27112.800000000003 |
| 2007-04-12 | CVY | ETF | 26.9 | 26.94 | 26.79 | 26.94 | 7100.0 |
| 2007-04-12 | CWI | ETF | 25.9533 | 26.24 | 25.9533 | 26.24 | 14850.0 |
| 2007-04-12 | DBA | ETF | 25.49 | 25.55 | 25.1 | 25.49 | 226700.0 |
| 2007-04-12 | DBB | ETF | 26.88 | 27.18 | 26.23 | 26.42 | 27900.0 |
| 2007-04-12 | DBC | ETF | 25.47 | 25.58 | 25.26 | 25.56 | 100400.0 |
| 2007-04-12 | DBE | ETF | 28.02 | 28.21 | 27.68 | 28.21 | 106600.0 |
| 2007-04-12 | DBO | ETF | 26.52 | 26.59 | 26.37 | 26.56 | 48800.0 |
| 2007-04-12 | DBP | ETF | 26.88 | 26.88 | 26.61 | 26.82 | 11300.0 |
| 2007-04-12 | DBS | ETF | 27.26 | 27.34 | 26.9125 | 27.28 | 134900.0 |
> showing 50 of 448 rows — these rows as CSV