PREVIEW / etf_daily / 2005-02-09
file: by_date/etf_daily/2005/2005-02-09.parquet size: 14 KB rows: 253
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-02-09 | SPY | ETF | 120.42 | 120.49 | 119.25 | 119.31 | 55279400.0 |
| 2005-02-09 | QQQ | ETF | 37.77 | 37.8 | 37.065 | 37.11 | 93432520.0 |
| 2005-02-09 | IWM | ETF | 63.74 | 63.75 | 62.175 | 62.175 | 27444000.0 |
| 2005-02-09 | DIA | ETF | 107.42 | 107.48 | 106.63 | 106.74 | 7444900.0 |
| 2005-02-09 | GLD | ETF | 41.03 | 41.36 | 41.02 | 41.31 | 3477900.0 |
| 2005-02-09 | TLT | ETF | 93.44 | 94.24 | 93.38 | 94.12 | 2125800.0 |
| 2005-02-09 | AAA | ETF | 58.72 | 60.0 | 58.72 | 59.7 | 36100.0 |
| 2005-02-09 | ADRE | ETF | 87.0 | 87.0 | 85.6 | 85.619 | 4376.0 |
| 2005-02-09 | AFK | ETF | 26.33 | 26.37 | 26.28 | 26.29 | 15700.0 |
| 2005-02-09 | AGG | ETF | 103.24 | 103.5 | 103.1 | 103.44 | 90600.0 |
| 2005-02-09 | AIQ | ETF | 63.85 | 64.1 | 61.05 | 61.5 | 45000.0 |
| 2005-02-09 | ARB | ETF | 41.6 | 41.8 | 40.61 | 40.72 | 133100.0 |
| 2005-02-09 | BAB | ETF | 51.17 | 51.29 | 50.91 | 51.11 | 29500.0 |
| 2005-02-09 | BBH | ETF | 48.2833 | 48.3167 | 47.2 | 47.29 | 2346000.0 |
| 2005-02-09 | BCM | ETF | 55.4 | 56.04 | 55.36 | 55.95 | 18100.0 |
| 2005-02-09 | BIS | ETF | 960.0 | 960.0 | 944.0 | 944.0 | 46.9 |
| 2005-02-09 | BITS | ETF | 9.6 | 9.6 | 9.0 | 9.28 | 6175.0 |
| 2005-02-09 | BKF | ETF | 39.85 | 39.85 | 39.58 | 39.58 | 20500.0 |
| 2005-02-09 | BNE | ETF | 15.28 | 15.49 | 15.24 | 15.26 | 282500.0 |
| 2005-02-09 | BOSS | ETF | 24.42 | 25.0 | 24.42 | 25.0 | 100.0 |
| 2005-02-09 | BRF | ETF | 15.8 | 15.82 | 15.75 | 15.82 | 8000.0 |
| 2005-02-09 | BTF | ETF | 91.8 | 91.8 | 90.85000000000001 | 91.4 | 2520.0 |
| 2005-02-09 | CBON | ETF | 27.9 | 27.9 | 27.2 | 27.38 | 22731.0 |
| 2005-02-09 | CDC | ETF | 11.15 | 11.15 | 10.75 | 10.75 | 2400.0 |
| 2005-02-09 | CDL | ETF | 14.08 | 14.43 | 14.01 | 14.3 | 511500.0 |
| 2005-02-09 | CEF | ETF | 5.21 | 5.24 | 5.16 | 5.21 | 171300.0 |
| 2005-02-09 | CEW | ETF | 27.54 | 27.54 | 27.54 | 27.54 | 400.0 |
| 2005-02-09 | CGW | ETF | 28.66 | 28.8 | 28.66 | 28.8 | 10200.0 |
| 2005-02-09 | CHB | ETF | 11.05 | 11.19 | 10.83 | 10.83 | 336400.0 |
| 2005-02-09 | CHIC | ETF | 11.05 | 11.29 | 10.77 | 10.955 | 392039.0 |
| 2005-02-09 | CHIR | ETF | 33.7701 | 33.9321 | 33.3699 | 33.4101 | 1212867.0 |
| 2005-02-09 | CID | ETF | 9.77 | 9.89 | 9.66 | 9.7 | 68400.0 |
| 2005-02-09 | CN | ETF | 31.15 | 31.45 | 31.15 | 31.25 | 23200.0 |
| 2005-02-09 | CNXT | ETF | 1.69 | 1.71 | 1.61 | 1.62 | 4544050.0 |
| 2005-02-09 | CSB | ETF | 33.14 | 33.53 | 33.14 | 33.5 | 96200.0 |
| 2005-02-09 | CSM | ETF | 2.3775 | 2.3775 | 2.3775 | 2.3775 | 9200.0 |
| 2005-02-09 | CTEC | ETF | 63.6 | 63.8 | 55.99999999999999 | 58.4 | 57691.200000000004 |
| 2005-02-09 | CURE | ETF | 0.6175 | 0.6175 | 0.6 | 0.6012 | 760976.0 |
| 2005-02-09 | CYA | ETF | 224.0 | 224.0 | 218.0 | 218.0 | 155.0 |
| 2005-02-09 | CYB | ETF | 4.28 | 4.28 | 3.72 | 3.9 | 31400.0 |
| 2005-02-09 | CZA | ETF | 10.4 | 10.4 | 10.4 | 10.4 | 4600.0 |
| 2005-02-09 | DGT | ETF | 64.32 | 64.32 | 63.9 | 63.9 | 7400.0 |
| 2005-02-09 | DIG | ETF | 11.5 | 11.525 | 11.5 | 11.525 | 880.0 |
| 2005-02-09 | DIV | ETF | 14.36 | 14.37 | 14.31 | 14.33 | 16600.0 |
| 2005-02-09 | DJP | ETF | 26.93 | 26.93 | 26.93 | 26.93 | 100.0 |
| 2005-02-09 | DRIV | ETF | 34.4 | 34.65 | 32.36 | 32.6 | 2198350.0 |
| 2005-02-09 | DSI | ETF | 6.03 | 6.03 | 6.03 | 6.03 | 1000.0 |
| 2005-02-09 | DUSA | ETF | 14.18 | 14.35 | 13.97 | 14.0 | 51733.0 |
| 2005-02-09 | DVY | ETF | 60.9 | 60.93 | 60.35 | 60.41 | 535900.0 |
| 2005-02-09 | EDEN | ETF | 1.07 | 1.07 | 0.95 | 1.0 | 110735.0 |
> showing 50 of 253 rows — these rows as CSV