PREVIEW / etf_daily / 2005-10-05
file: by_date/etf_daily/2005/2005-10-05.parquet size: 15 KB rows: 280
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-10-05 | SPY | ETF | 121.25 | 121.31 | 119.57 | 119.63 | 106052100.0 |
| 2005-10-05 | QQQ | ETF | 39.31 | 39.34 | 38.73 | 38.76 | 106227405.0 |
| 2005-10-05 | IWM | ETF | 65.77 | 65.77 | 64.05 | 64.1 | 45606700.0 |
| 2005-10-05 | DIA | ETF | 104.28 | 104.35 | 103.16 | 103.22 | 8901800.0 |
| 2005-10-05 | GLD | ETF | 46.38 | 46.53 | 46.14 | 46.36 | 1692300.0 |
| 2005-10-05 | TLT | ETF | 91.68 | 91.98 | 91.57 | 91.82 | 1215800.0 |
| 2005-10-05 | AAA | ETF | 56.74 | 56.85 | 56.09 | 56.09 | 3400.0 |
| 2005-10-05 | ADRE | ETF | 108.0 | 108.0 | 105.06 | 105.06 | 41724.0 |
| 2005-10-05 | AFK | ETF | 25.44 | 25.6 | 25.44 | 25.51 | 7000.0 |
| 2005-10-05 | AGG | ETF | 101.05 | 101.22 | 100.95 | 101.17 | 608800.0 |
| 2005-10-05 | AIQ | ETF | 41.25 | 41.5 | 40.05 | 40.15 | 11500.0 |
| 2005-10-05 | AIS | ETF | 0.99 | 1.0 | 0.9 | 0.91 | 127300.0 |
| 2005-10-05 | ARB | ETF | 39.02 | 39.02 | 37.8 | 37.81 | 282600.0 |
| 2005-10-05 | BAB | ETF | 52.56 | 53.41 | 52.56 | 53.07 | 64700.0 |
| 2005-10-05 | BBC | ETF | 6.65 | 6.659 | 6.55 | 6.62 | 47100.0 |
| 2005-10-05 | BBH | ETF | 64.0167 | 64.39 | 62.1333 | 62.21 | 3375300.0 |
| 2005-10-05 | BCM | ETF | 61.09 | 61.1 | 60.56 | 60.71 | 296400.0 |
| 2005-10-05 | BIS | ETF | 660.8 | 660.8 | 660.8 | 660.8 | 0.625 |
| 2005-10-05 | BITS | ETF | 11.2 | 11.2 | 10.8 | 10.88 | 4985.0 |
| 2005-10-05 | BKF | ETF | 29.95 | 29.95 | 28.65 | 28.86 | 72500.0 |
| 2005-10-05 | BNE | ETF | 14.18 | 14.18 | 13.97 | 14.0 | 159800.0 |
| 2005-10-05 | BRF | ETF | 15.46 | 15.6 | 15.36 | 15.57 | 16400.0 |
| 2005-10-05 | BTF | ETF | 85.5 | 86.5 | 85.25 | 85.89999999999999 | 13340.0 |
| 2005-10-05 | CBON | ETF | 33.46 | 33.46 | 32.99 | 32.99 | 3552.0 |
| 2005-10-05 | CDC | ETF | 3.75 | 3.88 | 3.75 | 3.85 | 1300.0 |
| 2005-10-05 | CDL | ETF | 13.95 | 13.95 | 13.58 | 13.58 | 304900.0 |
| 2005-10-05 | CEF | ETF | 5.62 | 5.65 | 5.56 | 5.61 | 588100.0 |
| 2005-10-05 | CEW | ETF | 25.9 | 25.9 | 25.9 | 25.9 | 100.0 |
| 2005-10-05 | CHB | ETF | 14.36 | 14.36 | 13.53 | 13.58 | 840300.0 |
| 2005-10-05 | CHI | ETF | 20.01 | 20.05 | 19.91 | 19.92 | 65200.0 |
| 2005-10-05 | CHIC | ETF | 15.93 | 16.04 | 15.32 | 15.43 | 1135187.0 |
| 2005-10-05 | CHIR | ETF | 43.5 | 43.89 | 43.2399 | 43.3101 | 1173280.0 |
| 2005-10-05 | CHY | ETF | 16.36 | 16.44 | 16.2 | 16.25 | 85500.0 |
| 2005-10-05 | CIL | ETF | 25.93 | 25.94 | 25.93 | 25.94 | 1500.0 |
| 2005-10-05 | CN | ETF | 34.9 | 35.0 | 34.11 | 34.11 | 16400.0 |
| 2005-10-05 | CNXT | ETF | 1.9 | 1.9302 | 1.87 | 1.89 | 10332715.0 |
| 2005-10-05 | COMB | ETF | 8.1 | 8.16 | 7.97 | 8.16 | 8036.0 |
| 2005-10-05 | CPI | ETF | 23.75 | 24.0 | 23.75 | 24.0 | 3800.0 |
| 2005-10-05 | CPST | ETF | 3.74 | 3.74 | 3.51 | 3.54 | 3736377.0 |
| 2005-10-05 | CSB | ETF | 29.58 | 29.79 | 29.5 | 29.5 | 20700.0 |
| 2005-10-05 | CSM | ETF | 2.4375 | 2.4375 | 2.4375 | 2.4375 | 3200.0 |
| 2005-10-05 | CSQ | ETF | 13.92 | 13.93 | 13.82 | 13.82 | 202200.0 |
| 2005-10-05 | CTEC | ETF | 50.3 | 50.55 | 49.15 | 49.4 | 11684.400000000001 |
| 2005-10-05 | CURE | ETF | 0.1037 | 0.1425 | 0.09 | 0.0975 | 22102272.0 |
| 2005-10-05 | CYA | ETF | 72.0 | 73.0 | 69.4 | 69.4 | 400.0 |
| 2005-10-05 | CYB | ETF | 3.4001 | 3.46 | 3.4001 | 3.46 | 700.0 |
| 2005-10-05 | DGT | ETF | 64.22 | 64.22 | 64.08 | 64.08 | 900.0 |
| 2005-10-05 | DIG | ETF | 14.5 | 14.5 | 14.35 | 14.35 | 8480.0 |
| 2005-10-05 | DIV | ETF | 13.14 | 13.17 | 12.99 | 13.06 | 34500.0 |
| 2005-10-05 | DRIV | ETF | 34.05 | 34.41 | 32.13 | 32.79 | 2095202.0 |
> showing 50 of 280 rows — these rows as CSV