PREVIEW / etf_daily / 2005-03-14
file: by_date/etf_daily/2005/2005-03-14.parquet size: 15 KB rows: 267
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-03-14 | SPY | ETF | 120.61 | 121.16 | 120.28 | 121.14 | 36336400.0 |
| 2005-03-14 | QQQ | ETF | 37.24 | 37.36 | 37.0305 | 37.34 | 71602364.0 |
| 2005-03-14 | IWM | ETF | 62.73 | 63.01 | 62.435 | 63.01 | 14980800.0 |
| 2005-03-14 | DIA | ETF | 107.95 | 108.16 | 107.58 | 108.14 | 3474500.0 |
| 2005-03-14 | GLD | ETF | 44.26 | 44.26 | 43.95 | 44.03 | 866600.0 |
| 2005-03-14 | TLT | ETF | 88.37 | 89.0 | 88.3 | 88.96 | 805000.0 |
| 2005-03-14 | AAA | ETF | 62.6 | 62.67 | 62.33 | 62.46 | 1600.0 |
| 2005-03-14 | ADRE | ETF | 91.95 | 91.95 | 88.28 | 88.51 | 11892.0 |
| 2005-03-14 | AFK | ETF | 25.73 | 25.742 | 25.57 | 25.57 | 9500.0 |
| 2005-03-14 | AGG | ETF | 101.15 | 101.25 | 100.93 | 101.2 | 129900.0 |
| 2005-03-14 | AIQ | ETF | 53.15 | 54.15 | 52.0 | 53.5 | 17840.0 |
| 2005-03-14 | ARB | ETF | 39.2 | 40.54 | 39.2 | 40.42 | 287800.0 |
| 2005-03-14 | BAB | ETF | 52.84 | 52.94 | 52.42 | 52.93 | 13000.0 |
| 2005-03-14 | BBH | ETF | 43.8933 | 47.8467 | 43.8333 | 47.5833 | 8427900.0 |
| 2005-03-14 | BCM | ETF | 59.47 | 59.95 | 59.47 | 59.88 | 13200.0 |
| 2005-03-14 | BIS | ETF | 664.0 | 694.4 | 656.0 | 688.0 | 88.0 |
| 2005-03-14 | BITS | ETF | 13.84 | 14.16 | 12.88 | 13.556 | 15568.0 |
| 2005-03-14 | BKF | ETF | 41.7 | 41.77 | 41.0 | 41.27 | 13500.0 |
| 2005-03-14 | BNE | ETF | 15.35 | 15.54 | 15.31 | 15.42 | 140000.0 |
| 2005-03-14 | BOSS | ETF | 23.51 | 24.5 | 23.51 | 24.5 | 200.0 |
| 2005-03-14 | BRF | ETF | 15.72 | 15.72 | 15.63 | 15.63 | 9400.0 |
| 2005-03-14 | BTF | ETF | 91.25 | 91.25 | 91.19999999999999 | 91.25 | 100.0 |
| 2005-03-14 | CBON | ETF | 26.65 | 26.7 | 26.65 | 26.65 | 13190.0 |
| 2005-03-14 | CDC | ETF | 8.51 | 8.75 | 8.51 | 8.75 | 2400.0 |
| 2005-03-14 | CDL | ETF | 14.3 | 14.48 | 14.21 | 14.23 | 260000.0 |
| 2005-03-14 | CEF | ETF | 5.76 | 5.76 | 5.61 | 5.71 | 161700.0 |
| 2005-03-14 | CEW | ETF | 26.7 | 26.7 | 26.7 | 26.7 | 300.0 |
| 2005-03-14 | CGW | ETF | 29.65 | 30.06 | 29.65 | 29.99 | 800.0 |
| 2005-03-14 | CHB | ETF | 10.16 | 10.29 | 10.0 | 10.03 | 307900.0 |
| 2005-03-14 | CHIC | ETF | 12.01 | 12.32 | 12.01 | 12.3 | 266494.0 |
| 2005-03-14 | CHIR | ETF | 36.5001 | 37.44 | 36.4899 | 37.3401 | 1402100.0 |
| 2005-03-14 | CID | ETF | 9.35 | 9.37 | 9.35 | 9.37 | 9000.0 |
| 2005-03-14 | CIZ | ETF | 21.4 | 21.4 | 21.4 | 21.4 | 200.0 |
| 2005-03-14 | CN | ETF | 28.55 | 28.55 | 28.32 | 28.49 | 13900.0 |
| 2005-03-14 | CNXT | ETF | 1.61 | 1.64 | 1.59 | 1.62 | 3802171.0 |
| 2005-03-14 | CPI | ETF | 18.3 | 18.3 | 18.1 | 18.1 | 300.0 |
| 2005-03-14 | CSB | ETF | 34.59 | 34.6 | 34.38 | 34.47 | 2300.0 |
| 2005-03-14 | CSM | ETF | 2.3775 | 2.3775 | 2.375 | 2.375 | 17200.0 |
| 2005-03-14 | CTEC | ETF | 48.25 | 52.8 | 48.25 | 49.0 | 23141.2 |
| 2005-03-14 | CURE | ETF | 0.4437 | 0.4437 | 0.415 | 0.4175 | 1334936.0 |
| 2005-03-14 | CYA | ETF | 182.0 | 182.0 | 175.0 | 178.8 | 595.0 |
| 2005-03-14 | CYB | ETF | 3.4 | 3.45 | 3.3 | 3.4 | 37000.0 |
| 2005-03-14 | CZA | ETF | 10.38 | 10.5 | 10.38 | 10.5 | 2100.0 |
| 2005-03-14 | DGT | ETF | 65.28 | 65.28 | 65.16 | 65.18 | 1700.0 |
| 2005-03-14 | DIG | ETF | 13.125 | 13.125 | 13.0125 | 13.0125 | 10000.0 |
| 2005-03-14 | DIV | ETF | 13.58 | 13.65 | 13.52 | 13.57 | 23600.0 |
| 2005-03-14 | DJP | ETF | 27.04 | 27.04 | 27.04 | 27.04 | 500.0 |
| 2005-03-14 | DRIV | ETF | 30.11 | 30.7 | 29.74 | 30.425 | 1349648.0 |
| 2005-03-14 | DSI | ETF | 6.02 | 6.065 | 6.02 | 6.03 | 5600.0 |
| 2005-03-14 | DUSA | ETF | 11.71 | 11.71 | 10.8 | 10.95 | 181160.0 |
> showing 50 of 267 rows — these rows as CSV