PREVIEW / etf_daily / 2005-08-10
file: by_date/etf_daily/2005/2005-08-10.parquet size: 15 KB rows: 280
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-08-10 | SPY | ETF | 123.82 | 124.5 | 122.82 | 123.33 | 72863700.0 |
| 2005-08-10 | QQQ | ETF | 39.55 | 39.685 | 38.97 | 39.11 | 104471008.0 |
| 2005-08-10 | IWM | ETF | 66.04 | 66.6 | 64.87 | 65.75 | 27119700.0 |
| 2005-08-10 | DIA | ETF | 106.73 | 107.33 | 105.79 | 106.24 | 8485100.0 |
| 2005-08-10 | GLD | ETF | 43.5 | 43.66 | 43.45 | 43.65 | 695500.0 |
| 2005-08-10 | TLT | ETF | 92.01 | 92.1 | 91.54 | 91.73 | 909300.0 |
| 2005-08-10 | AAA | ETF | 57.11 | 57.11 | 56.9 | 56.99 | 28400.0 |
| 2005-08-10 | ADRE | ETF | 101.19 | 102.28 | 101.19 | 101.702 | 10900.0 |
| 2005-08-10 | AFK | ETF | 25.62 | 25.69 | 25.62 | 25.67 | 7500.0 |
| 2005-08-10 | AGG | ETF | 101.41 | 101.43 | 101.15 | 101.27 | 128400.0 |
| 2005-08-10 | AIQ | ETF | 46.25 | 46.7 | 45.55 | 46.65 | 35400.0 |
| 2005-08-10 | AIS | ETF | 0.97 | 0.97 | 0.92 | 0.95 | 105400.0 |
| 2005-08-10 | ARB | ETF | 41.5 | 41.88 | 41.17 | 41.43 | 388700.0 |
| 2005-08-10 | BAB | ETF | 52.63 | 53.21 | 52.63 | 52.84 | 65800.0 |
| 2005-08-10 | BBH | ETF | 63.2567 | 63.2833 | 62.3867 | 62.6833 | 1383900.0 |
| 2005-08-10 | BCM | ETF | 58.62 | 59.82 | 58.62 | 59.34 | 42900.0 |
| 2005-08-10 | BIS | ETF | 726.4 | 726.4 | 689.6 | 689.6 | 7.5 |
| 2005-08-10 | BITS | ETF | 15.6 | 15.6 | 12.8 | 13.0 | 20543.0 |
| 2005-08-10 | BKF | ETF | 32.91 | 33.11 | 32.75 | 32.79 | 16600.0 |
| 2005-08-10 | BNE | ETF | 13.75 | 13.92 | 13.72 | 13.74 | 248800.0 |
| 2005-08-10 | BRF | ETF | 15.41 | 15.48 | 15.36 | 15.41 | 16200.0 |
| 2005-08-10 | BTF | ETF | 85.8 | 86.14999999999999 | 85.8 | 85.89999999999999 | 1500.0 |
| 2005-08-10 | CBON | ETF | 32.54 | 32.95 | 32.17 | 32.79 | 23448.0 |
| 2005-08-10 | CDC | ETF | 3.56 | 4.0 | 3.56 | 3.9 | 13600.0 |
| 2005-08-10 | CDL | ETF | 13.3 | 13.47 | 13.27 | 13.38 | 407800.0 |
| 2005-08-10 | CEF | ETF | 5.31 | 5.34 | 5.28 | 5.29 | 266500.0 |
| 2005-08-10 | CEW | ETF | 26.7 | 26.7 | 26.7 | 26.7 | 100.0 |
| 2005-08-10 | CHB | ETF | 12.1 | 12.16 | 11.83 | 12.13 | 597100.0 |
| 2005-08-10 | CHI | ETF | 20.7 | 20.78 | 20.63 | 20.7 | 99700.0 |
| 2005-08-10 | CHIC | ETF | 14.4 | 14.74 | 14.19 | 14.74 | 249390.0 |
| 2005-08-10 | CHIR | ETF | 36.7101 | 37.02 | 36.1401 | 36.2301 | 833696.0 |
| 2005-08-10 | CHY | ETF | 16.61 | 16.73 | 16.58 | 16.68 | 108500.0 |
| 2005-08-10 | CIL | ETF | 25.86 | 25.86 | 25.86 | 25.86 | 1600.0 |
| 2005-08-10 | CIZ | ETF | 23.5 | 23.75 | 23.5 | 23.75 | 5700.0 |
| 2005-08-10 | CN | ETF | 33.6 | 34.79 | 33.6 | 34.67 | 90900.0 |
| 2005-08-10 | CNXT | ETF | 1.79 | 1.83 | 1.71 | 1.72 | 4025387.0 |
| 2005-08-10 | CPI | ETF | 23.4 | 23.42 | 23.4 | 23.42 | 2200.0 |
| 2005-08-10 | CPST | ETF | 2.96 | 3.09 | 2.65 | 3.08 | 4161558.0 |
| 2005-08-10 | CSB | ETF | 31.7 | 31.98 | 31.0 | 31.46 | 19200.0 |
| 2005-08-10 | CSQ | ETF | 14.25 | 14.4 | 14.22 | 14.28 | 340200.0 |
| 2005-08-10 | CTEC | ETF | 56.050000000000004 | 57.0 | 53.89999999999999 | 54.74999999999999 | 15340.2 |
| 2005-08-10 | CURE | ETF | 0.3125 | 0.3275 | 0.2975 | 0.3025 | 9557376.0 |
| 2005-08-10 | CYA | ETF | 70.4 | 82.0 | 70.0 | 77.8 | 1585.0 |
| 2005-08-10 | CYB | ETF | 3.69 | 3.78 | 3.69 | 3.75 | 8700.0 |
| 2005-08-10 | DGT | ETF | 65.5 | 65.67 | 64.97 | 64.97 | 5800.0 |
| 2005-08-10 | DIG | ETF | 12.875 | 13.0 | 12.875 | 13.0 | 4000.0 |
| 2005-08-10 | DIV | ETF | 13.63 | 13.63 | 13.46 | 13.59 | 17900.0 |
| 2005-08-10 | DRIV | ETF | 36.44 | 37.71 | 36.42 | 37.11 | 965172.0 |
| 2005-08-10 | DSI | ETF | 5.83 | 5.83 | 5.79 | 5.825 | 20000.0 |
| 2005-08-10 | DUSA | ETF | 10.56 | 10.9 | 10.56 | 10.9 | 108646.0 |
> showing 50 of 280 rows — these rows as CSV