PREVIEW / etf_daily / 2005-03-09
file: by_date/etf_daily/2005/2005-03-09.parquet size: 14 KB rows: 258
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-09 | SPY | ETF | 121.97 | 122.29 | 120.96 | 120.97 | 73263600.0 |
| 2005-03-09 | QQQ | ETF | 37.67 | 37.93 | 37.47 | 37.57 | 98090870.0 |
| 2005-03-09 | IWM | ETF | 63.435 | 63.57 | 62.855 | 62.855 | 22694800.0 |
| 2005-03-09 | DIA | ETF | 108.83 | 109.23 | 108.0 | 108.01 | 5060900.0 |
| 2005-03-09 | GLD | ETF | 43.95 | 44.2 | 43.92 | 44.02 | 3025000.0 |
| 2005-03-09 | TLT | ETF | 89.18 | 89.4 | 88.44 | 88.54 | 2549600.0 |
| 2005-03-09 | AAA | ETF | 62.5 | 62.5 | 62.01 | 62.19 | 4100.0 |
| 2005-03-09 | ADRE | ETF | 90.25 | 94.0 | 90.11 | 90.29 | 12424.0 |
| 2005-03-09 | AFK | ETF | 26.2 | 26.25 | 26.14 | 26.14 | 22600.0 |
| 2005-03-09 | AGG | ETF | 101.66 | 101.69 | 101.19 | 101.28 | 110600.0 |
| 2005-03-09 | AIQ | ETF | 56.15 | 56.65 | 55.0 | 55.85 | 15660.0 |
| 2005-03-09 | ARB | ETF | 39.9 | 40.07 | 39.7 | 39.78 | 194800.0 |
| 2005-03-09 | BAB | ETF | 53.83 | 54.1 | 53.45 | 53.51 | 37400.0 |
| 2005-03-09 | BBH | ETF | 45.0267 | 45.1667 | 44.6467 | 44.8 | 2776800.0 |
| 2005-03-09 | BCM | ETF | 59.5 | 60.0 | 59.46 | 59.78 | 26900.0 |
| 2005-03-09 | BIS | ETF | 752.0 | 752.0 | 696.0 | 729.6 | 117.5 |
| 2005-03-09 | BITS | ETF | 10.64 | 15.56 | 10.6 | 14.48 | 344641.0 |
| 2005-03-09 | BKF | ETF | 42.75 | 42.9 | 42.69 | 42.81 | 16200.0 |
| 2005-03-09 | BNE | ETF | 15.64 | 15.65 | 15.41 | 15.48 | 306800.0 |
| 2005-03-09 | BRF | ETF | 15.75 | 15.8 | 15.75 | 15.75 | 8800.0 |
| 2005-03-09 | BTF | ETF | 91.14999999999999 | 91.25 | 90.89999999999999 | 91.25 | 2460.0 |
| 2005-03-09 | CBON | ETF | 27.0 | 27.083 | 26.75 | 26.75 | 59358.0 |
| 2005-03-09 | CDC | ETF | 10.4 | 10.4 | 10.3 | 10.32 | 3100.0 |
| 2005-03-09 | CDL | ETF | 14.55 | 14.57 | 14.39 | 14.42 | 502900.0 |
| 2005-03-09 | CEF | ETF | 5.7 | 5.8 | 5.69 | 5.74 | 778800.0 |
| 2005-03-09 | CEW | ETF | 26.67 | 26.67 | 26.63 | 26.63 | 1100.0 |
| 2005-03-09 | CHB | ETF | 10.68 | 10.7 | 10.49 | 10.54 | 593500.0 |
| 2005-03-09 | CHIC | ETF | 11.96 | 12.63 | 11.96 | 12.49 | 353389.0 |
| 2005-03-09 | CHIR | ETF | 37.4799 | 37.7301 | 36.9399 | 37.17 | 2212856.0 |
| 2005-03-09 | CID | ETF | 9.49 | 9.49 | 9.49 | 9.49 | 1000.0 |
| 2005-03-09 | CIL | ETF | 26.36 | 26.59 | 26.31 | 26.31 | 8400.0 |
| 2005-03-09 | CN | ETF | 27.75 | 27.94 | 27.7 | 27.74 | 15000.0 |
| 2005-03-09 | CNXT | ETF | 1.66 | 1.67 | 1.6 | 1.62 | 6534042.0 |
| 2005-03-09 | CPI | ETF | 18.5 | 18.5 | 18.5 | 18.5 | 100.0 |
| 2005-03-09 | CSB | ETF | 34.66 | 34.72 | 34.47 | 34.59 | 9300.0 |
| 2005-03-09 | CSM | ETF | 2.3775 | 2.3775 | 2.3775 | 2.3775 | 4800.0 |
| 2005-03-09 | CTEC | ETF | 53.699999999999996 | 54.15 | 50.849999999999994 | 52.15 | 22644.4 |
| 2005-03-09 | CURE | ETF | 0.4512 | 0.4562 | 0.4387 | 0.445 | 1682344.0 |
| 2005-03-09 | CYA | ETF | 211.0 | 211.0 | 206.0 | 206.0 | 325.0 |
| 2005-03-09 | CYB | ETF | 3.67 | 3.67 | 3.67 | 3.67 | 500.0 |
| 2005-03-09 | CZA | ETF | 10.47 | 10.47 | 10.39 | 10.47 | 5600.0 |
| 2005-03-09 | DGT | ETF | 65.94 | 65.97 | 65.42 | 65.42 | 3500.0 |
| 2005-03-09 | DIG | ETF | 13.2125 | 13.225 | 13.125 | 13.1375 | 2240.0 |
| 2005-03-09 | DIV | ETF | 14.05 | 14.08 | 13.8 | 13.89 | 41800.0 |
| 2005-03-09 | DJP | ETF | 27.05 | 27.05 | 27.04 | 27.04 | 1500.0 |
| 2005-03-09 | DRIV | ETF | 29.87 | 30.18 | 29.21 | 29.43 | 745315.0 |
| 2005-03-09 | DSI | ETF | 6.05 | 6.05 | 6.05 | 6.05 | 2000.0 |
| 2005-03-09 | DUSA | ETF | 11.4 | 11.7 | 11.31 | 11.44 | 57163.0 |
| 2005-03-09 | DVY | ETF | 62.01 | 62.09 | 61.36 | 61.45 | 415800.0 |
| 2005-03-09 | EDEN | ETF | 0.78 | 0.8 | 0.76 | 0.8 | 8050.0 |
> showing 50 of 258 rows — these rows as CSV