PREVIEW / etf_daily / 2005-06-10
file: by_date/etf_daily/2005/2005-06-10.parquet size: 15 KB rows: 269
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-10 | SPY | ETF | 120.56 | 120.65 | 119.6 | 120.2 | 36465300.0 |
| 2005-06-10 | QQQ | ETF | 37.9 | 37.9 | 37.38 | 37.547 | 86005691.0 |
| 2005-06-10 | IWM | ETF | 62.45 | 62.55 | 62.08 | 62.45 | 19949900.0 |
| 2005-06-10 | DIA | ETF | 105.14 | 105.38 | 104.48 | 105.17 | 5115500.0 |
| 2005-06-10 | GLD | ETF | 42.25 | 42.72 | 42.12 | 42.62 | 1678000.0 |
| 2005-06-10 | TLT | ETF | 95.55 | 95.55 | 94.86 | 94.89 | 1464800.0 |
| 2005-06-10 | AAA | ETF | 58.38 | 58.45 | 57.56 | 57.74 | 3300.0 |
| 2005-06-10 | ADRE | ETF | 89.55 | 89.55 | 89.07 | 89.07 | 2172.0 |
| 2005-06-10 | AFK | ETF | 26.3 | 26.58 | 26.3 | 26.58 | 8200.0 |
| 2005-06-10 | AGG | ETF | 102.86 | 102.86 | 102.52 | 102.6 | 77700.0 |
| 2005-06-10 | AIQ | ETF | 53.35 | 53.75 | 51.25 | 51.6 | 14460.0 |
| 2005-06-10 | AIS | ETF | 0.76 | 0.85 | 0.75 | 0.8 | 227600.0 |
| 2005-06-10 | ARB | ETF | 42.25 | 42.5 | 41.75 | 42.13 | 128000.0 |
| 2005-06-10 | BAB | ETF | 50.99 | 51.1 | 50.52 | 50.74 | 8400.0 |
| 2005-06-10 | BBH | ETF | 56.05 | 56.1233 | 55.6267 | 55.8767 | 602100.0 |
| 2005-06-10 | BCM | ETF | 59.87 | 60.06 | 59.53 | 59.62 | 61500.0 |
| 2005-06-10 | BITS | ETF | 12.0 | 12.48 | 11.92 | 12.48 | 10785.0 |
| 2005-06-10 | BKF | ETF | 37.85 | 38.87 | 37.85 | 38.26 | 55900.0 |
| 2005-06-10 | BNE | ETF | 13.43 | 13.58 | 13.39 | 13.51 | 55300.0 |
| 2005-06-10 | BRF | ETF | 15.49 | 15.51 | 15.45 | 15.51 | 13500.0 |
| 2005-06-10 | BTF | ETF | 85.99999999999999 | 85.99999999999999 | 85.64999999999999 | 85.64999999999999 | 2800.0 |
| 2005-06-10 | CBON | ETF | 28.8 | 28.8 | 28.48 | 28.7 | 21547.0 |
| 2005-06-10 | CDC | ETF | 7.4 | 7.85 | 7.4 | 7.84 | 7400.0 |
| 2005-06-10 | CDL | ETF | 12.18 | 12.25 | 12.06 | 12.09 | 318600.0 |
| 2005-06-10 | CEF | ETF | 5.31 | 5.37 | 5.26 | 5.34 | 404200.0 |
| 2005-06-10 | CEW | ETF | 26.53 | 26.53 | 26.53 | 26.53 | 100.0 |
| 2005-06-10 | CHB | ETF | 10.1 | 10.12 | 9.91 | 10.05 | 698200.0 |
| 2005-06-10 | CHI | ETF | 19.7 | 19.73 | 19.531 | 19.71 | 101600.0 |
| 2005-06-10 | CHIC | ETF | 12.69 | 12.79 | 12.6 | 12.67 | 98180.0 |
| 2005-06-10 | CHIR | ETF | 37.5501 | 37.5699 | 36.84 | 37.0101 | 580671.0 |
| 2005-06-10 | CHY | ETF | 16.21 | 16.21 | 16.091 | 16.2 | 89400.0 |
| 2005-06-10 | CIL | ETF | 25.51 | 25.51 | 25.51 | 25.51 | 200.0 |
| 2005-06-10 | CIZ | ETF | 22.45 | 22.45 | 22.45 | 22.45 | 300.0 |
| 2005-06-10 | CN | ETF | 26.9 | 27.23 | 26.9 | 27.0 | 60000.0 |
| 2005-06-10 | CNXT | ETF | 1.515 | 1.54 | 1.5 | 1.52 | 1706685.0 |
| 2005-06-10 | CPI | ETF | 23.05 | 23.05 | 22.9 | 22.92 | 1600.0 |
| 2005-06-10 | CPST | ETF | 0.99 | 1.06 | 0.98 | 1.01 | 801989.0 |
| 2005-06-10 | CSB | ETF | 31.02 | 31.02 | 30.67 | 30.78 | 12600.0 |
| 2005-06-10 | CSM | ETF | 2.405 | 2.405 | 2.405 | 2.405 | 4000.0 |
| 2005-06-10 | CSQ | ETF | 13.92 | 13.92 | 13.86 | 13.89 | 267700.0 |
| 2005-06-10 | CTEC | ETF | 46.699999999999996 | 47.099999999999994 | 46.39999999999999 | 46.699999999999996 | 4157.0 |
| 2005-06-10 | CURE | ETF | 0.3013 | 0.3013 | 0.2737 | 0.2762 | 1990504.0 |
| 2005-06-10 | CYA | ETF | 166.2 | 166.2 | 153.0 | 154.0 | 620.0 |
| 2005-06-10 | CYB | ETF | 2.9 | 2.99 | 2.9 | 2.99 | 8100.0 |
| 2005-06-10 | CZA | ETF | 10.48 | 10.48 | 10.48 | 10.48 | 400.0 |
| 2005-06-10 | DGT | ETF | 64.1 | 64.1 | 63.81 | 63.85 | 18000.0 |
| 2005-06-10 | DIG | ETF | 11.7375 | 11.7375 | 11.7375 | 11.7375 | 2720.0 |
| 2005-06-10 | DIV | ETF | 13.75 | 13.85 | 13.736 | 13.74 | 10600.0 |
| 2005-06-10 | DRIV | ETF | 28.75 | 29.1 | 28.1 | 28.36 | 528155.0 |
| 2005-06-10 | DUSA | ETF | 10.53 | 10.74 | 10.21 | 10.63 | 64180.0 |
> showing 50 of 269 rows — these rows as CSV