PREVIEW / etf_daily / 2007-03-30
file: by_date/etf_daily/2007/2007-03-30.parquet size: 21 KB rows: 439
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-03-30 | SPY | ETF | 142.24 | 142.84 | 140.56 | 142.0 | 128194100.0 |
| 2007-03-30 | QQQ | ETF | 43.56 | 43.87 | 43.2215 | 43.53 | 120433969.0 |
| 2007-03-30 | IWM | ETF | 79.36 | 80.06 | 78.73 | 79.45 | 54280000.0 |
| 2007-03-30 | DIA | ETF | 123.37 | 124.06 | 122.33 | 123.59 | 9827200.0 |
| 2007-03-30 | GLD | ETF | 65.74 | 66.21 | 65.49 | 65.74 | 4290200.0 |
| 2007-03-30 | TLT | ETF | 88.65 | 88.92 | 88.22 | 88.28 | 2015100.0 |
| 2007-03-30 | AAA | ETF | 64.66 | 65.39 | 64.66 | 65.28 | 22600.0 |
| 2007-03-30 | ADRE | ETF | 39.72 | 39.7699 | 39.19 | 39.41 | 190745.0 |
| 2007-03-30 | AGG | ETF | 100.42 | 100.43 | 100.07 | 100.26 | 435200.0 |
| 2007-03-30 | AIQ | ETF | 43.1 | 44.65 | 42.65 | 43.65 | 45000.0 |
| 2007-03-30 | AIS | ETF | 1.2 | 1.34 | 1.2 | 1.29 | 815200.0 |
| 2007-03-30 | ARB | ETF | 46.85 | 46.95 | 46.46 | 46.95 | 140900.0 |
| 2007-03-30 | BAB | ETF | 96.4 | 96.65 | 95.88 | 96.52 | 49100.0 |
| 2007-03-30 | BBH | ETF | 58.55 | 58.9133 | 58.33 | 58.6667 | 1095900.0 |
| 2007-03-30 | BITS | ETF | 31.8 | 32.52 | 31.6 | 32.28 | 10258.0 |
| 2007-03-30 | BNE | ETF | 15.62 | 15.73 | 15.51 | 15.73 | 243700.0 |
| 2007-03-30 | BRF | ETF | 14.51 | 14.51 | 14.5 | 14.5 | 7100.0 |
| 2007-03-30 | BTF | ETF | 108.1 | 108.55 | 108.1 | 108.55 | 480.0 |
| 2007-03-30 | CBON | ETF | 30.75 | 30.96 | 30.56 | 30.75 | 68694.0 |
| 2007-03-30 | CDL | ETF | 9.49 | 9.57 | 9.4 | 9.51 | 252800.0 |
| 2007-03-30 | CEF | ETF | 9.48 | 9.49 | 9.39 | 9.4 | 198600.0 |
| 2007-03-30 | CGO | ETF | 17.15 | 17.19 | 17.09 | 17.14 | 9700.0 |
| 2007-03-30 | CHB | ETF | 8.9 | 9.01 | 8.71 | 8.8 | 1453600.0 |
| 2007-03-30 | CHI | ETF | 20.18 | 20.26 | 20.14 | 20.24 | 46000.0 |
| 2007-03-30 | CHIC | ETF | 28.74 | 29.4 | 28.66 | 28.87 | 312703.0 |
| 2007-03-30 | CHY | ETF | 16.95 | 17.04 | 16.91 | 16.94 | 78400.0 |
| 2007-03-30 | CN | ETF | 51.76 | 52.35 | 51.69 | 52.26 | 101600.0 |
| 2007-03-30 | CNXT | ETF | 1.64 | 1.67 | 1.61 | 1.65 | 6724509.0 |
| 2007-03-30 | CPI | ETF | 22.32 | 22.32 | 21.81 | 21.97 | 1600.0 |
| 2007-03-30 | CPST | ETF | 1.06 | 1.07 | 1.02 | 1.06 | 2797712.0 |
| 2007-03-30 | CSA | ETF | 20.75 | 21.15 | 20.75 | 21.07 | 54500.0 |
| 2007-03-30 | CSB | ETF | 32.86 | 33.12 | 32.75 | 33.05 | 12100.0 |
| 2007-03-30 | CSD | ETF | 27.35 | 27.35 | 27.14 | 27.32 | 12300.0 |
| 2007-03-30 | CSQ | ETF | 15.09 | 15.14 | 15.04 | 15.1 | 224900.0 |
| 2007-03-30 | CTEC | ETF | 86.19999999999999 | 87.65 | 83.6 | 86.19999999999999 | 21511.4 |
| 2007-03-30 | CVY | ETF | 26.72 | 26.72 | 26.4 | 26.51 | 25100.0 |
| 2007-03-30 | CWI | ETF | 25.3933 | 25.52 | 25.3933 | 25.42 | 8550.0 |
| 2007-03-30 | DBA | ETF | 26.03 | 26.08 | 24.9 | 25.19 | 692200.0 |
| 2007-03-30 | DBB | ETF | 25.2 | 25.2 | 24.77 | 24.82 | 43800.0 |
| 2007-03-30 | DBC | ETF | 25.7 | 25.7 | 25.3 | 25.3776 | 171000.0 |
| 2007-03-30 | DBE | ETF | 27.69 | 28.07 | 27.59 | 27.67 | 106800.0 |
| 2007-03-30 | DBO | ETF | 27.14 | 27.5 | 27.04 | 27.15 | 15200.0 |
| 2007-03-30 | DBP | ETF | 26.22 | 26.35 | 26.15 | 26.21 | 20100.0 |
| 2007-03-30 | DBS | ETF | 26.25 | 26.62 | 26.19 | 26.41 | 7900.0 |
| 2007-03-30 | DBV | ETF | 26.96 | 27.04 | 26.88 | 26.97 | 110800.0 |
| 2007-03-30 | DDM | ETF | 6.6858 | 6.7542 | 6.5783 | 6.7 | 1100400.0 |
| 2007-03-30 | DEF | ETF | 25.9 | 26.03 | 25.73 | 25.89 | 5300.0 |
| 2007-03-30 | DES | ETF | 19.09 | 19.21 | 18.7233 | 19.0867 | 138600.0 |
| 2007-03-30 | DEW | ETF | 63.09 | 63.56 | 63.09 | 63.41 | 51300.0 |
| 2007-03-30 | DFE | ETF | 69.72 | 70.39 | 69.69 | 70.39 | 47100.0 |
> showing 50 of 439 rows — these rows as CSV