PREVIEW / etf_daily / 2005-06-15
file: by_date/etf_daily/2005/2005-06-15.parquet size: 14 KB rows: 263
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 |
|---|---|---|---|---|---|---|---|
| 2005-06-15 | SPY | ETF | 121.16 | 121.24 | 120.23 | 121.09 | 53195600.0 |
| 2005-06-15 | QQQ | ETF | 37.83 | 37.87 | 37.25 | 37.7 | 104082266.0 |
| 2005-06-15 | IWM | ETF | 63.43 | 63.48 | 62.64 | 63.44 | 20371900.0 |
| 2005-06-15 | DIA | ETF | 105.87 | 105.92 | 104.99 | 105.74 | 6118100.0 |
| 2005-06-15 | GLD | ETF | 42.69 | 42.89 | 42.67 | 42.74 | 2311400.0 |
| 2005-06-15 | TLT | ETF | 93.39 | 93.87 | 93.33 | 93.87 | 1996800.0 |
| 2005-06-15 | AAA | ETF | 57.72 | 57.72 | 57.27 | 57.552 | 11500.0 |
| 2005-06-15 | ADRE | ETF | 89.61 | 90.8199 | 89.61 | 90.8199 | 1396.0 |
| 2005-06-15 | AFK | ETF | 26.1 | 26.1 | 25.9 | 25.95 | 5400.0 |
| 2005-06-15 | AGG | ETF | 102.37 | 102.43 | 102.2 | 102.32 | 105800.0 |
| 2005-06-15 | AIQ | ETF | 52.05 | 52.5 | 50.75 | 50.75 | 38840.0 |
| 2005-06-15 | AIS | ETF | 0.92 | 0.95 | 0.87 | 0.92 | 111800.0 |
| 2005-06-15 | ARB | ETF | 42.5 | 44.0 | 42.4 | 43.86 | 876200.0 |
| 2005-06-15 | BAB | ETF | 50.72 | 50.86 | 50.08 | 50.28 | 24900.0 |
| 2005-06-15 | BBH | ETF | 55.9067 | 55.9067 | 55.2333 | 55.5433 | 2058000.0 |
| 2005-06-15 | BCM | ETF | 59.99 | 60.69 | 59.83 | 60.4 | 17900.0 |
| 2005-06-15 | BIS | ETF | 600.0 | 616.0 | 592.0 | 614.4 | 60.5 |
| 2005-06-15 | BITS | ETF | 12.64 | 13.36 | 12.64 | 13.04 | 15708.0 |
| 2005-06-15 | BKF | ETF | 38.3 | 38.59 | 38.3 | 38.47 | 68300.0 |
| 2005-06-15 | BNE | ETF | 13.97 | 14.0 | 13.79 | 14.0 | 107900.0 |
| 2005-06-15 | BRF | ETF | 15.45 | 15.5 | 15.37 | 15.37 | 11700.0 |
| 2005-06-15 | BTF | ETF | 86.3 | 86.69999999999999 | 85.95 | 86.05499999999999 | 2960.0 |
| 2005-06-15 | CBON | ETF | 28.6 | 29.65 | 28.6 | 29.29 | 40533.0 |
| 2005-06-15 | CDC | ETF | 7.62 | 7.63 | 7.0 | 7.2 | 12400.0 |
| 2005-06-15 | CDL | ETF | 12.15 | 12.15 | 11.92 | 12.0 | 186900.0 |
| 2005-06-15 | CEF | ETF | 5.32 | 5.34 | 5.29 | 5.34 | 309700.0 |
| 2005-06-15 | CEW | ETF | 26.56 | 26.56 | 26.56 | 26.56 | 100.0 |
| 2005-06-15 | CGW | ETF | 27.8 | 27.94 | 27.8 | 27.8 | 6200.0 |
| 2005-06-15 | CHB | ETF | 10.3 | 10.32 | 10.11 | 10.25 | 646900.0 |
| 2005-06-15 | CHI | ETF | 19.38 | 19.47 | 19.22 | 19.45 | 109900.0 |
| 2005-06-15 | CHIC | ETF | 12.59 | 12.71 | 12.47 | 12.69 | 77456.0 |
| 2005-06-15 | CHIR | ETF | 35.43 | 37.5 | 33.9999 | 35.4699 | 6422597.0 |
| 2005-06-15 | CHY | ETF | 15.98 | 15.99 | 15.9 | 15.98 | 114600.0 |
| 2005-06-15 | CN | ETF | 26.5 | 26.69 | 26.43 | 26.69 | 62900.0 |
| 2005-06-15 | CNXT | ETF | 1.48 | 1.49 | 1.4 | 1.45 | 5894975.0 |
| 2005-06-15 | CPI | ETF | 23.8 | 23.9 | 23.8 | 23.9 | 300.0 |
| 2005-06-15 | CPST | ETF | 1.15 | 1.15 | 1.06 | 1.09 | 2120984.0 |
| 2005-06-15 | CSB | ETF | 30.51 | 30.56 | 30.45 | 30.53 | 10400.0 |
| 2005-06-15 | CSQ | ETF | 13.82 | 13.87 | 13.76 | 13.84 | 347600.0 |
| 2005-06-15 | CTEC | ETF | 47.8 | 49.800000000000004 | 47.5 | 49.0 | 13248.6 |
| 2005-06-15 | CURE | ETF | 0.2762 | 0.28 | 0.265 | 0.2712 | 618568.0 |
| 2005-06-15 | CYA | ETF | 161.0 | 161.0 | 155.2 | 155.4 | 345.0 |
| 2005-06-15 | CYB | ETF | 2.92 | 2.93 | 2.9 | 2.9 | 2700.0 |
| 2005-06-15 | DGT | ETF | 64.4 | 64.4 | 64.4 | 64.4 | 2700.0 |
| 2005-06-15 | DIG | ETF | 11.9 | 11.9 | 11.9 | 11.9 | 400.0 |
| 2005-06-15 | DIV | ETF | 13.75 | 13.8 | 13.7 | 13.79 | 14000.0 |
| 2005-06-15 | DRIV | ETF | 28.89 | 29.23 | 28.25 | 28.75 | 572059.0 |
| 2005-06-15 | DUSA | ETF | 10.33 | 10.4 | 9.99 | 10.11 | 116316.0 |
| 2005-06-15 | DVY | ETF | 62.37 | 62.43 | 61.9 | 62.4 | 324100.0 |
| 2005-06-15 | EDEN | ETF | 0.63 | 0.76 | 0.63 | 0.64 | 72716.0 |
> showing 50 of 263 rows — these rows as CSV