PREVIEW / etf_daily / 2007-05-10
file: by_date/etf_daily/2007/2007-05-10.parquet size: 22 KB rows: 465
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 |
|---|---|---|---|---|---|---|---|
| 2007-05-10 | SPY | ETF | 150.73 | 151.02 | 149.27 | 149.58 | 153617800.0 |
| 2007-05-10 | QQQ | ETF | 46.67 | 46.78 | 46.07 | 46.19 | 171264643.0 |
| 2007-05-10 | IWM | ETF | 82.32 | 82.42 | 81.25 | 81.6 | 92481400.0 |
| 2007-05-10 | DIA | ETF | 133.19 | 133.43 | 132.21 | 132.5 | 14855800.0 |
| 2007-05-10 | GLD | ETF | 67.04 | 67.11 | 65.8 | 66.0 | 5536000.0 |
| 2007-05-10 | TLT | ETF | 88.4 | 88.59 | 88.31 | 88.5 | 519500.0 |
| 2007-05-10 | AAA | ETF | 69.75 | 71.25 | 69.25 | 70.4 | 114900.0 |
| 2007-05-10 | ADRE | ETF | 42.46 | 42.47 | 41.6 | 41.69 | 121544.0 |
| 2007-05-10 | AGG | ETF | 100.05 | 100.12 | 99.94 | 100.11 | 218200.0 |
| 2007-05-10 | AIQ | ETF | 44.25 | 45.35 | 43.9 | 45.15 | 40380.0 |
| 2007-05-10 | AIS | ETF | 1.68 | 1.68 | 1.61 | 1.65 | 276900.0 |
| 2007-05-10 | ARB | ETF | 48.68 | 48.86 | 48.13 | 48.26 | 148500.0 |
| 2007-05-10 | BAB | ETF | 96.95 | 98.14 | 96.3 | 96.31 | 59200.0 |
| 2007-05-10 | BBH | ETF | 62.0833 | 62.0833 | 60.2833 | 60.3333 | 1411500.0 |
| 2007-05-10 | BITS | ETF | 32.0 | 32.48 | 31.52 | 31.52 | 30211.0 |
| 2007-05-10 | BIV | ETF | 75.32 | 75.41 | 75.3 | 75.41 | 14000.0 |
| 2007-05-10 | BLV | ETF | 75.58 | 75.66 | 75.52 | 75.58 | 39800.0 |
| 2007-05-10 | BMVP | ETF | 18.0333 | 18.0533 | 17.8933 | 17.8967 | 47700.0 |
| 2007-05-10 | BND | ETF | 75.31 | 75.38 | 75.31 | 75.38 | 42000.0 |
| 2007-05-10 | BNE | ETF | 17.25 | 17.98 | 16.97 | 17.21 | 458500.0 |
| 2007-05-10 | BRF | ETF | 14.55 | 14.57 | 14.54 | 14.55 | 30900.0 |
| 2007-05-10 | BSV | ETF | 75.26 | 75.26 | 75.21 | 75.22 | 16000.0 |
| 2007-05-10 | BTF | ETF | 112.10000000000001 | 112.2 | 111.85 | 111.99999999999999 | 360.0 |
| 2007-05-10 | CBON | ETF | 31.1 | 31.12 | 30.25 | 30.26 | 30094.0 |
| 2007-05-10 | CDL | ETF | 8.66 | 8.66 | 8.55 | 8.58 | 763000.0 |
| 2007-05-10 | CEF | ETF | 9.33 | 9.35 | 9.16 | 9.23 | 327500.0 |
| 2007-05-10 | CGO | ETF | 18.04 | 18.1 | 17.97 | 17.98 | 33600.0 |
| 2007-05-10 | CHB | ETF | 11.04 | 11.12 | 10.72 | 11.11 | 2322300.0 |
| 2007-05-10 | CHI | ETF | 20.17 | 20.32 | 20.17 | 20.24 | 57200.0 |
| 2007-05-10 | CHIC | ETF | 26.15 | 27.11 | 25.7 | 25.79 | 702626.0 |
| 2007-05-10 | CHY | ETF | 17.08 | 17.12 | 17.08 | 17.11 | 70600.0 |
| 2007-05-10 | CIL | ETF | 25.86 | 25.86 | 25.86 | 25.86 | 400.0 |
| 2007-05-10 | CN | ETF | 49.1 | 49.34 | 47.8 | 47.92 | 80300.0 |
| 2007-05-10 | CNXT | ETF | 1.54 | 1.54 | 1.46 | 1.48 | 9853974.0 |
| 2007-05-10 | CPI | ETF | 23.71 | 23.71 | 23.65 | 23.65 | 2100.0 |
| 2007-05-10 | CPST | ETF | 0.91 | 0.9102 | 0.86 | 0.8693 | 3983306.0 |
| 2007-05-10 | CSA | ETF | 20.78 | 20.87 | 20.62 | 20.7 | 64500.0 |
| 2007-05-10 | CSB | ETF | 31.77 | 32.55 | 31.63 | 32.22 | 26800.0 |
| 2007-05-10 | CSD | ETF | 29.38 | 29.4 | 29.06 | 29.1 | 35300.0 |
| 2007-05-10 | CSQ | ETF | 15.49 | 15.5 | 15.3 | 15.36 | 387100.0 |
| 2007-05-10 | CTEC | ETF | 94.49999999999999 | 94.74999999999999 | 87.5 | 89.0 | 39580.4 |
| 2007-05-10 | CVY | ETF | 27.91 | 28.02 | 27.73 | 27.73 | 16500.0 |
| 2007-05-10 | CWI | ETF | 26.7533 | 26.8333 | 26.3933 | 26.3933 | 49200.0 |
| 2007-05-10 | CZA | ETF | 26.46 | 26.5 | 26.37 | 26.37 | 4200.0 |
| 2007-05-10 | DBA | ETF | 24.8 | 25.0 | 24.6 | 24.72 | 163100.0 |
| 2007-05-10 | DBB | ETF | 28.15 | 28.36 | 27.92 | 28.14 | 43100.0 |
| 2007-05-10 | DBC | ETF | 25.1 | 25.1099 | 24.86 | 24.98 | 245400.0 |
| 2007-05-10 | DBE | ETF | 27.55 | 27.58 | 27.44 | 27.5 | 45600.0 |
| 2007-05-10 | DBO | ETF | 25.83 | 25.93 | 25.68 | 25.93 | 7700.0 |
| 2007-05-10 | DBP | ETF | 26.42 | 26.49 | 26.08 | 26.11 | 45300.0 |
> showing 50 of 465 rows — these rows as CSV