PREVIEW / etf_daily / 2005-01-13
file: by_date/etf_daily/2005/2005-01-13.parquet size: 14 KB rows: 250
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-01-13 | SPY | ETF | 118.64 | 118.73 | 117.5 | 117.62 | 55537500.0 |
| 2005-01-13 | QQQ | ETF | 38.6 | 38.85 | 38.01 | 38.07 | 102117505.0 |
| 2005-01-13 | IWM | ETF | 61.145 | 61.435 | 60.575 | 60.865 | 18940600.0 |
| 2005-01-13 | DIA | ETF | 105.96 | 106.1 | 104.81 | 104.95 | 7669700.0 |
| 2005-01-13 | GLD | ETF | 42.39 | 42.6 | 42.34 | 42.6 | 718300.0 |
| 2005-01-13 | TLT | ETF | 89.75 | 90.18 | 89.73 | 90.18 | 1876700.0 |
| 2005-01-13 | AAA | ETF | 58.68 | 59.13 | 58.46 | 58.52 | 900.0 |
| 2005-01-13 | ADRE | ETF | 80.75 | 80.75 | 79.46 | 79.46 | 3548.0 |
| 2005-01-13 | AFK | ETF | 26.56 | 26.65 | 26.56 | 26.58 | 2300.0 |
| 2005-01-13 | AGG | ETF | 102.64 | 102.84 | 102.53 | 102.79 | 62400.0 |
| 2005-01-13 | AIQ | ETF | 69.0 | 69.95 | 65.15 | 67.25 | 77780.0 |
| 2005-01-13 | ARB | ETF | 37.3 | 37.49 | 36.97 | 37.05 | 282000.0 |
| 2005-01-13 | BAB | ETF | 46.7 | 46.8 | 45.73 | 46.12 | 76900.0 |
| 2005-01-13 | BBH | ETF | 49.6667 | 49.6667 | 48.8 | 48.9333 | 2123100.0 |
| 2005-01-13 | BCM | ETF | 58.0 | 58.35 | 58.0 | 58.15 | 46300.0 |
| 2005-01-13 | BITS | ETF | 11.2 | 11.236 | 10.32 | 10.4 | 25127.0 |
| 2005-01-13 | BKF | ETF | 35.05 | 35.12 | 34.9 | 34.93 | 10600.0 |
| 2005-01-13 | BNE | ETF | 15.1 | 15.2 | 15.0 | 15.05 | 187100.0 |
| 2005-01-13 | BRF | ETF | 15.55 | 15.6 | 15.55 | 15.57 | 5500.0 |
| 2005-01-13 | BTF | ETF | 90.0 | 90.0 | 89.45 | 89.94999999999999 | 1880.0 |
| 2005-01-13 | CBON | ETF | 28.893 | 28.893 | 28.11 | 28.3 | 38268.0 |
| 2005-01-13 | CDC | ETF | 10.62 | 10.62 | 10.49 | 10.5 | 7300.0 |
| 2005-01-13 | CDL | ETF | 14.26 | 14.45 | 14.17 | 14.23 | 460300.0 |
| 2005-01-13 | CEF | ETF | 5.35 | 5.4 | 5.31 | 5.39 | 205300.0 |
| 2005-01-13 | CEW | ETF | 27.32 | 27.4 | 27.32 | 27.4 | 500.0 |
| 2005-01-13 | CGW | ETF | 30.0 | 30.0 | 29.7 | 29.7 | 400.0 |
| 2005-01-13 | CHB | ETF | 11.28 | 11.85 | 11.28 | 11.58 | 440100.0 |
| 2005-01-13 | CHIC | ETF | 10.18 | 10.26 | 9.91 | 10.1 | 482241.0 |
| 2005-01-13 | CHIR | ETF | 35.22 | 35.2899 | 34.11 | 34.26 | 2517007.0 |
| 2005-01-13 | CID | ETF | 9.3 | 9.32 | 9.3 | 9.32 | 1300.0 |
| 2005-01-13 | CIL | ETF | 26.3 | 26.4 | 26.3 | 26.4 | 700.0 |
| 2005-01-13 | CIZ | ETF | 20.15 | 20.4 | 20.0 | 20.4 | 1500.0 |
| 2005-01-13 | CN | ETF | 28.2 | 28.45 | 28.18 | 28.39 | 103500.0 |
| 2005-01-13 | CNXT | ETF | 1.639 | 1.6703 | 1.6 | 1.62 | 6709763.0 |
| 2005-01-13 | CPI | ETF | 18.2 | 18.66 | 18.2 | 18.66 | 2500.0 |
| 2005-01-13 | CSB | ETF | 36.0 | 36.15 | 35.88 | 35.88 | 4000.0 |
| 2005-01-13 | CSM | ETF | 2.375 | 2.375 | 2.375 | 2.375 | 800.0 |
| 2005-01-13 | CTEC | ETF | 41.5 | 42.449999999999996 | 41.349999999999994 | 41.8 | 1300.0 |
| 2005-01-13 | CURE | ETF | 0.7425 | 0.7438 | 0.6863 | 0.6887 | 1661920.0 |
| 2005-01-13 | CYA | ETF | 212.0 | 212.0 | 208.0 | 208.0 | 190.0 |
| 2005-01-13 | CYB | ETF | 4.4 | 4.54 | 4.4 | 4.54 | 2800.0 |
| 2005-01-13 | CZA | ETF | 10.45 | 10.45 | 10.45 | 10.45 | 3500.0 |
| 2005-01-13 | DGT | ETF | 63.21 | 63.23 | 62.83 | 62.83 | 2200.0 |
| 2005-01-13 | DIV | ETF | 14.28 | 14.28 | 14.14 | 14.15 | 23600.0 |
| 2005-01-13 | DJP | ETF | 26.64 | 26.65 | 26.64 | 26.65 | 2200.0 |
| 2005-01-13 | DRIV | ETF | 34.2 | 34.9 | 33.36 | 33.56 | 921141.0 |
| 2005-01-13 | DSI | ETF | 5.9 | 5.925 | 5.9 | 5.915 | 18600.0 |
| 2005-01-13 | DTH | ETF | 25.39 | 25.4 | 25.27 | 25.28 | 2500.0 |
| 2005-01-13 | DUSA | ETF | 14.16 | 14.73 | 14.1 | 14.68 | 359305.0 |
| 2005-01-13 | DVY | ETF | 59.5 | 59.56 | 59.01 | 59.15 | 543500.0 |
> showing 50 of 250 rows — these rows as CSV