PREVIEW / etf_daily / 2006-05-05
file: by_date/etf_daily/2006/2006-05-05.parquet size: 17 KB rows: 327
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-05-05 | SPY | ETF | 132.05 | 132.8 | 131.85 | 132.52 | 62588200.0 |
| 2006-05-05 | QQQ | ETF | 42.11 | 42.2101 | 41.94 | 42.16 | 80394384.0 |
| 2006-05-05 | IWM | ETF | 77.52 | 78.02 | 77.32 | 77.52 | 37838800.0 |
| 2006-05-05 | DIA | ETF | 114.86 | 115.83 | 114.78 | 115.63 | 6889900.0 |
| 2006-05-05 | GLD | ETF | 67.51 | 68.01 | 67.06 | 67.99 | 9270900.0 |
| 2006-05-05 | TLT | ETF | 84.0 | 84.08 | 83.49 | 83.6 | 1685900.0 |
| 2006-05-05 | AAA | ETF | 62.31 | 62.98 | 62.2301 | 62.95 | 5100.0 |
| 2006-05-05 | ADRE | ETF | 145.49 | 145.86 | 144.65 | 145.81 | 48860.0 |
| 2006-05-05 | AFK | ETF | 25.18 | 25.22 | 25.15 | 25.18 | 10800.0 |
| 2006-05-05 | AGG | ETF | 98.14 | 98.14 | 97.77 | 97.95 | 128600.0 |
| 2006-05-05 | AIQ | ETF | 34.0 | 34.95 | 30.1 | 30.55 | 108880.0 |
| 2006-05-05 | AIS | ETF | 1.46 | 1.52 | 1.44 | 1.4899 | 410700.0 |
| 2006-05-05 | AOM | ETF | 6.9 | 6.91 | 6.82 | 6.84 | 13200.0 |
| 2006-05-05 | ARB | ETF | 35.29 | 35.65 | 35.01 | 35.4 | 210100.0 |
| 2006-05-05 | BAB | ETF | 62.08 | 62.59 | 61.86 | 62.51 | 19900.0 |
| 2006-05-05 | BBC | ETF | 13.06 | 13.46 | 12.5 | 13.38 | 259400.0 |
| 2006-05-05 | BBH | ETF | 57.3333 | 58.7167 | 57.3333 | 58.6833 | 2351700.0 |
| 2006-05-05 | BCM | ETF | 74.0 | 75.44 | 73.93 | 75.15 | 29300.0 |
| 2006-05-05 | BITS | ETF | 35.64 | 36.72 | 35.48 | 36.04 | 34362.0 |
| 2006-05-05 | BKF | ETF | 9.0 | 9.06 | 8.96 | 9.05 | 51100.0 |
| 2006-05-05 | BNE | ETF | 16.03 | 16.3 | 15.8 | 15.97 | 97500.0 |
| 2006-05-05 | BOSS | ETF | 36.99 | 36.99 | 36.45 | 36.45 | 100.0 |
| 2006-05-05 | BRF | ETF | 14.11 | 14.11 | 14.01 | 14.01 | 3700.0 |
| 2006-05-05 | BTF | ETF | 88.6 | 88.64999999999999 | 88.6 | 88.64999999999999 | 320.0 |
| 2006-05-05 | CBON | ETF | 32.55 | 33.01 | 31.4 | 32.77 | 19533.0 |
| 2006-05-05 | CDL | ETF | 10.35 | 10.96 | 10.3 | 10.35 | 1057700.0 |
| 2006-05-05 | CEF | ETF | 10.2 | 10.21 | 9.86 | 10.19 | 1090600.0 |
| 2006-05-05 | CEW | ETF | 25.55 | 25.55 | 25.55 | 25.55 | 300.0 |
| 2006-05-05 | CFO | ETF | 10.38 | 10.38 | 10.38 | 10.38 | 10000.0 |
| 2006-05-05 | CGO | ETF | 14.52 | 14.54 | 14.42 | 14.54 | 84300.0 |
| 2006-05-05 | CHB | ETF | 16.17 | 16.45 | 15.99 | 16.28 | 572300.0 |
| 2006-05-05 | CHI | ETF | 20.05 | 20.23 | 20.05 | 20.17 | 69700.0 |
| 2006-05-05 | CHIC | ETF | 23.0 | 23.41 | 22.9 | 23.2 | 673629.0 |
| 2006-05-05 | CHY | ETF | 16.0 | 16.12 | 16.0 | 16.1 | 71300.0 |
| 2006-05-05 | CIL | ETF | 25.83 | 25.83 | 25.83 | 25.83 | 100.0 |
| 2006-05-05 | CIZ | ETF | 22.7 | 23.1 | 22.7 | 23.1 | 2200.0 |
| 2006-05-05 | CN | ETF | 38.6 | 38.75 | 38.5 | 38.6 | 32200.0 |
| 2006-05-05 | CNXT | ETF | 3.7 | 3.88 | 3.67 | 3.8 | 63458458.0 |
| 2006-05-05 | COMB | ETF | 10.2 | 10.25 | 10.2 | 10.2 | 13799.0 |
| 2006-05-05 | CPST | ETF | 3.94 | 3.97 | 3.86 | 3.92 | 877355.0 |
| 2006-05-05 | CSA | ETF | 19.42 | 19.58 | 19.0 | 19.15 | 17800.0 |
| 2006-05-05 | CSB | ETF | 31.2 | 31.3 | 31.01 | 31.13 | 9200.0 |
| 2006-05-05 | CSQ | ETF | 13.98 | 14.1 | 13.96 | 14.08 | 276800.0 |
| 2006-05-05 | CTEC | ETF | 63.3 | 63.8 | 62.5 | 63.25 | 5283.0 |
| 2006-05-05 | CYB | ETF | 6.32 | 6.36 | 6.28 | 6.36 | 11000.0 |
| 2006-05-05 | DBC | ETF | 25.63 | 25.77 | 25.5 | 25.7 | 377300.0 |
| 2006-05-05 | DGT | ETF | 69.64 | 69.77 | 69.64 | 69.77 | 1500.0 |
| 2006-05-05 | DIG | ETF | 18.1125 | 18.1125 | 17.875 | 17.875 | 2400.0 |
| 2006-05-05 | DIV | ETF | 12.04 | 12.15 | 12.04 | 12.15 | 15300.0 |
| 2006-05-05 | DRIV | ETF | 46.29 | 46.42 | 45.07 | 45.87 | 771626.0 |
> showing 50 of 327 rows — these rows as CSV