PREVIEW / etf_daily / 2008-03-13
file: by_date/etf_daily/2008/2008-03-13.parquet size: 26 KB rows: 576
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 |
|---|---|---|---|---|---|---|---|
| 2008-03-13 | SPY | ETF | 129.61 | 132.64 | 128.6 | 131.65 | 351504200.0 |
| 2008-03-13 | QQQ | ETF | 42.21 | 43.33 | 41.81 | 43.04 | 208991739.0 |
| 2008-03-13 | IWM | ETF | 65.88 | 67.98 | 65.2 | 67.85 | 123504200.0 |
| 2008-03-13 | DIA | ETF | 119.82 | 122.37 | 118.97 | 121.51 | 24138600.0 |
| 2008-03-13 | GLD | ETF | 98.5 | 98.73 | 97.73 | 98.34 | 14681500.0 |
| 2008-03-13 | TLT | ETF | 95.03 | 95.19 | 93.26 | 93.84 | 5763500.0 |
| 2008-03-13 | ADRE | ETF | 49.28 | 50.48 | 48.5 | 50.27 | 721900.0 |
| 2008-03-13 | AGG | ETF | 102.35 | 102.52 | 101.72 | 102.12 | 417500.0 |
| 2008-03-13 | AIA | ETF | 41.5 | 41.71 | 40.85 | 41.71 | 74000.0 |
| 2008-03-13 | AIQ | ETF | 44.15 | 45.3 | 43.3 | 44.75 | 45600.0 |
| 2008-03-13 | AIS | ETF | 1.0 | 1.01 | 0.93 | 1.01 | 133000.0 |
| 2008-03-13 | AIVI | ETF | 62.08 | 63.09 | 61.49 | 62.91 | 61200.0 |
| 2008-03-13 | ARB | ETF | 42.76 | 44.05 | 42.7 | 43.85 | 301300.0 |
| 2008-03-13 | BBH | ETF | 56.4667 | 58.6 | 56.4667 | 58.2167 | 525600.0 |
| 2008-03-13 | BIL | ETF | 91.76 | 91.76 | 91.7 | 91.74 | 41300.0 |
| 2008-03-13 | BITS | ETF | 20.0 | 20.2 | 19.4 | 20.12 | 13871.0 |
| 2008-03-13 | BIV | ETF | 79.09 | 79.15 | 78.32 | 78.5 | 47500.0 |
| 2008-03-13 | BJK | ETF | 39.45 | 39.73 | 39.35 | 39.46 | 1200.0 |
| 2008-03-13 | BKF | ETF | 50.13 | 51.06 | 49.28 | 50.81 | 42600.0 |
| 2008-03-13 | BLV | ETF | 76.8 | 76.8 | 75.5 | 76.25 | 12900.0 |
| 2008-03-13 | BMVP | ETF | 15.1733 | 15.5366 | 15.0033 | 15.4767 | 62900.0 |
| 2008-03-13 | BND | ETF | 77.18 | 77.43 | 76.84 | 77.08 | 207000.0 |
| 2008-03-13 | BNE | ETF | 13.47 | 15.42 | 13.37 | 14.93 | 640200.0 |
| 2008-03-13 | BRF | ETF | 14.63 | 14.6301 | 14.61 | 14.61 | 10399.0 |
| 2008-03-13 | BSV | ETF | 78.94 | 78.98 | 78.59 | 78.75 | 37500.0 |
| 2008-03-13 | BTF | ETF | 100.0 | 101.05 | 99.1 | 100.99999999999999 | 7300.0 |
| 2008-03-13 | BWX | ETF | 28.93 | 28.9449 | 28.78 | 28.86 | 726086.0 |
| 2008-03-13 | CBON | ETF | 11.25 | 12.3 | 11.0901 | 11.96 | 156631.0 |
| 2008-03-13 | CDL | ETF | 1.85 | 1.87 | 1.57 | 1.65 | 2509953.0 |
| 2008-03-13 | CEF | ETF | 14.18 | 14.36 | 14.12 | 14.35 | 1143800.0 |
| 2008-03-13 | CGO | ETF | 16.4 | 16.4 | 15.28 | 15.99 | 43700.0 |
| 2008-03-13 | CGW | ETF | 23.31 | 24.05 | 23.21 | 24.05 | 67300.0 |
| 2008-03-13 | CHB | ETF | 8.4 | 9.23 | 8.2399 | 9.11 | 1901465.0 |
| 2008-03-13 | CHI | ETF | 13.52 | 13.94 | 13.4 | 13.86 | 133803.0 |
| 2008-03-13 | CHIC | ETF | 19.33 | 20.05 | 19.29 | 19.94 | 789929.0 |
| 2008-03-13 | CHW | ETF | 10.89 | 10.95 | 10.56 | 10.9 | 122509.0 |
| 2008-03-13 | CHY | ETF | 12.2 | 12.68 | 12.17 | 12.61 | 191935.0 |
| 2008-03-13 | CMF | ETF | 52.75 | 54.15 | 51.35 | 51.43 | 18200.0 |
| 2008-03-13 | CN | ETF | 57.4 | 58.82 | 56.29 | 58.12 | 555523.0 |
| 2008-03-13 | CNXT | ETF | 0.43 | 0.44 | 0.42 | 0.44 | 1424175.0 |
| 2008-03-13 | COW | ETF | 42.88 | 42.88 | 42.2 | 42.33 | 26800.0 |
| 2008-03-13 | CPST | ETF | 2.01 | 2.05 | 1.93 | 2.05 | 2395469.0 |
| 2008-03-13 | CSA | ETF | 15.05 | 15.25 | 14.94 | 14.98 | 138300.0 |
| 2008-03-13 | CSD | ETF | 22.14 | 22.76 | 22.0 | 22.62 | 84100.0 |
| 2008-03-13 | CSQ | ETF | 11.39 | 11.66 | 11.37 | 11.54 | 423421.0 |
| 2008-03-13 | CUT | ETF | 21.37 | 21.37 | 20.0 | 21.0 | 22100.0 |
| 2008-03-13 | CVY | ETF | 21.78 | 22.18 | 21.64 | 22.15 | 18300.0 |
| 2008-03-13 | CWI | ETF | 24.7 | 25.3733 | 24.58 | 25.32 | 424350.0 |
| 2008-03-13 | DBA | ETF | 42.39 | 42.91 | 42.05 | 42.5 | 2893900.0 |
| 2008-03-13 | DBB | ETF | 27.02 | 27.02 | 26.45 | 26.63 | 101900.0 |
> showing 50 of 576 rows — these rows as CSV