PREVIEW / etf_daily / 2005-09-01
file: by_date/etf_daily/2005/2005-09-01.parquet size: 15 KB rows: 281
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-09-01 | SPY | ETF | 122.52 | 123.15 | 121.14 | 122.49 | 74578700.0 |
| 2005-09-01 | QQQ | ETF | 38.98 | 39.15 | 38.78 | 38.92 | 74917176.0 |
| 2005-09-01 | IWM | ETF | 66.42 | 66.88 | 66.21 | 66.53 | 21105000.0 |
| 2005-09-01 | DIA | ETF | 104.78 | 105.19 | 104.22 | 104.6 | 7401300.0 |
| 2005-09-01 | GLD | ETF | 43.93 | 44.4 | 43.85 | 44.22 | 2502900.0 |
| 2005-09-01 | TLT | ETF | 95.31 | 95.74 | 94.93 | 95.08 | 1899000.0 |
| 2005-09-01 | AAA | ETF | 57.75 | 58.15 | 57.7 | 58.15 | 2200.0 |
| 2005-09-01 | ADRE | ETF | 100.55 | 101.06 | 99.86 | 100.8 | 7524.0 |
| 2005-09-01 | AFK | ETF | 25.96 | 25.96 | 25.9 | 25.9 | 1300.0 |
| 2005-09-01 | AGG | ETF | 102.54 | 102.81 | 102.38 | 102.65 | 104900.0 |
| 2005-09-01 | AIQ | ETF | 46.0 | 46.6 | 45.05 | 45.5 | 8340.0 |
| 2005-09-01 | AIS | ETF | 0.9 | 0.9 | 0.84 | 0.89 | 267400.0 |
| 2005-09-01 | ARB | ETF | 41.95 | 42.3 | 41.7 | 41.92 | 102200.0 |
| 2005-09-01 | BAB | ETF | 50.89 | 51.16 | 50.66 | 50.92 | 38300.0 |
| 2005-09-01 | BBC | ETF | 6.8 | 6.8 | 6.52 | 6.7 | 22000.0 |
| 2005-09-01 | BBH | ETF | 65.6633 | 66.4367 | 65.51 | 66.1667 | 1731000.0 |
| 2005-09-01 | BCM | ETF | 58.99 | 59.69 | 58.92 | 59.39 | 15700.0 |
| 2005-09-01 | BIS | ETF | 694.4 | 702.4 | 694.4 | 702.4 | 2.5 |
| 2005-09-01 | BITS | ETF | 12.084 | 12.44 | 12.0 | 12.08 | 775.0 |
| 2005-09-01 | BKF | ETF | 32.5 | 32.86 | 32.08 | 32.86 | 20600.0 |
| 2005-09-01 | BNE | ETF | 14.21 | 14.64 | 14.16 | 14.58 | 202600.0 |
| 2005-09-01 | BRF | ETF | 15.57 | 15.59 | 15.57 | 15.59 | 1900.0 |
| 2005-09-01 | BTF | ETF | 85.64999999999999 | 85.64999999999999 | 84.35 | 84.85 | 5060.0 |
| 2005-09-01 | CBON | ETF | 34.42 | 34.75 | 34.1 | 34.7 | 14892.0 |
| 2005-09-01 | CDC | ETF | 3.47 | 3.7 | 3.1 | 3.38 | 41500.0 |
| 2005-09-01 | CDL | ETF | 13.5 | 13.56 | 13.31 | 13.38 | 543500.0 |
| 2005-09-01 | CEF | ETF | 5.3 | 5.4 | 5.29 | 5.4 | 471300.0 |
| 2005-09-01 | CEW | ETF | 26.0 | 26.0 | 25.95 | 25.95 | 200.0 |
| 2005-09-01 | CHB | ETF | 13.8 | 13.9 | 13.45 | 13.5 | 2966700.0 |
| 2005-09-01 | CHI | ETF | 20.15 | 20.35 | 20.15 | 20.35 | 50600.0 |
| 2005-09-01 | CHIC | ETF | 13.74 | 13.7716 | 12.79 | 12.93 | 1345581.0 |
| 2005-09-01 | CHIR | ETF | 43.2399 | 43.4301 | 42.8499 | 42.93 | 30946912.0 |
| 2005-09-01 | CHY | ETF | 16.47 | 16.5891 | 16.42 | 16.57 | 95900.0 |
| 2005-09-01 | CIL | ETF | 25.88 | 25.88 | 25.88 | 25.88 | 1100.0 |
| 2005-09-01 | CN | ETF | 34.01 | 34.01 | 33.71 | 33.99 | 9100.0 |
| 2005-09-01 | CNXT | ETF | 1.71 | 1.8 | 1.61 | 1.64 | 9444759.0 |
| 2005-09-01 | CPI | ETF | 23.6 | 23.6 | 23.6 | 23.6 | 400.0 |
| 2005-09-01 | CPST | ETF | 4.97 | 5.23 | 4.94 | 5.05 | 14915944.0 |
| 2005-09-01 | CSB | ETF | 30.77 | 31.13 | 30.77 | 31.01 | 28700.0 |
| 2005-09-01 | CSM | ETF | 2.4275 | 2.4275 | 2.425 | 2.425 | 2400.0 |
| 2005-09-01 | CSQ | ETF | 14.39 | 14.44 | 14.25 | 14.26 | 299900.0 |
| 2005-09-01 | CTEC | ETF | 50.8 | 52.5 | 50.8 | 51.5 | 5735.6 |
| 2005-09-01 | CURE | ETF | 0.2787 | 0.285 | 0.2662 | 0.28 | 1212552.0 |
| 2005-09-01 | CYA | ETF | 62.0 | 67.0 | 62.0 | 62.2 | 480.0 |
| 2005-09-01 | CYB | ETF | 3.81 | 3.81 | 3.6 | 3.75 | 13500.0 |
| 2005-09-01 | DGT | ETF | 64.67 | 64.96 | 64.63 | 64.75 | 50400.0 |
| 2005-09-01 | DIG | ETF | 13.1125 | 13.45 | 13.1125 | 13.45 | 5520.0 |
| 2005-09-01 | DIV | ETF | 13.6 | 13.65 | 13.5 | 13.61 | 18100.0 |
| 2005-09-01 | DRIV | ETF | 38.0 | 38.77 | 37.75 | 38.18 | 408303.0 |
| 2005-09-01 | DSI | ETF | 5.74 | 5.77 | 5.735 | 5.74 | 15200.0 |
> showing 50 of 281 rows — these rows as CSV