PREVIEW / etf_daily / 2006-03-21
file: by_date/etf_daily/2006/2006-03-21.parquet size: 16 KB rows: 315
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-03-21 | SPY | ETF | 130.37 | 130.99 | 129.45 | 129.59 | 87102700.0 |
| 2006-03-21 | QQQ | ETF | 41.51 | 42.01 | 41.08 | 41.11 | 136565994.0 |
| 2006-03-21 | IWM | ETF | 74.0 | 74.6 | 73.0 | 73.0 | 44425900.0 |
| 2006-03-21 | DIA | ETF | 112.75 | 113.27 | 112.09 | 112.31 | 8855200.0 |
| 2006-03-21 | GLD | ETF | 54.71 | 55.28 | 54.4 | 54.83 | 4518900.0 |
| 2006-03-21 | TLT | ETF | 89.15 | 89.15 | 88.36 | 88.53 | 817200.0 |
| 2006-03-21 | AAA | ETF | 59.61 | 60.12 | 59.61 | 60.12 | 2800.0 |
| 2006-03-21 | ADRE | ETF | 129.12 | 129.12 | 125.25 | 126.5235 | 205460.0 |
| 2006-03-21 | AFK | ETF | 25.18 | 25.18 | 25.11 | 25.17 | 3200.0 |
| 2006-03-21 | AGG | ETF | 99.58 | 99.65 | 99.23 | 99.3 | 165400.0 |
| 2006-03-21 | AIQ | ETF | 33.25 | 33.5 | 32.5 | 32.7 | 26500.0 |
| 2006-03-21 | AIS | ETF | 1.8 | 1.8 | 1.59 | 1.73 | 1041400.0 |
| 2006-03-21 | AOM | ETF | 6.75 | 6.76 | 6.6 | 6.62 | 95200.0 |
| 2006-03-21 | ARB | ETF | 34.3 | 34.38 | 34.0 | 34.16 | 445000.0 |
| 2006-03-21 | BAB | ETF | 63.71 | 63.71 | 62.75 | 62.88 | 38900.0 |
| 2006-03-21 | BBC | ETF | 18.15 | 18.15 | 17.15 | 17.849 | 286700.0 |
| 2006-03-21 | BBH | ETF | 66.3633 | 66.4367 | 65.1733 | 65.2733 | 3055500.0 |
| 2006-03-21 | BCM | ETF | 72.9 | 73.1 | 72.43 | 72.54 | 15100.0 |
| 2006-03-21 | BITS | ETF | 32.8 | 33.0 | 29.2 | 30.68 | 40278.0 |
| 2006-03-21 | BKF | ETF | 12.73 | 13.0 | 12.71 | 12.78 | 67000.0 |
| 2006-03-21 | BNE | ETF | 15.9 | 15.98 | 15.41 | 15.42 | 171500.0 |
| 2006-03-21 | BRF | ETF | 14.27 | 14.28 | 14.26 | 14.28 | 3900.0 |
| 2006-03-21 | BTF | ETF | 88.9995 | 89.04999999999998 | 88.6 | 89.04999999999998 | 1940.0 |
| 2006-03-21 | CBON | ETF | 31.36 | 32.0 | 30.95 | 31.0 | 9170.0 |
| 2006-03-21 | CDL | ETF | 11.49 | 11.51 | 11.32 | 11.33 | 287000.0 |
| 2006-03-21 | CEF | ETF | 7.7 | 7.8 | 7.57 | 7.67 | 415800.0 |
| 2006-03-21 | CEW | ETF | 25.52 | 25.52 | 25.48 | 25.48 | 300.0 |
| 2006-03-21 | CFO | ETF | 9.8 | 9.9 | 9.66 | 9.7 | 6500.0 |
| 2006-03-21 | CGO | ETF | 14.43 | 14.49 | 14.34 | 14.37 | 31800.0 |
| 2006-03-21 | CHB | ETF | 15.69 | 15.71 | 15.03 | 15.05 | 550900.0 |
| 2006-03-21 | CHI | ETF | 20.66 | 20.92 | 20.66 | 20.81 | 144600.0 |
| 2006-03-21 | CHIC | ETF | 18.63 | 18.64 | 17.97 | 18.04 | 566419.0 |
| 2006-03-21 | CHIR | ETF | 45.5001 | 45.9801 | 45.5001 | 45.69 | 1014642.0 |
| 2006-03-21 | CHY | ETF | 16.45 | 16.56 | 16.4384 | 16.53 | 115100.0 |
| 2006-03-21 | CIL | ETF | 25.64 | 25.68 | 25.6 | 25.6 | 1400.0 |
| 2006-03-21 | CN | ETF | 36.4 | 37.2 | 35.75 | 35.87 | 108900.0 |
| 2006-03-21 | CNXT | ETF | 3.195 | 3.34 | 3.17 | 3.21 | 27318844.0 |
| 2006-03-21 | COMB | ETF | 8.3 | 8.5 | 8.3 | 8.5 | 2705.0 |
| 2006-03-21 | CPST | ETF | 3.33 | 3.44 | 3.25 | 3.3 | 3451447.0 |
| 2006-03-21 | CSA | ETF | 21.3 | 21.8 | 21.21 | 21.46 | 67900.0 |
| 2006-03-21 | CSB | ETF | 31.01 | 31.0499 | 30.85 | 30.85 | 7800.0 |
| 2006-03-21 | CSM | ETF | 2.485 | 2.485 | 2.485 | 2.485 | 8000.0 |
| 2006-03-21 | CSQ | ETF | 14.14 | 14.21 | 14.1 | 14.2 | 348100.0 |
| 2006-03-21 | CTEC | ETF | 59.3 | 60.0 | 58.75 | 59.199999999999996 | 8463.2 |
| 2006-03-21 | CYB | ETF | 6.25 | 6.25 | 6.05 | 6.05 | 13200.0 |
| 2006-03-21 | DBC | ETF | 22.8 | 23.04 | 22.65 | 22.92 | 412200.0 |
| 2006-03-21 | DGT | ETF | 67.65 | 68.06 | 67.38 | 67.38 | 6600.0 |
| 2006-03-21 | DIG | ETF | 17.2125 | 17.375 | 17.1 | 17.375 | 2720.0 |
| 2006-03-21 | DIV | ETF | 12.53 | 12.62 | 12.5 | 12.5 | 19300.0 |
| 2006-03-21 | DRIV | ETF | 45.08 | 46.08 | 43.27 | 43.48 | 3185904.0 |
> showing 50 of 315 rows — these rows as CSV